On Tuesday 08 April 2008 09:22:44 pm johnf wrote:
> ## cursor.execute("select COLUMN_NAME, DATA_TYPE"
> ## " from %s.INFORMATION_SCHEMA.COLUMNS"
> ## " where table_catalog = '%s'"
> ## " and table_name = '%s'"
> ## " order by ORDINAL_POSITION" %
> (dbName,dbName,tableName))
Sorry I missed the quotes the above works.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]