URLEncode problem

nscnick · March 22, 2007

I have an access database which is searched through a frontpage generated asp page SQL query. The problem is that it translates a web address hyperlink with a %2E instead of the period, even though the link is displayed on the page correctly.Does anybody have any ideas how this can be prevented? I cannot see any immediately obvious locations in the html.

iyeru42 · March 22, 2007

If you're using a PHP file or HTML, this wouldn't happen, because when HTML is used (in either a PHP file or HTM file) the URLs are literal and you don't need stuff like that.

<a href="blah%2Ephp">

Is the same as

<a href="blah.php">

to HTML. HTML uses it interchangeably, and does not convert them to URL-safe things such as that. (Unless sending it through a query like you have done.)

pulpfiction · March 22, 2007

If you need a way to decode the URLEncode, try this.

dim str str = Server.URLEncode("/open.asp")response.write(str)response.write("<br />")response.write(URLDecode(str))function URLDecode(sText)sDecoded = sTextSet oRegExpr = Server.CreateObject("VBScript.RegExp")oRegExpr.Pattern = "%[0-9,A-F]{2}"oRegExpr.Global = TrueSet oMatchCollection = oRegExpr.Execute(sText)For Each oMatch In oMatchCollectionsDecoded = Replace(sDecoded,oMatch.value,Chr(CInt("&H" & Right(oMatch.Value,2))))NextURLDecode = sDecodedEnd function

nscnick · March 24, 2007

This is the asp fragment that takes the access field (called www) containing the url:s-column="www" b-tableformat="FALSE" b-hasHTML="FALSE" clientside local_preview="<<www>>" preview="<<www>>" --><%=FP_FieldVal(fp_rs,"www")%>The resulting viewable page (in the browser) generates as source code:<td width="547" bgcolor="#FFFFFF" height="18"> <a href="http://www%2Enscdesign%2Ecom">www.nscdesign.com </a> </td>I can see the %2E but am unsure how I can change these for the period. There doesn't seem to anything like a URL 'unencode', or should I be looking at asp to do this? I suppose I could write a scan and replace the characters but wouldn't know how to insert into the asp page. This seems to be a result of what happens from the database as putting a url directly into html doesn't produce the encoded periods. So somewhere along the upper fragment generates this change.I wouldn't know where to start trying to work out what the asp fragment is doing.

justsomeguy · March 26, 2007

That doesn't make a lot of sense to me. Both of those variables, local_preview and preview, are in this form:

<font size="-1"><<</font>www<font size="-1">>></font>

I don't see that in the HTML you pasted, so I can't determine how that HTML is a result of that code. Furthermore, this:

s-column="www" b-tableformat="FALSE" b-hasHTML="FALSE" clientside

is not syntactically-correct ASP code, I'm not sure what it is.What I'm trying to say is that from that code you posted, it is not apparent why the periods are being left encoded.

nscnick · March 27, 2007

Apologies for the length of these bits but I'm notr sure what will or not be relevant (the asp is generated by Frontpage which is called as a result of the query and then obviously generates the resultant source code displayed on the browser - I managed to work that bit out for myself, but beyond that?). The asp page (with most of the output table row code deleted for simplicity)<html><head><meta http-equiv="Content-Language" content="en-gb"><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><meta name="GENERATOR" content="Microsoft FrontPage 4.0"><meta name="ProgId" content="FrontPage.Editor.Document"><title>BDetails</title><meta name="Microsoft Theme" content="sgrp 000, default"><meta name="Microsoft Border" content="tlb, default"></head><body bgcolor="#FFFFCC" text="#000000" link="#0000FF" vlink="#800080" alink="#CC6600"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td><div align="left" style="width: 825; height: 151"> <div align="center"> <center><pre style="margin-top: 0; margin-bottom: 0"> <img border="0" src="images/logos/small%20EU_pf_logo.gif" width="203" height="60"> <img border="0" src="images/logos/scvo.gif" width="55" height="59"> <a href="http://www.berryscotland.com"><img border="0" src="images/logos/berryscot.gif" width="216" height="45"></a> <img border="0" src="images/logos/DirectGrantsLogo.gif" width="88" height="59"> <img border="0" src="images/logos/se_black.gif" width="172" height="60"></pre></center> </div> <center> <blockquote> <div align="center"> <pre style="margin-top: 0; margin-bottom: 0"><img border="0" src="images/collogo_small.jpg" align="bottom" width="65" height="50"> Strathmore & The Glens Rural Partnership <img border="0" src="images/collogo_small.jpg" align="bottom" width="66" height="50"></pre> </div> <div align="center"> <pre style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><a href="http://www.perthshire.com"><img border="0" src="images/logos/Perthshireclassicscotland.gif" width="200" height="55"></a></pre> </div> </blockquote> </center></div></td></tr></table><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td valign="top" width="1%"> <a href="http://newsrss.bbc.co.uk/rss/newsonline_uk_edition/scotland/rss.xml">BBCNews</a><a href="http://www.google.com"><img border="0" src="images/logos/googlelogo.gif" width="89" height="39"></a><a href="http://www.bbc.co.uk/weather/5day.shtml?id=3066&links">StrathmoreWeather</a><a href="http://www.mwis.org.uk/index.php">MountainWeather</a><a href="images/walking.gif"><img border="0" src="images/walking_small.gif" width="100" height="75"></a><a href="images/lochmntns.gif"><img border="0" src="images/lochmntns_small.gif" width="100" height="75"></a><a href="images/trees.gif"><img border="0" src="images/trees_small.gif" width="100" height="75"></a></td><td valign="top" width="24"></td><td valign="top"><a href="directory/busdirectory.htm" name="top">DirectoryIndex</a> <a href="index.htm">Home</a> <%fp_sQry="SELECT * FROM Table1 WHERE (name = '::name::')"fp_sDefault="name="fp_sNoRecords="No records returned."fp_sDataConn="business"fp_iMaxRecords=1fp_iCommandType=1fp_iPageSize=0fp_fTableFormat=Falsefp_fMenuFormat=Falsefp_sMenuChoice="name"fp_sMenuValue="name"fp_iDisplayCols=17fp_fCustomQuery=FalseBOTID=0fp_iRegion=BOTID%><table border="0" width="661" height="294"> <tr>.....The other field items have been deleted between the periods to make it shorter! They are are records within an html two column tableText in the LH, and the field results textbox in the RH..... <td width="90" bgcolor="#CCFFFF" height="18"> website:</td> <td width="547" bgcolor="#FFFFFF" height="18"> <a href="http://<%=FP_FieldURL(fp_rs,"www")%>"><%=FP_FieldVal(fp_rs,"www")%> </a> </td> </tr> ..... .....</table><a href="directory/busdirectory.htm">DirectoryIndex</a> <a href="index.htm">Home</a> <a href="#top">Top</a> </td></tr></table><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td></td></tr></table></body></html>The HTML source (obtained through View Source on the Browser, as above with the non-problem field rows removed):<html><head><meta http-equiv="Content-Language" content="en-gb"><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><meta name="GENERATOR" content="Microsoft FrontPage 4.0"><meta name="ProgId" content="FrontPage.Editor.Document"><title>BDetails</title><meta name="Microsoft Theme" content="sgrp 000, default"><meta name="Microsoft Border" content="tlb, default"></head><body bgcolor="#FFFFCC" text="#000000" link="#0000FF" vlink="#800080" alink="#CC6600"><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td><div align="left" style="width: 825; height: 151"> <div align="center"> <center><pre style="margin-top: 0; margin-bottom: 0"> <img border="0" src="images/logos/small%20EU_pf_logo.gif" width="203" height="60"> <img border="0" src="images/logos/scvo.gif" width="55" height="59"> <a href="http://www.berryscotland.com"><img border="0" src="images/logos/berryscot.gif" width="216" height="45"></a> <img border="0" src="images/logos/DirectGrantsLogo.gif" width="88" height="59"> <img border="0" src="images/logos/se_black.gif" width="172" height="60"></pre></center> </div> <center> <blockquote> <div align="center"> <pre style="margin-top: 0; margin-bottom: 0"><img border="0" src="images/collogo_small.jpg" align="bottom" width="65" height="50"> Strathmore & The Glens Rural Partnership <img border="0" src="images/collogo_small.jpg" align="bottom" width="66" height="50"></pre> </div> <div align="center"> <pre style="word-spacing: 0; margin-top: 0; margin-bottom: 0"><a href="http://www.perthshire.com"><img border="0" src="images/logos/Perthshireclassicscotland.gif" width="200" height="55"></a></pre> </div> </blockquote> </center></div></td></tr></table><table dir="ltr" border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td valign="top" width="1%"> <a href="http://newsrss.bbc.co.uk/rss/newsonline_uk_edition/scotland/rss.xml">BBCNews</a><a href="http://www.google.com"><img border="0" src="images/logos/googlelogo.gif" width="89" height="39"></a><a href="http://www.bbc.co.uk/weather/5day.shtml?id=3066&links">StrathmoreWeather</a><a href="http://www.mwis.org.uk/index.php">MountainWeather</a><a href="images/walking.gif"><img border="0" src="images/walking_small.gif" width="100" height="75"></a><a href="images/lochmntns.gif"><img border="0" src="images/lochmntns_small.gif" width="100" height="75"></a><a href="images/trees.gif"><img border="0" src="images/trees_small.gif" width="100" height="75"></a></td><td valign="top" width="24"></td><td valign="top"><a href="directory/busdirectory.htm" name="top">DirectoryIndex</a> <a href="index.htm">Home</a> <table border="0" width="661" height="294">......Output rows deleted...... <tr> <td width="90" bgcolor="#CCFFFF" height="18"> website:</td> <td width="547" bgcolor="#FFFFFF" height="18"> <a href="http://www%2Enscdesign%2Ecom">www.nscdesign.com </a> </td> </tr>......Output rows deleted...... </table><a href="directory/busdirectory.htm">DirectoryIndex</a> <a href="index.htm">Home</a> <a href="#top">Top</a> </td></tr></table><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td></td></tr></table></body></html>

Sign In

URLEncode problem

Recommended Posts

nscnick

Link to comment

Share on other sites

iyeru42

Link to comment

Share on other sites

pulpfiction

Link to comment

Share on other sites

nscnick

Link to comment

Share on other sites

justsomeguy

Link to comment

Share on other sites

nscnick

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Browse

Activity