perl 5.8 CGI DBM Oracle and ?



Hello,

I need to run a basic sql, query select "5 colums" from db.table where
columnx = 123.
Need to present this data to the user in html scrolling list (because
there might be hundreds of rows).
I guess there must be an easish way of doing this as perl 5.8 is quite
modern.
Please can someone suggest the best modules to include to achieve this
and some pointers to for further research + any hints that spring to
mind?

Also I need to make a row clickable so as to display the rest of the
fields, (50ish!). But that should be easy if I have the right tools
installed and used for the initial retrieval - I hope.

Thnx in advance

J

.



Relevant Pages

  • Re: query enhancement
    ... The query, as it now stands, tests for the presence of 'null' in one ... select countfrom tableX where columnX IS NULL; ... Presuming you have an index this may produce an index fast full scan ...
    (comp.databases.oracle.server)
  • Re: query enhancement
    ... The query, as it now stands, tests for the presence of 'null' in one ... select countfrom tableX where columnX IS NULL; ... Presuming you have an index this may produce an index fast full scan ...
    (comp.databases.oracle.server)
  • Query and relationships
    ... The first table (table1) has four colums A, B, C and D. ... When i create a query, i get more than 10 records. ... it more difficult to idenitfy the problem. ...
    (microsoft.public.access.queries)
  • Re: How do I get the query to display?
    ... I would like it to display 2 colums and 3 rows, the subject colum containing multiple lines. ... A query is not going to format your results nicely so, but a report could. ...
    (microsoft.public.access.queries)
  • Re: Eliminating Duplicate Items in a Query
    ... Have you set the Unique Values property of your query? ... Jeff Boyce ... Has several colums one of which can contain duplicate names, ... Named product. ...
    (microsoft.public.access.queries)