RE: Update query

[Daniel Pitts]

I think his parameter class has a property named "track" which is a bean with a property named "id".

 

Anyway, I would probably debug (either set a break point, or just println) the value of track and track.getId() before calling this query.

---

From: puneet arya [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 24, 2006 12:29 AM
To: user-java@ibatis.apache.org
Subject: Re: Update query

Hi,
   try to remove the . bw track and id and use track_id instead ..may be it works
like #track_id#

Regards,
Puneet Arya

Andreas Prudzilko <[EMAIL PROTECTED]> wrote:

Hello,

I was wondering why my track_id is set to 0 after an update statement. The #track.id# syntax worked fine for insert statements, my Track object is also set properly with a valid ID.

Here how it looks like:

            <update id="update" parameterClass="com.sumea.timemachine.model.SumeaProject">

                        UPDATE project

                        SET name = #name#,

                        startdate = #startDate#,

                        enddate = #endDate#,

                        color = #color#,

                        track_id = #track.id#

                        WHERE project_id = #id#

            </update>

I wonder what I’m doing wrong.

- Andreas

---

Here's a new way to find what you're looking for - Yahoo! Answers
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW