This Dont work, and I dont know why

[brantGuy]

the values are from an xml feed

insert into ahnFeed
(link, topic, title, pubDate, image, description)
values
('#RIGHT(world.rss.channel.item[x].guid.xmlText, 10)#', 'Sports', '#world.rss.channel.item[x].title.xmlText#', '#world.rss.channel.item[x].pubDate.xmlText#', <cfif IsDefined("#world.rss.channel.item[x].enclosure.XmlAttributes.url#")>'#world.rss.channel.item[x].enclosure.XmlAttributes.url#',<cfelse>'',</cfif> '#world.rss.channel.item[x].description.xmlText#'

 

[imstillatwork]

needs a closing ) at least. try that.

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[FALCONSEYE]

can you try this?

insert into ahnFeed
(link, topic, title, pubDate, image, description)
values
( '#RIGHT(world.rss.channel.item[x].guid.xmlText, 10)#',
'Sports',
'#world.rss.channel.item[x].title.xmlText#',
'#world.rss.channel.item[x].pubDate.xmlText#',
<cfif IsDefined("#world.rss.channel.item[x].enclosure.XmlAttributes.url#")>'#world.rss.channel.item[x].enclosure.XmlAttributes.url#'<cfelse>NULL</cfif>, '#world.rss.channel.item[x].description.xmlText#'
)

http://www.jetansolutions.com

 

[Sarky78]

Try what Kevin has suggested, and if that doesn't work then put a try/catch around the query, if there is an error then it will be caught by that and the error shown to you. like this:

<cftry>
<cfquery datasource="">
insert into ahnFeed
(link, topic, title, pubDate, image, description)
values
('#RIGHT(world.rss.channel.item[x].guid.xmlText, 10)#', 'Sports', '#world.rss.channel.item[x].title.xmlText#', '#world.rss.channel.item[x].pubDate.xmlText#', <cfif IsDefined("#world.rss.channel.item[x].enclosure.XmlAttributes.url#")>'#world.rss.channel.item[x].enclosure.XmlAttributes.url#',<cfelse>'',</cfif> '#world.rss.channel.item[x].description.xmlText#')
</cfquery>
<cfcatch type="any">
  <cfdump var="#cfcatch#">
  <cfabort>
</cfcatch>
</cftry>

Hope this helps!

Tony

 

[FALCONSEYE]

also, please tell us "what is not working?"
do you get an error message? does the insert fail?

eessss brookeeennnn

http://www.jetansolutions.com

 

[brantGuy]

Hi

this is the error im getting

Element ENCLOSURE.XMLATTRIBUTES.URL is undefined in a Java object of type class coldfusion.xml.XmlNodeMap referenced as


as you can tell, im consuming an xml news feed for sports to but on my site. instead of directly displaying the xml on the site, im saving it to cd and feed up the db info to the visitors.

now, in this feed only some stories have pictures this is whats causing the problem

 

[GUJUm0deL]

Try this:

<cftry>
<cfquery datasource="">
insert into ahnFeed
(link, topic, title, pubDate, image, description)
values
('#RIGHT(world.rss.channel.item[x].guid.xmlText, 10)#', 'Sports', '#world.rss.channel.item[x].title.xmlText#', '#world.rss.channel.item[x].pubDate.xmlText#', <cfif IsDefined("#world.rss.channel.item[x].enclosure.XmlAttributes.url#")>'#world.rss.channel.item[x].enclosure.XmlAttributes.url#',<cfelse>[b]NULL[/b],</cfif> '#world.rss.channel.item[x].description.xmlText#')
</cfquery>
<cfcatch type="any">
  <cfdump var="#cfcatch#">
  <cfabort>
</cfcatch>
</cftry>

Make sure the columnname 'image' allows NULL.

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[brantGuy]

image does accept nulls...

I wonder if there is a status code or a catch all in the xml to determin if "ENCLOSURE.XMLATTRIBUTES.URL" even exist.

sort of like in geo coding, when you get a status code of 200 for when the address cant be located..

Craig

 

[FALCONSEYE]

can you do a cfdump and see what is being passed in world.rss.channel?

http://www.jetansolutions.com

 

[brantGuy]

THIS IS THE DUMP


insert into mytabele(link, topic, title, pubDate, image, description) values ('7006812975', 'Sports', 'Diving: China Men, Women Dominate At World Championships', 'Wed, 21 Mar 2007 13:37:01 +0000', struct
Detail [empty string]
ErrNumber 0
Message Element ENCLOSURE.XMLATTRIBUTES.URL is undefined in a Java object of type class coldfusion.xml.XmlNodeMap referenced as
Resolvedname [empty string]

 

[brantGuy]

I just had an idea...its not elegant but I think It will work...if it do I will post my solution here in the next hour...if not, im introducing my laptop to gravity

 

[brantGuy]

well, it worked so my computer is safe for another day...

this is what I did, and like it said, its not pretty but it does the trick..

my initial feed was setup to include images if they were available. so when I was inserting to the DB if it happened to be missing the image...it would throw an error...

remedy
I modified the feed to forget the images all together and just capture the news stories.

then i got a second feed just pulling stories with images, I match up the second feed id with the first one and where theres a match, i dump the image...

tried it it worked.


Thanks for all the help

 

[imstillatwork]

Why not add

<cfparam name="world.rss.channel.item[#x#].enclosure.XmlAttributes.url" default="">

so that that variable always exists?

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!