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
Hi
 
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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net