I already encountered that problem .. you should try 0 and -1 instead of 0
and 1 ... that worked for me :)
> -----Message d'origine-----
> De: Chris Meier [SMTP:[EMAIL PROTECTED]]
> Date: 4 mai, 2000 16:25
> �: [EMAIL PROTECTED]
> Objet: RE: Updatign a YES/NO record
>
> If the ID field is an auto-number field, remove the quotes around
> #form.id#.
> Also, if this is an Access2000 db, you might try using YES and NO instead
> of
> 0 and 1...a lot changed in Access2k from 97, this might be one of those
> changes.
>
> -----Original Message-----
> From: James Mathieson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 04, 2000 4:13 PM
> To: Cf-Talk Mailing List (E-mail)
> Subject: Updatign a YES/NO record
>
>
> 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.
>
> --------------------------------------------------------------------------
> ----
> 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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
