Mika
|
| Posted: 11/10/2005, 7:51 AM |
|
Hey,
If i retrieve a Hyperlink from access it shows me something like:
<Anydescription>#<ANYLOCATION>.pdf#
Is there a way to manipulate this and remove "<Anydescription>" and the "#"
So it will only display <ANYLOCATION> as the url?
I know the easiest way is to re-write the URLs as text in the db, but that will cost me weeks to do that.
Regards,
Mika
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 11/11/2005, 12:51 AM |
|
I recommend that you don't use Hyperlink type fields in MS Access. This field is specific to MS Access applications and possibly not following database standards. I've seen many people only having trouble with it if used outside of MS Access, like in Web applications.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Mika
|
| Posted: 11/11/2005, 7:44 AM |
|
but us there a 'beforerowshow' that can delete this?
|
|
|
|
Walter Kempees
|
| Posted: 11/11/2005, 10:30 AM |
|
Does ASP have a string replace function ?
I think so, so you can manipulate the retreived string and cut out the parts
you don''t want.
I am no ASP man but I bet I can google a way around this.
"Mika" <Mika@forum.codecharge> schreef in bericht
news:64374bc642cfe8@news.codecharge.com...
>
>
> but us there a 'beforerowshow' that can delete this?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/11/2005, 11:07 AM |
|
Yep, the replace function would fix it if you like to deal with it this way. See http://www.google.com/search?q=asp+replace+function
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
