Webject jsp

[BrianKrieger]

So, I have an embedded webject and am getting tripped up on the where
clause syntax. So......



<ie:param name="where"&lt;br"/>data="(number=$(@FORM[]searchBox[0]))"/>



Returns proper results (searchBox is the Form textbox name parameter).



<%

String myStr = "<string to=" test=">";

%>

.....

<ie:param name="where"&lt;br"/>data="(name='<%=myStr%>')"/>



Returns nothing. And



<%

String myStr = "<string to=" test=">";

%>

.....

<ie:param name="where"&lt;br"/>data="(name=<%=myStr%>)"/>



Returns invalid where clause syntax (note the last drops the single
quotes). So, while I could use javascript, etc. to make some
modifications (if needed), why am I not able to use the "<%= %>" jsp
syntax to properly execute a search? I remember some jsp syntax being
unacceptable in ie but I think it was syntax jsp deprecated.



Thoughts, all?



Brian Krieger



PS: Sorry if this is a simpleton question.......

[jmomber]

If you are searching, are you using search-objects or query-objects?

I believe the syntax is different depending on which one you are using:

<%

String num = "12345";

%>

Search-Objects:

<ie:param name="WHERE" data="(number='&lt;%=num%">')" />

Query-Objects: (note the () are omitted)

<ie:param name="WHERE" data="number=&lt;%=num%">"/> //might require ' ' around <%=num%>

~Jamie

[Linlin]

I have exactly the same issue,

I use "Search-Objects". If get the name from the form as Where condition. It works.

<ie:webject name="Search-Objects" type="OBJ">
<ie:param name="INSTANCE"" data="localdomain.vm-windchill.Windchill"/">
<ie:param name="authorization" data="$(@SERVER[]AUTHORIZATION[0])"/">
<ie:param name="type"" data="wt.epm.EPMDocument"/">
<ie:param name="where"" data="(name='$(@FORM[]name[0])')"/">
<ie:param name="group_out"" data="objectsSearched"/">
</ie:webject>

But if

<%
String whereKeyWord = "C6720PD.CATDRAWING";
%>

Use the following syntax. The result is blank.

<ie:param name="WHERE"" data="(name='&lt;%=whereKeyWord%">')" />

Any help will be appreciated. Thank you so much!