RE: Could not find prepared statement with handle 2 - suddenly?

[Peterson, Chris]

Actually, I am getting the same prepared statement error on another
query that looks fine!

                <cfquery name="getReportSecurity" datasource="Reports">
                SELECT
                        A.ID,
                        A.Name,
                        A.URL,
                        A.Folderpath,
                        A.Description,
                        B.Id,
                        B.userName,
                        C.ID,
                        C.groupName
                FROM
                        rpt_Reports A LEFT JOIN rpt_requiredUser B ON
A.ID = B.reportID
                        LEFT JOIN rpt_requiredGroup C on A.ID =
C.reportID
                WHERE
                        A.URL = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#reportAddress#">
                </cfquery>

Anyone have any idea's on this one, I may end up re-starting Coldfusion,
and I don't like that! =(

Chris Peterson

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274939
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4