-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
This belongs on the [EMAIL PROTECTED] mailing list.
Thanks!
-Mark
- -------- Original Message --------
Subject: SHOW FIELDS FROM myTable
Date: Tue, 30 Sep 2003 22:46:00 -0500
From: Mike Griffin <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
What does 'SHOW FIELDS FROM myTable' return? I don't get an error, I
just seem to get no data back, however, I can change the code below to
'SELECT * FROM myTable' and get my actual data. I'm using .NET here
but everything else works, just the show and describe things seem to not
return result sets?
OleDbConnection cn = new OleDbConnection(@"Provider=MySQLProv;Data
Source=test;DB=test;UID=;PWD=;PORT=3306");
cn.Open();
OleDbCommand cmd = new OleDbCommand("SHOW FIELDS FROM
test.employees", cn);
cmd.CommandType = CommandType.Text;
DataTable metaData = new DataTable();
OleDbDataAdapter ad = new OleDbDataAdapter();
ad.SelectCommand = cmd;
ad.Fill(metaData);
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 557 2388
www.mysql.com
Are you MySQL Certified?
http://www.mysql.com/certification/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQE/etH9tvXNTca6JD8RArXIAKCdXBTGU8U969SEVVldAIfDQU4UFwCgyMRa
VaevphDUSW5FzSYCUwISN7c=
=Zryt
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
