thank u bai , i will must use this code and then tell u result.
On Sep 21, 6:58 pm, "mushtaq ilyas" <[EMAIL PROTECTED]> wrote:
> look shani if u want to get the average or sum of the data u can don in this
> way for eg u can copy this code and paste in notepad or microsoft front page
> for asp applications usually i like to comment what i am doing in my code it
> is a good coding practice for you
> to remember what you done in the code for future upgradations
>
> <%@ Language="vbscript"%>
>
> <%
> 'decalre some variables here
> '-------------------------------------------------
> dim amt
>
> 'declare connections and recordset objects
> '-------------------------------------------------
> set ASConn = Server.CreateObject("ADODB.Connection")
> Set asRS = Server.CreateObject("ADODB.Recordset")
>
> '--------open connections-----------------------------
> ASConn.Open = "DSN=Your Dsn Name;Uid=rocky;Pwd=abcXYZ"
> ASConn.CommandTimeout = 0
>
> strSQL = "SELECT * FROM Emp"
>
> asRS.Open strSQL,ASConn
>
> Do While Not asRS.EOF
>
> If asRS("Cnty") = "USD" Then
>
> amt = cdbl(asRS("Sal")) + cdbl(asRS("Comm"))
>
> asRS.MoveNext
> else
>
> amt = cdbl(asRS("Sal"))
> Loop
>
> Response.Write "Records Inserted Successfully.."
>
> '--------Close connections---------------
>
> ASConn.Close
> asRS.close
> set asRS = Nothing
>
> %>
>
> I hope this is what u need always declare some varialbe and do ur operations
> accordingly .if u need further assistance just reply me back
>
> Bye and Take Care
>
> Mohammed Mushtaq Ilyas
>
> Software Developer
>
> Dubai.U.A.E
>
>
>
> On Sun, Sep 21, 2008 at 7:03 AM, shani <[EMAIL PROTECTED]> wrote:
>
> > thank u mushtaq bhai , my problem is that when i get any data from
> > database through recordset ,i only can display it on web page .for
> > example that was numaric data .and i want to get the total or average
> > of that data ..etc i mean how can i apply such opperrations on that
> > data. ( i m not expert person so please describe in easy manner )
> > thank u.
>
> > On Sep 18, 11:33 pm, "mushtaq ilyas" <[EMAIL PROTECTED]> wrote:
> > > Hi shani
> > > Can you be a little bit more precise what exactly you want to know so
> > that i
> > > can help you
>
> > > On Thu, Sep 18, 2008 at 4:36 PM, shani <[EMAIL PROTECTED]> wrote:
>
> > > > i m new person .i m making a web page wich can show result card .but i
> > > > can not manage valus of variables . can i work with recordset as
> > > > variable and control statments .please tell me .how can i do . thank
> > > > you.- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
