Error 42S22
SQ063: No column params.
while executing the following statement:
#line 2125 "/DAV/VAD/conductor/vdb_dsns.vspx-sql"
create method vc_render_vm_pagebody_has_vdb_template (inout control vspx_template) for "DB"."dba".page_fbb3c5d5e0c58387dc2ebb711061d421AV_VAD_conductor_vdb__dsns_vspx
{
?>
<table class="MainSubData" align="center" border="0" cellspacing="0" cellpadding="4">
<tr>
<th align="left">Data Source Name</th><th align="left">UserName</th><th align="left">State</th><th />
<th align="left">
<a href="vdb_dsns.vspx?sid=<?V self.sid ?>&realm=<?V self.realm ?>&mode=remove">Remove All</a>
</th>
<th align="left">
<a href="vdb_dsns.vspx?sid=<?V self.sid ?>&realm=<?V self.realm ?>&mode=test">Test All</a>
</th>
</tr>
<?vsp declare mode, ds_name varchar;
declare _err_code, _err_message varchar;
declare _cnt integer;
declare exit handler for sqlstate '*'
{ _err_code := __SQL_STATE; _err_message := __SQL_MESSAGE; goto error; };
mode := get_keyword('mode', params, '');
ds_name := get_keyword('dsn_name', params, '');
for (select ds_dsn, ds_uid from sys_data_source) do {
_cnt := _cnt + 1;
?>
<tr>
<td class="MainData"><?V ds_dsn?></td>
<td class="MainData"><?V ds_uid?></td>
<?vsp if( mode = 'test' and ( ds_name = '' or ds_name = ds_dsn ) ) {
http('<td class="MainData">');
declare state, msg, m_dta, res varchar;
state := '00000';
exec( '_sql_tables( ?, ?, ?, ?, ? )', state, msg, vector (ds_dsn, '', '', '','TABLE'), m_dta, res);
if ('00000' = state) {
http('OK');
}
else {
http('<span class="attention_text">Failed</span>');
}
http('</td>');
}
else {
http('<td class="MainData">Not tested</td>');
}
?>
<td class="MainData">
<a href="vdb_dsn_edit.vspx?sid=<?V self.sid ?>&realm=<?V self.realm ?>&mode=edit&dsn_name=<?V ds_dsn ?>&login=<?V ds_uid ?>">Edit</a>
</td>
<td class="MainData">
<a href="vdb_dsn_edit.vspx?sid=<?V self.sid ?>&realm=<?V self.realm ?>&mode=remove&dsn_name=<?V ds_dsn ?>&login=<?V ds_uid ?>">Remove</a>
</td>
<td class="MainData">
<a href="vdb_dsns.vspx?sid=<?V self.sid ?>&realm=<?V self.realm ?>&mode=test&dsn_name=<?V ds_dsn ?>&login=<?V ds_uid ?>">Test</a>
</td>
</tr>
<?vsp }
if (0 = _cnt) {
http('<tr><td class="MainData">No Data Sources</td></tr>');
}
goto next;
error:
?>
<tr>
<td colspan="6">
<table class="MainData" border="0" cellpadding="0" align="left" width="60%">
<tr><td class="attention_text" colspan="2">Error</td></tr>
<tr><td class="MainData">SQL State</td>
<td class="MainData"><?V _err_code ?>
</td></tr>
<tr><td class="MainData">Error Message</td>
<td class="MainData"><?V _err_message ?>
</td></tr>
</table>
</td></tr>
<?vsp next:
;
?>
</table>
<?vsp
}