Skip to main content
B
BrianKrieger10-Marble
10-Marble
December 17, 2012
Question

Webject jsp

  • December 17, 2012
  • 2 replies
  • 787 views
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.......

2 replies

J
jmomber12-Amethyst
12-Amethyst
December 18, 2012

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

L
Linlin1-Visitor
1-Visitor
February 13, 2015

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!

Terms & ConditionsAccessibility statement