Re: Adding hypertext data element into record ...

[Hassan Schroeder]

Andrew Lietzow wrote:

RE: 1) Is there no field type/data element type/column type that will allow a string to be treated as a hypertext link directly from MySQL?

No, there is no URL/URI datatype, but your *application* can treat
any data you like as a URL.

So, are you saying that if I am using phyMyAdmin and displaying records to the screen, and if one of the fields contains data like "http://mydomain.com/photos/mycoolpic.jpg"; that there is no way to make this "clickable" as a hypertext link?

This is *application* behavior. Even if there were a URI datatype,
that wouldn't imply that data of that type could *only* be used in
a hypertext-enabled application, or *only* as the value of the href
attribute of a link.

Neither can a database know what you want a "link" to look like --
<http://www.w3.org/TR/html4/struct/links.html#edef-A> lists twelve
attributes (plus [%coreattrs, %i18n, %events]) for the anchor tag
*in addition to* "href"; how would you propose to determine those
values? :-)

FWIW,
--
Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                          dream.  code.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]