palm tree lamp Comment SPAM on every post (Will be soon)

Ok, I gotta ask, what do the rest of you do to prevent comment spam. I turned up my Captcha and received less spam, but about an hour ago, I started to get comment spam about "palm tree lamp" 58 so far. At this rate in about an hour there will be comment spam on every blog post I made.



I'm not running a real old version of BlogCFC. Version 5 something... What do the rest of you running Blogcfc do to prevent this?

Justify form fields using jquery

http://www.jankoatwarpspeed.com/post/2008/07/09/Justify-elements-using-jQuery-and-CSS.aspx

Command line command for creating sites in IIS

iisweb /create D:\IIS "Test Site" /b 8080 /i 192.168.1.100 /dontstart

Here is the rest of the info:

http://thelazyadmin.com/blogs/thelazyadmin/archive/2005/06/01/IIS-Command-Line-Administration.aspx

Notes on Portcullis

<cfqueryparam cfsqltype="cf_sql_varchar" value="#url.category#">
<br>
<cfif isdefined("application.Portcullis") eq false>
<cfset application.Portcullis = createObject("component","com.fusionlink.Portcullis").init()/>
</cfif>
<cfset application.Portcullis.scan(url,"url",cgi.remote_addr)>

http://www.developer.be/index.cfm/fuseaction/faqDetail/FaqId/301.htm

Rosted Garlic

1 full Garlic bulb (big) 2 tablespoons of olive oil butter salt

Slice off the top of the bulb Pour olive oil on bulb Butter and Salt bulb Wrap in tin foil

Bake 45 min at 400

ColdFusion & Lucene: Installing Seeker Verity

Search engine, site search, Verity replacement

http://www.bytestopshere.com/post.cfm/coldfusion-lucene-solr

Augh, resoruce fork files strike again... dot underscore files /AppleDouble files

Augh, APPLE!!!, why do you have to make Resource fork files? (Ok, I know why, but that does not mean I want them all over my windows server and being uploaded to my webserver.) I want an option to keep the frigging files in a local cache or something.

If you don't know what I am raveing about:"Resource fork (._XXXXX) files, (correctly called AppleDouble files) are created by the MacOS when an application adds a resource fork to a file on a volume whose format doesn't natively support resource forks. Such as SMB, UFS and NTFS. A file's resource fork may contain information which is important, redundant or both. source: http://www.zeroonetwenty.com/blueharvest/#faq

Fixes:
To prevent Cyberduck FTP from uploading these dot underscore files:
Add "|\._.*" to the reg ex of the files to not upload. http://forums.cocoaforge.com/viewtopic.php?f=9&t=17491

Check out the new leopard command for killing off the dot underscore files
"dot_clean" http://www.macworld.com/article/132556/2008/04/geekfactor2504.html

Blueharvest is a pay for app that exists only to deal with dot underscore files

I have heard that tintertool may also fix this.

good CF code formatter for Eclipse... maybe...

... well not yet. But maybe soon?

If you are running windows and have need of a good code formatter for CF, HTML, ASP, PHP, Smarty templates, XML, etc... check out html-formatter Its cost is only $5.

I contacted Matt Pressnall of logichammer / html-formatter. html-formatter is a windows only app, but now after a few people have asked him about building an eclipse plug-in he is going to look into it. Matt will probably hate me for this, but I would encourage anyone reading this to send Matt an email requesting an eclipse plugin version of html-formatter. You can contact Matt at
support@logichammer.com

While you are harassing Matt think about buying a copy of his html-formatter, I did. (Too bad I use a Mac)
Oh and remember be kind, he has not promised to build any thing only to look into building an eclipse plugin.

html-formatter

Cannot drop tablename because it is being used for replication

If you are getting the error "Cannot drop 'sometablename' because it is being used for replication" on MS SQL server and you don't have replication even running on the server and you restored the tables from a back up, (... and it is raining on an odd day of the month in July) there is a good chance that the table is still marked for replication.

sp_MSunmarkreplinfo <tablename>

Change owner of many MS SQL tables

The internet is really in impressive reference library. I needed to change the ownership of 78 SQL tables. I was not about to click through 78 tables via the enterprise admin GUI to change ownership. I thought about getting a list of the tables and hacking together a SQL script to change the ownership with sp_changeobjectowner. Then I came across this technique the combined sp_changeobjectowner with sp_MSforeachtable.

sp_MSforeachtable @command1="sp_changeobjectowner '?', 'dbo'"

I found this and several other ways to change owner of many MS SQL tables at:
http://joseblanco.blogspot.com/2004/10/change-owner-of-all-tables-in-sql.html

Get Size of tables in MS SQL Part 2

One of the most hit articles on my blog is how to get the size of MS SQL tables with CF. I have always meant to get back to the idea and make a non CF based solution. Here is a different / better way to get the table sizes:

DECLARE @SQL VARCHAR(255)
SET @SQL = 'DBCC UPDATEUSAGE (' + DB_NAME() + ')'
EXEC(@SQL)
CREATE TABLE #foo
(
name VARCHAR(255),
rows INT ,
reserved varchar(255),
data varchar(255),
index_size varchar(255),
unused varchar(255)
)
INSERT into #foo
EXEC sp_MSForEachtable 'sp_spaceused ''?'''
SELECT *
FROM #foo
DROP TABLE #foo
I was going to build something very close to the above code but, I found this before I had the time to play at http://www.mydatabasesupport.com/forums/sqlserver-programming/188852-database-table-size.html

More Entries

BlogCFC was created by Raymond Camden. This blog is running version 5.9.001. Contact Blog Owner