> Get the output of one iteration of the insert statement by > outputting the > end result of the SQL. Take the SQL statement and execute it directly > against your DB. If the insert works fine, it may be how you handle > different data types.
I can't output the end-result. I put in debug=yes and result="debug_result", but since it gives an error, I never get to the point where that can be dumped. > Turn debugging on and see what the query actually is. If you mean on the server, I don't have access to that as I'm in shared-hosting. If you mean as I describe above, that seems to have problems. > We deal with these issues under the "15 minute rule".....if ya > can't see it in > 15 minutes it's dead bloody simple and you must ask someone else to > look at your > > code and then shame you by pointing out your silly typo ;-) That's why I sent the email. I don't have anyone here to review my code and as I've looked at it for way too long and don't seem to see the error, I was hoping someone here would shame me by pointing out the typo. I'll keep looking. -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
