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

Bryan LaPlante (52p/+0r) Posted: Tuesday 02 Jan 2001
This post: 122 views, +0 rating

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

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

Re: error insert date to sybase DB	02 Jan 2001	(111 v/ +0 r)
Re: error insert date to sybase DB	02 Jan 2001	(95 v/ +0 r)
Re: error insert date to sybase DB	02 Jan 2001	(92 v/ +0 r)
RE: error insert date to sybase DB	02 Jan 2001	(104 v/ +0 r)
Re: error insert date to sybase DB	02 Jan 2001	(101 v/ +0 r)
Re: error insert date to sybase DB	02 Jan 2001 (this post)	(122 v/ +0 r)
error insert date to sybase DB	02 Jan 2001	(138 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!)