ruby
Posts: 8
|
| Posted: 11/29/2004, 6:31 AM |
|
hi
can some one tell me how to do a update in the tabel based on form value
i have a text box field name :Qunatity
when a user has done an updated in the text box field then my sql statement should immediately update another column i.e
Status(column name) is O
when there is an update then Status must be changed to U
my code for this
Dim conn
Dim sql
Dim rs
set conn = new clsDBConnection1
conn.open
sql = "UPDATE Order set Status= 'U' WHERE Quantity = " & CCTOSQL(CCGetFromGet("Quantity",Empty),ccsFloat) & ""
conn.Execute(sql)
conn.close
set conn = Nothing
when i use GetParam it says that the varaible is undefined
i wrote this code in after submit event
can somebody help m e out in this situation
thanks in advance
regrads
|
 |
 |
|
