firebreath67
Programmer
Select [Shipping Customers`.CustomerNumber], [Shipping Customers`.ShippingToName], [Shipping Customers`.ShippingAddress_1], [Shipping Customers`.ShippingAddress_2], [Shipping Customers`.ShippingCity], [Shipping Customers`.ShippingState], [Shipping Customers`.ShippingZip], [Shipping Customers`.ShippingCountry], [Shipping Customers`.ShippingPhone], [Shipping Customers`.ShippingFax] From [Shipping Customers] [Shipping Customers] Where Shipping Customer.CustomerNumber=12512
this is the output to my query.
here is the query:
SQL = SQL & " Select"
SQL = SQL & " [Shipping Customers`.CustomerNumber],"
SQL = SQL & " [Shipping Customers`.ShippingToName],"
SQL = SQL & " [Shipping Customers`.ShippingAddress_1],"
SQL = SQL & " [Shipping Customers`.ShippingAddress_2],"
SQL = SQL & " [Shipping Customers`.ShippingCity],"
SQL = SQL & " [Shipping Customers`.ShippingState],"
SQL = SQL & " [Shipping Customers`.ShippingZip],"
SQL = SQL & " [Shipping Customers`.ShippingCountry],"
SQL = SQL & " [Shipping Customers`.ShippingPhone],"
SQL = SQL & " [Shipping Customers`.ShippingFax]"
SQL = SQL & " From"
SQL = SQL & " [Shipping Customers] [Shipping Customers]"
SQL = SQL & " Where "
SQL = SQL & "Shipping Customer.CustomerNumber='" & trim(request("item_id")) & "'"
keep getting syntax error(missing operator)
help
this is the output to my query.
here is the query:
SQL = SQL & " Select"
SQL = SQL & " [Shipping Customers`.CustomerNumber],"
SQL = SQL & " [Shipping Customers`.ShippingToName],"
SQL = SQL & " [Shipping Customers`.ShippingAddress_1],"
SQL = SQL & " [Shipping Customers`.ShippingAddress_2],"
SQL = SQL & " [Shipping Customers`.ShippingCity],"
SQL = SQL & " [Shipping Customers`.ShippingState],"
SQL = SQL & " [Shipping Customers`.ShippingZip],"
SQL = SQL & " [Shipping Customers`.ShippingCountry],"
SQL = SQL & " [Shipping Customers`.ShippingPhone],"
SQL = SQL & " [Shipping Customers`.ShippingFax]"
SQL = SQL & " From"
SQL = SQL & " [Shipping Customers] [Shipping Customers]"
SQL = SQL & " Where "
SQL = SQL & "Shipping Customer.CustomerNumber='" & trim(request("item_id")) & "'"
keep getting syntax error(missing operator)
help