Dreamweaver - another try failed, please help !!!

Author

another try failed, please help !!!

Axi

2004-02-29, 11:28 pm

One more try failed, please help !

Also tried this:

Dim iLoop

For iLoop = 0 to iCount
strLink = Request(iLoop & ".Link")
strBalance = Request(iLoop & ".Balance")
strID = Request(iLoop & ".ID2")
strSQL = "UPDATE BillingLines SET PmtRecd = ('strBalance')-('strLink')
WHERE Id ='strID'"

Command1.Execute strSQL
Next

-------------------
Got this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data
type. Operator equals subtract, type equals varchar.
/bluedot2004/Intranet/Cases/Billing/Payments/PaymentSavedUpdatebillines.asp,
line 28
------------------------

"Axi" <axiaxi2003@hotmail.com> wrote in message
news:c1u4fe$k7q$1@forums.macromedia.com...
> Hi,
>
> This might be an easy one, just cant find how to code it.
> I have 2 variables which I want to add (strBalance and strLink) the values
> could be: 500+300 = 800.
>
> The problem is that my code is instead adding them like this: 500+300 =
> 500,300
>
> Below is the code.
>
> ------------------------------------------------
> For iLoop = 0 to iCount
> strLink = Request(iLoop & ".Link")
> strBalance = Request(iLoop & ".Balance")
> strID = Request(iLoop & ".ID2")
> strSQL = "UPDATE BillingLines SET PmtRecd = " & strBalance + strLink & "
"
> &_
> " WHERE Id = " & strID
> ----------------------------------------------------------
>
> How can I do the code so that it adds correctly ?
>
> Appreciate any help !
>
> Axi
>
>