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?? Code:
can anyone put me on the right track.i have a comma delimited file and i need to search through this file and locate where acctsessionid does not have 2 matching records and display them on an asp page.
View Replies View Relatedneed to query a database and then get the results in a tab delimited file.currently am writing record by record in the file using the FSO,but just wanted to check can we directly get the results in the TAB delimited format and save to a file on the server.
I need to be able to read a tab delimited text file with an asp page so that I can stuff the fields into a sql table.I really don't know how you can do that, I checked the books I have and have been running around the internet trying to find the answer when I found this site.I cannot use a bulk insert statement because I don't have that level of access to the sql server. and I was assured that "BCP is indeed a command-line only utility and cannot be launched from ASP. You could parse the text file with ASP and generate INSERT statements that you then execute against the database. Routines for parsing tab-delimited files can be had by searching for them on google quite easily." by the system administrator
View Replies View RelatedI have the below code found on an ASP site.
<%
arrName = Split(Request("TextArea"),",")
%>
<%
For i = LBound(arrName) To UBound(arrName)
Response.Write "ID: " & arrName(i) & "<br>"
Next
%>
I'm using a TextArea box to submit the following...
A123,1
B123,2
C123,3
Results are...
ID: A123
ID: 1 B123
ID: 2 C123
ID: 3
I expected something like...
A123 1
B123 2
C123 3
For the sake of understanding, why are the results like above?
In the end, I want to insert these values into a table.
A123 into Field1 .... 1 into Field2
B123 into Field1 .... 2 into Field2
C123 into Field1 .... 3 into Field2
Where do I start?
What's the easiest way to generate CSV or a comma delimited file from an ASP
recordset? I've seen a few searching the internet and they appear to be
overkill or out of date.
Whenever I import a comma delimited file the field lengths are always 255. I tried an import specification in my code but they were stll 255 in length.
I imported about 156 fields and about 140 came in at 255. Not gonna work.
i am trying to run a asp sql query containging many tables. the main table though is a simple ID based table contains all ids from the other tables. Code:
View Replies View RelatedHow can I populate the results of a recordset into a comma delimited?
The recordset is only returning a sequence of ID's (one column - one dimension). I was trying the getRows and getString method. If the result was only one record it was okay, but for more than one result I was getting an unhandled data type error.
I would just like to place the values from the recordset into a comma-delimited list and then pass that into a javascript function?
I'm trying to read a tab-delimited file into an array so I can pick out different fields for a report. I keep getting a "Type Mismatch" error that I don't understand.
sReceiveFile = "receipt.txt"
sDataFile = sReceiveFolder & sReceiveFile
sDelimiter = "Chr(9)"
Dim objFileSystem, objFile
Set objFileSystem= CreateObject("Scripting.FileSystemObject")
Set objFile = objFileSystem.OpenTextFile(sDataFile,1)
sReadLine = objFile.readline
Do While objFile.AtEndOfStream <> True
Response.Write "<UL>" & Chr(10)
'Response.Write objFile.ReadLine & "<br>"
sSplit = split(objFile.Readline,"Chr(9)")
Response.write sSplit ' I want to see the contents and this line is giving me the error
Response.Write "</UL>" & Chr(10)
Loop
objFile.Close
%>
I need to read a tab delimted file into an array with ASP. Should be
easy enough, I know it is in Perl and PHP. Can someone show me how
that's done or post a link to an example.
This is what I'm trying to do in perl:
#!/usr/bin/perl -w
my $file = "myfile.txt";
open(FILE, $file);
while(<FILE>){
my ($f1, $f2, $f3) = split(' ', $_); # or @array = split(' ', $_)
print "F1:$f1 F2:$f2 F3:$f3
";
}
close(FILE);
I have written an ASP script that collects information from a form. The info is stored in one variable name. When I request the info, it is returned as a comma delimited string. How can I manipulate this string so the data can be stored in a database? I appreciate your assistance.
View Replies View RelatedAnyone know the best way of Read tab delimited text file, its old but I have to use it, I only know how to read csv.
View Replies View RelatedI'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?
I need to create a 2 dimensional array from a string with 2 kinds of delimiters
sample string: Code:
I'm using MSXML2.ServerXMLHTTP to retrieve a webpage. It works, but is unacceptably slow (~20s) when retrieving remote webpages (anything outside our network).Is there any way to improve the performance?
View Replies View Relatedim trying to build some custom shopping cart for a client
what i know about shopping carts is the main idea which is an array stored in the the client's session
also i know that this point (the session) may cause some bad performance and here is my point
any cart contains just the product id and number of items or something like that (some people says data dictionary is good here)
the cart im going to build contains alot od data coz the site client when choose to add some item to his cart must be redirected to some page with a form to add many details about his needs with the product so the session here will carry alot of data ........
so i thought in 2 iedeas
1- array into session
2- some databse table carries all of temporary data with a unique primary key for every session but i need to know the best selution for the best performance
If I a loop that displays a list of records on a page, lets say a list of contacts (lets say 200). The question that I have is does it effect the performance if I add inside the loop the following:
if Arr[0,index]="1" then
.....
end if
Whether it can improve the execution effciency of ASP by centeralizing the often used code into header files and then including these header files in ASP pages?
View Replies View RelatedI have a 500 page ASP program that takes 1-2 seconds to execute. For some strange reason it takes 20-30 seconds before the first lines executes. How can I make this program behave better?
View Replies View RelatedIn an application I'm working the user has the opportunity to record the
despatching of one or more items with serial numbers.
For each item they despatch, they have to chose the serial no that they want
to despatch from a list of available ones. In many cases, these items will
be of the same time, so the dropdown of available serial no's may be the
same. Code:
Is it possible to have a search page that queries a sql database and then writes the results to a comma-delimited text file instead of displaying the results.
I have no problem creating the search page and displaying the results I just don't know how to create the comma-delimited text file from the recordset results.
I have a sql server 2000 table with a comma delimited list of ids. there is a seperate lookup table with a desc for each id.
I need for this data to be retuned in the same order in which the data was entered into the database. right now it is returning ordered by the id from the lutable.
how to create a comma delimited text file from an asp form. Assume my fields are: Name, email, phone number.
View Replies View RelatedWe have several pages that are running very slow, is there any way to
identify which pages are taking the longest to process?
I have a list box with about 500 users in it. I have to populate that on a site. It causes extreme slowness. I am using classic ASP with MS SQL. What is happening is the users are stored as a number (a user_id) and that number is looked up. Then that number is passed through a simple function to turn the number into a name. The names are stored in the DB in first_name, last_name format. The company wants the list box in first_name last_name format so the function is needed. Should I look into database caching, caching the list box somehow, making another table of the user_id's and names in the correct form, or some other option. Once again, I am not using ASP.NET, but classic ASP instead.
View Replies View RelatedI am running the WebService / CurrentConnections performance counter.
It works fine for one site I'm looking at, but not for another.
The one it doesn't work for, the polling vertical red line doesn't even
move.
Is there a setting somewhere that controls whether a web site can be be
'polled' or not?
I am using Windows Server 2003 Standard Edition.
I'm maintaining an ASP Classic file that has HTML withing
Response.Write methods such as
<%
Response.Write "<table><tr><td>"
Response.Write testVariable
Response.Write "</td></tr></table>"
%>
Would their be a performance hit if I were to write this instead?
<table><tr><td><%=testVariable%></td></tr></table>
I need some confirmation.
I have a database with 300,000 records. I have two "DATE" columns and
I need to calcluate the difference and display the number of days in
one of the reports. I was wondering if this calculation of days should
be done on the fly or is it OK to have a "Difference Date"
column[Contains Number of Days] and retrieve the same
Their will be not more than 50 concurrent users accesing it. However,
in the next 6 months the record size is expected to reach 800,000. The
database will be hosted on a shared hosting on the internet
how to display the current connection value on a ASP page. Wanted to know how to read this value into ASP page as opposed to going to performance monitor.
View Replies View Relatedany 1 know of any resource that provides Active Server Page performance on differenct server platforms. I am interested to know what the page/sec, concurrent users (on avarage, this of course depends on other factors) is for Dell PowerEdge servers.
I recall that 40page/sec on 800Mhz server a few years ago was really good. What can I expect from a dual PE1750 3GHz Xeon?
I want to use a simple CDONT mail script to allow the administrator of a site to send an email blast to their users. there are approx 1600 emails in the MS SQL db table. I would like to parse the entire email address column and get a variable that is all the email addresses separated by a comma so that the form picks it up as all the emails in the 'bcc' field as in the eg. below..I know there has to be an easier way but I want to get these guys up and running.
<%
objCDO.To = "Recipient@oursite.org"
objCDO.From = "mailer@oursite.org"
objCDO.bcc = "$variable_of_all_email_addresses"
Dim txtSubject
txtSubject = "Insert comments and case info here"
objCDO.Subject = ""***ATTENTION*** NEW CASE - MISSING CHILD"
objCDO.Body = txtSubject
objCDO.Send
%>
I would like to use ASP to populate a select list from a comma delimited txt file.....
View Replies View Related