conversion error ????

[gvision]

I'm trying to run an sql query in an asp page.
Here's my query :

var sqlQuery = "insert into reparateurs (OBSERVATIONS, [Cazan OU Microlease], [Date Cde Microlease], [Date Inst Microlease], PHOTOS, [DATE AGREE], [NOM DU RESEAU]) values('" + observations + "', '" + cazanoumicrolease + "', '" + datecdemicrolease + "', '" + dateinst + "', '" + photo + "', dateagree + "', '" + nomreseau + "')" ;

[DATE AGREE] is a datetime field.

This gives the error message : The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Could anyone help me. Thank you

 

[foxdev]

Its a bit hard to distinguish the single quotes from the double, but it seems to my 20/400 vision that you might be missing a quote at the beginning of dateagree. --------------
Low Cost Prints:

http://www.lowcostprints.com

 

[tlbroadbent]

What is the format of the input date and the language of the SQL Server? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[sunila7]

Hi,

Try this

var sqlQuery = "insert into reparateurs (OBSERVATIONS, [Cazan OU Microlease], [Date Cde Microlease], [Date Inst Microlease], PHOTOS, [DATE AGREE], [NOM DU RESEAU]) values('" + observations + "', '" + cazanoumicrolease + "', '" + datecdemicrolease + "', '" + dateinst + "', '" + photo + "','" + dateagree + "', '" + nomreseau + "')" ;

I think u missed some " in the SQL string

Sunil

 

[gvision]

the format date is : mm/dd/yyyy