> 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 appreciated very much. > > *******************error message*********************** > > Error occured at: 04/17/02 16:05:24 > > Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; > .NET CLR 1.0.3705) > > ODBC Error Code = 37000 (Syntax error or access violation) > [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous > column name 'categoryJobDescrID'.
I don't see an obvious error, but are you referencing that field in your @orderby string? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists