Hi all,

   How can i update and insert record into database via Raw sql in
Lift?

   I write some code but it failed, here is :

### In the model

  def updateClickCountsById(id: Long) =
    DB.runQuery("UPDATE blogs set click_counts=click_counts+1 WHERE
id=1")

  def insertRecord() =
    DB.runQuery("INSERT INTO blogs click_counts=100 WHERE id=1")

###

   This two method doesn't work, so how can i update and insert via
raw SQL in the lift with Mapper?

   Thanks for any suggestion !

Cheers,
  Neil

--

You received this message because you are subscribed to the Google Groups 
"Lift" group.
To post to this group, send email to lift...@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.


Reply via email to