Chris,

>Thanks, one further follow up question, is there a way that I can then get
>the datatype of the columns and other bits of info (max size for a string
>etc?)
>

You'd need to interogate your database for that.  This will vary from DB to DB.  For 
mySQL - take a look at this : http://www.mysql.com/doc/en/SHOW_DATABASE_INFO.html

A small note about queryname.columnlist - the columns are returned in alphabetical 
order and not the order that they are in your database.

Regards

Stephen



BEGIN:VCARD
VERSION:3.0
PRODID:-//Gordano//NONSGML GLWebMail 7.02.3032//EN
FN:
N:;;;;
EMAIL;TYPE=INTERNET:[EMAIL PROTECTED]
END:VCARD


-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to