Monday, May 20, 2024
 Popular · Latest · Hot · Upcoming
180
rated 0 times [  185] [ 5]  / answers: 1 / hits: 20524  / 14 Years ago, fri, november 19, 2010, 12:00:00

How is the & symbol handled in the following query in oData?



/vendordataservice.svc/vDataMapper_SourceMapVendor?&$filter=startswith(ParentName,'AT&T')&$top=7&$skip=0


I'm using EF3.5 and SQL2008. When I send that to my oData service I get no data back.


More From » sql

 Answers
33

Here is a list of characters that should be encoded prior to sending to SQL server over HTTP:



http://msdn.microsoft.com/en-us/library/aa226544(SQL.80).aspx



Yes, the '&' symbol is one of them.


[#94901] Wednesday, November 17, 2010, 14 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
acaciac

Total Points: 317
Total Questions: 117
Total Answers: 128

Location: France
Member since Thu, Oct 27, 2022
2 Years ago
;