JeevesBond — Fri, 19 Jan 2007 02:59:16 +0000

Hi ben, sorry this wasn't answered earlier. Is there a specific problem you're having with this?

The code above seems like it will work. It's not very efficient to do a SQL query for every iteration of that loop though, what would be better is to iterate through the dictionary building a string which will be the WHERE clause in your SQL statement.

Dictionaries are very optimised in ASP (and VB6 too) so are a good choice in this case. You might want to make your loop look a little more like:

For i = 0 To objDict.Count - 1
  myKey = allkeys(i) 

  If i = 0 Then
    sqltext = "Select * from products where product_ID =" & myKey
  Else
    sqltext = sqltext & " or product_ID = " & myKey
  End If 
Next

sqltext = sqltext & ";"

cart.Open sqltext, ORSp
cart.MoveFirst
	
while Not cart.EOF
  response.write(cart("PName")&"<br />")
  cart.movenext
wend

cart.close

Hope this makes sense! It's been a while since I did any ASP programming so please forgive any errors in that code.