?
Solved

Problem in Displayig Storage Procedure values

Posted on 2005-03-03
8
Medium Priority
?
180 Views
Last Modified: 2013-11-15
hi everyone,

Out put  of a Storage Procedures is something like this:
-----------------------------------------------------------
Name        Version     Path                      FileSize
-----------------------------------------------------------
Bat.exe       1.1          /abc/bat/              52344
Read.txt     1.1          /abc/read/                413
Install.iso     1.1          /abc/install/            1111
------------------------------------------------------------

Now in JSP page I wanna display this values, please fill up the (?) here:

<% .......
ResultSet rs= cs.executeQuery();

<a href="(????Path + ????Name)"> Install</a>    FileSize: ???????
<a href="<%=rs.getString(3)%>"> Read Me</a>   <== I tried thils line but showed error.
<a href="????path plus file name??????"> Batch File</a>

..........%>
======================================
Bascialy I want the output something like this:

<a href="/abc/install/Install.iso">    Install       </a>   FileSize: 52344
<a href="/abc/read/Read.txt">     Read Me   </a>   FileSize: 413
<a href="/abc/bat/Batch.exe">     Batch File  </a>   FileSize: 1111

Please help
0
Comment
Question by:princehyderabad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
8 Comments
 
LVL 29

Expert Comment

by:bloodredsun
ID: 13453464
while (rs.next()) {
%>

<a href="(????Path + ????Name)"> Install</a>    FileSize: ???????
<a href="<%=rs.getString(3)%>"> Read Me</a>   <== I tried thils line but showed error.
<a href="????path plus file name??????"> Batch File</a>

<%}>

for the resultset value use get<type>(int index) or use getString(String columnName)
0
 

Author Comment

by:princehyderabad
ID: 13453906
yeah I tried the same, wrong output giving me three sets of values;

 See the output:

<a href="/abc/install/Install.iso">    Install       </a>   FileSize: 52344
<a href="/abc/install/Install.iso">     Read Me   </a>   FileSize: 52344
<a href="/abc/install/Install.iso">     Batch File  </a>   FileSize: 52344

<a href="/abc/read/Read.txt">    Install       </a>   FileSize: 413
<a href="/abc/read/Read.txt">     Read Me   </a>   FileSize: 413
<a href="/abc/read/Read.txt">     Batch File  </a>   FileSize: 413

<a href="/abc/bat/Batch.exe">    Install       </a>   FileSize: 1111
<a href="/abc/bat/Batch.exe">     Read Me   </a>   FileSize: 1111
<a href="/abc/bat/Batch.exe">     Batch File  </a>   FileSize: 1111
0
 
LVL 29

Expert Comment

by:bloodredsun
ID: 13453966
Then just do one line at a time not three. You'll have to do a if statement to get the String between the a tags
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:princehyderabad
ID: 13454021
How ? Thats is what I'm seeking help for
0
 
LVL 29

Accepted Solution

by:
bloodredsun earned 1100 total points
ID: 13454077
Do a subString on the returned value you use fot the url that stops at the docs. You need to look for the indexOf(".") for the stop point.
0
 

Author Comment

by:princehyderabad
ID: 13500795
Anyone to help on this issues.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question