Easy function question

Anon

I created a function i pasted the code below, But i keep getting the wrong result to display, it keeps thinking the $geostatus is equal to zero. My guess is that its rounding the numbers to zero because they are a really high negative number. Is there way to keep it from rounding? My code is below...

<?PHP
FUNCTION MOUSE ($GEOSTATUS)
{
IF ($GEOSTATUS == -2147483640)
{
$GEOCODE = \'Range\';

	}
IF ($GEOSTATUS == -2147418112)
	{
$GEOCODE = \'Envelop\';

	}

ELSE IF ($GEOSTATUS == -2147483376)
{
$GEOCODE = \'Mouse Geocode\';

	}
ELSE IF ($GEOSTATUS == -2147483644)
	{
	$GEOCODE = \'At Street\';
	}
ELSE IF ($GEOSTATUS == -2143287296)
	{
	$GEOCODE = \'Dialog Box\';
	}
	ELSE IF ($GEOSTATUS == 0)
{
	$GEOCODE = \'Not Geocoded\';
	}
RETURN ($GEOCODE);
}

$query = \"select GEOSTATUS, addrid, GEostatus
from ADDRESS
where ADDRTYPE = \'CH\' and addrid = 7750\";
$
while (OCIFetchInto ($cursor, $values)){
$GEOSTATUS = $values[0];
MOUSE ($GEOSTATUS);

Anon

echo the value of $geostatus to the screen before you apply the function and see the value.

then do this:

$myvalue=MOUSE ($GEOSTATUS);
echo $myvalue;

and see what you get.

rrijnders

I think it is your <b>if</b>'s and <b>else</b>'s that are foobar'd. Try a switch statement instead:

switch $GEOSTATUS {

case -2147483640:
  $GEOCODE = \'Range\';
  break;

case -2147418112:
  $GEOCODE = \'Envelop\';
  break;

case -2147483376:
  $GEOCODE = \'Mouse Geocode\';
  break;

case -2147483644:
  $GEOCODE = \'At Street\';
  break;

case -2143287296:
  $GEOCODE = \'Dialog Box\';
  break;

default:
  $GEOCODE = \'Not Geocoded\';

}

-- Rich

Anon

Thank you for your help guys. But I still keep getting Not Geocoded. Even when i a specify a perticular value for $Geostatus that i know should return envelope i get Not Geocoded. Any other suggestions??

Thank you for your help

Varun

rrijnders

Are those values coming from an application or from a form field?

If they are coming from user input, then just do the comparison against the literal instead of casting to an integer. Also, make sure you use trim() on value before you compare to the literal.

-- Rich