I need to update a table inside a database with a text file... Since our credit card processing software is ancient and throws the auth codes into a text file once batch processed, I'd like to update our orders table to reflect the authcode. Each Line of the text file looks something like this (usually there will be multiplelines): "1" "123456789012345" "1202" "18.99" "1713" "14219" "7555" "245962" Each item is separated by quotes. What I would like to do is key on the second set of double quotes which is the CC#. Base a query on that cc# to find that number in my orders table. Update the CCauth field with the info in the last set of quotes and update our payment status field to "payment made". Looping until its done with the text file Ideas? Thanks, Jeff ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
