Hi there,
I'm currently developing an ASP application which pulls personal data out of a MS-SQL server.
I should start by pointing out that I hate SQL. I don't get it and constantly struggle with it. So any help will be gratefully received.
In my table I have something like:
ID | Name | Group | Email | Phone
131 XXXX XXX XX@XX 12345
132 YYYY YYY YY@XX 67890
etc etc..
In the ASP application, users can select multiple people from a Web List. So, I'll potentially end up with
xxx.asp?userIDs=131,132,134.... ad infinitum.
I COULD get the asp to loop through a series of SELECT * from TABLE where ID = x things and store them in an array, but was wondering how to do it all in one hit. While not knowing how many IDs are going to be passed to the stored procedure?
I've googled about, but without knowing SQL at all well, it's hard to track down a solution...
Thanks,
Craig.
I'm currently developing an ASP application which pulls personal data out of a MS-SQL server.
I should start by pointing out that I hate SQL. I don't get it and constantly struggle with it. So any help will be gratefully received.
In my table I have something like:
ID | Name | Group | Email | Phone
131 XXXX XXX XX@XX 12345
132 YYYY YYY YY@XX 67890
etc etc..
In the ASP application, users can select multiple people from a Web List. So, I'll potentially end up with
xxx.asp?userIDs=131,132,134.... ad infinitum.
I COULD get the asp to loop through a series of SELECT * from TABLE where ID = x things and store them in an array, but was wondering how to do it all in one hit. While not knowing how many IDs are going to be passed to the stored procedure?
I've googled about, but without knowing SQL at all well, it's hard to track down a solution...
Thanks,
Craig.