G
Guenter
Hi,
I have an .asp file which gets called with a parameter representing a
product id:
DisplayProductDetails.asp?productid=<some number>
Then in DisplayProductDetails.asp I am retrieving the parameter by:
<% pid = Request.QueryString ("productid") %>
Now I want to use the value of the 'pid' parameter in the SQL statement I
create with the Database Result Wizard:
Going to "Database Result Properties"->"SQL Server"->"Custom Query"->"Edit"
and adding the query:
SELECT PRODNAME
FROM PRODUCT_RECORD
WHERE (PRODID = :id:
The code generated by Frontpage is:
....
<%
fp_sQry="SELECT PRODNAME FROM RODUCT_RECORD WHERE (PRODID = :id:"
fp_sDefault="pid="
....
%>
....
When I open the DisplayProductDetails.asp in IE it shows the follwoing error:
"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."
Anybody any ideas ?
Thanks !!!
Günter
I have an .asp file which gets called with a parameter representing a
product id:
DisplayProductDetails.asp?productid=<some number>
Then in DisplayProductDetails.asp I am retrieving the parameter by:
<% pid = Request.QueryString ("productid") %>
Now I want to use the value of the 'pid' parameter in the SQL statement I
create with the Database Result Wizard:
Going to "Database Result Properties"->"SQL Server"->"Custom Query"->"Edit"
and adding the query:
SELECT PRODNAME
FROM PRODUCT_RECORD
WHERE (PRODID = :id:
The code generated by Frontpage is:
....
<%
fp_sQry="SELECT PRODNAME FROM RODUCT_RECORD WHERE (PRODID = :id:"
fp_sDefault="pid="
....
%>
....
When I open the DisplayProductDetails.asp in IE it shows the follwoing error:
"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."
Anybody any ideas ?
Thanks !!!
Günter