I have a Coldfusion website administration function sitting on a MySQL database. I am using a SQL query (see below) to 'show tables'. I am then using the results to dynamically build database modification pages (enabling administrator to modify the database structure as well as modify content). It all works perfectly on my local machine but the 'show tables' query is not running at all on my live server! The Coldfusion error simply states that the query is unavailable. I know this is a MySQL problem not a CF syntax one because replacng the SQL with a standard 'select' statement works fine.
THis is a major problem that's come out of nowhere...as mentioned it works perfectly on my dev server but falls straight over on the live machine. Could this be to do with permissions or data ownership? I set up the db on my dev box but my ISP installed the db on the live server. I'm pretty new to MySQL so all help greatly appreciated! <CFQUERY name="tablelist" datasource="#application.dsn#"> show tables </CFQUERY> many thanks Jonathan Cooper Visation Ltd Contact Details: P - 44 (0) 1372 372345 E - [EMAIL PROTECTED] W - www.visation.com ==================================================== www.Fnaffle.com - Humour website www.Tranmit.com - Leading e-procurement and e-payables solutions www.LG-Collectables.com - Antiques and collectables --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/2001 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
