Sigh, that one is my bad, please ignore. Everything works as advertised.

Cheers!

-Boris

-- 
+1.604.689.0322
DeepCove Labs Ltd.
4th floor 595 Howe Street
Vancouver, Canada V6C 2T5

[EMAIL PROTECTED]

CONFIDENTIALITY NOTICE

This email is intended only for the persons named in the message
header. Unless otherwise indicated, it contains information that is
private and confidential. If you have received it in error, please
notify the sender and delete the entire message including any
attachments.

Thank you.

-----Original Message-----
From: Boris Popov [mailto:[EMAIL PROTECTED] 
Sent: Saturday, March 18, 2006 8:49 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] "bind or column index out of range" when using :AAA
notation?

In the following prepared statement,

SELECT * FROM STUFF WHERE ID = :2 OR ID = :17

Trying to determine index of ":17" via sqlite3_bind_parameter_index results
in 'bind or column index out of range' exception. Am I misreading the docs
again? ;)

Quote: "... one or more literals can be replace by a parameter "?" or ":AAA"
or "$VVV" where AAA is an alphanumeric identifier and VVV is a variable name
according to the syntax rules of the TCL programming language."

Any idea what am I doing wrong here?

Thanks!

-Boris

-- 
+1.604.689.0322
DeepCove Labs Ltd.
4th floor 595 Howe Street
Vancouver, Canada V6C 2T5

[EMAIL PROTECTED]

CONFIDENTIALITY NOTICE

This email is intended only for the persons named in the message
header. Unless otherwise indicated, it contains information that is
private and confidential. If you have received it in error, please
notify the sender and delete the entire message including any
attachments.

Thank you.

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to