Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-11 Thread Lloyd Thomas
September 10, 2006 1:32 PM Subject: Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program On Sun, 10 Sep 2006 13:02:58 +0100, you wrote: Thanks Teg, I have been trying to do using a basic example but still running into problems. Can you expand a little more on your example below. This is where

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-10 Thread Lloyd Thomas
details.cidn[0] = 0; details.cidt[0] = 0; strcpy(details.term, ""); break; default: // Any thing else ?? break; } break; - - Original Message - From: <[EMAIL PROT

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-10 Thread tls
On Sun, 10 Sep 2006 13:02:58 +0100, you wrote: >Thanks Teg, > I have been trying to do using a basic example but still >running into problems. Can you expand a little more on your example below. >This is where I am so far. >I am getting a bit closer bit still getting some errors. clearly I am st

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-10 Thread Lloyd Thomas
ntf(stderr, "SQL error: %s\n", zErrMsg); sqlite3_free(zErrMsg); } sqlite3_close(db); --- Lloydie T - Original Message - From: "Teg" <[EMAIL PROTECTED]> To: "Lloyd Thomas" Sent: Sunday, September 10, 2006 12:47 AM Subject: Re[2]: [sqlite

Re[4]: [sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Teg
LT> ^^ LT> sql = "insert into call_data(direction, LT> call_time)values('details.inout','details.statime)" LT> Do you have any ideas? LT> Lloydie T LT> - Original Messa

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Lloyd Thomas
all_time)values('details.inout','details.statime)" Do you have any ideas? Lloydie T - Original Message - From: "Teg" <[EMAIL PROTECTED]> To: "Lloyd Thomas" Sent: Sunday, September 10, 2006 12:47 AM Subject: Re[2]: [sqlite] A lillte help addi

Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Teg
bel appears here LT> make: *** [logger.o] Error 1 LT> -- LT> line 609 = LT> sql = "insert into call_data (direction, call_time, dest, trunk_no, LT> file_name)values('"+details.inout+"','"+details.statime+"&#x

Re: [sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Mark Richards
+"','"+details.cidn+"'"+details.channel+"','"+details.filename+"')"; - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: Sent: Saturday, September 09, 2006 11:16 PM Subject: Re: [sqlit

Re: [sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Lloyd Thomas
(direction, call_time, dest, trunk_no, file_name)values('"+details.inout+"','"+details.statime+"','"+details.cidn+"'"+details.channel+"','"+details.filename+"')"; - Original Message - F

Re: [sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Jay Sprenkle
On 9/9/06, Lloyd Thomas <[EMAIL PROTECTED]> wrote: I know nothing of C++ and therefore need a lilte help editing a C++ app to insert some records into a database. here's an example to read from a database. If you build the sql like you're doing and you use it on the web you leave yourself open

Re: [sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Mark Richards
Maybe. Here's what I do (in c). DoSql() is a wrapper function. I've included a callback function (and associated structure) below it. The call is made thusly: static char cData[1024]; char query[255]; snprintf(query, QUERY_SIZE, "SELECT * FROM inikeys WHERE inisection = \"%s\" AND ini

[sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Lloyd Thomas
I know nothing of C++ and therefore need a lilte help editing a C++ app to insert some records into a database. This is where I am so far #include sqlite *db; //insert record into database db=sqlite_open("/var/tmp/logger/database/logger.db",