how to inner join multiple fields.
I have 1 table SCHEMA1 wich contains:
id|wedstrijd|speler1|speler2|speler3|speler4
1 1 1 2 3 4
2 2 2 1 4 3
The other table SPELERS contains
id|speler|naam
1 1 Jan
2 2 Piet
3 3 Klaas
4 4 Henk
I would like to have te next result:
wedstrijd|speler1|speler2|speler3|speler4
1 jan piet klaas henk
2 piet jan henk klaas
Can anybody help, because i'm lost......?
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
I need to set up my front end app to update multiple fields with the same entry. See below.
Database: Testing
Columns:
Recdte
Invdte
So in this case, the user would need to update the Invdte with the current date for all rows where the Recdte is a given value. I know how to do this in SQL but not in ASP.
Is it possible to do an update on a recordset like this?display all the fields in a form and let the user pick which ones to update? What happens if they pick, say, two of the total to update, and leave the rest of the form fields blank? Would that update the chosen records and leave the rest of them blank or null?
View Replies View Relatedhow do i add afew items into a database of only a field name?
for example if there is only item_1.. it will add item_1 only. but if there is item_1 & item_2. how do i add them to the database name ("Items No")?
I have 4 number fields in the same table and need to display the lowest number from all 4 fields, is this possible?
View Replies View RelatedI have 4 tables first table category (category_id and category name in it)
second table artist (artist_id, category_id, artistname in it)
third table album (id, artist_id, album_title in it)
forth table song (id, album_id, title in it)
I'm selecting category in first page
I'm selecting artist in second page
I'm selecting album in third page
I'm requesting, collecting and posting all id's to the next page.
this is the question!!
How can I read from database
1- category name when I was selected in first page
2- artist name when I was selected in second page
3- album name when I was selected in third page
I've got 4 records in my lovely database table. The table contains 5 fields, lets say: id, number, name, age and sex. All I want to do is to get all the values (form all 4 records) of the "number" field and put all 4 of the values in to one variable.
The output have to look something like this : numbers: 001, 002, 003, 004.
I tired, honestly, I really did. But didn't find a solution.
How to create multiple text fields and will be submit when press a "enter key" ...
View Replies View RelatedIs there any way that I can break up text in a text field to spread across multiple fields in an access database? I've got a FAQ section that I want admins to be able to edit via an online interface. Unfortunately, it often doesn't fit into the 255 character restriction that access has. Any ideas?
View Replies View RelatedI'm having trouble passing hidden fields between forms. I have a total of four forms. I have the 1st form passing its field to the 2nd form, and the 2nd form passing its field to the 3rd form, but the 1st form's field then is not passed into the 3rd form. So obviously, my summary form (the 4th form) is not getting the 1st form's field or the 2nd form's field, only the 3rd form's field. Code:
View Replies View RelatedI have multiple fields (BLM, WHM, RNG, MNK) each with a numeric value. How can I search across these fields for each record and find the highest number.
Example:
Name BLM WHM RNG MNK
----------------------------------
Jason 19 52 33 18
What I want it to do is return and display Jason WHM 52
And I want to do this for every record in the table.
I am using this script to submit my form fields into the body of my email:
***********************************************
Dim strBody
dim ix, formElementName, formElementValue
strBody = "Results of form submitted at " & Now() & vbCrLf & CrLf
For ix = 1 to Request.Form.Count
formElementName = Request.Form.Key(ix)
formElementValue = Request.Form.Item(ix)
strBody = strBody & (formElementName & ": " & formElementValue & vbCrLf)
Next
***********************************************
I'm completely new to vbscript and have been searching all over the net for an example of this script being used with mutliple fields with absolutely no luck.
The closest I've come to getting something back from this thing is when I tested the script with these elements:
FormElementName = Request.Form.Key("Name")
formElementValue = Request.Form.Item("Name")
formElementName = Request.Form.Key("Telephone")
formElementValue = Request.Form.Item("Telephone")
formElementName = Request.Form.Key("Email")
formElementValue = Request.Form.Item("Email")
Which produced this result:
Email: Email
Email: Email
Email: Email
Its seems the answer to my problem lies in defining the 'Key' and possibly the 'Item' parameters but I haven't been able to find any documentation on these terms. Can someone out there please save me from what probably is a very simple solution?
I have a form on one page where someone selects a bunch of options and details about a specific category. Then on the next page they fill out a form with contact information, name, address, email, etc.
Well what I want to know is when they click Submit on that contact form is there a way to have it so it goes through and searches the database for any that match the state and county(which they will select from a )??
So what I basically want right now is for the first form to be filled out, then the second form to be filled out, then when they are submitted it will go through the database and select everyone in there with that state and county, then on the next page display the results of both forms AND the matches in the db(obviously whatever fields I want it to display).
I already have both forms(basic html), I already have the dynamic dropdown for state and county(classic asp), what Im wondering is how do I put that dynamic dropdown in the contact form and then when submitted it will go through and search the db based on what was selected there. Would this be some sort of onClick for the submit button tellin it to search the db based on the dropdown or how would I get started on something like this?
There will be other information on the dropdown like name address email so one problem I was wondering about was my dropdown menu. When you select the state it refreshes the page and then loads the counties, so wouldnt that erase anything that was filled out on the form?
I could make it so they actually type the name of their state and county but that causes problems too because if they mispell either then it wont return any results.
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 have three tables in the DB MySQL:
TABLE_V = id, codebar, description
TABLE_C = id, codeplu, description
TABLE_M = id, internalcode, description
In the tables TABLE_V and TABLE_M for each record the descriptions are the same, Is different in the table TABLE_C.
Relations in the tables:
TABLE_V.CODEBAR ===> TABLE_C.CODEPLU
TABLE_V.DESCRIPTION ===> TABLE_M.DESCRIPTION
TABLE_C.CODEPLU ===> TABLE_M.INTERNALCODE
I must query INNER JOIN into three tables to extract CODES and corresponding DESCRIPTIONS, its possible ?
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 need to insert simple SQL Queries (joins) in an ASP page.
Select Count (*) from
Fileindexqueue Q,
Domains D,
Files F
Where D.ID = Q.DOMAINID
and Q.FILEID = F.ID
and D.NAME = 'GAINS_GTN'
My ASP code where queries can be inserted looks somewhat like this:
strSQL = "SELECT COUNT(*) AS COUNTOF FROM FILEINDEXQUEUE where (SERVERFLAG = 'Failed')"
objRec.Open strSQL, objConn, adOpenForwardOnly, adLockReadOnly, adCmdText
Response.Write "<P Class=""clsMono"">Files Failed   : <b>" & objRec("COUNTOF") & "</b>"
objRec.Close ...
in this code, Code:
strSql = "SELECT tblClippings.fldClippingID, tblTopics.fldTopicName, tblMessages.fldMessageID, tblMessages.fldMessageTitle, tblMessages.fldMessageCreated, tblPeople.fldPersonDisplayName, tblMessages.fldTopicID FROM tblTopics.fldTopicID INNER JOIN (tblPeople INNER JOIN (tblClippings INNER JOIN tblMessages tblClippings.fldB_MessageID = tblMessages.fldMessageID) ON tblPeople.fldMemberID = tblMessages.fldPersonID) ON tblTopics.fldTopicID = tblMessages.fldTopicID WHERE (tblClippings.fldB_MemberID=" & iPersonID & ")"
after the FROM statement, I am getting confused. It gives error message. I think the problem is just about here,
FROM tblTopics.fldTopicID INNER JOIN (tblPeople INNER JOIN (tblClippings INNER JOIN tblMessages tblClippings.fldB_MessageID =
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)
<!--#Include Virtual="/bug/adovbs.inc"-->
<title>Bug Status Board</title>
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog =
techsupportBT; User Id = sa; Password="
Set rs = server.CreateObject("ADODB.Recordset")
sSQL="SELECT T.BugIndex, T.[Date Entered], T.DESCRIPTION,"
sSQL= ssql &" T.Company, T.Technician, T.Developer, T.PROGRAM, "
sSQL= ssql &" T.Status, T.PRIORITY, T.[Version Fix], n.noc"
sSQL= ssql &"FROM TSHIGHISSUES INNER JOIN noc ON T.BugIndex =
n.bugindex "
set rs=conn.Execute(ssql)
and this is the error message that I get Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'INNER'
I cannot find an example anywhere that helps with this situation. This works fine in SQL, but for some reason asp is being a pain.
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 was just wondering if it is possible to join more than one table with sql.
I am currently joining the tables care, and images with inner join;Code:
cnnSimple.Execute("SELECT * FROM [care] INNER JOIN [images] ON care.english = images.english WHERE care.english = 'whatever' ")
I have a third table, 'video' that i would also like to join(at video.english) and display on the page.
How can i insert a data using a join statement
insert into partmaster.p, execmaster.e(e.execno, e.model, e.battqty, p.partno, p.parttype, p.itemtype, p.stacklength, p.line, p.execno)
values('1234567890', 'GBM', '2', '9876543210', 'AR', 'M', '29V', '2', '1234567890')
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
I've got three tables:
tblEvent
--------
Id (PK) | Event_Name
tblDelegate
--------
Id (PK) | Delegate_Name
tblBooking
--------
Id (PK) | Event_Id (FK) | Delegate_Id (FK)
I need to retrieve a recordset with the following information:
Booking Id | Event_Name | Delegate_Name
Can anyone see how to do a SELECT statement to do this?
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:
Tables spec:
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='.
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
What am I doing wrong in this statement?
SELECT * FROM hebbooktable INNER JOIN hebrewbibletable ON hebbooktable.book = hebrewbibletable.book WHERE text_data LIKE '%bra%' ORDER BY id ASC
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
how do i do this?
View Replies View Related