[cfaussie] Re: LEFT JOIN in update cfquery
LEFT OUTER or LEFT INNER -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. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: LEFT JOIN in update cfquery
Or LEFT FULL LEFT JOIN is invalid -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. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[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] FROMTagtT_EFFDATEFINYRS, TagtT_EFFDATEFINYRS 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. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: LEFT JOIN in update cfquery
Try UPDATE TagtT_EFFDATEFINYRS SET TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol], TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem] FROM TagtVS_EFFDATEupd LEFT JOIN TagtT_EFFDATEFINYRS ON TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno You might have to change the LEFT JOIN to a RIGHT JOIN now Pauline On Oct 23, 12:55 pm, Greavesy [EMAIL PROTECTED] wrote: 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. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[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 exposednames. 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] FROMTagtT_EFFDATEFINYRS, TagtT_EFFDATEFINYRS 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 -~--~~~~--~~--~--~---
[cfaussie] Re: LEFT JOIN in update cfquery
Opps UPDATE TagtT_EFFDATEFINYRS SET TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol], TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem] FROMTagtT_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 exposednames. 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] FROMTagtT_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 -~--~~~~--~~--~--~---
[cfaussie] Re: LEFT JOIN in update cfquery
This one is working. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of paulineb Sent: Tuesday, 23 October 2007 1:07 PM To: cfaussie Subject: [cfaussie] Re: LEFT JOIN in update cfquery Try UPDATE TagtT_EFFDATEFINYRS SET TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol], TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem] FROM TagtVS_EFFDATEupd LEFT JOIN TagtT_EFFDATEFINYRS ON TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno You might have to change the LEFT JOIN to a RIGHT JOIN now Pauline On Oct 23, 12:55 pm, Greavesy [EMAIL PROTECTED] wrote: 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 -~--~~~~--~~--~--~---
[cfaussie] Re: LEFT JOIN in update cfquery
Thank you Pauline -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of paulineb Sent: Tuesday, 23 October 2007 1:07 PM To: cfaussie Subject: [cfaussie] Re: LEFT JOIN in update cfquery Try UPDATE TagtT_EFFDATEFINYRS SET TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol], TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem] FROM TagtVS_EFFDATEupd LEFT JOIN TagtT_EFFDATEFINYRS ON TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno You might have to change the LEFT JOIN to a RIGHT JOIN now Pauline On Oct 23, 12:55 pm, Greavesy [EMAIL PROTECTED] wrote: 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 -~--~~~~--~~--~--~---