Many thanks for your kind response. I was using a form that was submitted twice
for any given new ssn. I have also benefited from your comments on how to write
a better java code. Turns out my html and javascript skills need improvement.
Many thanks again.
Regards
David Griffiths <[EMAIL P
This is a little dangerous as well; if an exception gets thrown, the
statement doesn't get closed. My sample code is below.
That said, your query looks fine. Add logging to your code to figure out
what's going on. Run your query by hand against your database; I suspect
you have an issue with
I tried everything you suggested. 'Think it is the way I have set up
the table in MYSQL. This is the table
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---
Here is the code:
ps = con.prepareStatement("select first, last from cust where ssn=?");
int ssnint = Integer.parseInt(ssn.trim());
ps.setInt(1, ssnint);
ResultSet rs=ps.executeQuery();
if ( rs.next()) {
rs.close();
out.println("Cust
I am getting the same result in Java code, i.e. the resultset returned is
non-null even though the primary key value is not found in the table.
Hassan Schroeder <[EMAIL PROTECTED]> wrote: On 12/29/06, murthy gandikota
wrote:
> I am posting the relevant JSTL code.
Just to clarify: you're *not
http://www.cqhost.com/
I have a JSP app hosted there and they are pretty good. They also provide a
MSQL DB
Mark
-Original Message-
From: Ken Anderson <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, March 21, 2002 2:39 PM
Subject: Re: JSP or
Klym wrote:
>
> I have built a MySQL database for a web based survey. I am trying to decide
> between JSP and PHP for my programming interface. The reason I am
> considering Java is because I have some Java experience. What would you
> recommend for someone like me who is starting out?
If you
PHP all the way.
This will give you a lot of information on what your options are:
http://uptime.netcraft.com/up/graph?site=www.klym.ca
and substitute site=www.yourdomainname.com
It will tell you what modules they currently support etc.
PHP is faster than JSP and I think its a whole lot more
> Name: MySQL
> Display Name: MySQL
> Driver: org.gjt.mm.mysql.Driver
> URL:
> jdbc:mysql://192.168.0.2:80/studiosusa?user=root&password=axnolnms
I would assume that here is your problem, most likely mysql is not running
on port 80 on your machine and you should change it to 3306,
Hello -
You may wish to try something a little bit more fundamental if you are new
to the Java thing.
one good way to learn how everything works in JSP is to use a free Java
Server, such as Tomcat, and build pages using Macromedia's ultradev
software. There is an extension that installs JDBC-ODBC
Are you sure MySQL is listening on port 80? The default port is 3306:
jdbc:mysql://192.168.1.2:3306/
-Original Message-
From: Benj Arriola [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 10:56 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: JSP newbie n
Hi sara,
Try with:
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor
d");
I can able to understand that you want to use mysql database using Jsp.
regards,
S.Chitra
At 6:41 AM -0800 2/2/01, Labs Racing wrote:
>First excuse me for my english,
>
> I should like of knowing if the mysql ago connection
> with the jsp, what if if he may do, drop of knowing
> where I could meet any tutorial, if exist.
> Thank you by attention.
> Sara.
If you are familiar with
13 matches
Mail list logo
