TallyList : mailing list management, archiving, and analysis

Archive of:
CF-Server
Cold Fusion Server Tech

home
24 hour view
quick stats
weekly updates

all tallylists
corporate solutions
archive your favorite
help / feedback

About Cold Fusion :
product's home
product's list home

Archived TallyList / CF-Server:
Subject: RE: error insert date to sybase DB

Allan Pichler (4p/+0r) Posted: Tuesday 02 Jan 2001
This post: 97 views, +0 rating

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

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

Similar Subject Line Posts (+/- two weeks of this post)

Re: error insert date to sybase DB	02 Jan 2001	(101 v/ +0 r)
Re: error insert date to sybase DB	02 Jan 2001	(86 v/ +0 r)
Re: error insert date to sybase DB	02 Jan 2001	(85 v/ +0 r)
RE: error insert date to sybase DB	02 Jan 2001 (this post)	(97 v/ +0 r)
Re: error insert date to sybase DB	02 Jan 2001	(91 v/ +0 r)
Re: error insert date to sybase DB	02 Jan 2001	(111 v/ +0 r)
error insert date to sybase DB	02 Jan 2001	(128 v/ +0 r)

Send a reply to the CF-Server list!
	NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!)