Pete,
I thought your suggestion would be the answer...the syntax seemed familiar...but,
alas, CF Server balks again...thank you for the suggestion...
Dina
----- Original Message -----
From: Pete Freitag
To: CF-Talk
Sent: Wednesday, August 01, 2001 1:07 PM
Subject: RE: How can I insert a new record with no values?
Have you tried just: INSERT INTO Table ?
Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM
ColdFusion Developers Resources
http://www.cfdev.com/
-----Original Message-----
From: Dina Hess [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 1:20 PM
To: CF-Talk
Subject: How can I insert a new record with no values?
Hello all,
Would anyone be able to tell me how I can insert a row into a table that
requires no values. My MS Access table stores only an auto number and an
expiration date. The auto number, of course, is generated by the dbms and
the expiration date, which is set to a default value, is also generated by
the dbms, so there's no need for a field list or a values list in the SQL
statement. CF doesn't like my syntax as follows:
INSERT INTO Table ( )
VALUES ( )
I've also tried a few other approaches---all to no avail. Your help would be
much appreciated.
TYIA,
Dina
Official Member of the CF Newbie Club :-)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
