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

Posted By:   Charlotte_Endresen
Posted On:   Tuesday, April 3, 2001 06:24 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

Re: UPDATE PROBLEM IN JSP

Posted By:   Pankaj_Modi  
Posted On:   Wednesday, April 4, 2001 03:36 AM

Try storing the request.getParameters() in string variables and then use those variables in composing your SQL statement.

If that does not work then send me the code and I will do that for you.


E-Mail - pankajmodi@caltiger.com
About | Sitemap | Contact