<cfsilent> <CFIF IsDefined('reviewID')> <CFSET rID = reviewID> </CFIF>
<cfif NOT IsDefined('rID') OR NOT IsNumeric(rID)> <cfheader statuscode="301" statustext="Moved permanently"> <cfheader name="Location" value="http://www.spatrends.com/"> <cfabort> </cfif>
<CFQUERY NAME="GetResults" DATASOURCE="spatrends"> SELECT Title FROM BizReviews WHERE ReviewID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#rID#"> </CFQUERY>
<cfscript> function wpSlug(theItem) { theSlug = theItem; theSlug = Replace(theSlug, ' ', '-', 'ALL'); theSlug = Replace(theSlug, '®', '', 'ALL'); theSlug = Replace(theSlug, '"', '', 'ALL'); theSlug = Replace(theSlug, '“', '', 'ALL'); theSlug = Replace(theSlug, '”', '', 'ALL'); theSlug = Replace(theSlug, ':', '', 'ALL'); theSlug = Replace(theSlug, '&', '', 'ALL'); theSlug = Replace(theSlug, '’', '', 'ALL'); theSlug = Replace(theSlug, '™', '', 'ALL'); theSlug = Replace(theSlug, '<br>', '', 'ALL'); theSlug = Replace(theSlug, '%', '', 'ALL'); theSlug = Replace(theSlug, '.', '', 'ALL'); theSlug = Replace(theSlug, '/', '', 'ALL'); theSlug = Replace(theSlug, '(', '', 'ALL'); theSlug = Replace(theSlug, ')', '', 'ALL'); theSlug = Replace(theSlug, 'é', 'e', 'ALL'); theSlug = Replace(theSlug, 'ó', 'o', 'ALL'); theSlug = Replace(theSlug, '!', '', 'ALL'); theSlug = Replace(theSlug, '---', '-', 'ALL'); theSlug = Replace(theSlug, '--', '-', 'ALL'); return theSlug; }; </cfscript>
<cfheader statuscode="301" statustext="Moved permanently"> <cfheader name="Location" value="http://www.spatrends.com/press-release/#wpSlug(LCase(GetResults.Title))#"> </cfsilent>
Original article and pictures take www.spatrends.com site
No comments:
Post a Comment