Member Avatar for shantanusinghal 
$conn=odbc_connect('mobshopDB','','');
	if(!$conn){
		exit("Connection Failed: " . $conn);
	}
	$query="INSERT INTO users(uid,pass,fname,lname,pmm) VALUES('$username','$password','$fname','$lname',$pmm)";
	$rs=odbc_exec($conn,$query);

this query gives me this error
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in C:\Program Files\EasyPHP-5.3.6.0\www\mobshop\registered.php on line 39

..please suggest a solution

NOTE: pmm is a numeric field, thats why i haven't put it in quotes.

  • 2 Contributors
  • 1 Reply
  • 91 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by hielo
Member Avatar for hielo

Are you sure all those variables are properly initialized? Before line 6, add the following: echo $query; What do you get?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.