tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sandra Patricia Hunter <redbirdoftheso...@shaw.ca>
Subject RE: JDBC-ODBC bridge error
Date Tue, 01 Apr 2003 22:12:37 GMT
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:mail@filip.net] 
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:redbirdofthesouth@shaw.ca]
> 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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message