Backward slash (\) problem

In this forum all bug reports concerning the 6.x branch will be gahtered. You have the possibility to track the bug fix process.

Moderators: EgonHugeist, mdaems

danielweinmann
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 13.11.2006, 13:18

Backward slash (\) problem

Postby danielweinmann » 13.11.2006, 13:30

Hi folks! I have the following situation:

Unless I have stored in the database field double backwards slashes, TZQuery will return no \'s at all in myQuery.FieldByName('mycolumn').AsString...

Ex.:
Content of "mycolumn" stored in the database: "\\server\html\index.html" -> myQuery.FieldByName('mycolumn').AsString returns "\serverhtmlindex.html"

...is anybody facing the same problem? People from Zeos Team is aware of this? Is there any solution?

My systems wont work if this is not working.

Thanks in advance,
Daniel Weinmann

barko
Senior Boarder
Senior Boarder
Posts: 51
Joined: 07.09.2005, 13:13

Postby barko » 13.11.2006, 22:55

it works for me on firebird-1.5 and latest zeosdbo (testing branch) from svn, lazarus, fpc, linux

danielweinmann
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 13.11.2006, 13:18

Postby danielweinmann » 14.11.2006, 12:42

Ops...I forgot to tell I am using PostgreSQL.
I've tryed with PostgreSQL 8.2 and 7.1.2.

Both of them wont work.

Does anybody know a possible solution?

Thanks in advance,
Daniel Weinmann

danielweinmann
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 13.11.2006, 13:18

Postby danielweinmann » 14.11.2006, 13:01

...I did make it work now...but...

it is only working when I set myTZConnection.Protocol to "postgresql-7", even if I am using PostgreSQL 8.2.

I've tryed with myTZConnection.Protocol = "postgresql" and myTZConnection.Protocol = "postgresql-8". And it really only works with "postgresql-7" protocol.

Is it a bug or is it normal?

Thanks!

Daniel Weinmann

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 14.11.2006, 14:58

What did you change to make it work? So we can maybe find out why it doesn't work in postgresql-8. Problem looks Postgres-related.

Mark

danielweinmann
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 13.11.2006, 13:18

Postby danielweinmann » 14.11.2006, 15:36

The only thing I did was changing myTZConnection.Protocol from "postgresql" to "postgresql-7". I also tryed to change it to "postgresql-8", but it didn't work.

I think it is PostgreSQL related, indeed. But I believe it is a PostgreSQL X Zeos 6.6.0beta issue, cause with older versions of Zeos (5.3.4) it was working fine...

...thanks a lot.

Daniel Weinmann

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 22.11.2006, 09:49

Hi Daniel,
This proves it's a postgresql-8 driver error (postgresql defaults to postgresql-8 )
Probably we'll have to wait for a developerusing Postgres-8 to fix this. (I'm a mysql-addict 8) ) I'll do a quick diff to see if I can find it, but don't count on it.

Mark

cnliou
Zeos Dev Team
Zeos Dev Team
Posts: 31
Joined: 11.11.2005, 12:18

Re: [bug_report] Backward slash (\) problem

Postby cnliou » 12.12.2006, 17:00

danielweinmann wrote:Content of "mycolumn" stored in the database: "\\server\html\index.html" -> myQuery.FieldByName('mycolumn').AsString returns "\serverhtmlindex.html"

I just tried "/branches/testing" revision 188 but did not see this problem.

I used postgresql-8 and saved string "C:\\a\b\c.txt" in varchar column and successfully retrieved the same string from it.

String "\\a\b\c.txt" is good, too.

Regards,
CN

User avatar
fduenas
Zeos Dev Team
Zeos Dev Team
Posts: 132
Joined: 26.08.2005, 08:12
Location: Cancún

Postby fduenas » 27.12.2006, 03:37

Hi danielweinmann:

What version of zeoslib are you using?
Always try to use latest version from here.

Currently it is 6.6 beta


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 1 guest