You need to change your hyperlink and maybe your sql. Your link, for example should be:

link.asp?Part=76000-287,76000-333
Note the part numbers are seperated by a comma.

Your SQL should be something like:

"SELECT * FROM table WHERE Part IN (::Part::)"

This will work for multiple Part numbers and a single part number.

Good luck,

Joe

[This message has been edited by jbennett (edited 03-08-2001).]

[This message has been edited by Elecia (edited 03-08-2001).]

I've tried a dozen or more SQL statements and about the same number in hyperlink combinations.

I can't seem to understand the problem.

I've followed all the textbook rules. I don't think the query likes the variables I'm bringing over (more than one variable). I guess I need to dig into ASP and SQL a little more.

I'm feeling a little discouraged, but I can't give up.

Your feedback is totally appreciated!

I have been playing with this a bit. I have it working fine, but then I wondered if it did not work for you because of your field values (example: 76000-333).

I have not been able to get it to work using your values. I am using Access and the fields need to be number fields not text to work. But, to use a number field your values are causing problems. 76000-333 is looking like 76000 minus 333. If you change your field values it will work using the example I have given above.

Since I don't know that much about such things I need to present my disclaimer...

I reserve the right to be an idiot. I reserve the right to not know what I am talking about. I reserve the right to not be showing you the best technique available.

**Whoof**

Joe

Do this instead :

http://testing/query.asp?part1=76000-111&part2=76000-222

"SELECT * FROM floparts WHERE (part = '::part1::') OR (part = '::part2::') "

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!