Re: URL Encode via SQL?
From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 06/19/04
- Next message: Shaniqua Jones: "Re: URL Encode via SQL?"
- Previous message: Mario Splivalo: "Re: GROUP by, but not exact..."
- In reply to: Shaniqua Jones: "URL Encode via SQL?"
- Next in thread: Shaniqua Jones: "Re: URL Encode via SQL?"
- Reply: Shaniqua Jones: "Re: URL Encode via SQL?"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 19 Jun 2004 10:21:30 -0400
SQL Server doesn't know what a URL is, and doesn't know which characters
need to be encoded. You'd have to build your own function that steps
through each character in the string and rebuilds it, or runs a many-level
nested replace()).
-- http://www.aspfaq.com/ (Reverse address to reply.) "Shaniqua Jones" <kingOfPop@Neverland.com> wrote in message news:%23YD8b2YVEHA.2520@TK2MSFTNGP12.phx.gbl... > Hi there, > > I'm using a particular field as a basis for forming a URL. For example, > the field might contain: > > A1110541351(LQ#OBJim > > ...which would allow me to build the URL: > > <http://hostname/process.aspx?id=A1110541351(LQ#OBJim> > > The problem is that some of those characters in the ID aren't > URL-friendly. Is there a way to tell SQL to URLEncode the string before > returning it in the query? > > Thanks! > >
- Next message: Shaniqua Jones: "Re: URL Encode via SQL?"
- Previous message: Mario Splivalo: "Re: GROUP by, but not exact..."
- In reply to: Shaniqua Jones: "URL Encode via SQL?"
- Next in thread: Shaniqua Jones: "Re: URL Encode via SQL?"
- Reply: Shaniqua Jones: "Re: URL Encode via SQL?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
