Thank you, Dave...but that didn't work either. Meanwhile, I've discovered the
solution! Here it is, for all who come after:
INSERT INTO Table default values
Dina
----- Original Message -----
From: Bosky, Dave
To: CF-Talk
Sent: Wednesday, August 01, 2001 3:37 PM
Subject: RE: How can I insert a new record with no values?
Insert ' ' as itemname
-----Original Message-----
From: Guy M. Saenger [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 4:24 PM
To: CF-Talk
Subject: Re: How can I insert a new record with no values?
Sorry. I am pretty sure that it works in SQL Server. Was not sure about
Access.
--
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 3:00 PM
Subject: Re: How can I insert a new record with no values?
> 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
