First Table Player
tbl_player (fld_id, fld_dor, fld_tname, fld_tpass, fld_name, fld_email, fld_mobile)
Second Table Attempt
tbl_attempt (fld_attempt_id, fld_dop, fld_tname, fld_pid, fld_pscore)
Relation of First Table with Second Table is fld_tname and fld_pid of tbl_attempt with fld_id of tbl_player
Basically this is a 2-player game in which tbl_player contains both player a and player b details (they are identified by same Team Name). Table Attempt (tbl_attempt) holds individual scores which again can be grouped as a team score by the field fld_tname. Code:
I have a table in my DB called members. In that table, I have 2 tables I will be using "username" and "points"
Now, I also have a table called all_matches. This table contains every match report. Over 25,000 of them. I have a "username" field an "outcome" field an "username1" field and "extra_match" field.
What I need to do, is make a query that takes the username from table "members" and find :
using the "username" field in the members table, i need to obtain stats that give me the following. Code:
strSQL = "SELECT x.CountryId, x.CountryName, y.SiteId, y.SiteName, z.LocationId, z.Level FROM TableCountry AS x" strSQL = strSQL & " INNER JOIN TableSite AS y ON (x.CountryId = y.CountryId)" strSQL = strSQL & " INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)"
Error Type:
Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression '(x.CountryId = y.CountryId) INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)'. /system1.asp, line 21
I have a MSAccess 2000 mdb where 2 tables must be connected with a fieldname "book_spoke". This is what I have so far. Is it right? The purpose is to find within the search result all the book_spoke s and link with the proper url for each book_spoke. Code:
I have an access database called employment.mdb The fields that I have in this database are:
Company, Location, Dates, Position, Signing, and Duties.
The problem I am having, I can go in and create a Drop Down pulling information from the Company field, but I can not get the information from the rest of the fields to populate. I want the Database column values to change when I select a different company. I will be honest, my only experience with it has been thru Frontpage, I can go in and create a drop down, but get errors if I try to add other database connections into that query. I have enough experience at working with html, but not the asp side of it. I would really appreciate some help with this.
I have a question about JOIN'ed table in Access. I have 2 tables in my database with one being tbl_Events and the other tbl_VolunteerSchedule. tbl_Events contains information regarding upcoming Events. tbl_VolunteerSchedule contains the names of Volunteers plus information from tbl_Events pertaining to the event the volunteer is volunteering for.
What I need is for tbl_Volunteer to Update when I make changes to the Events in tbl_Events. I thought that it was working correctly when I used a LEFT JOIN. However if I make updates to tbl_Events it adding additional record to tbl_Volunteer. It should only Update tbl_VolunteerSchedule when the fields EventID match. Does this make sense? Code:
'Initialise the strSQL variable with an SQL statement to query the database strSQL = "SELECT [firstname], [lastname], [homepage], [aim], [location], [interests], [email] FROM tblUsers WHERE ID =" & userID
need to use session variable but need to select records form another table based on the logged in user (session variable) Code:
i have this code that join 2 tables, Reservation and Customer. Next, i wanted to add another table, Staf to get the name of staf that responsibled on a particular reservation. there is a field name staffCode (FK at Reservation table, PK at Staf table) at the Reservation table. Code:
SELECT DISTINCT dbo.logon.DRIVER_NO, dbo.booking_form.DriverNo FROM ((dbo.logon RIGHT JOIN dbo.Employees ON dbo.logon.DRIVER_NO = dbo.Employees.DriverNo) ) LEFT JOIN dbo.booking_form ON dbo.logon.DRIVER_NO = dbo.booking_form.DriverNo
problem is it produces more than 1 result for the driver from the booking_form table. If a Driver is logged in then I need to show information from the booking_form table for that driver but it produces row after row of data. Have tried all combinations of JOIN but to no avail. Code:
I need to basically transfer an existing site to my personal pc, when i copy everything to my wwwroot folder then preview it, I get errors such as:
-- Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified -- Microsoft VBScript runtime (0x800A01A8) Object required -- Microsoft VBScript runtime (0x800A000D) Type mismatch: '[string: ""]' -- Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. --
I know the site uses mysql, I've transfered every database/table/data to my localhost database.
One thing I don't understand is the ODBC (DSN) setup. The cpanel on the site lists 4 data sources with databases, I can't seem to find the mdb databases in the directory specified in the ODBC info panel (perhaps the mdb files are linked with mysql?)
I have a system that works on line without any problems. Problem is i need something in place that blends on line information with offline. i want to do something similar to the following if it is possible.User saves to an offline database using a dsn-less connection When the user goes on the web site, they have the option to upload their database contents.
It then copies the information from the offline version of the database to the online version of the database.Then it deletes the information off the offline version, (to prevent same information being uploaded, probably use sql to do this)The user also has the option to download a zipped copy of the main database so they are up-to-dateIs this possible?
I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
I am trying to create a record set using data from two tables. I am using the following code- Dim objRS oracleConnection.CommandText = "SELECT CONTACT.CONT_FNAME, LOGIN.LOGN_USER_EMAIL " &_ "FROM CONTACT INNER JOIN LOGIN ON CONTACT.LOGN_ID= LOGIN.LOGN_ID WHERE CONTACT.CONT_ID LIKE 3" oracleConnection.CommandType = adCmdText Set objRS = oracleConnection.Execute
Set oracleConnection = Nothing
While Not objRS.EOF Response.Write objRS("CONT_FNAME") & " " & objRS("LOGN_USER_EMAIL") objRS.MoveNext Wend
I am getting an error at the line Set objRS = oracleConnection.Execute The error is SQL command not properly ended
I can't seem to get the syntax right for an inner join statement, its based on one main table and two linked tables,
From Employee inner join((Department ON Employee.Department_Code=Department.Department_Cod e) Location ON Employee.Location_Code=Location.Location_Code)
or something to that effect. Employee is the main table and Dept,Location contain all dept/location codes+descriptions.I'm sure its pretty simple just can't get it right.
I have 2 tables I want use join to use their data its working but it will return twice of each record.
this:
strSQL = "SELECT Foods.*,SeFoods.* From Foods INNER JOIN SeFoods ON Foods.food_id = SeFoods.food_id WHERE SeFoods.type = 1 ORDER BY seFoods.sf_id DESC;" .....
I am in the process of creating an ASP application to read a SQL Database. I have imported the database from an Access Database. The Database holds Client details, such as Agent Name, Address, Telephone. etc. in a table called Client Code:
I have been racking my brain with this and I just can't seem to figure it out. Here is what I am trying to do. I have 3 tables named Registration, Events, and Customer.
I want to produce a page that lists all events and the number of attendees and who is attending each event. I assume that the only way to do this is by using an inner join and I am having a hard time grasping it.
My registration page has three fields (customernumber,eventid,eventdate) My events page has five fields (eventid,eventdate,place,description,numberofattendees) and my customer table has three fields that I need to use (firstname,middlename,lastname,customernumber)
I'm trying to select all the records from a table (usergames) based on the username. I want to then display all the records based on the title of the pin which is my inner join statement. Can I do this or is it easier to just have another sql statement?
sql = "SELECT usergames.pin AS gamecount, searchtable.title FROM usergames INNER JOIN searchtable ON usergames.pin = searchtable.pin WHERE usergames.username = '"&username&"' ORDER BY searchtable.title DESC"
Basically I'm trying to combine an SQL inner join with a delete statement, like:Code:
var cnn = Server.CreateObject('ADODB.Connection'); cnn.Open(Application('cnn')); cnn.Execute('delete * from editors_sections inner join editors on editors_sections.editor_id = editors.editor_id where editor_id='+intEditorId+' and editor.isSectionOne=0 or editor.isSectionTwo=0 or editor.isSectionThree=0'); cnn.Close(); But it gives me the following error:
Incorrect syntax near '*'.
Can this be done, and if so, can anyone see where I'm going wrong (I'm using JScript if that makes any difference?)
i have a few input box for the user to enter. but as u can see that both tables has execno. it's for both tables to connect. that's why i want to check on how i can key in one input box insert into execno in two different tables
drop1 - autonumber drop2 - autonumber drop1id in drop2 - number
strsql = "SELECT drop2.drop2id, drop2.drop2, drop2.drop1id" strsql = strsql & " FROM drop2 INNER JOIN drop1 ON drop1.drop1ID = drop2.drop1id where drop2.drop1id = " & drop1id
error msg:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'drop2.drop1id='.
I am using the sql query below, the problem I am having is that is selects every record with the HomeTeamID 1 upwards. I want it to still do this but not to ignore the records with the HomeTeamID of 0. How can I do this? Code:
<% ID = Request.QueryString("ID")
Dim rsHomeT SET rsHomeT = Server.CreateObject("ADODB.Recordset") rsHomeT.Open "SELECT * FROM Fixtures INNER JOIN Teams ON Fixtures.HomeTeamID = Teams.TeamID WHERE Fixtures.LeagueID = " & ID & " ORDER BY iYear, iMonth, iDay ;", objConn %>
