|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 11th, 2003, 03:13 PM
|
|||
|
|||
|
Debug My Update Statement
Why will this not work. It is not giving me any errors it just won't put anything into the database.
Code:
strsql = "UPDATE reportsn1nal1 SET n4 = n4 + (" & qn4 & ")"
|
|
#2
September 11th, 2003, 04:13 PM
|
||||
|
||||
|
You don't have a where clause in your sql statement. Add a response.write of your query, for debugging, and use the query analyzer in your database program to make sure you have a valid sql query.
The problem might also be in your asp code, however, so post the context of that line.
|
|
#3
September 11th, 2003, 06:47 PM
|
|||
|
|||
|
yeah i just added a where clause and it fixed it, thanks for the help
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Debug My Update Statement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
