Database where join in element with {$my->id}

[JeroenJ]

???
Hi,
I have a problem with creating a form where two elements are dropdowntables. They are limited by a join to an other table. They have to show a column from that other table as possible options. The only rows that need to be shown are the rows that are added to that table by the current logged in user. This is saved in the vriendboerid column of the other table.

I'm using Joomla 1.0.12 - fabrik1[1].0.4_upgrade_from_1.0.x--07-06-2007.zip (started with 1.0.3) on Windows.
I don't know the PHP and MySQL versions.

What did I do:
- Created the element
- Element type: Database join
- Render join as dropdown list
- Selected the correct database, table, keycolumn and value column
- and added the SQL where statement: where vriendboerid='{$my->id}' (also tried: where vriendboerid={$my->id})
- But I don't get any results. (With the quotes I get an empty list, without the quotes I get an error message)
- vriendboerid contains the userid of the users who created that row.

What an I doing wrong?

 

[rob]

Hi Jeroen

You're not doing anything wrong, this is a bug, which I have just fixed in the SVN - revision 70.
Details of how to check out the code from the SVN are here:

http://fabrikar.com/index.php?optio...wForm&Itemid=27&fabrik=30&rowid=10&tableid=29

 

[JeroenJ]

Hi Rob,

I got al the latest SVN code (91 I think) and indead the where join worked!! Thanks!!, but when I tried to create a new table I got an error. I first thoight it was a problem in my environment so I completely recreated my dev enviroment but it still gives the error. How do I install:
- Windows XP
- Uniform Server 3.3 (With Apache and MySQL)
- Install Joomla 1.0.12
- Install Fabrik 1[1].0.4b--07-06-2007 (also tried 1.0.3)
(If I test this to do new table it all works)
- Copy the components\com_farbik dir administrator\components\com_fabrik to the same on my website.
- If a say table-new it give a java scripting error (element missing)

Please help?

thanks

 

[andrelewis]

Is this a javascript error in your browser? If so what browser version are you using?

Either way could you post the error?

Andre

 

[JeroenJ]

Hi Andre,

sorry for the late response: Yes it is a javascript error in the browser:
- Using IE 6.0.2900
- Error is:
Line 1017
Char: 1
Error: Object expected
Code: 0
URL: http://localhost/administrator/index2.php?option=com_fabrik&task=edit2Table&cid=1

Hope it helps?
Is switching to Firefox an option?

 

[andrelewis]

Yes, you should try it on Firefox, but the error will probably still be there. You might be able to get farther on firefox. The developers just changed the javascript libraries to use MooTools, and they might have missed something.

There is a new patch up in the downloads section, I would try that first.

I would let them know about this bug in a new post, if It still exists in the new patch.

Andre

 

[JeroenJ]

Hi Andre,

I have tried it with firefox and it seems to be working. I'm not getting the pre-filters to work with
{$my->id} yet, but I have to do some more testing. The where join is working!!

I'll try to new patches also. THANKS!!