You do not say how far you have got with the database interface: and outline
of your script would be helpful.
You probably realise you need to
1) connect to the database
2) prepare the select statement
3) execute the sstatement
4) loop round the rows until exhausted.
5) disconnect from the database (for tidiness)
Where are you stuck?
- Roger -
----- Original Message -----
From: "Derek Harding" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 9:35 AM
Subject: MS SQL Server access
> Hi,
>
> I wonder if anyone can help please.
>
> I need to retrieve data from a server running NT4SP5 MS SQL Server. The
> server is NTSERV (distinguished name NT SQL SERVER), the table is
data::stats
> and the fields are name, id, number, status so the select reads "SELECT
> name,id,number,status FROM data::stats WHERE status>0" This works fine
using
> the MS SQL Client on ither the server itself or from the web server "WEB".
>
> I have installed ActivePerl and the DBD stuff on WEB and all the tests run
> OK. Finally, I can create an html test page on the fly so the web server
> (also NT4 running IIS) can see and run the perl scripts.
>
> All I need to do is collect the data from the select statement (about 12
> rows) and display in simple columns with a little header. Do you think I
can
> get the data in!
>
> Ideas would be welcome; unfortunately I'm about 800 miles from the server
so
> I have to ftp the script onto the box, the manager there has to move it
into
> cgi-bin and then test it!
>
> --
> Best wishes,
> Derek Harding, (BA MIAP)
> ICT & Network Manager
> [EMAIL PROTECTED]
>
>
>
