|
 |
pro_jsp thread: Data type mismatch in criteria expression.
Message #1 by "Piragash Moorthi Kanneappan" <rakanpithi@y...> on Wed, 25 Jul 2001 06:05:19
|
|
Below is an excerpt of my code. FYI, I am using MS-Access 2000, and in my
table makKilang, idKlg is already defined as text (a.k.a. string :) )
Then, why do i get the 500 error like below..
Help...
Thanx.
Piragash.
-------------------------------------------------------------
500 Internal Server Error
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type
mismatch in criteria expression.
---------------------------------------------------------------
(excerpt)
<html>
<head>
<title>Borang Pengubahsuaian Maklumat Kilang Luar</title>
</head>
<%@ page language="java" import="java.sql.*,java.io.*" %>
<body>
<p align="center">Borang Pengubahsuaian Maklumat Kilang Luar
<br><br>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection dbCon = DriverManager.getConnection("jdbc:odbc:db1");
Statement stmt = dbCon.createStatement();
Statement stmr = dbCon.createStatement();
String c = "";
String d = "";
String e = "";
String id = "010";
ResultSet myResult = stmt.executeQuery("SELECT * FROM makKilang
WHERE idKlg ="+ id );
if ((myResult != null) || (myResult.next()))
{
c = myResult.getString("nmKlg");
d = myResult.getString("alt1Klg");
e = myResult.getString("alt2Klg");
}
%>
<form method="POST">
<p align="center">Nama Kilang : <input type="text"
name="nmKlg" size="20" value="<%= c %>"></p>
<p align="center">Alamat 1 : <input type="text"
name="alt1Klg" size="20" value="<%= d %>"></p>
<p align="center">Alamat 2 : <input type="text"
name="alt2Klg" size="20" value="<%= e %>"></p>
<p align="center"><input type="submit" value="Submit"
name="submit"><input type="reset" value="Reset" name="reset"></p>
</form>
<%
stmt.close();
stmr.close();
dbCon.close();
%>
</body>
</html>
|
|
|
View Cart
