|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
April 17th, 2008, 06:09 AM
|
|||
|
|||
|
Syntax error in INSERT INTO statement
Has anyone got any idea what the error is here?
Code:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
INSERT INTO MailinglistSignups (ID, Name, Email, DateInfo) VALUES ("#currentid#", "#form.name#", "#form.email#", "#createodbcdatetime(now())#")
INSERT INTO MailinglistSignups (ID, Name, Email, DateInfo) VALUES ("5C160172-123F-6116-4236786851DB440A", "test", "test@test.com", "{ts '2008-04-17 06:12:36'}")
The four fields (ID, Name, Email, DateInfo) are all memo fields. Please help! Thanks! Last edited by airdesign : April 17th, 2008 at 06:14 AM.
|
|
#2
April 17th, 2008, 07:21 AM
|
||||
|
||||
|
has it ever worked before?
has a similar query ever worked on a different table? have you checked the spelling of the table and column names? does it work if you test it directly in Access, i.e. in SQL View? does it work if you change doublequotes for singlequotes? are there any other columns in the table?
|
|
#3
April 17th, 2008, 08:07 AM
|
|||
|
|||
|
Actually stating what the problem is would help. Do you get an error? What happens when you run this?
Also, why on earth would you use memo field types for ID, name, email, or date?
__________________
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 > Syntax error in INSERT INTO statement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
