Loading ...
Sorry, an error occurred while loading the content.

RE: [wmlprogramming] c2c wap portal help needed

Expand Messages
  • Soni, Sanjay
    Hi Samir, To fetch next or previous 10 records, u have to generate dynamic query on the basis of last or first record of previous query respectively. -SanjayS
    Message 1 of 3 , Feb 28, 2001
    • 0 Attachment
      Hi Samir,
      To fetch next or previous 10 records, u have to generate dynamic
      query on the basis of last or first record of previous query respectively.


      -SanjayS


      -----Original Message-----
      From: Mokarrabin A Rahman [SMTP:mokarrabin@...]
      Sent: Wednesday, February 28, 2001 9:29 PM
      To: wmlprogramming@yahoogroups.com
      Subject: [wmlprogramming] c2c wap portal help needed

      Hello Pravin & All,

      I have fixed up the wap simulator at www.mineed.com . It looks great
      but
      still there is a long way to go.
      Well. I was not thinking about STP but I will give it try . But I
      tried this
      SQL stmt : 'Select TOP 10' where ten is the number of rows to get.
      It
      worked fine but then the problem arised. It fetched the top ten
      similar
      records. For example if I said 'group by date' then it fetched all
      the
      records from last ten days , which can become even thousands ! I
      just dont
      know how to stop after the first ten.

      Pravin can you please give me an idea about the three level query
      that you
      mentioned.

      Regards,
      Samir. < Dhaka >


      > -----Original Message-----
      >
      > Hello Sameer,
      > I just thought of the query. It can be possible with 3
      level
      > query
      > in Oracle and in SQL I am not sure, but in single query I think it
      is
      > not
      > possible. Or we can use a stored procedure where the first stmt
      will be
      > "set
      > rowcount=N"
      >
      > Regards,
      >
      >
      >



      Please read the FAQ before you ask questions:
      http://www.allnetdevices.com/faq/

      Visit http://groups.yahoo.com/group/wmlprogramming for archive and
      subscription options

      Your use of Yahoo! Groups is subject to
      http://docs.yahoo.com/info/terms/



      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.