----- Original Message ----- From: Allan Pichler {apichler@machinedreams.com> To: CF-Server <cf-server@houseoffusion.com> 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:wlmak@yahoo.com] > 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 cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com