If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Long (403 character) URLs stored in hyperlinks?
I'm using perl to store urls in fields of type hyperlink. It seems that it
truncates them to 255 characters. Is this a problem with the perl DBI or MS Access? I've tried using text, memo and OLE object (I cannot remember what those are called -- something like OLE Object) and none of them allow me to store more than 255 characters. The latter type seems to corrupt my string too (although the documenation warned me about that possibility). I get an "[]" append on to the end of my url when I use "OLE Object" to store my url. Any perl programmers know of a workaround? Sieg |
#2
|
|||
|
|||
Memo fields can certainly store 403 character strings without any problems,
so I suspect that the problem's either with the perl DBI or with your code. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Siegfried Heintze" wrote in message ... I'm using perl to store urls in fields of type hyperlink. It seems that it truncates them to 255 characters. Is this a problem with the perl DBI or MS Access? I've tried using text, memo and OLE object (I cannot remember what those are called -- something like OLE Object) and none of them allow me to store more than 255 characters. The latter type seems to corrupt my string too (although the documenation warned me about that possibility). I get an "[]" append on to the end of my url when I use "OLE Object" to store my url. Any perl programmers know of a workaround? Sieg |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
Automatically up date time in a cell | Mark | General Discussion | 5 | May 12th, 2005 12:26 AM |
Troubleshoot the SendObject method | Nikky_Pickles | General Discussion | 1 | August 30th, 2004 07:40 AM |
Rich Text Spell Check | Stephen Lebans | General Discussion | 0 | July 27th, 2004 01:03 AM |
Running Access from network | Alan Fisher | Using Forms | 4 | July 3rd, 2004 02:37 AM |