Try this:
UPDATE USACopy SET BusUnitID=8 WHERE ID=3
Josh
----- Original Message -----
From: "S R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 01, 2000 10:26 AM
Subject: Re: Very Weird INSERT Problem
> This didn't work at all. You're telling me to insert on top of ID which
> already has a value of 3. ID is an 'Autonumber' field in ACCESS so it
won't
> allow this, plus thats not what I want to do anyway.
>
>
> >From: "Larry Meadors" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: <[EMAIL PROTECTED]>
> >Subject: Re: Very Weird INSERT Problem
> >Date: Mon, 01 May 2000 11:13:49 -0600
> >
> >You don't want a where in your insert. Try this:
> >
> >INSERT INTO USACopy (BusUnitID, ID) VALUES (8, 3)
> >
> >Larry
> >
> > >>> [EMAIL PROTECTED] 05/01/00 11:08AM >>>
> >I have tried everything, changing the name of the query, recreating the
> >table, Naming the field different names and I still get the error:
> >
> >Missing semicolon (;) at end of SQL statement.
> >
> >I even tried adding the semicolon and then it says:
> >
> >Characters found at end of SqL statement.
> >
> >It is just a simple insert statement going into a table in ACCESS.
> >
> ><cfquery datasource="synergy" name="TryToInsert">
> >INSERT INTO USACopy(BusUnitID)
> >VALUES(8)
> >WHERE ID = 3
> ></cfquery>
> >
> >
>
>---------------------------------------------------------------------------
---
> >Archives: http://www.eGroups.com/list/cf-talk
> >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.
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.
