SQL Query...

[Jamal Abdul Nasir]

--> what is the problem with the following query... Actually i am running it against Access 2007 from VB.net 2008...

SELECT * FROM TBL_SALES where product_id=2 and customer_id=3 and dated='2009-10-01'

--> it works when i run it from SQL Server 2005... but doesn't work from dotnet... Need some suggestion from your side.. thanks...

J A Nasir K

[Luc Pattyn]

Jamal Abdul Nasir wrote:

doesn't work

:)

Luc Pattyn

---

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

---

Local announcement (Antwerp region): Lange Wapper? Neen!

---

[Mycroft Holmes]

Read this article [^]

Never underestimate the power of human stupidity RAH

[i j russell]

When you catch the exception in your VB code, what does it say?

[i i i]

i think so you are having time also with date check that and try to also format your date :)

Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

[Md Marufuzzaman]

Well.. When you run this transact-sql statement.. probably you face that the datetime auto reformation like '2009-10-01' to CONVERT(DATETIME, '2009-10-01 00:00:00', 102). You should consider this..

Thanks Md. Marufuzzaman

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.