RE: javascript frame refresh function for IE4.07

2001-04-26 Thread Phil Ewington
Sorry, please ignore last post, the correct code is parent.document.frames['left'].location = "nav.cfm"; Phil. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http:/

RE: javascript frame refresh function for IE4.07

2001-04-26 Thread Phil Ewington
Try document.frames[left].location.href Phil. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http

RE: UPDATE / INSERT

2001-04-22 Thread Phil Ewington
ing like this. > > > > > > Thanks! > > > > > > > > > SELECT DN from logs WHERE DT=#DT# > > > > > > > > > > > > > > > UPDATE logs > > > SET DN=DN+#DN# WHERE DT=#DT# > > > > > > &g

RE: UPDATE / INSERT

2001-04-22 Thread Phil Ewington
> > > UPDATE logs > SET DN=DN+#DN# WHERE DT=#DT# > > > > > INSERT INTO logs (DN,DT) VALUES (#DN#,#DT#) > > > > > - Original Message - > From: "Phil Ewington" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]>

RE: UPDATE / INSERT

2001-04-22 Thread Phil Ewington
rk if I have all the possible values already placed > in COLUM1. > > - Original Message - > From: "Phil Ewington" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, April 22, 2001 2:34 PM > Subject: RE: UPDATE / I

RE: UPDATE / INSERT

2001-04-22 Thread Phil Ewington
'll need to use INSERT > to assign > default values. > I can't predicte all the possible values, so I can't make a > "READY-FOR-UPDATE-ONLY" table. > > > - Original Message - > From: "Phil Ewington" <[EMAIL PROTECTED]> > T

RE: UPDATE / INSERT

2001-04-22 Thread Phil Ewington
elect & update) if the update is required. Only a thought. Phil. > -Original Message----- > From: Phil Ewington [mailto:[EMAIL PROTECTED]] > Sent: 22 April 2001 12:04 > To: CF-Talk > Subject: RE: UPDATE / INSERT > > > Do you mean if the record exists UPDATE,

RE: UPDATE / INSERT

2001-04-22 Thread Phil Ewington
Do you mean if the record exists UPDATE, or if the value in the column is specified update? If the record does not exist, use cftry/cfcatch: try UPDATE, if fails do INSERT. If the record exists but value is NULL, you are probably better off setting the columns default value to zero, this way you

RE: SQL SERVER and IIS on the same machine?

2001-04-22 Thread Phil Ewington
Hi Michael, We have been using IIS 5.0 & SQL 7.0 on the same machine for about a year. No real problems, but now our traffic levels are much higher we have had to upgrade the memory to 1GB. We will be looking into moving the SQL to it's own server soon. For lower traffic sites I do not see a prob

CF Performance monitoring

2001-04-21 Thread Phil Ewington
Hi, I am trying to set-up performance monitoring for ColdFusion on a win2k platform, my problem is that the counters are not available to the performance monitor. I am sure that these have been removed for some reason and need to know if they can be re-installed or whether I need to do a complete