I meant, it happens in queries with a *cfqueryparam* tag.. In case that wasn't obvious
Restarting CF gets rid of the problem.. But it keeps coming back after a few hits. I've always had trouble with cfqueryparam tags.. Is it a curse I bear or is it just normal for them to be so erratic.. Is there a problem with the way I use them?? As below ----------------------------- SELECT * FROM Users WHERE Users_Login = <cfqueryparam cfsqltype="cf_sql_varchar" value=#U#> AND Users_password = <cfqueryparam cfsqltype="cf_sql_varchar" value=#P#> ----------------------------- Any ideas yet? Joel -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Joel Cass Sent: Tuesday, 6 June 2006 9:31 AM To: [email protected] Subject: [cfaussie] Strange recurrent problem with SQL Server 7 & MX7 Hi, We keep having this problem occuring on one of our larger applications, hosted on MX7. The same problem has not appeared on another server running MX6, however. Both connect to SQL server 7, running on windows 2000. "Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Could not find prepared statement with handle [X]". It always happens on queries containing at least one cfparam tag. Any ideas? Joel --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
