DataAssist Search server behavior

Report · Nov 07, 2007

I have merged an existing "customer locator" search application with a DataAssist Search application to further filter recordset results based on additional criteria.

I have attempted to acheive this by creating a search application using DataAssist Search server behavior and adding the WHERE clause segments of the existing search application as additional filter criteria to the DataAssist Search dialog box.

Following is the WHERE clause code generated by DataAssist which does not bring any results for the first four filter criteria which are Recordset1_HighLatitude etc) and therefore brings me the error message as shown below:

DataAssist generated code:
WADbSearch1_whereClause=BuildFilterString("LATITUDE","Recordset1__HighLatitude","","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("LATITUDE","Recordset1__LowLatitude","AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("LONGITUDE","Recordset1__LowLongitude","AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("LONGITUDE","Recordset1__HighLongitude","AND","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("VendorPartNumber","" & cStr( Session("VendorPartNumber") ) & "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)
WADbSearch1_whereClause=BuildFilterString("CustomText10","" & cStr( Session("Industry") ) & "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause)

error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression '(LATITUDE <= ) AND (LATITUDE >= ) AND (LONGITUDE >= ) AND (LONGITUDE <= ) AND (CustomText10 = 'Catering/Food Service')'.

/Results1.asp, line 291

>What can the problem be?

Report · Nov 08, 2007

have you tried posting this on the Web Assist forums?

http://www.webassist.com:8119/

--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: Dreamweaver CS3: The Missing Manual,
DMX 2004: The Complete Reference, DMX 2004: A Beginner's Guide
Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"aonefun" <webforumsuser@macromedia.com> wrote in message
news:fgtvfh$i3a$1@forums.macromedia.com...
>I have merged an existing "customer locator" search application with a
> DataAssist Search application to further filter recordset results based on
> additional criteria.
>
>
> I have attempted to acheive this by creating a search application using
> DataAssist Search server behavior and adding the WHERE clause segments of
> the
> existing search application as additional filter criteria to the
> DataAssist
> Search dialog box.
>
> Following is the WHERE clause code generated by DataAssist which does not
> bring any results for the first four filter criteria which are
> Recordset1_HighLatitude etc) and therefore brings me the error message as
> shown
> below:
>
> DataAssist generated code:
>
> WADbSearch1_whereClause=BuildFilterString("LATITUDE","Recordset1__HighLatitude",
> "","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClause
> )
>
> WADbSearch1_whereClause=BuildFilterString("LATITUDE","Recordset1__LowLatitude","
> AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereClau
> se)
>
> WADbSearch1_whereClause=BuildFilterString("LONGITUDE","Recordset1__LowLongitude"
> ,"AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereCl
> ause)
>
> WADbSearch1_whereClause=BuildFilterString("LONGITUDE","Recordset1__HighLongitude
> ","AND","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereC
> lause)
> WADbSearch1_whereClause=BuildFilterString("VendorPartNumber","" & cStr(
> Session("VendorPartNumber") ) &
> "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereC
> lause)
> WADbSearch1_whereClause=BuildFilterString("CustomText10","" & cStr(
> Session("Industry") ) &
> "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_dateSeparator,WADbSearch1_whereC
> lause)
>
> error message:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression
> '(LATITUDE <= ) AND (LATITUDE >= ) AND (LONGITUDE >= ) AND (LONGITUDE <= )
> AND
> (CustomText10 = 'Catering/Food Service')'.
>
> /Results1.asp, line 291
>
>
> >What can the problem be?
>