You searched for the word(s): userid:594254

More Search Options

RSS Available

• Re: SQL query with string parameters containing quotes

  You can either do a replace to double up all single quote chars so the SQL works as expected... e.g. strMyString.Replace("'", "''") or you could use a SqlCommand object that will handle these strings for you. Here's a nice example for you. These techniques will also help protect you against SQL injection attacks ;)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by gavinharriss on 10/11/2009

• Re: SQL query with string parameters containing quotes

  Good call Mike... I figured the replace should prevent issue, but examples in link given show I was wrong!

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by gavinharriss on 10/11/2009

• Re: DataSet Caching is not caching the actual data

  For anyone who stumbles upon this thread with a similar issue, the soution to my case can be found at http://forums.asp.net/p/1182258/2007210.aspx

  Posted to State Management (Forum) by gavinharriss on 7/15/2009

• Re: Url escaped chars not decoded properly

  Seems I'm not alone in encountering this prob... http://forums.asp.net/p/1442127/3268857.aspx unfortunately there was no real solution given :(

  Posted to Web Forms (Forum) by gavinharriss on 7/11/2009

• Re: Url escaped chars not decoded properly

  Found the solution here: http://groups.google.com/group/DotNetDevelopment/browse_thread/thread/3bcdbf7d10014ebd The trick is to use encodeURIComponent instead of escape in the JavaScript! :)

  Posted to Web Forms (Forum) by gavinharriss on 7/11/2009

• Re: help to sole escape() + HttpUtility.UrlDecode problem

  A bit late, but handy for anyone else who stumbles across this thread looking for the solution... The trick is to use encodeURIComponent instead of escape in the JavaScript! :)

  Posted to Client Side Web Development (Forum) by gavinharriss on 7/11/2009

• Url escaped chars not decoded properly

  Hi, I have some JavaScript that generates code people can paste in to their own websites and takes various user inputs. One input is text which I escape for url usage via JavaScript. For example " Cortijo Marañón " becomes " Cortijo%20Mara%F1%F3n ". However when I access this query string server side via Request.QueryString I end up with " Cortijo Mara��n ". Anyone know how I can get around this issue? Cheers, Gavin

  Posted to Web Forms (Forum) by gavinharriss on 7/4/2009
  Filed under: UrlDecode, Escape character

• Re: Url escaped chars not decoded properly

  Hi Ram, you've misunderstood my post... The problem is not the spaces - these are getting encoded / decoded without issue as you can see in the example I gave. The problem is with the ñó chars which are encoded client side by JavaScript to %F1%F3 which ASP.NET decodes server side to �� . They are not getting decoded correctly!

  Posted to Web Forms (Forum) by gavinharriss on 7/4/2009

• Re: Url escaped chars not decoded properly

  For the real-life example check out this url: http://www.yougodo.com/en/FullMap.aspx?lat=36.80241249444501&lng=-4.325523376464844&z=9&i=true&cm=2&ss=true&trgt=_blank&p=true&pc=FFFFFF&pd=Cortijo%20Mara%F1%F3n Click the white map pin with the X and you'll see the problem caused by the bad decoding.

  Posted to Web Forms (Forum) by gavinharriss on 7/4/2009

• Re: Ajax CalendarExtender

  Sounds like you'll just have to play around with your CSS until it does what you want I'm afraid.

  Posted to ASP.NET AJAX Control Toolkit (Forum) by gavinharriss on 6/28/2009