Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

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...?

Replies are listed 'Best First'.
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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1060181]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (2)
As of 2018-05-28 04:33 GMT
Find Nodes?
    Voting Booth?