UPDATE PROBLEM IN JSP
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Charlotte_Endresen
Posted On:   Tuesday, April 3, 2001 06:20 AM

Seems to be some problems with parentheses. There are to few of them, dont know where to put them. stmt.executeUpdate("UPDATE kunde SET KFORNAVN=('"+request.getParameter("Fornavn") +"', KMellomnavn = '"+request.getParameter("Mellomnavn")+"', KETTERNAVN = '"+request.getParameter("EtterNavn") +"', KADRESSE = '"+request.getParameter("Adresse")+"', KTLF ='"+request.getParameter("Tlf") +"', KMOB_TLF = '"+request.getParameter("Mob") +"', K_EPOST = '"+request.getParameter("Epost")+"', POSTNR = '"+request.getParameter("Postnr") +"', AKTIV = '"+ "" + "   More>>

Seems to be some problems with parentheses. There are to few of them, dont know where to put them. stmt.executeUpdate("UPDATE kunde SET KFORNAVN=('"+request.getParameter("Fornavn")
+"', KMellomnavn = '"+request.getParameter("Mellomnavn")+"', KETTERNAVN = '"+request.getParameter("EtterNavn")
+"', KADRESSE = '"+request.getParameter("Adresse")+"', KTLF ='"+request.getParameter("Tlf")
+"', KMOB_TLF = '"+request.getParameter("Mob")
+"', K_EPOST = '"+request.getParameter("Epost")+"', POSTNR = '"+request.getParameter("Postnr")
+"', AKTIV = '"+ "" + "'" + "' WHERE KNR = ('"+request.getParameter("KNR" )+"')"); Thank you

   <<Less
About | Sitemap | Contact