Yep, I know...bad programmer. no coffee. But, when you're pulling data from a view using a wildcard isn't "all" bad...considering you've made the view to aggregate the data anyhow and you probably want it all anyhow...
I'd usually write a stored proc. and have it do the work. But, this is a bend it and see what breaks day, so... ..I broke it... PS... ...don't do that...you can go blind. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of rudy Sent: Thursday, July 04, 2002 12:50 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] blind > It (the query) doesn't seem to like the * wildcard... well, you shouldn't be doing it that way anyway <grin> it's perfectly valid syntax, but comes with all kinds of disadvantages... the obvious answer is to list the columns you do want patient: doc, it hurts when i do this doctor: well, don't do it then rudy - 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: "Byron J. Bignell" <[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)
