[Zope] Search Interface Gone arwy! Red! No, Blue.....ahhhh.....
Here is my search interface and SQL method.
search_query:
dtml-var standard_html_header
form action="search_result" method="get"
h2dtml-var document_title/h2
input name="select_statment" value="select * from courses_description
"
input name="where_statement" value=" where subject = 'ee'"
input type="SUBMIT" name="SUBMIT" value="Submit Query"
/td/tr
/table
/form
dtml-var standard_html_footer
search_results:
dtml-var standard_html_header
dtml-in search_method size=50 start=query_start
dtml-if sequence-start
dtml-if previous-sequence
a href="dtml-var URLdtml-var sequence-query
query_start=dtml-var
previous-sequence-start-number"
(Previous dtml-var previous-sequence-size results)
/a
/dtml-if previous-sequence
table border
tr
thSUBJECT/th
thCOURSE NBR/th
thPART/th
thTEXT/th
/tr
/dtml-if sequence-start
tr
tddtml-var SUBJECT/td
tddtml-var COURSE_NBR/td
tddtml-var PART/td
tddtml-var TEXT/td
/tr
dtml-if sequence-end
/table
dtml-if next-sequence
a href="dtml-var URLdtml-var sequence-query
query_start=dtml-var
next-sequence-start-number"
(Next dtml-var next-sequence-size results)
/a
/dtml-if next-sequence
/dtml-if sequence-end
dtml-else
There was no data matching this dtml-var title_or_id query.
/dtml-in
dtml-var standard_html_footer
Z_SQL_method(search_method):
dtml-with search_query
dtml-call "REQUEST.set('left', select_statment + where_statement)"
/dtml-with
dtml-var left
What I am trying to do is concatenate select_statment and
where_statement , into a single statement known
as left. There will be more parameters when I get this to work. Then,
I want to use left, which would be a valid SQL statement, and throw it
at my Z SQL method. I don't
understand why I can't accomplish this, it doesn't seem like it should
be difficult to me. Thank you for reading this and thanks in advance
for any help.
-Sean
--
Sean G. Richards : Web Technician/Treasurer PLUG
Purdue University : Engineering Computing Network
[EMAIL PROTECTED] :
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] I want to assign the values of parameters in a form to another parameter in the same form?
Dear Zope list, I want to cat the values of parameters, all strings, in a form to another parameter in the same form. How would I go about doing this using dtml? -- Sean G. Richards : Web Technician/Treasurer PLUG Purdue University : Engineering Computing Network [EMAIL PROTECTED] : ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] How do I call a parameter from inside of the same form?
Hello, I am trying to build an SQL statement in a form, and then pass the statement onto a Z SQL method, for execution. something like form action="search_results" method="get" input type="text" name="select_statement" value="SELECT name, phone_number, address FROM black_book WHERE" size=20 select name="where_statement" size=3 option value=" name = 'jennifer' "Jennifer option value=" name='anne' " Anne option value=" name='alice' "Alice /select input type="hidden" name="cat_both_previous_statements" value="dtml-sqlvar select_statement type=string dtml-sqlvar where_statement type=string" input type="SUBMIT" name="SUBMIT" value="SUBMIT" /form I understand that this isn't the correct way to do this, I am just trying to convey what I want to do, and maybe someone can help me! Also, what would I do if the select box was multiple, where I could select more than one option? Well, if this is possible in Zope please let me know. Thank you and have a nice day! Sean Richards ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
