Getting Field type 1

[audiopro]

I am creating a MySQL update query within a PERL script.
The target table contains 2 types of field, TEXT and BIGINT.
The field names are read from a stored array but I need to know the field type in order to enter the var as a number or a quoted text value.
I feel sure there must be a simple way of getting each field type but my searches have so far failed to unearth a suitable solution, can anyone help?

Keith

http://www.studiosoft.co.uk

 

[sleipnir214]

How about issuing a

DESCRIBE tablename columnname

query?

http://dev.mysql.com/doc/refman/5.1/en/describe.html

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[audiopro]

That sorted it Thankyou.
I have been looking for a complicated solution to a simple problem. Have a star.

Keith

http://www.studiosoft.co.uk