Warning: mssql_select_db() [function.mssql-select-db]: Sybase: Server message: Database 'sp3_tn_chattanooga' cannot be opened. It is in the middle of a restore. (severity 14, procedure N/A) in /var/www/comm_guide/chattanooga/sql.inc on line 24
Warning: mssql_select_db() [function.mssql-select-db]: Sybase: Server message: Database 'sp3_tn_chattanooga' cannot be opened. It is in the middle of a restore. (severity 14, procedure N/A) in /var/www/comm_guide/chattanooga/sql.inc on line 24
Warning: mssql_query() [function.mssql-query]: Sybase: Server message: Invalid object name 'CP_SYSPREF'. (severity 16, procedure N/A) in /var/www/comm_guide/chattanooga/sql.inc on line 31
SQL Query Error:
SELECT
cpversion = convert(varchar(10), cp_major_version) + '.' +
case when len(convert(varchar(10), cp_revision)) = 1 then '0'+ convert(varchar(10), cp_revision)
when len(convert(varchar(10), cp_revision)) = 2 then convert(varchar(10), cp_revision)
else '00' end
+ '.' +
case when len(convert(varchar(10), cp_minor_revision)) = 1 then '00'+ convert(varchar(10), cp_minor_revision)
when len(convert(varchar(10), cp_minor_revision)) = 2 then '0' + convert(varchar(10), cp_minor_revision)
when len(convert(varchar(10), cp_minor_revision)) = 3 then convert(varchar(10), cp_minor_revision)
else '000' end,
spversion = convert(varchar(4), version_major) + '.' +
convert(varchar(1), version_revision) +
convert(varchar(1), version_minor_revision) + '.' +
case when len(convert(varchar(3), version_build_num)) = 1 then '00'+ convert(varchar(3), version_build_num)
when len(convert(varchar(3), version_build_num)) = 2 then '0' + convert(varchar(3), version_build_num)
when len(convert(varchar(3), version_build_num)) = 3 then convert(varchar(3), version_build_num)
else '000' end,
db_version = version_dbscript, *
FROM CP_SYSPREF, system_prefs