ORDER BY products.product_date_available;
On 10/2/07, Casey Dougall <[EMAIL PROTECTED]> wrote:
>
> 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??
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290025
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
