Re: Query a mySQL View?

2006-02-03 Thread Ken Ferguson
Works fine for me. --Ferg Rick Root wrote: Les Mizzell wrote: Hmmm - now that I can design a view in mySQL, how do I query the view in Coldfusion? Don't work like it does in SQL Server, where you cn just go: select * from myVIEW That's the way it's supposed to work. Rick

Re: Query a mySQL View?

2006-02-03 Thread Ryan Guill
Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? Thanks, On 2/3/06, Ken Ferguson [EMAIL PROTECTED] wrote:

Re: Query a mySQL View?

2006-02-03 Thread Rick Root
Ryan Guill wrote: Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? A view is sort of like a table, except

Re: Query a mySQL View?

2006-02-03 Thread Ryan Guill
Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... On 2/3/06, Rick Root [EMAIL PROTECTED] wrote: Ryan Guill wrote: Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects

RE: Query a mySQL View?

2006-02-03 Thread Andy Matthews
-Talk Subject: Re: Query a mySQL View? Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... On 2/3/06, Rick Root [EMAIL PROTECTED] wrote: Ryan Guill wrote: Sorry for the side topic on this, but I am in mysql setting up a new

Re: Query a mySQL View?

2006-02-03 Thread Ryan Guill
--//- -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:29 PM To: CF-Talk Subject: Re: Query a mySQL View? Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... -- Ryan Guill

RE: Query a mySQL View?

2006-02-03 Thread Baz
The best thing to do with the MySQL site is search it through google: views site:http://dev.mysql.com/doc/refman/5.1 Then it becomes awesome again ;-) Baz ~| Message:

Query a mySQL View?

2006-02-02 Thread Les Mizzell
Hmmm - now that I can design a view in mySQL, how do I query the view in Coldfusion? Don't work like it does in SQL Server, where you cn just go: select * from myVIEW ~| Message:

Re: Query a mySQL View?

2006-02-02 Thread Rick Root
Les Mizzell wrote: Hmmm - now that I can design a view in mySQL, how do I query the view in Coldfusion? Don't work like it does in SQL Server, where you cn just go: select * from myVIEW That's the way it's supposed to work. Rick