Dataadapter + date query problem

[Pascal_Temmar]

Hi,


I have this query

SELECT date_recherche, txt_recherche, nb_resultat_recherche, nb_resultat_rubrique, nb_recherche_commune, nb_resultat, ID
FROM table1
where date_recherche = "20/10/2005"

I would like to change the date "20/10/2005" with a keyword or other instruction.

Im under VB.NET 2005 B2 and I cant find exactly word : I tried = { d }, datetime, date.now but nothing.

Thanks a lot in advance for help.

Pascal T.
New Caledonie

 

[PlausiblyDamp]

You are probably going to benefit from a parameterised query for this, if you have a search of these forums you should find several examples / topics.

 

[Pascal_Temmar]

You are probably going to benefit from a parameterised query for this, if you have a search of these forums you should find several examples / topics.

In fact, with code I define the exact query. But When I use data designer, I cant insert datetime.now in query. I do not consider its a parameterised query.

But thanks for your answer.

 

[PlausiblyDamp]

If this is SQL server you could use GETDATE() to get the current date and time.