I was doing testing on a query today and it suddenly stopped returning any
results. Each time I would run the query it would return no records. I ran
it from the console utility and from a web page using ASP with the same
result. I also ran it from a GUI windows client (DBTools) with the same
result. I had been doing some script work and accidentally wrote something
that stuck in an infinite loop prior to the query stopping. When I went to
the server it had a "low on virtual memory" message so I assumed that the
two were connected. I rebooted the server and it still refused to return
records. At that point I did a simple SELECT * FROM tablename in the console
and it DID return records. Frustrated, I tried my original query it and it
would then return records. Since that time I have tried, without success, to
re-create the event. Any ideas? I posted my setup and the query below.
This is what was called from the ASP page:
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT
r.recID,r.recFlagged,r.recChannel,r.recBegin,r.recEnd,r.recFile FROM
recordings AS r WHERE ((r.recBegin BETWEEN '" & dtmSearchBegin & "' AND '" &
dtmSearchEnd & "') OR (r.recEnd BETWEEN '" & dtmSearchBegin & "' AND '" &
dtmSearchEnd & "')) AND (r.recChannel " & intSearchChannel & ") ORDER BY r."
& strSearchOrderBy & " LIMIT " & intSearchRowBegin & ", " & intSearchRowMax
objRS.Open strSQL, objConn
- MySQL
- MyODBC
- Windows 2000 SP2
- Active Server Pages (ASP)
Please reply to my e-mail address..thanks!
Jeff Phillips
[EMAIL PROTECTED]
VoiceLogger, Inc.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
