|
 |
asp_databases thread: SQL problem !
Message #1 by tonywhite@b... on Wed, 28 Mar 2001 15:02:39
|
|
Hi
I'm taking in two inputs via a form ("strSpareDescription"
and "strPartNumber") and then trying to apply them to the following
(Access generated) query.
I've dealt with the inverted commas.
BUT I get the error message "Expected End Of Statement"
set strQuery = "SELECT
spareDescription.GenericType,spareDescription.SpareNumber,spareDescription.
SpareDescription, SpareLocation.Quantity, Outlets.Name, Outlets.Address1,
Outlets.Address2, Outlets.Address3, Outlets.Address4, Outlets.Telephone,
Outlets.Mobile, parts.PartNumber FROM ((spareDescription INNER JOIN
SpareLocation ON spareDescription.SpareNumber = SpareLocation.Spare) INNER
JOIN (([Part Description] INNER JOIN parts ON [Part
Description].TypeDetails = parts.Details) INNER JOIN spares ON
parts.PartNumber = spares.ModelNumber) ON spareDescription.SpareNumber =
spares.SpareNumber) INNER JOIN (Outlets INNER JOIN StockDetails ON
Outlets.OutletNumber = StockDetails.OutletNumber) ON
(SpareLocation.Location = Outlets.OutletNumber) AND (parts.PartNumber =
StockDetails.PartNumber)
WHERE (((spareDescription.GenericType)=" & "'" & strSpareDescription
& "'") AND ((parts.PartNumber)="'" & strPartNumber & "'"))"
Any ideas greatly received!!
AW
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 30 Mar 2001 18:22:33 +1000
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: I've dealt with the inverted commas.
:
: BUT I get the error message "Expected End Of Statement"
:
: set strQuery = "SELECT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You don't Set a variable to a value. You Let a variable have a value.
strQuery = "SELECT..."
Also, when you are having problems with VBScript Syntax errors (eg
expected ), or expected End of Statement), it helps to write your code in a
little more structured way:
strQuery = _
"SELECT " & _
"spareDescription.GenericType, " & _
"spareDescription.SpareNumber, " & _
"spareDescription.SpareDescription, " & _
"SpareLocation.Quantity, " & _
"Outlets.Name, " & _
"Outlets.Address1, " & _
"Outlets.Address2, " & _
"Outlets.Address3, " & _
"Outlets.Address4, " & _
"Outlets.Telephone, " & _
"Outlets.Mobile, " & _
"parts.PartNumber " & _
"FROM " & _
"(" & _
"(" & _
"spareDescription
"INNER JOIN SpareLocation " & _
"ON spareDescription.SpareNumber = SpareLocation.Spare" & _
")" & _
"INNER JOIN " & _
"(" & _
"(" & _
"[Part Description] " & _
"INNER JOIN parts " & _
"ON [Part Description].TypeDetails = parts.Details" & _
")" & _
"INNER JOIN spares " & _
"ON parts.PartNumber = spares.ModelNumber" & _
")" & _
ON spareDescription.SpareNumber = spares.SpareNumber
etc
Cheers
Ken
|
|
|
View Cart
