Insert hyperlink into table

Forum|Forum|17 years ago
March 18, 2008
5 replies
591 views

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

This topic has been closed for replies.

A

Anonymous

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/

A

Anonymous

* duplicate post *

Gene_GodseyAuthor

Inspiring

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.

D

Daverms

Inspiring

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

Gene_GodseyAuthor

Inspiring

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.

D

Daverms

Inspiring

Hi,

Refer the List functions of cf here

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded