On 08 Oct 2011 at 23:32, Simon Slavin <slav...@bigfraud.org> wrote: > On 8 Oct 2011, at 10:37pm, Tim Streater wrote: > >> I have this string: >> >> attach database ':memory:' as mem; create table mem.messages ( absid >> integer, ..., replyto text ); >> >> (where the ellipsis represents a number of other column declarations). In >> PHP, I do this: >> >> $dbh->query ($str); >> >> where $str contains the string from above. > > I'm not clear whether you're using the PDO or the sqlite3 extension to PHP.
By the way, is one to be preferred over the other? I did notice that the command line tool had no problem with being given multiple statements on a line and executing them sequentially (which was in fact what prompted me to try it in my app). -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users