Hi again,
> And make that
> #define SEX "M"
I have only worked with databases in PHP, and there SQL injection is a
concern.
I could hardcode the query as:
SELECT name FROM children WHERE sex='M';
SELECT name FROM children WHERE sex='F';
And they work when prepared separately, of course.
So is:
SEL
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
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 correspond
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:
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);
>
Eric Bohlman wrote:
Eugene Wee wrote:
#define SEX "'M'"
And make that
#define SEX "M"
Gert
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 compatable
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 sqlite3_
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 writ
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
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 somet
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?
I
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?
http://upx.s
13 matches
Mail list logo