Classic ASP Discussion - separating data

Print Page | Close Window

separating data

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=22594
Printed Date: 29 March 2026 at 12:51am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: separating data

Posted By: MArk_dB
Subject: separating data
Date Posted: 03 February 2007 at 3:33pm

I have an HTML form which passes a number of unique values to an ASP page for display in the form 1,2,3,4, etc.

I want to use the values to append to and sql statement to display records from an MS database.

E.g sql select from ......where id=(single passed value)

My problem is I can't separate the data in the 'data stream'

Any help appreciated, I'm sure its simple but so am I!!!

Replies:

Posted By: Gullanian
Date Posted: 04 February 2007 at 7:41pm

Use the split() command to split the values by the comma seperator.

Loop through each value that is returned in the array and execute the SQL query.