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
