SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    May 2005
    Location
    Suwanee GA
    Posts
    118
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Set Rowcount sticking to all queries

    Using Coldfusion cfquery with Sql Server 2005

    I have one query

    Code:
    cfquery name="myq" datasource="mydsn"
     set rowcount 5
     select ...etc...
    /cfquery
    cfoutput outputs all 5 records as expected.

    On another web page I omit the set rowcount 5 statement for a completely different query. But I get back only 5 results when I should get back about 20. Even different users/sessions are affected so it is possibly impacting a global variable.

    Is there a setting on SQL SERVER or ColdFusion that causes this error? The set rowcount seems to affect every query after the first one is run until it meets a set rowcount 0 statement.

    I do not have this problem on sybase database so I am thinking possibly SQL SERVER issue.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,021
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    from your description, i'd say you've figured it out

    i checked BOL but all it says is that SET statements take effect for the current session

    maybe the coldfusion interface is a single session as seen from sql server

    by the way, BOL also says you should be using TOP in the SELECT statement rather than setting the rowcount
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •