|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
July 27th, 2004, 04:00 AM
|
|||
|
|||
|
vendorerrorcode
I am getting an error,
when using an cfinsert statement. The error shows that the venorerrorcode is 911 and the sqlstate is 42000. What does this vendorerrorcode mean? how can i find the list of these codes? Thanks, Vidya
|
|
#2
July 27th, 2004, 11:45 AM
|
|||
|
|||
|
Quote:
Vendor error code is your database makes error code; mssql, mysql, access, oracle. You dont need to worry about that, you need to worry about the other error statments.
|
|
#3
July 27th, 2004, 11:50 AM
|
|||
|
|||
|
Also if im correct <cfinsert> is not supported by CFMX
Use <cfquery name="name" datasource="whatever"> INSERT INTO table_name (column1, column2, column3) VALUES (integer_vale, 'text_value', 'memo_value') </cfquery>
|
|
#4
July 27th, 2004, 08:14 PM
|
|||
|
|||
|
In fact, never use cfinsert or cfupdate. Write your own SQL.
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > vendorerrorcode |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
