Forums

This topic is locked

Syntax error missing operator in query expression

Posted 23 years ago
1
has voted
23 years ago frog jumps posted:
<font face='Tahoma'>I cannot figure this one out...any idea...besides that I may be a moron...

SQL:

SELECT Customers.CustID, Customers.CompanyName, Customers.ContactFirstName, Customers.ContactLastName, Customers.Address, Customers.Address2, Customers.Address3, Customers.City, Customers.State, Customers.ZipCode, Customers.PhoneNumber, Customers.FaxNumber, Customers.AltPhone, Notes.TaskID, Notes.nCustID, Notes.Employee, Notes.Time, Notes.Date, Notes.Note
FROM Customers LEFT JOIN Notes ON Notes.nCustID=Customers.CustID GROUP BY Customers.CustID, Customers.CompanyName, Customers.ContactFirstName, Customers.ContactLastName, Customers.Address, Customers.Address2, Customers.Address3, Customers.City, Customers.State, Customers.ZipCode, Customers.PhoneNumber, Customers.FaxNumber, Customers.AltPhone, Notes.TaskID, Notes.nCustID, Notes.Employee, Notes.Time, Notes.Date, Notes.Note ORDER BY Customers.CustID, Customers.CompanyName, Customers.ContactFirstName, Customers.ContactLastName, Customers.Address, Customers.Address2, Customers.Address3, Customers.City, Customers.State, Customers.ZipCode, Customers.PhoneNumber, Customers.FaxNumber, Customers.AltPhone, Notes.TaskID, Notes.nCustID, Notes.Employee, Notes.Time, Notes.Date, Notes.Note
WHERE CustID = varNote

Variable:

Name : varNote
Default value: 1
Runtime value: Request.QueryString("Customers.CustID"
</font id='Tahoma'>

Reply to this topic