IIS 5 & IIS 6
How to: Classic ASP - Passing 'multiple' recordset values to another...
Last post May 23, 2011 05:50 PM by PropheC
May 18, 2011 09:01 PM|PropheC|LINK
May 19, 2011 11:57 AM|PropheC|LINK
Interestingly I found this article which explained my suspicion passing recordset values can't be done exclusively :
So I'm now thinking the only way is to pass it as an array
Which works! however now the issue is to load this array into editable regions that can be updated on a SQL Server 2000 backend.
sql server 2000
May 19, 2011 06:06 PM|tomkmvp|LINK
I would like to help but I am having a hard time understanding what you are trying to do. Can you give a specific/detailed example?
May 20, 2011 10:05 AM|PropheC|LINK
Thanks for the gesture. Being a younger .NET centric Web Developer, I have just complete forgot about classic asp and frankly didn't learn it as I came aboard just as ASP.NET and .NET in general was being releases in 1.1.
Anyhow, I am executing a storedprocedure and spitting out an array of IDs (IDNumber)
My problem was... and could still be, that I have to forward this information to another page with these values to be edited later.
My original thought is why not use the querystring to pass these values along and then on the receiving page, extract the values and pupulate a textbox?
However, My issue now is populating a control (textbox) in classic ASP with these values as I am getting a syntax error!
I have done this plenty of times in ASP.NET however with this particular project in classic ASP, I forget the double, single quotes and its truncating to my young eyes.
for i = 1 to Request.QueryString("id").Count
response.Write("<INPUT type=text ID=Text1 NAME=Text1 value= request.querystring("id")(i)" & "/>" & Request.QueryString ("id")(i) & "<br/>")
May 20, 2011 11:11 AM|PropheC|LINK
I found this article that I like and it should help... stay posted!
Forgot that just doing a
<%response.write(request.url.querystring("ID"))%> returns all values and... the textbox's value can be set to this! Progress!
May 20, 2011 01:33 PM|PropheC|LINK
I have a for each statement in vbscript which yields the appropricate count of textboxes but the value is ONLY the first value in the querystring, not all of them....
For each ID in Request.url.querystring(ID)
response.write("<input name=txtbox id=txtbox value=" + Request.querystring(ID) + " />")
May 23, 2011 02:30 AM|Leo Tang - MSFT|LINK
Could you please post the original query string here?
Or how did you build the query string?
May 23, 2011 10:08 AM|tomkmvp|LINK
Request.url.querystring(ID) is a value not an object so the For Each isn't really going to work. What does this data look like? I suspect you can use the Split() function to load the values into an array ...
May 23, 2011 05:50 PM|PropheC|LINK