Select problem with Apache, php4.3 and Jet 4.0 via ODBC on Win 2k/xp

Hi,

This is my first posting to this list, I guess a small intro should be
first, been developing in PHP for sometime, mainly with Mysql and nearly
always on Windows (oops, sorry).

I have done some bizarre things with PHP, but now I am involved in
re-writing an application (from ASP.NET).

The database however I can't change so easily as there are other
dependancies, and it's JET 4.0

This is the table.
TableRowID - AutoNumber
UCID - Text
TransactionTime - Date/Time

etc...

I have having trouble with getting any information out of it though...!

I can complete the following:

$db_resource = new accessDB();
$db_resource->host=$dbDSN;
$db_resource->username=$dbUsername;
$db_resource->open($dbPassword);

// build option list based on the field names in the table. Query is run
to just get the fieldnames
$query='SELECT * FROM TransTable'

$db_resource->query($query);
$db_resource->get_field_names();



and although the fieldnames are returned through my function, if I try
to extract the data from the query none is there...


if I add a where statement I get an error which I can't resolve:

SELECT * FROM TransTable WHERE ((TransactionTime>="2005-12-16 16:00:01")
AND (TransactionTime<="2005-12-21 16:00:00")) ORDER BY TableRowID

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access
Driver] Too few parameters. Expected 2., SQL state 07001 in
SQLExecDirect in c:\apache group\apache\htdocs\wmmc\db_access_class.inc
on line 58



ideas?

Thanks in advance

Richard

Re: Select problem with Apache, php4.3 and Jet 4.0 via ODBC on Win 2k/xp

"Richard Morton" wrote in message
news:OZwpf.48347$uR.12605@newsfe7-gui.ntli.net...
> Hi,
>
> This is my first posting to this list, I guess a small intro should be
> first, been developing in PHP for sometime, mainly with Mysql and nearly
> always on Windows (oops, sorry).
>
> I have done some bizarre things with PHP, but now I am involved in
> re-writing an application (from ASP.NET).
>
> The database however I can't change so easily as there are other
> dependancies, and it's JET 4.0

mysql.com has their MySQL Migration Toolkit for Access databases. pretty
slick at converting them.

>
> This is the table.
> TableRowID - AutoNumber (auto_increment in MySQL)
> UCID - Text
> TransactionTime - Date/Time
>
> etc...
>
> I have having trouble with getting any information out of it though...!
>
> I can complete the following:
>
> $db_resource = new accessDB();
> $db_resource->host=$dbDSN;
> $db_resource->username=$dbUsername;
> $db_resource->open($dbPassword);
>
> // build option list based on the field names in the table. Query is run
> to just get the fieldnames
> $query='SELECT * FROM TransTable'
>
> $db_resource->query($query);
> $db_resource->get_field_names();
>
>
>
> and although the fieldnames are returned through my function, if I try to
> extract the data from the query none is there...

That statement really makes me want to see your function, because I suspect
you are trying to do something you can't do with a database resource. if
you are returning it, try returning a reference instead of the object
itself. I suspect the object is being destroyed after the end of the return
and possibly the connection is being closed because the local copy on the
stack is gone when the function finishes, and a copy is returned? I could
be wrong (someone correct me). I'm just making a guess.
can you do your processing within the function if nothing else works?

and... are you wanting to return the field names, or $db_resource? you
can't do anything without that, can you?

>
>
> if I add a where statement I get an error which I can't resolve:
>
> SELECT * FROM TransTable WHERE ((TransactionTime>="2005-12-16 16:00:01")
> AND (TransactionTime<="2005-12-21 16:00:00")) ORDER BY TableRowID
>
> Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver]
> Too few parameters. Expected 2., SQL state 07001 in SQLExecDirect in
> c:\apache group\apache\htdocs\wmmc\db_access_class.inc on line 58

Bizarro.

>
>
>
> ideas?
>
> Thanks in advance
>
> Richard