mcsalp
Posts: 4
|
| Posted: 02/01/2006, 2:44 PM |
|
I've been partly successful in displaying mysql table names in a listbox by setting the listbox datasource to "show table status from databasename like '%'" but the dropdown just shows InnoDB for every table and does not display the table names.
Any help would be greatly appreciated.
|
 |
 |
eiden
Posts: 34
|
| Posted: 02/03/2006, 4:15 PM |
|
I'm not 100% sure of what you mean, but you can set the datasource to SQL and use: describe [tablename]
Example:
describe content
returns:
+-------------------+
| Field |
+-------------------+
| ContentId |
| Section |
| Title |
| Heading |
| Body |
| Published |
| PublishedByUserId |
| DatePublished |
| DatePublishStart |
| DatePublishEnd |
+-------------------+
|
|
|
|
mcsalp
Posts: 4
|
| Posted: 02/03/2006, 7:42 PM |
|
Thanks for your help Eiden. Let me try to clarify.
I have a listbox that I'm trying to populate with the list of tables in the current database(MySQL).
|
|
|
|
Walter Kempees
|
| Posted: 02/04/2006, 4:09 AM |
|
The SQL commands
SHOW TABLES FROM databasename
SHOW TABLE STATUS FROM databasename
Should work, if the result is less than expected, the I would suggest your
users access level is not allowing you these operations.
"mcsalp" <mcsalp@forum.codecharge> schreef in bericht
news:643e422c38f95d@news.codecharge.com...
> Thanks for your help Eiden. Let me try to clarify.
>
> I have a listbox that I'm trying to populate with the list of tables in
> the
> current database(MySQL).
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
