I am unsure of the syntax, as I don't use the sqlite API directly. I would say that seems correct as long as "'.$_SERVER['TMP'].'" resolves to a directory in which the user under which the application is running, has read and write access.
Artur Reilin wrote: > >> You can try setting a temp or tmp or tempdir environment variable on the >> server, however, as I said in the previous post, I am not sure if it >> will work. >> >> Probably the safest and most robust way would be to have your code call >> the pragma temp_store_directory directly after opening the database. >> How your code knows what directory to call the pragma with could be done >> with an environment variable or whatever you prefer. >> > > $db = @sqlite_open('../www/zero.sqlite'); > sqlite_exec('pragma temp_store=1; pragma > temp_store_directory="'.$_SERVER['TMP'].'"',$db); > > like this? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users