Forum OpenACS Development: Re: Tcl Help...ASAP Please!!!!!!

Collapse
Posted by Jarkko Laine on
Divya,

You don't use $ sign in bind variables. Just say "where address_book_id = :address_id".

Collapse
Posted by Divya R on
Hi,

I rectified that....It gave me an error for db0or1row...I havent used that as the command.....
I need to use db0or1row right??

Divya

Collapse
Posted by Divya R on
Here is what it said: -

[10/Jun/2003:12:43:24][11041.321541][-conn307-] Error: Database operation "db0or1row" failed (except
ion NSDB, "Query was not a statement returning rows.")
    while executing
"ns_db 0or1row $db $sql"
    (procedure "database_to_tcl_string_or_null" line 2)
    invoked from within
"database_to_tcl_string_or_null $db "select customer_id from commercial_details where commercial_d
etails_id =:commercial_details_id" "
    invoked from within
"set customer_id [database_to_tcl_string_or_null $db "select customer_id from commercial_details w
here commercial_details_id =:commercial_details_id" ]"
    (file "/web/nspapp/www/nspapp/delivery/delivery-add.tcl" line 84)
    invoked from within
"source [ad_conn file]"
    (procedure "rp_handle_tcl_request" line 2)
    invoked from within
"rp_handle_tcl_request"
    invoked from within
"catch $handler error"
    invoked from within
"rp_abstract_url_server"

Thanks in advance,
Divya