Opps
UPDATE TagtT_EFFDATEFINYRS
SET TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol],
TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem]
FROM TagtT_EFFDATEFINYRS, TagtVS_EFFDATEupd
WHERE TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno
-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of GREAVES, Maureen
Sent: Tuesday, 23 October 2007 1:17 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: LEFT JOIN in update cfquery
Thanks for your help Steve,
Im now experiencing this error with the query now using what you
suggested....
[Macromedia][SQLServer JDBC Driver][SQLServer]Tables or
functions 'TagtT_EFFDATEFINYRS' and 'TagtT_EFFDATEFINYRS' have the
same exposed names. Use correlation names to distinguish them.
Trying everything will let you know if I work it out .
-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Tuesday, 23 October 2007 1:02 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: LEFT JOIN in update cfquery
Oh your doing an update
You cant do updates like that
UPDATE TagtT_EFFDATEFINYRS
SET TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol],
TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem]
FROM TagtT_EFFDATEFINYRS, TagtVS_EFFDATEupd
WHERE TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno
I think that's right
Steve
-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Greavesy
Sent: Tuesday, 23 October 2007 12:56 PM
To: cfaussie
Subject: [cfaussie] LEFT JOIN in update cfquery
Could someone please shed some light on a cfquery that I am working on.
I
am receiving a syntax error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the
keyword 'LEFT'.
<cfquery datasource="#application.Dsn_dev0eucActuary#">
UPDATE TagtT_EFFDATEFINYRS LEFT JOIN
TagtVS_EFFDATEupd ON
TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno SET
TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol],
TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem] </cfquery>
Any guidance/help would be appreciated.
----------------------------------------------------------------------------
-------
This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of
its related entities "Suncorp".
Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13
11 55 or at suncorp.com.au.
The content of this e-mail is the view of the sender or stated author and
does not necessarily reflect the view of Suncorp. The content, including
attachments, is a confidential communication between Suncorp and the
intended recipient. If you are not the intended recipient, any use,
interference with, disclosure or copying of this e-mail, including
attachments, is unauthorised and expressly prohibited. If you have received
this e-mail in error please contact the sender immediately and delete the
e-mail and any attachments from your system.
If this e-mail constitutes a commercial message of a type that you no longer
wish to receive please reply to this e-mail by typing Unsubscribe in the
subject line.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
