Here's what I'm trying to do so forgive me it this has been solved before...but I can't find an example in the forums or samples.


I have a DF that should take a querystring value of InvoiceID and based on that value do a SQL lookup using that as a Where clause and return a the column InvoiceTotal. I need to use that InvoiceTotal to later send it on to authorize.net for processing.


Here's what I'm doing:
1. I have a hidden field called InvoiceID and it is set to get the querystring value. I've tested this and I know I can get a good value to that field.

2. I have a read only label field called InvoiceTotal with a SQL Option set to

select InvoiceTotal as DefaultValue from Invoice where InvoiceID = $(InvoiceID)

When I test the form I get the InvoiceID correctly however, the InvoiceTotal displays nothing. Obviously I'm doing something wrong.

Can you suggest the best way to accomplish this? I looked & tried the Initial SQL Binding method but didn't get any different results.

Thanks,

Ralph