passing session parameters to a DRW generated table

A

Alan

Dear all

I have a session("MemberID") parameter that I want to pass into a SQL
statement to query an underlying database.
I am using the database results wizard but am unable to get the query to
recognise the Session("MemberID") parameter.

I have made the changes to the _fpclass/fpdbrgn1.inc file as recommended
by
http://home.att.net/~codeLibrary/FrontPage/tweaks.htm#Passing Query Values

and tried a variety of parameter insertions using the DWR: eg ::MemberID::,
'::MemberID::', ::session("MemberID")::, '::session("MemberID"):: ', the
above without the :: borders.

I have even tried, but without success, the following:
<%
MemberID = 163
%>
and not relied on the session parameter at all.
But none of these work.

If, however I replace the parameter in the query with a number, say 163,
then it all works wonderfully - but only for MemberID 163!

Any suggestions?

Cheers...Alan
 
Top