It'll only work 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 / INSERT
> You need to set your table to have COLUM1 have a value 0 assigned by
> default, this is possible in SQL not sure about other dbs. When a record
is
> created, COLUM1 will be automatically assigned a value of 0 by default.
So,
> if you always do an update, the value will be updated even if you have not
> previously assigned a value. Does this make sense?
>
>
> Phil.
>
> > -----Original Message-----
> > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > Sent: 22 April 2001 13:59
> > To: CF-Talk
> > Subject: Re: UPDATE / INSERT
> >
> >
> > but if the value is not exists in "COLUM" I'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]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Sunday, April 22, 2001 1:18 PM
> > Subject: RE: UPDATE / INSERT
> >
> >
> > > Micheal,
> > >
> > > Thinking about it, if the value does exist and you simply want to
check
> > what
> > > that value is before updating, you could always do an update
> > irrespective
> > of
> > > the value, sure, this will mean doing an un-necessary update
sometimes,
> > but
> > > isn't that better than making two connections (select & 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, 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 will always be able
to
> > > > increment the value by 1 using UPDATE.
> > > >
> > > > HTH
> > > >
> > > > Phil.
> > > >
> > > > > -----Original Message-----
> > > > > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > > > > Sent: 22 April 2001 13:06
> > > > > To: CF-Talk
> > > > > Subject: UPDATE / INSERT
> > > > >
> > > > >
> > > > > I'm trying to find the best way to have SQL do this:
> > > > > IF COLUM1 already contains "VALUE" then UPDATE COLUM2+1
> > > > > IF NOT, INSERT COLUM1,COLUM2 VALUES ("VALUE",1)
> > > > >
> > > > > Currently I'm using SELECT / RecordCount to first find out if the
> > > > > VALUE exists.
> > > > >
> > > > > There must be a better way...
> > > > >
> > > > > Michael.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
