Hi, no, you habe 13 placeholders and one string constant '?' on position 9. You do not need to include the ? in quotes if the value you want to bind is a string.
Martin hussainfarzana schrieb: > Yes,the SQL prepared statement has got 14 placeholders. > > The statement is "INSERT INTO CollDataNum > values(?,?,?,?,?,?,?,?,'?',?,?,?,?,?)" > > Regards, > Farzana. > > > SimonDavies wrote: > >> 2009/2/2 hussainfarzana <hussainfarz...@gmail.com>: >> >>> Dear All, >>> >>> We are working with SQLite Version 3.6.10. >>> We tried to insert or update the records in the database using >>> sqlite3_prepare and binding the values using sqlite3_bind functions.We >>> have >>> started with the index 1.We have a table with 14 columns and when we use >>> sqlite3_bind_int,for the first 13 columns its returning 0 and for the >>> last >>> 14th column which is also an integer datatype, but the function is >>> returning >>> value 25(SQLITE_RANGE) error. >>> >> Your table may have 14 columns, but has the SQL for your prepared >> statement got 14 parameter placeholders? >> >> >>> Please help us how to proceed further. >>> >>> Regards, >>> Farzana. >>> >> Rgds, >> Simon >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> > > -- * Codeswift GmbH * Traunstr. 30 A-5026 Salzburg-Aigen Tel: +49 (0) 8662 / 494330 Mob: +49 (0) 171 / 4487687 Fax: +49 (0) 12120 / 204645 engelsch...@codeswift.com www.codeswift.com / www.swiftcash.at Codeswift Professional IT Services GmbH Firmenbuch-Nr. FN 202820s UID-Nr. ATU 50576309 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
