Invalid query: Parse error near 'Judy' (line 1, position 120).

Page 1 of 1

1 Replies - 467 Views - Last Post: 17 December 2012 - 11:48 AM

#1 charlo  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 13-December 12

Invalid query: Parse error near 'Judy' (line 1, position 120).

Posted 17 December 2012 - 11:39 AM

i have this query and am getting an error that i do not understand could someone help me identify the problen

https://www.googleapis.com/fusiontables/v1/query?sql=SELECT Name, Telephone_, Identifica, Registrati, Area_Hecta\
   FROM '+tablename+' WHERE Name="Judy Cherono Sang"&key=AIzaSyBu97VIKhFxNM9ypQAZ0k_hVUyj4HT5DNo&callback=?';

This post has been edited by Dormilich: 17 December 2012 - 11:44 AM
Reason for edit:: fixed code tags

Is This A Good Question/Topic? 0
  • +

Replies To: Invalid query: Parse error near 'Judy' (line 1, position 120).

#2 Dormilich  Icon User is offline

  • 痛覚残留
  • member icon

Reputation: 2936
  • View blog
  • Posts: 7,690
  • Joined: 08-June 10

Re: Invalid query: Parse error near 'Judy' (line 1, position 120).

Posted 17 December 2012 - 11:48 AM

there is no position 120 in the line given. you may have omitted other crucial code to understand the problem.

nevertheless, it may simply be a quote nesting problem as the string given uses both ' and " in some kind of string definition context.
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1