I get errors like that with coldfusion pages connecting to access if the
variable type does not match the database field or if the value is null.
if the database field is a string you I need to use single quotes around the
value in the sql statement
String sqlString = SELECT
Hi Sandra,
String sqlString = SELECT card_type.str_card_fields FROM card_type
WHERE (((card_type.str_card_type=cardType));;
you are using 3 opening brackets and only 2 closing ones in your where
condition. IMHO it would be correct SQL to write:
SELECT card_type.str_card_fields FROM
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
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
. And they'll probably act
differently as well.
--mikej
-=-
mike jackson
[EMAIL PROTECTED]
-Original Message-
From: Sandra Patricia Hunter [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 2:13 PM
To: 'Tomcat Users List'
Subject: RE: JDBC-ODBC bridge error
Thanks guys