Pass SQLVAR through URL to SQL Method

3 Messages Forum Options Options
Permalink
Culley Smith
Pass SQLVAR through URL to SQL Method
Reply Threaded More
Print post
Permalink
Hi,

I'm having trouble getting the setup and syntax correct.

I have a Z search interface set up.  When called, it returns a list of "staff" stored in an SQL database.  First Name, Last Name, and Staff ID.

I am then trying to create a hypertext link that, when clicked, will bring up a bio page for individual staff in the result list.

  <tal:x repeat="result batch" >
 
         <tr>
          <td><a href="showStaff?staff_id=<span tal:replace="result/staffid">staffid goes here</span>">
               <span tal:replace="result/firstname">firstname goes here</span>
               <span tal:replace="result/lastname">lastname goes here</span></a></td>
        </tr>

  </tal:x>

<td><a href="showStaff?staff_id=<span tal:replace="result/staffid">staffid goes here</span>">

That line doesn't work.  What I want to do is autogenerate the URL to include the staffid for each staff that appears in my results list, then this url should go to the SQL Method, and pass the id through the form, to bring up a new results page.  Perhaps I need a Python Script in the process?

My first problem, however, is to solve how to autogenerate a URL with a unique staffid. e.g. something like: /showStaff?staff_id=3000, /showStaff?staff_id=3306, /showStaff?staff_id=2814, etc.

Any thoughts or suggestions would be appreciated.  I've read through some of the TAL and DTML manuals, but I'm just not making very good headway.  However, if there is a document out there which covers this, I'd be happy to read through it.

Thanks,

Culley

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Plone-Users mailing list
Plone-Users@...
https://lists.sourceforge.net/lists/listinfo/plone-users
Yuri-11
Re: Pass SQLVAR through URL to SQL Method
Reply Threaded More
Print post
Permalink
Culley Smith ha scritto:

> Hi,
>
> I'm having trouble getting the setup and syntax correct.
>
> I have a Z search interface set up.  When called, it returns a list of
> "staff" stored in an SQL database.  First Name, Last Name, and Staff ID.
>
> I am then trying to create a hypertext link that, when clicked, will
> bring up a bio page for individual staff in the result list.
>
>   <tal:x repeat="result batch" >
>  
>          <tr>
>           <td><a href="showStaff?staff_id=<span
> tal:replace="result/staffid">staffid goes here</span>">
>                <span tal:replace="result/firstname">firstname goes
> here</span>
>                <span tal:replace="result/lastname">lastname goes
> here</span></a></td>
>         </tr>
>
>   </tal:x>
>
> <td><a href="showStaff?staff_id=<span
> tal:replace="result/staffid">staffid goes here</span>">
wrong tal syntax

use: <a href="" tal:define="staffid result/staffid" tal:attributes="href
string:showStaff?staff_id=${staffid}">staffid goes here</a>





-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Plone-Users mailing list
Plone-Users@...
https://lists.sourceforge.net/lists/listinfo/plone-users
Yuri-11
Re: Pass SQLVAR through URL to SQL Method
Reply Threaded More
Print post
Permalink
Yuri ha scritto:

> Culley Smith ha scritto:
>  
>> Hi,
>>
>> I'm having trouble getting the setup and syntax correct.
>>
>> I have a Z search interface set up.  When called, it returns a list of
>> "staff" stored in an SQL database.  First Name, Last Name, and Staff ID.
>>
>> I am then trying to create a hypertext link that, when clicked, will
>> bring up a bio page for individual staff in the result list.
>>
>>   <tal:x repeat="result batch" >
>>  
>>          <tr>
>>           <td><a href="showStaff?staff_id=<span
>> tal:replace="result/staffid">staffid goes here</span>">
>>                <span tal:replace="result/firstname">firstname goes
>> here</span>
>>                <span tal:replace="result/lastname">lastname goes
>> here</span></a></td>
>>         </tr>
>>
>>   </tal:x>
>>
>> <td><a href="showStaff?staff_id=<span
>> tal:replace="result/staffid">staffid goes here</span>">
>>    
> wrong tal syntax
>
> use: <a href="" tal:define="staffid result/staffid" tal:attributes="href
> string:showStaff?staff_id=${staffid}">staffid goes here</a>
or

<a href="" tal:attributes="href string:showStaff?staff_id=${result/staffid}">staffid goes here</a>

but tal:define can help in more readability and save you from more
complex expressions

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Plone-Users mailing list
Plone-Users@...
https://lists.sourceforge.net/lists/listinfo/plone-users