RB update up on the Adobe download page

The Adobe download page has been updated with the Report Builder fixes mentioned in the previous post. Namely, parameter errors going into and out of the Query Builder and the Query Builder losing information you had typed in when you came back into the Query Builder "SQL" mode.

You can download the updated version from here (build number 144677): http://www.adobe.com/support/coldfusion/downloads.html

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
Hi,

Anyone got round to playing with RB8? Having issues similar to the RB7 where it loses any code written in the advanced SQL mode. It doesn't crash, just ignores the information and assumes nothing has been typed.

Cheers

Jim
# Posted By Jim | 9/11/07 9:35 AM
thanks Dean Harmon.I noted those codes.
# Posted By sophie | 9/22/07 11:56 PM
Here is a handy little function to strip stuff out of a HTML field:
<cffunction name="tagStripper" access="public" output="true" returntype="string">
   <cfargument name="htmlDocument" required="YES" type="string">
   <cfargument name="exceptions" required="no" type="string">

   <cfset var returnString = arguments.htmlDocument />
   
   <cfloop list="#arguments.exceptions#" index="goodTag">
      <cfset returnString = REReplaceNoCase(returnString, "</#goodTag#>" , "_!_[P_!_/#goodtag#_!_P]_!_", "all") />
      <cfset returnString = REReplaceNoCase(returnString, "<#goodTag#\b[^>]*>" , "_!_[P_!_#goodtag#_!_P]_!_", "all") />
   </cfloop>
   <cfset returnString = REReplaceNoCase(returnString, "<[^>]*>" , "", "all") />
   <cfset returnString = replaceNoCase(returnString, "_!_[P_!_" , "<", "all") />
   <cfset returnString = replaceNoCase(returnString, "_!_P]_!_" , ">", "all") />
   
   
   <cfset returnString = ReReplace(returnString, "&nbsp;"," ", "ALL") />
   <cfset returnString = ReReplace(returnString, "&bull;"," * ", "ALL") />
   <cfset returnString = ReReplace(returnString, "&lsaquo;","<", "ALL") />
   <cfset returnString = ReReplace(returnString, "&rsaquo;",">", "ALL") />
   <cfset returnString = ReReplace(returnString, "&trade;","(tm)", "ALL") />
   <cfset returnString = ReReplace(returnString, "&frasl;","/", "ALL") />
   <cfset returnString = ReReplace(returnString, "&lt;","<", "ALL") />
   <cfset returnString = ReReplace(returnString, "&gt;",">", "ALL") />
   <cfset returnString = ReReplace(returnString, "&copy;","(c)", "ALL") />
   <cfset returnString = ReReplace(returnString, "&reg;","(r)", "ALL") />
   
   <!--- Remove all others. More special character conversions can be added above if needed --->
   <cfset returnString = ReReplace(returnString, "&(.{2,6});", "", "ALL") />

   
   <cfreturn returnString />
</cffunction>
# Posted By Jared Riley | 1/31/08 5:28 PM
Trying to use XHTML Text Formatting - I have tried text of the form:
<P ALIGN="LEFT"><FONT SIZE="3" COLOR="#FF0000">Trust Company <B>Superannuation</B> Services Limited (TCSSL) is the Trustee of the Fund</FONT></P>
But the font size and colour specs are ignored. I have placed the word Superannuation in bold to prove that the field really is XHTML and this along with underlining, etc. render correctly. Any thoughts please?
# Posted By Barry Brunning | 2/21/08 11:20 PM
BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.