On Thu August 7 2003 12:54, Truong Manh Cuong wrote:
> I try to create table in dialup_admin/sql directory, and it come to fail.
> ERROR: parser: parse error at or near "("
> and dialup_admin will not work with database fields in lower case. because
> of query sentence like this: SELECT UserName,AcctStopTime ... FROM..WHERE
> UserName ..
> and the result of that query sentence will differ to SELECT
> username,acctstoptime ... FROM..WHERE username ..
hmm. They are sql tables for MySQL, not Postgres. I have not used dialup_admin
before, but I will take a look at it.
> If all database is in lower case, I must change all code (PHP file) in
> dialup_admin. do you understand ?
This should not be the case. Have you tested this? Postgres is case
insensitive by default, and should work with FieldName as well as fieldname
in a SQL query.
Please confirm if you have actually tested this.
--
Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
