I really don't mean to be a jerk, but this does seem to be really off topic for this mailing list. Isn't the concatination of two string a general C/C++ question rather then a sqlite question? Don't you think you might be better off asking this question on a C/C++ mailing list or forum, maybe somewhere like http://www.codeguru.com?
As to stay close to the topic [sqlite], aka that of general sql, I would HIGHLY recommend looking at this link: http://en.wikipedia.org/wiki/SQL_injection And finally to stay on topic [sqlite], don't do what you are trying to do, use a prepared statement and bind your variables to the prepared statement to prevent sql injection. Sam 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 > email@example.com > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users