Displaying and editing long hyperlink data in mySQL/ASP
Posted on 2006-06-06
Am a complete newcomer to ASP/mySQL. I have one field in a mySQL table which stores long hyperlinks (Multimap page references). Have read the data in from an Access database where it was stored in a memo field. Have defined the mySQL field as a blob field. Is this the best field type to use? How can I set up an object on a form (presumably a textarea) in which I can read and edit the hyperlink. At present the data is not intelligible in the textarea, though I can read it in mySQL Front by highlighting the field and selecting the text tab, so the data is there.
Can I convert the data so it can be displayed in the textarea? If I cannot edit the data in that form, can I provide a button alongside the textarea which will display a dialog where the hyperlink can be changed/deleted and then fed back into the blob, or is this the wrong way to do it? If so, HOW can I do it?