InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 05:49:08 GMT20http://forum.strataframe.net/FindPost24748.aspxI have a need to encode the results of a SQL query for use with the web listview. I'm querying a database I have no control over to get a list of contracts. The contract ID is a varchar field that could include spaces. I want to then show this ID as a link and use the ID within that link. Of course the spaces are wreaking havoc. I could write a function in SQL Server to do a basic encode, but I'm wondering if there is a way to do this via either the listview or via a ASP.NET function call?<br> <br> Example:<br> Data (ID)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Desired &lt;a&gt; Link<br> -----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--------------------------<br> MS3 DM008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;a href="ContractDetails.aspx?key=MS3%20DM008"&gt;MS3 DM008&lt;/a&gt;Tue, 29 Sep 2009 08:52:42 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost24753.aspxCool :cool:Tue, 29 Sep 2009 08:52:42 GMTTrent L. Taylorhttp://forum.strataframe.net/FindPost24749.aspxNever mind. My brain engaged and I realized that there is a RowPopulating method to fill a column...duh...<br> <br> I used this to handle the encoding and it worked great!Mon, 28 Sep 2009 19:07:37 GMTGreg McGuffey