Philip,
I thank you again for your suggestion, however neither of the two fields in the table
will accept a null since one is an autonumber and one contains a default value.
Re: maintenance
There is only one instance of this code in my application, so that won't be a problem
when I migrate to a more robust database.
Regards,
Dina
----- Original Message -----
From: Philip Arnold - ASP
To: CF-Talk
Sent: Tuesday, August 07, 2001 4:27 AM
Subject: RE: How can I insert a new record with no values?
> > INSERT INTO Table (Field1)
> > VALUES (NULL)
> >
> > That should do it as long as the field can accept NULL values
> The autonumber field in my query does not accept nulls...but
> thank you for your input...
I know you've already got a solution to this, but as I commented, as long as
the field accepts NULL values, you can add a row
Your record can't just be an AutoNumber field, can it? If not, insert into
another field - the AutoNumber will take care of itself
Don't rely on Access solutions - when you upgrade to either mySQL, SQL
Server or Oracle, you'll have to hunt for all of these instances and change
them to more generic SQL or engine-specific versions (like you have now)
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