ASP Select Box to DB

[Cassien]

Update on my previous post...

Take a look at

http://www.pharmacylocum.net/tempupdate.asp

I'm trying to allow users to populate the right hand box with a number of variables from the left one and then update their data with it.

dim item
for each item in request.Form("Selected&quot
StrSql = "UPDATE Table2 SET Table2.Data = " & item & " WHERE UName = 'Prac'"
Set MM_editCmd = OBJdbConn.Execute(StrSql)%>
next

That's what I tried to use, but it doesn't seem to think there's anything in the second box.

Any ideas?

Thanks, John

 

[lebisol]

second box being Item?

WHERE my_field1="someVAR" AND my_field2="someVAR2"

 

[lebisol]

dim item
item= Request.Form("Selected&quot

 

[Cassien]

Hi, thought I'd replied to your last one but the responce doesn't seem to be there... have it all sorted now, just for anyones information did it through a SQL statment for the select * where right != left and then a javascript written SQL query for updating the db.