Macromedia ColdFusion

-Experience with current job.

-One of the leading web programs out there. Many sites use to manage ecommerce.

-Needed to create a page which took an author name, journal name, and book title and created a word document that would be printed out. The printout would then be sent to the customer. The printout  pulls their address, price of the book, author, description, etc. into a letter. All fields needed to be pulled from two separate folders. Obviously, the names were not blacked out.

Some Coldfusion/ SQL Code code to access the database:  (Code changed for security reasons)

<cfquery name="ReviewersDetails" datasource="Review">
SELECT *
FROM Journal_Details
WHERE Journal_Details.Review_Number= #id#;
</cfquery>
//This is selecting all the fields from Journal_Details table from the Review database.//
<cfquery name="ProductDetails" datasource="PD">
SELECT *
FROM tblPublisherList RIGHT JOIN (tblAuth RIGHT JOIN (tblPrice RIGHT JOIN tblProd ON tblPrices.intItemID = tblProd.intIDProdID) ON tblAuth.intProdID = tblProd.intIDProdID) ON tblPublishList.intPublisherID = tblProd.intPublishID
WHERE tblProd.intIDProdID= #id2#;
</cfquery>

Some code to create the output. (Code changed for security reasons)

<cfoutput query="ProdDetails">
<cfset pname= strTitle>
<cfset description= memDescription>
<cfset fname= strFirstName>
<cfset lname= strLastName>
<cfset location= strAfilication>
<cfset publisher= strPName>
<cfset pubdate = #Dateformat(datPubDate, "MMMM YYYY")#>
<cfif pubdate eq ""> <cfset pubdate= ""> <cfelse> <cfset pubdate="<tr><td></td><td>Published: #pubdate#</td></tr>"> </cfif>

Close This Window