Fwd: RE: Re[2]: [PHP-WIN] php access query problem

2001-02-11 Thread Bob Hall
>Date: Sun, 11 Feb 2001 10:02:56 -0500 >To: [EMAIL PROTECTED] >From: Bob Hall <[EMAIL PROTECTED]> >Subject: RE: Re[2]: [PHP-WIN] php access query problem >Cc: >Bcc: >X-Attachments: > > >> >> I have the query >> >> $cur= odbc_e

RE: Re[2]: [PHP-WIN] php access query problem

2001-02-10 Thread Bikes
I think you should also use mysql, for guaranteed interoperability with php. But meanwhile, just keep playing around with the quotes ' and " . Bikes -Original Message- From: Gonzalo Vera To: aaron Cc: [EMAIL PROTECTED] Sent: 2/9/01 8:45 PM Subject: Re[2]: [PHP-WIN] php ac

Re[2]: [PHP-WIN] php access query problem

2001-02-09 Thread Gonzalo Vera
At least in older versions of access it's better to enclose field names in square brackets, like "SELECT Location, [Dept ID], [Equip Type] FROM Equipment01 WHERE Location = '415C' AND [Equip Type] = 'C'" Also, shouldn't you end with a semicolon? The weird thing here is that it worked before. Sor