Beefy Boxes and Bandwidth Generously Provided by pair Networks RobOMonk
laziness, impatience, and hubris
 
PerlMonks  

Re: selectrow_array() problem....

by runrig (Abbot)
on Oct 29, 2013 at 17:06 UTC ( #1060181=note: print w/ replies, xml ) Need Help??


in reply to selectrow_array() problem....

...right syntax to use near 'and epoch ...
I don't see the string 'and epoch' in your SQL statement...?


Comment on Re: selectrow_array() problem....
Download Code
Re^2: selectrow_array() problem....
by CWJ (Initiate) on Oct 29, 2013 at 20:13 UTC

    That’s my point, as is typical these days the error message is quoting back the statement with a rough indication of where the syntactical problem occurs, the problem being that the syntax quoted back in the error message (which is syntactically incorrect) is not the one passed to selectrow_array(), i.e. the original SQL reads “where epoch” but the error being generated by the db engine appears to have received a statement which instead reads “and epoch”...

      ...CWJ ... and epoch ... CWJ...

      Try adding gratuitous () around parts, each and every, like  where(  (   (le)(ft) )  and (mi(dd)le) and (ri(g)ht)  ) )

      Chances are the error will become obvious, or the error message will improve

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1060181]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (20)
As of 2014-04-17 16:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (453 votes), past polls