Your second CFINDEX should have ACTION="UPDATE" not ACTION="REFRESH" REFRESH tells verity to clear and re-create the database. > -----Original Message----- > From: gregg Kachel [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 17, 2000 8:39 AM > To: [EMAIL PROTECTED] > Subject: > > This is a multi-part message in MIME format. > > ------=_NextPart_000_001D_01C0082F.05A294C0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > I'm trying to follow along on FORTE's book on indexing data for verity. = > Unfortuneatly it seems it is only indexing one table, I'm not sure what = > I am doing wrong.... I even tried creating two differant collections, = > and that isn't working either. No matter what I do, only the SECOND one = > seems to be indexed. Please help. Here is my indexing code: > > <cfquery name=3D"houseboatarticles" datasource=3D"hbarticles"> > SELECT Headline, Date, Body, ID, byline, category, subhead > FROM articles > </CFQUERY> > </head> > <CFINDEX ACTION=3D"REFRESH" > COLLECTION=3D"HBarticles" > KEY=3D"id" > TYPE=3D"CUSTOM" > TITLE=3D"HEADLINE" > QUERY=3D"HOUSEBOATARTICLES" > BODY=3D"BODY"> > > > <cfquery name=3D"houseboatarticles2" datasource=3D"hbarticles"> > SELECT Headline, Date, Body, ID, byline, category, subhead > FROM hbmarchives > </CFQUERY> > </head> > <CFINDEX ACTION=3D"REFRESH" > COLLECTION=3D"HBarticles" > KEY=3D"id" > TYPE=3D"CUSTOM" > TITLE=3D"HEADLINE" > QUERY=3D"HOUSEBOATARTICLES2" > BODY=3D"BODY"> > > Gregg Kachel > Webmaster > www.houseboatmagazine.com > www.houseboat.net > www.pdbworld.com/ > > Gregg Kachel > Webmaster > www.houseboatmagazine.com > www.houseboat.net > www.pdbworld.com/ > > > ------=_NextPart_000_001D_01C0082F.05A294C0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=3DContent-Type content=3D"text/html; = > charset=3Diso-8859-1"> > <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV><FONT face=3DArial size=3D2> > <DIV><FONT face=3DArial size=3D2>I'm trying to follow along on FORTE's = > book on=20 > indexing data for verity. Unfortuneatly it seems it is only = > indexing one=20 > table, I'm not sure what I am doing wrong.... I even tried creating two=20 > differant collections, and that isn't working either. No matter what I = > do, only=20 > the SECOND one seems to be indexed. Please help. Here is my = > indexing=20 > code:</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2> <cfquery = > name=3D"houseboatarticles"=20 > datasource=3D"hbarticles"><BR> SELECT Headline, Date, Body, ID, = > byline,=20 > category, subhead<BR> FROM=20 > articles<BR></CFQUERY><BR></head><BR><CFINDEX =20 > ACTION=3D"REFRESH"<BR> =20 > COLLECTION=3D"HBarticles"<BR> = > KEY=3D"id"<BR> =20 > TYPE=3D"CUSTOM"<BR> = > TITLE=3D"HEADLINE"<BR> =20 > QUERY=3D"HOUSEBOATARTICLES"<BR> = > BODY=3D"BODY"></FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=3DArial size=3D2><BR> <cfquery=20 > name=3D"houseboatarticles2" datasource=3D"hbarticles"><BR> = > SELECT Headline,=20 > Date, Body, ID, byline, category, subhead<BR> FROM=20 > hbmarchives<BR></CFQUERY><BR></head><BR><CFINDEX =20 > ACTION=3D"REFRESH"<BR> =20 > COLLECTION=3D"HBarticles"<BR> = > KEY=3D"id"<BR> =20 > TYPE=3D"CUSTOM"<BR> = > TITLE=3D"HEADLINE"<BR> =20 > QUERY=3D"HOUSEBOATARTICLES2"<BR> =20 > BODY=3D"BODY"><BR></FONT></DIV> > <DIV><FONT face=3DArial size=3D2>Gregg Kachel<BR>Webmaster<BR><A=20 > href=3D"http://www.houseboatmagazine.com">www.houseboatmagazine.com</A><B= > R><A=20 > href=3D"http://www.houseboat.net">www.houseboat.net</A><BR><A=20 > href=3D"http://www.pdbworld.com/">www.pdbworld.com/</A><BR></FONT></DIV><= > /FONT></DIV> > <DIV><FONT face=3DArial size=3D2>Gregg Kachel<BR>Webmaster<BR><A=20 > href=3D"http://www.houseboatmagazine.com">www.houseboatmagazine.com</A><B= > R><A=20 > href=3D"http://www.houseboat.net">www.houseboat.net</A><BR><A=20 > href=3D"http://www.pdbworld.com/">www.pdbworld.com/</A><BR></FONT></DIV><= > /BODY></HTML> > > ------=_NextPart_000_001D_01C0082F.05A294C0-- > > -------------------------------------------------------------------------- > ---- > Archives: http://www.mail-archive.com/[email protected]/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
