I recommend making a backup copy of the current query, create a simple
base query, then incrementally add in complexity to see where it
breaks.
-Mike Chabot
On 10/2/07, Mike Little <[EMAIL PROTECTED]> wrote:
> interesting. my query is as follows...
>
> <cfquery name="getProduct" datasource="#variables.dsn#"
> password="#variables.dbpassword#" username="#variables.dbusername#">
> SELECT products.*, categories.*, categories_description.*,
> products_description.product_title, products_description.product_description,
> products_to_categories.cat_id
> FROM products
> INNER JOIN products_description ON products.product_id =
> products_description.product_id
> INNER JOIN products_to_categories ON products.product_id =
> products_to_categories.products_id
> INNER JOIN categories ON products_to_categories.cat_id =
> categories.cat_id
> INNER JOIN categories_description ON categories.cat_id =
> categories_description.cat_id
> WHERE 1=1
> <cfif isDefined("arguments.product_id")>
> AND products.product_id = <cfqueryparam
> cfsqltype="cf_sql_integer" value="#arguments.product_id#">
> </cfif>
> <cfif isDefined("arguments.cat_id")>
> AND (categories.cat_parent_id = <cfqueryparam
> cfsqltype="cf_sql_integer" value="#arguments.cat_id#">
> OR categories.cat_id = <cfqueryparam
> cfsqltype="cf_sql_integer" value="#arguments.cat_id#">)
> </cfif>
> <cfif isDefined("arguments.display")>
> AND products.product_display = <cfqueryparam
> cfsqltype="cf_sql_bit" value="#arguments.display#">
> </cfif>
> <cfif isDefined("arguments.locale")>
> AND categories_description.language_id = <cfqueryparam
> cfsqltype="cf_sql_varchar" value="#arguments.locale#">
> AND products_description.language_id = <cfqueryparam
> cfsqltype="cf_sql_varchar" value="#arguments.locale#">
> </cfif>
> ORDER BY products.product_date_available
> </cfquery>
>
> would i put the ';' after the ORDER BY statement??
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290026
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
