Getting a block of data from with a text file

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
    - access insert statement I am used to SQL Server, no Access, but this one thing has to be done in Access. Can you tell me if this query will work, based on the syntax? I am trying create a new row on the database, in one table, and the primary key is an Autonumber called PersonalID. This is on the second page, which shows after the personal has filled out some info on the first page, then submitted the form using POST. Database name is Shape, and table is named Personal. ----------------------------------------------------------------------- DB_CONNECTIONSTRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & _ Server.Mappath("Shape.mdb") & ";" Set objRecordset = Server.CreateObject("ADODB.Recordset") objRecordset.Open "Shape", DB_CONNECTIONSTRING, adOpenStatic, adLockPessimistic, adCmdTable strFirstName = Replace(Trim(Request.Form("FirstName")),"'","''") strLastname = Replace(Trim(Request.Form("LastName")),"'","''") strSQL = "set nocount on; INSERT INTO Personal(FirstName,LastName) VALUES (strFirstName,strLastName); select @@identity [newid];" Set rs=objConnection.execute (strSQL) strPersonalID = RS("newid") rs.Close Tag: Getting a block of data from with a text file Tag: 270479
  - 2
    - Obtain users IP address? How does one capture the IP address of the user ....and...is there anything 'unique' you can do with this info besides knowing the ip number of his domain/browser? Thanks Jason Tag: Getting a block of data from with a text file Tag: 270474
  - 3
    - Double Insert :: best route? If one is attempting to insert data into tables at the same time what is the best way to do this. I could do it the way below - but is there any reason I should not do it this way or perhaps follow a better route. The second table is really an audit table to track changes made by the user Set cnn = CreateObject("ADODB.Connection") strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("../database/listings.mdb") '//This one is for Access 2000/2002 cnn.Open(strCon) SQL = "INSERT INTO tblCustomer (email_address, first_name, last_name) VALUES(" SQL=SQL & "'" & email_address & "', " SQL=SQL & "'" & first_name & "', " SQL=SQL & "'" & last_name & "', " cnn.Execute(SQL) SQL = "INSERT INTO auditCustomer (email_address, first_name, last_name) VALUES(" SQL=SQL & "'" & email_address & "', " SQL=SQL & "'" & first_name & "', " SQL=SQL & "'" & last_name & "', " cnn.Execute(SQL) Tag: Getting a block of data from with a text file Tag: 270473
  - 4
    - Windows 2000 Server - Make support ASP Hello.. I really need some help here, Maybe it is simple :S I have Windows 2000 Server. Running IIS 5. I created a ASP file that connects to a database and when i go to view it, It either says that there is a error in the code on like 106.. Which is only an "End If" command, Or it will say that this page needs to be posted on a web server that supports ASP. Well.. I have indexing service running, And I know for a fact that the code in the page is correct because it works on other 2000 server! Please email me at thowle@elwoh.com Tag: Getting a block of data from with a text file Tag: 270464
  - 5
    - Big favour needed to test site combos Hi All I know this is a big favour, but I knew I'd get good honest feedback from you. Basically users are saying that I'm having time out problems with a site of mine, but I can't pin it down because it's OK when I look at it on my dial-up. I know there must be something wrong because of the amount of complaints. The way the site works is that it you click the 'Latest Addtions', 'Product Lists' and 'Specials' links on the left hand side and this displays individual product lists that you can page through with the next and previous pages at the bottom. Now the 'Product Lists' button should display a pop-up menu where you can select more of these lists. This is where my big favour comes in. What I've done is create 4 versions of the same site with each having the same visible look but each having a different internal/background change. If possible, could you please do the following for me and let me know your feedback: 1) Go to http://www.bardwells.co.uk and just click through the product lists as I have mentioned above. PLEASE NOTE: as I have put the test sites together some of the pages may not display correctly so could you please ignore this. It is how many time outs you experience (if any) whilst navigating round the site. Could you please note down how many time outs you get. 2) Go to http://www.bardwells.co.uk/test211/ and just click through, etc, etc Could you please note down how many time outs you get. 3) Go to http://www.bardwells.co.uk/test221/ and just click through, etc, etc Could you please note down how many time outs you get. 4) Go to http://www.bardwells.co.uk/test222/ and just click through, etc, etc Could you please note down how many time outs you get. I know it's a lot too ask, but I'm tearing my hair out with it and it shouldn't take that long to be honest. Many, Many thanks. Rgds Laphan Tag: Getting a block of data from with a text file Tag: 270444
  - 6
    - problem running aspx Anytime I try to load an aspx file in my browser from my iis server or try to run the debugger in VS7 web project to debug aspx, I get Server Application Error. In the event log it says this: The server failed to load application '/LM/W3SVC'. The error was 'The specified metadata was not found. Does anybody know what this means and how to fix it? Tag: Getting a block of data from with a text file Tag: 270443
  - 7
    - 1 or many ASP files?? Hi All Just trying to clear my cluttered mind and wondering if you can help. IYHO, if I have say 10 different product categories that extract their data from say 10 text files or an Access DB, is it more efficient to have an ASP for each product category to query each section or 1 which parses the lot?? The only reason I am asking is for multiple user access I have this strange belief that if 1 page is getting requested and queried by 10 simultaneous visitors then 'spreading the load' on different pages would help. Is my logic correct or do the ISP fairies have this in hand?? Many thanks. Rgds Laphan Tag: Getting a block of data from with a text file Tag: 270434
  - 8
    - Tab-delimited or CSV - Performance difference??? Hi All Due to using a combo of OLEDB/ADO/ASP and JavaScript I was having trouble reading in CSV data so I converted my client's web site to use tab-delimited instead. Better for me, but client is adamant that their site's recent timeout problems are since I converted to this tab format?? God forbid, but can the end user actually be technically right? Is there an issue using tab files rather than csv?? I noticed that if you use csv you don't need a schema.ini, but you do if you use tab files. Does Microsoft think everybody uses CSV and work better with this format?? Regards Laphan Tag: Getting a block of data from with a text file Tag: 270432
  - 9
    - Missing Something Obvious Here! I am trying to define the active connection for a command in an ASP page but I keep getting the error: --------------------------------------------- ADODB.Command error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /LoginControl.asp, line 19 -------------------------------- Line 19 is the "cmdDC.ActiveConnection = myConn" line. The code is as follows: ==================================== Dim cmdDC, RecordSet Dim strUserName, strPassword strUserName = Request.Form("txtName") strPassword = Request.Form("txtPassword") '-- Create command object Set cmdDC = Server.CreateObject("ADODB.Command") cmdDC.ActiveConnection = myConn ==================================== I use an include file at the start of the ASP page to establish my connection - the included code is:: ==================================== Dim cst, myConn Sub CreateConnection() cst = "Provider=SQLOLEDB; Data Source = xx.xx.xx.xx; Initial Catalog = myDB; User ID = myID; Password=myPW" set myConn = Server.CreateObject("ADODB.Connection") myConn.open cst End Sub ==================================== Any suggestions on what I did wrong here? -- ------------------------------------ Wayne Wengert wayne@wengert.org Tag: Getting a block of data from with a text file Tag: 270428
  - 10
    - UTF-8 and FSO Hi i have two files with korean characters one is UTF-8 and other is unicode saved .. if i try to ead unicode one .. it goes fine but throw garbage when i try to read UTF-8 saved txt file with FSO ... whats the difference .. y is it so Plz Help, Thankx in advance Qazi Tag: Getting a block of data from with a text file Tag: 270415
  - 11
    - Image Processing in ASP How can we carry out image processing (similar to PHP GD Library) to manipulate Images using ASP. Can we call Windows API functions for the same thru ASP? Tag: Getting a block of data from with a text file Tag: 270414
  - 12
    - Session objects and POSTed Form items Hi all, Anyone know of any issues with setting the value of a Session object to the value of a submitted form item via 'Session("mySessionObj")=Request.Form("myFrmElem")' ? In my case the Session object gets set fine. But when the user links to another page, the value of the session object is EMPTY. thanks in advance.. -BB Tag: Getting a block of data from with a text file Tag: 270411
  - 13
    - problem with CreateObject Does anybody know why the second statement below hangs the call to the server. I am running Win2000 , SP4, IIS 5.0 on a local machine. I recently applied SP4 and had to re- install IIS. The code use to work okay under Sp3. Set TypeLib = Server.CreateObject("Scriptlet.TypeLib") TempGUID = TypeLib.Guid Response.Write TempGUID & Chr(13) & Chr(10) Set TypeLib = Nothing Thank you Jim G Tag: Getting a block of data from with a text file Tag: 270410
  - 14
    - Embedding images in e-mail? Hi, I need to create HTML e-mail from an ASP program that includes embedded images that go along with the e-mail, e.g. logos, product image, etc. Is there a technique in HTML that people use to embed images? I know that when I insert an image into an e-mail in Outlook, and I look at the HTML behind it, there is a funny tak CID: IMG hspace=0 src="cid:027301c29d8e$da6ba600$0afea8c0@MYMAIN" align=baseline border=0> Any clues? Thanks! Tag: Getting a block of data from with a text file Tag: 270399
  - 15
    - Memory Usage By dllhost.exe Under IIS Hello. I'm new to the news group and new to IIS. I'm trying to help a client deal with memory usage issues in IIS. My client is running IIS 5.0 on a Win2K box and is running ASP scripts that both talk to an Active X Control written in C++ as well calls directly into the ADO layer. It seems that basic interaction with the ADO layer and Active X Control causes the dllhost.exe process to use more and more memory until the machine becomes wedged. It seems that removing the interaction with the database and with the Active X control helps significantly, but not completely. I can make memory usage go up indefinitely just by concatenating strings together in a loop. Once the loop ends, the memory doesn't come back, even after 15 or 20 minutes of idle time. Switching to VB Script from Java Script doesn't seem to help. I'd like to know if there's a book out there or a reasonably up to date web site that discusses best coding practices for making database calls via ADO from IIS approved scripting languages. My client's ASP scripts seem to be matching the examples I've found online. The scripts close connections after each call; the scripts set all record set and connection objects to nothing/null when complete. I'd like to know also what constitutes reasonable ADO usage from an ASP script. One of my client's pages performs an outer query and then varying nested queries while processing the records of the outer loop. The result is potentially thousands of ADO queries. Trying to display this page in particular can easily eat up 300 megabytes and that memory never comes back. I'd like to know also if it's enough to set a handle to an Active X Control to nothing/null when one finishes with it in the scripting language when one finishes with it or if something additional is required to ensure that its resources are reclaimed. I've spent a lot of time searching on Google for others that may have run into this and found some horror stories as well as success stories. This leads me to believe that we probably have either a configuration problem or our scripts are missing some key step or steps for releasing resources. Thanks for your help, David Swift Tag: Getting a block of data from with a text file Tag: 270388
  - 16
    - conditional sql statements I have a shopping cart that I want to load items in that come from a huge scrolling form. In other words, when someone clicks on a category in our site, it scrolls out all the items in that category, maybe 30 or more. I have text boxes next to each item so somone can enter a number, then press submit form button at the bottom of the form, and send those slections to the shopping cart. The problem is, many of the text boxes are empty, yet they are still being sent to the shopping cart as a quatity of 0. Is there a way for sql to ignore a value if the variable is zero, or only get the sql statement to run if a variable is > 0? Thanks, Bill Tag: Getting a block of data from with a text file Tag: 270373
  - 17
    - Executing VBS file from ASP I've tried instantiating the Windows Script Host shell object in ASP, and I'm trying to run this command: "cscript.exe myvbs.vbs parameter1 parameter2"; however, the server runs cscript.exe very briefly, and the task ends. Note, it runs fine from a command prompt. Do I need to give the anonymous user any special permissions in order to do this? Thanks in advance, Jeff Cheung Tag: Getting a block of data from with a text file Tag: 270368
  - 18
    - Query Processing Time How can i set the Query Processing Time in my asp page. i am getting this error messages "Estimated query processing time 152 exceeds limit 30" John Tag: Getting a block of data from with a text file Tag: 270367
  - 19
    - "forced" download from ASP Hi All, First of all I'm mostly an MS Access guy (and novice learning MSSQL guy) and put on this project because of personnel changes, etc and because of db experience. I've only been doing this for about 2 months. I need to know how to "force" a download (patch) from an ASP page. I am developing an on-line internet registration page for students in the Residence Halls. Part of this project is getting their Res Hall/room number/port, MAC address, operating system, etc. This has been fairly straight forward and works reasonably well (my opinion). However since the Blaster/Welchia crap and the way they have been bouncing around our network with everybody coming back off summer vacation, 2 days ago the powers that be have decided to "force" the Blaster fix and then the patch to the students as they register for the internet. We are using the Symantec W32.Blaster.Worm Fix Tool 1.0.0 (our file is named patch.vbs). I don't know enough and quite frankly have a very limited amount of time in which to implement this. I've been to ASPFAQ, serverobjects.com and others, but it always seems that I miss or can not find or just plain don't understand the process. A lot of my questions are quite basic, I know, but.......... Where exactly is the best place to place the worm fixer file? How do I call it and get it to run on the students machine? I've downloaded ASPExec from serverobjects.com, but am unsure I have it set up correctly as I don't get notepad to show (per the example asp page) and I've registered the aspexec.dll and set the WWW service to interact with the desktop (per aspexec.txt). Is there a method of determining if the fix was run or allowed to finish running? ....because if they don't I'm told to not allow them to register and therefore restrict them to only a "closed" default vlan. Anything else I missed? (I always feel that way.) I'm sure there is more, but as I implied, I don't really know enough to ask the right questions. Any help down the path of "force" feeding will be certainly appreciated as we have students beginning to return this weekend. Thank you. gdr -- Gary D. Rezek University Networking Services South Dakota State University Tag: Getting a block of data from with a text file Tag: 270365
  - 20
    - Pull down and add I know how to enter data to a SQL database from a form. I am making a form where the user inputs some numbers. Than other users login to this other place and I want the number that the person imputed to be shown in a field multipled at a certain price. I am unsure how to pull the numbers down to display them and do the multiplcation. The multiplication will show up in another place on the page. Does this make sense? Tag: Getting a block of data from with a text file Tag: 270359
  - 21
    - anyone use Dreamweaver? I've been doing ASP by hand-coding in either Homesite or Interdev for years. I have been using Dreamwever for static sites that I make on the side. I recently was asked to make a form which will store info in an Access database, and thought it would be a good chance to learn how to use Dreamweaver MX's ASP capabilities. Haven't tried it yet, but reading up on it, it seems that it forces you to use Session variables. I'm not a big fan of session variables, and want to avoid them. Anyone here use DW MX for ASP? Got any thoughts or experiences you want to share? Tag: Getting a block of data from with a text file Tag: 270355
  - 22
    - File Exists Hello, Can anyone tell me if its possible to check to see if a remote (text) file exists, I'm currently using If (fs.FileExists("http://www.example.com/myfile.txt"))=true Then but this doesn't work Any ideas? Thanks in adance Gram. Tag: Getting a block of data from with a text file Tag: 270339
  - 23
    - indexing search I'm trying to set up a pdf search using windows indexing service, but i'm getting the most random results in the world. it's seatching throught a directory of just pdfs, and if i search for pdf, they all come up, but is i search for 103 then 103.pdf wont come up but things like 034.pdf and 29.pdf will - any ideas?! i'm using the windows IISSamples -- PSCA International web@publicservice.co.uk +44 (0) 1782 740088 Tag: Getting a block of data from with a text file Tag: 270315
  - 24
    - Keyword Parsing with ASP I am writing a search program in ASP(VBScript). The user can enter keywords and press submit. The user can separate the keywords by spaces and/or commas and key words may contain plain words, single quoted strings (phrases), double quoted strings (phrases). For example: Keywords: Jack, Jill, Jim, "Timothy Brown", Mary OR Jack Jill Jim 'Timothy Brown' Mary OR Jack, Jill Jim, 'Timothy Brown' "Mary" When I parse it i store the keywords in an array. The results must be: Jack Jill Jim Timothy Brown Mary I have tried doing this using Split but am unable to get the Phrases. Some suggestions, code examples or links would help. Thanks in advance ARK. Tag: Getting a block of data from with a text file Tag: 270313
  - 25
    - Qustion: ASP Q: I have an array with some values. so I have values Value(0,1) Value(0,2) Value(0,2) ...etc. since the values are different size, I'm using left(values(0,1),7) So I can take first 7 digits out. Normally I'm looping through the array and I'm using form like this: CDbl(Left(CStr(values(0, 1)),7)) Everything goes perfect, but when I put m insted of 1 check = True : m=1 do do while n<59 value1= CDbl(Left(CStr(values(0, m)),7)) m=m+1 if n=58 then check = False exit do end if loop returns message like this: Type mismatch: 'CDbl' How I can solve this so I can get normal value so I can for e.g. add 1 to value 1 Thanx Tag: Getting a block of data from with a text file Tag: 270308
- Next
  - 1
    - Variable from RecordSet only keeps the first word.? Huh.? Tearing heair out here ........... and there must be a simple solution. The words Joe Peter Smith are stored in an Access-97 field called Contact and are returned in a record set and stored to a variable called ShowContact ie. ShowContact = rstemp("Contact") But when the variable ShowContact is displayed. ie. <% =ShowContact %> it conatins only Joe and not Joe Peter Smith Any suggestions please. TIA .les. o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o Les Juby lesjuby@anti-spam.iafrica.com Webpro Internet - - - Prosoft Microsystems Durban, KwaZulu-Natal, South Africa P.O.Box 35243, Northway 4065, South Africa Tel: +27 31 563-8344 Fax: +27 31 564-4928 o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o (you *do* know to take "anti-spam" out the address....? Tag: Getting a block of data from with a text file Tag: 270307
  - 2
    - Problem by sending a fax via ASP Application Hi newgroup, i struggle with a problem with windows 2000 fax server running under my ASP Web application The sending of an fax - like the example below - works manually very well (with file open and print to the fax printer) - logged on as a normal user. But my code under ASP doesnt work (access rights for directory, to read the file and the fax server is given to the anonymous user) Here is the VB Script Code: Dim Faxserver Dim FaxDoc Dim JobNo Dim Dateiname Set Faxserver = Server.Createobject("Faxserver.Faxserver") FaxServer.Connect("gericom.sbs.office") Filename = server.MapPath("Orders/10173.pdf") Set FaxDoc = FaxServer.CreateDocument(Filename) FaxDoc.SendCoverpage = 0 FaxDoc.RecipientName = "Arnold" FaxDoc.SenderName = "Peter" FaxDoc.FaxNumber = "12345678" FaxDoc.SenderFax = "87654321" JobNo = FaxDoc.Send() Set FaxDoc = Nothing FaxServer.Disconnect() Set FaxServer = Nothing When i start this programm, the system seams to hang and after a short time, there appears an error 0x8007000D (Data is invalid??) at the line FaxDoc.Send() Has anyone of you a tip for me? Regards Peter Haider Tag: Getting a block of data from with a text file Tag: 270304
  - 3
    - retrieving a post form I have a comments form that when filled in posts the comments from a text field into a database. Due to a bit of duff coding (Doh!) the database was not getting updated and i lost 50 or so posts worth of comments. Is there any way of retrieving the posted forms from the server? The form uses the post method, with asp doing the work. Can anyone help me please? Tag: Getting a block of data from with a text file Tag: 270303
  - 4
    - Lookup Country by IP Address I want to know if there is a free service or database available from where I can get the country information if I pass it the IP address. If been to a site where you can do a free lookup, but I want to automate it. Your help or ideas will be greatly appreciated Cheers Charles Tag: Getting a block of data from with a text file Tag: 270302
  - 5
    - Stumped - page executes twice sometimes (even thrice occasionally!) I have a web form "Page1.asp" and it reads data from a database, does some calculations, and displays the records in pages. Works fine. I have a button that displays on the page, defined as <input type="button" onClick="OutputData()"> The OutputData() function is a javascript function that simply does this: window.location = "Page1.asp?Flag=1"; This "re-executes" Page1.asp, but with a flag set in the query string. The logic in Page1.asp writes the data to a file when this flag is set instead of paging it to the browser - it sends NOTHING to the browser when that flag is set. At the end of the data file generation, Page1.asp does a Response.Redirect to Page2.asp, passing it the filename in the query string. Page2.asp uses a COM object (DLL) we wrote in VB6 to further manipulate the data and the end result is a PDF file that gets sent to the browser through Response.BinaryWrite from an ADO binary stream. Page2.asp outputs no HTML itself - only the PDF data. What has me stumped is that Page2.asp is executing _multiple times_. Usually it executes twice, but sometimes it executes 3 times. I can tell because the COM object it uses writes some info to a log file. I clear the log file, click on the button on Page1.asp _one_ time, and the log shows the COM object being executed 2 or 3 times in a row. I cannot figure out why. There are no loops in Page2.asp - it is a fairly simple ASP script, no functions or sub's - just about 20 lines of script. Page1.asp is definitely not redirecting to it multiple times. I put some code in Page1.asp to log a timestamp each time it redirects to Page2.asp and it only does it *once* after I click the button. I put some code in Page2.asp to increment a Session variable and it does increment it multiple times after a click, so it is definitely Page2.asp that is executing multiple times. I did the same in Page1.asp and it increments only one time per click. Any ideas why this might be happening? Tag: Getting a block of data from with a text file Tag: 270298
  - 6
    - Response.Add Header problems (Content-disposition) All, I have an ASP Application in which users can save a recordset as an Excel spreadsheet should they choose to do so. When the app was on test box all was well but when I moved it to production, the page failed and IE returned an error saying that the page was not available The lines of code that cause the error appear to be: in test I have Response.AddHeader "Content-Disposition", "inline; filename=weberport1.xls" Response.ContentType = "application/vnd.ms-excel" On the production server in a secure environment the same lines produce the error "Page not available" If I Comment out the first line the page works fine and I get he option to save the page as a excel spreadsheet. e.g 'Response.AddHeader "Content-Disposition", "inline; filename=weberport1.xls" Response.ContentType = "application/vnd.ms-excel" Does having the application on a secure environment prevent pages from being returned with a content-disposition Has anyone seen this error before,? is there a special feature on IIS for secure links? Any help or suggestions are appreciated Thanks Jawahar Tag: Getting a block of data from with a text file Tag: 270296
  - 7
    - How can I post contents of a menu to a database? Hello all, I've created a web form that will post to an Access database. All of the form fields correctly save to the database upon submit using: <td><font face="MS Gothic">Site:</td><td><INPUT TYPE="TEXT" NAME="Site"></td> Below is what I have for one of the drop-down menus. Could anyone help with how to add the VB code to this so that the selected menu item will submit to the database as well? <td><font face="MS Gothic">Division:</td> <td> <select name="select"> <option>Select</option> <option>CHC</option> <option>Corp</option> <option>Legal</option> <option>AHG</option> <option>PGM</option> <option>PGP</option> <option>PGRD</option> </select> </td> Much thanks, Les Tag: Getting a block of data from with a text file Tag: 270294
  - 8
    - Formatting percent and dealing with division by zero problems I have some values that I want to display as percent, such as the retail price/wholesale price. In some instances, the wholesale price is zero, so I get a division by zero error. What can I do to avoid this? Also, how can I get this to only show two decimals, instead of it going .##### the way it does. I want it to look like .45% Thanks a million, Bill Tag: Getting a block of data from with a text file Tag: 270290
  - 9
    - ASP functions can get the HTTP request and response headers? Any ASP functions can get the HTTP request and response headers? Thanks! John Tag: Getting a block of data from with a text file Tag: 270280
  - 10
    - Finding filenames using wildcards I have an interesting challenge. I have a client that is putting pictures into a single folder on the web server. The files are specific in that the first 5 characters of the filename are the same ORDER#. The challenge is simply to find all the filenames with the initial 5 characters being input on an HTML form. That way I can establish links to each one of the pictures on the results page. So for instance if Order # 12345 was input the ASP page using I guess the filesystemobject should find all files that start with 12345 and return them. So the page could show 12345_1a.jpg / 12345_1b.jpg / 12345_4a.jpg / 12345_12.jpg / etc., etc. Any ideas or help would be greatly appreciated!! Thank you in advance! Tag: Getting a block of data from with a text file Tag: 270269
  - 11
    - Problem with including a header I have the following file structure: / header.asp test.asp /subDir testpage.asp /images I would like to have header.asp to be usable from all directories. Header.asp will have images and URLs. When I try to #include the file in test.asp, it works fine. However, if I #include it in testpage.asp, the images in header do not work - testpage.asp thinks the images are in subDir, when they are in the images directory. I have tried a variety of combinations of MapPath, Server.Execute, but I have not gotten the image to appear correctly. What is the correct syntax for what I am trying to accomplish? Thank you for you time, Jim Tag: Getting a block of data from with a text file Tag: 270264
  - 12
    - connect to the data source with or without Connection object To connect the ASP application to data source, we can use ADO.Connection object Const connectionString = "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=C:\mydatabase.mdb;" Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") ... objConn.Open connectionString objRS.Open sqlStatement, objConn '----------------- (1) The alternative is we can open the connection directly with ADO.RecordSet object, without using ADO.Connection object. objRS.Open sqlStatement, connectionString '---------------(2) What's the differences between line (1) and (2)? I read a book saying using Connection object is expensive, but I don't got it since there is connection anyway by using RecordSet object. Please advice. Thanks John Tag: Getting a block of data from with a text file Tag: 270255
  - 13
    - True answer re timeouts Hi Guys I've been using text files for Tab-Delimited/ADO/ASP sites so that users can update and display their products lists through my system with relative ease. Only problem is that for the last few months or so, this system has been generating loads of timeouts. ISP has said that I should be looking to upgrade my system, as it is the mechanics of it that are creaking under the strain. My queries are: a) Which REALLY performs better OLEDB DSN-less or ODBC DSN-less? b) If I convert the system to use 1 Access DB rather than 50-odd tab-delimited text files will this REALLY perform better in relation to timeouts? To give you some idea of the problems, the site can viewed by going to www.bardwells.co.uk and clicking the Product List link. I just can't understand it because the pages on the whole are very lean and zippy (esp. ADSL), but its these exact same Broadband users who seem to have more trouble with timeouts than dial-up ones. We're not talking Marks & Sparks here, but they do get quite a few visitors. Any help you can give would be appreciated. Rgds Laphan Tag: Getting a block of data from with a text file Tag: 270247
  - 14
    - Need suggestions on where to get help I've posted a question here twice and unfortunatly got no reply. Maybe it's a hard question. Maybe I've broken some sort of netiquette and I'm being shunned. Don't know. If the former, I would like to ask if anyone could suggest another good resource for getting help with ASP and forms. If the latter, I would like to know what I may have done to offend, as I'm unaware and will most likely do it again, and offense is not my intention. Oddly I've also posted three other questions in other MS newsgroups and never got any replies. Go figure. Anyway, thanks for whomever takes the time to let me know they've read my post. TurboDuster Tag: Getting a block of data from with a text file Tag: 270239
  - 15
    - Detecting new mail? Hi all, I am planning out the stages for an application at work, the application needs to detect when a client has emailed 'us' and then trigger a new row written to a database and email the client back by return. I can see how most of what our application needs to do can be achieved with ASP/SQL Server - but the part I am unsure of is the email detection...I suppose the closest thing to what we are aiming for would be one of those 'helpdesk' apps that many companies have - you email them - you get an automated confirmation email back by return with a ticket number etc etc - anyone got any ideas on how I can achieve this? Thanks in advance for any help. Regards Robb Tag: Getting a block of data from with a text file Tag: 270238
  - 16
    - GetRows Mystery I'm facing an odd behavior in using the GetRows Method. I'm not sure what's causing it because it has been working fine until now. I have a sproc that returns 1 row. I display the RS info on the page using a DO-WHILE loop. All fields have values. I then rerun the same sproc, but this time extract the values into an array using getrows. I loop through the array and display the content of each element on screen. However, from the 14 fields, fields 0, 1, 12, 13, & 14 have data and all else are empty. This is all done in a simple test script, nothing fancy. I checked carefully that i didn't mix index or anything else silly and well as have someone else look at it. I know this is a longshot, but has anyone seen this behavior before? Maybe some component installed is causing this problem. Just thought I'll ask. Thanks for any info. Tag: Getting a block of data from with a text file Tag: 270237
  - 17
    - DTS Package using Excel Spreadsheets I will start off by giving you a background of the process I am taking. The nature of my DTS package is that I recieve an Excel Spreadsheet, run it through the DTS Package applying validation to the records, create an excel file that contians the records that do not pass the validation, send this Excel file back to the person who sent me the original spreadsheet. They will send the Excel Spreadsheet back once they correct the records. Then the process starts over and keeps going until there are no records left. The problem I have ran into is that I have to create an excel file using an ActiveX script, the DTSPump will not, as far as I am aware of, create an Excel file automatically. So, I have created a ActiveX script that will create an Excel object using Set objExcel=CreateObject("OWC10.spreadsheet") . I do not add any data to the spreadsheet at this point, just the column headings. A few steps later in my DTS package I attempt to use a data pump and process information from a table into the Excel worksheet that was just created. However, when I choose the file and click on the OK button it throws an erro "The External table is not in the expected format". The problem lies in that I HAVE to use Excel files to complete this DTS package, but the excel files that I create are not compatible with the Excel 97-2000 connections in DTS. The object that I have created using the ActiveX script shows as an Excel Spreadsheet in My Computer and will open with Microsoft Excel. I have also tried to use the other DTS Connect formats for Excel such as 5.0 and 6.0, these did not work either. Does anyone know how I can work around this problem? If I need to clear things up or provide more information just let me know. Thanks, Jeff * * * Sent via DevBuilder http://www.devbuilder.org * * * Developer Resources for High End Developers. Tag: Getting a block of data from with a text file Tag: 270236
  - 18
    - ASP, LDAP and Active Directory I have an ASP page acessing an LDAP server (Exchange server on Windows 2000). I tried running the asp query on the machine that contains the LDAP server, and it worked fine, returning the correct no of records. I subsequently moved the page to anotehr machine on the network, but here, it gives me a recordcount of 0 when i try running it. Any ideas on what could be the problem? I read somewhere that EXchange Server and IIS have to be on the same physical machine to use the ADSDSO object. is that true? is there any other way to work around that then? Any help would be appreciated. Im attaching my code below. <% Set Conn=CreateObject("ADODB.Connection") Conn.Provider="ADSDSOObject" Conn.Open "ADs Provider" Qvar="<LDAP://daa21366ads001>;((objectClass=user)(showinaddressbook=CN=Global Address List,OU=Microsoft Exchange,OU=CMC,OU=corp-i,OU=Organizations,o=corp-i,o=corp));*;subtree" Set rs=Server.CreateObject("ADODB.RecordSet") rs.Open QVar,Conn if rs.supports(adApproxPosition) then if rs.Supports(adBookmark) then Response.Write(rs.RecordCount) end if end if %> Tag: Getting a block of data from with a text file Tag: 270225
  - 19
    - input type=file is it possible to define a default or start up directory with input type="file" field type? If so, is it also possible to filter by another option box selection? If so, how so? Thank you Paul Moffitt Tag: Getting a block of data from with a text file Tag: 270223
  - 20
    - newbie:How to print the background of a cell in a table? I have a table with one cell which has a black background and white letters. Looks good on Screen. When I print on a B&W laserjet, the letters appear gray and there is NOT a Black background. ie. <TD class="normalReverse" >Apple</TD> Any suggestions? TIA Steve Tag: Getting a block of data from with a text file Tag: 270222
  - 21
    - ASP WebClassRuntime and Windows2000 SP4 Problem Hi All I have different WebApplications running on Windows2000 Servers without problems since years now. Since the Administrators recently started to install Windows 2000 Service Pack 4 the WebApps doesn't work anymore. The First request of a page returns the Error "An internal exception has occurred" thrown by the WebClass Runtime, all other page requests doesn't receive any response at all (IE seams to "hang"). I found two Knowledge Base Articles (KB821546 (http://support.microsoft.com/default.aspx?scid=kb;en-us;821546) and KB304071 - (http://support.microsoft.com/default.aspx?scid=kb;en-us;304071)), but it doesn't help me to solve the Problem (It is no Security or Language specific Problem as described there). Has anyone a solution for that problem? Is there a newer WebClass Runtime (MSWCRUN.dll) than 6.0.88.4 contained in VB6 SP5? Thanks Andy Tag: Getting a block of data from with a text file Tag: 270220
  - 22
    - OT: RSS news feed on my site... HOW? i keep seeing these rss news items and i want to know how i put them on my site, there xml files? a have access to both asp and perl scripts do i need one of these to do the magic? and if so anyone know a good free one :) cheerz mark Tag: Getting a block of data from with a text file Tag: 270208
  - 23
    - can't login! - authentication prob. Hi, Can anyone help. I have a folder on my website that has 'anonymous access' and 'basic authentication' disabled, and requires 'intergrated Windows authentication'. This used to work fine, but all of a sudden it won't let me in! . The login box appears, I have checked the username, password and domain are fine (I can still log directly in to the server with them) but I can't get access! and after I've tried 3 times I just get redirected to the: 'You are not authorized to view this page' page. Same thing happens even if I try using basic authentication. Does anyone know why this is happening? (running windows 2000 server if this helps) Thanks, Nicky Tag: Getting a block of data from with a text file Tag: 270206
  - 24
    - Waiting for db to insert record? Hi all Just a quick question more about the flow of an asp page. IF I have code as below: - MyDBConnection.Execute "Insert Record Into A Table" MyRecordset.Open "Retreive the same record from the table" Is there any chance that the connection process (Inserting the record) will not have completed by the time I try to retrieve the record. I.E. will the asp page wait for the insert to complete before continuing to open it (the next command in the page). Tag: Getting a block of data from with a text file Tag: 270205
  - 25
    - ASP + PAyPal Hi, Can some one point me to a resource (if there is one) that describes if a value is sent back to my site from PAyPal once the payment has been process. The reason is that I want to perform some actions once I know the payment has been received and processed. I have looked the PDN (Paypal developers Network) but cannot see anything - I may have missed of course !! All help greatly appreciated Tag: Getting a block of data from with a text file Tag: 270202

Hi All,

Any ideas on how to read a txt file from asp and get it to grab one block of
information?
Sample txt file;

Windows IP Configuration
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 192.168.0.1
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
PPP adapter SpeedTouch UK:
Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 81.128.131.42
Subnet Mask . . . . . . . . . . . : 255.255.255.255
Default Gateway . . . . . . . . . : 81.128.131.42

I wish to grab the PPP ip address of 81.128.131.42 (the 81 is the only
static part of the ip) and then create a hyper link on the outputted page
using this ip address.

Thanks in advance,
Rob

Top

Re: Getting a block of data from with a text file by Curt_C

Curt_C
Sun Aug 31 17:21:49 CDT 2003

IPConfig huh? :}
Use FSO to read it all in then use the Instr() Mid() Left() Right()
functions to break to what you need.

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
..Offering free scripts & code snippits for everyone...
---------------------------------------------------------

"Rob" <hdw.reporting@btopenworld.com> wrote in message
news:bitnoc$r07$1@titan.btinternet.com...
> Hi All,
>
> Any ideas on how to read a txt file from asp and get it to grab one block
of
> information?
> Sample txt file;
>
> Windows IP Configuration
> Ethernet adapter Local Area Connection:
> Connection-specific DNS Suffix . :
> IP Address. . . . . . . . . . . . : 192.168.0.1
> Subnet Mask . . . . . . . . . . . : 255.255.255.0
> Default Gateway . . . . . . . . . :
> PPP adapter SpeedTouch UK:
> Connection-specific DNS Suffix . :
> IP Address. . . . . . . . . . . . : 81.128.131.42
> Subnet Mask . . . . . . . . . . . : 255.255.255.255
> Default Gateway . . . . . . . . . : 81.128.131.42
>
> I wish to grab the PPP ip address of 81.128.131.42 (the 81 is the only
> static part of the ip) and then create a hyper link on the outputted page
> using this ip address.
>
> Thanks in advance,
> Rob
>
>

Top