Time Out Error
From: larry (anonymous_at_discussions.microsoft.com)
Date: 04/21/04
- Next message: Steve Kass: "Re: want to see duplicates INNER JOIN"
- Previous message: AshleyT: "want to see duplicates INNER JOIN"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 10:31:13 -0700
I am getting an error on an ASP page that does a simple
update to a single row in a table. The SQL statement is:
UPDATE tblRecHead SET Qty = 1 WHERE SeqNum = 123 and
LineNumber = 12
The ASP page will time out and return an error. If I
change the SQL to:
UPDATE tblRecHead SET Qty = 1 WHERE SeqNum = 123 and
LineNumber = 12 and 1 = 0
Obviously, nothing is updated, but the SQL is executed
without a problem. If I attempt to update the record in
QA, using the first SQL statement, it works fine. There
is an index on SeqNum,LineNumber.
Another thing to note is that a select is done prior to
this and it returns data. Also, if I convert the first
SQL statement to
SELECT * FROM tblRecHead WHERE SeqNum = 123 and
LineNumber = 12
This returns one row.
Any ideas anyone?? Any help will be appreciated.
Larry...
- Next message: Steve Kass: "Re: want to see duplicates INNER JOIN"
- Previous message: AshleyT: "want to see duplicates INNER JOIN"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
- Re: Formatierungsproblem
... > Wie soll denn so ein EIN SQL Statement aussehen? ... > IE Schwierigkeiten
bei der Darstellung und schließlich auch bei der ... ja nie welchen Browser der User hat,
wie er diesen konfiguriert hat usw. ... > Ich sollte wirklich versuchen alles mit ASP
zu managen. ... (microsoft.public.de.inetserver.iis.asp) - Re: System.Data.SqlClient.SqlException: Subquery returned more than 1 value.
... I noticed after I posted that the group was .asp not aspnet, ... >> following
SQL statement. ... >> INSERT INTO OrderItems (ClientID, ProductID, OrderHeaderID,
Quantity, ... >> Dim conn As New System.Data.SqlClient.SqlConnection ... (microsoft.public.inetserver.asp.db) - RE: Is this correct syntax for OLE DB for ODBC parameter query?
... (Just a brief review of that SQL statement) ... You may have more information
from ASP .NET team. ... data showing up in the second list when the page loads or
I make a selection ... (microsoft.public.data.odbc) - Re: Time Out Error
... > update to a single row in a table. ... > The ASP page will time
out and return an error. ... > QA, using the first SQL statement, it works fine. ...
(microsoft.public.sqlserver.programming) - Re: Random sort via SQL in ASP
... and I will be calling this recordset in a SQL statement from ... randomize from
ASP? ... I'd write some code that you can trigger that puts a random ...
number in a field (e.g. sortfield as long) in the table. ... (comp.databases.ms-access)
