xyzit wrote:
> In article <44d61a49$0$10470$ba620e4c@news.skynet.be>, anti@spam.com
> says...
>
>>"xyzit" <xyzitabc@hotmail.com> wrote in message
>>news:MPG.1f3d8cba990da5a5989688@newsbin.telenet. be...
>>
>>>In article <hq6dnVRgYv7mBU_ZnZ2dnUVZ_v2dnZ2d@comcast.com>,
>>>jstucklex@attglobal.net says...
>>>
>>>>xyzit wrote:
>>>>
>>>>>Is there a possibility (a data-type) to insert an URL-adress in a
>>>>>field of a mysql-database
>>>>>
>>>>>TIA
>>>>
>>>>It's just character data. VARCHAR should do quite nicely.
>>>>
>>>>
>>>
>>>But, is it "clickable" ?
>>
>>There is no "URL" datatype, if that is what you mean. You have to put it in
>>a character field. Of course you could write your own constraints to check
>>if the string is a valid URL (although that would be not that easy).
>>
>>
>>
>>
>
> What I want is, when you type a valid url-adress in a certain field of a
> databaserecord ( http://www.zot.be), and when I click (in my website )
> on it that I go to that URL-adress.
> Meanwhile I found it - in Firefox it is "clickable" - in IE, it is not
> -there it is just "dead" text.
> (I am not a professional - I just try things - sorry)
>
>
That is a function of the display of the data, not the storage. The
right way to do this is to create an anchor tag for the URL.
It has nothing at all to do with the database.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================