It works now.
I use the same executeUpdate method, and it can insert into the db.
Thanks Marcin,
Cheers,
Neil
On Dec 19, 1:29 am, "Neil.Lv" <anim...@gmail.com> wrote:
> Hi Marcin,
>
> Thank you very much! The update statement works now!
>
> There is a question about the insert statement, how can i use the
> prepareStatement ?
>
> ###
> "INSERT INTO blogs click_counts=100 WHERE id=1"
> ###
>
> I'm not familiar with it,
>
> Thanks very much!
>
> :)
>
> Cheers,
> Neil
>
> On Dec 18, 11:13 pm, Marcin Jurczuk <mjurc...@gmail.com> wrote:
>
> > Hi,
>
> > You have few options:
> > - DB.runQuery("UPDATE blogs set click_counts=click_counts+1 WHERE
> > id=1")
> > - DBprepareStatement("UPDATE blogs set click_counts=click_counts+1
> > WHERE id=?",yourDBConnection) {
> > stmt =>
> > stmt.setLong(1,1)
> > stmt.executeUpdate()}
>
> > Where first 1 in setLong is position in prepared statment where you
> > will put second value. Since You have only one ? it always will be
> > "1".
>
> > WARNING:
> > runQuery is vulnerable to SQL injection in many situations (mostly
> > where string is passed to query)
>
> > Marcin,
>
> > On 18 Gru, 15:45, "Neil.Lv" <anim...@gmail.com> wrote:
>
> > > 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.
