topic Re: Error due to less than or equal (<= symbol) in query in ArcGIS Viewer for Flex Questions

Error due to less than or equal (<= symbol) in query

PierreLarondelle — Wed, 06 Mar 2013 20:17:33 GMT

Hello,

I've tried the following query in Flash Builder 4.6 : <esri:Query id="query1FR" where = " pw_fre <= '{qText2FR.text}' " which causes an error while compiling with a warning message telling that the value of atribute "where" associated to an element type "esri:query" must not contain the character '<'

How do I query properly in Flex using operators "<" and "<=" , can anybody show me how to do it the right way ?
Thanks already,
Pierre

Re: Error due to less than or equal (<= symbol) in query

AnthonyGiles — Wed, 06 Mar 2013 20:23:30 GMT

Pierre,

If you want to use < or > than you need to use:

< or >

Other wise the xml thinks you are closing or creating another tag

Regards

Anthony

Re: Error due to less than or equal (<= symbol) in query

AnthonyGiles — Wed, 06 Mar 2013 20:50:08 GMT

Pierre,

Ignore my post above that relates to using the greater than and less than symbols in an xml config. You should be able to use the <=, your problem maybe that you are trying to do a less than or equal to against a text input.

Regards

Anthony

Re: Error due to less than or equal (<= symbol) in query

PierreLarondelle — Wed, 06 Mar 2013 20:55:13 GMT

Anthony, thanks for the quick reply but I don't use an external XML config. The faulting query code is written in a Flash Builder mxml module within the <fx : Declarations> tag.

Pierre

Re: Error due to less than or equal (<= symbol) in query

AnthonyGiles — Wed, 06 Mar 2013 21:03:42 GMT

Pierre,

I'm not in front of a system to check but try something like:

pw_fre <= {Number(qText2FR.text)}

Regards

Anthony

Re: Error due to less than or equal (<= symbol) in query

PierreLarondelle — Wed, 06 Mar 2013 21:04:29 GMT

Anthony, the TextInput catch a date (dd/mm/yyyy) as value for querying. What I try to do is to retrieve all dates that are <= than the date entered in the TextInput.

Pierre

Re: Error due to less than or equal (<= symbol) in query

RobertScheitlin__GISP — Wed, 06 Mar 2013 21:05:32 GMT

Pierre & Anthony,

mxml is still xml and you still need to escape the < and >

Re: Error due to less than or equal (<= symbol) in query

PierreLarondelle — Wed, 06 Mar 2013 21:06:23 GMT

Ok Anthony, I will try your code and will let you know what happened.
Thanks.

Pierre

Re: Error due to less than or equal (<= symbol) in query

PierreLarondelle — Wed, 06 Mar 2013 21:08:23 GMT

Thanks for your reply too Robert, I will modify with both your advices.

Pierre

Re: Error due to less than or equal (<= symbol) in query

AnthonyGiles — Wed, 06 Mar 2013 21:31:45 GMT

Pierre,

You may better off setting your where clause and the expression in the actionscript instead of the mxml. Have a look at ths older post from Robert where he help someone else out with querying dates:

http://forums.esri.com/Thread.asp?c=158&f=2421&t=278917

Regards

Anthony

Re: Error due to less than or equal (<= symbol) in query

PierreLarondelle — Thu, 07 Mar 2013 06:38:53 GMT

Anthony and Robert thanks a lot for your help !

The query works perfectly with the < and > escaping. Nevertheless, I'm trying to follow the best practices and will move the queries to the actionscript from now as suggested.

Have a nice day,
Pierre

Re: Error due to less than or equal (<= symbol) in query

AnthonyGiles — Thu, 07 Mar 2013 15:05:54 GMT

Pierre,

Please do not forget to mark the post as answered.

Regards

Anthony

Re: Error due to less than or equal (<= symbol) in query

PierreLarondelle — Fri, 08 Mar 2013 10:43:00 GMT

Sorry Anthony, thanks for doing it. Won't forget the closing mark next time.
Regards,
Pierre.

topic Re: Error due to less than or equal (<= symbol) in query in ArcGIS Viewer for Flex Questions

Error due to less than or equal (&lt;= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Re: Error due to less than or equal (<= symbol) in query

Error due to less than or equal (<= symbol) in query