General information
Title:
Parameterized Recordset & Grid does not display.
Hi! I'm having a problem displaying my ASP page. It has coding like this:
< %
Dim cCode
cCode = "1221"
% >
DTC Recordset goes here with following query:
Select * from web_tbldisplay where AreaCode = ?
The parameter is set to cCode in the Parameter tab.
DTC Grid goes here with data linked to DTC Recordset.
The page displays blank and when I look at the source in my browser, it shows:
< ! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
< HTML > < HEAD >
< META content="text/html; charset=windows-1252" http-equiv=Content-Type > < / HEAD >
< BODY > < / BODY >< / HTML >
The weird thing is that when I am using SQL builder and run the SQL at the query designer, I am asked the parameter value and input '1200'. The result pane returns the requested rows so it appears to be working fine. What am I doing wrong?
Thanks for any advice you could give.
Ramon
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only