Re: Update query

[puneet arya]

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