Isaac, Yeah - that is kind of a bummer. I sometimes develop a query script with regular variables, and then change them to CFqueryparams as the last step - after my debugging is complete. As far as the cf_sql_date type, I have used the cf_sql_char type instead and that works as well. SQL automatically converts the Char into a date object - as long as the format is correct.
-mk -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:52 PM To: CF-Talk Subject: Re: more <cfstoredproc> issues -- ARGH!! The other thing that really gets me is that with <cfquery> blah blah</cfquery> , no matter how many variables I put in it, as long as I stay away from <cfqueryparam> I get nice clean sql text in the debugging output that I can throw into query analyzer for comparison... If I use cfqueryparam or if I go to a cfstoredproc tag, I get nothing in the debugging output where those are used... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists