Heya all,
I'm fairly new to all of this (though loving every minute!) and am stuck
with an SQL problem. What I want to have happen is this:
1. When the given entry is approved, the approved entry is written to a
table (seperate from the source table)
2. The entry in the original table is marked as approved.
The database in an Access2000 db, and the field "checked" is a YES/NO
type.
My problem is, when I process the form, the new record is written to the
second table just fine, but the original record is not marked as checked
off, and the test of the page chokes with an error. I know my problem is
in the SQL for the update, but I can't seem to get the expression right!
Here's what I have:
<cfquery name="checkedrecord" datasource="timesheets">
update timesheets
set checked='1'
where ID='#form.ID#'
</cfquery>
I've tried =1, ="1", ='1', since the "Mastering ColdFusion 4" book states
"When manipulating a Microsoft Access logical (YES/NO) field, use 1 for
YES and 0 for NO." So I *should* be setting it to 1...right?...
Is my problem my update query, or do I need to set a variable to use for
the set command, or what? I'm sure there's an obvious answer right in
front of me, but I'm stumped...
Thanks in advance!
James
=======================
James Mathieson
[EMAIL PROTECTED]
Kurtis & Associates, P.C.
2000 M Street, N.W., Suite 600
Washington, D.C. 20036
(202) 328-4500 (voice)
(202) 328-1231 (fax)
--
------------------------------------------------------------------------------
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.
