I've had almost exactly the same problem - in access the query returns all
the fields that should be there, but use that SQL string in a php script and
I only get a few (or none) of the results.
I am not where the erroneous source is at the moment - I'll post it to the
list when I get there, but it is perplexing because I'm using the same code
as I've used elsewhere, of the form:
$res = odbc_exec ($connect, $query);
while (odbc_next_field [[or whatever]] ($res)) {
print (odbc_fetch ($res, "field"));
}
I've used this successfully in other situations, but I think the difference
here may be that it's accessing the mdb file through a shared drive. What's
even weirder is that I have a php script that I run standalone that queries
an access db through a shared drive and that works fine!
I am using php 4.0.4 (CGI) on win2k on IIS 5, so it doesn't seem to be an
apache problem.
I will send again when I have a better example of what I wrote.
Martin
> -----Original Message-----
> From: Nick Allen [mailto:[EMAIL PROTECTED]]
> Sent: 19 April 2001 1:13
> To: [EMAIL PROTECTED]
> Subject: Select statement not working
>
>
> Can't seem to troubleshoot this one...
>
> WinNT4.0
> PHP4.0.3 cgi
> Apache (latest)
>
> Code queries an Access database via ODBC and returns an empty dataset
> although there are definately records in there. Connection is fine - no
> errors and a valid connection handle is returned.
>
> echoing the query string to the page and then copying/pasting
> that directly
> into the sql edit section of the query builder in MSAccess works fine.
>
> Query is so simple it hurts:
>
> SELECT txtIntCategory FROM tblIntCategory;
>
> yet it returns *NOTHING*!!
>
> Identical Access query returns 8 string values.
>
> Any ideas or known bugs?
>
> TIA.
>
> Nick.
>
>
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
