code timing out on select from access

[Jeremy]

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);

%>

[Jeremy Zifchock]

Please disregard the var in front of the sqlText string...It isn't in
the code (thus isn't what is causing the problem)

Thanks again!




*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Aaron [SQL Server MVP]]

Why are you using DISTINCT? Are you really going to have a join that
produces duplicates? If so, why don't you have any primary keys?
[url]http://www.aspfaq.com/2509[/url]
[url]http://www.aspfaq.com/2504[/url]

Why are you using SELECT *?
[url]http://www.aspfaq.com/2096[/url]

Why are you using ODBC and a DSN?
[url]http://www.aspfaq.com/2126[/url]

Why are you using an explicit ADODB.Recordset object?
[url]http://www.aspfaq.com/2191[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"Jeremy" <jeremy_zifchock@yahoo.com> wrote in message
news:f9d85033.0407120540.2e8f01ed@posting.google.c om...

> 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);
>
> %>

[Bob Barrows [MVP]]

Jeremy wrote:

> 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?
>

>
> while (!rs.EOF) {
> var f1 = rs.Fields("Field1").value;
> var f2 = rs.Fields("Field2").value;
> var f3 = rs.Fields("Field3").value;
> }

You have an infinite loop. You left out the rs.moveNext(); statement in your
loop.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Jeremy Zifchock]

Thanks Bob!



*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!