Join Query DONT WORK

am using a join query below to get multiple results from different related tables to form one. e.g

SELECT DISTINCT dbo.e_Wallet.subscriptions, dbo.e_Wallet.username, dbo.e_Wallet.status, dbo.e_Wallet.suspension, dbo.ewalletx_yr_registratn.email, dbo.ewalletx_yr_registratn.Fiscal_Yr, dbo.ewalletx_yr_registratn.end_date, dbo.e_walletpurse.purse
FROM dbo.e_Wallet INNER JOIN dbo.ewalletx_yr_registratn ON dbo.e_Wallet.registrationID = dbo.ewalletx_yr_registratn.registrationID AND dbo.e_Wallet.email = dbo.ewalletx_yr_registratn.email LEFT OUTER JOIN dbo.e_walletpurse ON dbo.e_Wallet.email = dbo.e_walletpurse.email AND dbo.e_Wallet.registrationID = dbo.e_walletpurse.regID
WHERE username = 'variable'

however it dosent seem to work or show any results on my asp page. What is wrong here ?

View Replies


ADVERTISEMENT

I Cannot Get This Inner Join To Work In Asp

<!--#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.

View Replies View Related

SQL JOIN QUERY ISSUE

having problem with query below

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:

View Replies View Related

Join Two Tables In This Complicated Query

I've two tables:

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:

View Replies View Related

Dont Download A File

i have a file *.num and when i enter the full URL to download it he give my
a 404 error !

but when i rename the *.NUM by *.TXT everything coming ok !?
so how i can tell to IIS6 to accept *.num files ?

View Replies View Related

Dont Do If Recordset Is Empty

Below is code to display in a drop down menu some addresses. There is two things i need to do. One is to not show if there are no records but also there could be duplicate records, How do i stop duplicates occuring...

View Replies View Related

Html Email DONT Support

I dont have CDONTS support. i am using the following script. with this, even yahoo doesn't consider the email to be HTML and displays all the HTML tags and treats it as TEXT. here is the code i use! Please dont consider it abuse as i dont know how to encloase the code in TAGS!

<%
mes = ""
IsSuccess = false

sTo = Trim(Request.Form("txtTo"))
sFrom = Trim(Request.Form("txtFrom"))
sSubject = Trim(Request.Form("txtSubject"))
sMailServer = "127.0.0.1"
sBody = Trim(Request.Form("txtBody"))

if Request("__action")="TestEMail" then
TestEMail()
end if

Sub TestEMail()

Set objMail = Server.CreateObject("CDO.Message")
Set objConf = Server.CreateObject("CDO.Configuration")
Set objFields = objConf.Fields

With objFields
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = sMailServer
.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
.Update
End With

With objMail
Set .Configuration = objConf
.From = sFrom
.To = sTo
.Subject = sSubject
.TextBody = sBody
End With

Err.Clear
on error resume next

objMail.Send
if len(Err.Description) = 0 then
mes = " Message sent to " + sTo
mes = mes + " EMAIL SENT SUCCESSFULLY!"
IsSuccess = true
else
mes = " " + Err.Description + " TESTS FAILED!"
end if
Set objFields = Nothing
Set objConf = Nothing
Set objMail = Nothing
End sub

Sub Alert(html)
if IsSuccess then
Response.Write "<div class='testRelults' id='testSuccessful'><span class='testResult'>Success:</span>" & html & "</div>"
else
Response.Write "<div class='testRelults' id='testFailed'><span class='testResult'>Fail:</span>" & html & "</div>"
end if
End Sub
%>

View Replies View Related

Script Dont Process My Email List!

Im working on an automated email sending script which work real fine. I have to send 2 different list of email ( contact1 and contact2) of an acces database file (.mdb).

The fact is that my script work well but for some reason it only send the second list of email (contact2).

The script process the list contact1 without any error but obviously it isnt sending mail to those email.

It seems to be an easy fix mistake but i cant figure out why the first contact list isnt sending. Must be a "If then" mistake or something with the loop i think.

Heres the code: ......

View Replies View Related

Formview And Gridview Combo Issues (gv Dont Update But DB Does)

I have a formview which im using to ammed records in a DB via a gridview. When an item is selected on the gridview its details are shown in the formview. Ive wrote the update statement for the Insert button in the formviews edit mode.

If i edit a record in the formview this updates the DB, but not the gridview striaght away. I have to click on one of the select buttons on the gridview to update this. I have gridview.databind() on the click event of the insert button of the formview and on pageload, if its a callback. Code:

View Replies View Related

Inner Join

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

View Replies View Related

INNER JOIN

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 ?

View Replies View Related

Inner Join

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.

View Replies View Related

INNER JOIN

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;" .....

View Replies View Related

Inner Join

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&nbsp&nbsp&nbsp: <b>" & objRec("COUNTOF") & "</b>"
objRec.Close ...

View Replies View Related

SQL (INNER JOIN)

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 =

View Replies View Related

SQL JOIN

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:

View Replies View Related

Inner Join

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)

View Replies View Related

Sql Inner Join Problem

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"

View Replies View Related

SQL Delete And Inner Join

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?)

View Replies View Related

Mpre Than 1 Join

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.

View Replies View Related

Join Insert

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

View Replies View Related

SQL JOIN 3 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?

View Replies View Related

Complicated Inner Join??

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:

View Replies View Related

Problem With Sql Join

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='.

View Replies View Related

How Do I Inner Join 3 Tables?

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

View Replies View Related

INNER JOIN Statement

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.

View Replies View Related

Inner Join 2 Tables?

how do i do this?

View Replies View Related

How To Inner Join Tables

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:

View Replies View Related

Select Everything But Still Join?

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
%>

View Replies View Related

Join Two Strings

I have 2 string

str1="John"
str2="Smith"

I need to join them and then i need to get 6 characters from the left

so here is my code
str3=str1&str2
str4=Left(str3, 6)

I need to see the output as johnsm

but it gives the output as john

View Replies View Related

Outer Join

how can i join two tables and retrieve all information for a particular customer where the item does not appear in the union.

Basically if i join table 1 and table 2 items both exist then i don't want to show them. I want to show the items that are exist in table 1 and not in table2.

View Replies View Related

Multi-join

Trying to join three tables and find the records which DON'T match OR have less than x number of matches.Not sure how to go about it.keep getting matching fields only.

View Replies View Related

JOIN Recordsets

Is it possible to INNER JOIN two recordsets in ASP?I don't mean the normal JOIN you would use with two tables, but actually join the recordsets in ASP?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved