|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
October 7th, 2003, 11:55 AM
|
|||
|
|||
|
SQL in ASP, I have an error in statement.
I keep getting this error, the "ID" in the last part of the statement is an "Integer" the rest are "Char". How would I make this statement correct?
Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. /saveData.asp, line 24 Code:
SQLstmt = "UPDATE Customers SET custname='" & custname & "', received='" & received & "', investor='" & investor & "', class='" & clss & "', closing='" & closing & "', loanamount='" & loanamount & "', fee='" & fee & "', comments='" & comments & "' WHERE ID='" & loanID & "'"
|
|
#2
October 7th, 2003, 02:16 PM
|
|||
|
|||
|
With numbers ( ' ) is not needed this is only with characters and if you was using date you would use #. This should now work
WHERE ID= " & loanID & ""
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > SQL in ASP, I have an error in statement. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
