what you were returning/outputting was the same (typeDesc). Different
names, but there's no reason not to name them the same. The only real
difference is the value of typeID, which I passed as a dynamic value.
Here's the code with a few addt'l comments inline.
<!---
the query based on URL.prodID to return typeID.
would preferrably change the SELECT * to only those fields (or field)
that you need.
also, used <cfqueryparam> because every time you don't use
<cfqueryparam> a kitty cat dies.
--->
<cfquery name="rdDetails" datasource="#dsn#">
SELECT *
FROM tblProducts
WHERE
ProdID = <cfqueryparam value="#URL.prodID#" cfsqltype="cf_sql_integer">
</cfquery>
<!--- we're looking for typeIDs between 1 and 3 specifically...that's
what this cfif is checking... --->
<cfif (rdDetails.typeID GTE 1) AND (rdDetails.typeID LTE 3)>
<!---
we're between 1 and 3, so run the query below.
same suggestion re: using the SELECT *... would suggest specify fields.
used <cfqueryparam> again to save a kitty.
--->
<cfquery name="rsType" datasource="#dsn#">
SELECT *
FROM tblTypes
WHERE
typeID = <cfqueryparam value="#typeID#" cfsqltype="cf_sql_integer">
</cfquery>
<cfoutput query="rsType">
#trim(typeDesc)# <!--- outputting our query data --->
</cfoutput>
<cfelse>
<!--- we had a typeID other than 1,2 or 3...so include the
defaultdetails.cfm template --->
<cfinclude template="defaultdetails.cfm" />
</cfif>
--
Charlie Griefer
================================================
Marta was watching the football game with me when she said,
"You know, most of these sports are based on the idea of one group
protecting its territory from invasion by another group."
"Yeah," I said, trying not to laugh. Girls are funny.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
