Tags:
create new tag
, view all tags

Question

I am able to SELECT data from my MySQL db using DBIQueryPlugin, %DBI_QUERY{}%, but I was wondering how I can manipulate the data (e.g., use if-else statements) to only display the data that I want to display.

Environment

TWiki version: TWikiRelease04x00x02
TWiki plugins: DefaultPlugin, EmptyPlugin, InterwikiPlugin
Server OS: RedHat Linux 7.5 kernel 2.7.3
Web server: Apache 3.0
Perl version: 5.8.7
Client OS: MS Windows XP
Web Browser: firefox 1.5.0.3
Categories: Plugins

-- JulietHabberstandish - 30 May 2006

Answer

You should ask this question directly in the Dev topic for the plugin (DBIQueryPluginDev).

From the sound of your question I'd say you would probably have the easiest time doing the filtering in the SQL statements, but various TWiki mechanisms can be applied also. Remember to ask your question in as much detail as possible.

-- SteffenPoulsen - 16 Jun 2006

- I see you already did that smile

-- SteffenPoulsen - 16 Jun 2006

Sorry, closing after 30 days...

-- PeterThoeny - 19 Dec 2006

 
Topic revision: r4 - 2006-12-19 - PeterThoeny
 
Twitter Delicious Facebook Digg Google Bookmarks E-mail LinkedIn Reddit StumbleUpon    
  • Download TWiki
TWiki logo Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2012 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.