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],tradeDat=
e,da=ADtaArray[5],dataArray[6])
> rescue MysqlException =3D> 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=3D 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],tradeDat=
e,da=ADtaArray[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