Thanks everyone!
Changing the DATE field name did the trick.
Erika
----- Original Message -----
From: "Deanna L. Schneider" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 3:15 PM
Subject: Re: Insert INTO syntax error - HELP
: Right off the bat, I'd say...do you have any number fields? Like, for
: instance, your id field? If it's a number, leave off the ' marks. Also,
: you'll probably need to do something like this:
:
: createodbcdate(thisdate) to convert the date field into an odbc format
: (assuming an odbc type database such as access.
:
: Also, "date" is a reserved word, so you'll want to change it in your
: database to something like "mydate" or "thisdate." Hm...type might be a
: reserved word, too...but I'm not sure on that one.
:
: Hope that helps you along.
:
: -Deanna
:
:
:
: ************************************************************
: Deanna Schneider
: Interactive Media Developer
: UWEX Cooperative Extension Electronic Publishing Group
: 103 Extension Bldg
: 432 N. Lake Street
: Madison, WI 53706
: (608) 265-7923
:
:
:
: --------------------------------------------------------------------------
----
: Archives: http://www.mail-archive.com/[email protected]/
: 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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
