Re: [sqlite] Prepared Statement Interface

Thomas Fjellstrom <[EMAIL PROTECTED]> writes: >> > Change sizeof to strlen here (and in the corresponding statement below); >> > sqlite3_bind_text wants the length of the string, not the size of the >> > pointer to it. >> >> sizeof(SEX)-1 is fine. > > I hope you mean strlen(SEX)-1 > > sizeof is a

Re: [sqlite] Prepared Statement Interface

On March 26, 2005 07:41 pm, Mrs. Brisby wrote: > On Sat, 2005-03-26 at 15:15 -0600, Eric Bohlman wrote: > > #define SEX "'M'" > > > > >sqlite3_bind_text(stmt, index, SEX, sizeof(SEX), SQLITE_TRANSIENT); > > [note the extra ' in SEX] > > > Change sizeof to strlen here (and in the

Re: [sqlite] using cross-link table

On Sat, 2005-03-26 at 10:29 -0500, Jason Jobe wrote: > // to find people whose great-grandfather's name is Fred > Well, this is probably correct sql but hopefully you get the idea. So > part of the question is: > > 1. How efficient is this? Not at all. It doesn't work. If you meant:

Re: [sqlite] Prepared Statement Interface

On Sat, 2005-03-26 at 15:15 -0600, Eric Bohlman wrote: > #define SEX "'M'" > > sqlite3_bind_text(stmt, index, SEX, sizeof(SEX), > > SQLITE_TRANSIENT); [note the extra ' in SEX] > Change sizeof to strlen here (and in the corresponding statement below);

Re: [sqlite] Prepared Statement Interface

Eric Bohlman wrote: Eugene Wee wrote: #define SEX "'M'" And make that #define SEX "M" Gert

[sqlite] Best embedded OS for Sqlite and perl

Hi All I am just looking into building some "set top" like devices for a particular business application. I would like to use Sqlite to manage the data repository and I have been a perl developer for the last few years. Does anybody have a recommendation about which embeddable linux

Re: [sqlite] Prepared Statement Interface

Eugene Wee wrote: As a test, I created a database containing a single table [children]. I filled it with the names of 3 girls and 2 boys, and then tried to write a program that selects the boys and girls separately and printed their names. However, I have difficulty in binding text with

[sqlite] Prepared Statement Interface

Hi, Are there any tutorials available to explain SQLite3's prepared statement interface further? I adapted from: http://www.linuxjournal.com/article/7803 As a test, I created a database containing a single table [children]. I filled it with the names of 3 girls and 2 boys, and then tried to

Re: [sqlite] Concurrency tutorial ( small bounty )

On Mar 25, 2005, at 9:18 PM, Kervin L. Pierre wrote: ... I am interested in how you got this problem solved. I'll reply you off list. Regards, Marco Bambini SQLabs.net

[sqlite] using cross-link table

I'm a big fan of EOF (Apple's relational to OO tool) and I've been trying to figure out the easiest/best way to support queries that span several links through a many-to-many cross-link table and am hoping for some suggestions and pointers. Here is the kind of query I would like to write (or

Re: [sqlite] RegEx w/ sqlite, yet?

Hello Jay, Saturday, March 26, 2005, 2:41:10 AM, you wrote: >> Hello sqlite-users, >> >> any news on that? > It's not part of the sql standard, so I would bet the answer > is going to be 'you have to add that yourself'. I did for > my project. How did you do that? Do you want to share it?

RE: [sqlite] Contrib uploads

it is already UPX'ed AND zipped. still... From: Eugene Wee [mailto:[EMAIL PROTECTED] Sent: Fri 3/25/2005 6:24 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Contrib uploads Hi, have you considered using UPX to reduce the executable filesize?