Hi All,
I know I'm missing something really simple but I'm beyond seeing it now. Any
ideas what's up here?
This is working in SQL server but using Access97 or 2000 I get the following
error.
[Microsoft][ODBC Microsoft Access 97 Driver] Missing semicolon (;) at end of
SQL statement
Data Source = "eMPower2000"
SQL = "INSERT INTO documents (doc_id, lang_id, doc_status, doc_group_id,
parent_doc_id, doc_order, doc_type_id, doc_title,doc_text, date_displayed,
date_expires, user_id, cat_id, subcat_id) VALUES (11, 1, 'O', 1, NULL, 4, 2,
'Test eMPower Content', 'This content is being managed by eMPower', {d
'2000-05-02'}, NULL, 2, NULL, NULL) INSERT INTO doc_edit (doc_id, lang_id,
doc_status, doc_group_id, parent_doc_id, doc_order, doc_type_id, doc_title,
doc_text, date_displayed, date_expires, cat_id, subcat_id) VALUES (11, 1,
'I', 1, NULL, 4, 2, 'Test eMPower Content', 'This content is being managed
by eMPower', {d '2000-05-02'}, NULL, NULL, NULL) INSERT INTO
doc_history(doc_id, lang_id, doc_status, doc_group_id, parent_doc_id,
doc_order, doc_type_id, doc_title, doc_text, date_displayed, date_expires,
user_id,cat_id, subcat_id) VALUES (11, 1, 'I', 1, NULL, 4, 2, 'Test eMPower
Content', 'This content is being managed by eMPower', {d '2000-05-02'},
NULL,2,NULL, NULL)"
Code looks like:
<cfquery datasource="#dsn#" name="qi_doc">
INSERT INTO documents ( ...table fields...)
VALUES ( .... form fields .... )
INSERT INTO doc_edit ( ...table fields...)
VALUES ( .... form fields .... )
</cfquery>
TIA,
Duane Boudreau
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249
Fax: 603-594-0258
ICQ#: 18024374
Jobs: [EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
