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 <blaplante@netwebapps.com> To: CF-Server <cf-server@houseoffusion.com> 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" <wlmak@yahoo.com> > To: "CF-Server" <cf-server@houseoffusion.com> > 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 cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com