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
Greg,
categoryJobDescrID is in both you categoryJobDescr and categoryJobListing
table.
The procedure looks ok, so I can only assume that you are passing through
categoryJobDescrID as one of the fields in @orderby without a tablename
prefix.
Regards
Stephen
- Original Message -
From:
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
Greg,
This error usually indicates a failure to properly alias during a join -
where the driver can't figure out which table to pull jobdescId from.
Mark
-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 9:42 AM
To: CF-Talk
Subject: stored
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
7 matches
Mail list logo