Forum: Software-Projekte der Mitglieder
by sippytom,
25. Mai 2015
Thanks, yes I think I will test various characters that I can set on the way to the database and reset on the way out.
Tom
Forum: Software-Projekte der Mitglieder
by sippytom,
25. Mai 2015
Hi,
Single quotes is how I had it before. Still with the error.
Maybe it has something to do with the transfer of data between zeos and the tunnel php file.
Tom
Forum: Software-Projekte der Mitglieder
by sippytom,
25. Mai 2015
Just did some tests and still got the error
DROP TABLE IF EXISTS nodes;
CREATE TABLE nodes (
node_id int,
parent_id int,
bez TEXT,
CONSTRAINT PK_nodes PRIMARY KEY (node_id),
CONSTRAINT FK_nodes_parent FOREIGN KEY (parent_id) REFERENCES nodes (node_id)
) ENGINE=InnoDB;
Forum: Software-Projekte der Mitglieder
by sippytom,
25. Mai 2015
Thanks, will do.
I was using the Delphi quotedstr function.
Will change to double quotes.
Tom
Forum: Software-Projekte der Mitglieder
by sippytom,
25. Mai 2015
Sorry for that.
Yes that is the code.
It seems as though the error is the ":" or "=" or the ";" which causes the error.
Tom
Forum: Software-Projekte der Mitglieder
by sippytom,
25. Mai 2015
Hi,
I am English so sorry I cannot ask this question in German.
I have tested your Zeos addition and am very happy.
One problem I have is in inserting some characters into a database.
Here is a demo from your program which will show the error.
INSERT INTO nodes VALUES (4, 2, 'AA:=1234; bbA');
The error occurs around the ":=".
Has this something to do with the way the data is sent to the...