Categories > TinyButStrong general >

How can I, in joomla, pass parameters with a link to a new page to modifiy sql?

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: eugeni
Date: 2010-03-02
Time: 00:09

How can I, in joomla, pass parameters with a link to a new page to modifiy sql?

I have an article with a table with a field that is a link that should call another article that, depending on the value of the field linked, modify the WHERE in the sql.

Let's say that the first list in the first article is for countries and each country should open the same article but the sql should have "SELECT ... WHERE country = parameter" that comes from the other page.

Did I explain myself?

If I add a parameter in url, joomla doesn't find the page like:
http://localhost/euros/index.php?option=com_content&view=article&id=16&Itemid=35&country=13

I've tryed the POST method without exit (maybe I didn't really know what I was doing...

Any other idea?

Thanks
By: Skrol29
Date: 2010-03-03
Time: 00:10

Re: How can I, in joomla, pass parameters with a link to a new page to modifiy sql?

Hi Eugeni,

Joomla should find an article when you add extra custom parameters in the URL. I've tested it and it worked for me with Joomla 1.5. Your URL should work.
By: eugeni
Date: 2010-03-04
Time: 22:27

Re: How can I, in joomla, pass parameters with a link to a new page to modifiy sql?

Hi thanks  and sorry for the delay, but I could not connect before. Today I've tried again to add new parameters to url and it worked! suprise! I've tried that before and did not worked!

By the way, I'm trying to insert a checkbox into the template, I copy the examples from the manual adapting the fields but the editor doesn't recognize the sentence and marks me an error and does not let me close the window.

<td><input name="tinc" type="checkbox" value="1" [m.tinc;if [val]=1; then 'checked="checked"'; else  ' '] /></td>

Actually, the editor marks me in red (error) after de "then" and until the "/>" of the input.

What I'm doing wrong? I search in the forums and internet and seems nobody else has this problem!!! The sql works, the field exists...

Thanks
By: Skrol29
Date: 2010-03-05
Time: 00:37

Re: How can I, in joomla, pass parameters with a link to a new page to modifiy sql?

Hi Eugeni,

What editor makes you this error?
By: eugeni
Date: 2010-03-05
Time: 00:42

Re: How can I, in joomla, pass parameters with a link to a new page to modifiy sql?

I've done it with TinyMCE, JCE 1.5.6 and XStandard Lite 2.0
I try also the if condition to display the number of records and it doesn't work either.

I mean, without the <input...>, it doesn't give me that error but does not make any case on the if:

<p>[m.#;if [val]=0; then ''; else 'Es mostren [m.#] monedes.']</p>
By: Skrol29
Date: 2010-03-06
Time: 00:50

Re: How can I, in joomla, pass parameters with a link to a new page to modifiy sql?


You can try this syntax in order to have no error with the editor:
<input name="tinc" type="checkbox" value="1" />[m.tinc;if [val]=1;then 'checked';else '';att=checked;magnet=#]
It uses parameter "att" which is able to move the TBS fields and replace an XML/HTML attribute.


By: eugeni
Date: 2010-03-06
Time: 04:09

Re: How can I, in joomla, pass parameters with a link to a new page to modifiy sql?

You're fantastic!!! it's impossible for me to imagine how you get to know this, because it's not in any manual and forums!

Thank you very much!!

And of course: It worked!