>>can you post a more informative error message? OK - I put in some pseudo variables instead of using the ones from Flash Remoting and got this when I call the CFC from a CFM:
------------------------------------------------------------------------ ---------------------- Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The table 'Lessons' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically. The error occurred in C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11 Called from C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2 Called from C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11 Called from C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2 9 : UPDATE Lessons 10 : SET Lesson = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#lesson#"> 11 : WHERE ID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#row#"> 12 : </cfquery> 13 : <cfreturn #lesson#> ------------------------------------------------------------------------ ---------------------- Not sure how its being used by someone else, this is all being done locally on my workstation and only have ColdFusion accessing the access database. I am also only using the Developer edition of ColdFusion MX 7, but that shouldn't matter because you get 2 IP addresses to connect anyway, right? What's going on here? Jason Merrill | E-Learning Solutions | icfconsulting.com >>-----Original Message----- >>From: Douglas Knudsen [mailto:[EMAIL PROTECTED] >>Sent: Friday, July 15, 2005 10:28 AM >>To: CF-Talk >>Subject: Re: Query error >> >>can you post a more informative error message? Also, test it without the >>queryparams. Also, maybe just build the SQL in a string and email it to >>yourself to see if the SQL and inputed arguments are actually coming in >>correct from Flash. >> >>Aside fro this I'll not that you should VAR scope your local variables too. >>:) >> >>DK >> >>On 7/14/05, Merrill, Jason <[EMAIL PROTECTED]> wrote: >>> >>> Any idea why I'm getting an "Error Executing Database Query." With this? >>> I can take out the query and return "lesson" and "row" just fine. >>> Lesson and ID in the table are varchar and integer type fields >>> respectively. >>> >>> <cfcomponent> >>> <cffunction name="recieveData" access="remote"> >>> <cfargument name="lesson" type="string" required="yes"> >>> <cfargument name="row" type="string" required="yes"> >>> <cfquery name="updateDB" datasource="coursesDB"> >>> UPDATE Lessons >>> SET Lesson = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" >>> value="#Arguments.lesson#"> >>> WHERE ID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" >>> value="#Arguments.row#"> >>> </cfquery> >>> <cfreturn #Arguments.lesson#> <!---Test. works fine when cfquery >>> removed---> >>> </cffunction> >>> </cfcomponent> >>> >>> Thanks. >>> >>> Jason Merrill | E-Learning Solutions | >>icfconsulting.com<http://icfconsulting.com> >>> >>> >>> NOTICE: >>> This message is for the designated recipient only and may contain >>> privileged or confidential information. If you have received it in error, >>> please notify the sender immediately and delete the original. Any other use >>> of this e-mail by you is prohibited. >>> >>> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211996 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
