One issue that I ran into, that I don't think anyone has ever mentioned, is that of "record" length.
I ran into a situation where my reindexing of a database failed with some weird verity error on every row attempting to be added (verity does product a log file , you just have to go look for it). The only difference was that I had added another field into the "body" for searching purposes. When I took that field away, the error went away. There was nothing special in the field other than pure textual data. No special chars, control chars, anything. Just some more data. But having said that, I have used verity for four years, it get's used every day in multiple applications, with no problems. It just works. Just a fyi, Steve At 12:10 PM 9/18/2002 -0400, Raymond Camden wrote: >Never mind - yea, refresh may work - just remember it nukes a collection >before adding. > >Also, try this for me, change your title and body attributes to NOT use >listguide. in front. You should only be passing the column, not >queryname.column. > >======================================================================= >Raymond Camden, ColdFusion Jedi Master for Hire > >Email : [EMAIL PROTECTED] >Yahoo IM : cfjedimaster > >"My ally is the Force, and a powerful ally it is." - Yoda > >> -----Original Message----- >> From: Angel Stewart [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, September 18, 2002 12:05 PM >> To: CF-Community >> Subject: RE: Verity experience >> >> >> Well yeah..last resort cuz I don't want to clutter the list with work >> stuff :) >> >> Anyways..here's the really SIMPLE code! >> >> ---------------- >> >> <html> >> <head> >> <title>Trinidad And Tobago Energy Guide-Updating Index</title> >> </head> >> >> <body> >> >> <cfquery name="listeguide" datasource="eguide" dbtype="ODBC"> >> >> SELECT tblCompany.entryid,tblCompany.CName, tblCompany.CAddr, >> tblCompany.CAddr2, tblCompany.CState, tblCompany.CZip, >> tblCompany.CCountry, tblCompany.Ctel1, tblCompany.Ctel2, >> tblCompany.cemail, tblCompany.curl >> >> FROM tblCompany >> >> </cfquery> >> >> <cfcollection action="REPAIR" collection="eguide"> >> >> <CFINDEX >> COLLECTION = "eguide" >> ACTION = "REFRESH" >> TYPE = "CUSTOM" >> QUERY = "listeguide" >> TITLE = "listeguide.CName" >> KEY = "entryid" >> BODY = "listeguide.CName" >> EXTERNAL = NO> >> >> <cfsearch collection="eguide" >> name="myResults" >> criteria=""> >> >> >> <cfdump var="#myResults#"> >> >> ------------------ >> >> I mean..I took out ALL the extra stuff from the query and >> just left it a >> BASIC query..BASIC Select query, Basic Index statement.. >> >> What am I doing wrong?? >> >> I even narrowed the Body to just one field. >> >> -Gel >> >> >> -----Original Message----- >> From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, September 18, 2002 11:49 AM >> To: CF-Community >> Subject: RE: Verity experience >> >> >> Last resort! >> Harumph! >> ** chants ** >> ** Show us your code! Show us your code! ** >> >> ~~ >> Stephenie >> >> > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
