Re: [sqlite] aces a databases store into a web server not into my local PC

Le vendredi 21 décembre 2007, finder a écrit : Hi, I don't find how to aces a databases store into a web server, throught a web page. I want to make a form that post a query and receive the result using a web page. Many thanks You could use a php script using the PDO::SQlite interface...

Re: [sqlite] [Linux + PHP] Recommended way to access SQLite?

Le dimanche 9 décembre 2007, Gilles Ganault a écrit : It seems like I have two options: - calling the SQLite library - going through the PDO interface, and its SQLite module. Which of the two would you recomend? Are there other options I should know about? I would recommend using PDO

Re: [sqlite] The fastest way to change the data of a table?

Alexei Alexandrov a écrit : Hi, Basically, I need to do the following: given a big-big table, I need to iterate through all its rows and change a column in about half the rows. The contents of the column to change depends on other columns, but only partially, so triggers won't work here.

Re: [sqlite] problem with creating a table

A. Pagaltzis a écrit : * Bijan Farhoudi [EMAIL PROTECTED] [2006-06-25 17:05]: A. Pagaltzis wrote: .headers on SELECT [order] FROM foo But how would you know the name of the col is order not [order]? That’s what `.headers on` was supposed to demonstrate.

Re: [sqlite] SQLite Path Problem On Fedora Core 5

Robert L Cochran a écrit : However, on Fedora Core 5, my path is set so that objects on /usr/local/bin are found before those on /usr/bin. I'm not sure how this is happening; perhaps /etc/profile? The result seems to be that even if sqlite 3.3.3 was installed by yum, executing /usr/bin/sqlite3

Re: [sqlite] Wildcards

Alex Roston a écrit : Ideally I'd like to do something like: UPDATE card SET foo='100' where bar='ABC*'; Use SQL standard construct: UPDATE card SET foo='100' WHERE bar LIKE 'ABC%' ;

Re: [sqlite] question about php_pdo_sqlite

yuyen wrote: Ok, finally I found the problem is that the PHP and Apache are installed in local drive and I put the sqlite database file on a remote file server which is a Linux / Samba. I can use sqlite3.exe to open that remote database with a mapped remote drive. And Insert, Update and

Re: [sqlite] question about php_pdo_sqlite

yuyen wrote: Hi, all I try to use php_pdo_sqlite in php which is a sqlite of version 3.2.8. With php_pdo, it provides PREPARE and EXECUTE functions to prepare an sql at first then which can execute later. But it seems that the php_pdo_sqlite.dll doesn't support it. Or I may do somthing

Re: [sqlite] question about php_pdo_sqlite

yuyen wrote: HI, JC I use php_do_sqlite with PHP 5.1.4 and Sqlite 3.2.8 on Windows XP. The following is my coding: ?php try{ $dsn = 'sqlite:counter/cntdata.sq3'; $myConn = new PDO($dsn); $myConn-setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $myPre = $myConn-prepare('update

Re: [sqlite] question about php_pdo_sqlite

yuyen wrote: And the error message is: execute err: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database So the problem is why the database becomes read only. This time, you get another message :) Are you sure the Web Server user (Apache or...) has write access to your

Re: [sqlite] Anyone knows any sqlite based bullettin board ?

Le mardi 2 Novembre 2004 09:36, George Ionescu a crit: I'm looking for an sqlite-based bulletin board to run under linux. Any recommendations? All PHP CMS, forum and boards using adodb php class can use sqlite. Google with sqlite cms -- JCR aka DJ Anubis LAB Project Initiator coordinator

Re: [sqlite] SQLite for large bulletin board systems?

larger sites could use a client/server database for scalability. For PHP users, ADOdb library needs a glance, as its abstract engine is fast and really well designed. It has drivers for most databases (sqlite included) and an abstract XML schema for databases. -- JCR aka DJ Anubis LAB Project

Re: [sqlite] Version 3.0.0 ALPHA first report

might need some optimizations, as we can end up with endless triggerings when using somewhat complex queries. I'll make more tests during the week end and provide a full report, with platform independant C++ test code. Thanks for the improvements. Great job +++ -- JCR aka DJ Anubis LAB Project

Re: [sqlite] the 2.8 database ananysis tool

features of classic Mac. ** OS X uses the os_unix.h file, not this one. Try to compile and tell us ;-) I can't try here as I have no Mac on hand. -- JCR aka DJ Anubis LAB Project Initiator coordinator - To unsubscribe, e-mail

Re: [sqlite] Version 3.0.0 ALPHA first report

a circular trigger (trigger triggering another trigger which triggered the first one). Cleaning the trigger declaration solved it. -- JCR aka DJ Anubis LAB Project Initiator coordinator - To unsubscribe, e-mail: [EMAIL

Re: Spam: Re: [sqlite] Version 3.0.0 ALPHA now available

(sqlite3_value*); or long long sqlite3_value_int64(sqlite3_value*); if this compiles, propose the typo change as a bug report. This could help improving portability. -- JCR aka DJ Anubis LAB Project Initiator coordinator

Re: [sqlite] Version 3.0.0 compiler warnings

Le samedi 19 Juin 2004 13:48, Daniel K a écrit : To fix this you need a TCL upgrade. Any 8.4.* will Thanks. Maybe this could fix my make doc problem too. I use tcl-8.3.5 for now. I'll try an upgrade. -- JCR aka DJ Anubis LAB Project Initiator coordinator