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 interfac

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 i

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/sqli

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 sup

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] 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 D

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 yo

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: > > try{ > $dsn = 'sqlite:counter/cntdata.sq3'; > $myConn = new PDO($dsn); > $myConn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); > > $myPre = $myConn->prepare('upd

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 somth

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 Projec

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

ovides while 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 ak

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 &

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

INT64_TYPE sqlite3_value_int64(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 &

Re: [sqlite] Version 3.0.0 ALPHA first report

n mine. I had 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

Re: [sqlite] the 2.8 database ananysis tool

-specific 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 u

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

g long off_t; # if defined(__MINGW32__) # define_OFF_T_ # endif # endif #endif Maybe some defines checking needed. -- JCR aka DJ Anubis LAB Project Initiator & coordinator - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

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 Pr

Re: [sqlite] Is there a demand for Client / Server Modules ?

Le jeudi 17 Juin 2004 16:20, Alex K a écrit : > Is there any demand for this ??? Sure, if you already developed it, I will not have to reinvent. If I can help for the linux port, tell me. -- JCR aka DJ Anubis LAB Project Initiator & coor