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 mig

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_o

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 w

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

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

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", &db)) error_handle(db); printf("\n hello [2]"); Option 2: printf("\nhello [1]"); if (sqlite_open("myDB.db", &db)) { error_handle(db); } printf("\n hello [2]"); On 15/12/06,

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 sma

[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", &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 afte

[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 an

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