|
|
Posted by Richard Morton on 12/19/05 13:39
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
Navigation:
[Reply to this message]
|