Thanks guys! This is what works: String sqlString = "SELECT str_card_fields FROM card_type WHERE str_card_type='"+cardType+"';";
Sandra Patricia Hunter Systems Development and Web Design -----Original Message----- From: Filip Hanik [mailto:[EMAIL PROTECTED] Sent: April 1, 2003 2:06 PM To: Tomcat Users List Subject: RE: JDBC-ODBC bridge error it is just a typo, I think what you want is this String sqlString = "SELECT card_type.str_card_fields FROM card_type WHERE (((card_type.str_card_type='"+cardType+"'));"; cardType, is from you java and is a parameter Filip > -----Original Message----- > From: Sandra Patricia Hunter [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 01, 2003 1:54 PM > To: 'Tomcat Users List' > Subject: JDBC-ODBC bridge error > > > I am using the JDBC-ODBC bridge driver during development because I > don't want to load Oracle on my system here and am using Access for > now, and will be using Oracle in the final production. I know I know: > it isn't good but I > don't think it is the heart of the problem. > I don't know if that is the source of the problem but I am getting this > error message: > [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. > only on one page while the others using the same driver don't produce that > error. It may just be an SQL error. Here is the code snippet: > > String cardType = manageData.getCardType();%> > <P> cardType: <%=cardType%></p> //this is just a debug line and > produces the required value > <% > String sqlString = "SELECT card_type.str_card_fields FROM card_type > WHERE (((card_type.str_card_type=cardType));"; > > ResultSet rs = statement.executeQuery (sqlString); > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
