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
