This year I decided to bring it back but the ColdFusion version had changed from 3 to 8 and now I can only get parts of the website to work.
I am not familiar enough with the syntax to find the problem myself so I am going to post the code from the section that is currently giving me a problem and what the error is.
<cfquery name="get_body" datasource="#idatasource#" username="#iusername#" password="#ipassword#"> SELECT SymptomID,SymptomName,SymptomVarName,SymptomID_Cure FROM Symptom_Cat WHERE Symptom_Cat.CategoryID=4 AND Symptom_Cat.SymptomVarName='#rbodytype#' ORDER BY Symptom_Cat.SymptomName,Symptom_Cat.SymptomID_Cure </cfquery>
The error that I am getting is:
The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'Symptom_Cat'.
I have looked through my database extensively and can't fin't Symptom_Cat anywhere in it so I am assuming this is a syntax issue based on the earlier code or an older SQL.
I am using SQL 2005 now am just learning SQL and ColdFusion.
P.S. The #rbodytype# is calculated earlier on the page from form results on the previous page.
Any help would be appreciated.
Let me know if you need more of the code or any details from the database.
This post has been edited by iamwebgod: 04 February 2010 - 07:23 PM