Home > Default > Query based on dynamic url paramter

Query based on dynamic url paramter

November 30Hits:0
Advertisement
I am displaying all the results of a simple select statement on one page in an html table. One of these colums displays the unique ID of every row returned from the query. I want to make the ID field an active link, whereupon when the user clicks it, they are taken to seperate page where information for just that row is displayed. I'd imagine you have to pass the ID for that specific row to the next page via the URL, and run another query based on that specific ID to retrieve the information. I just don't know how to have the URL variable equal the ID for each row. All I can find is static examples such as 'www.gotopage.jsp?ID=1234'.

Answers

while displaying the result in html table,
form the href like this
String id = resultSet.getString("ID");
<a href="gotopage.jsp?ID=<%= id%"></a><%=id%>.......
or post your code and we may be able to point it out.

Read other 2 answers

Tags:

Related Articles

  • Query based on dynamic url paramterNovember 30

    I am displaying all the results of a simple select statement on one page in an html table. One of these colums displays the unique ID of every row returned from the query. I want to make the ID field an active link, whereupon when the user clicks it,

  • Query Based Taxonomy - Dynamic Creation of a Query ProblemOctober 11

    Hi, I'm trying to create new category nodes in a taxonomy and to assing them queries. I know how to do this, but I encountered a strange behavior. Here is the situation: I have a string property DocumentType. When manualy creating a query, it looks l

  • Launch services query based on URL protocolNovember 30

    Heyaz. Technote 2017 describes a means of using LSGetApplicationForInfo() to query Launch Services to see what application is available handling a specific file extension (e.g., .html).. I am curious if the same call can be used to query based instea

  • How to call a dynamic URL on 'button press' event, in MVC-based BSPOctober 11

    Hi, My requirement is as below: On selecting a row in table view, and pressing a button, I need to open a browser. The Browser URL depends on the row selected. The key field from table view, is added at the end of the URL string. Shortly, I can say t

  • Dynamic filter on time characteristics on OLAP SAP BEX query based universeNovember 30

    Dear all, I'm currently working on the integration between SAP NetWeaver BI 7.0 and SAP BusinessObjects XI 3.1 FP 1.5 via integration kit. I've built an OLAP universe on the top of a BW query based on a multiprovider that contains 10 infocubes. Every

  • SAP Web Dispatcher - Dynamic URLNovember 30

    Hi All, We have a scenario where a URL coming to Web Dispatcher with be dynamic ,since each time the URL will hold a different phone number and a User ID as parameters in the URL and an external application would be requring to get some data from ERP

  • Open a Dynamic URL from a Table column linkOctober 11

    Hi, Jdev Version (11.1.1.6.0) I have requirement to open a dynamic URL from table column. Any time I click on link, it should generate dynamic URL based on column attribute and open in popup or browser. Can someone pls suggest how to achieve this. Th

  • How to change the fields in a JSF form based on a URL parameterOctober 11

    I am trying to build a generic JSF form of parameters which I want to dynamically change (i.e. change which field is visible, what the label text should be, etc) based on a URL parameter. I can set the fields using logic in the backing bean as an act

  • Dynamic URL in SOAP Receiver adapterOctober 11

    Hi all, I have a scenario where I am using a SOAP receiver adapter to send a cXML document to some vendors. I need to change the URL based on the vendor number (passed by sender SRM system). So I have created a user-defined function and used in messa

  • SOURCING10: Passing parameters to a Query Based webservice using JAVAOctober 11

    Hi Experts, I have been working on consuming a Query based webservice published in Souricng10 in a simple JAVA class. The query has a filter parameter which is not mandatory. I am able to consume the webservice using the GET method and display the co

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.833 s.