Search results for query: *

I am Selecting all of the rows from a main table (cms_WhatsHot) along with related rows from other tables (cms_Segments and cms_SegmentsParents) all joined using Inner join. The main table (cms_WhatsHot) will always have rows, the joined tables may have no related rows. The result is that if a...

Hi I have, what has turned out to be a bit of a monster stored proc. The idea behind it was so that I have just one proc that can handle many different types on my table of contacts. This table links to various other 'relationship' tables such as ContactsToDirectories, ContactsToMaillists. So...

Hi I hope the title explained the problem accurately. I didn't quite know the best way to describe the problem. Basically, I am retrieving data from my contacts table using a stored procedure. The procedure is passed one parameter - '@directoryID'. For each record returned to my ASP.Net app...

Hi Im would like to know if its possible to create an auto number field to a query so that no matter what your query returns, you'll always have a column starting at 1 and incrementing up for each record. Example Query: Select Top 10 TeamScore From tblTeams Order By TeamScore How would I add...

<script runat="server"> Public objConn as new OleDbConnection (System.Configuration.ConfigurationSettings.AppSettings("ConnectionString")) Sub GetTeam(s as Object, E as EventArgs) Dim objCmd As New OleDbCommand("SELECT TOP 4 PlayerID FROM tblPlayers WHERE PositionID='defender' ORDER BY...

Hi, I am trying to fill a DataGrid with random records from my database. It thought I had found a way to randomly select records using SQL. So I built a stored procedure in Access and sure enough, it returns a random set of records and works exactly how I need it to. But... Whe I tried to call...

Hi I have the following query: SELECT ft.FantasyTeamID, ft.TeamName, fp.FantasyTeamPlayerID, p.PlayerName, p.PositionID FROM tblFantasyTeams AS ft, tblFantasyTeamPlayers AS fp, tblPlayers AS p, tblGoals as g WHERE p.PlayerID = fp.PlayerID AND fp.FantasyTeamID = ft.FantasyTeamID AND...

Hi I'm hoping someone could give me a hand with what seems to be an impossible task. I have a table of website hits. Each record contains the following: HitID CreationDate IPAddress DevelopmentID All are self explainatory apart from DevelopmentID. Basically, the site is a portal that leads...

Hi Is it possible to target a variable, whose name you create from the content of other variables? Please stay with me on this one as I'm getting little feedback from the ASP.NET world. I'm assuming I'm not explaining it well enough. Example: I have some variables, for arguments sake lets call...

Hi Before I start, this is the structure of my table, tblStatsSessions. SessionID (primary key, auto number) CreationDate (DateTime) DevelopmentID (Number) The purpose of the function below(a stored procedure in Access) is to return a Count of SessionID's for the past 7 days and group them...

Hi I'm getting confused with my joins in this query. I have a table holding: viewID SessionID developmentID There will be multiple viewID's for every developmentID and SessionID. How can I count the number of different sessionID's for a specific DevelopmentID? I am using the following, but...

Hi, does anyone know the limit to the number of records an Access table can hold? And at what point efficiency goes out the window? I'm currently logging page views in a table and wondering if this is wise / the best way to do it?? Cheers Shaun

I have a query that works fine: SELECT tblPFTopics.DevelopmentID, Count(*) as TotalDev FROM tblPFEntries, tblPFTopics, tblPFThreads WHERE tblPFTopics.TopicID =tblPFThreads.TopicID AND tblPFThreads.ThreadID=tblPFEntries.ThreadID Group By tblPFTopics.DevelopmentID Until I add: AND...

Hi This is what I'm trying to do: Select Name From tblDevelopments Where DevelopmentID = Max( SELECT tblPFTopics.DevelopmentID, Count(*) as TotalDev FROM tblPFEntries, tblPFTopics, tblPFThreads WHERE tblPFTopics.TopicID =tblPFThreads.TopicID AND tblPFThreads.ThreadID=tblPFEntries.ThreadID...

Hi Here is the structure of my tblSessions: SessionID (auto number) DevelopmentID (number) CreationDate (DateTime) Is there a query that would count all of the sessions for each development and return the DevelopmentID that has the highest number of Sessions. Similarly, I would like to be...

Hi I have a table of PDF Files that can be downloaded from the server. I have a field named downloads that will store the number of times the file is downloaded. At the moment, I retreive the value of downloads, increment it within my web page and insert the new value back into the database...

Hi What is the correct way to compare a new record with the one before it. Basically, I have a table that stores web page names. Before adding another page name to the table, I want to check that the last one entered isn't the same page. If it is, the page name doesn't get entered again. Is...

Hi I have a simple search field in my form. I am trying to use it to search for a string within my 'Keywords' column. I am using this at the moment: SELECT DevelopmentID, Name, Town FROM tblDevelopments WHERE Keywords Like %@Keyword%' AND Live=Yes ORDER BY Name; but it return nothing and...

Hi Does anyone know why I'm getting the following error with the Query below? Syntax Error (Missing Operator) in query expression 'e ON e.ThreadID=t.ThreadID INNER JOIN tblUsers AS u ON u.UserID=t.CreatorID' The query is: SELECT t.ThreadID,t.Thread, t.CreationDate...

Hi Can anyone tell me why the Query below receives the following error? Syntax Error (Missing Operator) in query expression 'e ON e.ThreadID=t.ThreadID INNER JOIN tblUsers AS u ON u.UserID=t.CreatorID' The query is: SELECT t.ThreadID,t.Thread, t.CreationDate, count(e.EntryID),u.Username...