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
