Insert hyperlink into table

[Gene_Godsey]

I asked this question on MSDN with no success and now I will try out ADOBE's smart guys.

This is a simple request. I need to get a stored procedure that will parse an HTML document like a favorite list and extrapolate the link into 2 seperate columns into a database. one column would be the hyperlink and the other would be the text in the link.

Any ideas?????

Thanks in advance,

Gene

[Daverms]

Hi,

Refer the List functions of cf here

[Gene_Godsey]

NOT THERE!

I need to take a list of links and parse them so they can be inserted into a database w/2 columns.
1 column is the link's text
2 column is the hyperlink itself.

[Gene_Godsey]

NOT THERE!

I need to take a list of links and parse them so they can be inserted into a database w/2 columns.
1 column is the link's text
2 column is the hyperlink itself.

[Daverms]

Hi Gene,

First of all, try to put up a list form your html content using the hrefsToList udf, and then you can parse them using the ParseURLData udf..

HTH

[CF_output]

* duplicate post *

[CF_output]

Gene, I would reccommend using cfhttp - it will gather up the entire html of a page, and you can parse through it with you're preferred method to get the links..

Here's a site that walks you through the process using cfhttp and xpath to gather links on a website.

http://www.anujgakhar.com/2007/11/21/extracting-links-using-xpath/