Hi Oleg and Malini,
Thanx for your solutions. I tried them and it is working now.
Best regards,
Marcel
> Monday, August 07, 2000, 1:59:18 AM, you wrote:
>
> MvK> When I use queries in a JavaBean, using JDBC classes and
> interfaces, to
> MvK> get data from the database, there is no problem. However, now I
> want to
> MvK> use a variable in a subquery of a query, e.g. in the query I
> mentioned
> MvK> below I want to replace "Voorstellingcode = 1" by
> "Voorstellingcode =
> MvK> var".
> MvK> What is the syntax of that??
>
> MvK> ("SELECT Count(Stoel.Rijnummer) AS cinr FROM Stoel GROUP BY
> MvK> Stoel.Rijnummer, Stoel.Zaalcode HAVING Stoel.Zaalcode IN (SELECT
> MvK> Zaalcode FROM Voorstelling WHERE Voorstellingcode = 1)");
>
>
===========================================================================
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
