good question but i had arrange all the value according to the columns so it
should not be a problem on SQL statement without column names
----- Original Message -----
From: Allan Pichler <[EMAIL PROTECTED]>
To: CF-Server <[EMAIL PROTECTED]>
Sent: Tuesday, January 02, 2001 5:01 PM
Subject: RE: error insert date to sybase DB
> Is it just me or does that query miss the column names from the table ???
>
> <CFQUERY name="additem" datasource="database">
> INSERT INTO proitem (column1, column2, column3, column4)
> VALUES (#value1#, #value2#, #value3#, #value4#)
> </CFQUERY>
>
>
>
> -----Original Message-----
> From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 01, 2001 11:48 PM
> To: CF-Server
> Subject: error insert date to sybase DB
>
>
> i encountered an error when i try to insert a date into sybase db table.
> the sql statement
>
> <cfquery name="additem" datasource="database">
>
> insert into proitem values("#itemid#", #form.costprice#,
> #DateFormat(CreateDate(form.year, form.month, form.day),"dd-mm-yyyy")#)
> </cfquery>
>
> it give me an error from sybase side, then i try to substitute the whole
> DateFormat function with a variable but it still have the same error
> nyone know what seems to be the problem.?
>
> regards
>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
