Fantastic! That was it... Thanks a lot, I really did not have my MySQL
Config on mind!!
Martin
On 9/25/07, noel guilbert <[EMAIL PROTECTED]> wrote:
>
> I think you have the "ansi quote" mode enable in mysql , so you can't use
> double quotes, because there are interpreted as a column. So, you m
I think you have the "ansi quote" mode enable in mysql , so you can't use
double quotes, because there are interpreted as a column. So, you must quote
your string literals with single quote. (see
http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html).
On 9/25/07, Martin Groh <[EMAIL PROTECTE
I've got another clue now.
when I replace the double quotes by single quotes everything works fine.
when I use
$sql="SELECT COUNT(*) AS level FROM text WHERE (text.TREE_LEFT < 2 AND
text.TREE_RIGHT > 5) AND text.SCOPE = '1'";
instead of
$sql='SELECT COUNT(*) AS level FROM text WHERE (text.TREE_
Hi Tristan,
that's pretty weird, this looks like valid sql to me. The rdbms you
> are using is mysql right ?
>
> Yes indeed, I'm using MySQL 5.0.15
While debugging everything looks nice to me until that row 552. ( $rs =
$stmt->executeQuery($sql); )
I can retrieve the root node and descendants but
hi,
On 9/25/07, Martin Groh <[EMAIL PROTECTED]> wrote:
> The $sql in getLevel() has the following value:
> SELECT COUNT(*) AS level FROM text WHERE (text.TREE_LEFT < 2 AND
> text.TREE_RIGHT > 5) AND text.SCOPE = "1"
> Has anybody got a clue for me?? I'd love to get this running...
that's pret
