back to results

Question

Hi i have a websites which generates quotes for a user.

The user types in a area and price and it will select the
companies fromt the database based on area (page name is
getquotefigures.cfm). It will also select the comapny which
receieved the information last. Once it generates the lead it puts
it into the database. 
The user can then request that the company calls them.It goes
to another page where the user can put in any information they
require. It then goes to a page that e-mails the information. There
is a button on this page which says return to quote. I want it to
go back to the getquotefigures.cfm. How can i do this without it
creating a new search

Grizzly9279 · Answer

I'm not sure if I understand what you're trying to accomplish 100% here...but I'll see if I can help.

Are you hoping to save yourself from having to re-execute the search query (for performance reasons?). Or are you trying to preserve the original search results, since the results could potentially change, even within a minute or two?

Either way, you could try to accomplish this within the database itself, or you could implement some sort of query result caching mechanism at the application level.

Some of the more advanced DBMSs offer ways to accomplish this. Using Oracle as just one example, you could leverage DBMS_FLASHBACK to query for a result as of a specific system change number (as of scn). Other DBMSs offer similar functionality I believe - but you might have to research it a bit.

Alternatively, if you want to cache the search results in the user's session (in ColdFusion) - you could very easily accomplish that by doing something like the following:

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded