Invalid Sub Query

[Jared Ritchey]

I'm getting a notification / error when a query value has parentheses
in the Raleigh Market.

The query is for a select list of cities where one of the cites
available is; Willow Spring (s) and I think it expects the (s) to be
part of a sub query which it is not.

The query looks like;
(20=Angier,Apex,Rolesville,Roxboro,Sanford,Siler
City,Smithfield,Southern Pines,Wendell,Willow Spring (s),Wilson)

[W Bowley]

try escaping them. ie: \(s\)

> --
> You received this message because you are subscribed to the Google Groups "PHRETS" group.
> 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.
>

[Jared Ritchey]

Hello, yeah I tried that and still get something along the lines of a missing close parenthesis on subquery error.

[W Bowley]

Based on the RETS spec, you may need to make the value a string literal:

string-literal ::= " 1*( *( PLAINTEXT except " ) *( 2 * " ) *(
PLAINTEXT except " )) "

So, try putting it inside of double quotes and see if that works.

[Jared Ritchey]

Yep! that one goes into my snippet library of things to remember, that worked and the rest is script related which I can deal with.
Thanks sincerely;

[W Bowley]

Glad I could help. Good luck with the rest of it.