Ok, well, maybe more comprehensive. Did I mention that I loved playing
Mousetrap as a kid?
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: BOROVOY Noam [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 21, 2000 7:53 AM
> To: Fusebox
> Subject: RE: cf_queryrefresh
>
> Easier???
> If that's easy for you, looks like you deserve that certification ;-)
>
> ----------
> From: McCollough, Alan [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, 21 September 2000 17:27
> To: Fusebox
> Subject: RE: cf_queryrefresh
>
> I think there might be an easier solution, but it is based on using
> a 100%
> Microsoft solution...
> Lets say you've got an NT server cluster, complete with an MS SQL 7
> server
> in there.
>
> In your fusebox code, you create a var called, oh, db_timespan. Now,
> here's
> what to do. Have this var live up in app_globals.cfm, so it gets
> called
> persistently. But you set the variable by doing a CFREGISTRY read,
> and let's
> say you've got a Registry key called "{blah blah}\db_timespan". You
> could
> use the value in this var to change the CACHEDAFTER or CACHEDWITHIN
> values
> of a query, depends on what ya want to do.
>
> If you want to keep different timespans for different queries, you'd
> just
> set up additional Registry keys.
>
> So okay, follow with me, you've set this var up so every time
> app_globals
> gets called, you do a registry hit and get the new value. So what?
>
> I've found out you can do some mega-cool stuff with batch files in
> NT,
> including changing registry settings on remote boxes. Uh, huh, you
> see the
> idea coming together.
>
> For each "db_timespan" variable you have, you write a batch file
> that goes
> out and updates the Registry keys for those time vars on all the CF
> servers
> in your cluster; resetting the time to zero so as to force a fresh
> query.
> You make sure this batch file is installed on each server in the
> cluster so
> that any node on the cluster can execute the batch file.
>
> Now, you have two avenues you can take. The obvious one is to use
> CFEXECUTE
> to call the batch file whenever you run a Insert/Update/Delete
> query. The
> batch file gets called, and, ta-da, there ya go.
>
> The other solution, with its own benefits and caveats, is instead of
> housing
> the batch files on the CF boxes and using CFEXECUTE, use your SQL
> server and
> create a trigger for any Insert/Update/Delete actions. The trigger
> would
> then start a XP_CMDSHELL extended stored proc (thats pure MS SQL,
> folks; it
> ain't gonna be available elsewhere) to call the batch file.
>
> Alan McCollough
> Web Programmer
> Allaire Certified ColdFusion Developer
> Alaska Native Medical Center
>
> > -----Original Message-----
> > From: Steve Nelson [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, September 21, 2000 3:46 AM
> > To: Fusebox
> > Subject: Re: cf_queryrefresh
> >
> > The tag is not worth it. All it really does is set the timespan
> in the
> > cachedwithin attribute to #createtimespan(0,0,0,0)# when you set
> > attributes.refresh="yes"
> > #createtimespan(1,0,0,0)# when you set attributes.refresh="no" I
> was being
> > lazy when i wrote that. At the time i hadn't thought up what
> happens when
> > you have clustered servers.
> >
> > A much better solution is doing a thing I call the
> "Synchronization
> > Server". This will allow you to keep multiple clustered servers
> in Sync.
> > It's still just a theory, but if it
> > actually works we'll have a session on it at the next Fusebox
> conference,
> > because it is way cool.
> >
> > http://www.fusebox.org/theories/sync_server/
> >
> > Steve Nelson
> >
> > "Andrew Sleigh (Worth Media)" wrote:
> >
> > > Does anyone know where I can get hold of the <queryrefresh> tag
> that
> > Steve
> > > Nelson mentions in his spec on fusebox.org?
> > >
> > > the URL is
> > >
> > >
> >
> http://www.fusebox.org/specifications/largescale/index.cfm?fuseaction=quer
> > yf
> > > iles
> > >
> > > but the link seems to have died....
> > >
> > > Andy
> > >
> > >
> >
> --------------------------------------------------------------------------
> > ----
> > > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> > send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in
> > the body.
> >
> >
> --------------------------------------------------------------------------
> > ----
> > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> > send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in
> > the body.
>
> --------------------------------------------------------------------------
> --
> --
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --------------------------------------------------------------------------
> ----
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
