P
Pierre de Beer
Hi
I am creating a ASP page that displays the "Database Result" from 4 SQL
tables. This works
well if I hard code the query criteria.
The problem is to pass a parameter to the web bot to retrieve the correct
records. I define a variable MyAppId in the form and by calling the variable
I can see that the variable is visible in the form.
I use "Where (AppId = ::MyAppId:
" in the query expression. The web page
returns an error informing me that the value of the parameter can not be
blank. When I define a default value for MyAppId the form retrieves the data
perfectly for the record that is = to the default value. It seems that the
"webbot bot" is executed before the variable is known.
I attempted to define the variable in the <head> tag of the form with the
same result. If you attempt to insert the variable in the FrontPage
component FrontPage informs you that the component has changed and the
changes will be lost when saving the form.
Please help. Is there a way around this?
Kind regard
Pierre
I am creating a ASP page that displays the "Database Result" from 4 SQL
tables. This works
well if I hard code the query criteria.
The problem is to pass a parameter to the web bot to retrieve the correct
records. I define a variable MyAppId in the form and by calling the variable
I can see that the variable is visible in the form.
I use "Where (AppId = ::MyAppId:
" in the query expression. The web pagereturns an error informing me that the value of the parameter can not be
blank. When I define a default value for MyAppId the form retrieves the data
perfectly for the record that is = to the default value. It seems that the
"webbot bot" is executed before the variable is known.
I attempted to define the variable in the <head> tag of the form with the
same result. If you attempt to insert the variable in the FrontPage
component FrontPage informs you that the component has changed and the
changes will be lost when saving the form.
Please help. Is there a way around this?
Kind regard
Pierre