Hi all,
Can somebody please help me with the following problem?
When I use queries in a JavaBean, using JDBC classes and interfaces, to
get data from the database, there is no problem. However, now I want to
use a variable in a subquery of a query, e.g. in the query I mentioned
below I want to replace "Voorstellingcode = 1" by "Voorstellingcode =
var".
What is the syntax of that??
("SELECT Count(Stoel.Rijnummer) AS cinr FROM Stoel GROUP BY
Stoel.Rijnummer, Stoel.Zaalcode HAVING Stoel.Zaalcode IN (SELECT
Zaalcode FROM Voorstelling WHERE Voorstellingcode = 1)");
Best regards,
Marcel van Kooy
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
