James,
Change the name of your id field...id is a reserved word. Make it "formid"
or something.
set checked = 1
should work. You wouldn't need the '1' or "1" for a yes/no field.
-d
Deanna Schneider
Interactive Media Developer
UWEX
, 2000 4:25 PM
To: [EMAIL PROTECTED]
Subject: 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
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 r
:[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 app
James, a Yes/No field (also known as a bit field) can hold a bit - that's either a 1
or a 0. In your query, you are enclosing the value in single quotes. '1'. This is SQL
syntax for strings. So the DB driver thinks you are trying to put a string into a bit
field. This returns an error. Try remo
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
6 matches
Mail list logo
