> On Friday 13 Jul 2007, hussain shaikh wrote: > > I am getting an ORA-01003 error when I try to use cfqueryparam in my > query, > > but when I remove the cfqueryparam tag and hard code the value in > the where > > condition it works fine.The oracle error no. description says that > "No SQL > > statement parsed".I really don't understand whether it's an oracle > database > > issue or something to with the usage of cfqueryparam tag. > > Are you sure the value going into cfqueryparam is of the type you > expect ?
Yea, I'm sure of that. Even if the type is not correct will it still throw ORA-01003 error?? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
