xml to sql DB

[brantGuy]

Hey, hope someone can help

I have the following working

<cfif #qCheckDups.recordCount# eq 0>
insert into ahnFeed
(link, topic, title, pubDate, description)
values
('#world.rss.channel.item[x].guid.xmlText#', 'Sports', '#world.rss.channel.item[x].title.xmlText#', '#world.rss.channel.item[x].pubDate.xmlText#', '#world.rss.channel.item[x].description.xmlText#'
)

but its missing the image field...thing is images only come through with the feed every so ofter so when there is no image my app crashes.

<cfif #qCheckDups.recordCount# eq 0>
insert into ahnFeed
(link, topic, title, pubDate, description, image)
values
('#world.rss.channel.item[x].guid.xmlText#', 'Sports', '#world.rss.channel.item[x].title.xmlText#', '#world.rss.channel.item[x].pubDate.xmlText#', '#world.rss.channel.item[x].description.xmlText#', '#world.rss.channel.item[x].enclosure.XmlAttributes.url#'
)

any ideas how to acomplish this

 

[brantGuy]

hope I explained this properly

 

[harebrain]

Image field a datatype mismatch?