-
Oct 21st, 2004, 12:58 PM
#1
SQL Update on Bit field (Resolved)
I'm having a strange problem with an update query. I have an update line that includes a set statement like this:
SET Injected = " & injected & "
The column Injected is a bit field, and the variable injected is a boolean. In this query, I get an error saying the column name is invalid. I assume that I have to enclose the variable in some kind of punctuation, but I can't figure out what.
I was able to work around it by interpreting the boolean as an integer (1/0) which works fine when put into the statement.
I assume this is simple, but I haven't done it before, and haven't seen any usefull reference for it.
Last edited by Shaggy Hiker; Oct 21st, 2004 at 01:59 PM.
My usual boring signature: Nothing
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|