
January 4th, 2001, 02:13 PM
|
|
Member
|
|
Join Date: Dec 2000
Location: Ft. Lauderdale, FL, US
Posts: 29
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
you can use server-side JScript, although this, i'm pretty sure, is only supported by iis. this is how you accomplish it anyways;
<%@Language="JScript"%>
<%
var sqlbeg = "SELECT * FROM sbc WHERE disp = 'F00' AND rec_uid IS NULL";
var aconn = Server.CreateObject("ADODB.Connection");
var recset = Server.CreateObject("ADODB.Recordset");
aconn.Open("DSN=ACUSQL_SBC;UID=sbc;PWD=sbc;");
recset.Open(sqlbeg, aconn, 3, 3);
%>
you just change the dsn and other jive to that of your oracle db.
|