Grabbing Images.. 1

[brantGuy]

I just purchased a news rss.20 feed...

Im grabbing the feed, and parsing it to my database and displaying it on my site from the DB...I wrote a cron that updates once every 30 minutes to check if rss has changed.

alot of these feeds come with video, images and soundclips.
I tried to grab the image but to no avail..I have the image name and location, how can grab it using CF

Craig

 

[Sarky78]

there is an answer, but you're not going to like it based on your experieces with cfhttp in your other post, but the solution is to do a cfhttp to the image location, and then a base64 of the content that comes back to turn it into an image, this should then be readable by the browser

hope this helps!

Tony

 

[brantGuy]

Hi Tony

Its not that I got a problem with cfhttp...lol..
its the speed...I want this to run in the background so I can serve it to my site visitors faster...how long it takes for me to get it is irrvellavent...its how fast the serfer gets it is the point..

if you could please elaborate on the base64 idea, it would be greatly appriciated...

Craig

 

[brantGuy]

been researching base64, I still cant figure it out for my senario...I think this approach will actually store the image in the db and not a directory.

I just want the image name in the directory and the actual image stored in a folder.


Craig

 

[brantGuy]

also, it only sees to work if I use images on my system, when I try an extrernam url I get this

C:\CFusionMX7\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\

http://media.worldnewsheadlines.com/media/3/67634.jpg.

 

[Sarky78]

Sorry, for the delay in getting back to you and I was leading you up the wrong garden path, with the base64 thing, it was for something else i had to do with images and cfhttp.

All you should need is this:

<cfhttp url="your_url_with_image"
        method="get"
        path="c:\some_directory"
        file="name.jpg" />

that should do it.

Hope this helps!

Tony

 

[brantGuy]

hey Tony

I modified it a bit..but there seems to be a problem

<cfquery datasource="#DSN#" name="qPullLinks">
SELECT * from 
ahnFeed
where imageLink <> '' 
</cfquery>
<cfoutput>#qPullLinks.recordCount#</cfoutput> 
<cfoutput query="qPullLinks">
Getting Image: <img src="#qPullLinks.imageLink#" /><br />
<cfhttp url="#qPullLinks.imageLink#"
        method="get"
        path="d:\branford.com\beta5\images\feeds\temp"
        file="#RIGHT(qPullLinks.imageLink, 9)#" />
		
</cfoutput>

it pulls the images and displays them on my page but wont put them in the directory specified

 

[Sarky78]

i know that tis is going to sound stupid, but can you put the cfhttp into a cfinclude, no change to the code but into a cfinclude. i had a problem with something like that a while ago and that sorted it. mind you i thought that the issue had been fixed in cf!

Hope this helps!

Tony

 

[brantGuy]

I've noticed a few situations in CF where you have to use an include to get the code to run properly...

my server is down right now and im unable to test grrrrr.

hmmmmm I think you may have solved another one of my problems with that post...2 for the price on one...

The other problem is I have a scheduled task to be run by the cfadministrator but it refuses to run cause the file it sees as a redirect...basically, I use that file to read the xml feed every 30 mins and update the DB if Necessary..

maybe I will put the cfhttp there in an include as well...



I will advise on outcome..

Craig

 

[brantGuy]

I got it partially working..

only problem is now is I put in a variable for the name and it dont work, will only accept hardcoded name.

 

[brantGuy]

so figured out that I didnt need to use the name attribue with a get cause it defaults to the name of the file your getting, which works for me but I can see issuews with that.

now, i noticed it not looping the query

 

[Sarky78]

Can you post where you are getting the rss from and i'll try and knock it up and see if i can get it to work

 

[brantGuy]

I would like to but I cant...

Its a purchased feed and my boss would flip if he found out...

 

[Sarky78]

Can you post the url's for some of the images, and I'll create a query to mimic yours

 

[brantGuy]

Thanks

http://www.brantford.com/beta5/cron.cfm

click this link...

takes a minute to populate...

 

[Sarky78]

weird! this works fine for me:

 <cfset qPullLinks = QueryNew("imageLink")> 
 <cfset temp = QueryAddRow(qPullLinks, 3)> 
 <cfset temp = QuerySetCell(qPullLinks, "ImageLink", "[URL unfurl="true"]http://media.allheadlinenews.com/media/8/78018.jpg",[/URL] 1)> 
 <cfset temp = QuerySetCell(qPullLinks, "ImageLink", "[URL unfurl="true"]http://media.allheadlinenews.com/media/6/77996.jpg",[/URL] 2)> 
 <cfset temp = QuerySetCell(qPullLinks, "ImageLink", "[URL unfurl="true"]http://media.allheadlinenews.com/media/e/77162.jpg",[/URL] 3)> 

 <cfloop query="qPullLinks"> 
  <cfinclude template="something.cfm"> 
 </cfloop>

then something.cfm is:

<cfhttp url="#qPullLinks.imageLink#" 
method="get" 
path="c:\" />

what version of cf are you using? I've got the latest

Does the above code work for you?

Hope this helps!

Tony

 

[brantGuy]

Sarky78

Thanks alot for all you help..


Craig