COLD FUSION summary.cfm

<cfset pfid = url.pid > <cfquery name="getPfTag" datasource="#DS#"> select portfoliotag, description from tblportfoliodef where portfolioid = #pfid# </cfquery> <cfinvoke component="components.portfoliopath" method="showportfoliopath" returnvariable="getportfolio" > <!--- <cfdump var="#getPfTag#" > ---> <!--- <cfquery name="getMemberID" datasource="#DS#"> Select * from tblentitymember where intMemeberid = #eid# </cfquery> ---> <cfquery name="getPfStyle" datasource="#DS#"> select * from tblportfoliostyle where portfolioid = #pfid# </cfquery> <cfquery name="getMemberData" datasource="#DS#"> SELECT *,t.strEntityName, t.strEntityEMail, t.strEntityUrl, t.strPostCode, t.strAddress01, t.strAddress02, t.strAddress03, t.strAddress04, t.strTown, t.strCounty, t.strMainPhone, t.strMainFax, t.isLogo, t.isListing, t.intPayed,t.strDisplayImage,t.strFullTeaser FROM tblentity t WHERE t.intPortfolioid= #pfid# </cfquery> <cfquery name="getLogo" datasource="#DS#"> SELECT * FROM tblEntity WHERE intPortfolioid= #pfid# </cfquery> <cfparam name="page" default="top"> <cfoutput> <div class="jumbotron"> </div> <Cfset count = 1> <div class="container-fluid bg-3 text-center"> <h2 style="padding-left: 14px; padding-right: 14px; padding-bottom: 20px"> #getPfTag.description#</h2> </div> <div class="container-fluid bg-3 text-center"> <div class="row"> <cfloop query="getportfolio"> <div class="col-sm-3"> <cfinvoke component="components.photos" method="photo" returnvariable="getphotos" folioid= "#folioid#" ds="#ds#" primaryphoto="1"> <a href="/portfolio/#getPfTag.portfoliotag#/#getportfolio.projecttag#/"> <cfif getphotos.PHOTO gt ''> <img src="/mycm/portfolio/#getportfolio.entityid#/bigimages/#getphotos.PHOTO#" class="img-responsive" alt="#getphotos.alt#"> <cfelse> <cfif getportfolio.defaultitem IS "mp3" > <img src="/images/mp3_icon.gif" border="0"> <cfelseif getportfolio.defaultitem IS "utube" > <img src="/images/youtube_icon.gif" border="0"> <cfelseif getportfolio.defaultitem IS "video" > <img src="/images/flv_icon.gif" border="0"> <cfelse> <img src="/art/samples/#getLogo.strDisplayImage#" border="0"> </cfif> </cfif> </a> <a href="/portfolio/#getPfTag.portfoliotag#/#getportfolio.projecttag#/"><h3>#FOLIOITEMTITLE#</h3></a> <cfif client gt ''><p class="client">Client: #client#</p></cfif> <p>#left(FOLIOITEM,150)# <a href="/portfolio/#getPfTag.portfoliotag#/#getportfolio.projecttag#/">... more</a></p> </div> </cfloop> </div> </div> </cfoutput> <!--- #UTUBE# ---> <!--- <cfif count MOD 2 eq 0 > </tr> <tr ALIGN="CENTER" style="padding:5px;" > </cfif> <Cfset count = #count#+1> --->