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" <[email protected]> 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 <[email protected]> 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" <[email protected]> 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/liftweb?hl=en.
