Error message when performing a Search

[ready2drum]

I received the following error message after clicking the 'Search' button on a live web page...

------------------

Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> CreateRecordset<br/><b>Description:</b> There is no catalog. ' in E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php:66 Stack trace: #0 E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php(66): com->CreateRecordSet('nonsequential') #1 {main} thrown in E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php on line 66

------------------

 

Line 66 reads as follows...

 

$fileRS = $Q->CreateRecordSet("nonsequential");

------------------

I think this error is because the original location of the file was recently moved to a new location on the web server...not 100%.

 

Anyone have any idea as to how to cure this error so that it doesn't happen again?

 

Your help is much appreciated..Thanks in advance!

 

 

 

 

[Andy-H]

Seems you need to use exceptions / try + catch with whatever class you are using?

[ready2drum]

thanks, but where would the 'try and catch' go?  see my code below...

 

---------------

<?php

$Q = new COM("ixsso.Query");

$util = new COM("ixsso.util");

$Q->Catalog = "E:\GROUP\BIWeb\jha";

$Q->Query = $_POST['query'];

$Q->Columns = "filename, rank, vpath, path, DocTitle, characterization, All";

$Q->SortBy = "rank[d]";

$Q->MaxRecords = 200;

$fileRS = $Q->CreateRecordSet("nonsequential");

if(!$fileRS->RecordCount == 0) {

$fileRS->MoveFirst();

}

while($i < $fileRS->RecordCount) {

?>

-----------

I've not had to use the 'try and catch' before, so using the correct syntax/location is foreign to me.

[Andy-H]

<?php
try
{
               $Q = new COM("ixsso.Query");
               $util = new COM("ixsso.util");

               $Q->Catalog = "E:\GROUP\BIWeb\jha";
               $Q->Query = $_POST['query'];
               $Q->Columns = "filename, rank, vpath, path, DocTitle, characterization, All";
               $Q->SortBy = "rank[d]";
               $Q->MaxRecords = 200;
               $fileRS = $Q->CreateRecordSet("nonsequential");
               if(!$fileRS->RecordCount == 0) {   
                  $fileRS->MoveFirst();
               }
               while($i < $fileRS->RecordCount) {   //etc...}

//etc...
}
catch (Exception $e)
{
echo '<pre>'."\n";
   echo "\t".'Error with COM---'."\n\n";
   echo "\t\t".'ERROR: - ' . $e->getMesage() . "\n";
echo '</pre>';
}
               ?>

[ready2drum]

thanks for the information....I added the try/catch items and when I tried the search button again, it generated a different error message...

----------

Parse error: parse error, unexpected T_CATCH in E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php on line 75

----------

 

line 75 reads...

----

catch (Exception $e)

----

 

does it have something to do with what's on line 79?

--

cho "\t\t".'ERROR: - ' .$e->getMesage(). "\n";

--

I thought maybe it had something to do with the '$e' pointing to the object of the 'getMesage()' function...I added an 's' to "Mesage" so it reads 'Message', but it didn't seem to get rid of the new error...

 

not sure what could be causing it to not work....any thoughts?

 

 

[jonsjava]

missing a "}"

<?php
try
{
$Q = new COM("ixsso.Query");
$util = new COM("ixsso.util");

$Q->Catalog = "E:\GROUP\BIWeb\jha";
$Q->Query = $_POST['query'];
$Q->Columns = "filename, rank, vpath, path, DocTitle, characterization, All";
$Q->SortBy = "rank[d]";
$Q->MaxRecords = 200;
$fileRS = $Q->CreateRecordSet("nonsequential");
if(!$fileRS->RecordCount == 0) {
	$fileRS->MoveFirst();
}
while($i < $fileRS->RecordCount) {   //etc...}

	//etc...
}
}
catch (Exception $e)
{
echo '<pre>'."\n";
echo "\t".'Error with COM---'."\n\n";
echo "\t\t".'ERROR: - ' . $e->getMesage() . "\n";
echo '</pre>';
}
               ?>