>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
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
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
Access 2000 on IIS 4.0
"Gonzalo Vera" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
What DB are you using?
Gonzalo.
> I have the query
> $cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
> Equipment01 WHERE Location = '415C'");
> which r
What DB are you using?
Gonzalo.
> I have the query
> $cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
> Equipment01 WHERE Location = '415C'");
> which returns the proper results but when I add AND 'Equip Type' = 'C' to
> the end of it I get no results. Is my syntax corre
I have the query
$cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
Equipment01 WHERE Location = '415C'");
which returns the proper results but when I add AND 'Equip Type' = 'C' to
the end of it I get no results. Is my syntax correct? Thanks, Aaron
$cur= odbc_exec( $cnx, "S
