Re: selectrow_array() problem....

...right syntax to use near 'and epoch ...
[download]

I don't see the string 'and epoch' in your SQL statement...?

Comment on Re: selectrow_array() problem.... Download Code

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”...	[reply]
Re^3: selectrow_array() problem.... (gratuitous parens in sql) by Anonymous Monk on Oct 29, 2013 at 23:18 UTC
...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	[reply] [d/l]