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

2006-09-11 Thread Lloyd Thomas 
I am still having some problems compiling my code. I suspect it maybe 
something to do with my app not linking (ld) with sqlite libraries, but I do 
not know how to do this or it could be something else.

Can you advise?
-
/usr/src/logger-1.2-beta3/src/logger.cpp:731: undefined reference to 
`sqlite3_open'
logger.o(.text+0xc99):/usr/src/logger-1.2-beta3/src/logger.cpp:732: 
undefined reference to `sqlite3_exec'
logger.o(.text+0xcae):/usr/src/logger-1.2-beta3/src/logger.cpp:735: 
undefined reference to `sqlite3_free'
logger.o(.text+0xcbf):/usr/src/logger-1.2-beta3/src/logger.cpp:737: 
undefined reference to `sqlite3_close'

collect2: ld returned 1 exit status
make: *** [logger] Error 1



- Original Message - 
From: [EMAIL PROTECTED]

To: sqlite-users@sqlite.org
Sent: Sunday, 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 I am so far.
I am getting a bit closer bit still getting some errors. clearly I am still
getting something wrong with the format of snprintf. any ideas?


Hello Lloydie

If you use a MS Compiler like VC++ 6 or VC++ 7 Net you can look at
my HP. There is a little Example and a Wrapperclass simple to
understand, desgined to handle small Databases.

http://www.thlu.de

Best Regards
Thomas


-
To unsubscribe, send email to [EMAIL PROTECTED]
-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

2006-09-10 Thread Lloyd Thomas 

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 still 
getting something wrong with the format of snprintf. any ideas?

errors:
logger.cpp: In function `void* start_one_channel(void*)':
logger.cpp:607: error: invalid conversion from `const char*' to `size_t'
logger.cpp:607: error:   initializing argument 2 of `int snprintf(char*, 
size_t, const char*, ...)'

logger.cpp:629: error: jump to case label
logger.cpp:603: error:   crosses initialization of `char*zErrMsg'
make: *** [logger.o] Error 1
---

code:-
char *zErrMsg = 0;
   char *sql;
   int rc;
   sqlite3 *db;
   snprintf(sql, insert into call_data (direction, call_time, dest, 
trunk_no, file_name)values(\'%s\',\'%s\',\'%s\',\'%s\',\'%s\'), 
details.inout, details.statime,details.cidn, 
details.channel,details.filename);//line 607
   rc = sqlite3_open(/var/tmp/logger/database/logger.db, db); //line 
608

   rc = sqlite3_exec(db, sql, NULL, 0, zErrMsg);
   if( rc!=SQLITE_OK ){
   //fprintf(stderr, SQL error: %s\n, zErrMsg);
   sqlite3_free(zErrMsg);
   }
   sqlite3_close(db);
---

Lloydie T


- Original Message - 
From: Teg [EMAIL PROTECTED]

To: Lloyd Thomas sqlite-users@sqlite.org
Sent: Sunday, September 10, 2006 12:47 AM
Subject: Re[2]: [sqlite] A lillte help adding sqlite to a c program



Hello Lloyd,

You need to escape the quotes. Remember in C and C++  means the
beginning or end of a literal string so, when you want to embed quotes
in a string you have to escape them. Probaby \.

You'd be better off using the paramaterized version of the SQL

std::string sql = insert into call_data (direction, call_time, dest, 
trunk_no,

file_name)values(?,?,?,?,?);;

Then bind the actual parameters after the fact.

C


Saturday, September 9, 2006, 7:02:43 PM, you wrote:

LT Jay, Thanks for your reply.
LT I gave it a try with and got a few errors. as follows
LT ---
LT logger.cpp:609: error: invalid operands of types `const char[80]' and
LT `char[4]' to binary `operator+'
LT logger.cpp:615: error: `t' was not declared in this scope
LT logger.cpp:615: warning: unused variable 't'
LT logger.cpp:634: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:637: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:638: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:639: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:641: error: `t' was not declared in this scope
LT logger.cpp:641: warning: unused variable 't'
LT logger.cpp:664: error: jump to case label
LT logger.cpp:621: error:   crosses initialization of `bool Loop'
LT logger.cpp:634: warning: destructor needed for `test2'
LT logger.cpp:634: warning: where case label appears here
LT logger.cpp:634: warning: (enclose actions of previous case statements
LT requiring destructors in their own scope.)
LT logger.cpp:637: warning: destructor needed for `test2'
LT logger.cpp:637: warning: where case label appears here
LT logger.cpp:638: warning: destructor needed for `test2'
LT logger.cpp:638: warning: where case label appears here
LT logger.cpp:639: warning: destructor needed for `test2'
LT logger.cpp:639: warning: where case label 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+','+details.cidn+'+details.channel+','+details.filename+');







LT - Original Message - 
LT From: Jay Sprenkle [EMAIL PROTECTED]

LT To: sqlite-users@sqlite.org
LT Sent: Saturday, September 09, 2006 11:16 PM
LT Subject: Re: [sqlite] A lillte help adding sqlite to a c program



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 to sql injection attacks. Using the bind

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 still 
getting something wrong with the format of snprintf. any ideas?

Hello Lloydie 

If you use a MS Compiler like VC++ 6 or VC++ 7 Net you can look at
my HP. There is a little Example and a Wrapperclass simple to
understand, desgined to handle small Databases. 

http://www.thlu.de

Best Regards
Thomas


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

2006-09-10 Thread Lloyd Thomas 

Nearly there just a couple of outstanding issues any help apreciated

Error:--
make: Warning: File `logger.cpp' has modification time 45 s in the future
g++  -c -Wall -O -g logger.cpp -o logger.o
logger.cpp: In function `void* start_one_channel(void*)':
logger.cpp:607: warning: format argument is not a pointer (arg 6)
logger.cpp:629: error: jump to case label
logger.cpp:603: error:   crosses initialization of `char*zErrMsg'
make: *** [logger.o] Error 1



code sample:---
char *zErrMsg = 0;
   char sql[200];
   int rc;
   sqlite3 *db;
   sprintf(sql, insert into call_data (direction, call_time, dest, 
trunk_no, file_name)values('%s','%s','%s','%s','%s'), details.inout, 
details.statime,details.cidn,channel,details.filename);

   rc = sqlite3_open(/var/tmp/logger/database/logger.db, db);
   rc = sqlite3_exec(db, sql, NULL, 0, zErrMsg);
   if( rc!=SQLITE_OK ){
   //fprintf(stderr, SQL error: %s\n, zErrMsg);
   sqlite3_free(zErrMsg);
   }
   sqlite3_close(db);
   LOGIT([%02d] sql string = %s\n,channel,sql);


 // Clear out details ready for next call
 details.inout[0] = 0;
 details.filename[0] = 0;
 details.statime[0] = 0;
 details.endtime[0] = 0;
 details.cidn[0] = 0;
 details.cidt[0] = 0;
 strcpy(details.term, );
   break;

default:  // Any thing else ??
 break;

}
break;
-


- Original Message - 
From: [EMAIL PROTECTED]

To: sqlite-users@sqlite.org
Sent: Sunday, 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 I am so far.
I am getting a bit closer bit still getting some errors. clearly I am still
getting something wrong with the format of snprintf. any ideas?


Hello Lloydie

If you use a MS Compiler like VC++ 6 or VC++ 7 Net you can look at
my HP. There is a little Example and a Wrapperclass simple to
understand, desgined to handle small Databases.

http://www.thlu.de

Best Regards
Thomas


-
To unsubscribe, send email to [EMAIL PROTECTED]
-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[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.h

sqlite *db;


 //insert record into database
 db=sqlite_open(/var/tmp/logger/database/logger.db, 0, NULL);
 query = insert into call_data;
 query += (direction, call_time, dest, trunk_no, file_name)values(;
 query += 
'details.inout','details.statime','details.cidn','details.channel','details.filename;

 sqlite_exec(db, query, NULL, NULL, NULL);
   sqlite_close(db);
--

Can someone tell me if I am going in the right direction. Sorry for being so 
lazy,but I need to get something working quick.


Lloydie T 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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 inikey = \%s\ ,section,key);

  if (!DoSql(query, sql_inirecord_callback, nDoSqlTimeout))
  {
FORMAT_TRACE(ERR_DEBUG,aem.db temporarily locked by another 
process.  Cannot continue);

return();
   }




int DoSql(char *query, int (*callback) (), int nRetrySeconds)
{
int nResult=0;
nSQLRetry=0;
char *cError;
db=sqlite_open(/var/tmp/solarwave/aem.db, 0, NULL);
sqlite_busy_timeout(db,1000);

printf(DoSql gets query=-%s-\n,query);

while (nSQLRetry=nRetrySeconds)
{
nResult=sqlite_exec(db, query, callback, NULL, cError);
if (nResult==SQLITE_BUSY || nResult==SQLITE_LOCKED)
{
if (nSQLRetry==0)
printf(Sleeping );
else
printf(.);
sleep(1);
++nSQLRetry;
continue;
}
if (nSQLRetry0)
printf(\n);
break;
}

if (nResult==SQLITE_BUSY || nResult==SQLITE_LOCKED)
{
FORMAT_TRACE(ERR_CRIT,DoSql: aem.db temporarily locked by 
another process.  Cannot continue);

free(cError);
sqlite_close(db);
return(false);
}

if (!(nResult==0))
{
FORMAT_TRACE(ERR_CRIT,DoSql: query %s returned error %s. 
Cannot continue,query, cError);

free(cError);
sqlite_close(db);
return(false);
}
free(cError);
sqlite_close(db);
return(true);
}



struct _inirecord
{
  int record_key;
  char inisection[30];
  char inikey[30];
  char iniline[255];
} inirecord[1];
int sql_inirecord_callback(void *args, int numCols, char **results, char 
**columnNames)

{
int i;
for (i=0; inumCols; i++)
{
//printf(sql_inirecord_callback() column %i value 
%s\n,i,results[i]);

if (i==0)
inirecord[0].record_key=atoi(results[i]);
if (i==1)
strncpy(inirecord[0].inisection,results[i],30);
if (i==2)
strncpy(inirecord[0].inikey,results[i],30);
if (i==3)
strncpy(inirecord[0].iniline,results[i],255);
}
return(0);
}



Lloyd Thomas wrote:
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



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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 to sql injection attacks. Using the bind() method eliminates that
vulnerability.
Something to consider.

Jay


Here's some example code:

sqlite3*db;

// connect to database
if ( sqlite3_open( test.db, db ) )
 throw Can't open database;

char* sql;

sql = SELECT one.test1, two.test2
 FROM one
 INNER JOIN two ON one.id = two.id
;
sqlite3_stmt*   pStmt;

if ( sqlite3_prepare( db, sql, strlen(sql), pStmt, NULL ) != SQLITE_OK )
 {
string str = Cannot prepare sql: ;
str += sql[t];
str += , Error: ;
str += sqlite3_errmsg(db);
throw str.c_str();
 }

bool Loop = true;
while ( Loop )
 switch ( sqlite3_step( pStmt ) )
{
   case SQLITE_ROW:
  // retrieve the results
  char* p = (char *) sqlite3_column_text( pStmt, 0 );
  string test1  = string( p ? p :  );

  p = (char *) sqlite3_column_text( pStmt, 1 );
  string test2 = string( p ? p :  );

  break;
   case SQLITE_DONE:
  Loop = false;
  break;
   case SQLITE_BUSY:
   case SQLITE_LOCKED:
   default:
  string str = Cannot execute sql: ;
  str += sql[t];
  str += , Error: ;
  str += sqlite3_errmsg(db);
  throw str.c_str();
  break;
}

// clean up when finished
sqlite3_finalize( pStmt );

sqlite3_close( db );



--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

2006-09-09 Thread Lloyd Thomas 

Jay, Thanks for your reply.
I gave it a try with and got a few errors. as follows
---
logger.cpp:609: error: invalid operands of types `const char[80]' and 
`char[4]' to binary `operator+'

logger.cpp:615: error: `t' was not declared in this scope
logger.cpp:615: warning: unused variable 't'
logger.cpp:634: error: jump to case label
logger.cpp:631: error:   crosses initialization of `std::string test2'
logger.cpp:628: error:   crosses initialization of `std::string test1'
logger.cpp:637: error: jump to case label
logger.cpp:631: error:   crosses initialization of `std::string test2'
logger.cpp:628: error:   crosses initialization of `std::string test1'
logger.cpp:638: error: jump to case label
logger.cpp:631: error:   crosses initialization of `std::string test2'
logger.cpp:628: error:   crosses initialization of `std::string test1'
logger.cpp:639: error: jump to case label
logger.cpp:631: error:   crosses initialization of `std::string test2'
logger.cpp:628: error:   crosses initialization of `std::string test1'
logger.cpp:641: error: `t' was not declared in this scope
logger.cpp:641: warning: unused variable 't'
logger.cpp:664: error: jump to case label
logger.cpp:621: error:   crosses initialization of `bool Loop'
logger.cpp:634: warning: destructor needed for `test2'
logger.cpp:634: warning: where case label appears here
logger.cpp:634: warning: (enclose actions of previous case statements 
requiring destructors in their own scope.)

logger.cpp:637: warning: destructor needed for `test2'
logger.cpp:637: warning: where case label appears here
logger.cpp:638: warning: destructor needed for `test2'
logger.cpp:638: warning: where case label appears here
logger.cpp:639: warning: destructor needed for `test2'
logger.cpp:639: warning: where case label appears here
make: *** [logger.o] Error 1
--
line 609 =
sql = insert into call_data (direction, call_time, dest, trunk_no, 
file_name)values('+details.inout+','+details.statime+','+details.cidn+'+details.channel+','+details.filename+');







- Original Message - 
From: Jay Sprenkle [EMAIL PROTECTED]

To: sqlite-users@sqlite.org
Sent: Saturday, September 09, 2006 11:16 PM
Subject: Re: [sqlite] A lillte help adding sqlite to a c program



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 to sql injection attacks. Using the bind() method eliminates that
vulnerability.
Something to consider.

Jay


Here's some example code:

sqlite3*db;

// connect to database
if ( sqlite3_open( test.db, db ) )
 throw Can't open database;

char* sql;

sql = SELECT one.test1, two.test2
 FROM one
 INNER JOIN two ON one.id = two.id
;
sqlite3_stmt*   pStmt;

if ( sqlite3_prepare( db, sql, strlen(sql), pStmt, NULL ) != SQLITE_OK )
 {
string str = Cannot prepare sql: ;
str += sql[t];
str += , Error: ;
str += sqlite3_errmsg(db);
throw str.c_str();
 }

bool Loop = true;
while ( Loop )
 switch ( sqlite3_step( pStmt ) )
{
   case SQLITE_ROW:
  // retrieve the results
  char* p = (char *) sqlite3_column_text( pStmt, 0 );
  string test1  = string( p ? p :  );

  p = (char *) sqlite3_column_text( pStmt, 1 );
  string test2 = string( p ? p :  );

  break;
   case SQLITE_DONE:
  Loop = false;
  break;
   case SQLITE_BUSY:
   case SQLITE_LOCKED:
   default:
  string str = Cannot execute sql: ;
  str += sql[t];
  str += , Error: ;
  str += sqlite3_errmsg(db);
  throw str.c_str();
  break;
}

// clean up when finished
sqlite3_finalize( pStmt );

sqlite3_close( db );



--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

2006-09-09 Thread Mark Richards 
I don't know how to work string types in c++, but it looks like you need 
to initialize an integer t=0, or replace sql[t] with sql[0] perhaps?


/m



Lloyd Thomas wrote:

Jay, Thanks for your reply.
I gave it a try with and got a few errors. as follows
---
logger.cpp:609: error: invalid operands of types `const char[80]' and 
`char[4]' to binary `operator+'

logger.cpp:615: error: `t' was not declared in this scope
logger.cpp:615: warning: unused variable 't'
logger.cpp:634: error: jump to case label
logger.cpp:631: error:   crosses initialization of `std::string test2'
logger.cpp:628: error:   crosses initialization of `std::string test1'
logger.cpp:637: error: jump to case label
logger.cpp:631: error:   crosses initialization of `std::string test2'
logger.cpp:628: error:   crosses initialization of `std::string test1'
logger.cpp:638: error: jump to case label
logger.cpp:631: error:   crosses initialization of `std::string test2'
logger.cpp:628: error:   crosses initialization of `std::string test1'
logger.cpp:639: error: jump to case label
logger.cpp:631: error:   crosses initialization of `std::string test2'
logger.cpp:628: error:   crosses initialization of `std::string test1'
logger.cpp:641: error: `t' was not declared in this scope
logger.cpp:641: warning: unused variable 't'
logger.cpp:664: error: jump to case label
logger.cpp:621: error:   crosses initialization of `bool Loop'
logger.cpp:634: warning: destructor needed for `test2'
logger.cpp:634: warning: where case label appears here
logger.cpp:634: warning: (enclose actions of previous case statements 
requiring destructors in their own scope.)

logger.cpp:637: warning: destructor needed for `test2'
logger.cpp:637: warning: where case label appears here
logger.cpp:638: warning: destructor needed for `test2'
logger.cpp:638: warning: where case label appears here
logger.cpp:639: warning: destructor needed for `test2'
logger.cpp:639: warning: where case label appears here
make: *** [logger.o] Error 1
--
line 609 =
sql = insert into call_data (direction, call_time, dest, trunk_no, 
file_name)values('+details.inout+','+details.statime+','+details.cidn+'+details.channel+','+details.filename+'); 








- Original Message - From: Jay Sprenkle [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Saturday, September 09, 2006 11:16 PM
Subject: Re: [sqlite] A lillte help adding sqlite to a c program



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 to sql injection attacks. Using the bind() method eliminates that
vulnerability.
Something to consider.

Jay


Here's some example code:

sqlite3*db;

// connect to database
if ( sqlite3_open( test.db, db ) )
 throw Can't open database;

char* sql;

sql = SELECT one.test1, two.test2
 FROM one
 INNER JOIN two ON one.id = two.id
;
sqlite3_stmt*   pStmt;

if ( sqlite3_prepare( db, sql, strlen(sql), pStmt, NULL ) != SQLITE_OK )
 {
string str = Cannot prepare sql: ;
str += sql[t];
str += , Error: ;
str += sqlite3_errmsg(db);
throw str.c_str();
 }

bool Loop = true;
while ( Loop )
 switch ( sqlite3_step( pStmt ) )
{
   case SQLITE_ROW:
  // retrieve the results
  char* p = (char *) sqlite3_column_text( pStmt, 0 );
  string test1  = string( p ? p :  );

  p = (char *) sqlite3_column_text( pStmt, 1 );
  string test2 = string( p ? p :  );

  break;
   case SQLITE_DONE:
  Loop = false;
  break;
   case SQLITE_BUSY:
   case SQLITE_LOCKED:
   default:
  string str = Cannot execute sql: ;
  str += sql[t];
  str += , Error: ;
  str += sqlite3_errmsg(db);
  throw str.c_str();
  break;
}

// clean up when finished
sqlite3_finalize( pStmt );

sqlite3_close( db );



--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 






- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 






-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

2006-09-09 Thread Teg 
Hello Lloyd,

You need to escape the quotes. Remember in C and C++  means the
beginning or end of a literal string so, when you want to embed quotes
in a string you have to escape them. Probaby \.

You'd be better off using the paramaterized version of the SQL

std::string sql = insert into call_data (direction, call_time, dest, trunk_no,
file_name)values(?,?,?,?,?);;

Then bind the actual parameters after the fact.

C


Saturday, September 9, 2006, 7:02:43 PM, you wrote:

LT Jay, Thanks for your reply.
LT I gave it a try with and got a few errors. as follows
LT ---
LT logger.cpp:609: error: invalid operands of types `const char[80]' and
LT `char[4]' to binary `operator+'
LT logger.cpp:615: error: `t' was not declared in this scope
LT logger.cpp:615: warning: unused variable 't'
LT logger.cpp:634: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:637: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:638: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:639: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:641: error: `t' was not declared in this scope
LT logger.cpp:641: warning: unused variable 't'
LT logger.cpp:664: error: jump to case label
LT logger.cpp:621: error:   crosses initialization of `bool Loop'
LT logger.cpp:634: warning: destructor needed for `test2'
LT logger.cpp:634: warning: where case label appears here
LT logger.cpp:634: warning: (enclose actions of previous case statements
LT requiring destructors in their own scope.)
LT logger.cpp:637: warning: destructor needed for `test2'
LT logger.cpp:637: warning: where case label appears here
LT logger.cpp:638: warning: destructor needed for `test2'
LT logger.cpp:638: warning: where case label appears here
LT logger.cpp:639: warning: destructor needed for `test2'
LT logger.cpp:639: warning: where case label 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+','+details.cidn+'+details.channel+','+details.filename+');






LT - Original Message - 
LT From: Jay Sprenkle [EMAIL PROTECTED]
LT To: sqlite-users@sqlite.org
LT Sent: Saturday, September 09, 2006 11:16 PM
LT Subject: Re: [sqlite] A lillte help adding sqlite to a c program


 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 to sql injection attacks. Using the bind() method eliminates that
 vulnerability.
 Something to consider.

 Jay


 Here's some example code:

 sqlite3*db;

 // connect to database
 if ( sqlite3_open( test.db, db ) )
  throw Can't open database;

 char* sql;

 sql = SELECT one.test1, two.test2
  FROM one
  INNER JOIN two ON one.id = two.id
 ;
 sqlite3_stmt*   pStmt;

 if ( sqlite3_prepare( db, sql, strlen(sql), pStmt, NULL ) != SQLITE_OK )
  {
 string str = Cannot prepare sql: ;
 str += sql[t];
 str += , Error: ;
 str += sqlite3_errmsg(db);
 throw str.c_str();
  }

 bool Loop = true;
 while ( Loop )
  switch ( sqlite3_step( pStmt ) )
 {
case SQLITE_ROW:
   // retrieve the results
   char* p = (char *) sqlite3_column_text( pStmt, 0 );
   string test1  = string( p ? p :  );

   p = (char *) sqlite3_column_text( pStmt, 1 );
   string test2 = string( p ? p :  );

   break;
case SQLITE_DONE:
   Loop = false;
   break;
case SQLITE_BUSY:
case SQLITE_LOCKED:
default:
   string str = Cannot execute sql: ;
   str += sql[t];
   str += , Error: ;
   str += sqlite3_errmsg(db);
   throw str.c_str();
   break;
 }

 // clean up when finished
 sqlite3_finalize( pStmt );

 sqlite3_close( db );



 --
 SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
 http://www.reddawn.net/~jsprenkl/Sqlite

 Cthulhu Bucks!
 http://www.cthulhubucks.com

 -
 To unsubscribe, send email to [EMAIL PROTECTED

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

2006-09-09 Thread Lloyd Thomas 
if I could somehow create the following string as a char i cpuld probably 
get the code to work.
 sql = insert into call_data (direction, call_time, dest, 
trunk_no, file_name)values(';

 sql += details.inout;
 sql += ',';
 sql += details.statime;
 sql += ',';
 sql += details.cidn;
 sql += ';
 sql +=details.channel;
 sql += ',';
 sql += details.filename;
 sql += ');
I am getting stuck adding exist chars to the sql char


  defined chars

^^
sql = insert into call_data(direction, 
call_time)values('details.inout','details.statime)

Do you have any ideas?

Lloydie T


- Original Message - 
From: Teg [EMAIL PROTECTED]

To: Lloyd Thomas sqlite-users@sqlite.org
Sent: Sunday, September 10, 2006 12:47 AM
Subject: Re[2]: [sqlite] A lillte help adding sqlite to a c program



Hello Lloyd,

You need to escape the quotes. Remember in C and C++  means the
beginning or end of a literal string so, when you want to embed quotes
in a string you have to escape them. Probaby \.

You'd be better off using the paramaterized version of the SQL

std::string sql = insert into call_data (direction, call_time, dest, 
trunk_no,

file_name)values(?,?,?,?,?);;

Then bind the actual parameters after the fact.

C


Saturday, September 9, 2006, 7:02:43 PM, you wrote:

LT Jay, Thanks for your reply.
LT I gave it a try with and got a few errors. as follows
LT ---
LT logger.cpp:609: error: invalid operands of types `const char[80]' and
LT `char[4]' to binary `operator+'
LT logger.cpp:615: error: `t' was not declared in this scope
LT logger.cpp:615: warning: unused variable 't'
LT logger.cpp:634: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:637: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:638: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:639: error: jump to case label
LT logger.cpp:631: error:   crosses initialization of `std::string test2'
LT logger.cpp:628: error:   crosses initialization of `std::string test1'
LT logger.cpp:641: error: `t' was not declared in this scope
LT logger.cpp:641: warning: unused variable 't'
LT logger.cpp:664: error: jump to case label
LT logger.cpp:621: error:   crosses initialization of `bool Loop'
LT logger.cpp:634: warning: destructor needed for `test2'
LT logger.cpp:634: warning: where case label appears here
LT logger.cpp:634: warning: (enclose actions of previous case statements
LT requiring destructors in their own scope.)
LT logger.cpp:637: warning: destructor needed for `test2'
LT logger.cpp:637: warning: where case label appears here
LT logger.cpp:638: warning: destructor needed for `test2'
LT logger.cpp:638: warning: where case label appears here
LT logger.cpp:639: warning: destructor needed for `test2'
LT logger.cpp:639: warning: where case label 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+','+details.cidn+'+details.channel+','+details.filename+');







LT - Original Message - 
LT From: Jay Sprenkle [EMAIL PROTECTED]

LT To: sqlite-users@sqlite.org
LT Sent: Saturday, September 09, 2006 11:16 PM
LT Subject: Re: [sqlite] A lillte help adding sqlite to a c program



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 to sql injection attacks. Using the bind() method eliminates that
vulnerability.
Something to consider.

Jay


Here's some example code:

sqlite3*db;

// connect to database
if ( sqlite3_open( test.db, db ) )
 throw Can't open database;

char* sql;

sql = SELECT one.test1, two.test2
 FROM one
 INNER JOIN two ON one.id = two.id
;
sqlite3_stmt*   pStmt;

if ( sqlite3_prepare( db, sql, strlen(sql), pStmt, NULL ) != 
SQLITE_OK )

 {
string str = Cannot prepare sql: ;
str += sql[t];
str += , Error: ;
str += sqlite3_errmsg(db);
throw str.c_str();
 }

bool Loop = true;
while ( Loop )
 switch ( sqlite3_step( pStmt ) )
{
   case

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

2006-09-09 Thread Teg 
Hello Lloyd,

I gave you the answer, you just don't want to use it. Generating SQL
this way is painful, messy and error prone. SQLite already has a far
better mechanism for doing it using late binding of the parameters.

How about learning the right way to do this?

I'll give you a hint though

   sql += ',';
   sql += details.statime;
   sql += ',';
...

should work
You could do it with sprintf too and/or some IO stream thing but, I
never use them.

Conrad




Saturday, September 9, 2006, 9:41:01 PM, you wrote:

LT if I could somehow create the following string as a char i cpuld probably
LT get the code to work.
LT   sql = insert into call_data (direction, call_time, dest,
LT trunk_no, file_name)values(';
LT   sql += details.inout;
LT   sql += ',';
LT   sql += details.statime;
LT   sql += ',';
LT   sql += details.cidn;
LT   sql += ';
LT   sql +=details.channel;
LT   sql += ',';
LT   sql += details.filename;
LT   sql += ');
LT I am getting stuck adding exist chars to the sql char

 
LTdefined chars
 
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 Message - 
LT From: Teg [EMAIL PROTECTED]
LT To: Lloyd Thomas sqlite-users@sqlite.org
LT Sent: Sunday, September 10, 2006 12:47 AM
LT Subject: Re[2]: [sqlite] A lillte help adding sqlite to a c program


 Hello Lloyd,

 You need to escape the quotes. Remember in C and C++  means the
 beginning or end of a literal string so, when you want to embed quotes
 in a string you have to escape them. Probaby \.

 You'd be better off using the paramaterized version of the SQL

 std::string sql = insert into call_data (direction, call_time, dest,
 trunk_no,
 file_name)values(?,?,?,?,?);;

 Then bind the actual parameters after the fact.

 C


 Saturday, September 9, 2006, 7:02:43 PM, you wrote:

 LT Jay, Thanks for your reply.
 LT I gave it a try with and got a few errors. as follows
 LT ---
 LT logger.cpp:609: error: invalid operands of types `const char[80]' and
 LT `char[4]' to binary `operator+'
 LT logger.cpp:615: error: `t' was not declared in this scope
 LT logger.cpp:615: warning: unused variable 't'
 LT logger.cpp:634: error: jump to case label
 LT logger.cpp:631: error:   crosses initialization of `std::string test2'
 LT logger.cpp:628: error:   crosses initialization of `std::string test1'
 LT logger.cpp:637: error: jump to case label
 LT logger.cpp:631: error:   crosses initialization of `std::string test2'
 LT logger.cpp:628: error:   crosses initialization of `std::string test1'
 LT logger.cpp:638: error: jump to case label
 LT logger.cpp:631: error:   crosses initialization of `std::string test2'
 LT logger.cpp:628: error:   crosses initialization of `std::string test1'
 LT logger.cpp:639: error: jump to case label
 LT logger.cpp:631: error:   crosses initialization of `std::string test2'
 LT logger.cpp:628: error:   crosses initialization of `std::string test1'
 LT logger.cpp:641: error: `t' was not declared in this scope
 LT logger.cpp:641: warning: unused variable 't'
 LT logger.cpp:664: error: jump to case label
 LT logger.cpp:621: error:   crosses initialization of `bool Loop'
 LT logger.cpp:634: warning: destructor needed for `test2'
 LT logger.cpp:634: warning: where case label appears here
 LT logger.cpp:634: warning: (enclose actions of previous case statements
 LT requiring destructors in their own scope.)
 LT logger.cpp:637: warning: destructor needed for `test2'
 LT logger.cpp:637: warning: where case label appears here
 LT logger.cpp:638: warning: destructor needed for `test2'
 LT logger.cpp:638: warning: where case label appears here
 LT logger.cpp:639: warning: destructor needed for `test2'
 LT logger.cpp:639: warning: where case label 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+','+details.cidn+'+details.channel+','+details.filename+');






 LT - Original Message - 
 LT From: Jay Sprenkle [EMAIL PROTECTED]
 LT To: sqlite-users@sqlite.org
 LT Sent: Saturday, September 09, 2006 11:16 PM
 LT Subject: Re: [sqlite] A lillte help adding sqlite to a c program


 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