Re: [sqlite] Error Message near ".": syntax error

2011-10-09 Thread Simon Slavin

On 10 Oct 2011, at 2:06am, James Brison wrote:

> Very embarrassing ... I had a typo after doing a copy & paste.
> 
> Thanks All!

No problem.  We'd rather have a problem we can solve than one we can't.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Error Message near ".": syntax error

2011-10-09 Thread James Brison
Very embarrassing ... I had a typo after doing a copy & paste.

Thanks All!





From: Simon Slavin <slav...@bigfraud.org>
To: James Brison <rman...@yahoo.com>; General Discussion of SQLite Database 
<sqlite-users@sqlite.org>
Sent: Saturday, October 8, 2011 7:06 PM
Subject: Re: [sqlite]  Error Message near ".": syntax error


On 9 Oct 2011, at 2:28am, James Brison wrote:

> I am receiving the following error message when running a query against a 
> sqlite db:
> 
> Error Message near ".": syntax error
> 
> What does this mean? and how do I debug it?  I'm new to sqlite and don't 
> understand the 'near'.  Is it saying that I have syntax error somewhere 
> involving '.'?

In your SQL command you have a '.'.  Either that dot, or very soon after it, is 
a character that SQLite doesn't know what to do with.  If you can't figure it 
out, post the command and we'll tell you.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Error Message near ".": syntax error

2011-10-08 Thread Simon Slavin

On 9 Oct 2011, at 2:28am, James Brison wrote:

> I am receiving the following error message when running a query against a 
> sqlite db:
> 
> Error Message near ".": syntax error
> 
> What does this mean? and how do I debug it?  I'm new to sqlite and don't 
> understand the 'near'.  Is it saying that I have syntax error somewhere 
> involving '.'?

In your SQL command you have a '.'.  Either that dot, or very soon after it, is 
a character that SQLite doesn't know what to do with.  If you can't figure it 
out, post the command and we'll tell you.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Error Message near ".": syntax error

2011-10-08 Thread Mr. Puneet Kishor

On Oct 8, 2011, at 8:28 PM, James Brison wrote:

> I am receiving the following error message when running a query against a 
> sqlite db:
> 
> Error Message near ".": syntax error
> 
> What does this mean? and how do I debug it?  I'm new to sqlite and don't 
> understand the 'near'.  Is it saying that I have syntax error somewhere 
> involving '.'?
> 


Wouldn't it have been super-easy to actually show us your query? How can anyone 
divine what is wrong when no knows what your query is. You are likely missing a 
comma, or have an extra space... please resend with the actual query that 
causes the above error.

--
Puneet Kishor

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Error Message near ".": syntax error

2011-10-08 Thread James Brison
I am receiving the following error message when running a query against a 
sqlite db:

Error Message near ".": syntax error

What does this mean? and how do I debug it?  I'm new to sqlite and don't 
understand the 'near'.  Is it saying that I have syntax error somewhere 
involving '.'?

Thanks
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users