We are trying to move to a new codebase for a public site and have come up with a strange problem which I do not seem to be able to find a satisfactory explanation or solution for.
During testing nothing odd came up but trying to send it live with external use we started to get a lot of 'Invalid parameter binding' errors when cfqueryparam was being used. This was not all the time, only some of the time, and happened on a variety of pages (straight forward CF pages, CFCs, CFTags...). Looking at the error messages, the error either presented itself as the parameter being missing, or it would be randomly inserted in the wrong position, or sometimes the query itself would be missing chunks of SQL. The values were being passed across since you can see them being passed as params - error example below: SQL: SELECT COUNT(ar.ID) AS idCount FROM tblTest ar WHERE ar.ID = AND ar.fPublished = 1 AND ar.fDeleted = 0 WHERE: (param 1) = [type='IN', class='java.lang.Integer', value='17721', sqltype='CF_SQL_INTEGER'] Thought it may have been the JDBC drivers and tried a variety of them, and then tried taking out the cfqueryparams to see what happened, but instead of getting 'Invalid parameter binding', we just get 'Incorrect syntax near ...' so the cfqueryparam link seemed to have masked an underlying problem. I cannot reproduce this on demand - it does not happen all the time to the files I have received errors for... Big changes to the codebase involve moving from Application.cfm to Application.cfc and using more persistent objects. Would a memory leak manifest itself in this way and it's been exposed by relying on objects more? I'd appreciate any suggestions for ways to approach this! Tara ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
