This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C01C39.709F19C4
Content-Type: text/plain;
charset="iso-8859-1"
Like this...
UPDATE Food
SET Hits = (Hits+1)
HTH,
Robert
-----Original Message-----
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 11, 2000 4:36 PM
To: [EMAIL PROTECTED]
Subject: Numeric Field
How exactly would I write this query, my table name being FOOD and field
being HITS.
>>> Robert Hinojosa <[EMAIL PROTECTED]> 09/08/00 12:39PM >>>
Try This
UPDATE Products
SET ProdCount = (ProdCount+1)
HTH,
Robert
-----Original Message-----
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 12:58 PM
To: [EMAIL PROTECTED]
Subject: Numeric Field
Is there a way to write a query that will add 1 to a numberic field in a
database? Meaning everytime the query is ran, it adds 1 to the current
number that is in the database. (example: if the database says 3 and I run
the query it will then say 4).
This may be a dumb question but it doesn't hurt to ask.
Thanks
Jeremy
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------_=_NextPart_001_01C019CC.8AAEC54A
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Numeric Field</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Try This</FONT>
</P>
<P><FONT SIZE=3D2>UPDATE Products =
=
=
=
=
=
</FONT>
<BR><FONT SIZE=3D2>SET ProdCount =3D (ProdCount+1)</FONT>
</P>
<P><FONT SIZE=3D2>HTH,</FONT>
</P>
<P><FONT SIZE=3D2>Robert</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Jeremy Toevs [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, September 08, 2000 12:58 PM</FONT>
<BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>Subject: Numeric Field</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Is there a way to write a query that will add 1 to a =
numberic field in a database? Meaning everytime the query is ran, it =
adds 1 to the current number that is in the database. (example: if the =
database says 3 and I run the query it will then say 4).</FONT></P>
<P><FONT SIZE=3D2>This may be a dumb question but it doesn't hurt to =
ask.</FONT>
</P>
<P><FONT SIZE=3D2>Thanks</FONT>
<BR><FONT SIZE=3D2>Jeremy</FONT>
</P>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C019CC.8AAEC54A--
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------_=_NextPart_001_01C01C39.709F19C4
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Numeric Field</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Like this...</FONT>
</P>
<P><FONT SIZE=3D2>UPDATE Food =
=
=
=
=
</FONT>
<BR><FONT SIZE=3D2>SET Hits =3D (Hits+1)</FONT>
</P>
<P><FONT SIZE=3D2>HTH,</FONT>
</P>
<P><FONT SIZE=3D2>Robert</FONT>
<BR><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Jeremy Toevs [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, September 11, 2000 4:36 PM</FONT>
<BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>Subject: Numeric Field</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>How exactly would I write this query, my table name =
being FOOD and field being HITS.</FONT>
</P>
<P><FONT SIZE=3D2>>>> Robert Hinojosa =
<[EMAIL PROTECTED]> 09/08/00 12:39PM >>></FONT>
</P>
<P><FONT SIZE=3D2>Try This</FONT>
</P>
<P><FONT SIZE=3D2>UPDATE Products =
=
=
=
=
=
</FONT>
<BR><FONT SIZE=3D2>SET ProdCount =3D (ProdCount+1)</FONT>
</P>
<P><FONT SIZE=3D2>HTH,</FONT>
</P>
<P><FONT SIZE=3D2>Robert</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Jeremy Toevs [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>] </FONT>
<BR><FONT SIZE=3D2>Sent: Friday, September 08, 2000 12:58 PM</FONT>
<BR><FONT SIZE=3D2>To: [EMAIL PROTECTED] </FONT>
<BR><FONT SIZE=3D2>Subject: Numeric Field</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Is there a way to write a query that will add 1 to a =
numberic field in a</FONT>
<BR><FONT SIZE=3D2>database? Meaning everytime the query is ran, it =
adds 1 to the current</FONT>
<BR><FONT SIZE=3D2>number that is in the database. (example: if the =
database says 3 and I run</FONT>
<BR><FONT SIZE=3D2>the query it will then say 4).</FONT>
</P>
<P><FONT SIZE=3D2>This may be a dumb question but it doesn't hurt to =
ask.</FONT>
</P>
<P><FONT SIZE=3D2>Thanks</FONT>
<BR><FONT SIZE=3D2>Jeremy</FONT>
</P>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
-------------</FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A> </FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or</FONT>
<BR><FONT SIZE=3D2>send a message to [EMAIL PROTECTED] =
with 'unsubscribe' in</FONT>
<BR><FONT SIZE=3D2>the body.</FONT>
</P>
<P><FONT SIZE=3D2>------_=3D_NextPart_001_01C019CC.8AAEC54A</FONT>
<BR><FONT SIZE=3D2>Content-Type: text/html;</FONT>
<BR> <FONT =
SIZE=3D2>charset=3D"iso-8859-1"</FONT>
<BR><FONT SIZE=3D2>Content-Transfer-Encoding: quoted-printable</FONT>
</P>
<P><FONT SIZE=3D2><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML =
3.2//EN"></FONT>
<BR><FONT SIZE=3D2><HTML></FONT>
<BR><FONT SIZE=3D2><HEAD></FONT>
<BR><FONT SIZE=3D2><META HTTP-EQUIV=3D3D"Content-Type" =
CONTENT=3D3D"text/html; =3D</FONT>
<BR><FONT SIZE=3D2>charset=3D3Diso-8859-1"></FONT>
<BR><FONT SIZE=3D2><META NAME=3D3D"Generator" =
CONTENT=3D3D"MS Exchange Server version =3D</FONT>
<BR><FONT SIZE=3D2>5.5.2650.12"></FONT>
<BR><FONT SIZE=3D2><TITLE>RE: Numeric Field</TITLE></FONT>
<BR><FONT SIZE=3D2></HEAD></FONT>
<BR><FONT SIZE=3D2><BODY></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D3D2>Try =
This</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D3D2>UPDATE Products =
=3D</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp; =3D</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp; =3D</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp; =3D</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp; =3D</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp; =3D</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp; </FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>SET ProdCount =3D3D =
(ProdCount+1)</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT =
SIZE=3D3D2>HTH,</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT =
SIZE=3D3D2>Robert</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D3D2>-----Original =
Message-----</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>From: Jeremy Toevs =
[<A =3D</FONT>
<BR><FONT SIZE=3D2>HREF=3D3D"<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>"><A=
=
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A></A>]&=
lt;/FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>Sent: Friday, =
September 08, 2000 12:58 PM</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>To: =
[EMAIL PROTECTED]</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>Subject: Numeric =
Field</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
<BR><FONT SIZE=3D2><BR></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D3D2>Is there a way to =
write a query that will add 1 to a =3D</FONT>
<BR><FONT SIZE=3D2>numberic field in a database? Meaning everytime the =
query is ran, it =3D</FONT>
<BR><FONT SIZE=3D2>adds 1 to the current number that is in the =
database. (example: if the =3D</FONT>
<BR><FONT SIZE=3D2>database says 3 and I run the query it will then say =
4).</FONT></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D3D2>This may be a dumb =
question but it doesn't hurt to =3D</FONT>
<BR><FONT SIZE=3D2>ask.</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT =
SIZE=3D3D2>Thanks</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT =
SIZE=3D3D2>Jeremy</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT =3D</FONT>
<BR><FONT =
SIZE=3D2>SIZE=3D3D2>-------------------------------------------------=
--------------=3D</FONT>
<BR><FONT SIZE=3D2>---------------</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>Archives: <A =
=3D</FONT>
<BR><FONT SIZE=3D2>HREF=3D3D"<A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A>" =3D</FONT>
<BR><FONT SIZE=3D2>TARGET=3D3D"_blank"><A =
HREF=3D"http://www.mail-archive.com/[email protected]/=3D" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
=3D</A> </FONT>
<BR><FONT SIZE=3D2></A></FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D3D2>To Unsubscribe =
visit <A =3D</FONT>
<BR><FONT SIZE=3D2>HREF=3D3D"<A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=3D=
3Dli=3D" TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sideba=
r=3D3Dlists&body=3D3Dli=3D</A> </FONT>
<BR><FONT SIZE=3D2>sts/cf_talk" =3D</FONT>
<BR><FONT SIZE=3D2>TARGET=3D3D"_blank"><A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists=3D" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlis=
ts=3D</A> </FONT>
<BR><FONT SIZE=3D2>&body=3D3Dlists/cf_talk</A> or send a =
message to =3D</FONT>
<BR><FONT SIZE=3D2>[EMAIL PROTECTED] with 'unsubscribe' =
in the =3D</FONT>
<BR><FONT SIZE=3D2>body.</FONT></P></FONT>
</P>
<P><FONT SIZE=3D2></BODY></FONT>
<BR><FONT SIZE=3D2></HTML></FONT>
<BR><FONT SIZE=3D2>------_=3D_NextPart_001_01C019CC.8AAEC54A--</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A> </FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A> </FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C01C39.709F19C4--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
