not matter it is single quote or double code, the error message as below:
Error Diagnostic Information
Sybase Error Code = 213
Insert error: column name or number of supplied values does not match table
definition.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (14:1) to (14:53)
any ideas?
----- Original Message -----
From: Bryan LaPlante <[EMAIL PROTECTED]>
To: CF-Server <[EMAIL PROTECTED]>
Sent: Tuesday, January 02, 2001 4:55 PM
Subject: Re: error insert date to sybase DB
> I don't know sybase at all but try wrapping your values in single quotes
> instead of double quotes.
>
> Bryan LaPlante
> Manager
> Cold Fusion User group of Kansas City MO.
> ----- Original Message -----
> From: "Mak Wing Lok" <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 02, 2001 1:47 AM
> 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
