Forums

Version 2 RC1.
Connections from previous version. Install was smooth and didn't have to use the tables backup.

I used, as a link to a second connection, where the id filtered the query to one row the next code"

index.php?option=com_chronoconnectivity&connectionname=single_event&id={id}

.

Now I get sql error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}' at line 1 SQL=SELECT count(*) FROM jos_cb_events WHERE `id`={id}You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}' at line 1 SQL=SELECT count(*) FROM jos_cb_events WHERE `id`={id}You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}' at line 1 SQL=SELECT count(*) FROM jos_cb_events WHERE `id`={id}

Any idea?
Thanks, Emanuel.

Maybe relevant: the $row object doesn't exists anymore... I try to print_r it - nada.
Did you changed the array variable name?

Hi menchee,

I'm afraid this is a question for Max; he's made some fundamental changes to ChronoConnectivity and I don't know how the upgrade is supposed to work.

Bob

Thanks Bob.

Meanwhile I had some direct correspondence with Max.

a) $row become $MyRow so an example code will be

<?php echo $MyRow->id; ?>

b) After playing around, I found that the link it self, as I wrote it - works. The problem is with the WHERE section of the connection form. This one doesn't accept (yet) the {id}, so at least for now I put there

WHERE id = <?php echo $_GET['id']; ?>

Again, thank you all for the important extension and for your dedicated support.

Emanuel.