Thanks for the pointers from migrating Access to SQL, John.
Today I have a new question.
I am developing a CF Web App and am having a bear of a time ONLY
with INSERT INTO statements.
For example,
In an Access MDB I have the following table (named "content"):
guid (VARCHAR 16)
type_id (SMALLINT 2)
client_id (SMALLINT 2)
user_id (SMALLINT 2)
logdate (DATETIME 16)
birthdate (DATETIME 16)
expirationdate (DATETIME 16)
which is recordless at the time of testing.
I have the following query on a CF page:
<cfquery name="perm_write_content" datasource="#Application.dsn#"
dbtype="ODBC">
INSERT INTO content(guid,
type_id,
client_id,
user_id,
logdate,
birthdate,
expirationdate)
VALUES('#temp.guid#',
#temp.content_type_id#,
#temp.client_id#,
#getuserid.user_id#,
#Now()#,
#ParseDateTime(temp.birth_date)#,
#ParseDateTime(temp.expiration_date)#);
</cfquery>
It is throwing the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
INTO statement.
SQL = "INSERT INTO content (guid, type_id, client_id, user_id, logdate,
birthdate, expirationdate) VALUES ('ADOUTV2Y', 1, 2, 1, {ts '2001-
04-13 10:24:48'}, {ts '2001-01-01 00:00:00'}, {ts '2099-12-31 23:
59:59'});"
It all seems to be syntactically correct -- any pointers?
I tried everything I could think of; the only way I can get INSERT
INTO statements working is by NOT NAMING the columns, which is, for
obvious reasons, not ideal. If I explicity name the columns, it throws
an error every time. BtW, the columns all are not required and do
allow zero length values, but as you can see, I am naming every column
and providing what appears to be the proper data type, yet it throws
an error.
Thanks in advance,
Geoff Hoffman
[EMAIL PROTECTED]
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
