How to make operation - ASP / Active Server Pages

Federico Moschini [328594]

I have to make difference between2 data from a table in SQL.

The page is made with Frontpage, and it extracts QtaGiaCons and Quantita
from table "oclrighe".

I have to make Quantita - QtaGiaCons to obtain QtaInev
(quantity that I have to ship because I have partially shipped)

I wait for your suggestion. Thank you.

Federico

*************** ***********
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_LCID = 1040 %>
<meta http-equiv="Content-Language" content="it">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>DETTAGLI O RESIDUO D'ORDINE</title>
</head>

<body>

<p style="margin-top: 0; margin-bottom: 0"><b>METRO INTERNATIONAL
S.p.A.</b></p>
<p style="margin-top: 0; margin-bottom: 0"><font size="2">VIA MODICA 16 -
20143
MILANO MI</font></p>
<p style="margin-top: 0; margin-bottom: 0"><font size="2">TEL. 02817941 -
FAX.
028131113</font></p>
<p style="margin-top: 0; margin-bottom: 0"><font size="2">E-MAIL:
in**@metroint.i t
- SITO INTERNET: http://www.metroint.it </font></p>
<div style="border-top-style: solid; border-top-width: 1; padding-top: 1">
<p style="margin-top: 0; margin-bottom: 0"> </p>
</div>

<p style="margin-top: 0; margin-bottom: 0"> </p>
<table width="100%" border="0">
<thead>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaS cript">
document.write( "<div style='backgrou nd: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM OClTesta WHERE (IdOrdCli = ::IdOrdCli::)"
fp_sDefault="Id OrdCli="
fp_sNoRecords=" <tr><td colspan=1 align=""LEFT"" width=""100%""> No records
returned.</td></tr>"
fp_sDataConn="O rdini"
fp_iMaxRecords= 256
fp_iCommandType =1
fp_iPageSize=0
fp_fTableFormat =True
fp_fMenuFormat= False
fp_sMenuChoice= ""
fp_sMenuValue=" "
fp_sColTypes="& NrOrClInt=200&N rOrClEst=200&Dt aOrdCli=135&Dta PrevCon=135&Dta C
onConf=135&Clie nte=200&Lingua= 200&NsRif=200&V sRif=200&CondPa g=200&PagNonStd =
200&Listino=200 &BancaCli=200&B ancaDitta=200&S edeDoc=200&Sede Eff=200&NettoIV A
=200&Divisa=200 &DtaFixing=135& FixingManuale=2 00&Fixing=5&Are a=200&Agente=20 0
&CalcProvv=3&Ma turaz=3&PrcMatA DF=5&CapoArea=2 00&Nota=200&Mod Con=200&RegIVA= 2
00&CauMov=200&B ollett=200&Depo Fase1=200&SpecF ase1=200&DepoFa se2=200&SpecFas e
2=200&GiaConseg n=200&GiaFatt=2 00&Stampato=200 &UsaAnnoC=200&O rdAnn=200&IdOrd C
li=3&Commessa=2 00&Centro=200&L istinoDaDtaCons =200&DataValLis t=135&ConsegnaU n
ica=200&CCDitta =200&Presentaz= 3&DtaConTass=13 5&LastSubId=3&C odCliFatturazio n
e=200&Priorita= 2&SedeMerce=200 &CodAutBancaria =200&SegueFattu ra=200&ClcRateD a
=135&ImportoPro vvigioneAgenteT ot=5&ImportoPro vvigioneCapoare aTot=5&ImportoB a
seAgente=5&Impo rtoBaseCapoArea =5&PercProvvAge nte=5&PercProvv CapoArea=5&Impo r
toProvvAgenteAu to=200&ImportoP rovvCapoAreaAut o=200&CalcoloPr ovvCapoArea=3&P e
rcProvvAgenteAu to=200&PercProv vCapoAreaAuto=2 00&TipoCliFor=3 &TipoSpecificat o
reFase1=3&TipoS pecificatoreFas e2=3&CodicePoli ticaAgente=200& CodicePoliticaC a
poArea=200&"
fp_iDisplayCols =1
fp_fCustomQuery =False
BOTID=1
fp_iRegion=BOTI D
%>

<tr>
<td><b>RESIDU O D'ORDINE N°
<%=FP_FieldVal (fp_rs,"NrOrClI nt")%></b></td>
</tr>

</tbody>
</table>

<table width="97%" border="0" cellspacing="0" >
<thead>
<tr>
<th ALIGN="LEFT" bgcolor="#CCCCC C" style="border-bottom: 1px solid
#000000; padding-left: 4px; padding-right: 4px" width="15%">
<b>Articolo</b></th>
<th ALIGN="LEFT" bgcolor="#CCCCC C" style="border-bottom: 1px solid
#000000; padding-left: 4px; padding-right: 4px" width="41%">
<b>Descrizion e</b></th>
<th ALIGN="LEFT" bgcolor="#CCCCC C" style="border-bottom: 1px solid
#000000; padding-left: 4px; padding-right: 4px" width="12%">
<p align="right">
<b>Quantità</b></th>
<th bgcolor="#CCCCC C" style="border-bottom: 1px solid #000000;
padding-left: 4px; padding-right: 4px" width="21%">
<p align="right">Q .tà consegnata</th>
<th ALIGN="LEFT" bgcolor="#CCCCC C" style="border-bottom: 1px solid
#000000; padding-left: 4px; padding-right: 4px">
 </th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaS cript">
document.write( "<div style='backgrou nd: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM OClRighe WHERE (IdOrdCli = ::IdOrdCli:: AND TipoRiga
= ::TipoRiga:: AND GiaConsegn = '::GiaConsegn:: ' AND GiaFatt =
'::GiaFatt::' AND RigaAnn = '::RigaAnn::') ORDER BY Riga ASC"
fp_sDefault="Id OrdCli=&TipoRig a=3538947&GiaCo nsegn=0&GiaFatt =0&RigaAnn=0"
fp_sNoRecords=" <tr><td colspan=4 align=""LEFT"" width=""100%""> No records
returned.</td></tr>"
fp_sDataConn="O rdini"
fp_iMaxRecords= 256
fp_iCommandType =1
fp_iPageSize=0
fp_fTableFormat =True
fp_fMenuFormat= False
fp_sMenuChoice= "Articolo"
fp_sMenuValue=" Articolo"
fp_sColTypes="& Riga=2&Posiz=2& TipoRiga=3&Desc ri=200&NoRipSta m=200&NoRipBoll a
=200&NoRipFatt= 200&Articolo=20 0&Variante=200& Cliente=200&Dta OrdCli=135&Repa r
to=200&UnMis=20 0&Quantita=5&Qt aAcc1=5&QtaAcc2 =5&QtaAcc3=5&Qt aAcc=5&ValUnit= 5
&Imponibile=5&C odIVA=200&Total e=5&Sconto1=5&S conto2=5&Sconto Formula=200&Imp S
conto=5&DtaPrev Con=135&DtaConC onf=135&QtaGiaC ons=5&QtaGiaFat t=5&TipoVend=3& N
rColli=2&UnMisC olli=200&PesoLo rdo=5&PesoNetto =5&Cubaggio=5&G iaConsegn=200&G i
aFatt=200&RigaA nn=200&IdOrdCli =3&NrKitDoc=2&Q taKit=5&Commess a=200&Centro=20 0
&PercProvv=5&Pr ovCapoarea=5&Sc ontoAge=5&CatPr ovv=200&IDSchem a=3&NrSchema=20 0
&RigaSchema=2&C ntprt=200&QtaPr enotata=5&ImpPr ovAge=5&SubID=3 &ArticoloDistin t
a=200&DepoFase1 =200&DepoFase2= 200&SpecFase1=2 00&SpecFase2=20 0&RifRigaEst=2& N
rLottoCli=200&R ifIDDocEsterno= 3&RifNrDocEster no=200&RifIDOff erta=3&RifSubID O
fferta=3&RifOff erta=200&Nota=2 00&ImportoBaseA gente=5&Importo BaseCapoArea=5& I
mportoProvCapo= 5&CatProvvCapoA rea=200&Percent ualeProvvigione Auto=200&Percen t
ualeProvCapoare aAuto=200&Impor toProvAgeAuto=2 00&ImportoProvC apoAuto=200&Cat P
rovvAgeAuto=200 &CatProvvCapoAu to=200&"
fp_iDisplayCols =4
fp_fCustomQuery =False
BOTID=2
fp_iRegion=BOTI D
%>

<tr>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px" width="15%">
<a title="VERIFICA DISPONIBILITA'"
href="magazzino .asp?Articolo=< %=FP_FieldURL(f p_rs,"Articolo" )%>">
<img border="0" src="info.gif" width="16" height="16"></a>
<%=FP_FieldVal (fp_rs,"Articol o")%> </td>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px" width="41%">
<%=FP_FieldVal (fp_rs,"Descri" )%></td>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px" width="12%">
<p align="right">
<%=FP_FieldVal (fp_rs,"Quantit a")%></td>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px" width="21%">
<p align="right">
<%=FP_FieldVal (fp_rs,"QtaGiaC ons")%></td>
<td style="border-bottom: 1px solid #000000; padding-left: 4px;
padding-right: 4px">
 
</td>
</tr>

</tbody>
</table>

</body>

</html>

Jul 19 '05 #1

Subscribe Reply

1818

Similar topics

1668

Troubles w/ mysql installation, "create" cannot make innodb

by: niku | last post by:

Hello all. I'm trying to get mysql installed on OpenBSD 3.4. Unfortunately, it appeares that the port only installes the mysql-client, and one needs to install the -server package seperately. This would be fine with one exception, there is a dependency that breaks when installing from ports. This lead me to install from source, and now I'm having problems just getting mysql to start. If anyone could look at the error message below, and...

MySQL Database

2295

How to make reference from a xml file to another xml file

by: moonriver | last post by:

In a xml file, can we make reference to another xml file so that all contents of the latter xml file will be included into the first xml file? Had better give me an example for details.

C# / C Sharp

4217

How do you make all public classes of a web service accessible from client?

by: Burak | last post by:

Hello, I have a web service that has a two user defined public classes. For sake of brevity, I'll write them as follows Public Class Service1 Public Class Class1 Public x as integer End Class

.NET Framework

17338

Make Thread-Safe Calls to Windows Forms Controls

by: Alexander Walker | last post by:

Hello I want to get the value of a property of a control from a thread other than the thread the control was created on, as far as I can see this is not the same as invoking an operation on a control on a different thread I have used the following code as per the guidance in the msdn documentation to invoke an operation on a control from a thread other than which it was created delegate void SetFormCursorCallback(Cursor cursor);

C# / C Sharp

5931

HOWTO: Make DDL changes?

by: Ian Boyd | last post by:

Every time during development we had to make table changes, we use Control Center. Most of the time, Control Center fails. If you try to "undo all", it doesn't, and you end up losing your identity seed, or your constraints, or your triggers, or your table. Talking to developers at other companies who have had the misfortune of using DB2, they are adamant that you cannot use the tools; they are buggy and you just have to resign yourself to...

DB2 Database

1631

everytime I read this it make me mad

by: John Harrison | last post by:

This is from SGI's FAQ, its the justification for why list<T>::size() is linear time in their library (and in gcc library too since their code is based on SGI) <quote> Why is list<>::size() linear time? The size() member function, for list and slist, takes time proportional to the number of elements in the list. This was a deliberate tradeoff. The only way to get a constant-time size() for linked lists would be to

C / C++

3515

I need form dependency with dropdown menu !!!!

by: deephill | last post by:

hi i need form dependency. Can u check below code? <p>1. Are you married?</p> <p>

Javascript

2114

many "or" operation make system choose incorrect index

by: lsllcm | last post by:

Hi All, I have one question about many "or" operation make system choose incorrect index There is one table TT ( C1 VARCHAR(15) NOT NULL, C2 VARCHAR(15) NOT NULL, C3 VARCHAR(15) NOT NULL, C4 VARCHAR(15) NOT NULL

Microsoft SQL Server

970

How do I not make a list?

by: Just Another Victim of the Ambient Morality | last post by:

It may sound like a strange question but that's probably only because I don't know the proper terminology. I have an iterable object, like a list, and I want to perform a transform on it (do an operation on each of the elements) and then pass it onto something else that expects and iterable. I'm pretty sure this something else doesn't need a list, either, and just wants to iterate over elements. Now, I could just make a list, using a list...

Python

3717

How to make this program more efficient?

by: Bill David | last post by:

SUBJECT: How to make this program more efficient? In my program, a thread will check update from server periodically and generate a stl::map for other part of this program to read data from. Let's name the update method as doUpdate and stl::map read methods as getData and copyData. Since stl::map is not thread-safe, we should do synchronization by ourselves. A usable solution is to create a boost::mutex::scoped_lock object in all above...

C / C++

8944

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8773

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9445

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9306

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9180

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8186

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6733

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6030

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4548

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration