Hi, all.
mySQL 4.0.1, Win2K Pro
I'm running this Insert Query:
The #Form.PaymentDate# coming from the form shows up as
{d '2002-12-16'} (before processing below):
<CFQUERY Name="InsertPayment" Datasource="#DSN#">
Insert into rentcofeepayments
(RentalCompanyID, PaymentDate, PaymentMethod,
PaymentAmount)
Values (<cfqueryparam cfsqltype="CF_SQL_BIGINT"
Value="#Form.RentalCompanyID#">,
<cfqueryparam cfsqltype="CF_SQL_DATE"
Value="#CreateODBCDate(Form.PaymentDate)#">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR"
Value="#Form.PaymentMethod#">,
<cfqueryparam cfsqltype="CF_SQL_DOUBLE"
Value="#Form.PaymentAmount#">)
</CFQUERY>
But getting this error:
CFQUERYPARAM data conversion error
There is a data conversion error for CFQUERYPARAM #2.
How do I modify it to make it work?
I added the CreateODBCDate into the code, but that didn't help...
Thanks,
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
