Re: Multiple results by a single prepared statement..

From: Roedy Green (look-on_at_mindprod.com.invalid)
Date: 06/15/04

  • Next message: Franz-Josef Hoennekes: "Re: ODBC access" 
    Date: Tue, 15 Jun 2004 07:02:06 GMT

    On Tue, 15 Jun 2004 02:53:08 -0400, "Raquel" <raquel@nospam.com> wrote
    or quoted :

    >"Some prepared statements return multiple results;"

    I could see two interpretations:

    1. you get multiple rows back.

    2. you ran reuse the PreparedStatement for another query.

    I don't see how you could get multiple ResultSets literally back from
    the same query since the method signature does not allow for it. 

    -- 
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming. 
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.
  • Next message: Franz-Josef Hoennekes: "Re: ODBC access"

    Relevant Pages

    • Re: Escape character weirdness
      ... The problem of course is that you can't return brackets from the ... Sql Server uses brackets '' to escape. ... I tried a 'LIKE ' query, ... PreparedStatement p = c.prepareStatement("insert into #foo ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: Establishing Precedence In ORDERBY Condition Causing Problems.
      ... this query is likely to return multiple rows. ... Since @sort is NULL at this point, ... since your original query had some 7-8 tables whereof several repeated ... by commenting out the following code, ...
      (comp.databases.ms-sqlserver)
    • Re: Establishing Precedence In ORDERBY Condition Causing Problems.
      ... this query is likely to return multiple rows. ... Since @sort is NULL at this point, ... since your original query had some 7-8 tables whereof several repeated ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
      (comp.databases.ms-sqlserver)
    • Re: Limit records by date difference
      ... I 've done what you outlined and this is what I get when I run the query. ... you can see below I am getting multiple rows. ... Same thing with John I want to ... Since you're applying a criterion to a field from the second table, ...
      (microsoft.public.access.queries)
    • Re: Getting query SQL from a JDBC PreparedStatement
      ... I want to get the SQL query text from ... a PreparedStatement (which is a SybPreparedStatement in this ... connection when asking for a PreparedStatement. ...
      (comp.lang.java.databases)