ColdFusion/Railo & MySQL
ColdFusion: How to use dynamic/if based queries in CFSCRIPT
TweetAt AeonCube Networks and Host Media we have been moving our CFML code from tag based to cfscript for more performance and to keep up to date with coding in CFML. In doing so we found that when we have our cfquery’s we couldn’t simply add <cfif>/if() within our SQL code. After testing and reading what [...]
ColdFusion Tip: Turn HTML into plain text
TweetThis is a simple but effective way of getting rid of HTML tags and make the HTML string into plain text to output: #REReplace(htmlStr,”<[^>]*>”,””,”All”)# Example HTML: <h1>Title</h1><p>My content<p> Example Output after: Title My content
ColdFusion pagination with next, previous and numbers
TweetGet great ColdFusion hosting from Host Media One of the main things all developers come to in applications is pagination and the best way we found to do this is by Raymond Camden which covers how to create next and previous buttons for your content using the URL variable. As we have extended what Raymond Camden [...]
Polar CMS in alpha testing
TweetAfter 3 months of development first staging of the Polar CMS script has been released to our testers / designers to start playing with. Process of our testing Running the install program to setup the databases and user accounts Use the basic functions of the CMS: – Add pages – Add page elements to change [...]
Coldfusion DateFormat
TweetThe Coldfusion dateformat works in the same sort of fashion as the ASP.NET and the PHP date time function. As our team mainly works in Coldfusion we can expand alot more on this function that ASP.NET / PHP. The code: (Use this code within a <cfoutput></cfoutput> tag) #DateFormat(Now(), “YYYY”)# About the code: As you can [...]
Detecting iPhone, Blackberry etc using ColdFusion
TweetMany of our clients have been asking about detecting if a user is using a blackberry or iPhone etc to view their website and redirect to a mobile version of their websites. Well we have put together a little bit of code to do this: Code example: <cfif findNoCase(‘blackberry’, CGI.HTTP_USER_AGENT)> <cflocation url=”http://blackberry.yourdomain.com” addtoken=”no”> <cfelseif findNoCase(‘iphone’, [...]
vBulletin Database Coldfusion integration
TweetvBulletin use a different way of HASHING the password for users (vb_user table), we have been able to allow a Coldfusion page to retrieve the username and password to allow you to use the vBulletin database on your website for account. With this you will get an idea on adding new records into the database [...]
Having problems with not working with images
TweetWhen working with some of our clients on windows servers we have noticed Coldfusion has some problems when working with images for cfdocument. The Coldfusion shows a 60 second time out error. We found out that it was due to the image location as Coldfusion appears to pull all the files onto is main application [...]
[Tutorial] Coldfusion Detect mobile device
TweetColdfusion Detect mobile device wake dvd rip This code detects if the browsing media is a mobile/wap device and redirects to a new directory. Quote: <CFIF CGI.HTTP_ACCEPT CONTAINS “text/vnd.wap.wml”> <CFLOCATION URL=”/wap/index.cfm”> </CFIF> NOTE: This is untested but I have seen this code used on live projects.