terryyan wrote:
HI,EVERYBODY!
I AM WRITING CGI WIHT C ,AND I WANT TO INSER A CHARACTER ARRAY INTO SQLITE
IN SENTENCE LIKE:
RC=SQLITE_EXEC(DB,"INSERT INTO MYTABLE VALUES('ARRAY_HERE')");
HOW CAN I DO ?
THANKS IN ADVANCE!
OS: LINUX
CGI: C
DATABASE: SQLITE
THE CHARACTERS IN THE ARRAY RECEIVED FORM UART.
--
View this message in context:
http://www.nabble.com/help%21%21-insert-array-into-sqlit--t1359589.html#a3642486
Sent from the SQLite forum at Nabble.com.
Use sprintf.
char sqst[256];
...
sprintf(sqst, "SELECT .... %s ....", your_char_array);
rc = sqlite_exec(db, sqst);
...