Probems with Replace Command

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
    - Web page calling COM+ DLL I have a web server that has a COM+ DLL. This is successfully called by a web page running on that server. I exported the COM+ package (as an MSI and NOT as a proxy stub) and imported it onto a new machine. I set up the web application in (I believe) an identical fashion. When I run the ASP page it errors - permission denied; can not create object. Things I have checked: 1 - the COM+ package runs under the LOCAL ADMINISTRATOR account (same as on the other server). 2 - the NTFS permissions on the DLL (sitting in C:\Program Files\ComPlus Applications\{xxxxxx} are identical on both machines 3 - the IIS security and NTFS permissions on the script are identical 4 - I've ensured that the DLL is registered correctly (using regsvr32) I'm at a loss to see what else could be the problem. The COM+ DLL only references standard Windows components that exist on the server. Any suggestions please? Thanks Griff Tag: Probems with Replace Command Tag: 314757
  - 2
    - Help with Internationalization Hello Currently we have an ASP + SQL Server website running for a UK audience. The server, W2K, is set to UK (£, dd/mm/yyyy), GMT with daylight saving etc. All our ASPs have <%@ LCID=2057%> at the top to ensure no date or currency symbol ambiguity. We wish to open our application up to the world, (although only working with GBP, Euros and USD), and do not want to run in to any time/locale issues. Upon registration the user will select their timezone. The website does scheduling for want of a better description, so people are creating events with dates and times. I would like to have your opinions as to the best way to go about controlling the time within ASP and/or SQL Server. For example, if I create an event for 2-September-2005 at 1600, I would like the date and time displayed according to the viewers time zone selection. 1600 in the UK will be 1700 in Germany and 1100 in New York. At the moment I think I need to set the server back to GMT with no daylight saving observed. Then, store all dates and times, for simplicity, in the database as GMT. So when inserting values the times will be converted to GMT and when extracting values the times will be converted to the visitors timezone from GMT, based on their earlier timezone selection. I do not believe that Windows can give me the conversion values required as I am not sure how good it is at daylight saving around the world etc. I have been looking at this product from worldtimeserver.com, (see COM+ component details): http://www.worldtimeserver.com/time_zone_guide/. They allege to have all the required info and provide a COM object that can do the conversion from and to UTC. Regarding input validation and that sort of thing, I am planning to allow the user to select their country and will use Session.LCID to perform validation on dates etc. So, IsDate(#25/12/2005#) will return true when the LCID is set to 2057 and IsDate(#12/25/2005#) will also return true when the LCID is 1033. I have yet to look in to validating on the client side as I use JavaScript and it is probably better at it and will of course be done, (hopefully not by string manipulation), on the client's PC. I am sure that many of you out there have already overcome this challenge and I would appreciate any advice you would be prepared to offer. Thanks for your time. David Tag: Probems with Replace Command Tag: 314754
  - 3
    - another permission denied error So I'm new to ASP and set it up on my computer and just want a simple text based guestbook where it just adds your entry to the end of the textfile and to display just displays the contents of the textfile. So displaying the contents is not the problem. Here is the code <html> <body> <% Const ForReading = 1 Const ForWriting = 2 Const ForAppending = 8 %> <FORM action="signBook.asp" method="GET"> name:<INPUT TYPE="text" NAME="name"> message:<INPUT TYPE="text" NAME="message"> <INPUT TYPE="submit"> </FORM> <% n=request.querystring("name") m=request.querystring("message") if n<>"" And m<>"" then set fs = Server.CreateObject("Scripting.FileSystemObject") set f = fs.OpenTextFile("guestbook.txt", ForAppending, true) f.WriteLine("This line is added to the file.") f.Close() end if if n="" And m="" then Set fs=Server.CreateObject("Scripting.FileSystemObject") Set f=fs.OpenTextFile(Server.MapPath("guestbook.txt"), 1) Response.Write(f.ReadAll) f.Close() end if %> </body> </html> I get the Permission denied error on this line -> set f = fs.OpenTextFile("guestbook.txt", ForAppending, true) I have been all over the internet and tried giving the folders write access through the control panel -> administrative tools -> internet information services and I've also tried right clicking the folder and clicking on properties. Then the security tab. Can anyone help me? It's kinda important I get this out of the way. I am using Windows XP Professional with Service Pack 2. Thanks guys. Tag: Probems with Replace Command Tag: 314748
  - 4
    - Active Directory error '80070005' (GetObject) I create an ASP application for Windows 2003 server (Czech) with Exchange 2003. When I want to create new user in Active Directory from my application - this error occurs: Active Directory error 80070005' General Access error denied Web application runs under ADMINISTRATOR account and problematic code is: Set oOU = GetObject("LDAP://test.test.cz/ou=skup,dc=test,dc=test,dc=cz") Set oUser = oOU.Create("User", "cn=" & "Test" & " " & "Tester") oUser.Put "sAMAccountName", "Test13" oUser.SetInfo Tag: Probems with Replace Command Tag: 314745
  - 5
    - xml transform to excel I used the below code to transform xml to a spreadsheet using a .xsl file. It works great; problem is I want to transform several recordset to xml to multiple worksheets in the workbook. Should I use something other than the "transformNodeToObject"? I can't see how to direct the xml to different worksheets. I appreciate any help. <%@ Language="vbscript"%> <% sConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("mydb.mdb") sXSL = Server.MapPath("mydb.xsl") Response.Buffer = True 'Retrieve an ADO recordset of the Orders Detail table in mydb Dim rs, nRecords Set rs = CreateObject("ADODB.Recordset") rs.Open "SELECT uDesc FROM mydbTable", sConn, 3, 3 'Persist the recordset to a new DOMDocument and store the record count Dim oXML Set oXML = CreateObject("Microsoft.XMLDOM") rs.Save oXML, 1 nRecords = rs.RecordCount rs.Close 'Load the XSL (the workbook template with XSL directives) into a DOMDocument Dim oXSL Set oXSL = CreateObject("Microsoft.XMLDOM") oXSL.Load sXSL 'Transform the XML using the stylesheet Dim oResults Set oResults = CreateObject("Microsoft.XMLDOM") oXML.transformNodeToObject oXSL, oResults If oXSL.parseError.errorCode <> 0 Then Response.Write "Parse Error: " & oResults.parseError.reason Else 'Modify the ss:ExpandedRowCount attribute for the <table> node in the XSL. Dim oTable Set oTable = oResults.selectSingleNode("Workbook/Worksheet/Table") oTable.setAttribute "ss:ExpandedRowCount", nRecords + 2 'Return the resulting XML Spreadsheet for display in Excel Response.ContentType = "application/vnd.ms-excel" Response.Charset = "ISO-8859-1" Response.Write oResults.XML Response.Flush end if %> Tag: Probems with Replace Command Tag: 314742
  - 6
    - debugging activex exe and asp page I have asp page which is using activex exe component ...how can I debug from asp page to the component...I am using visual basic to create my activex component thanks Tag: Probems with Replace Command Tag: 314735
  - 7
    - To work with two data bases in asp Is possible to have a connection to SQL server and another one conaxion to a data base Access to process data among them Thanks. Tag: Probems with Replace Command Tag: 314733
  - 8
    - Web report development Hi, We have a web application(asp based) without any report features. I have to build web reports. Right now, these reports are build on an Access 97 desktop application. The idea is to have our clients to print the reports via web application. I am wondering, what is the best way to develop web reports that would be exact same as Access 97 reports. Thanks in advance. Regards. Tag: Probems with Replace Command Tag: 314730
  - 9
    - Global.asa Session_OnEnd I have an ASP application that is a electronic purchase orders system. My problem is that only 3 people can authorise a purchase order. When a purchase order is selected I update the table to show that the field is locked. If they complete the form then the database is updated and the lock is removed, all though at this stage the record moves into another part of the system and the lock becomes redundant. If however they dont complete the form the record is left in a permanent locked state, it could be that they decided to look at the record then navigated away or closed the browser. So i thought maybe i could stick some code that updates the database into the session_OnEnd in the global.asa, so after 20 minutes when the session has ended the lock will free. I don't however have any experience with this and don't even know if this will work. The code won't be a problem its just whether this process will actually work. I am thinking that I code put the order_id into a session variable then when the session variable ends i run a sub in the .asa file that gets the session variable and updates the table. Am I thinking correctly here or have i misunderstood the event and its purpose, or is there a better way of achieving the task. TIA Tag: Probems with Replace Command Tag: 314709
  - 10
    - Writing to valid ANSI text file (UTF8 issue?) Hi, I've a problem with code that should produce a Windows(ANSI) encoded text file but doesn't. Server is IIS 5 on Win 2k, with ASP ver? My ASP uses data from an upstream HTML form on a UTF-8 encoded page. The latter is output by a server-side system and I can't alter that source format. Here's some of the ASP code (may wrap): ' Following vars are longer strings but of this type - just more Request object vlaues added strLabels = "Filename" & vbTab "EXTENDED_DESCRIPTION" strValues = Request.Form("Filename") & vbTab & Request.Form("EXTENDED_DESCRIPTION") On Error Resume Next ' set up the FSO Set fso = CreateObject("Scripting.FileSystemObject") ' Create the lock file ('ture' arg allows file overwrite if already exists) Set objMyFile = fso.CreateTextFile(strDataFile, True) If Err.Number = 0 Then ' Successfuly created file, let's write to it objMyFile.WriteLine(strLabels) objMyFile.WriteLine(strValues) ' close - we're done objMyFile.Close This code worked with the previous version of the server-side system but since it was upgraded now the next part after the ASP form-to-file process breaks as expects a Windows(ANSI) TXT file. When I do a text import of my current ASP created files it reports "MS_DOS(PC-8)". I assume the move to UTF-* encoded pages upstream is the issue. I assume the ASP is getting UTF-8 values from the Response object. How can I parse these to ANSI encoding to get a valid Windows(ANSI) Text file? Many thanks. Mark Tag: Probems with Replace Command Tag: 314705
  - 11
    - Alternative to <select> for large number of values? My users have to select an value from a fixed selection of values. The obvious choice of control for such a requirement is to use a <select> (i.e. a combo box). My problem is that sometimes, these combo boxes will have a *large* number of values. There could be any number of values in them from 5 to 5 million (unlikely it would be this large but possible). Obviously 5 million is far too much to populate a <select> control with. Does anyone have any suggestion as to how a user could select a value from a *potentially* very large selection of values (i.e a suitable alternative to the <select> control)? Tag: Probems with Replace Command Tag: 314703
  - 12
    - Use of HTTP_REFERER in Global.asa Hello, I have the below requirement. When ever my website is opened by any link: say clicked from the google search result or a link from other website: Then I should able to know the referrer URL. How Do I get that? I know about Request.ServerVariables("HTTP_REFERER"). So I used this in "global.asa" file in "Session_OnStart" event like this: Sub Session_OnStart Session("ReferralURL") = Request.ServerVariables("HTTP_REFERER") End Sub Sub Session_OnEnd Session("ReferralURL") = "" End Sub So that I can use the session variable any where in my website, because the HTTP_REFERER will give the URL of the last webpage. But this seems to not working. Please help. Thanks Prabhat Tag: Probems with Replace Command Tag: 314702
  - 13
    - dear microsoft.public.inetserver.asp.general readers -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 It's getting a bit tiresome seeing one misguided American after another with their cutsie little yellow or red-white-blue ribbons on their outsized SUVs. Yeah, I guess it's the thing to do; maybe part of that whole soccer-mom culture. Unfortunately, the only thing they demonstrate is that the person behind the wheel is a clueless, gullible, misguided, nitwit. If foreign invaders landed on our soil, as we have done in Iraq, I would be the first one to take up arms and repel them. (I suppose that would make me an 'insurgent' by OUR logic.) This, and other aggressive governments have always done their utmost to make it APPEAR as if committing yourself to kill in feuds on distant shores that have nothing to do with the welfare of the citizenry is somehow patriotic. It is not. Enlisting in the armed forces, in the absence of a real and impending foreign threat, is no different that hiring yourself as a paid assassin . . the only difference is, you're not getting paid enough. But let's take a realistic look at exactly WHO joins up in an all-volunteer army. The first group are those who join (during peacetime) for the benefits: to get an education, or because it seems a reasonable career path. Consider carefully! Realize that you are gambling with your humanity. Once you sign that form, you sign away your right to say: "No, that is an atrocity." You put your abilities, including the ability to kill, at the disposal of proven liars, psychopaths . . . enemies of humanity. Do you think that every German soldier in World War II who helped load Jews into cattle cars was a cold-blooded killer? Most were poor kids, just like you, who got caught up in the patriotic frenzy. Once you're in, you're IN. You lose the ability to stop killing until they tell you so. This not only makes you less than human, it makes you less than an animal, for even the animals retain their freedom of self determination. The second group are the simple minded, who fall for patriotic entreaties about defending democracy, Mom, apple pie; in other words, all the traditional government propaganda. Do you think Soviet lads subjugated their neighbors throughout the world because they thought the Soviet Union was an EVIL empire? No, they were fighting for MOM, and whatever passes for apple pie in Russia. Step back and examine the lies your government is handing you, and ask yourself if they have the ring of truth. Do you want to be one of the murderers in uniform who opened up on their fellow citizens at Kent State? When you put on that uniform, you give up all autonomy, and become nothing more than a weapon, to be used for whatever evil purposes the scoundrels in government demand (and, if you look carefully, you will discover that the only interests THEY serve are those of the big businesses that own them.) Finally, you have the hard-core psychopaths. These are the people who WANT to kill. Murder, torture, rape; THESE are the American values upon which THIS group is focused. The cause doesn't matter, they're after the thrill that only warfare can provide. Just remember: killing for George W. Bush, or for George H.W. Bush, or for Lyndon B. Johnson, or for Richard M. Nixon is not the same as defending yourself, your family, your friends, or your country. Don't be a dupe. Don't Enlist! Remember -- supporting the troops means supporting Bush aggression, profiteering, and war crimes. Here's an idea: why not take those ribbons, dip them in blood, and mail them to the White House? - -- Tom St.Denis 111 Banning Rd Kanata, Ontario K2L 1C3 Canada Home: (613)836-3160 Cell: (613)796-8220 tomstdenis@gmail.com KeyID: 0x40B640D5 Fingerprint: 53F9 307F F83E D52A 9E63 C2A5 B43F D952 40B6 40D5 http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x40B640D5 -----BEGIN PGP SIGNATURE----- Version: PGP 8.0.3 iQA/AwUBQxLVO7Q/2VJAtkDVEQJnnQCg1mRyNVgZ6Po6Xf7csn62Ph9rkC8AoMxZ Zo8jLvfr6bDGWZb/PhEpz3c8 =2NAY -----END PGP SIGNATURE----- Tag: Probems with Replace Command Tag: 314701
  - 14
    - Paged recordsets What is the best way to produce these? Is there a SQL statement that selects, say, records 30-40 from the results? Tag: Probems with Replace Command Tag: 314700
  - 15
    - Need help with "No input file specified" error I'm new here so if I posted this incorrectly please go easy. I recently moved my website from a Unix hosting service to a Windows 2003 IIS hosting service. The site was converted from php/mysql to asp/mssql. The search engines still have a lot of links cached that point to ......php. When a user clicks the link they get a blank page that reads "No input file specified.". This page does not appear to be a standard error page. My question. Is there a way to redirect all ....php page requests to my home page? Thanks, Terry http://www.4everhers.com Tag: Probems with Replace Command Tag: 314696
  - 16
    - images and buttons HTML question Very basic HTML question 1. I have image I want to display that to a button how can I do that. I want to fire the on click event too 2. if 1 is not possible then how can I set image to have oncclick event, currently I get object nbot found error code is like this <button ID ="Sel" name="Sel" OnClick="moveOptions(this.form.AvailableInd, this.form.SelectedInd);" ><img src = "/images/movedown.gif" alt="Remove" title="Remove"></button> <button ID ="Del" name="Del" OnClick="moveOptions(this.form.SelectedInd, this.form.AvailableInd);" ><img src= "/images/moveup.gif" alt="Add" title="Add"></button> above code shows me the button which I dont want and just want to display image when I tried following code, moveoptions doesnt work <img src = "/images/movedown.gif" alt="Remove" title="Remove" OnClick="moveOptions(this.form.AvailableInd, this.form.SelectedInd);"> <img src= "/images/moveup.gif" alt="Add" title="Add" OnClick="moveOptions(this.form.SelectedInd, this.form.AvailableInd);" > any clues Tag: Probems with Replace Command Tag: 314694
  - 17
    - un/hiding textbox when dropdown changes Hi, I would like to know if this is possible. I'm using ASP with JSCRIPT. I have a dropdown box that when the use selects a particular value, I would like the textbox to become visible. also if they dont choose it, I would like the textbox to be hidden. I have this web input form with many other fields. This dropdown box is in the middle of these fields. I dont see any property to set. I see the disable property but I want it hidden. thanks, Will Tag: Probems with Replace Command Tag: 314692
  - 18
    - Capturing identity of the user Hi... I have made a asp page that accepts some data from user and stores it in MS Access database. Now...I want to identify the user who filled the form and store this information in database. About the enviornment....the server has Windows 2000 server installed. Clients have Windows XP. Server also has Exchange 2003 installed and every client has Outlook Express installed. Every user has to login to his account inorder to use a machine. A given user can login on any machine. How can i find the identity of the user who submitted the form? Is it possible to find out the current logged in user given the IP address of the machine? If yes, how and will there be any chances of error due to delay in replication? Since ASP can use 'com' components on server, i think there should be some way to achive this. What do you think? For any clarifications post a reply or mail me at mailanoop@gmail.com Thanks in advance.... - Anoop Tag: Probems with Replace Command Tag: 314690
  - 19
    - problem accessing cookie values I have a pdf form that is submitting to an asp 3.0 page. I am setting a cookie value at login time that I need to access in this processing page. For some reason, the cookie is not being detected on that particular page but is being detected on other pages on the same server when I test for it. This problem only occurs on the processing page when I post to it from the form. If I navigate to it directly, the cookie is detected. This is happening no matter what version of adobe reader or acrobat is used. Tag: Probems with Replace Command Tag: 314685
  - 20
    - ASP to EXCEL Hi, Im creating an Excel file using ASP Versions : Office 97 The formattting is not working properly in Excel 97, but the same works fine in Office XP & 2000 Is there any additional code has to be added in my code to get a formatted output in Excel 97 version? Please help. Thanks. MyCode --------- set Cn=server.createobject("ADODB.connection") Cn.open sqlconstring tfName = "salesexcel.xls" set Rs=server.createobject("ADODB.recordset") sql = "select * from sales WHERE month(saledate)=8 and day(saledate)=28 year(saledate)=2005" Rs.open sql,Cn,1,3 Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "attachment; filename=" & tfName if not rs.eof then Response.write "<table>" Response.write "<tr><td colspan='2'>ID</td><td colspan='2'>Executive</td><td colspan='2'>Sales Done</td></tr>" while not rs.eof Response.write "<tr>" Response.write "<td colspan='2'>" & rs(0) & </td>" Response.write "<td colspan='2'>" & rs(1) & </td>" Response.write "<td colspan='2'>" & rs(2) & </td></tr>" rs.movenext wend enf if Response.write "</table>" set Cn = Nothing ------------------------------------------------------------- Tag: Probems with Replace Command Tag: 314684
  - 21
    - Multimedia - MP3 Does any know how to hide the audio media from the page or embedded file the way flash does? Explain. I have 5 MP3 or WMA files in hosting service and I want the user to select them for playing in the embedded windows media player in a asp page I know how to hide the control of the media player but by looking at the source of the page you can tell what file is playing and location of it cutting and paste link on the browser then anyone can still it and that what I want to avoid. I was trying to do it with flash but I am not good at it so gave up and trying to do it in just plain .ASP Can this be possible.? TIA. Tag: Probems with Replace Command Tag: 314665
  - 22
    - Select DB Columns Dynamically! A Form has a select list which lists all the column names of a SQL Server database table. Users will select one or more than one column from this select list & after submitting the Form, the records of only those columns that he had selected in the previous page will be displayed to him. This is the Form code: ---------------------------------------- strSQL="SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tblSheet' ORDER BY ORDINAL_POSITION" ............. ............. objRS.Open strSQL,objConn <form........> <select name="colname" multiple size=5> Do Until(objRS.EOF) %> <option><%= objRS("COLUMN_NAME") %></option> <% objRS.MoveNext Loop %> </select> ---------------------------------------- & this is the ASP page that retrieves the records: ---------------------------------------- <% Dim strColNames,arrColName,strEachColName strColNames=Request.Form("colname") arrColName=Split(strColNames,", ") ............. ............. ............. Dim strSQL strSQL="SELECT " & strColNames & " FROM tblSheet" ............. ............. ............. objRS.Open strSQL,objConn %> <table border=2> <tr> <% For Each strEachColName In arrColName %> <th><%= strEachColName %></th> <% Next %> </tr> <% Do Until(objRS.EOF) %> <tr> ---------------------------------------- Now how do I loop through the recordset to display the recordset to the user? Had the column names not been generated dynamically, objRS("ColumnName") would have sufficed but how do I do the same here? Thanks, Arpan Tag: Probems with Replace Command Tag: 314659
  - 23
    - Need Help With QueryString & Password! An ASP application retrieves records from a SQL Server database. In the first page of the application, the user has to enter a password & the columns retrieved from the DB table depends upon the password. For e.g. if the password entered is say, pwd1, then that user should be displayed the records of Column1 & Column2 only. If the password entered is say, pwd2, then that user should be displayed the records of Column1 & Column3 only. If the password entered is say, pwd3, then that user should be displayed the records of Column1 & Column4 only. Now after the records are displayed, the user should also be given the option of sorting the records. I am implementing this by making the column header a hyperlink which has the column name & the sort order as the querystrings, something like this (the records are being displayed in a tabular format): ---------------------------------------- <% Dim strColName,strSortOrder,strPwd strColName=Request.QueryString("colname") strSortOrder=Request.QueryString("sortorder") strPwd=Request.Form("pwd") 'assume that the user is displayed the records of Column1 & 'Column2. When the user comes to this page for the first time 'after entering his password in the previous page, both 'strColName & strSortOrder are empty strings. Dim strSQL If(strColName="col1" Or strColName="") Then If(strSortOrder="" Or strSortOrder="asc") Then If(strPwd="pwd1") Then 'columns retrieved depends on the 'password strSQL="SELECT Col1,Col2 FROM tblSheet ORDER BY Col1 ASC" ElseIf(strPwd="pwd2") Then strSQL="SELECT Col1,Col3 FROM tblSheet ORDER BY Col1 ASC" ElseIf(strPwd="pwd3") Then strSQL="SELECT Col1,Col4 FROM tblSheet ORDER BY Col1 ASC" End If ElseIf(strSortOrder="desc") Then 'the same code in the If condition will come here, the 'only difference being using DESC in the ORDER BY clause. End If End If 'Column1 is common for both pwd1 & pwd2, thus using Or in the 'next If statement If(strPwd="pwd1" Or strPwd="pwd2") Then If(strColName="col1" Or strColName="") Then If(strSortOrder="" Or strSortOrder="asc") Then %> <a href="Records.asp?colname=col1&sortorder=asc">Column 1</a> <% Else %> <a href="Records.asp?colname=col1&sortorder=desc">Column 1</a> <% End If End If %> ---------------------------------------- As seen in the above code, I am passing the column name & the sort order through the column header (which is a link) as querystrings. This correctly sorts the columns & serves my purpose. But the problem is since the columns displayed depends on the password entered by the user, when it comes to sorting the records, even the password has to be passed somehow along with the column name & the sort order. Of course, the password can be passed as a querystring along with the column name & the sort order but that's definitely not a wise idea. So how do I pass the password when the user clicks one of the column headers to sort the records? One way of carrying the password forward is by encrypting the password & then sending it through the querystring along with the column name & the sort order but I would like to avoid such a solution. This solution will be my last option. Please keep in mind that the columns displayed to a user depends upon the password; so the password has to be sent somehow along with the column name & the sort order (column name & the sort order are being passed through the querystring). For e.g. if the password entered is pwd1, then the user sees the records of only Column1 & Column2. Next he clicks the column header 'Column 1' (which is a hyperlink with the column name & the sort order as the querystrings) to sort the records based on Column 1. When the link is clicked, pwd1 also has to be carried forward so that this user is displayed the records of Column1 & Column2 only & not the records of the other columns. Thanks, Arpan Tag: Probems with Replace Command Tag: 314654
  - 24
    - checking for window existance Is there any way to check the existance of a window by the name ? I'm using this code: window.open("http://www.google.com",'targetWin1') If I open a window using previous code without getting immediatly return value of open method, can I get it in a second moment ? For example using the value of param sName of open method ? regards Tag: Probems with Replace Command Tag: 314644
  - 25
    - Deleting blank lines from text file I have a text file being create with the FileSystemObject. It's being built based on results from a SQL query. All this is working fine, but so that I have a carriage return VBCRLF at the end of each row, I have an empty row at the end of my text file. How do I delete this last line? Here is the end of my script: csvText=csvText & vbcrlf rs.movenext loop How should I do this? Thanks!! *** Sent via Developersdex http://www.developersdex.com *** Tag: Probems with Replace Command Tag: 314640
- Next
  - 1
    - £ to $ conversion Hi I want to be able to show prices in £ to UK customers and $ for every one else. Is there a way to do this. Thanks D Tag: Probems with Replace Command Tag: 314636
  - 2
    - ASP Classic and .Net Components Hello, I have just moved an ASP Classic website to a new hosting company that has a number of .NET components available. The website works fine after the move with one exception. We were creating PDFs using ASPPDF for ASP but now it looks like only ABCPDF.NET is available. My knowledge of ASP.NET is very limited at this time and I am planning on converting the site to ASP.NET soon but I really need to get the PDF working as soon as I can. Is any of the following possible... 1) "wrap" the ASPPDF com control so I can use it at the new hosting company as a workaround for now? This would be the easiest for me as I would not need to change the asp classic code (maybe a little). Maybe place the asppdf com control in the .bin directory? The control does need registered in it's current form. 2) access the ABCPDF.NET component from a classic asp page? 3) write the pdf code in ASP.NET and then call that code from an ASP Classic page? If I write this as a web service can I call the web service from an ASP Classic page? I would need to pass a parameter, maybe two parameters to the pdf code 4) I am open to any suggestion other then migrate the website to asp.net at the moment as I need to get this up and working in the next few days if possible. If you have any thoughts on this subject please let me know. (code samples would be wonderful!!) Cheers, Rhek Tag: Probems with Replace Command Tag: 314634
  - 3
    - Performance problem when moving to new server Hi All, We need to move an old asp database application that I wrote to a new server. But when we do we start getting serious performance problems as more and more users connect. By old I mean old, its using a MS Acccess 97 database as the back end which is on the server also. There are no code changes just a streight move from the old server to the new server. I testing it seemed ok, its only when a few users start connecting that the performance get really bad. It seems the initial connection time is one of the obvious problem areas. The original server is running on Windows 2000 Service Pack 4 with IIS 5 The new server is running on Windows 2003 Service Pack 1 with IIS 6. Whats different between the two versions that mightr be causing this problem. Can anyone help? TIA Brian Tag: Probems with Replace Command Tag: 314632
  - 4
    - display problem Hi, I have a strange problem when i try to display my data on a web page. Everything's fine until i try to display a Date Value. If i try to display this, no problem : obj("data1") obj("data2") obj("data3") obj("data4") But if i try to display this, only "data1" and "data2" will by displayed : obj("data1") obj("data2") obj("DateData") obj("data1") (if i put DateData at the beginning, i will have a blank page) (if i put DateData after Data1, only Data1 will be displayed) did someone have any idea of my problem ? Thank you Tag: Probems with Replace Command Tag: 314631
  - 5
    - Charset in XMLHTTP or an alternative solution? Hi, I'm trying to get some data from an external website using XMLHTTP, but my problem is that the data is with special danish characters in (ÆØÅ), which are being replaced with "?" due to UTF-8. I've tried to specify the charset using response.charset, but that doesn't seem to have any effect. Any suggestions, or alternative solutions to XMLHTTP? Thanks. -- Med venlig hilsen Sune Christesen http://www.ActiveWebs.dk/ Tag: Probems with Replace Command Tag: 314630
  - 6
    - Correct HTTP response status code on "Access Denied" page. Hi, I have a password-protected area on my site. I'm not using any server authentication methods: Instead I prompt the user for a username and password using an HTML form and check these against a database of registered users. I was thinking that this page should be returning a HTTP status code of "401 Unauthorized" instead of its current "200 OK". My reasoning being that this would let search engines know what's going on when they request a protected page and get redirected to the "Access Denied" page. I experimented with adding response.status = "401 Unauthorized" to the "denied" page, but now it displays a (Windows/IE) username & password prompt instead. The HTTP sniffer shows that the www-authenticate field is set to "Basic". My question: How can I indicate to the search engines that the page it is requesting requires authentication, yet have it not display the login/password dialog box? Thanks in advance, --Diarmaid McGleenan Tag: Probems with Replace Command Tag: 314628
  - 7
    - Looking for mutliple file downloader Is there such a component that makes downloading multiple files easy? Thanks Jon Tag: Probems with Replace Command Tag: 314620
  - 8
    - LOGON_USER becomes null Hi, I create a web site in a Windows 2003 server/IIS6, and I used asp pages to get ServerVariables. After I set FrontPage Extension 2002, some ServerVariables like LOGON_USER become null. Any body has an idea? Tag: Probems with Replace Command Tag: 314612
  - 9
    - Importing comma delimited file I've been asked to develop a semi-automated type situation where we have a database table (sql server) and periodically, there will be a comma delimited file from which we need to import the data, replacing the old. I naurally know that we can use [truncate tablename] to kill the other data, but does anyone have any examples of importing a comma delimited file into SQL Server with ASP? Tag: Probems with Replace Command Tag: 314610
  - 10
    - Session Problems with Desktop Shortcuts in IE I have an issue that I've been encountering in an ASP application I'm working on. Most of the application is written in ASP, but there is one page written in ASP.NET. The ASP.NET page needs to have access to the ASP Session data to run correctly. In order to achieve this I create my own HTTP request for a certain ASP page with the name of Session variable that I want is stored in the query string of the request. The requested ASP page sends back the Session value in the response (you can see more on this at http://searchvb.techtarget.com/vsnetTip/1,293823,sid8_gci951935_tax293033,00.html). This seems to work in general but we have noticed a few difficult to reproduce problems with this. When multiple instances of the web app are set up in different virtual directories and the user creates desktop shortcuts to access each installation, there appears to be problems with the Session data. When the user opens up more than one shortcut at once, it looks as though all the browsers are running under one IEXPLORE.EXE process. This would explain things if the ASPSESSIONID cookie, which holds the ID for the Session data to use for a particular user, is held in the shared process. However, on different servers the Session bug is not always reproducible. In other words if the user has a desktop shortcuts to "http://Server1/app1/login.asp" and another to "http://Server1/app2/login.asp", the Session accessing will have problems. However if you do the same thing on a different server, that is "http://Server2/app1/login.asp" and to "http://Server2/app2/login.asp", the bug will *not* occur. The servers are running different versions of Windows and IIS, so I'm sure that has something to do with it, but I just can't figure out what. Through some experimentation using FireFox and Live HTTP Headers, we found that sometimes FireFox will contain two ASPSESSIONID cookies, where the characters after "ASPSESSIONID", but before the '=' sign, are different. Since both FireFox browsers were running in the same process and yet somehow correctly handled the Session data, we assumed these extra characters helped the server distinguish which Session data the browser needed. However, these cookies have magically stopped appearing (though FireFox still seems to handle the Session correctly). And I've never gotten the multiple cookie thing to happen in IE. Has anyone heard of this issue? Since people use desktop shortcuts quite a bit, I would have expected this issue to have occurred a number of times in the past, but I'm having trouble finding any info on it. Dave Tag: Probems with Replace Command Tag: 314609
  - 11
    - Indenting HTML code in a textarea the question is simple... is there any way to indent HTML code inside a simple textarea?... tnx! martin Tag: Probems with Replace Command Tag: 314605
  - 12
    - trying to open excel from a page (changes in 2002+) hi.. i'm trying to have excel open up a webpage which basically contains a table. in excel 2000 if i specify content type text/csv this works by displaying an open/save dialog box and clicking open, launches excel and displays data as a table (desired result ) however in machines with excel 2002+ excel simply displays the html code. trying to specify application/excel opens an excel plug-in inside the browser which poses a problem becouse the excel has links to pdf file that obscure the plug-in. Tag: Probems with Replace Command Tag: 314603
  - 13
    - 100% height of a div inside a TD This is a multi-part message in MIME format. ------=_NextPart_000_0080_01C5ABC5.EFAC9860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've got the problem described in the table above. I've put a div red with some text inside a TD, but its height is less = than 100% of TD height as you can see. I've defined the following styles: div.test { background-color:red; height:100%; width: 100%; }=20 table.test { border: 1px solid #CCCCCC; background-color:yellow; }=20 td.test { border: 1px solid #CCCCCC; } does anyone know a solution ? Please help me. Regards to all 2 2b 1=20 4 5=20 7 8=20 ------=_NextPart_000_0080_01C5ABC5.EFAC9860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY><FONT face=3DArial><FONT size=3D2> <DIV> <STYLE> div.test { background-color:red; height:100%; width: 100%; } =09 span.test { background-color:blue; height:100%; width:100%; }=09 </STYLE>  I've got the problem described in the table above.</DIV> <DIV> </DIV> <DIV>I've put a div red with some text inside a TD, but its height is = less than=20 100% of TD height as you can see.</DIV> <DIV> </DIV> <DIV>I've defined the following styles:</DIV> <DIV> </DIV> <DIV>div.test { background-color:red; height:100%; width: 100%; } </DIV> <DIV>table.test { border: 1px solid #CCCCCC; background-color:yellow; } = </DIV> <DIV>td.test { border: 1px solid #CCCCCC; }</DIV> <DIV> </DIV> <DIV>does anyone know a solution ?</DIV> <DIV> </DIV> <DIV>Please help me.</DIV> <DIV> </DIV> <DIV>Regards to all</DIV> <DIV> </DIV> <DIV> <STYLE> div.test { background-color:red; height:100%; width: 100%; } =09 span.test { background-color:blue; height:100%; width:100%; } table.test { border: 1px solid #CCCCCC; background-color:yellow; } td.test { border: 1px solid #CCCCCC; } </STYLE>  =20 <STYLE> div.test { background-color:red; height:100%; width: 100%; } =09 span.test { background-color:blue; height:100%; width:100%; } table.test { border: 1px solid #CCCCCC; background-color:yellow; } td.test { border: 1px solid #CCCCCC; } </STYLE> <TABLE class=3Dtest id=3DTable1 cellSpacing=3D0 cellPadding=3D0 = width=3D300 border=3D0> <TBODY> <TR> <TD class=3Dtest>2<BR>2b</TD> <TD class=3Dtest> <DIV class=3Dtest>1</DIV></TD></TR> <TR> <TD class=3Dtest>4</TD> <TD class=3Dtest>5</TD></TR> <TR> <TD class=3Dtest>7</TD> <TD = class=3Dtest>8</TD></TR></TBODY></TABLE></DIV></FONT></FONT></BODY></HTML= > ------=_NextPart_000_0080_01C5ABC5.EFAC9860-- Tag: Probems with Replace Command Tag: 314602
  - 14
    - asp component error Hi I am having a problem with a com object on WinXP Pro. It is properly registered, but gives me the following error: Server object error 'ASP 0177 : 800401f3' Server.CreateObject Failed /code/cgi-sec/upload.asp, line 3 Invalid class string I do not have windows firewall active and it does the same thing with firewall/virus/spyware software disabled. It runs fine on my Win2K Pro desktop. The MS Knowledgebase entries are no help. Thanks fo all help, Bill Tag: Probems with Replace Command Tag: 314601
  - 15
    - Functions pass by ref or by value? I have a function called GetRS which takes in a SQL string and returns a recordset object. Does this mean that a copy of the recordset is returned or is it passed by reference? Obviously this could have a large impact on performance for large recordsets. Tag: Probems with Replace Command Tag: 314596
  - 16
    - ASP does not work We have a new installation of Win XP Pro, SP2 with IIS 5.1. None of the ASP pages will function - they just display ALL the code on the page, including code between script tags. .asp is listed in Application Mappings for the Default Web Site properties. Seems like I'm missing something obvious...??? Tag: Probems with Replace Command Tag: 314591
  - 17
    - Best ASP 3.0 Editor? This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C5AA56.CF8386E0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I'm currently using Dreamweaver MX as my editor but continually have = problems with it. Any suggestion for a "lighter" weight editor for 3.0? Kev ------=_NextPart_000_000A_01C5AA56.CF8386E0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-1252"> <META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I'm currently using Dreamweaver MX as = my editor but=20 continually have problems with it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any suggestion for a "lighter" weight = editor for=20 3.0?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Kev</FONT></DIV></BODY></HTML> ------=_NextPart_000_000A_01C5AA56.CF8386E0-- Tag: Probems with Replace Command Tag: 314588
  - 18
    - Displaying carriage returns in a memo field Can someone please help with a suggestion as to how I can keep the formatting (carriage returns) that the user enters into a memo field and then display that later. I figured I might be able to use: 'replace carriage returns with BRs comment=Replace(comment, chr(13), "<br>") but obviously net.! The <pre> tag doesn't sem to help either as the embedded return is lost by the time you get past Request.Form...... thanks .les. Tag: Probems with Replace Command Tag: 314584
  - 19
    - Date Question Hi all, I need a script that tells the user what the date is for monday and what the date is for friday for the current week based on the current day. Any help? Tag: Probems with Replace Command Tag: 314580
  - 20
    - User Account Security Hi I'm trying to design a web application where people can create user Ids and passwords while signing up and then use that information to login to an account. (I know, very basic). I just can't get my mind around how to make this system most secure. the user id and password is verified at the time of logging in and at that point, I would like to create something like a session key before openning the new page. I basically don't want to start the new page by passing regular parameters through the URL because that's very easy to manipulate and break. Can someone give me some information about creating a secure system like this and/or forward me some useful sources?? btw.. I'm using, IIS as my server, ASP.Net and VB.Net. Thanks Farsad Tag: Probems with Replace Command Tag: 314579
  - 21
    - MSXML posting SOAP message with Client Certificate I get the following error, I've seen many news forum with similar issue but never a concrete solution. anyone have an idea what could be causing this not to work? msxml4.dll (0x80072F0C) A certificate is required to complete client authentication Here's the code: strPostToURL = "https://cert.here.com/SOAP/" strCert = "cert.here.com" strRequest = server.MapPath("/xml/Sample_XML.xml") set objXMLDocument = CreateObject("MSXML2.DOMDocument.4.0") objXMLDocument.async = false objXMLDocument.load(strRequest) set objSrvHTTP = CreateObject("MSXML2.ServerXMLHTTP.4.0") objSrvHTTP.setOption 3, strCert objSrvHTTP.open "POST", strPostToURL, false objSrvHTTP.setRequestHeader "content-Type","text/xml" objSrvHTTP.send objXMLDocument <-------------------- Error occurs here Response.Write objSrvHTTP.responseText Set objSrvHTTP = Nothing Set objXMLDocument = Nothing Response.End Resources I've looked up and followed that didn't help: http://support.microsoft.com/default.aspx?scid=KB;en-us;q290761 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q294266 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q301429 http://support.microsoft.com/kb/289481/ http://support.microsoft.com/kb/302080/EN-US/ Tag: Probems with Replace Command Tag: 314578
  - 22
    - Posting Data From .aspx to WorldPay Hi, I am writing a script that requires two actions performed on the same page; 1) upload pictures and store them on the server & 2) Send all of the variables from the WebForm to the WorldPay servers via the POST method. I am aware of the Server.Transfer and Response.Redirect methods but neither of these will do what I want. Are there any soluitions out there in C# that I can used to do this easily (running out of time on this project!)? Thanks for your help. Tag: Probems with Replace Command Tag: 314577
  - 23
    - Using ScanLine I'm trying to create an asp page for Scanline from Foundstone (http://www.foundstone.com/index.htm?subnav=resources/navigation.htm&subcontent=/resources/proddesc/scanline.htm) with the asp below. (for our network monitoring site) sl.exe starts on the web server processor goes to 50% but just hangs there. The asp page then eventually times out. (I have to kill the sl.exe process on the server) Any ideas where I'm going wrong.... [-------------code---------------] Dim wshShell Dim oResult Set wshShell = CreateObject("WScript.Shell") Set oResult = wshShell.Exec("sl -nsr "&startaddress&"-"&endaddress) Do Until oResult.StdOut.AtEndOfStream oline=oResult.StdOut.Readline&"<br>" response.write oline Loop Set oResult = Nothing Set wshShell=Nothing [-------------code---------------] Many Thanks Tag: Probems with Replace Command Tag: 314574
  - 24
    - how do I upload files to server? Hi, I need to allow a user to upload images to my website. I can't use an asp.net solution, just asp 3.0. Please advise. many thanks, NEIL Tag: Probems with Replace Command Tag: 314572
  - 25
    - Odd "Invalid class string" error In an asp page in localhost I have this: Set x = Server.CreateObject("Scripting.Dictionary") And I get this error: Invalid class string If I omit Server like this: Set x = Server.CreateObject("Scripting.Dictionary") I get this error: ActiveX component can't create object: 'Scripting.Dictionary' In the same asp page this works fine: Set conn = Server.CreateObject("ADODB.Connection") In a Visual Basic application this works fine, too: Set x = CreateObject("Scripting.Dictionary") I reinstalled VB without success. Why do I get "Invalid class string" in the first case? Tag: Probems with Replace Command Tag: 314568

Hi,

I am facing problems with the replace command in classic ASP.

my code is as follows:
.........
test = Replace(test,"xxxx/xxxxxxxxxx","yyy/yyyyy",,,1)
.........

I want to use compare method as vbTextCompare i.e. 1
When I remove this parameter, it works fine.

the error is as follows:
Microsoft VBScript runtime error '800a000d'
Type mismatch

Can someone kindly help me out with this

Thanks in advance

Top

Re: Probems with Replace Command by McKirahan

McKirahan
Fri Sep 02 20:12:17 CDT 2005

"Jimmy" <abhishekbhattj@yahoo.com> wrote in message
news:1125709039.709089.70460@g47g2000cwa.googlegroups.com...
> Hi,
>
> I am facing problems with the replace command in classic ASP.
>
> my code is as follows:
> .........
> test = Replace(test,"xxxx/xxxxxxxxxx","yyy/yyyyy",,,1)
> .........
>
>
> I want to use compare method as vbTextCompare i.e. 1
> When I remove this parameter, it works fine.
>
> the error is as follows:
> Microsoft VBScript runtime error '800a000d'
> Type mismatch
>
>
> Can someone kindly help me out with this
>
> Thanks in advance
>

What a value of the variable "test"?

We need to simulate/duplicate your problem.

Top

Re: Probems with Replace Command by Jimmy

Jimmy
Mon Sep 05 09:14:48 CDT 2005

Hi ,

Thanks for looking in to the issue.
I was able to resolve the error I used the following code:

test =3D Replace(test,"xxxx/xxxxxxxxxx"=AD,"yyy/yyyyy",1,-1,1)

By The way, the value of test was HTML Content
Thanks Again.

Top