code timing out on select from access
From: Jeremy (jeremy_zifchock_at_yahoo.com)
Date: 07/12/04
- Next message: Jeremy Zifchock: "Re: code timing out on select from access"
- Previous message: David: "Re: problems connecting to database from outside."
- Next in thread: Jeremy Zifchock: "Re: code timing out on select from access"
- Reply: Jeremy Zifchock: "Re: code timing out on select from access"
- Reply: Aaron [SQL Server MVP]: "Re: code timing out on select from access"
- Reply: Bob Barrows [MVP]: "Re: code timing out on select from access"
- Messages sorted by: [ date ] [ thread ]
Date: 12 Jul 2004 06:40:08 -0700
I am getting a timeout error and I'm not sure why. I have not called
any data from a form on either post or get...(do I need to?) Any Idea
why it isn't working and how to fix it?
Thanks in advance!
Here is my entire code:
<%@LANGUAGE="JAVASCRIPT"%>
<%
var conn = Server.CreateObject("ADODB.Connection");
var rs = Server.CreateObject("ADODB.Recordset");
var sqlText = "SELECT DISTINCT Table1.*, Table2.* FROM Table2 INNER
JOIN Table1 ON Table2.Unm = Table1.Unm WHERE Table1.Field1 =
'something'";
conn.Open("DSN=photo");
rs.Open(sqlText,conn);
while (!rs.EOF) {
var f1 = rs.Fields("Field1").value;
var f2 = rs.Fields("Field2").value;
var f3 = rs.Fields("Field3").value;
}
rs.Close();
conn.Close();
Response.write (f1 + " " + f2 + " " + f3);
%>
- Next message: Jeremy Zifchock: "Re: code timing out on select from access"
- Previous message: David: "Re: problems connecting to database from outside."
- Next in thread: Jeremy Zifchock: "Re: code timing out on select from access"
- Reply: Jeremy Zifchock: "Re: code timing out on select from access"
- Reply: Aaron [SQL Server MVP]: "Re: code timing out on select from access"
- Reply: Bob Barrows [MVP]: "Re: code timing out on select from access"
- Messages sorted by: [ date ] [ thread ]