I build a series of form rows as follows:
<td><input type=radio name=\"$Userid\" value=\"$orgID\"></td>
<td><input type=text value = \"$Name\" name=name onFocus=\"this.blur()\"></td>
<td><input type=text value = \"$Userid\" name=userid onFocus=\"this.blur()\"></td>
<td><input type=text value = \"$Password\" name=password onFocus=\"this.blur()\"></td>
I ma trying to run a query that will delete a record based on the value of $orID as follows:
$SQL_Exec_String = "Delete * From user WHERE memorg_id = '".$_POST['orgID']."'";
$cur= odbc_exec( $cnx, $SQL_Exec_String);
if (!$cur)
{
Error_Handler( "Error in odbc_exec( no cursor returned )" , $cnx );
}
Problem is I get a data type mismatch on the $orgID. If I output the $orgID value in my javascript it is a number as it should be. Also, if I hard code the query with a number the record is deleted. Where is this thing going wrong? Why the datatype mismatch?