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

2009-03-02 Thread Andrew Ballard
On Sun, Mar 1, 2009 at 12:39 AM, Paul M Foster wrote: > On Sat, Feb 28, 2009 at 06:54:25PM -0500, Andrew Ballard wrote: > >> On Sat, Feb 28, 2009 at 6:08 PM, Paul M Foster >> wrote: >> > On Sat, Feb 28, 2009 at 12:41:12AM +, Ashley Sheridan wrote: >> > >> >> On Fri, 2009-02-27 at 16:58 -0500,

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

2009-02-28 Thread Paul M Foster
On Sat, Feb 28, 2009 at 06:54:25PM -0500, Andrew Ballard wrote: > On Sat, Feb 28, 2009 at 6:08 PM, Paul M Foster > wrote: > > On Sat, Feb 28, 2009 at 12:41:12AM +, Ashley Sheridan wrote: > > > >> On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: > > > > > > > >> That'll just return an

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

2009-02-28 Thread Andrew Ballard
On Sat, Feb 28, 2009 at 5:08 AM, Ashley Sheridan wrote: > On Sat, 2009-02-28 at 00:40 -0500, Andrew Ballard wrote: >> On Fri, Feb 27, 2009 at 7:41 PM, Ashley Sheridan >> wrote: >> > On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: >> >> On Thu, Feb 26, 2009 at 4:01 PM, revDAVE wrote: >> >

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

2009-02-28 Thread Andrew Ballard
On Sat, Feb 28, 2009 at 6:08 PM, Paul M Foster wrote: > On Sat, Feb 28, 2009 at 12:41:12AM +, Ashley Sheridan wrote: > >> On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: > > > >> That'll just return an empty result set, as in empty and with no fields >> output! In MySQL you can do thi

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

2009-02-28 Thread Paul M Foster
On Sat, Feb 28, 2009 at 12:41:12AM +, Ashley Sheridan wrote: > On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: > 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

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

2009-02-28 Thread Jim Lucas
revDAVE 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-list

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

2009-02-28 Thread Ashley Sheridan
On Sat, 2009-02-28 at 00:40 -0500, Andrew Ballard wrote: > On Fri, Feb 27, 2009 at 7:41 PM, Ashley Sheridan > wrote: > > On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: > >> On Thu, Feb 26, 2009 at 4:01 PM, revDAVE wrote: > >> > >> > Newbie question: > >> > > >> > I would like to get a li

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

2009-02-27 Thread Andrew Ballard
On Fri, Feb 27, 2009 at 7:41 PM, Ashley Sheridan wrote: > On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: >> On Thu, Feb 26, 2009 at 4:01 PM, revDAVE wrote: >> >> > Newbie question: >> > >> > I would like to get a list of column field names from a MS Access table and >> > hopefully get th

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

2009-02-27 Thread Andrew Ballard
On Fri, Feb 27, 2009 at 4:58 PM, Bastien Koert wrote: > On Thu, Feb 26, 2009 at 4:01 PM, revDAVE 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) >> >>

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

2009-02-27 Thread Ashley Sheridan
On Fri, 2009-02-27 at 16:58 -0500, Bastien Koert wrote: > On Thu, Feb 26, 2009 at 4:01 PM, revDAVE 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)

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

2009-02-27 Thread Bastien Koert
On Thu, Feb 26, 2009 at 4:01 PM, revDAVE 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? > > > > > --

[PHP] Get a list of column field names from a MS Access table

2009-02-26 Thread revDAVE
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