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