DevForce Community Forum : Date Problem in PassthruEsql Query http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Date Problem in PassthruEsql Query Sun, 12 Apr 2026 22:37:11 -700 Wed, 14 May 2008 22:27:18 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=806 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Date Problem in PassthruEsql Query : Thanks for your response...... http://www.ideablade.com/forum/forum_posts.asp?TID=806&PID=2956#2956 Author: Dinesh
Subject: 806
Posted: 14-May-2008 at 10:27pm


Thanks for your response... it works...

Thanks once again...



Edited by Dinesh - 14-May-2008 at 10:36pm]]> Wed, 14 May 2008 22:27:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=806&PID=2956#2956 Date Problem in PassthruEsql Query : Since this is a pass through query,... http://www.ideablade.com/forum/forum_posts.asp?TID=806&PID=2955#2955 Author: kimj
Subject: 806
Posted: 14-May-2008 at 3:01pm

Since this is a pass through query, the syntax is validated by the Entity Framework and must meet EF eSQL requirements.  Date literals are a little tricky and need to be formatted something like this:
  Datetime 'yyyy-mm-dd hh:mm'
 
So, your birthdate clause should work if rewritten like this:
    (m.BirthDate = Datetime'1958-07-23 00:00')
 
Here's a link to some info on eSQL literal support:  http://msdn.microsoft.com/en-us/library/bb399176.aspx
 
 
]]> Wed, 14 May 2008 15:01:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=806&PID=2955#2955 Date Problem in PassthruEsql Query : Cosider the Following PassthruEsql... http://www.ideablade.com/forum/forum_posts.asp?TID=806&PID=2953#2953 Author: Dinesh
Subject: 806
Posted: 14-May-2008 at 7:03am

Cosider the Following PassthruEsql Query

SELECT VALUE m from Members AS m WHERE (1=1) AND ( (0=1) or (m.SSN like '_Data_') or (m.MemberName.LastName like '_Data_') or (m.BirthDate = 7/23/1958 12:00:00 AM) or (m.Contact.Phone like '_Data_') )

When i run above PassthruEsqlQuery it gives following error :

IdeaBlade.EntityModel.v4.EntityServerException: The query syntax is not valid, near term '12', line 1, column 163. --->  System.Data.QueryException: The query syntax is not valid, near term '12', line 1, column 163.

When i remove m.birthdate part from PassthruEsqlQuery it works fine and gives me the result.

so pl. tell whats wrong with Date Part in above passthruESql Query.

Thanks

]]> Wed, 14 May 2008 07:03:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=806&PID=2953#2953