----- Original Message -----
From: Peter M. Jansson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 7:56 PM
Subject: Re: [AOLSERVER] Error: nsd.tcl: Database operation "0or1row" failed
(exception NSINT)
> On Monday, February 25, 2002, at 05:25 AM, oetjoen wrote:
>
> > set sql "select distinct $id from paymentmethodsdescr where
> > keynr=$keynr"
> You have a stray dollar sign there -- it should be "distinct id", not
> "disting $id".
Hi Pete..
I'am using a stray dollar sign on "id" because that is a variable which
referring to variable procedure get_payment_method,
proc get_payment_method {id keynr} {
......
set sql "select distinct $id from paymentmethodsdescr where keynr=$keynr"
......
}
ie if I called procedure at HTML:
.......
get_payment_method "name" "1"
.......
so the sql on procedure could be
set sql "select distinct name from paymentmethodsdescr where keynr=1"
......
where $id=name and $keynr=1
