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 <[email protected]>
At: 10/10 7:53:36
Stan,
In the "bad" cases, what is in $ars_errstr?
Cheers
Richard.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of STAN HOLODNAK,
BLOOMBERG/ 731 LEXIN
Sent: 10 October 2006 10:31
To: [email protected]
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
[email protected]
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/arsperl-users
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Arsperl-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/arsperl-users
