concatenate 2 queries

[sensory21]

Hi,

I've got a first query:
ResultSet r = s.executeQuery ("SELECT COUNT(*) AS rowcount FROM customer"

further down, I'd like to add another part of the query, how do I write this? I've tried that but it doesn't work:
req = r.(" LIMIT page_start, per_page"

Thanks
Vero

 

[sedj]

It doesn't really work like that. A ResultSet is linked to a certain sql query. So what you are saying is "perform a query, but then at some later arbitrary time, perform it again but with another clause".

So if you need to limit a query, then you need to execute that]query :

ResultSet r = s.executeQuery ("SELECT COUNT(*) AS rowcount FROM customer LIMIT 1"

 

[sensory21]

Hi,

can someone tell me how to change this:
<a href=\&quot;customer.jsp?nopage=&quot; + i + &quot;\&quot;>&quot; + i + &quot;</a>

to reload the same page?
I've tried target=_self but what to put instead of customer.jsp please?

Cheers
Vero

ps: Thanks Sedj for your reply earlier, finally I've used the PreparedStatement, glad to know how to use it now! x

 

[venur]

Hi,

Try this.. if you are calling the same page in URL

String uri = request.getRequestURI();

out.println(&quot;<a href=\&quot;&quot;+ uri +&quot;?nopage=&quot; + i + &quot;\&quot;>&quot; + i + &quot;</a>&quot;

Cheers,
Venu