>From the point of view of a C question, make your array of characters large enough to hold the characters you want (and terminating null) before copying them in.
>From the point of view of an SQL: if you want to change the comparison constant in a where clause, look up bind parameters. read through http://www.sqlite.org/c3ref/bind_blob.html There are lots of examples on the list of binding. regards, Adam On Fri, Jul 9, 2010 at 3:06 PM, rollerueckwaerts <rollerueckwae...@gmx.net>wrote: > > Hello, > I try to get an sql query string from 2 const chars. > > const char *language; > language = "'6'"; > const char *sql2 = "SELECT key,name,text FROM uebersetzungen WHERE > sprach_id > = "; > > const char *sql = strcpy(sql2,language); > // or > const char *sql = "SELECT key,name,text FROM uebersetzungen WHERE sprach_id > = " + language; > //or > const char *sql = "SELECT key,name,text FROM uebersetzungen WHERE sprach_id > = " & language; > > > nothing works :) > > How can i do this ? > > Hoping for help :) > tobi > > -- > View this message in context: > http://old.nabble.com/concat-2-const-chars---tp29121393p29121393.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
