K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP
I have tried many different ways to get my sql query work but its not working
kvaughan is the value uid i am passing to query as paramater
It's for my practice as I am learning it.
]
String uid = request.getParameter("userid");
//out.println(uid);
String sql="select RLastName, RFirstName, RUserId, RDepartNo, REmail, Tarea from Awards where SUserId="+uid;
I am always surprised at the added knowledge i can get from others when i give my opinion on a topic.
String SLastName = request.getParameter("SLastName");
out.println("SLastName");
String SFirstName = request.getParameter("FirstName");
String SUserId = request.getParameter("SUserId");
String SDepartNo = request.getParameter("SDepartNo");
String RLastName = request.getParameter("RLastName");
String RFirstName = request.getParameter("RFirstName");
String RUserId = request.getParameter("RUserId");
String RDepartNo = request.getParameter("RDepartNo");
String REmail = request.getParameter("REmail");
String Tarea = request.getParameter("Tarea");
I am always surprised at the added knowledge i can get from others when i give my opinion on a topic.
I am always surprised at the added knowledge i can get from others when i give my opinion on a topic.
String sql = "DELETE FROM Awards"+"WHERE SUserID="+suserid+"and RUserId="+ruserid+"and SDepartNo="+sdeptno+"and RDepartNo="+rdeptno;
I am always surprised at the added knowledge i can get from others when i give my opinion on a topic.
"DELETE FROM Awards"+"WHERE SUserID="+suserid+" and RUserId="+ruserid+" and SDepartNo="+sdeptno+" and RDepartNo="+rdeptno;
I am always surprised at the added knowledge i can get from others when i give my opinion on a topic.
out.println(suserid);
out.println(sdeptno);
out.println(ruserid);
out.println(rdeptno);
out.println(slname);
out.println(sfname);
out.println(rlname);
out.println(rfname);
out.println(area);
out.println(remail);
I am always surprised at the added knowledge i can get from others when i give my opinion on a topic.
There are 10 kinds of people in this world. Those that understand binary get this tiny ad:
New web page for Paul's Rocket Mass Heaters movies
https://coderanch.com/t/785239/web-page-Paul-Rocket-Mass
|