INNER JOIN IN ADO / ACCESS / ASP

[apple17]

I have a query that works in the Access database engine, however when I execute it as part of my ASP page, it only returns the FIRST location joined with each program_update.

SELECT Program_Updates.ProgramID, Program_Updates.Name,
Location.StartDate, Location.EndDate, Location.LocationName
FROM Program_Updates INNER JOIN Location
ON Program_Updates.ProgramID = Location.ProgramID
WHERE Location.EndDate >= #1/1/1900# and Location.StartDate <= #12/31/2010# AND Name LIKE '%%'

For data, I have 1 program with 3 locations and 1 program with 1 location. In Access I get 4 rows. In my ASP page, I get 2 rows, one for each location.

TIA!

 

[mwolf00]

Are you sure that you're recordset has only 2 rows? Can you post the code where you move through the recordset?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[DotNetGnat]

try removing the WHERE condition and see what results you get...i doubt about date limiters in your where clause going wrong...what is the data type of the date field in your database...

-DNG