> 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