Member Avatar
I have an error "ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression". I am using VBdotNet2005 and MS Access as its database, and I can't really get the hang of this error. I've been trying to google the answer but I cannot find solution for this. …
by aerohn in Software Development ()
Member Avatar
<%@ page import="java.sql.*" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body> <% String ans=" "; if(request.getParameter("correctAns")!=null) { ans=request.getParameter("correctAns").toString(); } Connection con = null; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = java.sql.DriverManager.getConnection("jdbc:odbc:sid"); Statement st = null; ResultSet qrst; ResultSet rs = null; String id=request.getParameter("id"); …
by biplob29 in Web Development ()
Member Avatar
Hi, My Access database has one column named 'Term' and the Table name is 'ATG'. I require to populate my listbox with data in the 'Term' columns. I'm unable to do that using this code. Can anyone tell me what's wrong with this (it displays numbers from 1 to 10 …
by nitguit in Software Development ()
Member Avatar
HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in …
by gruffy321 in Databases ()
Member Avatar
I need functionality to retrieve the new pk, like I could in DAO. I would like my "nLog" function (see code below) to return the new pk. I have found this , and I was able to make it work fine in my environment, so I'm pretty sure the problem …
by PerplexedB 2 in Software Development ()