Query works with MX, but not 5

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bacteria Man - 29 Sep 2004 22:00 GMT

I have a simple query on query:

<cfquery name="qryLoadProduct" dbtype="Query">
SELECT LoadAllProduct.*
FROM LoadAllProduct

</cfquery>

It works perfectly under MX, but fails under 5.0 with the following error:

Query Manipulation Error Code = 0

Invalid SQL

I tried to hardcode the WHERE clause without success:

WHERE LoadAllProduct.ProductID = 1

Any suggestions would be greatly appreciated.

Reply to this Message

Bacteria Man - 29 Sep 2004 22:20 GMT

Sorry, the query should look like this:

<cfquery name="qryLoadProduct" dbtype="Query">
SELECT LoadAllProduct.*
FROM LoadAllProduct
WHERE LoadAllProduct.ProductID = #strProductID#
</cfquery>

Reply to this Message

Bacteria Man - 29 Sep 2004 22:30 GMT

Figured it out. The SELECT clause doesn't like the table prefix declaration
under version 5.

<cfquery name="qryLoadProduct" dbtype="Query">
SELECT *
FROM LoadAllProduct
WHERE LoadAllProduct.ProductID = #strProductID#
</cfquery>

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / September 2004

Query works with MX, but not 5