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
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
: 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
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
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
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
-
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
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
8 matches
Mail list logo