update jsp mysql

[sensory21]

Hi all,

I am trying to update (after editing) some displayed records in a form, the file compiles ok, no message error but the update doesn't take place?

String sql1 = "UPDATE provider set company_name='" + company_name + "', contact_name='" + contact_name + "', address='" + address + "', address2='" + address2 + "', city='" + city + "', pcode='" + pcode + "', country='" + country + "', phone='" + phone + "', fax='" + fax + "', email='" + email + "', website='" + website + "', account_no='" + account_no + "', reference='" + reference + "' where provider_id=" + val;
out.print(sql1 + &quot;<br>&quot;
st.executeUpdate(sql1);


<input type=&quot;text&quot; size=&quot;40&quot; class=&quot;text-box&quot; name=&quot;company_name&quot; value=&quot;<%= company_name %>&quot;>

Cheers
Vero

 

[venur]

Hi,

Can you copy the output of sql1 and run it from the MySQL command prompt ?

If not copy and paste the out put of sql1.

Cheers,
Venu

 

[sensory21]

Yes, I've just done that and the record has updated without problem, in the cmd I added contact_name='vero' and that was fine!
This is the output of sql1

UPDATE provider set company_name='Edgars Cool Water', contact_name='', address='New Wharf', address2='Brighton Road', city='Shoreham-by-Sea - West Sussex', pcode='BN43 6RN', country='UK', phone='01273 701618', fax='01273 888338', email='', website='

http://www.edgarscoolwater.co.uk',

account_no='SENS0004', reference='' where provider_id=132

vero