Data Connection in Global.asa -- useful??

[GailS]

I am setting up an Intranet site to display product
specifications housed in several SQL (7.0) tables. The
website is hosted by IIS 4.0, NT4.0 SP6 server. I'm
working with FP2002, SP3.

I got a standard "Results" page to display in table view,
so my connection is working. I'm not sure this feature of
FP will be adequate to my needs, and am not sure how to
access the application connection string created in the
global.asa file for use in my own asp scripts. Typically,
I would set up an ADO connection in a server-side include
file for this purpose. I used FP to design the page
template, and figured I would have to hand code the script.

Specifically, I need to pull a recordset from a SQL view
that I created pulling data from two or more tables. The
FP database wizard only allows me to select a table from
my database to display. Can I modify the SQL query to use
a view? I would also like to manipulate the display of the
record into more of a "page-type" display, to include the
picture referenced by only a file name in the table,
depending on the value of some fields, various text will
be displayed, etc.

The FP Database results format seems rather rigid, or
perhaps I just haven't worked with it enough. Any thoughts
or advice? Thanks.

 

[Kevin Spencer]

the FrontPage Database components can do some of the simplest and most
typical things that are done with databases. If you want to write your own
ASP solution, I would suggest leaving FrontPage's DRW out of the picture
altogether. You could use the Connection String it creates in the
global.asa, I suppose.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.