Re: [sqlite] combining multiple queries
On 12/15/06, jason schleifer <[EMAIL PROTECTED]> wrote: If the user specifies one or more tags, I want to be able to return all moves that match EITHER tag.. for example, if htey specify "carrey" and "snow", it should return all movies that have either carrey or snow in the list. maybe this might help? select * from yourtable where tag = 'carrey' union select * from yourtable where tag = 'snow' etc... -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix 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] Problem with sqlite3 on CGI scripts with ANSI C
On 12/15/06, Francesco Andrisani <[EMAIL PROTECTED]> wrote: Hi comunity, i have the follow problem. I've insert into a C-CGI page a small sqlite3 code. When i call the page from a browser, it exec a query and show on browser the entries, but it don't work. If i add a "printf" above the sqlite3_open() it print the message, but if i put the instruction after the sqlite2_open() it don't swow the message. Under i put my piece of code: Did your program also print the proper cgi header before printing anything else? If you don't print the header you're output will probably get destroyed. Probably something like: printf( "Content-type: text/html\n\n" ); or printf( "Content-type: text/plain\n\n" ); -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix 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] sqlite internationalization
Hi someone have an SQLite internationalization samples which I can take a look at ? Also can I save,search in internationalization fomat ? Thanks Rashmi --- Cory Nelson <[EMAIL PROTECTED]> wrote: > On 12/15/06, Rashmi Hiremath > <[EMAIL PROTECTED]> wrote: > > Hi > > > > I would like to know wheather SQlite 3.3.8 > supports > > internationalization. > > It will store UTF-8 or UTF-16, but that's it. > > > Thanks > > Rashmi > > > > __ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > > - > > To unsubscribe, send email to > [EMAIL PROTECTED] > > > - > > > > > > > -- > Cory Nelson > http://www.int64.org > > - > To unsubscribe, send email to > [EMAIL PROTECTED] > - > > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite internationalization
On 12/15/06, Rashmi Hiremath <[EMAIL PROTECTED]> wrote: Hi I would like to know wheather SQlite 3.3.8 supports internationalization. It will store UTF-8 or UTF-16, but that's it. Thanks Rashmi __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cory Nelson http://www.int64.org - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] sqlite internationalization
Hi I would like to know wheather SQlite 3.3.8 supports internationalization. Thanks Rashmi __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem with sqlite3 on CGI scripts with ANSI C
Here is fixed your bug.. :D.. I'd use the Option 2.
Option 1:
printf("\nhello [1]");
if (sqlite_open("myDB.db", ))
error_handle(db);
printf("\n hello [2]");
Option 2:
printf("\nhello [1]");
if (sqlite_open("myDB.db", ))
{
error_handle(db);
}
printf("\n hello [2]");
On 15/12/06, John Stanton <[EMAIL PROTECTED]> wrote:
How do you set the working directory? Where is your Sqlite DB file?
You are just opening a file name, not a pathname so your working
directory is whatever your web server uses for CGI data.
Francesco Andrisani wrote:
> Hi comunity,
> i have the follow problem.
> I've insert into a C-CGI page a small sqlite3 code.
> When i call the page from a browser, it exec a query and show on browser
the entries, but it don't work.
> If i add a "printf" above the sqlite3_open() it print the message, but
if i put the instruction after the sqlite2_open() it don't swow the message.
> Under i put my piece of code:
>
>
>
> printf("\nhello [1]");
>
> if (sqlite_open("myDB.db", ));
> error_handle(db);
>
> printf("\n hello [2]");
>
>
> Regards.
>
> F.
>
>
>
> Francesco Andrisani
>
>
>
> Software Engineer
>
> mailto: [EMAIL PROTECTED]
>
> Gruppo Acotel
>
> http://www.acotel.com
Re: [sqlite] Problem with sqlite3 on CGI scripts with ANSI C
How do you set the working directory? Where is your Sqlite DB file?
You are just opening a file name, not a pathname so your working
directory is whatever your web server uses for CGI data.
Francesco Andrisani wrote:
Hi comunity,
i have the follow problem.
I've insert into a C-CGI page a small sqlite3 code.
When i call the page from a browser, it exec a query and show on browser the
entries, but it don't work.
If i add a "printf" above the sqlite3_open() it print the message, but if i put
the instruction after the sqlite2_open() it don't swow the message.
Under i put my piece of code:
printf("\nhello [1]");
if (sqlite_open("myDB.db", ));
error_handle(db);
printf("\n hello [2]");
Regards.
F.
Francesco Andrisani
Software Engineer
mailto: [EMAIL PROTECTED]
Gruppo Acotel
http://www.acotel.com
[sqlite] SQLite Invoicing Application?
I'm wondering if anyone out there has written an SQLite-based invoicing solution for Linux? I need one. Please contact me off-list. Thanks, Alex - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Problem with sqlite3 on CGI scripts with ANSI C
Francesco Andrisani wrote:
if (sqlite_open("myDB.db", ));
The semicolon at the end of this line means your error_handle() will
always get called.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[sqlite] Problem with sqlite3 on CGI scripts with ANSI C
Hi comunity,
i have the follow problem.
I've insert into a C-CGI page a small sqlite3 code.
When i call the page from a browser, it exec a query and show on browser the
entries, but it don't work.
If i add a "printf" above the sqlite3_open() it print the message, but if i put
the instruction after the sqlite2_open() it don't swow the message.
Under i put my piece of code:
printf("\nhello [1]");
if (sqlite_open("myDB.db", ));
error_handle(db);
printf("\n hello [2]");
Regards.
F.
Francesco Andrisani
Software Engineer
mailto: [EMAIL PROTECTED]
Gruppo Acotel
http://www.acotel.com
[sqlite] Sqlite Date-column support
I use date column in Sqlite as text with format '-mm-dd'. Declared type is 'date' real type in 'text'. After query i test result column type: sqlite3_column_type(sqlite3_stmt*, int iCol) return SQLITE_TEXT sqlite3_column_decltype(sqlite3_stmt*, int iCol) return 'date' only for table column and NULL for computed column as max(date-column). SQL function (and user function) can't return declared type of origin column. Can everyone add this feature? Fabio - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] combining multiple queries
Hi Jason.
Can make is easier so:
SELECT * FROM film WHERE
genre IN ("comedy", "drama")
AND tag IN ("bill murry", "scarlett o'hara"
,"silly");
--- jason schleifer <[EMAIL PROTECTED]> wrote:
> heya folks,
>
> I'm trying to figure out the proper syntax for doing
> a query of something
> like this:
>
> I have two different types of things that people
> will be querying for, and I
> want to do an OR on each, but and AND between them..
>
> So let's say i've got a table that looks like this:
>
> Create TABLE film (id INTEGER PRIMARY KEY, genre
> VARCHAR, tag VARCHAR):
>
> Genre can be of whatever genre the user wants..
> comedy, drama, etc.
> tag is a list of words that are separated by ;..
> "kennedy;marilyn;funny;"
> etc
>
> If the user doesn't specify either genre or a tag
> when they're querying, I
> want to return the whole list of films (that's an
> easy one).
>
> If the user specifies one or more tags, I want to be
> able to return all
> moves that match EITHER tag.. for example, if htey
> specify "carrey" and
> "snow", it should return all movies that have either
> carrey or snow in the
> list.
>
> If they then specify a genre, I want it to return
> ONLY the movies in the
> specified genre that match carrey or snow.
>
> Then (just to make it more complicated), if they
> specify two genres, it
> should return all movies in either of those genres
> that match either carrey
> or snow.
>
> Does this make sense?
>
> I know how to string a whole bunch of LIKEs together
> with an OR to get it to
> work so you could get it to match a genre or a tag..
> but how do I do
> something like:
>
> SELECT * FROM film WHERE (genre = "comedy" OR genre
> = "drama") AND (tag =
> "bill murry" OR tag = "scarlett o'hara" OR tag =
> "silly");
>
> any help is greatly appreciated..
>
> cheers!
> -jason
> --
> jason schleifer
> ah-ni-may-tor | weirdo
> http://jonhandhisdog.com/
>
Yahoo!?
Yahoo! !
http://ru.mail.yahoo.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
