View Single Post
  #8 (permalink)  
Old May 6th, 2008, 12:42 PM
MarkGT MarkGT is offline
Authorized User
 
Join Date: Apr 2008
Location: , , .
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I used the r1, r2...etc because it made the sql statement easier for me to create/read. There are actually 27 fields being updated with the sql statment, I didnt post all of the code because it's really long.

While we're discussing sql statments...How would I create an sql statement with values from a <select> list? In my current sql statement I used request.form("xxxx") and retrieved the values based on the name of the input box, where "xxxx" was the name of the box. To create an sql statement, do I need to name the select box or the individual options? Would I still use the request.form("xxxx")?
Reply With Quote