Re: Jet Provider limitations?

From: Jay (jay_NOSPAM_zelos.org.uk)
Date: 02/23/04

  • Next message: Tabitbol: "how to reset the cursor after running an SQL statement with Do Until" 
    Date: Mon, 23 Feb 2004 14:56:05 -0800

    Its always the way, 5 minutes after writing a problem you find the answer, and its always so simple :).

    I was getting OLE erros when calling by UNION query from an ASP page, the problem was in the query itself. Although it worked fine in Access, using this:

    SELECT Fixture_ID, LeagueTeams_ID, League, Team, AwayTeam As OtherTeam, AwayScore As OtherScore,HomeScore As TeamScore, dtDate, Notes, CupRound, Result, Points, "H" As HorA FROM FixturesHome
    UNION SELECT Fixture_ID,LeagueTeams_ID, League, Team, HomeTeam As OtherTeam, HomeScore As OtherScore, AwayScore As TeamScore, dtDate, Notes, CupRound, Result, Points, "A" As HorA FROM FixturesAway;

    gave an "Expected 2 parameters" error. The problem was the "A" As HorA line and its equiv. Once I'd removed them it worked fine, not sure why this throws up an error but I can live without it (for now).

    Jay

  • Next message: Tabitbol: "how to reset the cursor after running an SQL statement with Do Until"