The error code is <p>
[28/Dec/2000:12:39:00]
Error: Ns_PgExec: result status: 7 message: ERROR: Function
'decode(bpchar, unknown, unknown, unknown)' does not exist
Unable to identify a function that satisfies the given
argument types
You may need to add explicit typecasts
<p>
[28/Dec/2000:12:39:00]
Error: dbinit: error(localhost::iigfdb,ERROR: Function
'decode(bpchar, unknown, unknown, unknown)' does not exist
Unable to identify a function that satisfies the given
argument types
You may need to add explicit typecasts
): 'select cea.*, cea.alert_id,
decode(valid_p,'f','t','f') as not_valid_p,
upper(email) as upper_email, email
from classified_email_alerts cea, users
where cea.user_id = users.user_id
and domain_id = 1
order by not_valid_p, upper_email'
<p>
[28/Dec/2000:12:39:00]
Error: Database operation "select" failed (exception NSDB, "Query
was not a statement returning rows.")
Database operation "select" failed (exception NSDB, "Query was not
a statement returning rows.")
while executing
"ns_db select $db "select cea.*, cea.alert_id,
decode(valid_p,'f','t','f') as not_valid_p,
upper(email) as upper_email, email
from classified_email_ale ..."
invoked from within
"set selection [ns_db select $db "select cea.*, cea.alert_id,
decode(valid_p,'f','t','f') as not_valid_p,
upper(email) as upper_email, email
from class ..."
(file "/web/iig.org.in/www/gc/admin/view-alerts.tcl" line 41)
invoked from within
"source $script"
invoked from within
"if ![file exists $script] {
ns_returnnotfound $conn
} else {
source $script
}"
(procedure "ns_sourceproc" line 3)
invoked from within
"ns_sourceproc cns54 {}"
Notice: Querying 'select ad_group_member_p(1,
system_administrator_group_id()) from dual;'
<p>This is the same error I was getting previously in ads.tcl due to
decode function but in theis view-alerts.tcl there is no decode
function . <p>
Help Please