Re: [sqlite] SQLite and C++

2012-06-13 Thread PJ Naughter
l.com -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Arbol One Sent: 13 June 2012 12:22 To: SQLite user list Users Subject: [sqlite] SQLite and C++ Anyone knows where I can find some examples of how C++ interfaces with SQLite? I just ne

Re: [sqlite] SQLite and C++

2012-06-13 Thread Simon Slavin
On 13 Jun 2012, at 12:21pm, "Arbol One" wrote: > Anyone knows where I can find some examples of how C++ interfaces with > SQLite? I just need to see some code that is functional and not just some > snips of how it maybe-should-possibly work. The code at the bottom of this page works, and does

Re: [sqlite] SQLite and C++

2012-06-13 Thread John Drescher
On Wed, Jun 13, 2012 at 7:21 AM, Arbol One wrote: > Anyone knows where I can find some examples of how C++ interfaces with > SQLite? I just need to see some code that is functional and not just some > snips of how it maybe-should-possibly work. Although this is probably not what you want Qt co

Re: [sqlite] SQLite and C++

2012-06-13 Thread Stephan Beal
On Wed, Jun 13, 2012 at 1:21 PM, Arbol One wrote: > Anyone knows where I can find some examples of how C++ interfaces with > SQLite? I just need to see some code that is functional and not just some > snips of how it maybe-should-possibly work. > Here's mine: http://fossil.wanderinghorse.net/re

[sqlite] SQLite and C++

2012-06-13 Thread Arbol One
Anyone knows where I can find some examples of how C++ interfaces with SQLite? I just need to see some code that is functional and not just some snips of how it maybe-should-possibly work. TIA ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] SQLite and C++ in Linux

2010-10-07 Thread Richard Hipp
On Thu, Oct 7, 2010 at 5:47 PM, Dan Sabin wrote: > Hi, > > I'm trying to embed SQLite into a Linux application. It's written in C++ > and I'm having trouble getting the code to compile with the SQLite .c and .h > files included. I get some of the following errors: > > ./MyProject/Debug/../src

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-17 Thread Wilson, Ron P
2008 10:55 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQlite and C works with "like" but not with "=" "Daniel White" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >> Which way is it stored in the database? Show the output of this &

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-16 Thread Daniel White
Thanks again Dan and Igor. Since I don't need to write to the database (only read from it atm), collate binary will do nicely. I'll keep an eye on those error messages in future! Dan On Sun, 15 Jun 2008 09:13:52 +0100, Dan <[EMAIL PROTECTED]> wrote: > On Jun 15, 2008, at 8:55 AM, Daniel White

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-15 Thread Dan
On Jun 15, 2008, at 8:55 AM, Daniel White wrote: > Cheers both of you, it seems this problem is indeed > linked with the "no such collation sequence: iunicode" > error as Dan mentioned. > > After some research, I found out that the root of > the problem is unsurmountable at present. I quote from:

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Igor Tandetnik
"Daniel White" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Oh well, there are one or two 'hacks' around it. The first is > to use COLLATE BINARY, or COLLATE NOCASE after the SQL query. > This appears okay on the surface, but probably ignores > unicode chars or something. It may al

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Daniel White
Cheers both of you, it seems this problem is indeed linked with the "no such collation sequence: iunicode" error as Dan mentioned. After some research, I found out that the root of the problem is unsurmountable at present. I quote from: http://www.mediamonkey.com/forum/viewtopic.php?p=84197 "It's

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Dan
On Jun 14, 2008, at 9:08 PM, Daniel White wrote: > The course of action I thought you implied was to change > it from "hexion" to "Hexion", and so I hoped that would > return the results, but it still doesn't. > > "Still" meaning, just like the small 'h', 'H' doesn't > work either. > The answer

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Igor Tandetnik
"Daniel White" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >> Which way is it stored in the database? Show the output of this >> statement: >> >> SELECT SongTitle FROM songs WHERE SongTitle like 'hexion'; > > There are 8 records of Hexion in the database, so after a printout > to th

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Daniel White
> Which way is it stored in the database? Show the output of this > statement: > > SELECT SongTitle FROM songs WHERE SongTitle like 'hexion'; There are 8 records of Hexion in the database, so after a printout to the console with a carriage return after each value, I basically get: Hexion Hexion He

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Igor Tandetnik
"Daniel White" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > The course of action I thought you implied was to change > it from "hexion" to "Hexion", and so I hoped that would > return the results, but it still doesn't. Which way is it stored in the database? Show the output of thi

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Daniel White
The course of action I thought you implied was to change it from "hexion" to "Hexion", and so I hoped that would return the results, but it still doesn't. "Still" meaning, just like the small 'h', 'H' doesn't work either. Dan also mentioned the capital letter thing so it was a reply to him as wel

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Igor Tandetnik
"Daniel White" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Funny you should mention the capital at the start > to make "Hexion". I thought of that just after I > posted. But it doesn't solve the problem unfortunately. > Zero results are still returned. What do you mean, "still" r

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Daniel White
Thanks Dan and Igor for clarifying the 5th param. I'm guessing it's safe to leave it at 0 if I just use one SQL statement then. Funny you should mention the capital at the start to make "Hexion". I thought of that just after I posted. But it doesn't solve the problem unfortunately. Zero results ar

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-13 Thread Dan
On Jun 14, 2008, at 10:39 AM, Daniel White wrote: > Hi guys, > > My first post to this list, and I'm new to SQL in general too. > > Just a couple of questions to start: > > ***1: > In the sqlite3_prepare_v2 function, can someone explain > to me the 5th parameter better than the site's help can? >

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-13 Thread Igor Tandetnik
"Daniel White" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > My first post to this list, and I'm new to SQL in general too. > > Just a couple of questions to start: > > ***1: > In the sqlite3_prepare_v2 function, can someone explain > to me the 5th parameter better than the site's h

[sqlite] SQlite and C works with "like" but not with "="

2008-06-13 Thread Daniel White
Hi guys, My first post to this list, and I'm new to SQL in general too. Just a couple of questions to start: ***1: In the sqlite3_prepare_v2 function, can someone explain to me the 5th parameter better than the site's help can? I quote: /* OUT: Pointer to unused portion of zSql */ I'm a bit pe

Re: [sqlite] Sqlite and C

2004-10-29 Thread Florian Boor
Hi, > Someone have a link about little software like an address book > write in ansi C with sqlite? look at http://gpe.handhelds.org most of the applications that need to store data use sqlite. e.g. gpe-contacts and gpe-todo (The database interface of it is in libtododb.) Greetings Florian --

[sqlite] Sqlite and C

2004-10-29 Thread Max
Someone have a link about little software like an address book write in ansi C with sqlite? Thanks 1K Ciao Max -- Secondo alcuni autorevoli testi di tecnica Aeronautica, il calabrone non può volare, a causa della forma e del peso del proprio corpo in rapporto alla superficie alare. Ma il calabron