Re: [Arsperl-users] GetListEntry returns empty sometimes

[Vaughan, M. <Mar...@ca...>]

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: ars...@ar...
[mailto:ars...@ar...] On Behalf Of STAN HOLODNAK,
BLOOMBERG/ 731 LEXIN
Sent: Wednesday, October 11, 2006 8:59 AM
To: ars...@ar...
Subject: Re: [Arsperl-users] GetListEntry returns empty sometimes

I just added $ars_errstr to printout. I also indexed fields on which I
am=20
searching and I did not see an error yet, because  GetListEntry always
returned=20
something I guess. The response time for the query varies from 30
seconds to 200
 seconds. So this query

'%entries =3D ars_GetListEntry( $ctrl, $form, $qual , 0 , 0);' produces=20
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 =3D 'SWDRData') AND
(T431.C7 < 5)) AND (T431.C2 =3D 'nams')) ORDER BY 1 ASC
When I remove 'ORDER BY 1 ASC' clause it returns right away, but with
the=20
'ORDER' there are delays. I don't need 'ORDER BY 1 ASC', how can I
remove it?  =20
Also is there some kind of timeout for the function? -Stan

=20

            ----- 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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
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=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users