Sorry, I was in a hurry. :-) In 'Daveemailspeak' MM = Macromedia UltraDev v4.01. I put the stored procedures into the MS SQL v7 server using Access or WinSQL.
I have used MSDE for 1 client. It is not to bad. Problem types I have when using stored procedures include cast problems. When I have a long INSERT statement, and say, a default value is not correct in 1 of the variables passed to the stored procedure, it is a pain to discover which variable is char and should be integer etc. When I use a recordset for my inserts, I see the entire SQL statement in the error message. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of rudy Sent: Tuesday, June 04, 2002 6:32 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] SQL 7 stored procedure debugger >I normally use Access 2000/XP or WinSQL Lite to develop and test my >stored procedures before using them in CF. That works reasonably well >for me, it's only all the extra code MM drops into the file that is >causing me the occasional fit when I try to debug. huh? all the extra code MM drops in? david, could you clarify this a bit? what's MM?? and why are you letting it do that? another option for testing your sql locally is MSDE i have not used it myself, but apparently it is the same as sql/server, minus a few non-essential features like replication see http://urlizer.com/00/822/ rudy http://rudy.ca/ - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "rudy" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "David Porter [Sympatico]" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
