Expression too complex in query expression
page code creates string of manufacturerpartnumbers share common productfamilyid based on manufacturerpartnumber form selection. string included in recordset query.
the following error message occurs when manufacturerpartnumber string has numerous listings. when string contains 3 listings of manufacturerpartnumbers, error message not appear.
[microsoft][odbc microsoft access driver] expression complex in query expression 'latitude <= 40.8210861895984 , latitude >= 40.3865898104016 , longitude >= -74.2737786508004 , longitude <= -73.7014913491996 , (((((((((((((((((((((((((((((manufacturerpartnumber = '3408h')) or ((manufacturerpartnumber = '4608h'))) or ((manufacture'.
/customer_locator/testprocessform2.asp, line 233
is there size limit recordset query causing error or there possible syntax issue query code?
the following error message occurs when manufacturerpartnumber string has numerous listings. when string contains 3 listings of manufacturerpartnumbers, error message not appear.
[microsoft][odbc microsoft access driver] expression complex in query expression 'latitude <= 40.8210861895984 , latitude >= 40.3865898104016 , longitude >= -74.2737786508004 , longitude <= -73.7014913491996 , (((((((((((((((((((((((((((((manufacturerpartnumber = '3408h')) or ((manufacturerpartnumber = '4608h'))) or ((manufacture'.
/customer_locator/testprocessform2.asp, line 233
is there size limit recordset query causing error or there possible syntax issue query code?
More discussions in Develop server-side applications in Dreamweaver
adobe
Comments
Post a Comment