Junkone
10/28/2007 6:10:00 PM
On Oct 28, 12:21 pm, "Tom Machinski" <tom.machin...@gmail.com> wrote:
> Assuming the exception object is e, you can check out e.
>
> Exceptions and rescuing them works like this (assuming you want to
> st.execute throws a MysqlException):
>
> begin
> st.execute(dataArray[0],dataArray[1],dataArray[2],dataArray[3],tradeDate,da?taArray[5],dataArray[6])
> rescue MysqlException => e
> puts e.message
> end
>
> -Tom
>
> On 10/28/07, Junkone <junko...@gmail.com> wrote:
>
>
>
> > I got an exception
> > E:/TradingTools/CODE/ImportTrade.rb:20:in `execute'
>
> > The associated piece of code is
> > st= dbConn.prepare("insert into raw_data
>
> > (SYMBOL,ACTION,SIZE,PRICE,DATE_TIME_OF_TRADE ,EXECUTION,ACCOUNT_ID)
> > VALUES(?,?,?,?,?,?,?)")
> > st.execute(dataArray[0],dataArray[1],dataArray[2],dataArray[3],tradeDate,da?taArray[5],dataArray[6])
> > st.close
>
> > How do i find out what the exception details were that was triggered
> > at st.execute in this case.
> > any assistance will be appreciated- Hide quoted text -
>
> - Show quoted text
Great. It works. Can i get it to print the sql that was executed that
caused the error. becaues i am using a prepared statement