yes
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??
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290024
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
