Problem

[radubalmus]

i am building a query depending if some cells(my interface is excel) have text or not..
it is working, but when i am trying to read from a certain field it gives me an error "80040e14"
ex: So the following works:

SELECT testorder,shortyear,orderdate,requester,tel,weno,partno,partname,samples,costcat,status,product_rating FROM test_orders WHERE orderdate>=(1/1/2007) AND (costcat='2.4 CoP')

or

SELECT testorder,shortyear,orderdate,requester,tel,weno,partno,partname,samples,costcat,status,product_rating FROM test_orders WHERE orderdate>=(1/1/2007) AND (testtype='ES Tests')

but when this query is build i have the error:

SELECT testorder,shortyear,orderdate,requester,tel,weno,partno,partname,samples,costcat,status,product_rating FROM test_orders WHERE orderdate>=(1/1/2007) AND (status='Open')

is Sql(database or language) sezitive to some words??? or what could be the problem


There are simple solutions for almost every problem! The hard part is to see them!!!!

 

[RiverGuy]

Try surrounding your dates with single quotes.

 

[gmmastros]

Dates should have apostrophes (single-quote) around them.

SELECT testorder,shortyear,orderdate,requester,tel,weno,partno,partname,samples,costcat,status,product_rating FROM test_orders WHERE orderdate>=[!]'[/!]1/1/2007[!]'[/!] AND (status='Open')

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[gmmastros]

Sorry RiverGuy. Your post wasn't there when I first started to respond.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[radubalmus]

i'll try it. but why thas it work in the other two cases??

There are simple solutions for almost every problem! The hard part is to see them!!!!

 

[radubalmus]

i've tried with single quote but i am stil getting the same error
i don't think it is about the dates
when i am querying only the dates, or the dates and another field it's working, but when i am querying about this field "status" i get the error.
i have this problem in others modules too
i making a small program with excel interface and now i am switching from Acces to Sql Server(i am modifiing the program(connection) to work with Sql)
and it is rather strange becase some procedures work and other similar keep getiing me the same error.

any ideeas???



There are simple solutions for almost every problem! The hard part is to see them!!!!