Getting a list of MySQL database views

[Ray Meade]

I'm trying to create a custom export page for our member rep's. I'm using 
cfdbinfo to get a list of tables to pull the data from, but I also have a 
handful of views that combine data from different tables. (such as the members 
table and the deliverables table) Is there any way to pull a list of DB views 
that I can use instead of raw tables? (I've named my views with intuitive names 
('members' instead of 'users', etc.) so that our rep's. will know where to pull 
the data they need) I've looked everywhere I can think of for a solution 
including the MySQL doc's., but to no avail...please help. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334017
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Getting a list of MySQL database views

[Barney Boisvert]

http://dev.mysql.com/doc/refman/5.0/en/views-table.html

On Wed, May 26, 2010 at 1:00 PM, Ray Meade raym...@yahoo.com wrote:

 I'm trying to create a custom export page for our member rep's. I'm using 
 cfdbinfo to get a list of tables to pull the data from, but I also have a 
 handful of views that combine data from different tables. (such as the 
 members table and the deliverables table) Is there any way to pull a list of 
 DB views that I can use instead of raw tables? (I've named my views with 
 intuitive names ('members' instead of 'users', etc.) so that our rep's. will 
 know where to pull the data they need) I've looked everywhere I can think of 
 for a solution including the MySQL doc's., but to no avail...please help.

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334018
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Getting a list of MySQL database views

[Leigh]

http://dev.mysql.com/doc/refman/5.1/en/views-table.html

As always when doing this kind of thing, be sure to protect your queries 
against sql injection and structure permissions accordingly...



  


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334019
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm