Why this doesn't work? insert into table (creationdate, modifieddate, mytext, title) select date('now'), date('now'), "show text", "show title";
Pavel On Wed, Dec 23, 2009 at 11:24 AM, Christopher Doss <phdcp...@gmail.com> wrote: > Hello, I have a table that I'd like to create that needs calculated data in > multiple fields. The columns are: mytext, creationdate, title, modifieddate, > etc. etc > > If I only had one calculated data date, i could do something like insert > into table (creationdate, mytext, title) select date('now'), "show text", > "show title"; > > However, I want the current date to go to both fields. I can't use the > select statement twice because I keep getting errors. Can someone please > inform me how to achieve this? > I'm interfacing with sqlite with javascript. > _______________________________________________ > 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