Making Custom Functions with Squeryl-Record

[Bruna]

Hi,

I'm using squeryl-record. Is there any way to build my sql using DB
pre-defined functions?

For example

class Ta extends Record[Ta] with KeyedRecord[Int] {
override def meta = Ta

override val idField = new IntField(this)
val time = new DateTimeField(this)
}

object Sc extends Schema{
val tab = table[Ta]

def func = from(tab)(t =>
where(to_char(t.time,"mi") = "00")
select(h))
}

thanks

[David Whittaker]

I think that Max has been helping you out with this on the Squeryl list.  Are you set?

--
You received this message because you are subscribed to the Google Groups "Lift" group.
To post to this group, send email to lif...@googlegroups.com.
To unsubscribe from this group, send email to liftweb+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/liftweb?hl=en.

[David Whittaker]

Bruna,

Max had asked me to take a second look at this and there does appear to be a Squeryl/Record bug that specifically affects DateTimeField.  Would you mind creating a Lift ticket referencing this thread and assigning it to me?  I'm working on a fix which should be ready soon.

On Wed, Jun 8, 2011 at 11:08 AM, Bruna <brunac...@gmail.com> wrote:

[David Whittaker]

I've created a ticket: https://www.assembla.com/spaces/liftweb/tickets/1048-datetimefield-cannot-be-used-in-a-custom-squeryl-function.  Should have a fix in soon.

[David Whittaker]

Fix for this is in master.  Please check out the latest snapshot if you can and let me know if your issue is resolved.

Thanks,

Dave