DataAssist Search server behavior

[aonefun]

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("LATITUD E","Recordset1__HighLatitude",
"","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSep arator,WADbSearch1_whereClause
)

WADbSearch1_whereClause=BuildFilterString("LATITUD E","Recordset1__LowLatitude","
AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateS eparator,WADbSearch1_whereClau
se)

WADbSearch1_whereClause=BuildFilterString("LONGITU DE","Recordset1__LowLongitude"
,"AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dat eSeparator,WADbSearch1_whereCl
ause)

WADbSearch1_whereClause=BuildFilterString("LONGITU DE","Recordset1__HighLongitude
","AND","<=",1,WADbSearch1_wildCard,WADbSearch1_da teSeparator,WADbSearch1_whereC
lause)
WADbSearch1_whereClause=BuildFilterString("VendorP artNumber","" & cStr(
Session("VendorPartNumber") ) &
"","AND","=",0,WADbSearch1_wildCard,WADbSearch1_da teSeparator,WADbSearch1_whereC
lause)
WADbSearch1_whereClause=BuildFilterString("CustomT ext10","" & cStr(
Session("Industry") ) &
"","AND","=",0,WADbSearch1_wildCard,WADbSearch1_da teSeparator,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?

[Nancy]

have you tried posting this on the Web Assist forums?

[url]http://www.webassist.com:8119/[/url]


--
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("LATITUD E","Recordset1__HighLatitude",
> "","<=",1,WADbSearch1_wildCard,WADbSearch1_dateSep arator,WADbSearch1_whereClause
> )
>
> WADbSearch1_whereClause=BuildFilterString("LATITUD E","Recordset1__LowLatitude","
> AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dateS eparator,WADbSearch1_whereClau
> se)
>
> WADbSearch1_whereClause=BuildFilterString("LONGITU DE","Recordset1__LowLongitude"
> ,"AND",">=",1,WADbSearch1_wildCard,WADbSearch1_dat eSeparator,WADbSearch1_whereCl
> ause)
>
> WADbSearch1_whereClause=BuildFilterString("LONGITU DE","Recordset1__HighLongitude
> ","AND","<=",1,WADbSearch1_wildCard,WADbSearch1_da teSeparator,WADbSearch1_whereC
> lause)
> WADbSearch1_whereClause=BuildFilterString("VendorP artNumber","" & cStr(
> Session("VendorPartNumber") ) &
> "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_da teSeparator,WADbSearch1_whereC
> lause)
> WADbSearch1_whereClause=BuildFilterString("CustomT ext10","" & cStr(
> Session("Industry") ) &
> "","AND","=",0,WADbSearch1_wildCard,WADbSearch1_da teSeparator,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?

>