database1Add my vote for this tag create new tag
, view all tags
I'm looking for some guidance/suggestions here. I need to create a web-based database-backed inquiry/editing system. I had started down that path using HTML::Template, DBD, DBI:Oracle, and HTML::Form. At the same time, various departments in my company started pushing for an Intranet. Luckily, I stumbled onto TWiki. TWiki looks like it will solve most of the Intranet requirements.

Where I'm looking for suggestions in, is in integrating the web-based app on top of TWiki. I realize that I can just put links and forms into my own CGI scripts that perform all the work, however, I'd like to provide tighter integration with TWiki. The ability to design forms as rapidly as I'm rolling out pages under TWiki would be a big plus. I have glanced at the DatabasePlugin, and need to start experimenting with it, but I don't think it will solve my overall problem.

For instance, I'd like to setup a search screen that would query the database (a la QBE) and return a set of rows. Allow the user to drill down into detail based on the response. But, I'd also like to preserve the TWiki interface (templates, TextFormattingRules, etc) as well as the formatting facilities. My first stumbling block is what to set my FORM ACTION= value. Like I said, I realize that I can do a "/cgi-bin/MyScript" but I'm looking for tighter integration with TWiki. I don't see anything in PlugIns that will let me process the ACTION.

Does this make any sense? Thanks in advance,

-- DavidMurray - 16 Apr 2002

One thing you can do as go to the view script, with CGI parameters that a plugin can pickup. The plugin can be invoked by a %PluginVar% on the specific page you chose to view. For example, I have a page on my company's TWiki that shows a users details and photo from an LDAP server. Details:

end of URL that allow viewing of a database entry - bin/view/People/PersonDetails?userGdsUid=winigera
variable in PersonDetails that shows the details - %GDS{uid="%URLPARAM{"userGdsUid"}%"}%

A pretty neat way of doing things. I still think we might need a more general case of a script in bin that hands over to a plugin for rendering, but the above is usually good enough.

-- JohnTalintyre - 17 Apr 2002

Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r3 - 2008-09-17 - TWikiJanitor
  • 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-2018 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.