i want to select from a PROGRESS 8.3a database via PHP on redhad linux 6.0/ODBC access. the PROGRESS Db resides on a WIN-NT 40server with open-link ODBC
usually thats not the problem but:
select * from orders where orderdate=$inputdate;
makes it to a problem. i dont know the correct syntax for the where clause when i use a datefield within. i tried some hardcoded things like
...where ..
..orderdate="05-10-2000"
..orderdate=#05.10.2000#" (=access-style)
..orderdate='05-OCT-2000' (ansii sql)
..orderdate=10/05/00 (hopless try)
but unfortunately nothing of them works... the range of error msgs are quite big:
..invalid datatypes,
..unknown variable after oderdate=
and so on
i hope anybody can help me!
horst
usually thats not the problem but:
select * from orders where orderdate=$inputdate;
makes it to a problem. i dont know the correct syntax for the where clause when i use a datefield within. i tried some hardcoded things like
...where ..
..orderdate="05-10-2000"
..orderdate=#05.10.2000#" (=access-style)
..orderdate='05-OCT-2000' (ansii sql)
..orderdate=10/05/00 (hopless try)
but unfortunately nothing of them works... the range of error msgs are quite big:
..invalid datatypes,
..unknown variable after oderdate=
and so on
i hope anybody can help me!
horst