Re: [mdb-dev] An Example SQL (2)

[Peter S. <pet...@wa...>]

Le Jeudi 19 Juin 2003 19:16, Carlos Arias a =E9crit :
> Hi Adam and other ,
>
>     Yes of course,  you are right,  the same happens  in my
> Linux+PHP4+unixODBC+mdbtools. is it a bug?
>     I 've installed the last version of all needed soft.
>     I 've tried to solve this and i haven't had any data from tables
> when i try to use the "WHERE" clause.
>     Then i execute "SELECT * FROM table" and they export the data to
> postgreSQL (all all all data).
>     This solves half of my problems.
>     But, fun haven't finished.
>     One of the tables has only one column of type date/time and when i
> try to read this table again, any response from php, in my netscape
> browser "The document contains no data".
>      This is horrible, i don't know what to to.
>     Has anyone any idea to solve this trouble?
>     can mdbtools read one table with one colum of type date/time?
>     can mdbtools use the "WHERE" clause?
> Could someone help me?
> Any help will be wellcome.
>
> Regards.

Hello,
Yes, mdbtools knows to read day-time colums of access97 and access 2000.
There is another problem I think.
You told from import to postgr=E9 and then reading with php if I understo=
od=20
well.
I don't know postgr=E9,
but I tried importing in mysql and read that mysql understand only=20
date-time-values in
year-month-day (yyyy-mm-dd hh:mm:ss) format, whereas mdbtools exports in =
the=20
format given by the database (my tries where with german date formats).
My idea is (when I'll have time) to write a script which changes the date=
=20
formats before importation in another database.

I think there is still some work to do for mdbtools but it seems to be th=
e=20
only serious project trying to read and export datas from MS-Access direc=
tly=20
in Linux. So I will write a postcard to the developper Brian Bruns. I wou=
ld=20
like to help more but I don't know enough :-)

Regards
peter
--=20
Peter Stopschinski
pet...@wa...