Thanks.
On 10/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
For number 1: do you have a <cfqueryparam> in your query - from what I understand, this doesn't work with cached queries...------------------------------------------------------------------Original Message-----Good Morning everyone,
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ajas Mohammed
Sent: Monday, October 16, 2006 10:17 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature
Just wondering if anyone has any ideas/suggestions for the 2 questions I had asked??? I didnt see any reply which makes me think if it is very simple or if its difficult / time consuming.
Thanks,
Ajas.
On 10/13/06, Ajas Mohammed <[EMAIL PROTECTED]> wrote:Hello everyone, I apologize for the earlier mail sent.. I dont know what happened and the incomplete message got sent.....
I have 2 questions.
1) I have a search page which might return 1000's of records for a search/keyword. I have implemented Pagination i.e. showing NEXT / PREVIOUS (10) RECORDS at a time. My problem is that everytime I click on NEXT OR PREVIOUS, the query is getting executed all over again. I dont want the query to be run everytime NEXT/PREVIOUS link is clicked. I have this code to do the caching
<cfquery datasource="#client.dbname#" name="StateRegs" cachedwithin="#createTimeSpan(0,2,13,0)#">
</cfquery>
<cfoutput query="StateRegs" group="Reg_Name" startrow="#start#" maxrows="#end#">
data shown here
<td><a href="" + disp")#">Next >>#next# records</a> </td>
(this link basically takes to the same query page, but I have a url parameter action, which if set to search will run the query and display search results)
</cfoutput>
Similarly a link for previous records. In the coldfusion Administrator, ONLY SAVE CLASS FILES IS CHECKED AND MAXIMUM NUMBER OF CACHED QUERIES IS SET AS 300.
2. The second question is also long. So plz visit this URL...http://www.sitepoint.com/forums/showthread.php?t=428803
Its about implementing multiple word search on a site and you have search for those words (maybe 3 or 5 or even more) in 4 tables.
Thanks in advance...
Ajas.
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
