Thank you very much, But it doesn't work yet, maybe because of using two db connections.
I'll test it later again. On Jan 21, 12:44 am, Jeppe Nejsum Madsen <[email protected]> wrote: > "Neil.Lv" <[email protected]> writes: > > Hi all, > > > I use two db connections in my app, and I want to use > > DB.prepareStatement to select > > the records from the second db. > > > It failed, Here is the code: > > ### > > def getHotByTid(id : Long) = > > DB.use(bootstrap.liftweb.TwoDB) { > > conn => > > DB.prepareStatement("SELECT * FROM hots WHERE id=? ", conn) { > > stmt => > > stmt.setLong(1, id) > > Log.info("stmt :" + stmt) // The information is correctly now, but > > after call executeUpdate method > > stmt.executeUpdate() > > } > > } > > Not sure what your problem is really, but I think you should use > DB.runQuery to execute a select statement > > Ie > > val (_,result) = DB.runQuery("SELECT COUNT(*), contract_length FROM "+ > "vehicles_current v "+ > "WHERE v.account_id=? "+ > "GROUP BY contract_length "+ > "ORDER BY contract_length", > List(42)) > > /Jeppe
-- 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.
