strUpdate = "update tblCustRate set dtRateFrom =" + ndateFrom + _
                ", dtRateTo =" + ndateUntil+ _
                ", decHourlyRate=" + nHourlyRate+ _
                " where iEmpID =" + iEmpID +_
                " and iTaskiD=" + iTaskID +_

                 " and iProjDetiD=" + iProjDetID

  it gives me an error mismatch string. From the data base I am updating numbers like 9/11/2003, 9/10/2004 and 50. But when i use
the code below it works fine. Please explain me the reason. Thanks

strUpdate = "update tblCustRate set dtRateFrom =" & ndateFrom & _
                ", dtRateTo =" & ndateUntil& _
                ", decHourlyRate=" & nHourlyRate& _
                " where iEmpID =" & iEmpID &_
                " and iTaskiD=" & iTaskID &_

                 " and iProjDetiD=" + iProjDetID

Whenever possible use an "&" (ampersand) to concatenate strings in VBScript. When you use "+" to concatenate string and a number for eg. ("this is a test" + 5 )it does not know how to reconcile the two different types to get them to work together.

I didnot understand what you want to say. Explain me in detail. Regards shoakat

Yes,

  Better to use & as concatenation operator.
And, which database are you using? Access/SQL server ?
If access, in your sql statement, check the query.
Dates are followed by #9/1/2003#


---------
Rajani

Shoakat,

I think you are mixing up with + and & operators in relation to VBScript and T-SQL

Use & as concatenation operator in VBScript.
Use + as concatenation operator in T-Sql.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection