ASP On Loaded

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - How to get the percentage amout of a file being loaded ? Hi All, i'm trying to display the amout in percentage for the loading sub event value, for the <img .../> example: the browser should display something like this: view 1, time 00:00:05 loading 5% ==================== view 2, time 00:00:010 loading 10% ==================== view 3, time 00:00:57 loading 99% ==================== view 4, time 00:01:00 complete 100%  ==================== i have this code: <script language="vbscript"> Function showState_onready() IF myImgID.readyState = "loading" then myDivID.innerText = myImgID.readyState & " " & strPerventage Else myDivID.innerText = myImgID.readyState & " " & "100%" End If End Function </script> <html> <head></head> <body> <div id="myDivID"></div> <img id="myImgID" src="img.jpg" onreadystatechange="vbscript:showState_onready('')" /> </body> </html> i'm trying to display the image amount of the file loaded in percentage, how do i do it? Tag: ASP On Loaded Tag: 326929
  - 2
    - Problems with encoded mailto-link in combination with outlook Hello all out there! I don't know if this is the correct group for posting this, please correct me/it, if you have a better group for it... We have a customer who uses utf-8 encoded websites and wants mailto-link on some websites with integrated subject/content. Website is written in ASP (.NET is not available at customer site). So according to RFC (as far as I could interpret it), we created a mailto-link like this mailto:assistencia.tecnica@pt.bosch.com?subject=%3D%3Fiso%2D8859%2D1%3FQ%3FPenso_que_dever=e1_ser_a_Assist=eancia_T=e9cnica_a_definir_qual_o_prefixo_a_aparecer_neste_campo.miniMAXX_pilhas%3F%3D&body=%3D%3Fiso%2D8859%2D1%3FQ%3FAnomalia:Aparelho_n=e3o_efectua_igni=e7=e3o._Igni=e7=e3o_lenta_e_dif=edcil.%3F%3D What shows up in Outlook instead of encoded strings is that: Subject =?iso-8859-1?Q?Penso_que_dever=e1_ser_a_Assist=eancia_T=e9cnica_a_definir_qual_o_prefixo_a_aparecer_neste_campo.miniMAXX_pilhas?= Content =?iso-8859-1?Q?Anomalia:Aparelho_n=e3o_efectua_igni=e7=e3o._Igni=e7=e3o_lenta_e_dif=edcil.?= In Thunderbird everything shows up correctly, but in outlook we have these encoded lines with the encoding displayed. Also tried Server.URLEncode() for the parts between &subject= and &body= till end, but shows up the same. -- CEB-Systems GbR Sudetenstrasse 6 60437 Frankfurt Tag: ASP On Loaded Tag: 326925
  - 3
    - request retrurns empty variable. Hi all, On my asp form I have the simple code as below. The idea is that I check the client browser version and store it in BTYP. If I make BTYP a text input I can see the value OK. When I submit and request BTYP from l0008ps.asp I get an empty variable. How do I hold my mouth while doing this. **********firstpage.asp <head> <script language="javascript"> function checkOK( thisform ) { { return true } } function checkBT() { if (navigator.appName == "Microsoft Internet Explorer" && navigator.appVersion.indexOf(MSIE6) != -1) { return true } else { if (navigator.appName == "Netscape" && navigator.appVersion >= "4.0") { return true } else { return false } } } </script> </head> <body> <input type="hidden" name="BTYP" size="10" maxlength="10" border="1" bordercolor="#000000" width="40%"> <form method="post" width="800" action="l0008ps.asp" onsubmit="return checkOK(this)"> //rest of code <script language="javascript"> var brow= checkBT(); if ( brow == true ) { BTYP.value=1; } else { BTYP.value=0; } </script> </body> *****************l0008ps.asp <% ubt=request("BTYP") %> Tag: ASP On Loaded Tag: 326919
  - 4
    - No data return from ASP but Access returns correctly. When in access the SQL Statement works as expected; in ADO it does not. I have replaced the * with the % so I am sure that's not the problem. Anyone have any idea? <% Dim objConn, objRS, sCity,CONNECTIONSTRING,ReponseString CONNECTIONSTRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\jturlington\Desktop\Demographics\App_Data\DemoGraphics.mdb;User Id=admin;Password=;" 'Capture the username that we need to lookup, making sure its prepared for 'our forthcoming SQL query sCity = Replace(Trim(Request.QueryString("city")),"'","") 'Fire up ADO - ask the database whether or not the user idexists Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open CONNECTIONSTRING sSQL = "select ID,GeographicArea from Data where GeographicArea like '%uni%'" response.Write(sSQL & "<br />") Set objRS = objConn.Execute(sSQL) WHILE NOT objRS.EOF ReponseString = objRS("ID") & "=" & objRS("GeographicArea") & "," objRS.MoveNext WEND Response.Write(sCity & " ") If Len(ResponseString) > 1 Then Response.Write(Left(ResponseString, Len(ResponseString) - 1)) Else Response.Write("No Records") End If 'Clean up objRS.Close objConn.Close Set objRS = Nothing Set objConn = Nothing %> Tag: ASP On Loaded Tag: 326917
  - 5
    - File System Object and displaying data Hello All I used to have some static htm files which used to display data. There is a calling asp file which used to do something like below if Request.QueryString("PageName").count = 0 then strPageNameHtm = "toc.htm" strPageNameInc = "toc.inc" else strPageNameHtm = Request.QueryString("PageName") & ".htm" strPageNameInc = Request.QueryString("PageName") & ".inc" end if strPageNameHtm = server.mapPath(strPageNameHtm) strPageNameInc = server.mapPath(strPageNameInc) 'response.write(strPageNameHtm) set fs = server.createobject("scripting.fileSystemObject") set f = fs.openTextFile(strPageNameHtm) strSPDHtml = f.readall The strSPDHTML info used to be displayed using a response.write(strSPDHTML). This allowed the static content to be loaded up. I switched the static pages to be asp pages having the content come from a database. I would still like to maintain the controlling page logic. Can I modify the above section of code in anyways to access the asp page content Tag: ASP On Loaded Tag: 326913
  - 6
    - Problem accessing database from within a folder... I have a happily working set of asp pages which read from the database via include file "./_private/include/database.mdb". However, when I try to gain access to this database on pages one folder removed using "../_private/include/database.mdb", the pages won't display. This whole system works fine on my home test server (iis.5.0), but 'breaks' when uploaded to the public server. I know the path to database is correct because the upper level pages are displaying without problem. I am utterly perplexed and any suggestions would be welcome. I'm using Acess database. Thank you Tag: ASP On Loaded Tag: 326888
  - 7
    - Simple query returns 0 records in asp, but all records in vbscript I have a few vbscripts that I want to convert to asp pages so I can use html to format the data better. 1). Do asp pages have to be run from an IIS server or can I just create them locally and then open them in IE? 2) The following connection strings, accounts and queries work fine in vbs files but I am getting 0 results when I run them as asp. I don't know how to debug them to figure out the issue here is the code <%@ language="VBSCRIPT" %> <html> <head> <meta name="GENERATOR" content="SAPIEN Technologies PrimalScript 4.0"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>CFG site</title> </head> <body> <% Dim objConnection, dsn Set objConnection = CreateObject("ADODB.Connection") objConnection.Open "Provider=SQLOLEDB;Data Source=servername;" & _ "Trusted_Connection=Yes;Initial Catalog=edfcm4;" & _ "User ID=user;Password=password;" Set rs=objConnection.Execute ("SELECT machine_name FROM ecm_dat_machines") %> <table border="1"> <% Do While Not rs.EOF %> <tr> <td><%= rs.Fields("ecm_dat_machines.machine_name")%></td> </tr> <% rs.MoveNext Loop %> </table> <% Set objConnection = Nothing %> </body> </html> Tag: ASP On Loaded Tag: 326886
  - 8
    - Beautiful women, aged clones, and Ultimate Fighting Championship Friend, I'm always looking for good and intelligent individuals like you to visit my website, www.ChezBrandon.com , and it has pictures of beautiful women, information about aged clones, and a link to Ultimate Fighting Championship, a very good show. My name is Brandon, and I'm in my 20s, am a college student, and as lie detectors, both conventional and unconventional would show, I've never been sexually penetrated. Moreover, I could be shown pictures of X, Y, and Z, and it would show that I'm only sexually attracted to women. The Murders of Our Leaders in Government were Stopped. I, Brandon, can take lie detector and psychological tests, and I can go before a panel of truth detecting experts. I tell the truth. A mini-psychological test: 8 times 2 = 16, the world is round, not flat, and the year is 2006. Feel free to call me, my cellphone number is 503.740.0272 (United States based) and feel free to utilize a GK-1 voice truth detecting device too: >From Congressmen Bill Frist to John Kerry to Dennis Hastert to Hillary Clinton to John Warner to Ron Wyden to Gordon Smith to John McCain to Joseph Lieberman to Nancy Pelosi to Diane Feinstein to Ted Kennedy to anyone else who happened to be in the Congressional chambers during either a joint session of Congress or a State of the Union address from Masons to Skull and Bones members to Secret Service agents to pages to visitors to other good individuals, they all would have been murdered, all of their accomplishments stripped away, their earned wealth stripped away, their homes stripped away, their family and friends stripped away. Moreover, someone else would have been sleeping with their spouses. Elements of the Mossad, who wanted to bathe in the blood of our Congressmen as well as bathe in the blood of leaders on the Federal and State levels and leaders around the world, and when these elements seized power they would, as confirmed by psychic vision and confirmed auditorially, "he's right; he's psychic," would outlaw most if not all organizations, including the Masons, and these elements as Victor Ostrovsky writes about in his #1 New York Times bestseller By Way of Deception are out of control, notoriously lie, and have a disregard for life -- I was able, thank God, to thwart the conquest of the USA and the world, and was able to thwart the murder of United States and world leaders, via a psychic vision of Senator John Warner and other Congressmen being choked to death by gas, which was confirmed auditorially from both ears, such as "He saved Congress," who they were going to kill "all of them,""how did he know that?" and "he's psychic" -- murdered my biological Aunt Gloria Atkinson, whom I loved very much, as she did of me, and there is a tribute to her on my website. Please, friend, be sure to barricade your bedroom door at night. I'm not afraid of aged clones or the attempted chopping off of my appendages (elements of the Mossad talked about chopping off my right middle finger and right ear, and 10 out of 10 of my toes, like my right middle finger have unique steeple designs). I'm not afraid of anything. I'll defend myself to the best of my ability, and I commit my life to saving the lives of men, women, and children and strengthening good organizations. I will always remember my biological Aunt Gloria Atkinson. Sincerely, Brandon Tag: ASP On Loaded Tag: 326880
  - 9
    - checkbox to insert data Quick question. Is it possible to insert values in a Database with a checkbox? Say I have a recordset and if the check box is checked I want to insert the value of the of the field in the DB. <%=rsqa.Fields.Item("recini").Value%> That is a persons initials, i want to insert those initials in a column if it is checked, if it isnt checked nothing is inserted.. Tag: ASP On Loaded Tag: 326879
  - 10
    - How to change the default "Update" in a DetailsView Using a DetailsView to update data in SQL 2005, How do I change the default "Update" hyperlink to a more user friendly button? Thanks Tag: ASP On Loaded Tag: 326877
  - 11
    - Using a stored procedure to return multiple recordsets with .Filter support I have a stored procedure which returns 2 tables and 1 output value. I want the first table to be assigned to rs1 and the second to rs2. However when I run this, I get the following error as I begin to refer to the rs2 recordset (Do while not rs2.eof). I have even used 2 ".execute" statements in the code below, but the code assigns the first recordset twice. Microsoft VBScript runtime error '800a01a8' Object required: 'rs2' /output.asp, line 166 How can I assign the two tables to the appropriate recordsets? Also, I need the .MoveFirst method support, and if possible, the .Filter method. The code for calling the Stored Procedure is below ' -------------------------------------------------------------------------------- Set rs1 = Server.CreateObject("ADODB.Recordset") Set rs2 = Server.CreateObject("ADODB.Recordset") Set adocmd = Server.CreateObject("ADODB.Command") adocmd.CommandTimeout = 120 adocmd.ActiveConnection = conn adocmd.CommandType = adCmdStoredProc adocmd.CommandText = "dbo.spr_MyProcedure" With adocmd set param = .createparameter("@searchstring", adVarchar, adParamInput, 40, guid) .parameters.append param set param = .createparameter("@numvalues", adInteger, adParamOutput) .parameters.append param On Error Resume Next errorstring = "" errornumber = 0 set rs1 = .execute set rs2 = rs1.NextRecordset '-- check the return value If Err.Number <> 0 Then errorstring = "<p>Error Number " & Err.Number & "<br>" & "The Error Code was: " & Err.Description & "</p>" errornumber = Err.Number Response.Write(errorstring) Response.Redirect(HomePath & "/error.asp?eid=unknown") End If numvalues = .Parameters("@numvalues").Value End With On Error GoTo 0 set adocmd = nothing ' -------------------------------------------------------------------------------- Thank You, Julian Tag: ASP On Loaded Tag: 326874
  - 12
    - How do i call a function defined in html script tags from asp page? Hi All, i have this.asp page: <script type="text/vbscript"> Function myFunc(val1ok, val2ok) ' do something ok myFunc = " return something ok" End Function </script> <html> <body> <% val1ok = something1 val2ok = something2 thenewVal = myFunc((val1ok), (val2ok)) %> </body> </html> i want to call and use the returned value of Function myFunc(val1ok, val2ok) , without omitting the html script tags and replacing them in <% %>, (My Question is:) How do i call a function defined in html script tags from asp page? Tag: ASP On Loaded Tag: 326863
  - 13
    - Mobile Phone plan calculator Hi guys, I'm working on my first ASP web site. The idea of the site is to calculate which mobile phone plan is right for you. The idea is that the user answers a few questions about their calling habits, and the server calculates the ammount of talk time for each plan and then recommends on or two. I've created 2 excell sheets already. One is a user input sheet, the other is a database of all the plans available. At the moment the excell sheet works like this. The user selects a rate plan, enters in their details and calling habits, and a total talk time is displayed on the bottom of the page. I want to go one step further. I want the ASP page im working on to calculate the total talk time for ALL the plans in my database (based on the users input) and then recommend the 3 with the most talk time. As you can probably tell, I'm completely lost. All of the tutorials I've seen are simple "add this to, delete this from" database blah blah. I need help! :) Psy Tag: ASP On Loaded Tag: 326859
  - 14
    - input box Hi, I have an input box that sends data over to the next page. This input box was in a loop, there creating data looking like this: 2, 0, 0, 3, 0, 4, 0, 22, 0, 0, 0 How do i break the data up in such a way that i can populate it into my db while running through a recordset? Any help would be highly appreciated. Thanx Tag: ASP On Loaded Tag: 326856
  - 15
    - Accessing network resources via classic ASP I would like for server-side VBscript code to save a file to a remote server's network share. I've noticed that the exact code that would run from the command prompt does not get access to files on remote disks via ASP. Is there a workaround? Do you know if ASP.Net has a solution? Thanks in advance! Tag: ASP On Loaded Tag: 326852
  - 16
    - Update Multiple Records How do I update multiple records in a table in ASP using loops ? For example. I have a table with the following colums ID | Col1 | Col2 ------------------------- 1 | 50 | 100 2 | 25 | 130 3 | 55 | 70 I want to add *66* and *77* into the ID # *1* and ID # *3* respectively. So the result should be ID | Col1 | Col2 ------------------------- 1 | 116 | 177 2 | 25 | 130 3 | 121 | 147 Note: All datatype of the colums are integer -- cancer10 ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: ASP On Loaded Tag: 326850
  - 17
    - asp.net problem Hi I have an asp.net 2.0 project and am experiencing a problem. In the project, I am trying to make use of Membership. I have one Role, called "Basic User" and two users - "admin" and "test". "admin" is a member of the Role but "test" is not. I have only a few pages in the project at the moment: - . SecurePage.aspx - The page I want only authenticated users that are members of the Role to use. . Login.aspx - Login page . Unauthorized.aspx - Informs user that they cannot view the secure page because of a lack of permissions SecurePage.aspx just contains a ChangePassword control. Unauthorized.aspx has some text and a LoginStatus control. So in the SecurePage.aspx, I have this code to handle this: - Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) If User.Identity.IsAuthenticated = False Then Server.Transfer("login.aspx") End If If Roles.IsUserInRole("Basic User") = False Then Server.Transfer("unauthorized.aspx") End If End Sub If I go to the SecurePage and am not authenticated, it transfers me to login.aspx. If I then login with the user "admin", which is in the Role "Basic User", it works ok. If I first login with "test", which is NOT in the Role, then I am transfered to the "unauthorized.aspx" page. However, if I click "Logout" on the LoginStatus control on the "unauthorized" page it refreshes and changes to display "Login". So, if I then click "Login", I am taken back to the login page. The URL in the address bar at this point is: - http://localhost:1489/Lesson09/login.aspx?ReturnUrl=%2funauthorized.aspx If I then login with using "admin" - which is a member of the Role - this is where I get a problem. Instead of being taken to the SecurePage.aspx as expected, I get taken back to the "unauthorized.aspx" page. This is obviously wrong. Now, I know that this should work but does anybody know why it is not working? Is there some settings or something I need to change on my PC? Am I missing a step or not doing something? I've checked the obvious things - like that the user was actually in the Role etc. However, I just cannot get this to work. I am new to ASP.Net and so I don't really know where to start to look for what the problem is? I have gone through re-doing the project twice now and I still get the same problem. For info, I am using: - - Visual Studio .Net 2005 (Professional) (up to date) - Latest .Net installed - Windows XP Pro - Internet Explorer 6 (version 6.0.2900.2180.xpsp_sp2_gdr.050301-1519) SP2 I would very much appreciate any help or advice on this problem. Thanks in advance. Kind regards Darren Brook email: darrenbrook@btconnect.com Tag: ASP On Loaded Tag: 326845
  - 18
    - asp does not find table I must have forgotten someting. I did something like this about 4 years ago and got it to work. Now I need to do it again and I get this error message: Technical Information (for support personnel) a.. Error Type: Microsoft JET Database Engine (0x80040E37) The Microsoft Jet database engine cannot find the input table or query 'verify'. Make sure it exists and that its name is spelled correctly. /meddir/verifyreturn.asp, line 35 b.. Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322) c.. Page: POST 50 bytes to /meddir/verifyreturn.asp This is my code, does anyone see where I've made my mistake. My table is at this physical location on the server (win 2000, latest service pack, IIS 5): d:\Inetpub\namcp.org\fpdb\verify.mdb This is my data.asp file: <% strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" &_ "Data Source=d:\Inetpub\namcp.org\fpdb\verify.mdb;" &_ "Persist Security Info=False" %> This is my script that generate the error message from above: <% Option Explicit Dim strConnect %>  <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 6.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 1</title> </head> <body> <% Dim objconn, objrs Dim lcsql, strName, strEmail, strPassword, strCookie1, strCookie2 Set objconn = Server.CreateObject("ADODB.Connection") Set objrs=Server.CreateObject("ADODB.Recordset") objconn.open strConnect strEmail = request.form("Email") Session("Email") = strEmail strPassword = request.form("password") Session("UserPassword") = strPassword 'lcsql="select * FROM verify WHERE Email = '"+request.form("Email")+"' and password = '"+request.form("password")+"'" lcsql="select * FROM verify WHERE Email = 'terry@windigo.com'" objrs.Open lcsql,objconn,0,1,1 If objrs.EOF then %> <Script Language=VBscript> ReturnItem = msgbox( "Either your name or password was incorrect, try again.", vbOKOnly, "INCORRECT ENTRY") </Script> <% else Session("LoggedIn") = "StartUp" 'Session("JobType") = objrs.fields("JobType") 'Session("IDNumber") = objrs.fields("Password") Server.Transfer "Index_Copy(2).htm" end if objrs.Close objconn.Close Tag: ASP On Loaded Tag: 326838
  - 19
    - DATABASE ACCESS I am trying to create a unique type of registration form for my job upcoming Holiday Christmas Party. There will be 60 tables for seatings with 10 people max at table. How can I write some codes to support this? I need to be able to see the number of people who are seating and any available seats at a given table. How can I set my database and pull the information to give what I want. Tag: ASP On Loaded Tag: 326837
  - 20
    - Global Objects inside User Controls? [note: I am relatively new to ASP.NET, so I'm very possibly doing something stupid or overlooking something obvious. Please be forgiving, and walk me through your answer as much as possible. Much appreciated.] Here is the situation. I'm developing an application where: I have defined a class (DBClass) to provide an abstraction layer for interacting with a database. When an instance of the class is created, it creates a connection to the database. My initial plan was that, at the very top of each page I would: 1) include the DBClass class file, so the page knows about the class 2) create an instance of DBClass, which I call DB. My thought was, once the DB instance was created, I would be able to use it anywhere on the page. However, on the page I am also making use of a "user control". This user control has to have access to the database. When I simply reference DB in the control file, the compiler complains, because I have not created the instance DB in the control file. I'm sure I'm probably just approaching this the wrong way or leaving out something obvious.... can anyone help? ---G Tag: ASP On Loaded Tag: 326834
  - 21
    - Auto Incrementing number display on form submit I dont know if this is possible or if someone has a better way to do this but here it is: I have a page where the user enters an rma#, lot#, and number of barcodes they need to print, here is the code for the results page that shows the barcodes to print: <% RMABarCode = Request.Form("idrma") NoTimes = Request.Form("NoTimes") If Len(RMABarCode)>0 Then If IsNumeric(NoTimes) Then For i = 1 to NoTimes response.write "<div><img src='barcode.asp?code=" & RMABarCode & "&height=25&width=1&mode=code39'></div>" & Request.Form("idrma") & "-" & Request.Form("idlot") & "<p></p>" Next End If End If %> So if the user entered rma# 1234, lot#1, and number of barcodes(NoTimes) 3 it displays (barcode) ** being the physical barcode ** 1234-1 ** what is displayed under the barcode ** (barcode) 1234-1 (barcode) 1234-1 What i need to add is that each barcode has a unique number. What i need it to display is: (barcode) 1234-1(1) (barcode) 1234-1(2) (barcode) 1234-1(3) The number of barcodes needed(NoTimes) is also going to be the unique identity of the barcode... Does that make sence?? If so, can it be done?? Thanks in advance. Respectfully, Danny Tag: ASP On Loaded Tag: 326830
  - 22
    - filter results to display those older than 'today'? I've been going round in circles here trying to get this to work and my ignorance of ASP is now showing me up. I want to construct a query string to allow me to filter entries to be displayed on a web page with respect to the date-entry contained in the database. i.e. an archived results page will show all entries where "my_date" is less than 'todays date' I have tried to do this by; Dim strSQL Dim showdate showdate = Date then... strSQL = "Select * FROM my_database WHERE my_date <" & showdate Although this does give a result, it has no actual bearing on todays date and wondered what strinkingly obvious this I'm doing wrong? when I use > i get all results displayed, when i use < I get none at all. thanks for any help Tag: ASP On Loaded Tag: 326823
  - 23
    - Cross Domain Cookie? By IP Perhaps? Guys, Anyone know of a way to allow a cookie to be read by multiple domains, or even better a specific IIS server IP? We're looking to track users across multiple domains within our website group, appreciate any help? Cheers, @sh Tag: ASP On Loaded Tag: 326822
  - 24
    - run excel I want to run excel in server. Server have IIS and MS SQL. My plan is, get data from MS sql and attach it in excel and run macro(vba) get result and save it as htm in server. I know it's weird, but I can run it in excel and don't want to write code again. (actually have no idea). So, my question is, load excel and run it (vba). possible? Thank you. Tag: ASP On Loaded Tag: 326820
  - 25
    - Sending files from Servlet/JSP page to ASP Page Hi everyone, I want to transfer a file from servlet page or JSP to an ASP page. Since the two pages are in different server (WAS and IIS), I cannot just send file path to the ASP page and let it retrieves the file itself. If i path file paths's to servlet/JSP it should send those files to ASP page on different server(IIS) for processing.I don't want to use file input type ="File" for selecting the file to upload,i want it to happen in background. I want the ASP page can get the file and then process it. Do you guys know how to do it? If any of you know, please reply. I really appreciate it. Srini Tag: ASP On Loaded Tag: 326815
- Next
  - 1
    - validating input boxes This is really starting to annoy me, I've got a form, that has some input boxes, a example of the code is here:- <form action="admin_save_stock.asp" method="post" name="MyFormData"> <input name="Make" type="text" id="MenuText" value=<% response.write rsTable("Make") %> size="50" maxlength="50"> <input name="DateBought" id="MenuText" type="text" value=<% response.write rsTable("DateBought") %> size="10" maxlength="10"> </form> I also have a FUNCTION that checks to make sure the dates etc are correct :- But, the code will work as far as giving me the error MSGBOX but it still posts to the next page for some reason its ignoring the " MyFormData_OnSubmit = False " Why ? <Script language="vbscript"> Function MyFormData_OnSubmit() Dim FormOkay FormOkay=True if isdate(MyFormData.DateBought.Value)=False then msgbox "Error in date", vbokayonly+vbinformation,"Checking Data" MyFormData.DateBought.SetFocus FormOkay=False end if if FormOkay=False then MyFormData_OnSubmit = False else MyFormData_OnSubmit = True end if end Function </Script> thankls Mike. Tag: ASP On Loaded Tag: 326805
  - 2
    - Generate Email from Form Submission I have a form on my ASP 3.0 web site and I need to monitor submissions. Is it possible to generate an email upon form submission? If so, how do I invoke the email functionality from an ASP 3.0 page? Thanks Dave Tag: ASP On Loaded Tag: 326798
  - 3
    - How do I get the parameter and value of clients web browser temporary system path? Hi All, myGetImage.asp is suppose to create a temporary file in the client side, and display in on the client web browser. myGetImage.asp needs to know the clients web browser temporary system path, in order to create the temp file. How do I get the parameter and value of clients web browser temporary system path? Tag: ASP On Loaded Tag: 326790
  - 4
    - How do I assure/be certain/check in ASP that an html element was fully loaded in the client side? Hi All, Hi All, (this is not the same topic as the my previous topic) What objects/methods/properties does VBScript offer for: Assuring/guarantee/make certain that ASP/VBSCript an ELEMENT - e.g. <img ... /> - was FULLY Loaded into web Browser My Question is: describe, i have a page that does this a dll thatt does that the problem temp file How do I assure in ASP that an html element was fully loaded in the client side? myGetImage.asp uses a myGetImg.dll that does the following steps: 1. myGetImg.dll gets a data base record field 2. myGetImg.dll creates a temporary image - out of step 1 - on the client side - eg. myTempImg.jpg 3. myGetImage.asp has the <img .../> tag, and displays myTempImg.jpg on the client side. 4. myGetImage.asp uses a simple for...next loop for delaying - because in step 6 myTempImg.jpg is deleted - and Server.ScriptTimeout has a bigger value than the default. 5. myTempImg.jpg is supposed to be shown/displayed on the client side 6. myGetImg.dll deletes the myTempImg.jpg i'm not complete with step 4: that uses for...next loop for delaying, because it can very annoying on the client side to wait so long, for a image to be displayed on the client browser. My problem is: On some case - eg where myTempImg.jpg has big size - the myTempImg.jpg is deleted by myGetImg.dll, before myTempImg.jpg was displayed on the client/web browser. the for..next/and Server.ScriptTimeout don't seem as a good idea, because they sometimes they work and sometimes not. i've test my page on intranet and it's ok, but i'm not sure this will be valid for internet testing. My Question is: is there any object/way/method in asp, that can assure/verify/check/make certain that myTempImg.jpg was fully/100% loaded into the client web server, before myGetImg.dll deletes it. OR How do I assure/be certain/check in ASP that an html element was fully loaded in the client side? Tag: ASP On Loaded Tag: 326789
  - 5
    - Question of programming principle I am an experienced but self-taught ASP programmer, and sometimes wonder about major issues of principle in programming. For example: I have a web application that iterates over a set of database records, and displays each one on screen. The details of how each record is displayed can vary a lot, so each record might have one to a half-dozen parameters indicating how it displays, and the total list of parameters that any record could have tops 40. Which of the following represents better programming practice: 1) Create a parameters table in the database with a 1:many relationship to the main records, and as each record is processed in the script, do a database query to pull associated parameters, and store the resulting recordset as an array in memory. At each decision point in the script, call a function to check the parameter array and return values if present. Advantages of this approach: orthodox database design; meaning of all the parameters and their values is easily documented in the database. Disadvantage: one to 50 extra database queries per screen, which will affect performance and scalability. 2) Code the parameters into one or more fields in the main record (probably one field for integers and one for text strings) separated by some marker. For example, 2x0x5 for integers or text1&&&text2&&&text3 for text strings. As each record is processed in the script, use the ASP split funciton to create arrays of these parameters. At each decision point in the script, check the appropriate position in the relevant array. Advantage of this approach: no extra database query for each record. Disadvantage: unorthodox, un-normalized database design; parameter sequence and meaning of the values must be documented in the code, which can get messy; and setting up the parameter strings for each record can be tedious and error-prone. Overall, it seems to be a trade-off of hygeine vs. performance. Which approach is better? Tag: ASP On Loaded Tag: 326788
  - 6
    - bubble sort!? So heres the deal... I work for a company in which numbers are dropping. The owners created a game where calling potential clients racks up points for crap like basketball ticekts and such. The owners called upon me to develop a system where users could enter information to list user name, data stamp it, and then add form data such as the person they called and if it was a cold call or not. All that was pretty easy. Oh, by the by, I had never programmed anything prior to this. I was strictly html. So I made the game... Users enter data, gets dropped into a csv in our _private folder. Then I made it so that the data can be read in html format, simple fso... Well not for me, but I got it to work... So now, the owner wants this list to be sortable by the last name of the agent.... This is where I have the problem. You see, I have a boss, a programmer. He is in Canada where as I am in California. He is far to busy to assist me, and his teaching methods consist of telling me one key word, and leaving me to google the hell out of it. So his key work was bubble sort. Now I have been playing with this for,,, well over a week now (a few days past deadline) and I cannot get it to work properly. I can get bubble sort to work on an array of pre-defined data... My problem( which I have taken forever to get to, sorry) is that I need to get it to look at the whole csv, find out where the eof is, then read up from there... I have no idea how to do this, and no jedi like mentor to ask assistance. I ask for help and either get harped at or a "lol"... Its getting old... Here is the code for the game ++++++++++++++++++++++++++++++++++ <script language="vbscript"> sub referrals_onchange() DIM intCounter for intCounter = 1 to 5 if CInt(document.all.item("referrals").value) >= intCounter then document.all.item("referral_"&intCounter).style.display="block" else document.all.item("referral_"& intCounter).style.display="none" end if next end sub </script> </head> <body> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1" bgcolor="#C0C0C0"> <tr> <td width="100%" colspan="3"> <img src="../images/1newbanner.jpg" width="513" height="57"><form method="POST" name="FrontPage_Form1" action="--WEBBOT-SELF--" target="_self"> <input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><p> <font face="Arial" size="2" color="#000066">Welcome <span id="lblCurrentUserName"></span></font></p> <hr> <p> <font face="Arial"><font size="2" color="#000066">Please enter the name of the agent with whom you made contact:<br> First Name: </font><font color="#000066"> <input type="text" name="agentFname" size="20" maxlength="15"></font><font size="2" color="#000066"><br> Last Name: </font><font color="#000066"> <input type="text" name="agentLname" size="20" maxlength="20"></font></font></p> <hr> <p> <font face="Arial"><font size="2" color="#000066">Please enter the agents phone number:<br> </font><font color="#000066"> <input type="text" name="agentNumber" size="20" maxlength="10"></font><font size="2" color="#000066"> ( </font><font size="1" color="#FF0000">must have 10 digits </font><font size="2" color="#000066"> )</font></font></p> <p> <font face="Arial"><font size="2" color="#000066">What is the agents e-mail address:<br> </font><font color="#000066"> <input type="text" name="agentEmail" size="40"></font></font></p> <p> <font face="Arial"><font size="2" color="#000066">Please select a category which best describes the agent with whom you made contact:<br> Active Agent </font><font color="#000066"> <input type="radio" value="active" checked name="agentType"></font><font size="2" color="#000066"> Inactive Agent </font><font color="#000066"> <input type="radio" name="agentType" value="inactive"></font><font size="2" color="#000066">Cold Call</font><font color="#000066"><input type="radio" name="agentType" value="cold"></font></font></p> <p> <font face="Arial" color="#000066" size="2">How many referrals this agent give you?<br> <select size="1" name="referrals"> <option value="0">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></font></p> <p>  </p> <p> <input type="text" name="referral_1" size="20" style="display:none"></p> <p> <input type="text" name="referral_2" size="20" style="display:none"></p> <p> <input type="text" name="referral_3" size="20" style="display:none"></p> <p> <input type="text" name="referral_4" size="20" style="display:none"></p> <p> <input type="text" name="referral_5" size="20" style="display:none"></p> <hr> <p> <font color="#000066" face="Arial"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></font></p> <input type="hidden" name="uname" value="hidden"> </form> </td> </tr> </table> <iframe src="date_user.asp" width="80%" height=100 frameborder=0 scrolling=no name="date_time" styke="display: none"> </iframe> ++++++++++++++++++++++++++++++++++++++++++ this is the code for data_user.asp ++++++++++++++++++++++++++++++++++++++++++ <script language="vbscript"> dim txtUserName txtUserName = "<% = (Session("UserName")) %>" Sub window_onload() window.parent.document.all.item("uname").value = txtUserName window.parent.document.all.item("lblCurrentUserName").InnerText = txtUserName end sub </script> ++++++++++++++++++++++++++++++++++++ this is the admin page i am trying to create +++++++++++++++++++++++++++++++++++++ <b><font color="#000066" face="Arial">Marketing Contest Results <% csv_to_read="../_private/game.csv" set fso = createobject("scripting.filesystemobject") set act = fso.opentextfile(server.mappath(csv_to_read)) imported_text = act.readline imported_text = replace(imported_text,chr(13),",") imported_text = replace(imported_text,chr(34),"") split_text=split(imported_text,",") num_imported=ubound(split_text)+1 total_imported_text = act.readall total_imported_text = replace(total_imported_text,chr(13),",") total_imported_text = replace(total_imported_text,chr(34),"") total_split_text=split(total_imported_text,",") total_num_imported=ubound(total_split_text) %> </font> </b> <table width="100%"border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" > <tr> <% for table = 0 to num_imported -1 %> <td width="<% response.write 100/(num_imported) 'make the cell widths even %>%"bgcolor="#C0C0C0"> <font face="Arial" size="1" color="#000066"> <b><%= split_text(count) %></b>  </td> <% count=count+1 next %> </tr> <tr> <font face="Arial" size="1" color="#000066"> <% 'Reset the counter count=0 for tablea = 0 to (total_num_imported/ (num_imported)-1) %> <% for table = 0 to num_imported -1 %> <td width="<%= 100/(num_imported) %>%"> <font face="Arial" size="1" color="#000066"> <%= total_split_text(count) %> </font>  </td> <% count=count+1 next ' end of the observation %> </tr> <% next 'end of the csv %> </table> +++++++++++++++++++++++++++++++++++++++++++++++++ so there it is... I no Im lame... I have no idea how to do any of this, but do not remember it being in my job description either. Either way, I have to learn or Im gone... All advice will be appreciated. Thanks very much, - joe Tag: ASP On Loaded Tag: 326775
  - 7
    - bubble sort!? So heres the deal... I work for a company in which numbers are dropping. The owners created a game where calling potential clients racks up points for crap like basketball ticekts and such. The owners called upon me to develop a system where users could enter information to list user name, data stamp it, and then add form data such as the person they called and if it was a cold call or not. All that was pretty easy. Oh, by the by, I had never programmed anything prior to this. I was strictly html. So I made the game... Users enter data, gets dropped into a csv in our _private folder. Then I made it so that the data can be read in html format, simple fso... Well not for me, but I got it to work... So now, the owner wants this list to be sortable by the last name of the agent.... This is where I have the problem. You see, I have a boss, a programmer. He is in Canada where as I am in California. He is far to busy to assist me, and his teaching methods consist of telling me one key word, and leaving me to google the hell out of it. So his key work was bubble sort. Now I have been playing with this for,,, well over a week now (a few days past deadline) and I cannot get it to work properly. I can get bubble sort to work on an array of pre-defined data... My problem( which I have taken forever to get to, sorry) is that I need to get it to look at the whole csv, find out where the eof is, then read up from there... I have no idea how to do this, and no jedi like mentor to ask assistance. I ask for help and either get harped at or a "lol"... Its getting old... Here is the code for the game ++++++++++++++++++++++++++++++++++ <script language="vbscript"> sub referrals_onchange() DIM intCounter for intCounter = 1 to 5 if CInt(document.all.item("referrals").value) >= intCounter then document.all.item("referral_"&intCounter).style.display="block" else document.all.item("referral_"& intCounter).style.display="none" end if next end sub </script> </head> <body> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1" bgcolor="#C0C0C0"> <tr> <td width="100%" colspan="3"> <img src="../images/1newbanner.jpg" width="513" height="57"><form method="POST" name="FrontPage_Form1" action="--WEBBOT-SELF--" target="_self"> <input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><p> <font face="Arial" size="2" color="#000066">Welcome <span id="lblCurrentUserName"></span></font></p> <hr> <p> <font face="Arial"><font size="2" color="#000066">Please enter the name of the agent with whom you made contact:<br> First Name: </font><font color="#000066"> <input type="text" name="agentFname" size="20" maxlength="15"></font><font size="2" color="#000066"><br> Last Name: </font><font color="#000066"> <input type="text" name="agentLname" size="20" maxlength="20"></font></font></p> <hr> <p> <font face="Arial"><font size="2" color="#000066">Please enter the agents phone number:<br> </font><font color="#000066"> <input type="text" name="agentNumber" size="20" maxlength="10"></font><font size="2" color="#000066"> ( </font><font size="1" color="#FF0000">must have 10 digits </font><font size="2" color="#000066"> )</font></font></p> <p> <font face="Arial"><font size="2" color="#000066">What is the agents e-mail address:<br> </font><font color="#000066"> <input type="text" name="agentEmail" size="40"></font></font></p> <p> <font face="Arial"><font size="2" color="#000066">Please select a category which best describes the agent with whom you made contact:<br> Active Agent </font><font color="#000066"> <input type="radio" value="active" checked name="agentType"></font><font size="2" color="#000066"> Inactive Agent </font><font color="#000066"> <input type="radio" name="agentType" value="inactive"></font><font size="2" color="#000066">Cold Call</font><font color="#000066"><input type="radio" name="agentType" value="cold"></font></font></p> <p> <font face="Arial" color="#000066" size="2">How many referrals this agent give you?<br> <select size="1" name="referrals"> <option value="0">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></font></p> <p>  </p> <p> <input type="text" name="referral_1" size="20" style="display:none"></p> <p> <input type="text" name="referral_2" size="20" style="display:none"></p> <p> <input type="text" name="referral_3" size="20" style="display:none"></p> <p> <input type="text" name="referral_4" size="20" style="display:none"></p> <p> <input type="text" name="referral_5" size="20" style="display:none"></p> <hr> <p> <font color="#000066" face="Arial"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></font></p> <input type="hidden" name="uname" value="hidden"> </form> </td> </tr> </table> <iframe src="date_user.asp" width="80%" height=100 frameborder=0 scrolling=no name="date_time" styke="display: none"> </iframe> ++++++++++++++++++++++++++++++++++++++++++ this is the code for data_user.asp ++++++++++++++++++++++++++++++++++++++++++ <script language="vbscript"> dim txtUserName txtUserName = "<% = (Session("UserName")) %>" Sub window_onload() window.parent.document.all.item("uname").value = txtUserName window.parent.document.all.item("lblCurrentUserName").InnerText = txtUserName end sub </script> ++++++++++++++++++++++++++++++++++++ this is the admin page i am trying to create +++++++++++++++++++++++++++++++++++++ <b><font color="#000066" face="Arial">Marketing Contest Results <% csv_to_read="../_private/game.csv" set fso = createobject("scripting.filesystemobject") set act = fso.opentextfile(server.mappath(csv_to_read)) imported_text = act.readline imported_text = replace(imported_text,chr(13),",") imported_text = replace(imported_text,chr(34),"") split_text=split(imported_text,",") num_imported=ubound(split_text)+1 total_imported_text = act.readall total_imported_text = replace(total_imported_text,chr(13),",") total_imported_text = replace(total_imported_text,chr(34),"") total_split_text=split(total_imported_text,",") total_num_imported=ubound(total_split_text) %> </font> </b> <table width="100%"border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" > <tr> <% for table = 0 to num_imported -1 %> <td width="<% response.write 100/(num_imported) 'make the cell widths even %>%"bgcolor="#C0C0C0"> <font face="Arial" size="1" color="#000066"> <b><%= split_text(count) %></b>  </td> <% count=count+1 next %> </tr> <tr> <font face="Arial" size="1" color="#000066"> <% 'Reset the counter count=0 for tablea = 0 to (total_num_imported/ (num_imported)-1) %> <% for table = 0 to num_imported -1 %> <td width="<%= 100/(num_imported) %>%"> <font face="Arial" size="1" color="#000066"> <%= total_split_text(count) %> </font>  </td> <% count=count+1 next ' end of the observation %> </tr> <% next 'end of the csv %> </table> +++++++++++++++++++++++++++++++++++++++++++++++++ so there it is... I no Im lame... I have no idea how to do any of this, but do not remember it being in my job description either. Either way, I have to learn or Im gone... All advice will be appreciated. Thanks very much, - joe Tag: ASP On Loaded Tag: 326774
  - 8
    - bubble sort!? So heres the deal... I work for a company in which numbers are dropping. The owners created a game where calling potential clients racks up points for crap like basketball ticekts and such. The owners called upon me to develop a system where users could enter information to list user name, data stamp it, and then add form data such as the person they called and if it was a cold call or not. All that was pretty easy. Oh, by the by, I had never programmed anything prior to this. I was strictly html. So I made the game... Users enter data, gets dropped into a csv in our _private folder. Then I made it so that the data can be read in html format, simple fso... Well not for me, but I got it to work... So now, the owner wants this list to be sortable by the last name of the agent.... This is where I have the problem. You see, I have a boss, a programmer. He is in Canada where as I am in California. He is far to busy to assist me, and his teaching methods consist of telling me one key word, and leaving me to google the hell out of it. So his key work was bubble sort. Now I have been playing with this for,,, well over a week now (a few days past deadline) and I cannot get it to work properly. I can get bubble sort to work on an array of pre-defined data... My problem( which I have taken forever to get to, sorry) is that I need to get it to look at the whole csv, find out where the eof is, then read up from there... I have no idea how to do this, and no jedi like mentor to ask assistance. I ask for help and either get harped at or a "lol"... Its getting old... Here is the code for the game ++++++++++++++++++++++++++++++++++ <script language="vbscript"> sub referrals_onchange() DIM intCounter for intCounter = 1 to 5 if CInt(document.all.item("referrals").value) >= intCounter then document.all.item("referral_"&intCounter).style.display="block" else document.all.item("referral_"& intCounter).style.display="none" end if next end sub </script> </head> <body> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1" bgcolor="#C0C0C0"> <tr> <td width="100%" colspan="3"> <img src="../images/1newbanner.jpg" width="513" height="57"><form method="POST" name="FrontPage_Form1" action="--WEBBOT-SELF--" target="_self"> <input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><p> <font face="Arial" size="2" color="#000066">Welcome <span id="lblCurrentUserName"></span></font></p> <hr> <p> <font face="Arial"><font size="2" color="#000066">Please enter the name of the agent with whom you made contact:<br> First Name: </font><font color="#000066"> <input type="text" name="agentFname" size="20" maxlength="15"></font><font size="2" color="#000066"><br> Last Name: </font><font color="#000066"> <input type="text" name="agentLname" size="20" maxlength="20"></font></font></p> <hr> <p> <font face="Arial"><font size="2" color="#000066">Please enter the agents phone number:<br> </font><font color="#000066"> <input type="text" name="agentNumber" size="20" maxlength="10"></font><font size="2" color="#000066"> ( </font><font size="1" color="#FF0000">must have 10 digits </font><font size="2" color="#000066"> )</font></font></p> <p> <font face="Arial"><font size="2" color="#000066">What is the agents e-mail address:<br> </font><font color="#000066"> <input type="text" name="agentEmail" size="40"></font></font></p> <p> <font face="Arial"><font size="2" color="#000066">Please select a category which best describes the agent with whom you made contact:<br> Active Agent </font><font color="#000066"> <input type="radio" value="active" checked name="agentType"></font><font size="2" color="#000066"> Inactive Agent </font><font color="#000066"> <input type="radio" name="agentType" value="inactive"></font><font size="2" color="#000066">Cold Call</font><font color="#000066"><input type="radio" name="agentType" value="cold"></font></font></p> <p> <font face="Arial" color="#000066" size="2">How many referrals this agent give you?<br> <select size="1" name="referrals"> <option value="0">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></font></p> <p>  </p> <p> <input type="text" name="referral_1" size="20" style="display:none"></p> <p> <input type="text" name="referral_2" size="20" style="display:none"></p> <p> <input type="text" name="referral_3" size="20" style="display:none"></p> <p> <input type="text" name="referral_4" size="20" style="display:none"></p> <p> <input type="text" name="referral_5" size="20" style="display:none"></p> <hr> <p> <font color="#000066" face="Arial"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></font></p> <input type="hidden" name="uname" value="hidden"> </form> </td> </tr> </table> <iframe src="date_user.asp" width="80%" height=100 frameborder=0 scrolling=no name="date_time" styke="display: none"> </iframe> ++++++++++++++++++++++++++++++++++++++++++ this is the code for data_user.asp ++++++++++++++++++++++++++++++++++++++++++ <script language="vbscript"> dim txtUserName txtUserName = "<% = (Session("UserName")) %>" Sub window_onload() window.parent.document.all.item("uname").value = txtUserName window.parent.document.all.item("lblCurrentUserName").InnerText = txtUserName end sub </script> ++++++++++++++++++++++++++++++++++++ this is the admin page i am trying to create +++++++++++++++++++++++++++++++++++++ <b><font color="#000066" face="Arial">Marketing Contest Results <% csv_to_read="../_private/game.csv" set fso = createobject("scripting.filesystemobject") set act = fso.opentextfile(server.mappath(csv_to_read)) imported_text = act.readline imported_text = replace(imported_text,chr(13),",") imported_text = replace(imported_text,chr(34),"") split_text=split(imported_text,",") num_imported=ubound(split_text)+1 total_imported_text = act.readall total_imported_text = replace(total_imported_text,chr(13),",") total_imported_text = replace(total_imported_text,chr(34),"") total_split_text=split(total_imported_text,",") total_num_imported=ubound(total_split_text) %> </font> </b> <table width="100%"border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" > <tr> <% for table = 0 to num_imported -1 %> <td width="<% response.write 100/(num_imported) 'make the cell widths even %>%"bgcolor="#C0C0C0"> <font face="Arial" size="1" color="#000066"> <b><%= split_text(count) %></b>  </td> <% count=count+1 next %> </tr> <tr> <font face="Arial" size="1" color="#000066"> <% 'Reset the counter count=0 for tablea = 0 to (total_num_imported/ (num_imported)-1) %> <% for table = 0 to num_imported -1 %> <td width="<%= 100/(num_imported) %>%"> <font face="Arial" size="1" color="#000066"> <%= total_split_text(count) %> </font>  </td> <% count=count+1 next ' end of the observation %> </tr> <% next 'end of the csv %> </table> +++++++++++++++++++++++++++++++++++++++++++++++++ so there it is... I no Im lame... I have no idea how to do any of this, but do not remember it being in my job description either. Either way, I have to learn or Im gone... All advice will be appreciated. Thanks very much, - joe Tag: ASP On Loaded Tag: 326773
  - 9
    - Display one object multiple times The object I have is a barcode: <% RMABarCode = Session("rmaID") IF Len(RMABarCode) Then response.write "<img src='barcode.asp?code=" & RMABarCode & "&height=25&width=1&mode=code39'>" End If %> But I need to be able to display that barcode multiple times. Say the user needs 4 displayed, he/she will enter the number and it shows that many. any help is appreciated. Respectfully, Danny Tag: ASP On Loaded Tag: 326768
  - 10
    - Write one entry multiple times?? I created a barcode: <% RMABarCode = Request.Form("idrma") IF Len(RMABarCode) Then response.write "<img src='barcode.asp?code=" & RMABarCode & "&height=25&width=1&mode=code39'>" End If %> Does anyone know how to display that barcode multiple times through a variable? Say a user needs to print 4 of the above barcode, they would be able to enter the number of barcodes they need and it will display that many to be printed. Any kind of help is appreciated. Respectfully, Danny Tag: ASP On Loaded Tag: 326767
  - 11
    - unable to create MSHTML.HTMLDocument COM object hi , i'm trying to get a reference to the DOM of an HTML file by using MSHTML from asp set HTMLDoc=server.createObject("MSHTML.HTMLDocument") but this is not workin , i get an "invalid class string" now i've looked everywhere for a way around this but i found nothing knowing that this can be done from ASP.Net ( C# or VB.Net ) i read someWhere on the net that this is impossible, so i tried to write my own Windows Script Component to handle this but i also couldn't find any documentation about the MSHTML.dll that could truly help so if any one knows somethin that could help, well i could use any kind of help Tag: ASP On Loaded Tag: 326761
  - 12
    - Display text before ending the script Hi! I have a script that is taking some time to run and in my page, i've placed some comments to be displayed on the webpage so I can know what the script is currently running. Unfortunately, the HTML page is displayed ONLY when the script is entirely finished. I'd like the comments placed within the script to be displayed as soon as the script is reading them, not at the end! (I don't know if i'm clear enough, here's an example) CURRENTLY: (script running) ... (script end) HTML page will show: The script is starting... Script step 1... Script step 2... Done! WHAT I'D LIKE IT TO DO: (script running) The script is starting... (script continues) Script step 1... (script continues) Script step 2... (script end) Done! Thanks! Andrew Tag: ASP On Loaded Tag: 326756
  - 13
    - Hide an external script address Hi, I have a ASP site that needs to call a Perl CGI script with some parameters. Currently, the Perl script is called directly by a <form> and the script retreive the form's parameter. My problem is that I want to restrict access to the Perl script ( I don't want anybody to check the source HTML and call the Perl script directly ). Up to now, I haven't found any way to put security constraint on the Perl script. What I thought is that if nobody knows the address, then it should be fine. So is there a way to call that script on the server side, and then send the output of it to the client? Unfortunately, the Response.Redirect displays the address of Perl script in the address bar :( Thanks for any help Twig Tag: ASP On Loaded Tag: 326754
  - 14
    - need more help on split, replace and inserting into a databse Hello again experts, I have successfully pulled data from an LDAP server and now what I want to do is drop the data into a database table. The following is my code that will insert the data but that has problems. [Code] FullName=Request.Form("Name") Email=Request.Form("Email") GivenName=Request.Form("GivenName") StreetAddress=Request.Form("StreetAddress") FullNameDesc = Replace(FullName, "'", "''") EmailDesc = Replace(Email, "'", "''") GivenNameDesc = Replace(GivenName, "'", "''") StreetAddressDesc = Replace(StreetAddress, "'", "''") strFullName = Split(FullNameDesc,", ") strEmailName = Split(EmailDesc,", ") strGivenName = Split(GivenNameDesc,", ") strStreetAddress = Split(StreetAddressDesc,", ") Response.Buffer = True Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = (ConnectionInfoHidden) objConn.Open For i = 0 to Ubound(strFullName) sSQL = "INSERT into Users (FullName, Email, GivenName,Address)" sSQL = sSQL & "VALUES ('" & strFullName(i) &"', '"& strEmailName(i) &"', '" & strGivenName(i) &"', '" & strStreetAddress(i) &"')" 'objConn.Execute sSQL response.write sSql & "<BR>" Next [/code] What is happening is for each user the fullname, email, given name and address should get successfully entered into the database table however some fullnames are getting the incorrect email address, given name etc. while others are correct. Can anyone see a problem? I have checked the data that is coming back from ldap and my code is definitely incorrect. Why do some users get incorrect info...it's almost like they are getting the prior users info. Tag: ASP On Loaded Tag: 326744
  - 15
    - ? How to - streaming audio and video using windows media... ? Using VS 2003, VB.NET and/or ASP.NET 2.0, BACKGROUND I have a window forms based application that contains a TreeView control and a WebBroswer (AxSHDocVw.AxWebBrowser) control. The TreeView is populated with nodes that when clicked play an audio clip from specified local or web URL and navigate the browser control to a specified local or web URL. Audio playback uses as hidden media player object AxWMPLib.AxWindowsMediaPlayer). PROBLEM My client now wants the application moved from a windows based app, to a web app. My plan is to use redevelop the app in ASP.NET 2.0. The biggest question I have is - how do I stream audio and/or video files from my ASP server to the client? Will I need special software and/or configurations on the server to allow streaming media? Can someone point me to some web resources on this topic or better yet post some example code? Thanks for any thoughts? celoftis Tag: ASP On Loaded Tag: 326738
  - 16
    - ASP returning 404 Hi all, I am using a windows 2000 server with IISLockdown and ISAPI_Rewrite installed on it. I have 2 websites A & B. ASP pages on A are working properly, but when placed one B they return 404 error. All other pages such as txt, html, asp.net work fine on B. Both websites have the same configuration, and use the same ISAPI filters. A sample code that is not working is, file name test.asp: <%@ LANGUAGE="VBSCRIPT" %> <% response.redirect("URL")%> Do you know what needs to be done to fix that? Thanks, Mohammed Tag: ASP On Loaded Tag: 326737
  - 17
    - Microsoft VBScript runtime (0x800A000D) Type mismatch: '[string: " Hello: I have Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: '[string: "2, 0"]' The error happened at this line: if session("systemIdCount" & arrSystems(iLoop)) > 0 The code like this: strSystems = session("strSystems") '' Capture SystemId Array arrSystems = split(strSystems, ",") iLoop = 0 For iLoop = LBound(arrSystems) to UBound(arrSystems) '' Start SystemId Array Loop arrSystems(iLoop) = Trim(arrSystems(iLoop)) computerCount = computerCount + 1 session("systemId" & arrSystems(iLoop)) = arrSystems(iLoop) '' Define SystemId Session if request.querystring("newOrder") = "true" then '' Resets Session if it is a New Order session("systemIdCount" & arrSystems(iLoop)) = request("systemIdCount" & arrSystems(iLoop)) '' Define SystemId Count Session end if if session("systemIdCount" & arrSystems(iLoop)) > 0 then '' Check if count is grater than 0 varSysId = session("systemId" & arrSystems(iLoop)) for varItemNum = 1 to session("systemIdCount" & arrSystems(iLoop)) ' varItemNum Loop ......... I thought that the error was that session should be int, so add cint to the this line: if (session("systemIdCount" & arrSystems(iLoop))) > 0 However, I got mismatch "cint" error. What am I missing here? Your help is highly appreciated. Tag: ASP On Loaded Tag: 326732
  - 18
    - ASP: Exchange 2003 Free/Busy Lookup Hi, I'm trying to get a users free/busy status from exchange from within a website and using the code below, but when I run this a login page from MS Outlook Web Access is retrieved from the server rather than a XML file containing the users free/busy status for the specified time period. I've spent all day looking for solutions to this but I'm stumped. I have been looking for an Exchange newsgroup but there doesn't seam to be one, does anyone know if i can post this some where else to get a response from an Exchange expert. The Server is 2003, with Exchange 2003. Any help would be very much appreciated! Code being run is shown below and was modified from the following location http://msdn.microsoft.com/library/default.asp?url=/library/en-us/e2k3/e2k3/_esdk_checking_free_busy_status_http.asp <% ' Initialize variables. ' The public folder server that contains the user's free/busy information. strServer = "????????????" ' The user's e-mail address. strUser = "andy.long@????????????.co.uk" ' Build the URL with the freebusy command. Specify a start date/time of ' 08:00 (UTC) 27 Sep 2004, an end date/time of 20:00 (UTC) 27 Sep 2004, an ' interval of 60 minutes, and the e-mail address of the user. Multiple ' e-mail addresses can be specified by appending one or more ' "&u=SMTP:user@example.com" command parameter values to the URL string. strUrl="https://" & strServer & "/public/?cmd=freebusy" & _ "&start=2006-10-24T08:00:00Z" & _ "&end=2006-10-24T20:00:00Z" & _ "&interval=60" & _ "&u=SMTP:" & strUser ' & "&u=SMTP:user2@example.com" ' Initialize the XMLHTTP object. set objRequest=createobject("Msxml2.ServerXMLHTTP") ' Open the request object with the GET method and ' specify that it will be sent asynchronously. objRequest.open "GET", strUrl, false ' Set the Content-Type header. objRequest.setRequestHeader "Content-Type", "text/xml" ' Set the Content-Length header. objRequest.setRequestHeader "Content-Length", 0 ' Set the Accept-language header. objRequest.setRequestHeader "Accept-Language", "en-us" ' Send the GET method request. objRequest.send ' The request was successful. If 200 = objRequest.status Then ' Uncomment this line to see the XML response. response.write(objRequest.responsetext) ' Create the DOM document. Set objDoc = createobject("msxml2.domdocument") ' Load the XML response body. If objDoc.loadXml(objRequest.ResponseText) Then ' Build a list of the WM:item XML nodes, corresponding to the ' returned user and free/busy information of the freebusy ' command. The WM: namespace is typically assigned the a: prefix ' in the XML response body. The namespaces and their associated ' prefixes are located in the attributes of the WM:response node ' of the XML response. Set objNodeList=objDoc.selectNodes("//a:item") ' Iterate through the WM:item nodes. For Each objItemNode In objNodeList ' Use an XPath query to get the WM:displayname node ' from the WM:item node. set objDisplayNode = objItemNode.selectSingleNode("a:displayname") ' Use an XPath query to get the WM:fbdata node ' from the WM:item node. set objFBNode = objItemNode.selectSingleNode("a:fbdata") ' Display free/busy information. response.write("Display name: " & objDisplayNode.Text) response.write("Free/busy data: " & objFBNode.Text) response.write("<br>") Next End If Else response.write(objRequest.status & " " & objRequest.statustext) End if ' Clean up. Set objRequest = nothing Set objDoc = nothing %> Tag: ASP On Loaded Tag: 326728
  - 19
    - MS Access Scripting? I want to script real-time data FROM financial Web sites TO an MS Access db. on a PC (no server issues). Is this possible? If so what should I use ASP VBScript, ASP.NET VB or something else, and could you point me to possible resources that will help me learn how to do this? Thanks! Tag: ASP On Loaded Tag: 326720
  - 20
    - can I load database data in global.asa Hi everyone, I never used global.asa. I am thinking of load some data in application_onstart which is read only from database(I mean the data will never be changed in any asp pages of the applcation) and so any session for this application doesn't need to reload data from database again, reduce database connection and procedure call. Am I right? just doesn't see that kind of comments on-line. I want to make sure this is the right concept before I am heading too far. -- Betty Tag: ASP On Loaded Tag: 326717
  - 21
    - How to create a file in ASP/VBScript? Hi All, What options/methos/properties/functions/objects do I have in order to create a Function in ASP/VBScript that process/create binary data as an image file type? The Function is supoosed to get 2 parameters: 1. The file image content type defined as "image/bmp" , strContentType 2. the file binary data, binDataImageBytes (which is stored in session vars) The Function should return/create an Image File , for instance ~tmpImg.BMP My Question is How to create a binary Image file type from the session var binary data ? Tag: ASP On Loaded Tag: 326714
  - 22
    - How to select and insert using asp Hello experts, O.k I give up on this. I have an LDAP query from asp working correctly. It is returning data fine. Now I need to know how to take this data and then submitt it into the database. Can this be done in one page and is there any other way to do this without putting a submit button on a page. Almost like a file that I can pass to the user and he can click it to insert into a database. My way of do it is to simply to put a submit button on the page and when the user hits submit the values selected will go to the database. However the only thing on this page is a submit(kinda useless). This is part of my code [code]<form name="form1" method="post" action="ldap_second.asp"> <TABLE BORDER = 2> <TR><TD>Name</TD> <TD>Mail</TD> <TD>GivenName</TD> <TD>Address</TD> </TR> <% Do Until objRecordSet.EOF%> <% Dim N Dim M Dim GN N = objRecordset("Name") M = objRecordset("Mail") GN = objRecordset("GivenName") SA = objRecordset("StreetAddress") response.write "<TR>" response.write "<TD>" & N & "</TD>" response.write "<TD>" & M & "</TD>" response.write "<TD>" & GN & "</TD>" response.write "<TD>" & SA & "</TD>" response.write "</TR>" %> <% objRecordSet.MoveNext Loop %> </TABLE> <p><input type="submit" value="Submit" name="B1</p> [/code] Now on my ldap_second how to I take the values and submit them to a database. Your help is appreciated. Tag: ASP On Loaded Tag: 326705
  - 23
    - Error Line Number Hi, I have a page that whenever an error occur, I send an email to support with the error description, script name, server, referer, etc... However, I want to add the line number to the email message. So far, I have found that you would have to modify the custom error (500;100) on the IIS to point to your own error page to be able to use the Server.GetLastError object. Does anyone know if there is a way out there that does not require changing the IIS settings? Thanks in advance! Tag: ASP On Loaded Tag: 326703
  - 24
    - Session Var Issues Hi all, Anyone out there using session vars to hold user information when a user logs in to your Web site, and sometimes having the Session Vars not get set (especially in IE)? My situation involves a Web site that uses a Session Var to hold a UserID and another to hold a UserType and some users are being directed to our 'timeout' message right away when they log in - it's coded so users get directed here if the Session Vars are empty, NULL, or "" so they are not really 'timing out'. The biggest problem is that some users cannot even get in. I have found that IE's Privacy setting about 'blocking all cookies' will cause this to happen and as long as the privacy gets set to 'High', you can still block cookies as long as you enable 'Session Cookies'. I have also found a work around by adding the Web site to the list of trusted sites in IE. Any other suggestions? Perhaps there is a coding work-around that I am not aware of. Any tips would be appreciated. Thanks Agent H :) *** Sent via Developersdex http://www.developersdex.com *** Tag: ASP On Loaded Tag: 326688
  - 25
    - Form to Email Hi, I have some database records which are listed out in a table on an asp page. The table is within a <form> tag. At the end of each record (and table row), I have created a <select> dropdown box to appear. The user selects an item for each record in the list, then hits submit. The following code is used to create the body of the email: For Each i in Request.Form MailBody = MailBody & Request.Form(i) & vbcrlf Next What I need in the body is the first database field printed on the form in each record and the selected item from the dropdown against that record i.e. Product A Yes Product B No Product C Yes I have tried adding a hidden input type to carry the Product Code but all I get is the following as my email body: Select Status, Select Status, Select Status, Approved, Select Status, Select Status, Select Status, Approved, Select Status, Select Status, Approved, Select Status, Select Status 070512001R, 069435001Q, 069424001Q, 069321001Q, 069305001Q, 069270001Q, 069167001Q, 068744001Q, 068677001Q, 068677001Q, 068466001Q, 066497001Q, 061097001Q Submit Where 'Select Status' is the default text to show in the dropdown. It first goes through all the dropdown results, and them through all the product codes and for some reason, the vbcrlf is not working ? How can I print them together in sets ? I need the body to show 070512001R = Approved 069435001Q = Approved etc PLEASE CAN YOU HELP ME DO THIS, THANKS Thanks David Tag: ASP On Loaded Tag: 326682

Hi, can any1 tel me how do i and what exactly does an onloaded function
look like?

I want to use an on loaded function that when the page is done loading,
i want to use, respose.redirect to reload the page.

Thanx in advance for ur help.

Top

Re: ASP On Loaded by Ray

Ray
Fri Nov 03 05:56:08 CST 2006

Do you want the user to see the page first? If so, you can't use
Response.Redirect. You'd have to use client-side script.

<script type="text/javascript">
location.href = 'page2.asp';
</script>

Ray at work

"amatuer" <njoosub@gmail.com> wrote in message
news:1162547937.406399.93970@f16g2000cwb.googlegroups.com...
> Hi, can any1 tel me how do i and what exactly does an onloaded function
> look like?
>
> I want to use an on loaded function that when the page is done loading,
> i want to use, respose.redirect to reload the page.
>
> Thanx in advance for ur help.
>

Top

Re: ASP On Loaded by amatuer

amatuer
Mon Nov 06 00:36:55 CST 2006

Yes i would like the user to see the page first. What does the script
below do?

Ray Costanzo [MVP] wrote:
> Do you want the user to see the page first? If so, you can't use
> Response.Redirect. You'd have to use client-side script.
>
> <script type="text/javascript">
> location.href = 'page2.asp';
> </script>
>
> Ray at work
>
> "amatuer" <njoosub@gmail.com> wrote in message
> news:1162547937.406399.93970@f16g2000cwb.googlegroups.com...
> > Hi, can any1 tel me how do i and what exactly does an onloaded function
> > look like?
> >
> > I want to use an on loaded function that when the page is done loading,
> > i want to use, respose.redirect to reload the page.
> >
> > Thanx in advance for ur help.
> >

Top

Re: ASP On Loaded by Ray

Ray
Mon Nov 06 05:53:15 CST 2006

Then you'll have to use client-side script. The script below will instruct
the browser to navigate to page2.asp.

Ray at work

"amatuer" <njoosub@gmail.com> wrote in message
news:1162795015.770026.65120@i42g2000cwa.googlegroups.com...
> Yes i would like the user to see the page first. What does the script
> below do?
>
>
> Ray Costanzo [MVP] wrote:
>> Do you want the user to see the page first? If so, you can't use
>> Response.Redirect. You'd have to use client-side script.
>>
>> <script type="text/javascript">
>> location.href = 'page2.asp';
>> </script>
>>
>> Ray at work
>>
>> "amatuer" <njoosub@gmail.com> wrote in message
>> news:1162547937.406399.93970@f16g2000cwb.googlegroups.com...
>> > Hi, can any1 tel me how do i and what exactly does an onloaded function
>> > look like?
>> >
>> > I want to use an on loaded function that when the page is done loading,
>> > i want to use, respose.redirect to reload the page.
>> >
>> > Thanx in advance for ur help.
>> >
>

Top