Query with sysid range giving me 0 result

[sarwar]

Hi, 

I have tried to fetch all the data from rets server. But I'm facing some problem, As long as rets no longer support offset so I fetch the all sysid first then I put some range with sysid and trying to fetch the data. but it not working 

$class = 1;

$limit = 1000;

$query = "(sysid=62203534+)"; // where this id is the lowest one

$search = $rets->SearchQuery("Property", $class, $query, array('Limit' => $limit, 'Format' => 'COMPACT-DECODED', 'Count' => 1));

ERROR I'm getting: 

Array
(
    [type] => rets
    [code] => 20201
    [text] => No Records Found Reference ID: 1f7eec32-e113-4e20-ba67-1264c7d25028
)

OR if i put $query = "(sysid=62203534-62203595)";

Its showing me only 2 result and rest of item between this not showing 

But if i put $query = "(sysid=0+)";

It work

Can you please help me I need to fetch all the result between two sysid.

Thanks in advanced 

[David Kullmann]

Maybe that field isn't numerical so it's giving you odd results. What is the field definition?

David Kullmann

--
You received this message because you are subscribed to the Google Groups "PHRETS" group.
To view this discussion on the web visit https://groups.google.com/d/msg/phrets/-/Wc2BAdrf2GAJ.
To post to this group, send email to phr...@googlegroups.com.
To unsubscribe from this group, send email to phrets+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/phrets?hl=en.

[sarwar]

Hi David, 

The field is Int(10) and i think it should work for range. I don't know why it won't. 

Thanks

Sarwar

To unsubscribe from this group, send email to phrets+unsubscribe@googlegroups.com.

[W Bowley]

Have you tried:

$query = "(sysid=62203500+)";

See if you get anything from that

>> phrets+un...@googlegroups.com.

>> For more options, visit this group at
>> http://groups.google.com/group/phrets?hl=en.
>

> --
> You received this message because you are subscribed to the Google Groups
> "PHRETS" group.
> To view this discussion on the web visit

> https://groups.google.com/d/msg/phrets/-/RcDH_dNlJvkJ.

> To post to this group, send email to phr...@googlegroups.com.
> To unsubscribe from this group, send email to

> phrets+un...@googlegroups.com.