Need help with SQL query please

Permanently deleted user

December 23, 2014 10:33

My workflow contains a form that prompts the user for a liber and folio which are returned from the form as strings varLiber and varFolio. My parcel layer contains 2 integer fields (LIBER, FOLIO) that I need to query using these 2 pieces of information retrieved from the user.

I tried this syntax in my query task's WHERE clause to no avail:

"LIBER = ('" + varLiber.ToString() + "') AND FOLIO = ('" + varFolio.ToString() + "')"

The workflow bombs once the query task starts returning Error: Unhandled exception: 'One or more errors occurred.' in activity '1.74: QueryTask'.

I use this WHERE clause syntax with success when the fields I'm querying are string fields but in this case they are stored as integer fields in my parcel layer and that seem to be my problem. How do I need to modify my where clause to work? Any help is appreciated.

Incidentally, I can successfully query my parcel layer from the ArcGIS Server Services directory using the syntax LIBER = 1289 AND FOLIO = 302  in the WHERE column.

0

• 

  Permanently deleted user

  December 24, 2014 02:41

  and did you try:

  "(LIBER = " + varLiber + ") AND (FOLIO = " + varFolio + ")"

  Regards

  Ralph

  PS you should probably set the correct timezone for Maryland in your Forum Profile

  0
• 

  Permanently deleted user

  December 30, 2014 03:26

  Many thanks, Ralph. The WHERE clause syntax you supplied is just what I needed.

  Regards, 

  Erick

  0

Please sign in to leave a comment.