No, we are actually filling in the parameter with a valid integer value. I
was just trying to say it was a parameter.
>
> Are you actually searching for records where F is the string "?"
>
> If so, why don't you try WHERE F="?" instead of leaving it with the
> ? unquoted.
--
"Mark Brown" <[EMAIL PROTECTED]> wrote:
> Hi-
>
> We have a query that is failing with SQLite error code 10:
>
> SELECT A, B, C, D, E, F, G
> FROM Table1
> WHERE F=?
> ORDER BY E
>
> but succeeds when the ORDER BY clause is removed.
>
> This database does not have any indicies on any of the
Mark Brown wrote:
> Hi-
>
> We have a query that is failing with SQLite error code 10:
>
> SELECT A, B, C, D, E, F, G
> FROM Table1
> WHERE F=?
> ORDER BY E
>
> but succeeds when the ORDER BY clause is removed.
>
> This database does not have any indicies on any of the tables. Is this why
3 matches
Mail list logo