Re: [Arsperl-users] GetListEntry returns empty sometimes
Brought to you by:
jeffmurphy
Menu
▾
▴
Re: [Arsperl-users] GetListEntry returns empty sometimes
|
From: STAN H. B. 7. L. <sch...@bl...> - 2006-10-11 15:14:21
|
I just added $ars_errstr to printout. I also indexed fields on which I am
searching and I did not see an error yet, because GetListEntry always returned
something I guess. The response time for the query varies from 30 seconds to 200
seconds. So this query
'%entries = ars_GetListEntry( $ctrl, $form, $qual , 0 , 0);' produces
this query
that's the one SELECT T431.C1,T431.C1,C536871066,C536871068,C60
0000200,C536870935,C8,C7,C536870953,C536870924,C536871044,C53687
0937 FROM T431 WHERE (((T431.C600000200 = 'SWDRData') AND
(T431.C7 < 5)) AND (T431.C2 = 'nams')) ORDER BY 1 ASC
When I remove 'ORDER BY 1 ASC' clause it returns right away, but with the
'ORDER' there are delays. I don't need 'ORDER BY 1 ASC', how can I remove it?
Also is there some kind of timeout for the function? -Stan
----- Original Message -----
From: Richard Hellier <ars...@ar...>
At: 10/10 7:53:36
Stan,
In the "bad" cases, what is in $ars_errstr?
Cheers
Richard.
-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of STAN HOLODNAK,
BLOOMBERG/ 731 LEXIN
Sent: 10 October 2006 10:31
To: ARS...@AR...
Subject: [Arsperl-users] GetListEntry returns empty sometimes
I have a script (daemon) that runs GetListEntry every 10 minutes. LAtely
I've
noticed that at times GetListEntry returns empty despite of the form having
data
for that qualification. What is the reason for that? -Stan Holodnak
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users
|
