Another Multiple Question!

[vanillapod]

Okay so i've ust been asked to change a select menu to a multiple select menu... I've put multiple in the <select> tag but now my update sql doesn't work.

I'm guessing because, for example, when the user selects two values from the list the form passes myvalue=abc&myvalue=def... can anyone show me how to get round this?

Cheers

 

[DreXor]

when you request the element the values will be returned comma delimited.. so you'll need to split them out and then apply the values towards your sql statement.

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!

 

[ToddWW]

dim arrayObj
dim arrayValue

arrayObj = Split(Request.Form("myvalue"))

FOR EACH arrayValue IN arrayObj
  UPDATE Database SET myfield = '" & arrayValue & "'"
NEXT

The UPDATE statement is just an example.

ToddWW

 

[Genimuse]

See my post at the end of your other thread for a quick and easy way of doing your SQL IN command with your list.