I only have a little hair left so PLEASE throw ideas at me! I get this error:
Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. I have tested the SP and it works properly. The stored procedure does exist and I copied and pasted every single variable name from the stored procedure. There is no way the field doesn't exist and I Have counted that the number of variables is identical. What could I be missing!!!? Neil ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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