|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hello,
I'm having a problem with creating an INSERT statement with the cfquery tag. I'm just testing at the moment and I can use SELECT ok, but not INSERT. can anyone give me a clue as to what's happening? the code is... <cfquery datasource="murphthedog"> INSERT INTO visitors (visitor, datetime) VALUES ('daniel', 'now') </cfquery> ...and the error is... Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement... Many thanks Daniel |
|
#2
|
|||
|
|||
|
Try this.
INSERT INTO visitors (visitor, datetime) VALUES ('daniel', now()) |
|
#3
|
|||
|
|||
|
doh! Many thanks Ezra
Daniel |
![]() |
| Viewing: Dev Articles Community Forums > Programming > Cold Fusion Development > Problem with INSERT statement in <cfquery> |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|