Is there a some simple code ~? Thanks very much!
Cheers, Neil On Nov 13, 10:50 pm, Derek Chen-Becker <dchenbec...@gmail.com> wrote: > MetaMapper.findAllFields may work for what you're doing, but with the > DAYOFWEEK conversion you may just have to go directly against the DB. > > Derek > > On Sun, Nov 8, 2009 at 11:44 PM, Neil.Lv <anim...@gmail.com> wrote: > > > Hi all, > > > There is some example code: > > ### > > SELECT id, name, sex, created_at, DAYOFWEEK(created_at,) as week, > > (CURRENT_DATE) as t > > FROM users > > WHERE created_at > (CURRENT_DATE ) AND created_at < (CURRENT_DATE + > > interval 2 day) > > ORDER BY created_at ASC > > ### > > > How can i specify the SELECT statement that i don't want all the > > columns and i want add the column as week > > in the example code ? > > > Any help would be much appreciated! > > > Cheers, > > Neil --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---