Ilias Lazaridis wrote:
> I've integrated the AutoNav macro into a plugin, see:
..
> If a wiki-page is called "Project", the query returns all pages which
> contain "Project", but in _any_ context.
...
> A query should look only for _real_ entries, such as [wiki:Project] ?
>
> So this addition should do the work:
>
> if isCamelCase(thispage):
>     search = thispage
> else:
>     search = 'wiki:" + thispage
>
> is there such a function "isCamelCase"?

ok, this is solved:

http://dev.lazaridis.com/base/changeset/60

but would still like to know what this SQL does:

> Additionally, I'm not familar with SQL, and am wondering about the
> query (especially the .version and .name). Can possibly someone
> explain?
>
> "
> 49            SELECT w1.name
> 50            FROM wiki w1,
> 51                (
> 52                    SELECT name, MAX(version) AS version
> 53                    FROM wiki
> 54                    GROUP BY name
> 55                ) w2
> 56            WHERE
> 57                w1.version = w2.version AND
> 58                w1.name = w2.name AND
> 59                w1.text LIKE \'%%%s%%\'
> 60            ORDER BY w1.name""" % thispage
> "


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/trac-users
-~----------~----~----~----~------~----~------~--~---

Reply via email to