Why does my random record query always bring back the same record ? (1 Viewer)

covcitydv · Dec 11, 2007

Any ideas ???

Cheers.

Code:

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="randomplayer.ascx.cs" Inherits="randomplayer" %>
<div class="control">
    <div class="controlTitle">
     Random Player 
    </div>
    <div class="controlContent">
        <asp:Repeater ID="Repeater4" runat="server" DataSourceID="AccessDataSource4">
            <ItemTemplate>
            <%# Eval ("playername") %>
            <br />
            <asp:Image ID="imgplayer" runat="server" ImageUrl='<%# Eval("picture") %>' Width=100px Height=100px ImageAlign=Middle/>
            <br />
            STATS
            </ItemTemplate>
        </asp:Repeater>
        <br />
        <a href="./playerprofile.htm">Player Profile</a>
    </div>
</div>
    <asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="~/App_Data/stfc.mdb"
    selectCommand="SELECT TOP 1 [playerID], [playername], [picture], [favouriteposition] FROM [player] WHERE [nolongeratclub] = false ORDER BY Rnd([playerID]);">
    </asp:AccessDataSource>

boblarson · Dec 11, 2007

RND has to be randomized or else it returns the same numbers in the same order each time (I know it's not intuitive about that one). See here for a way to initialize your RND using RANDOMIZE:

http://support.microsoft.com/default.aspx/kb/120587

covcitydv · Dec 11, 2007

Thanks, I'll have a play with that and let you know what happens.

EDIT : This is the code behind I have at the moment.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class randomplayer : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{

}
}

I'm not too sure how I'd integrate the code on that link you sent me. Especially as it is in visual basic.

Pardon my ignorance, Im still very new to all of this.

Why does my random record query always bring back the same record ? (1 Viewer)

covcitydv

New member

boblarson

Smeghead

covcitydv

New member

Similar threads

Users who are viewing this thread