Re: Get a list of column field names from a MS Access table

On Fri, Feb 27, 2009 at 4:58 PM, Bastien Koert <phpster@gmail.com> wrote: > On Thu, Feb 26, 2009 at 4:01 PM, revDAVE <Cool@hosting4days.com> wrote: > >> Newbie question: >> >> I would like to get a list of column field names from a MS Access table and >> hopefully get them returned in the ORIGINAL order (as they appear in >> access) >> >> Is there a sql query I could do to get this result? >> >> >> >> >> -- >> Thanks - RevDave >> Cool @ hosting4days . com >> [db-lists 09] >> >> >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > A dirty way is to query the table where 1=2 to return no results > > select * from table where 1=2 > > -- > > Bastien > > Cat, the other other white meat > I thought (and almost replied) the same, but the more I think about it, I'm not sure it would work. The query would return no results, so there wouldn't even be an array of empty values. Andrew