> 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
