Fetching Column Names and Data Types

2002-10-11 Thread Chuck Tomasi
Can someone give me a sample of how to use the column_info method in DBI 1.30? I've read the docs, and I believe this method has the information I seek, but I'm an examples kind of person when it comes to stuff like this. I'm primarily interested in getting my hands on the column names and data

Fetching Column Names

2001-05-08 Thread Sean Carte
Is it possible to fetch the names of all columns in a table? How about all tables in a database? -- My brain hurts! SeanC Mediatek Training Institute 26 Crart Ave., Berea, Durban, South Africa phone: +27 (0)31 202 1886 [EMAIL PROTECTED]

RE: Fetching Column Names

2001-05-08 Thread Gregory_Griffiths
You can do a DESC command in SQL, although most interfaces also provide a specific way of doing this. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 10:45 To: [EMAIL PROTECTED] Subject: Fetching Column Names Is it possible to fetch

Re: Fetching Column Names

2001-05-08 Thread Philip Newton
On 8 May 2001, at 11:45, Sean Carte wrote: Is it possible to fetch the names of all columns in a table? First, prepare a statement that will select all columns from that table: $sth = $dbh-prepare('select * from blurfle'); Next, you may have to execute the handle. (Whether this is

RE: Fetching Column Names

2001-05-08 Thread Sean Carte
Many thanks your helpful replies Gregory, Sikkandar, and Philip! -- SeanC