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 the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290023
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
