Shouldn't this be:

$query = qq/Attatchment 1 != $NULL$/;

$schema = "PagerNotification";

($q = ars_LoadQualifier($c, $schema, $query)) || die "Unable to load $ars_errstr";

 

Just a thought,


Rusty



----- Original Message ----
From: Thomas Worth <[EMAIL PROTECTED]>
To: ARSperl User Discussion <arsperl-users@arsperl.org>
Sent: Wednesday, October 18, 2006 5:55:53 AM
Subject: Re: [Arsperl-users] Regarding ars_LoadQualifier

Hi Vinod,

 

I’m not sure you can do this.  You could never use a function in the Run If part of a filter or Active Link, so I don’t believe you would be able to use it in a Load Qualifier either.

 

You would probably need to set a hidden field using the length function via workflow and then use that field in your qualifier.

 

Regards,

 

Thomas Worth

 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of vinod kumar
Sent: Wednesday, October 18, 2006 3:54 AM
To: arsperl-users@arsperl.org
Subject: [Arsperl-users] Regarding ars_LoadQualifier

 

Hi,

 

Can any one help me out in the following scenario?

 

I need to retrieve rows from a table, where the data in a column length is greater than 4

How can I use length function in ars_LoadQualifier.

 

I am using the following

 

$schema = "PagerNotification";

($q = ars_LoadQualifier($c, $schema, "\"Attachment 1\" !=  \"NULL\"")) || die "Unable to load $ars_errstr";

 

Above is retrieving all the records from PagerNotification form

 

How can I use length function in ars_LoadQualifier.

 

 

With Regards,

Vinod.R

 

 

-------------------------------------------------------------------------
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
Arsperl-users@arsperl.org
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
Arsperl-users@arsperl.org
https://lists.sourceforge.net/lists/listinfo/arsperl-users

Reply via email to