Hi,
I'm trying to implement an initial SQL Rendering/Bind using a querystring containing an Id in order to populate some read only fields on the form:
Querystring passed : FairId (also tried making it a hidden field reading its value from the querystring).
Passed like this: (url of page containing the Form)/Default.aspx?FairId=114
Fields on the Form: FairName (textbox, read only), FairCity (textbox, read only)
Enable initial SQL data bind (checked)
Only enable when querystring present? (empty)
Initial SQL query:
If I use the following select, it works:
Select FairName, FairCity from FairsAU where FairsAUId = 114
If I try to use the querystring (or a field shortname), it doesn't work:
Select FairName, FairCity from FairsAU where FairsAUId = '$(FairId)'
Also tried
Select FairName, FairCity from FairsAU where FairsAUId = $(FairId)
(without the single quotes)
Any ideas? I guess the question is: how to use a variable in the SQL expression? How are they parsed?
Best regards,
Daniel Salas
ICCI Melb Inc.