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
