RE: Cannot Update MYSQL Database

[Kyle Lange]

I think you probably need to do one of the following;

Insert into info set referer = ?

Or

Insert into info (referer) values (?)

But I could be wrong. 



-----Original Message-----
From: jsp [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 25 March 2003 07:17
To: 'Tomcat Users List'
Cc: [EMAIL PROTECTED]
Subject: Cannot Update MYSQL Database


I'm running this code with no errors but it's not inserting the string
into the database ?

public void addInfo( String referer )
      throws SQLException, Exception {
         if (con != null) {
            try{
            
               PreparedStatement updateInfo;
               updateInfo = con.prepareStatement(
                                    "insert into info(?)");
               updateInfo.setString(1, referer )
               updateInfo.execute();

            
            
            }
               catch (SQLException sqle){ 
                  sqle.printStackTrace();
               }
         }
         else {
            error = "Connection with database was lost.";
            throw new Exception( error );
         }
      }

This is my database
mysql> desc info;
+---------+-----------+------+-----+---------+-------+
| Field   | Type      | Null | Key | Default | Extra |
+---------+-----------+------+-----+---------+-------+
| ID      | int(11)   |      | PRI | 0       |       |
| REFERER | char(200) | YES  |     | NULL    |       |
+---------+-----------+------+-----+---------+-------+
2 rows in set (0.00 sec)

Any Idea why nothing is showing up. Referer is a String its printing out
on the page but not updating the database?

Thanks anyone
-wiley

   


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]