Archive for May, 2009
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 [...]
