Re: Problem with AND &

Mike wrote:
"Jerry Stuckle" <jstucklex@xxxxxxxxxxxxx> wrote in message
news:_cKdnZScBvXoZ3renZ2dnUVZ_s6dnZ2d@xxxxxxxxxxxxxx
Mike wrote:

"Jerry Stuckle" <jstucklex@xxxxxxxxxxxxx> wrote in message
news:jpSdncRvI4QQpHrenZ2dnUVZ_t2dnZ2d@xxxxxxxxxxxxxx
Mike wrote:

Ah, I did not catch that since I changed the user records. It puzzled me then I remembered DUH!
the
organization records. So they are now changed.

However, everything still comes back zero. A question I do have is why does the first number
(varbinary(8) in MySQL) come back hex but the second number (PHP code as
define('CERTACCESS_MEMENTRY', 0x01);) come back as decimal (or so it looks like)? Could that be
the
problem?


function SecurityLevel_Check($security_byte, $securitylevel_bit) {
// & = 1 IF BOTH are 1
echo "<P>SecurityLevel_Check";
$binanswer = $security_byte & $securitylevel_bit;
echo "<P>nonbin byte=".$security_byte." /bit=".$securitylevel_bit." /nonbin result is
".$binanswer;
return $security_byte & $securitylevel_bit; }

SecurityLevel_Check

nonbin byte=0xFE /bit=2 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0xFE /bit=1 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0xFE /bit=4 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0xFE /bit=8 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0xFE /bit=16 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0xFE /bit=32 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0xFE /bit=128 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x00 /bit=1 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x00 /bit=2 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x00 /bit=4 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x00 /bit=8 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x00 /bit=16 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x00 /bit=32 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x00 /bit=64 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x6E /bit=4 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x6E /bit=8 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x6E /bit=16 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x6E /bit=32 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x04 /bit=1 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x04 /bit=2 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x04 /bit=4 /nonbin result is 0


SecurityLevel_Check

nonbin byte=0x04 /bit=8 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x04 /bit=16 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x04 /bit=32 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x01 /bit=1 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x01 /bit=2 /nonbin result is 0

SecurityLevel_Check

nonbin byte=0x01 /bit=4 /nonbin result is 0

>

Mike,

You're still close. But you're still passing a string as the first
parameter, not a numeric value. Otherwise, printing it out would give
the value 254 instead of 0xfe.

Bit operations are on integer values only. Here it's taking the '0xfe'
as a string and converting it to an integer. But the integer value of
the string is zero - so none of your test work.

You still need to figure out where the strings are coming from. If this
is coming from a database, the column needs to be an integer type. I
suspect you have it as a character type column.

BTW, you're doing find with bottom posting. But you need to either post
before the signature lines or delete them all together. Many news
readers (like Thunderbird) take everything after the signature separator
(dash-dash-space on a line by itself) as part of the signature.



As I said in the message, the database column is varbinary(8) in MySQL. The call to the function is

if(SecurityLevel_Check($recordSet_cert->fields['certcode_access'], CERTACCESS_MEMBERS) == 1) {

Should I change that to

if(SecurityLevel_Check((int)$recordSet_cert->fields['certcode_access'], CERTACCESS_MEMBERS) == 1) {

so it becomes an integer? Okay, tried that and it did not work. This also did not work.

function SecurityLevel_Check((int)$security_byte, $securitylevel_bit)

So I went thru the whole database changing varbinary(8) to tinyint. Then I reset the hex values as ints. Then I ran the test and it looks good!

Thank you for your patience and help. It is GREATLY appreciated.

Mike








No problem, Mike,

Yes, varbinary is a character type - basically the difference between that and varchar in MySQL is the binary types are case sensitive.

I know it is confusing, but that's how things work!

Glad you got it going.

And BTW - this post was perfect!

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.

Relevant Pages

  • Re: Problem with AND &
    ... Mike wrote: ... I did not catch that since I changed the user records. ... But you're still passing a string as the first ... before the signature lines or delete them all together. ...
    (comp.lang.php)
  • Re: Problem with AND &
    ... Mike wrote: ... I did not catch that since I changed the user records. ... But you're still passing a string as the first parameter, ... Many news readers take everything after the signature separator as part of the signature. ...
    (comp.lang.php)
  • Re: IP range to CIDR list VB6 utility?
    ... >> Mike, is UnpackDWord something new with VB.Net? ... string address and convert it to a binary equivalent enclosed within a long, ... But I still have to use CIDR notation, which requires looking at an address ... using netmask to generate that exact same network range list: ...
    (microsoft.public.vb.general.discussion)
  • Re: Countif for a string
    ... Thanks for both Bob and Harald for the quick response. ... > Hi Mike ... > Function ShouldImport(ByRef S As String) As Boolean ... >> I am importing a text file into excel line by line. ...
    (microsoft.public.excel.programming)
  • Re: Multiselect Listbox as qualifier for query
    ... That's correct, Mike. ... You can pass that kind of string in the ... Or you can re-write the SQL ... > other qualifiers within the individual query definitions. ...
    (microsoft.public.access.queries)