Re: HELP!!! SEVERE: VendorError: 1064 during INSERT

2004-08-11 Thread Jonathan Mangin
I didn't actually count the characters but it looks very close to a 512-character limit. (I used a pica stick on the screen, very accurate!) The error message appears to be showing a truncated line. Is possible? --Jon > > > > > > INSERT INTO dirxml.emp > > > (fld_ind_id,fld_frname,fld_srname,fld_

Re: HELP!!! SEVERE: VendorError: 1064 during INSERT

2004-08-11 Thread Rhino
- Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Shaffin Bhanji" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 11, 2004 4:20 PM Subject: Re: HELP!!! SEVERE: VendorError: 1064 during INSERT &g

Re: HELP!!! SEVERE: VendorError: 1064 during INSERT

2004-08-11 Thread Rhino
[EMAIL PROTECTED]> Sent: Wednesday, August 11, 2004 4:02 PM Subject: RE: HELP!!! SEVERE: VendorError: 1064 during INSERT > The statement is from a System.out.println() and my code is as follows: > > public boolean insert(String sql) { > > try { > >

RE: HELP!!! SEVERE: VendorError: 1064 during INSERT

2004-08-11 Thread Shaffin Bhanji
"F"); Shaffin. >>> Victor Pendleton <[EMAIL PROTECTED]> 08/11/04 3:41 PM >>> Can you system.out.println the sql statement to verify what you have is correct? Also, are you using prepared statements? -Original Message- From: Shaffin Bhanji To: [EMAIL PRO

RE: HELP!!! SEVERE: VendorError: 1064 during INSERT

2004-08-11 Thread Victor Pendleton
Can you system.out.println the sql statement to verify what you have is correct? Also, are you using prepared statements? -Original Message- From: Shaffin Bhanji To: [EMAIL PROTECTED] Sent: 8/11/04 2:07 PM Subject: HELP!!! SEVERE: VendorError: 1064 during INSERT Hello All, I have the

HELP!!! SEVERE: VendorError: 1064 during INSERT

2004-08-11 Thread Shaffin Bhanji
Hello All, I have the following environment: MySQL 4.1.3-beta-standard Connector/J 3.0.14 SUN Java JDK 1.4.2 SUSE Linux 9.1 I have written a java program to insert information into an "emp" table as follows: INSERT INTO dirxml.emp (fld_ind_id,fld_frname,fld_srname,fld_init,fld_sh_name1,fld_sh_n