[Zope] SQL query by parameter
Dmitry B. Khlonin
khl@paloma.spbu.ru
Wed, 12 May 1999 21:56:21 +0400
This is a multi-part message in MIME format.
------=_NextPart_000_0023_01BE9CC2.4575F760
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
How I do this?
I have table with results from SQL query
I need this: first column contain Names(that are must be hyperlinks)
I have second SQL query with parameter Name
How I may link my table to new table with results from second
SQL query(parameter must be passed from first table by hyperlink,
f.e. "table2?John", table2 - DTML Document, "John" - parameter for
second SQL query)
------=_NextPart_000_0023_01BE9CC2.4575F760
Content-Type: text/html;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Dkoi8-r http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.71.2110.0"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 face=3D"Arial Cyr" size=3D2>How I do =
this?</FONT></DIV>
<DIV><FONT color=3D#000000 face=3D"Arial Cyr" size=3D2>I have table with =
results from=20
SQL query</FONT></DIV>
<DIV><FONT color=3D#000000 face=3D"Arial Cyr" size=3D2>I need this: =
first column=20
contain Names(that are must be hyperlinks)</FONT></DIV>
<DIV><FONT color=3D#000000 face=3D"Arial Cyr" size=3D2>I have second SQL =
query with=20
parameter Name</FONT></DIV>
<DIV><FONT color=3D#000000 face=3D"Arial Cyr" size=3D2>How I may link my =
table to new=20
table with results from second</FONT></DIV>
<DIV><FONT color=3D#000000 face=3D"Arial Cyr" size=3D2>SQL =
query(parameter must be=20
passed from first table by hyperlink,</FONT></DIV>
<DIV><FONT color=3D#000000 face=3D"Arial Cyr" size=3D2>f.e. =
"table2?John",=20
table2 - DTML Document, "John" - parameter for</FONT></DIV>
<DIV><FONT color=3D#000000 face=3D"Arial Cyr" size=3D2>second SQL =
query)</FONT></DIV>
<DIV><FONT color=3D#000000 face=3D"Arial Cyr"=20
size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0023_01BE9CC2.4575F760--