JDBC using Servlets!!!!!!Hurry up!

Hi,

MySelf Savdeep Vasudeva,Presently I am involved in a project using JDBC-ODBC Bridge in which I want to connect a database table to a HTML Page using Java Servlets.When I fill the form on the HTML Page using numeric data in all my variables,it works quite good and the query is executed.Consequently the data of the person who has filled in the form is displayed.But when I want to change one of the numeric variables(parameter variable) to a String by also making the data type change in my table from numeric to character.The query is not executed at all and It gives the exception message.Kindly help me that how should I make a query in the Java Servlets using the String Variables in the condition.Presently I am only Limited to numeric

variables.Waiting for a quick response from your side.

Regards,

Savdeep Vasudeva.

E-mail: svasu60@rediffmail.com

[903 byte] By [svasu60] at [2007-9-26 2:12:19]
# 1
can you please post some of the code where you construct the query and the error message you get?
wobelix at 2007-6-29 9:05:25 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2

Savdeep,

it would really help, if u posted some part of the erroneous code. anyway, u say u have changed the datatype in ur table to string, but while receiving the parameters, what ru using?

for integers values u would have been using something like: rs.getInt(col index);

whereas to get a string value u have to use:

rs.getString(col index);

are u making this change in ur code?

keep progRamming...

-satyen

filtertipped at 2007-6-29 9:05:25 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...