MySQL

[John Craig]

Hi, Mark.  I've used the following to get a list of MySQL tables;

put revDataFromQuery(tab, return, lDB, "show databases") into tResult

and the following to list tables in a database;

put revDataFromQuery(tab, return, lDB, "show tables from mysql") into 
tResult   ('mysql' being the database name)


JC

Mark Schonewille wrote:
> Hi Chris,
>
> Sure, I have read the documentation. Once a database has been created, 
> I can modify it. That's not the problem. I would like to do something 
> like this (in a button):
>
> on mouseUp
>   revExecuteSQL 1,"SHOW DATABASES;"
>   put the result
> end mouseUp
>
> and would like to get a list of databases returned, but the result is 
> empty. The used parameters for revExecuteSQL are not really logical of 
> course, since I provide a database ID while the SQL statement is 
> typically executed before opening a database. Any ideas?
>
> Best,
>
> Mark
>
> -- 
>
> Economy-x-Talk
> Consultancy and Software Engineering
> http://economy-x-talk.com
> http://www.salery.biz
>
> Get your store on-line within minutes with Salery Web Store software. 
> Download at http://www.salery.biz
>
> Op 27-nov-2006, om 16:36 heeft Chris Sheffield het volgende geschreven:
>
>> Hi Mark,
>>
>> This is probably more of a MySQL thing than a Rev thing. I would 
>> recommend reading through the MySQL documentation if you haven't 
>> already, and check out the commands for working with databases and 
>> their tables. If I'm not mistaken, you should be able to use any 
>> MySQL command by running it through the revExecuteSQL command from 
>> your Revolution code. One thing to watch would be user permissions 
>> for your MySQL server, and making sure users have the ability to 
>> create/modify database schemas.
>>
>> Hopefully this will help you in the right direction. Btw, by no means 
>> do I consider myself a database guru. :-)
>>
>> Chris
>>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>