Hi,
I have written the following code for Apache::ASP under Windows XP, Apache
1.3.23 using Activestate Perl 5.6. Everything seems to be working correctly
except two things. The DSN dsn_graphics is set up with mySQL for Windows
NT/2000.
1. The Apache server starts eating up all the processor time on my machine
after the initial hit to this page.
2. How do I access the recordsets Fields properties???
Any help will be greatly appreciated.
Thanx,
William J. Gannon
The Beacon Group, Inc.
---------------------------------------------
<% $conn = $Server->CreateObject('ADODB.Connection');
$rec = $Server->CreateObject('ADODB.Recordset');
$conn->ConnectionString ('DSN=dsn_graphics;UID=;PWD=;');
$conn->Open;
$rec->Open ('select * from sizes order by picref', $conn);
%>
<html>
<head>
<title>Test</title>
</head>
<body>
<center><h1>Apache DB Test</h1></center>
<hr>
<% while ( !$rec->EOF ) {
$fld = $rec->Fields('picref');
print "$fld<br>";
$rec->MoveNext;
}
if ($rec) {
$rec->Close;
$rec = undef
}
if ($conn) {
$conn->Close;
$conn = undef;
}
%>
<hr>
</body>
</html>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
