What I was referring to was to output the string and not execute the end result SQL. Create a temporary variable that holds a string that you create, so that you capture the SQL that you would normally execute. At that point, you put the variable to see how the SQL would have executed and analyze it for validity. You can test it manually just by executing it between another cfquery tag block once you are done analyzing the string.
----- Original Message ----- From: "Daniel Kessler" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, May 24, 2007 12:57 PM Subject: insert error >> 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:279117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
