Member Avatar for mutawari

Dear all,

I have some table on my database.
i had input them via JSP and i view them on JSP too.
i use simple MySql queri in it to view the values of the Table.

But when i use another query like :

SELECT tabel_jawab.nis,
CASE WHEN (tabel_jawab.jwb1=tabel_kunci.Kjwb1) THEN '2,5' ELSE '0'
End AS Jawab1,
CASE WHEN (tabel_jawab.jwb2=tabel_kunci.Kjwb2) THEN '2,5' ELSE '0'
End AS Jawab2
FROM tabel_jawab,tabel_kunci WHERE tabel_jawab.kd_kunci=tabel_kunci.kd_kunci;

it successly compile but when it showed on the browser, it shows error massage.


Please tell me, what is in correct??


best regards,


Mutawari

  • 2 Contributors
  • 1 Reply
  • 64 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by javaAddict
Member Avatar for javaAddict

What error message and are you sure that the query is valid? Have you tried to run in at the MySql command prompt ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.