Web Development

FirstPrevNext

Re: Server.MapPath Guffa4-Apr-06 23:42 Guffa 4-Apr-06 23:42  You have to get a reference to the actual page that is being created. Use HttpContext.Current.Server.MapPath(). --- b { font-weight: normal; } Re: Server.MapPath Larza1235-Apr-06 20:45 Larza123 5-Apr-06 20:45  Thanx! That worked! ASP casimirrex4-Apr-06 22:04 casimirrex 4-Apr-06 22:04  Hi, In ASP,how to move the data from an excel sheet to excel sheet. to bear my hand to me regards rex Re: ASP Sushant_Mathur4-Apr-06 22:44 Sushant_Mathur 4-Apr-06 22:44  You can use VBScript in your ASP code which will do the same... first you have to open a database coinnection string like strConn = "DRIVER={Microsoft Excel Driver (*.xls)}; DBQ=MY.xls" oC.Open strConn 'then fetch value from your worksheet strPath = "select VALUE From [WKSHEET$]" 'now put this value to new worksheet Hope this will help you Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm in asp casimirrex4-Apr-06 22:01 casimirrex 4-Apr-06 22:01  how to rename the work sheet in excel document using with ASP have you an any idea,to tell me thanking you regards rex Urgent help needed : Reading from a .htm file using VBScript giftsana4-Apr-06 20:28 giftsana 4-Apr-06 20:28  I am new to VBScripting. have only worked on VC++,C# etc.Kindly help me with this. I have to develop a module using VBScript. The VbScript should be able to open an existing .htm file(this .htm file has a list of drivers name and file name). The VBScript has to basically be able to open this .htm file, pick out all drivers name and associated file name and log the driver and file names into a simple text file. Being new to VBScripting i do not have an idea how to go ahead. Pls suggets me a way to do this - if there is a sample code existing kindly inform me. Thanks in advance. Awaiting a reply soon. Sincerely Giftsana Re: Urgent help needed : Reading from a .htm file using VBScript Sushant_Mathur4-Apr-06 20:51 Sushant_Mathur 4-Apr-06 20:51  This is the code you need..hope this will help you _________________________________________________ set fso=createobject("scripting.filesystemobject") Function read_data() s="" set f=fso.getfile("c:\source.htm") 'read data from source file set ts=f.openastextstream(1,0) 'read,ascii s=s & ts.readall ts.close set ts=fso.CreateTextFile("C:\destination.txt",true,false) 'overwrite,ascii s=clearAllTags(s) ts.write s ts.close End Function 'This function will remove all the HTML,BODY tags from our data and write only data from htm file Function clearAllTags(s) Dim re Set re = New RegExp re.Pattern = "(<[^>]*>)" re.Global = True re.IgnoreCase = True clearAllTags = re.Replace(s, "") End Function _________________________________________________ Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm Re: Urgent help needed : Reading from a .htm file using VBScript giftsana4-Apr-06 21:18 giftsana 4-Apr-06 21:18  Hi Sushant Thanks a lot for the prompt reply with the sample code. I shall try with this. Thanks again Sincerely Giftsana Singapore Re: Urgent help needed : Reading from a .htm file using VBScript giftsana4-Apr-06 22:07 giftsana 4-Apr-06 22:07  Hello Sushant I opended an .htm file and copied the code you gave. there is an error in the following line: where is removed defined? i get the message "Could not find any attribute 'removed' of element 'body'." so i replaced 'removed' with 'onload' but i cannot find any .txt log file created in the folder. Kindly let me know what is 'removed' used for? do we have to define it elsewhere? Awaiting a reply. Sincerely Giftsana Re: Urgent help needed : Reading from a .htm file using VBScript Sushant_Mathur4-Apr-06 22:35 Sushant_Mathur 4-Apr-06 22:35  actually there was onload in BODY tag but when i paste my code hereit automatically becomes removed ...don't know why and i have checked again and its working fine here... try again and let me know Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm Re: Urgent help needed : Reading from a .htm file using VBScript giftsana4-Apr-06 23:06 giftsana 4-Apr-06 23:06  Hi Sushant Thanks again for informing me of the above. I tried running it with again, but i still cant see the Log file created? Below is my code, cld you suggest me where am i going wrong? <title>DaVinci Driver Logger Set objfso = CreateObject("scripting.filesystemobject") Function read_data() s = "" Set f = objfso.GetFile("c:\DaVinci-1 Latest Driver List (US).htm") Set ts = f.openastextstream(1,0) s = s & ts.readall ts.close set ts = objfso.CreateTextFile("c:\DaVinciLog.txt",true,false) s = clearAllTags(s) ts.write s ts.close End Function Function clearAllTags(s) Dim re Set re = New RegExp re.Pattern = "(<[^>]*>)" re.Global = True re.IgnoreCase = True clearAllTags = re.Replace(s,""); End Function Sincerely Giftsana Re: Urgent help needed : Reading from a .htm file using VBScript giftsana4-Apr-06 23:09 giftsana 4-Apr-06 23:09  FYI I have used in the code. when i copied and pasted it shows removed as you said. Sincerely Giftsana Re: Urgent help needed : Reading from a .htm file using VBScript Sushant_Mathur4-Apr-06 23:19 Sushant_Mathur 4-Apr-06 23:19  do one thing i have uploaded my code on the below URL.just download this code and then try again. http://n.domaindlx.com/fun2ssh/Code.txt[^] Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm Re: Urgent help needed : Reading from a .htm file using VBScript giftsana4-Apr-06 23:36 giftsana 4-Apr-06 23:36  Thanks for the prompt reply and for downloading the source. Sorry for bothering again. Let me try it. Thanks again. Sincerely Giftsana Re: Urgent help needed : Reading from a .htm file using VBScript Sushant_Mathur4-Apr-06 23:45 Sushant_Mathur 4-Apr-06 23:45  download this file and if it will open in browser take code from view->source Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm Re: Urgent help needed : Reading from a .htm file using VBScript giftsana4-Apr-06 23:54 giftsana 4-Apr-06 23:54  Yes i did that, took code from view->source I opened a new html(DriverLog.htm) page and copied the code. On trying to open this .htm file(DriverLog.htm) from IE, i see a message "An ActiveX control on this page might be unsafe to interact with other parts of the page.Do you want to allow this interaction?" on hitting the "Yes" button i see "Error on page" message and no log file is created. Kindly suggest if i missed something. Thanks again for your patience and replying to my queries. Sincerely Giftsana Re: Urgent help needed : Reading from a .htm file using VBScript Sushant_Mathur5-Apr-06 0:00 Sushant_Mathur 5-Apr-06 0:00  Can u please clik on that error symbol and let me know what is the error?? because its working fine here. That active X prompt will come.needn't worry Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm Re: got solution! giftsana5-Apr-06 0:24 giftsana 5-Apr-06 0:24  The error is foll: Line: 13 Char: 1 Error: File not found Code: 0 It was not getting the proper source file path at the foll line set f=fso.getfile("c:\DaVinciDriver.htm") 'read data from source file so i changed this to(hardcoded) -> set f=fso.getfile("C:\Giftsana\ATS Modules\ATS DaVinci Driver Logger\DaVinciDriver.htm") So now the log file is created and i can see the driver name etc! is there a function to get the path of the source file(.htm) ,cos here i am hardcoding the path? Thanks again for replying to all my queries and helping me get a solution! Thank You. Sincerely Giftsana Re: got solution! Sushant_Mathur5-Apr-06 0:31 Sushant_Mathur 5-Apr-06 0:31  Yes to do this use and you can take value from there. and no thanks its my pleasure ----------------- sample code to do the above Sub button_1_onclick dim file_val file_val=Document.frm1.val.value End Sub --------------- Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm Re: got solution! giftsana6-Apr-06 0:52 giftsana 6-Apr-06 0:52  Hello Sushant Thanks. i have another query which i tried getting sol but cldnt. the log file that i retrive frm the above opern returns all data, i want to extract only the driver name and file name from the .txt file? is it possible in vbscript? for ref here is a part of my text file the IBM Confidential information. Driver/Utility Name <ThinkPad Utility> ThinkVantage Productivity Center 79uz02ww.zip 11/25/05 1.02 O O Productivity Center Supplement for ThinkPad 79uy01ww.zip 11/25/05 1.01 and so on... i have to retrieve only "Productivity Center Supplement for ThinkPad" and "79uy01ww.zip" and likewise other drivers / filenames in the text file above. i have been trying without succes? or is it possible to filter these frm the .htm file itself, by identifying driver name after some special character? Sincerely Giftsana Re: got solution! Sushant_Mathur6-Apr-06 20:09 Sushant_Mathur 6-Apr-06 20:09  I am sorry for replying late...actually it is possible if we use some string function but not sure which one tell u after some time Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm Re: got solution! giftsana6-Apr-06 20:29 giftsana 6-Apr-06 20:29  Sure, Thanks for the reply. I am really sorry for bothering you, but am helpless as i have no clue as to which func to use in VBScript. fyi: i have posted a new message with the sample html file, although some tags r missing while posting, Cld you have a look at this htm file and suggest what RegExp pattern i shld set to extract the driver name and file name and log to txt file? Sincerely Giftsana follow vertical scroll bar e32magic4-Apr-06 13:51 e32magic 4-Apr-06 13:51  hello... everyone... need some help... i have a page that's really long... and it has a "SAVE" button at the very bottom of the page... i saw an idea but do not know how to implement... question is how can the "SAVE" button follow the vertical scroll bar button when the user scrolls up/down??? so, the user does not have to scroll to the bottom of the page to see the "SAVE" button... thanks... e32 Re: follow vertical scroll bar Sushant_Mathur4-Apr-06 20:11 Sushant_Mathur 4-Apr-06 20:11  You can check pixel values of the scrollbar using document.body.scrollTop(IE only) and window.pageYOffset(Non IE).This will return value in pixels so take this and each time set this value in the position attribute of your SAVE image button. Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm help me ..... rss to asp zybernau4-Apr-06 9:14 zybernau 4-Apr-06 9:14  hi all, help me i need a simple asp code for reading a livefeed from a site and display the info to my site RaJ

Last Visit: 31-Dec-99 18:00     Last Update: 29-Apr-24 1:19 Refresh ᐊ Prev1...920921922923924925926927928929 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.