Guy,
Thanks for your input...unfortunately, that query produces a row that overrides the
autonumber with the value 0...
back to the drawing board... :-)
Dina
----- Original Message -----
From: Guy M. Saenger
To: CF-Talk
Sent: Wednesday, August 01, 2001 1:03 PM
Subject: Re: How can I insert a new record with no values?
Dina,
I think that you can do the following
insert into TableName (AutoNumberField) values (0)
I think that will create a row, assign the autonumber value, and populate
the
default value for the expiration date.
--
Guy M. Saenger
[EMAIL PROTECTED]
214.448.8887
----- Original Message -----
From: "Dina Hess" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 01, 2001 12:20 PM
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