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

Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r4 - 2006-12-19 - PeterThoeny
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.