Skip to main content
C
cinsters
Participant
October 15, 2012
Question

database migration query not executing in database

  • October 15, 2012
  • 1 reply
  • 450 views

We moved over our SQL database to another server. We have a few .cfm template files that have queries to get 'content' from our database. These queries in the .cfm template files work fine and execute properly. However, for some reason, since we moved over our database, the queries in the actual database don't execute/run anymore. In the old server we didn't have this problem. Our queries in the database would run properly then. The data would display correctly on the webpages.

Is there some kind of properties setup that was overlooked when migrating over our database?

The output we now see when viewing our pages is the actual query code.

Example:

SELECT lname

FROM table

This is actually displayed on the website and therefore the query is not executing/running. Our code was never changed. So why is it not outputting the same?

Thanks for any help provided.

This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
October 15, 2012

Your problem description is not clear.  You start by saying that the queries in the cold fusion templates work fine and then you say that sql code displays on your web page instead of query results.

If you run your query in Management Studio, do you get the expected results?

If you put the query on a standalone web page, and cfdump the resulting variable, do you see the records or sql?

C
cinstersAuthor
Participant
October 16, 2012

Sorry for the confusion.

The coldfusion templates and database queries both worked fine on the previous old server.

Now since the migration onto the new server, only the coldfusion templates work fine, but not the queries in the database.

So for example, a query in the coldfusion template will run fine, and execute the intial pull of data. But once the content is pulled from the database, the queries inside the database (including stored procedures) don't execute.

We do get the expected results when we run our stored procedure in Management Studio and if we put the stored procedure on a standalone web page we do see the records. 

We only see the sql code when we have the stored procedure inside of our w_content table of our database, and its being called by the first query in the template.  For some odd reason the stored procedure does not execute if it is inside the database.  

Hopefully that clarifies our problem.

Thank you for helping!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices