ready2drum

I appreciate your help with this issue...I also noticed some missing braces '}' ...here's the full code within the php tags... ________ <?php $Q = new COM("ixsso.Query"); $util = new COM("ixsso.util"); $Q->Catalog = "E:\GROUP\BigWeb\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) { ?> <div id="search_results"> <table width="100%" border="0" cellpadding="0"> <tr> <td height="20" class="fstyle_4"><?php echo($fileRS->fields['DocTitle']->value); ?></td> </tr> <tr> <td class="fstyle_5"><a href="<?php echo($fileRS->fields['path']->value); ?>"><?php echo($fileRS->fields['filename']->value); ?></a></td> </tr> <tr> <td class="fstyle_5"><?php echo($fileRS->fields['characterization']->value); ?></td> </tr> <tr> <td class="fstyle_5"><hr /></td> </tr> </table> </div> <?php $fileRS->MoveNext(); $i++; } ?> __________ shouldn't there be a closing brace '}' for line 70? while($i < $fileRS->RecordCount) { ?> ...and also for an opening brace for line 89? $fileRS->MoveNext(); $i++; } _________ just curious if the missing braces had any bearing on the error message...what do you think?

I'm trying to fix an error that references some piece of code that someone else setup a while ago and they're no longer around to ask/discuss it with. The error message references the following code, Line 62: <?php $Q = new COM("ixsso.Query"); $util = new COM("ixsso.util"); $Q->Catalog = "E:\GROUP\BigWeb\jha"; /*Line 62*/ $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) { ?> The error message that shows up on screen is as follows: Notice: Undefined index: query in E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php on line 62 Fatal error: Uncaught exception 'com_exception' with message 'Parameter 0: Type mismatch. ' in E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php:62 Stack trace: #0 E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php(62): unknown() #1 {main} thrown in E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php on line 62 The code mentioned at the beginning pertains to a 'Search' feature that allows users the ability to type in a string and have the results displayed on the screen, however, everytime I enter a word or words in the text box and then click on the 'Search' button, the error message appears. Line 61 of the code: $Q->Catalog = "E:\GROUP\BigWeb\jha"; //there are multiple catalog.wci folders located on the shared GROUP directory and also under the BigWeb directory. In addition, from the research I've done so far, the built-in $_POST function is used to collect values in a form with method="post", and since there are no lines referencing 'method="post" anywhere in the code, it confirms that the way it's written on Line 62, is not valid. I hope this makes sense to someone out there on the forum because I'm trying to explain it the best way I know how....so if anyone has ANY suggestions on what to do to resolve this, I'd greatly appreciate it. Thanks in advance!

additional information...using IXSSO query within PHP to display the results of a 'search' function...not sure how to set the 'query property' for line 66 so that this will work. I've seached on Google.com as well for further assistance without success.

The PHP code that I have put together is supposed to allow users on the ability to 'search' for a specific file related to their department, but instead, it's giving an error message after entering an item and clicking on the 'search' button.... Error message reads as follows: 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 --------- PHP code reads: <?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; (line 66) $fileRS = $Q->CreateRecordSet("nonsequential"); if(!$fileRS->RecordCount == 0) { $fileRS->MoveFirst(); } while($i < $fileRS->RecordCount){ } ?> ---------- has anyone ever run across this type of error and if so, what am I missing in order to resolve this error? If you need more information, please let me know, as I really want to fix this before the day is over. Thanks in advance!

I really appreciate your help and direction on this issue. I will definitely take your advice and put it to good use. Thanks for your input!

I'm working with Dreamweaver 8 and when I insert a .jpg image, it shows up on the web page looking all kinds of pixelated, not very crisp and clear. The text image was created using the WordArt feature in MS Word, and then copied and pasted into MS Paint so that I could save it as a .jpg file. The next step was to use the 'Insert/Image' function in Dreamweaver 8, whereby the webpage has a .php extension (not sure if that matters or not). Is there a way to create, save, and display a very nice, crisp and clear text image that maintains its quality once it's saved to a web page? (p.s. I don't have Adobe Photoshop, but I do have MS Paint and MS Photo Editor). Any suggestions are much appreciated and welcomed...thanks!

I recently had moved files from one server to another and now when I'm performing a 'Search' on a web page, the following error message appears: -------------- Notice: Undefined index: query in E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php on line 62 Fatal error: Uncaught exception 'com_exception' with message 'Parameter 0: Type mismatch. ' in E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php:62 Stack trace: #0 E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php(62): unknown() #1 {main} thrown in E:\Inetpub\wwwroot\Intranet_Old\intranet\jha\jha_doc_results.php on line 62 -------------- Below is the code showing 'line 62'... --- <?php LIne 59 $Q = new COM("ixsso.Query"); Line 60 $util = new COM("ixsso.util"); Line 61 $Q->Catalog = "E:\GROUP\BIWeb\jha"; Line 62 $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) { ?> --- Not sure how to resolve this after searching the Forum for similar/related issues... Your help is greatly appreciated...thanks in advance!

The good news is that it works now...no errors to report. I checked everything to ensure that there were no missed items and no other discrepancies in the code. Thank you for all your help!

I appreciate your help on this Premiso...I'll put your suggestions to good use and let you know how it turns out. Thanks!

I corrected a link for a web page using Dreamweaver 8 (.php file), and after saving the change and refreshing the web page, an error appeared: ------ Notice: Undefined offset: 1 in E:\Inetpub\wwwroot\Intranet_Old\intranet\includes\header_1.php on line 30 ------ line 30 reads as... --- <?php $username = $_SERVER["LOGON_USER"]; $username2 = explode('\\', $username); Line 30 -> $_SESSION['username'] = $username2[1]; echo($_SESSION['username']); $_SESSION['valid_user'] = false; for ($i=0; $i<$num_users; $i++) { if ($users[$i] == $_SESSION['username']) { $_SESSION['valid_user'] = true; } } ?> --- I've not ever seen this error before and need assistance on how to resolve it. Your help is greatly appreciated. Thanks in advance!

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?

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.

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!

Thanks for the link! I'll check it out and see what I can do....

Is there any documentation specifically on how to use PHP to import data (i.e. cell(s)) from MS Excel? I've not seen anything message posts about it yet, so I thought I'd ask. The ultimate goal is to have the owner of the spreadsheet make weekly updates and have it show up on the Home Page of the website automatically. Your feedback and guidance is greatly appreciated! Thank you in advance.