Programming
CFHTTP Connection Failure
If you’re getting a “Connection Failure” error when using the ColdFusion CFHTTP tag and have absolutely no idea what the problem could be as surfing the page via the browser works, then the web server most likely compresses the content and ColdFusion can’t handle the output.
To fix this issue just add the following two cfhttpparam [...]
How to import Excel into MS SQL
First, forget about importing Excel into MS SQL, it is to time consuming to get it right. You are better of converting the Excel file to a simple CSV file, change the setting to a large string value for the columns, import it into MS SQL and then convert the field types to the proper [...]
Read Full Post | Make a Comment ( 1 so far )Eway online payment gateway (recurring payments)
Just a quick warning for everyone who are about to use eway (www.eway.com.au) for their recurring online payments (accepting Credit Cards online etc.).
Read Full Post | Make a Comment ( None so far )SWFUpload Error 500 or Request object error ‘ASP 0104 : 80004005′ Operation not Allowed
This error is to do with the maximum file upload size allowed by ASP as global setting. By default the max size is set to 200KB.
To change this setting you need to edit the MetaBase.xml file located under c:\windows\system32\inetsrv\
Stop IIS
Open c:\windows\system32\inetsrv\MetaBase.xml
Search for “AspMaxRequestEntityAllowed”
Change the value to 1073741824 (one gigabyte) or [...]
CFPOP GMail
To check gmail with cfpop you need to use the following code before you make your cfpop call
<cfscript>
javaSystem = createObject( “java”, “java.lang.System” );
jProps = javaSystem.getProperties();
jProps.setProperty( “mail.pop3.socketFactory.class”, “javax.net.ssl.SSLSocketFactory” );
jProps.setproperty( “mail.pop3.port”, 995 );
jProps.setProperty( “mail.pop3.socketFactory.port”, 995 );
</cfscript>
<cfpop action=”getheaderonly” name=”rsEmail” startrow=”1″ maxrows=”50″ server=”pop.gmail.com” port=”995″ username=”your@username.com.au” password=”yourpassword”>
Query Of Queries syntax error. Encountered “DELETE.
If you want to delete some rows from a Query of Query with the DELETE statement you will most likely have encountered the error: Query Of Queries syntax error. Encountered “DELETE.
You can’t use the DELETE statementin QoQ.
Try the following instead
<cfquery
dbtype=”query”
name=”rsDelete”>
SELECT expiryDateTime
, cacheHash
FROM variables.instance.cacheCollection
WHERE (expiryDateTime < <cfqueryparam value=”#now()#” cfsqltype=”CF_SQL_DATE”>)
</cfquery>
<cfloop query=”rsDelete”>
rsDelete.deleteRows( javaCast( “int”, (rsDelete.currentRow [...]
ColdFusion Flickr Photos API
I’ve written a ColdFusion CFC that integrates with the Flickr API. I know there is already another component out there written in ColdFusion, but I found that one a bit too complicated (no offense intended) and it did not do what I wanted it to do, which is simply displaying the sets and photos.
See an [...]
Saving change is not permitted MS SQL 2008
Been battling with MS SQL 2008 and ran across the issue (it’s actually a feature!) of not being able to save changes made to a table in designer view. I got the following error:
Saving change is not permitted. the changes you have made require the following tables to be dropped and re-created. You have either [...]
Convert HTML entities from XML in JavaScript
Sometimes you get passed a string from XML and it can contain HTML entities like the following
&
<
>
"
©
®
«
»
'
If you write the string with JavaScript then you get something like didn't instead of didn’t
I’ve searched around for a function that could handle this but could not find one, so I wrote my own. I thought I’d share [...]
Convert Microsoft Word Characters
I’ve written a JavaScript function a while ago that converts Microsoft Word Characters (crap) to valid HTML characters. Till today I didn’t realize how valuable the function is, it could probably do with some expansion on what it converts so any help to improve is much appreciated.
Read Full Post | Make a Comment ( 1 so far )« Previous Entries