Philip,
The autonumber field in my query does not accept nulls...but thank you for your
input...
Dina
----- Original Message -----
From: Philip Arnold - ASP
To: CF-Talk
Sent: Wednesday, August 01, 2001 12:50 PM
Subject: RE: How can I insert a new record with no values?
> 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.
INSERT INTO Table (Field1)
VALUES (NULL)
That should do it as long as the field can accept NULL values
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
