Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • SQL Plugin setup

    Posted by sam_a

    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!

    Reads: 1683
    Posted by Damian Parker

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

    Damian


    Posted by sam_a

    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!