Doug
|
Posted: 01/30/2002, 4:20 PM |
|
I get a type mismatch error on the following code, the last line. InvoiceId is a number. I am stumped.
------------
pkSQL = "select max(InvoiceID) as max_id from Invoices where MyAccountID= " & ToSQL(session("MyAccountID"), "Number")
openrs rs, pkSQL
last = GetValue(rs, "max_id")
GetParam("pInvoiceID") = last
-------------------
-Doug
|
|
|
Omaha
|
Posted: 01/30/2002, 7:34 PM |
|
Well, I've never seen a value being assigned to a function like you have:
GetParam("pInvoiceID") = last
usually it is a value being set by a function as in
last = GetParam("pInvoiceID")
|
|
|
|