Search results for query: *

Yes

Help!! I have an application whereby I want to play a MIAW which contains an Mpg file. When I create the MIAW normally it opens fin and plays but I want to get rid of the titlebar (Director MX not 2004), when I set the windowType = 2 the rest of the movie shows but not the mpg??? Anyone know...

S'OK... Cracked it!!!! SELECT mofc_fixres.ID, H.TeamName As HomeTeam, A.TeamName As AwayTeam, RefName FROM ((mofc_fixres INNER JOIN mofc_teams As H ON mofc_fixres.Team_ID = H.Team_ID) INNER JOIN mofc_teams As A ON mofc_fixres.Awayteam_ID = A.Team_ID) INNER JOIN mofc_ref ON...

Yes!! The second one works a treat... Now for my next dilemma, how to match up the Referee Number to the Referee_ID in the Ref table??? Here is the query so far: SELECT ID, H.TeamName As HomeTeam, A.TeamName As AwayTeam, Referee FROM (mofc_fixres INNER JOIN mofc_teams As H ON...

Hi I have created a recordset from two tables, teams and fixres. teams has team data (ID, name etc) fixres has two values one for each of the teams in the fixture (Hometeam_ID, Awayteam_ID). I have managed to join the two tables to match the ID with the team name, however I can only get one team...

That seems to have done the trick... Only now I can only retrieve either the hometeam name or the away team name (as when joined, both have the field name Teamname). Thanks anyway, will post this new problem in the sql section!

Its a little long winded... Its based around a football league website premise... I have a Teams table and a Fixtures table. The Teams table has Team_ID column for each team, the fixtures table has a Hometeam_ID column and an Awayteam_ID column. The problem I have is relating the Hometeam_ID...

I have a table with an autonumber primary key. What I want to do is automatically duplicate the value created in this field, in two other fields. Can I create an expression to do this?

I am creating an updatable Football league website: I have a table called Divisions with two columns: division_ID and Division, where Division is the label and division_ID is the value. I have another table called Teams with the division_ID value, how do I display the Division label on a page...

What I am attempting to do is create a list of files in a directory, which can be downloaded from a html page. SSI is enabled on the site, can anyone point me in the direction of a script that might do what I want? Thanks El

PH, thanks for the advice, have it working now! Hadnt made the column numeric! Doh! Taking off the inverted commas helped too, many thanks!!

Sorry, the full query is: SELECT * FROM ROOMS WHERE City LIKE '%varCity%' AND Rent <= 'varMax' taking away the inverted commas didnt help...

Hi I have a query that reads WHERE Rent <= 'varMax' Where varMax is a number entered by the user and Rent is the number in the database, when the user puts in a number with three figures, even though the database cointains an entry of 40, it returns no results, any idea why???