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.).

 If you are using their services in Development and you test it once in LIVE they will assume you are now using their services and will whack you with a yearly $400 fee. I wasn’t even aware of the yearly fee until I got whacked with it. Make sure you read the fine print on this.

 Keywords: recurring online payments, eway, payment gateway api

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\

1. Stop IIS
2. Open c:\windows\system32\inetsrv\MetaBase.xml
3. Search for “AspMaxRequestEntityAllowed”
4. Change the value to 1073741824 (one gigabyte) or some other maximum value that’s valid for your setup
5. Save and close the file
6. Start IIS

ClixGalore Affiliate Marketing, www.clixgalore.com.au – www.clixgalore.com

This is another one of those cases where I have to write about an unpleasant experience that will save you some headaches, time and money.

If you are thinking about using ClixGalore for your affiliate marketing – don’t! We used ClixGalore Affiliate Marketing both for Advertising and to generate extra revenue.

I have to admit I ignored posts warning me about ClixGalore and can now only blame myself. But I hope you’re smarter than I was!

We’ve build up a nice commission with ClixGalore and asked how to get the money out, that on its own was a painful process! The guys from ClixGalore are very unhelpful, full of riddles and can’t give straight answers. When I finally figured out the puzzle, it was something like “we process on the 1^st of the month if the payment threshold is met, then it takes another 21 days to go through another process, and then it gets processed”….. errrrrr….

In any case, our payment should have been processed weeks ago, but it’s completely off the radar, the amount doesn’t even show up in their system anymore, we’ve gone to ZERO. The only answer I get is “I have to talk to my manager”, “I passed it on to my manager”.

Honestly, save yourself some time and don’t join these people. If you have any questions in regards to them please don’t hesitate to ask, or if you have similar experiences with these people post them below.

Keywords: Warning, Bad, Don’t pay

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 – 1) ), javaCast( “int”, 1 ) );
</cfloop>

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 example of the FlickrCFC in use here Boot Camp Photos

I’m more than happy to share the code base, it’s not ready yet for publishing here but can certainly send a copy to anyone who requests it. Of course a nice text link in return is always appreciated!

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 made changes to a table that cant be re-created or enabled the option Prevent Saving changes that require the table to be re-created.

Seems there is an easy fix (if you know where to look), go to
Tools Menu >
Options >
Designers >
And untick the option “Prevent saving changes that require a table re-creation”

Convert HTML entities from XML in JavaScript

Sometimes you get passed a string from XML and it can contain HTML entities like the following

&amp;
&lt;
&gt;
&quot;
&copy;
&reg;
&laquo;
&raquo;
&apos;

If you write the string with JavaScript then you get something like didn&apos;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 it with the world!

The following will convert &amp; to &, convert &apos; to ‘ etc.

Following is the code, if you need help implementing it, I’m more than happy to explain how you install and run this function in return for a text link on your website, now that’s cheap as, considering I normally charge $140 an hour

String.prototype.trim = function () {
	return this.split( /\s/ ).join( " " );
}
String.prototype.convertHTMLEntity = function () {
	var myString = this;
	myString = myString.replace( /\&/g, '&' );
	myString = myString.replace( /\&lt;/g, '<' );
	myString = myString.replace( /\&quot;/g, '"' );
	myString = myString.replace( /\&copy;/g, '©' );
	myString = myString.replace( /\&reg;/g, '®' );
	myString = myString.replace( /\&laquo;/g, '«' );
	myString = myString.replace( /\&raqou;/g, '»' );
	myString = myString.replace( /\&apos;/g, "'" );
	return myString;
}

Facebook advertising

We’ve been advertising online on facebook for a while and have been seriously disappointed with the results so far. Just wondering if anyone else is experiencing the same results?

Taking the web statistics for this month

facebook.com
20 visits
Avg. time on site: 00:00:00
100% new visits
100% bounce rate

Nowhere else in our statistics have we got a bounce rate of 100% or average time on site of zero, and I mean nowhere. It almost feels as if these are automated visits.

Would love to hear from others out there using facebook for advertising?

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.

For those needing the function, just send me an email or leave a comment.

/*
	‘ = 8216 convert to '
	’ = 8217 convert to '
	“ = 8220 convert to "
	” = 8221 convert to "

	bullet points from word: 61558, 8226, 61607
	convert them all to 111

	dash 8211 convert to -

	... 8230 convert to ...

	trademark symbol 8482 convert to TM

	copyright symbol 169 convert to (c)

	registered symbol 174 convert to (r)

	>> 187 convert to >>

	<< 171 convert to <<

/


function convertCharacter( obj ) {
	var myRegEx = new RegExp( String.fromCharCode( 8216 )
 + "|" + String.fromCharCode( 8217 ), "g" );
	obj.value = obj.value.replace( myRegEx, "'" );
	var myRegEx = new RegExp( String.fromCharCode( 8220 )
 + "|" + String.fromCharCode( 8221 ), "g" );
	obj.value = obj.value.replace( myRegEx, '"' );

	var myRegEx = new RegExp( String.fromCharCode( 61558 )
 + "|" + String.fromCharCode( 8226 ) + "|"
+ String.fromCharCode( 61607 ), "g" );
	obj.value =
obj.value.replace( myRegEx, String.fromCharCode( 111 ) );

	var myRegEx = new RegExp( String.fromCharCode( 8211 ), "g" );
	obj.value = obj.value.replace( myRegEx, "-" );

	var myRegEx = new RegExp( String.fromCharCode( 8230 ), "g" );
	obj.value = obj.value.replace( myRegEx, "..." );

	var myRegEx = new RegExp( String.fromCharCode( 8482 ), "g" );
	obj.value = obj.value.replace( myRegEx, "TM" );

	var myRegEx = new RegExp( String.fromCharCode( 169 ), "g" );
	obj.value = obj.value.replace( myRegEx, "(c)" );

	var myRegEx = new RegExp( String.fromCharCode( 174 ), "g" );
	obj.value = obj.value.replace( myRegEx, "(r)" );

	var myRegEx = new RegExp( String.fromCharCode( 187 ), "g" );
	obj.value = obj.value.replace( myRegEx, ">>" );

	var myRegEx = new RegExp( String.fromCharCode( 171 ), "g" );
	obj.value = obj.value.replace( myRegEx, "<<" );
}