RE: stored procedure - Ambiguous column name

2002-04-19 Thread cf refactoring
Try renaming your stored proc input parameter CategoryJobDescrID to something else so it doesn't have the same name as a database column. --- Greg Jordan <[EMAIL PROTECTED]> wrote: = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ___

Re: stored procedure - Ambiguous column name

2002-04-18 Thread Stephen Moretti
T statement. Regards Stephen - Original Message - From: "Greg Jordan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 4:29 PM Subject: RE: stored procedure - Ambiguous column name > the def

RE: stored procedure - Ambiguous column name

2002-04-18 Thread Greg Jordan
! -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: Re: stored procedure - Ambiguous column name Greg, categoryJobDescrID is in both you categoryJobDescr and categoryJobListing table. The

RE: stored procedure - Ambiguous column name

2002-04-18 Thread Greg Jordan
no -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:21 AM To: CF-Talk Subject: RE: stored procedure - Ambiguous column name > i've been trying to work this out for about a week and i > am stumped. i keep getting an error re

RE: stored procedure - Ambiguous column name

2002-04-18 Thread Mark A. Kruger - CFG
CF-Talk Subject: stored procedure - Ambiguous column name i've been trying to work this out for about a week and i am stumped. i keep getting an error related to an ambiguous column name. I've checked the sp over and over (with my admittedly sub-par sql skills) and cannot find anything wrong

RE: stored procedure - Ambiguous column name

2002-04-18 Thread Dave Watts
> i've been trying to work this out for about a week and i > am stumped. i keep getting an error related to an ambiguous > column name. I've checked the sp over and over (with my > admittedly sub-par sql skills) and cannot find anything > wrong. i've included the error and the sp below. any hel

Re: stored procedure - Ambiguous column name

2002-04-18 Thread Stephen Moretti
: "Greg Jordan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 3:41 PM Subject: stored procedure - Ambiguous column name > i've been trying to work this out for about a week and i am stumped. i keep > getting an erro

stored procedure - Ambiguous column name

2002-04-18 Thread Greg Jordan
i've been trying to work this out for about a week and i am stumped. i keep getting an error related to an ambiguous column name. I've checked the sp over and over (with my admittedly sub-par sql skills) and cannot find anything wrong. i've included the error and the sp below. any help is apprecia