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

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

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 error related to an ambiguous column name. I've checked

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 help

RE: stored procedure - Ambiguous column name

2002-04-18 Thread Mark A. Kruger - CFG
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. i've included the error

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 related

RE: stored procedure - Ambiguous column name

2002-04-18 Thread Greg Jordan
- 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 procedure looks ok, so I can only assume

Re: stored procedure - Ambiguous column name

2002-04-18 Thread Stephen Moretti
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 default orderby is dateTimeEntered desc. here is cfml. thanks again! cfparam name