Recent content by covcitydv
-
C
Why does my random record query always bring back the same record ?
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...- covcitydv
- Post #3
- Forum: ASP and ASP.NET
-
C
Why does my random record query always bring back the same record ?
Any ideas ??? Cheers. <%@ 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"...- covcitydv
- Thread
- Replies: 2
- Forum: ASP and ASP.NET
-
C
Count query as well as select query
The DCOUNT function ??? I'll have a look on google for it. Thanks. -
C
Count query as well as select query
Yes I am. Ideally it would look something like this ... -------------------------------------------------------------------------- [PLAYERNAME] [PLAYERPHOTO] Appearances Goals A (B) C... -
C
Count query as well as select query
Thanks for your help. So what you're saying is that the best way to approach this would be via a different SQL for the following. Total number of 'yes' for starts when season is '2007-08' Total number of 'yes' for subs when season is '2007-08' Total number of 'numbers' for goals when season is... -
C
Count query as well as select query
Hello All, I'm currently developing a football team website and I'm created a player profile bit of the website linking to my Access Database. Currently I have the following : selectCommand="SELECT [playername], [favouriteposition], [picture] FROM [player] WHERE [playername] ='Smith J' This...