This brought up an interesting challenge for me.
Situation:
Approx 300 .htm docs that are called into .cfm templates via query and
<cfinclude>.
When searched by verity, the URL returned is on to the .htm doc
outside of it's .cfm template, so if selected it comes up without all
the nice trim and navigation.
Current Fix (being worked on):
Set up a Document Directory table in the db
When a search result is selected, it is passed as variable in the URL
to a .cfm that uses
<cfif URL CONTAINS ".htm">
<cfquery name="Convert" datasource="ofah" dbtype="ODBC">
SELECT *
FROM DocumentSearch
WHERE #URL# = AssociatedHTMDoc
</cfquery>
<cfoutput query="Convert">
<cfhttp url="#DocumentLocation#" method="GET" resolveurl="false">
</cfhttp>
</cfoutput>
<cfelse>
<body>
<cfhttp url="../#URL#" method="GET" resolveurl="false">
</body>
</cfif>
Okay, that doesn't work yet but you see where I am going with it! ;)
Now, I understand that I can take the contents of my .htm docs, put
them in Memo data type fields in my Access DB. ( I wish we could
afford Oracle or SQL 7!)
If I do that, can Verity search the contents of these fields and
return a URL with the proper .cfm template, something like;
http://www.ofah.org/AboutUs?DocID=2
If the latter is possible, I would rather do that as I believe that
would result in better performance.
My Hispanic aunt TIA says, "Hold the Halibut" ;0)
Yours In Conservation,
Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262
www.OFAH.org
P.S.
Check out all our great websites
www.AuctionForWildlife.com - The place to get bargains on quality
outdoors goods.
www.AHTV.com - The online companion to the Angler & Hunter Television
show
www.HuntingDog.org - Come celebrate Ontario's Hunting Dog Heritage
www.EcoEd.org - An online outdoors adventure for kids grades 1-8
www.OHEP.net - The official Ontario Hunters Education Program site
www.InvadingSpecies.com - Ontario's premier site for invading species
info
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
