i need explanation..

[changym]

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in C:\HTTPD\HTDOCS\hr\add_result.php on line 49

can u tell me what's wrong with this? and how do i solve the problem? hee.. thanx in advance! ^ ^

[brandonschnell]

typically it means you're trying to do something like add a VARCHAR & an INT. make sure the type of data you're working with matches up with the columns in the DB.

[changym]

hello Brandon Schnell,

how to convert from varchar to int??
which command should i use??
in my DB, the field(loc_id) is in auto-number...

thank you again and again~~

[brandonschnell]

what is the sql command its failing on and what does your db table look like?

[changym]

else if($location_name=="")
{

		 $result3=odbc_exec($con, "select location from location, data where loc_id='$location_id'");


				echo" Location: ".odbc_result($result3, "location")."<br>";

the above code is what i wrote, and i wanna display the location from the pull menu.

[changym]

i solved the problem...
thanx alot too