need help with function

From: Rhonda Nowak (rmn@itol.com)
Date: Wed Oct 06 1999 - 00:51:01 EST


Hi Everyone,

I have a simple function that will do a query and put out some results to
the browser.
The socket is open prior to calling this function.
$sock and $physician_row[0] are both ints.

calling function:
displaySpecialties((int) $sock, (int) $physician_row[0]);

funct displaySpecialties(int $sock, int $physician_row)
{
        $qryStr = "select specialty.specialty_name
                        from specialty, physician_specialty
                        where specialty.specialty_id = physician_specialty.specialty_id and
                        physician_specialty.physician_id = $physician_row
                        order by specialty.specialty_name";

        if (msqlQuery( $sock, $qryStr ) < 0 ) {
                fatal("Can't select from specialty table : $ERRMSG");
        }
        .
        . more to function here
        .
}

Problem:
I get the following error on execution:

W3-mSQL Runtime Error! - Invalid comparison for this type
ON THE msqlQuery line.

Any help is greatly appreciated.
Thanks much.

Have a great day!

Rhonda Nowak
Infinity Technology, Inc.
2200 Riverside Drive
Green Bay, WI 54301
(920) 420-1117 x1303
email rmn@itol.com
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/



This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST