Skin Spider : Miscellaneous Updates

Posted November 15, 2006 at 8:22 AM by Ben Nadel

Tags: ColdFusion, Skin Spider

To learn all about Skin Spider, click here.

To view the most updated application, click here.

To view the current code base, click here.

Just a few minor updates that I wanted to post before I moved onto some bigger changes.

Spider Gallery

I have updated the spider_gallery.cfm ColdFusion template to use a CFTry / CFCatch tag set wrapped around the Web Shot CMD CFExecute tag. The Web Shot application is set to have a timeout of 120 seconds. Some sites were causing this to crash (go longer than the timeout). I am not sure what causes that, but I think sites with lots of DHTML and stuff cause the app to get all confused. I don't know... that's one of the down sides to using 3rd party software - you just don't know how to fix it.

Now, it should work fine, just as it did before, but if the executable times out then it just displays a nice error message and the page keeps on processing.

Clean Library

Now that we have a nice video rating system in place, I have added a "Ratings Based Criteria" to the clean_library.cfm ColdFusion template. This allows the user to delete all videos below a given rating. There a few caveats here. Since it is not an inclusive delete, it means that you cannot use this to delete any videos with a rating of "10." But come on, whose gonna do that?!? Also, since all non-rated videos have a default rating of "0" it means that any video that has not been explicitly rated will be deleted regardless of which rating was selected (as a delete criteria). I think this actually works out quite nicely. And, as usual, no video that has been flagged as being a favorite video will be deleted.

Spider Content

I have added a "clear queue" link to the spider.cfm ColdFusion template. This just deletes all records from the queue. Right now, the link just calls the spider.cfm ColdFusion template and passes along the URL "Action" variable set to "clear." Then, during pre-page processing, I check to see if the action is set to "clear" and act accordingly. I am not sure if this is the best way to do it. I don't like that the clear functionality feels like such an after-thought (which it was). We can always move it later when a better place presents itself.



Reader Comments

There are no comments posted for this web log entry.

Post A Comment

Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Please review the following issues:

Author Name:


Author Email:

Author Website:

Comment:

Supported HTML tags for formatting: <strong>bold</strong>   <em>italic</em>   <code>code</code>







  • Help Wanted - Find Your Next ColdFusion Job
Ben Nadel's Company - Epicenter Consulting Recent Blog Comments
May 23, 2013 at 9:52 PM
Preventing Links In Standalone iPhone Applications From Opening In Mobile Safari
@Muhmmadibn Did you figure out a solution to launching PDFs? I am running into the same issues myself. There is no way to close the PDF or go back once you launch it. Thanks in advance! ... read »
May 23, 2013 at 6:06 PM
The Girl Who Broke My Heart, And Made Me A Better Person
Good day,ladies and gentle men, my name is Dr AMADI the great spell caster in Africa, i have help so many people for different kind of problems,who say there is no solution to problems on earth, that ... read »
May 23, 2013 at 4:26 PM
ColdFusion QueryAppend( qOne, qTwo )
@Heather, Glad people are still getting value out of this! ... read »
May 23, 2013 at 3:49 PM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@WebManWalking, I meant the code at the bottom (not the video). I did try to experiment with an intermediary variable, like: value = users.id[ i ]; arrayContains( userIDs, value ); ... but t ... read »
May 23, 2013 at 11:06 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@Ben, Are you talking about As Number: YES As String: YES As Java: YES? If so, that's with 3 different ways of referencing the constant 1, not users.id[1]. Query object references(*) are what seem ... read »
May 23, 2013 at 9:55 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@Dan, According to the CF Admin, I'm running Java "1.6.0_45". As far as the DB column, in the database it's an INT. I'll see if I can dig into what CF sees it as. @WebManWalking, But h ... read »
May 23, 2013 at 9:49 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@Ben, I think the problem is that we're used to loose typing in ColdFusion, like JavaScript. If a value is a number but it's needed in an expression to be a string, noooo problem. I've encountered ... read »
May 23, 2013 at 9:47 AM
ColdFusion QueryAppend( qOne, qTwo )
You rock! Thank you, thank you, thank you!!! ... read »
InVision App - Prototyping Made Beautiful With Prototyping Tools