On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote:
> On Thu, Feb 26, 2009 at 4:01 PM, revDAVE <c...@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
> 
That'll just return an empty result set, as in empty and with no fields
output! In MySQL you can do this:

SELECT column_name FROM information_schema.columns WHERE table_name =
'table_name'

this might help with doing the same for M$Access?


Ash
www.ashleysheridan.co.uk


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to