Stan, You can use ars_GetListSQL and do the query directly to the DB, but have to know exactly which table.
Hope that helps, Mark Vaughan Comcast Cable Corporation 720.268.8591 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of STAN HOLODNAK, BLOOMBERG/ 731 LEXIN Sent: Wednesday, October 11, 2006 8:59 AM To: [email protected] Subject: Re: [Arsperl-users] GetListEntry returns empty sometimes 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=DEVDE V _______________________________________________ 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=DEVDE V _______________________________________________ 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 ------------------------------------------------------------------------- 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
