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'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?
how to create a comma delimited text file from an asp form. Assume my fields are: Name, email, phone number.
View Replies View RelatedI would like to use ASP to populate a select list from a comma delimited txt file.....
View Replies View RelatedWhat'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 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 RelatedI 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.
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'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);
Anyone 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 have a sting that have to be split by comma (cvs file)
Let me give you an example:
this is my string:
asd,asd,asd,"asd,asd,asd",asd,asd
I have to split this string but the string that is in quote I dont whant to be splited
result have to be like that:
Array(
[0]=>asd
[1]=>asd
[2]=>asd
[3]=>"asd,asd,asd"
[4]=>asd
[5]=>asd
)
I have a text file that has two lines in it, the first line gives item
labels, my second line gives values for those labels. I would like to use
ASP to present this data on a web page. I also want the page to reload every
10 seconds so that any updates to the text file would be relfected on the web
page.
I want to create a disconnected recordset and want to store the values in a txt file at client site and then want to use for some validation.
View Replies View RelatedI am trying to find distinct hostname. And my code is:
sql="select distinct a.Hostname, b.Productname from TableInventory as a, TableProduct as b, TableModel as c WHERE a.ModelId=c.Model AND c.ProductId=b.ProductId"
rs.open sql, cnn
After which im suppose to get the indivual hostname's productname, qty and cost.
i tried to split up the rs into array values Code:
My database has customers, orders, and orderDetails tables. I'm trying to create a page that we can access to lookup all details about our orders. That page will need information from all of these tables.
How do I create a recordset that can handle the relationships and bring in all data?
I am in the process of rewriting my table formats for an Access Project that was created. I now need to get the data from 1 table and transfer to a second table.
I created a page that creates the record set, I then loop through that record set and need to run an update statement to a second table, however, I get the following message:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/BusPlanTest/updBusPlan.asp, line 17
Below is the code I am using: Code:
I'd like to create ASP file on ther server side. Can I use
fso.createtextfile("c:folder est.asp")
Do I need to create a folder too?
is it possible to create a xml file and save so that i can upload with asp?
View Replies View RelatedHow can I simply save some data into a flat file (.txt) ? I've some data available and if the user clicks on a button it will save that data into the flat file... The user also need to define the directory (as in VB the common dialog box)...
Is this possible ???
I have Windows 2000 and recently included Internet Information Services. I
then created a simple ASP file and clicked on it. The Open With dialog
appears asking me to select a program. I copied an existing ASP file,
test.ASP from another computer where it runs successfully. When I copied it
to my computer it changed to test.ASP auto file. The other computer runs
Windows XP. I am not sure is this is the issue. I verified the IIS is up
and running on my computer. Is there anything that can be done to correct
this?
I am using ASP code to create a Word document on the server and all is working except for one thing: I need to be able to insert page breaks. My existing style formatting for page breaks does not seem to insert a page break into the Word DOC. Suggestions? Code:
View Replies View RelatedI was wondering if it is possible to create an sql file using asp to back up a tables contents at all?basically I want to make a copy of each table we have on the server into an SQL file so we can move it elsewhere, the server techs want to charge us for the backup copy so I want to get around paying if possible.
View Replies View Relatedi'm using window XP (hope this is not the reason) i cant create a file in my computer but it works on my school server
**********************************************
Set fso = Server.CreateObject("Scripting.FileSystemObject")
Set OutputXMLFile = fso.CreateTextFile("c:xx.htm",true)
**********************************************
everytime i run this method my IE hang(???) so, is it my IIS configuration problem or else.
I want to create pdf file for reports using asp code.
View Replies View RelatedI know this is a lot to ask but if you have time please have a look and see if you can figure out why the following page to create a new ASP page on the fly seems to work but the output page doesn't seem to be there: Code:
View Replies View RelatedSo, is there anyone can post sample code which cab generate the invoice, also it can be viewed by PDF file online.
View Replies View Relatedis it possible to create and asp page that can. zip a file and ate the same time unzip it.
View Replies View RelatedIn Outlook Express, we could schedule event reminder on the calendar. I have seen people doing this on their web site, where they have a list of events and a "Add to my calendar" link to let user to click on. When the link is clicked, the Outlook calendar will pop up with all the event's information in it. Then I can save that event to my Outlook calendar.
I want to give this ability to the people browsing my web site to add our events to their Outlook calendar.
if this was possible to have the users able to create a file into your webroot.
View Replies View Related