Search engine, site search, Verity replacement

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

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.

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

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.

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.

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

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:

Here is the fix for Windows Server IIS6, not streaming FLV videos:

1. On the Windows 2003 server, open the Internet Information Services Manager.
2. Expand the Local Computer Server.
3. Right-click the local computer server and select Properties.
4. Select the MIME Types tab.
5. Click New and enter the following information:
* Associated Extension box: .FLV
* MIME Type box:flv-application/octet-stream
6. Click OK.
7. Restart the World Wide Web Publishing service.

The above was taken directly from the tech note.
Here is the tech note:
http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19439

Though, some of you out there may not agree with me, I'm going to call Fireworks, the great graphic tool, as DEAD as a door nail. Yes, yes, yes... I can already hear some of you looking for the comment button to fire off a few rounds of points my way. They will most likely sound like this, "look at the list of new features, how can you call FW dead?" or "Dude, did you even bother downloading the beta?" Or "Did you see the part about the beta not being a full feature release?" or "Just go buy Photoshop if you want Photoshop" Yes, all valid points, but hear me out.

If you hold to the old adage of growth is a sign of life, then as a graphic tool FW is dead. True FW has Lots of new really neat features. Many of the features are for related Adobe products Flex, Photoshop Import, Air and PDF. Where is the list of improvements to the graphics editing engine? Where are the V brushes, healing brush, Filters and a 10th of the other features that Photoshop is hording. I know that FW is not Photoshop and never will be. I was just hoping that Adobe would just allow the features of.. oh say photoshop 6 to filter down to FW.

Applying the same "growth is a sign of life" adage... It looks like Adobe has wrapped FW in a chrysalis and is in process of meta morphing FW into a rather handy Swiss army knife of the Adobe tool box. Though, I don't really have any use for those new features. I have more need for a new round of features to the existing graphics editing engine. After all, a graphics editing tool is what ponied up my own $ for when I bought FW CS3. So I'm left with what option, if I want more features in the graphics editing, paying BIG $ for Photoshop? Ah, I like Photoshop, I have used it since version 2.5, but it is a bit pricey for my 3-5 freelance sites I make a year.

I am hopeful that Adobe will add in a few new features to the graphics editing engine in the final shipping version, though I am not holding my breath.

Mom and Harrison are doing really well. We are all home and happy. Harrison has already started to make plans to take over the world. But first he must defeat his arch enemy the cold wet wipe.

Next week Harrison and I are planning on programming websites and rebuilding a few old cars... ok, maybe that will have to wait a few years, before we start those projects.


Harrison's first picture


Harrison and his big sister Abby and Mom


Harrison and his big sister Abby and Mom


Harrison and his big sister Abby

Last week I was all set to move several sites to new CF8 VPS and in testing I found that the CFX_PAYFLOWPRO and CF8 were not happy together. After a bit of research, it seems that some developers out there were able to get it to work, but I could not, most likely due to I had an older CFX_PAYFLOWPRO tag and the newest one is not available via Payflopro's website. In any case, spending time trying to get the CFX_PAYFLOWPRO to work with CF8 was not going to be a good idea. The system for charging cards that the custom tag uses is set to be retired September 2009.
So I went to work researching how to quickly replace the CFX_PAYFLOWPRO with the http request method.

Here is a drop in replacement for the CFX_PAYFLOWPRO custom tag, it returns the results of the transaction in a query just as the CFX_PAYFLOWPRO custom tag does.

Drop me a comment below, if this is useful to you, or if you have a suggestion on how to improve it.

Disclaimer: As always, test this before you deploy it, if you choose to do so, I will not be responsible for any damage it causes.

UPDATE:3/8/2008: I wrote a chunk of code to act as a drop in replacement to the CFX_PAYFLOWPRO tag Click here

Ok, I know that the custom tag for Pay Flow Pro is not support under CF8 and it is probably not a good idea to try and make it work, but I still need to get it working, until I can come up with another solution like the cfpayflowpro cfc
So those of you out there that are running CF8 and payflow what solution are you using?

I have seen in comments on other blogs that people have gotten ColdFusion 8 and CFX_PAYFLOWPRO to work together, but they never seem to share the "FIX" that made it work. If your one of these people, I'm looking for you.

The error I get is a cert related error. I am fairly sure, I have the "certs" folder in the correct location. Here is the error:
RESULT=-31&RESPMSG=The certificate chain did not validate, no local certificate found, Modify java.security file to add security provider&

My other thought is I might have an older version of the CFX_PAYFLOWPRO tag. What version of the CFX_PAYFLOWPRO is the latest / newest?