What I need to obtain is the table information. Column names, type, length, etc. Someone suggested using the EXPLAIN or DESCRIBE commands, but ColdFusion is not returning it as a valid queryset. Are the result sets of these commands ODBCable? I am using MyODBC on Linux.
-----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 4:53 PM To: Lon Lentz Cc: [EMAIL PROTECTED] Subject: Re: mysql equiv for syscolumns? On Tue, Aug 20, 2002 at 04:03:03PM -0400, Lon Lentz wrote: > > I have a web based ad hoc query builder I built for running > against SQL Server databases. I am trying to port it to mysql. I > need a way to return table info through a query. Is there a way to > return syscolumns type info in standard column and row format? It might be helpful to describe what you need without using SQL Server terminology. A lot of folks here have never used the product but could probably help you anyway. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 287,167,474 queries (228/sec. avg) --------------------------------------------------------------------- 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