Using parameters from one page to populate recordset object in another

[perfessor]

I'm a newcomer to Interdev, so any alternate ways of doing this are appreciated.<br><br>I'm trying to get a parameterized recordset object to work, based on input from another form.<br><br>The method I'm using (probably wrong) is this:<br>The url is <A HREF="

http://page.asp?cust_num=0000200028"

TARGET="_new">

http://page.asp?cust_num=0000200028</A><br><br>I'm

getting the customer number by doing<br>&lt;% <br>custnum = Request.QueryString(&quot;cust_num&quot<br>%&gt;<br>Then I'm setting the parameter tab in my recordset to look at custnum.<br>The error I get is: <br>Error Type:<br>Microsoft JScript runtime (0x800A1391)<br>'cust_num' is undefined<br>/page.asp, line 36<br><br>I think my problem has to do with either the scope of the variable I'm declaring, or with the fact that I'm setting the variable in VBScript, and the recordset object is written in JavaScript.<br><br>Actually, the real problem is that I don't have a clue what I'm doing.&nbsp;&nbsp;:-&gt;<br><br>Any Ideas?<br>Thanks,<br>Rik<br><br><br>

 

[megasuperman]

Hope you have it answered by now but if you dont, I ran into that same problem with that, you have to click sql statement set it to what you want like


SELECT * from Custlist where custnum = ?


then under parametes define the value of ? Request.QueryString(&quot;cust_num&quot