Passing variable to Frontpage SQL query

  • Thread starter Thread starter Emmett Power
  • Start date Start date
E

Emmett Power

Hi Guys,

I have read a lot of postings and articles about this problem but I
still haven't been able to crack it.

I want to populate a table with results from a database dependent upon
the identity of the user - a common enough issue. But I can't seem to
get the user's name to the pass as a valid variable to SQL.

The relevant part of the query as generated by the Wizard and manually
ammended by me (both grey and red text) is as follows:

fp_sQry="SELECT etc WHERE FamilyDetails.FamilyName = '" & varFamily &
"'"

The problem is what occurs after the '=' sign. I have tried a number
of ways of passing the value to the query.

I have got the closest with defining a variable 'VarFamily', defining
it as a cookie value and inserting that into the query.

The problem is that in FP SQL keeps treating the first quotation mark
as the end of the statement to be evaluated rather than taking the
variable and returns an error message.

This variation is accepted but returns no records:

WHERE (FamilyDetails.FamilyName = '& varFamily &' )"

I've tried lots of different ways none of which have worked.

Any suggestions would be most appreciated.

Thanks

Emmett Power
 
Try using the Spooky Diet at www.outfront.net/spooky/
This will allow you to manually change the DRW without any web bot concerns.
I assume that you have requested the value of the variable or given it a
value?
 
Back
Top