Loading...
 
Architecture / Installation

Architecture / Installation


SQL Plugin setup

posts: 47

Hi - In 1.8, I'm trying to setup the SQL plugin, but can't for the life of me get it working. I'm on a Dreamhost server. My understanding is 1.8 already has the plugin installed, and only requires DSN setup.

Setting up the DSN, I followed the instructions for 1.7.5 to a tee.

Then I inserted the syntax, per the plugin instructions page, to a wikipage.

Nothing...

I'm a TWiki convert, and had no problem getting sql queries setup over there. Did I miss a configuration setup with 1.8 tikiwiki?

Thx!

posts: 2881 United Kingdom

When you setup the DSN did you also give the group the permission to use than new DSN?

Damian


posts: 47

Yes, that did it ! Got it working.

FOLLOWUP QUESTION: is there a way to select a single database field with sql, WITHOUT having the results formatted in a table?

I see it's easy to select a field, and get its contents formatted IN a table. However, I'd like to query just the contents of a single field, in order to use the text results as part of a URL.

Thanks again!


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting