473,383 Members | 1,762 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > asp / active server pages > questions > if statement using vbscrip language

Join Bytes to post your question to a community of 473,383 software developers and data experts.

if statement using vbscrip language

Expand|Select|Wrap|Line Numbers
  1. If sIssueId <>rs("IssueId") Then%> <tr class=selsty> <td rowspan=2> <%= rs("ISSUENO")%> </td> <td rowspan=2> <%= rs("ITEM") %> </td> <td rowspan=2> <%= rs("COLOR") %> </td> <td rowspan=2><%= rs("SIZE") %> </td> <td align=right rowspan=2> <%= rs("ISSUEQTY") %> </td> <%        end if%>
Oct 29 '13 #1
3 1432
thank you.i have lot of doubts.so i learn lot of things from
Oct 29 '13 #2
Expand|Select|Wrap|Line Numbers
  1. <%@ language=vbscript %>
  2. <!--#include file="axongeneral.asp"-->
  3. <!--#include file="GeneralFunctions.asp"-->
  4. <html>
  5. <head>
  6.     <title>Process</title>
  7.     <style>
  8.     font.title
  9.             {font-family:arial;
  10.             font-size:12px}
  11.         td{font-family:arial; font-size:11px}
  12.         .selsty{width:250px; font-family:arial; font-size:12px; font-weight:bolder; color:91008b; background:e7f8f7}
  13.     </style>
  14. </head>
  15. <body>
  16. <% 
  17. dim  cn, rs, squery
  18. Dim sIssueId
  19.  
  20. if Request.QueryString("show")="detail" then
  21.     Response.Write("Issue")
  22.     squery =" Select I.Item,Clr.color,SZ.size,PIM.IssueNo,PID.IssueQty,PRD.RcptQty,PRD.RcptRate From Process_Rcpt_Det PRD "
  23.     squery = squery & "<br>" & " Inner Join Process_Iss_Mas PIM On PRD.IssueId=PIM.IssueId "
  24.     squery = squery & "<br>" & " Inner Join Process_Iss_Det PID On PRD.IssueDetId=PID.IssueDetId "
  25.     squery = squery & "<br>" & " Inner Join Item I On PID.itemid=I.itemid "
  26.     squery = squery & "<br>" & " Inner Join color Clr On PID.ColorId=Clr.colorId "
  27.     squery = squery & "<br>" & " Inner Join size SZ On PID.sizeid=SZ.sizeid "
  28.     'squery = squery & "<br>" & " Where IssueNo= '" & Request.QueryString("IssueNo") & "' "
  29.     'squery = squery & "<br>" & " and  storeId= " & Request.QueryString("store") & ""
  30.     'squery = squery & "<br>" & " and PID.IssueDetId= " & Request.QueryString("IssueDetId") & ""
  31.     Response.Write squery
  32.     'end response
  33.     squery = replace(squery,"<br>","")
  34.     Set rs =Server.CreateObject("ADODB.Recordset")
  35.     Rs.Open sQuery, Con, adOpenStatic, adLockReadOnly
  36. %>
  37.     <table align=Center border=0 bgcolor=red Cellpadding=1 Cellspacing=1 WIDTH=100%>
  38.       <tr class=selsty align=Center  height=25>
  39.         <td align=CENTER><font size=3> <b>ISS DET DETAILS</b> </font> </td>
  40.       </tr>
  41.     </table>
  42.     <BR>
  43.     <table  align=center  border=0 bgcolor=red Cellpadding=1 Cellspacing=1 WIDTH=100%>
  44.       <tr class=selsty height=25 >
  45.         <td ALIGN=CENTER rowspan=2> <b>ISSUENO</b> </td>
  46.         <td ALIGN=CENTER rowspan=2> <b>ITEM</b> </td>
  47.         <td ALIGN=CENTER rowspan=2> <b>COLOR</b> </td>
  48.         <td ALIGN=CENTER rowspan=2> <b>SIZE</b> </td>
  49.         <td ALIGN=RIGHT rowspan=2> <b>ISSUEQTY</b> </td>
  50.         <td ALIGN=RIGHT> <b>RCPTQTY</b> </td>
  51.         <td ALIGN=RIGHT> <b>RCPTRATE</b> </td>
  52.       </tr>
  53.     <%
  54.     rs.movefirst
  55.     sIssueId=0
  56.     while rs.EOF=False
  57.         If sIssueId <>rs("IssueId") Then%>
  58.  
  59.  
  60.  
  61.             <tr class=selsty>
  62.             <td rowspan=2> <%= rs("ISSUENO")%> </td>
  63.             <td rowspan=2> <%= rs("ITEM") %> </td>
  64.             <td rowspan=2> <%= rs("COLOR") %> </td>
  65.             <td rowspan=2><%= rs("SIZE") %> </td>
  66.             <td align=right rowspan=2> <%= rs("ISSUEQTY") %> </td>
  67.  
  68. <%        end if%>
  69.             <td align=right> <%= rs("RCPTQTY") %> </td>
  70.             <td align=right> <%= rs("RCPTRATE") %> </td>
  71.             </tr>
  72.             sIssueId=rs("IssueId")
  73.    <%
  74.    rs.movenext
  75.    wend%>                
  76. </table>
  77.  
  78. <%    Response.end
  79. end if
  80. %>
  81.  
  82. <%
  83.  Set rs =Server.CreateObject("ADODB.Recordset")
  84.  squery = " Select PID.IssueDetId, PIM.IssueNo,PIM.IssueDate ,su.supplier,S.Store,P.process,PID.IssueQty,PIM.Remarks From Process_Iss_Det PID "
  85.  squery = squery & "<br>" & " Inner Join Process_Iss_Mas PIM On PID.IssueId=PIM.IssueId " 
  86.  squery = squery & "<br>" & " Inner Join supplier su On PIM.supplierid=su.supplierid " 
  87.  squery = squery & "<br>" & " Inner Join Store S On PIM.StoreId=S.StoreId " 
  88.  squery = squery & "<br>" & " Inner Join process P On PIM.processid=P.processid " 
  89.  squery = squery & "<br>" & " Where 1=1"
  90.  'Response.Write squery
  91.  'end Response
  92.  squery = replace(squery,"<br>","")
  93.  Rs.Open sQuery, Con, adOpenStatic, adLockReadOnly
  94.  %>
  95. <table align=Center border=0 bgcolor=red Cellpadding=1 Cellspacing=1 WIDTH=100%>
  96.  <tr class=selsty  height=25>
  97.     <td align=CENTER > <font size=3> <b>ISSUE LISTING</b> </font> </td>
  98.  </tr>
  99. </table>
  100. <BR>
  101. <table  align=center  border=0 bgcolor=red Cellpadding=1 Cellspacing=1 WIDTH=100%>
  102.  <tr class=selsty height=25>
  103.     <td ALIGN=CENTER> <b>ISSUENO</b> </td>
  104.     <td ALIGN=CENTER> <b>ISSUEDATE</b> </td>
  105.     <td ALIGN=CENTER> <b>SUPPLIER</b> </td>
  106.     <td ALIGN=CENTER> <b>STORE</b> </td>
  107.     <td ALIGN=CENTER> <b>PROCESS</b> </td>
  108.     <td ALIGN=CENTER> <b>ISSUEQTY</b> </td>
  109. </tr>    
  110. <%
  111.  rs.movefirst
  112.  do while not rs.eof%>
  113.     <tr class=selsty>
  114.       <td> <%= rs("ISSUENO") %> </td>
  115.       <td> <%= rs("ISSUEDATE") %> </td>
  116.       <td> <%= rs("SUPPLIER") %> </td>
  117.       <td> <%= rs("STORE") %> </td>
  118.       <td> <%= rs("PROCESS") %> </td>
  119.       <td align=right>
  120.       <a href="Process.asp?IssueNo=<%=rs.Fields("IssueNo")%>&StoreId=<%=rs.Fields("Store")%>&IssueDetId=<%=rs.Fields("IssueDetId")%>&show=detail">
  121.        <%= rs("ISSUEQTY") %> </a> </td>
  122.     </tr>  
  123.     <tr class=selsty >
  124.       <td colspan=6><b>REMARKS:</b><%= rs("REMARKS") %> </td>
  125.     </tr>
  126.     <%
  127.  rs.movenext
  128.  loop 
  129. %> 
  130. </table>
  131. </body>
  132. </html>
  133. <%
  134. rs.close
  135. set rs=nothing
  136. %>
Oct 29 '13 #3
Rabbit
12,516 Expert Mod 8TB
You haven't asked a question...
Oct 29 '13 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
Mimicking a SELECT/CASE statement using XSL
by: Gadrin77 | last post by:
as a newbie to XSL, is it possible to mimic a SELECT/CASE statement using XSL? I tried a quickie and I kept getting errors either using PARAM or WITH-PARAM in the wrong place or VARIABLE. I...
.NET Framework
10
How to get filename using C language
by: Hughes | last post by:
Hi, I would like to get the filename from a folder by using C language. For example, in path /Users/abc/Desktop/xyz/ there is a file named "test.s" (file "test.s" is inside folder "xyz"). How...
C / C++
4
How to interact with Oracle, MS-SQL and Sybase databases using C Language
by: yogishaj | last post by:
How to interact with Oracle, MS-SQL and Sybase databases using C Language. Please provide me information about links or books which discuss this subject
C / C++
1
Export to Excel using XMLSpreadSheet Language
by: vijay babu | last post by:
Hi, I'm developing asp.net web application and doing some part of the Export data to Excel using XMLSpreadSheet Language. But, I'm unable to set some new properties like autowidth for cell and...
C# / C Sharp
0
JPEG file handling using C language.
by: tigerofkvp | last post by:
Hello, I want to know abt some basic operations such as 1) copy a JPG image from one location to another/same location using C language. 2) Add the Status information to an existing image...
C / C++
0
set cookie using c language
by: nickyeng | last post by:
hi I have done the searching, but couldn't find it. I wanna set state information to site-wide cookie. I have a static form, user select the choice and press submit button. This button will...
C / C++
0
MERGE statement using PreparedStatement in JAVA
by: eonblue20 | last post by:
Hello I\\\'m new to DB2 and I\\\'ve been trying to create the MERGE statement using PreparedStatements in Java as a requirement for a project I\\\'m working on, but I get the following message: ...
DB2 Database
1
Error with Select Statement using the SQLDataAdapter Wizard
by: sds50 | last post by:
Error with Select Statement using the SQLDataAdapter Wizard -------------------------------------------------------------------------------- I am needing to setup the data adapter for my SQL...
Microsoft SQL Server
1
printout using c language
by: selvasscript | last post by:
i want to take printout using c language . how to connect the printer using c codes..(i.e) how to connect printer using printer interface
C / C++
6
how we can modify window regsitery using java language .i am using java1.6 version...
by: sanchit007 | last post by:
how we can modify window registry using java language .i am using java1.6 version...
Java
1
Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
General
0
Wordpress or something else?
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
Content Management Systems
0
Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
General
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Batch import of multiple excel files into the database
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
Data Management
0
Merging data from multiple Excel files
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!