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:211982 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
