using of [[SQL(select * from bar)]]

[didley@…]

Hi,

it's me again. Thanx I could download your egg and it's already installed. see it under Plugins and it's enabled.

But I get the message

Error: Macro SQL(SELECT summary FROm ticket) failed
no such table: ticket

I want read your example of your hompage but there is an error no SubWiki ...

Have I to announce my trac that the sql statemant should use the trac.db?

[Jason Trahan]

I get the same thing. It's acting like its not talking to the right database.

[James Mills]

Replying to didley@gmx.de:

Hi,

Hi again :)

it's me again. Thanx I could download your egg and it's already installed. see it under Plugins and it's enabled.

But I get the message

Error: Macro SQL(SELECT summary FROm ticket) failed
no such table: ticket

I want read your example of your hompage but there is an error no SubWiki ...

Have I to announce my trac that the sql statemant should use the trac.db?

Oh I do apolagise. I did not include an example of how to configure the plugin. If you look in the Web Admin under trac.ini configuration tool.

You need a section like this:

[sqlquery]
uri=oracle://tamsd:tamsd@tams/

I'll include an example on the wiki page here at TH.

Also, do you have pymills installed ? It uses this to connect to:

• SQLite
• MySQL
• Oracle

--JamesMills