hello together, I would like to sort the output from my table in ascending or descending order according to a field, is that possible?

Thank you very much! (ihr könnt auch deutsch zurückschreiben :) )

Thanks for quick answer!

Construction in your example - isn't work.

It's piece of template for catalog view what I use now in my catalog of collectible card's. It's work until I'm insert one else {joodb ifis|...} after first loop and {joodb endif} before second loop. Or until I try to complicate generation path to image with another ...ifis.

<...>

{joodb loop}

<...>
<td width="150"><img src="/images/mtg_pics/{joodb Set_name}/{joodb ifis|Tips}tip_{joodb endif}{joodb Language}{joodb ifis|Token}_tok{joodb endif}/small/{joodb Card_number_in_set}.jpg" border="0" width="150" style="border: 0pt none; float: left; margin-left: 5px; margin-right: 5px;" /></td>
<td valign="top">
<...>
{joodb loop}

<...>

sorry i was to lazy to implement real recursive routines but normally somethig like
{joodb ifis|field1}hello{joodb ifis|field2}world{{joodb endif}{joodb endif}
should work.

I will check it.

As you see at the example database, there are alternating row colours. If you add a {joodb loopclass} to a template it will insert a even and odd at the current position.

I dont know what kind of plugin you mean? Maybe a plugin which shows a single dataset in a normal content message.

Joodb is a very fresh project. We have con cvs for joodb until now because we want to have controll the process. However your suggestions and your code is welcome.

In the next week we will publish a bugyfix-release.

The next version 1.1 will include access control to the frontend views, a formview-template and some special fields like image-fields and a publish/unpublish field.

Hello!

Thanks for this plugin!

Small question: if  I use 2 or more {joodb ifis}...{joodb endif} constructions, nested one to another, the result is not that which is expected. Example: building path to the file from item name.

{joodb loop}{joodb ifis|Amount} //show item only if amount of em is not NULL

<.....>

//depending on props of item in table we build path to image

<.....>

{joodb endif}{joodb loop}

In the result of this cod we get page with unexpected result.

Maybe perhaps to add at next version the ability to specify in closer tag - what exactly it close?

Example: {joodb ifis|Number}......{joodb endif|Number}

Hi Dirk,

First of all I'd like to say great job, this is useful and you seem to be the only person to come up with this sort of extension.

You haven't replied to any posts in a while but I'm hoping you take a look at this one. First how come once we modify the demo the alternating row colors dissappear and it seems like there is nothing we can do about it. Is there a way to get aleternating row colors?

Also I would suggest that you give us the possiblity to add pbp code in a JooDB Component, this would make things very versatile, maybe a JooDB php plugin.

Regards & Thanks again

Hi again

I have not much an idea of what I've done but IT WORKS!!!

The problem is with the {joodb loop} statement that when you edit the editor moves it and screws everything up.

So you have to add this lines twice:

<tr>

<td valign="top">{joodb loop}</td>

</tr>

Hi

It happens the same to me. When I edit the database in joomla, even if I don't change anything but I save it, the front end shows nothing. I printed form phpmyadmin the fields before and after the saving and the field tpl_list changes a bit.

Maybe it's because these changes that it doesn't work?

Does anybody knows why the editor changes the field?

Thanks

First, GREAT component!

I have a filter set in the WHERE expression box in the menu parameters, but the results seem to die after the first query.  For example, I have in the WHERE box (userid = 144)

This returns only one row from the table for userid 144, even though there are 20 rows in the table.

Hi,

1. It's a great component! Thanks a lot!

2. It works perfect: I specify a table, make a link, and it's perfect.

HOWEVER

3. I then decide to edit the display template, or the key fields (the ones you choose at the beginning), I modify what I want, click save and then when I go to front-end it screwed :(

To be precise: I get the template, but no entries are displayed (limit set to default 20). No db connection errors, no php errors, nothing. Just as if the DB was empty... Now - WHY?

Editing the database entry doesn't influence it's ID in the jos_joodb table. However it does somehow change the link - how? Where? Looks like the template gets somehow ruined by WYSIWYG Editor...

Any help?

How can can I get alternating row colors like you have in your example?

I've tried everything so far.

Thank you

Hallo,

everything is working perfect until I make some changes in the template and want to save them, at this point I get an internal server error ( I get the same error when I use the apply or cancel button).

all the other components that I have installed are working fine, joodb is the only one with the internal server error.

how to solve this ?
by the way it is a great component for getting my data on the site

gretings,
Peter

www.paulvlaanderen.nl
( the dutch paul temple site)