I have a site that is using Verity, which works fine on the development
server, but gives an Internal Error ("Internal Error: Open of BulkUpdate
file failed"). I can not find why this problem is being caused, so I have to
use the alternative - I have to do the searches (lots of them) using
QUERIES.
The other problem is that this has to be done in the next hour or so.
The quickest way for me to do this (i.e the way that involves the least
amount of coding time) is for me to duplicate the CFSEARCH with a custom tag
that takes the same paramters, and returns the same results. This is where I
am stuck.
I need to create a caller Struct that imitates the output of the CFSEARCH,
so within my custom tag I need to create a variable that can be used in the
caller page by refering to it as variablename.key[n] .
Is this possible?
Here is my code so far (which fails):
========================================================
<CFQUERY NAME="gettable" DATASOURCE="#caller.application_datasource#">
SELECT
A.videoid AS idkey
FROM
archivevideo AS A
LEFT OUTER JOIN companies AS PC ON A.prodcoid=PC.companyid
LEFT OUTER JOIN companies AS PPC ON A.postcoid=PPC.companyid
LEFT OUTER JOIN companies AS AG ON A.agencycoid=AG.companyid
LEFT OUTER JOIN people AS D ON A.directorid=D.peopleid
WHERE
A.videoid LIKE '%#searchcriteria#%' OR
A.issue LIKE '%#searchcriteria#%' OR
A.title LIKE '%#searchcriteria#%' OR
A.client LIKE '%#searchcriteria#%' OR
A.brand LIKE '%#searchcriteria#%' OR
A.keywords LIKE '%#searchcriteria#%' OR
A.description LIKE '%#searchcriteria#%' OR
D.firstname LIKE '%#searchcriteria#%' OR
D.lastname LIKE '%#searchcriteria#%' OR
PC.companyname LIKE '%#searchcriteria#%' OR
PPC.companyname LIKE '%#searchcriteria#%' OR
AG.companyname LIKE '%#searchcriteria#%' OR
A.recordcompany LIKE '%#searchcriteria#%' OR
A.creativeteam LIKE '%#searchcriteria#%' OR
A.producer LIKE '%#searchcriteria#%' OR
A.dirofphotography LIKE '%#searchcriteria#%' OR
A.editor LIKE '%#searchcriteria#%' OR
A.music LIKE '%#searchcriteria#%' OR
A.location LIKE '%#searchcriteria#%' OR
A.locationservicecompany LIKE '%#searchcriteria#%' OR
A.extrainfo LIKE '%#searchcriteria#%' OR
A.agencyproducer LIKE '%#searchcriteria#%'
ORDER BY
A.title DESC
</CFQUERY>
<CFSET "caller.#searchname#"=StructNew()>
<CFSET "caller.#searchname#.key"=ArrayNew(1)>
<CFLOOP FROM="1" TO="#gettable.RecordCount#" INDEX="n">
<CFSET "caller.#searchname#.key[n]"=gettable.idkey[n]>
</CFLOOP>
========================================================
H H EEE L PPP
H H E L P P
HHH EE L PPP
H H E L P
H H EEE LLL P
------------------------------------------------------------------------------
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.
