What interface are you using to execute this code? Since this is
CF-TALK I assume there is some CF code involved? Can you supply this
code then someone may be able to spot the problem for you.
----- Original Message -----
From: Daniel Kessler <[EMAIL PROTECTED]>
Date: Mon, 13 Sep 2004 10:27:28 -0400
Subject: Update a field
To: CF-Talk <[EMAIL PROTECTED]>
I'm trying to manually update an entry in a database (ORACLE) so that
I can insert a number into it'd ID field.
update whats_new
set id = 2
where header = 'Dr. Catherine Ennis Wins McKenzie Award'
I'm getting SQL Command Not Properly Ended. This works fine if I
remove the WHERE line, but the reason that I'm giving it an id is
that the header is too inexact an identifier.
So any thoughts on how to get this working? I tried adding some
semi-colons, but it didn't work.
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
