Dave, thanks for your response. See my responses below:
>>My guess is that one of the following is true:
>>
>>1. You don't have a datasource called "coursesDB".
I do. I've been accessing it and making modifications to it. It seems
only to mess up when I try and do this UPDATE type query.
>>2. The user account used by CF doesn't have rights to update the
Lessons
>>table.
It does.
>>3. The Lessons table belongs to another user account, so your user
account
>>can't see it without specifying the username explicitly ("UPDATE
>>otherusername.Lessons ...").
Nope.
>>4. The table is not in fact named "Lessons".
It is.
>>5. The table doesn't have a field called "Lesson".
It does.
>>6. The "Lesson" field doesn't contain a VARCHAR.
It does. at least in Access it designed to be field data type "Text"
which Dreamweaver displays as VARCHAR.
>>7. The table doesn't have a field called "ID".
It does.
>>8. The "ID" field doesn't contain an INTEGER.
It does - at least in Access it designed to be field data type "Number".
>>9. You're passing the wrong datatype to one of the fields - my guess
would
>>be that Arguments.row should be a number instead of a string.
It does, at least as far as I know how Flash Remoting works, I am
sending like this:
var pc:PendingCall = updateDatabaseService.recieveData({lesson:"How to
Dismantle an Atomic Bomb", row:9});
....where 9 should be an integer, unless Remoting still sends it as a
string. If so, it seems there is no way to be sure it's being sent as a
number from Flash, is there a way in CF to convert it from a string type
(if that's really how its being sent) to type numeric? Or at least
find out what data type its being received as?
Thanks for your help.
Jason Merrill | E-Learning Solutions | 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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211974
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
