Temporary Txt,csv Files?
I've got a web-based "database admin console" that uses ADOX, etc. to query a database and return the tables, columns, etc to a form that I can then use to build SQL statements to run against that database. It's very "generic" - i.e., everything is dymanically created but pretty handy to have
If you send it a "SELECT" statement, it can print out a table on the screen showing your recordset. No big deal. What I'd also like to include is some way for users to get that output in a comma- or tab-delimited text file that they can use however they like. There are two ways I know of to accomplish thi
1) Create a big string as I step through the recordset - (strOutput = strOutput & "'" & objRS(I) & "," .....) and then slap strOutput into a <textarea>. This is probably not desirable because the user would have to copy all the content in that <textarea> and manually paste it into Notepad or whatever
2) Use the FSO. However, my limited experience with the FSO leads me to believe that I'd have to SAVE the resultant file before I can send it to users. I don't want to do that.
Does anyone have any suggestions about how else I can accomplish this? Or, if FSO is the way to go (which I suspect it is), bear in mind that my only exposure to FSO is in the context of .vbs files....are there any special tricks you need to use for ASP
View Replies
ADVERTISEMENT
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
View Replies
View Related
How I can erase all the files from the cache of an ASP page, at the end of a session?
Is it possible?
View Replies
View Related
Is it possible to delete internet temporary files using ASP code? And maybe specify the extension of the files to delete?
View Replies
View Related
I keep getting this message onmy webiste. I have had to change from a DSN connection to a dsn less connection but i still can't get the site to work.
Link to the error message
Page
Here i sthe code that relates to the error message
Code:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=ftp://SimonJohnstone/htdocs/Tpvsite.mdb"
objConn.open
View Replies
View Related
I need to take some info from a SQL Database into an ASP (VBscript) web page, create a temporary vcs file (Outlook vCalender file) and use the SQL data to create the entrys for the appointment, then email it to someone as an attachment. Getting the SQL values is no problem. How do I go about creating, populating & sending the vcs file? its similiar to a txt file. Its plain ASP not ASp.net and I can't install any components onto the server. It has to be kept local.
View Replies
View Related
Is there a way to create an asp program which counts the number of impressions, clicks, leads and sales of a certain ad and post it somewhere else? I have actually reviewed some ad servers one of which is Adxpress by Valuead. It's a good one but it'll really cost some money.
View Replies
View Related
I have a script that generates varius entities of data, like this
Name__________Value
nameA_________2
nameB_________18
nameC_________4
nameD_________23
I want to 'response.write' these onto the webpage, but I want them to be ordered by the value (largest first). Can I create a temporary table, put the values into it, then call them back using the an SQL command? If so, how do I create 'temporary tables'?
View Replies
View Related
i am developing a search engine. its like this. i have an asp from which gets the search string. i display a page with a wait symbol for 2 seconds (meta-equiv-refresh=2) and then transfer the control to the same page which would display the search results.
I think even this forum does this type of display. Now my question is how do i start searching for the entered string and stop displaying the wait page only when the search is finished.
i.e i dnt want a wait page to be displayed simply for two seconds and then show the search page. I want to ""show the wait page after the search is started and then stop displaying it and display the search results only after the result is got""
View Replies
View Related
I use the ASP to genereate the excel file. We use the Excel.Application to create a excel. But we find many excel shortcut or directory shortcut under the C: or D:
How can we resolve it?
View Replies
View Related
I have a form on my site that users must fill out before downloading a pdf document, however, i would like the form to send them an email with a temorary URL.
which they can click to download from, and which expires after 'x' days. is this an asp thing? or do i have to move to .net to do this?
View Replies
View Related
i have written a stored procedure. depending upon different parameters, query is prepared as string and executed through exec() function. it returns a certain number of rows. stored procedure also contains a temporary table. the question is this how can i insert the rows returned by the query in to temporary table?
View Replies
View Related
I am using ASP + IIS + MS access, when running the following codes:
set Conn=Server.CREATEOBJECT("ADODB.CONNECTION")
conn.open "DRIVER={Microsoft Access Driver
(*.mdb)}; " & Server.MapPath("db.mdb")
The following erorr is show:
General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x508 Thread 0x634 DBC 0x2181024 Jet'.
I have shared the MS knowledge base and try to grant the modify Permissions to IUSR_SERVER on the folder that holding the database, and set the script authority in IIS, the error is still exist. If I create a system DNS for that Access file and modify the second code as ...
conn.Open "AKmobile"
Another error is show:
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
But there is no problem when conencting with MS SQL Server.
View Replies
View Related
Why d I get this error?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x18c8 Thread 0x1478 DBC 0x2f56fa4 Jet'.
/wheelofgod/search/cat/showbook.asp, line 102
View Replies
View Related
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xa60 Thread 0xb30 DBC 0x1391ec4 Jet'.
/name.asp, line 17
my code:
View Replies
View Related
All time that I go to make login to enter in admin is appearing this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x120c Thread 0x1494 DBC 0x1690024 Jet'.
/noticias/config.inc, line 6
In line 6 of config I have this: .....
View Replies
View Related
Can a php file be executed inside an asp file? I need to execute a php file in another asp file but i'm not so sure it's possible.
My server can run both asp and php and they run without any problems... I just need to find a way to include the execution results of the php file in the asp one.
Is it possible to use SSI and include the executed php file and then the executed asp file in a main ssi file?
View Replies
View Related
I have installed PWS in windows 98 in each of the system at various places and put my Sales program files in the WWWROOT directory in all the branches. I'm afraid that the users may tamper my ASP files. Is there any way of converting .ASP files to .exe files so that the dont see my program.
View Replies
View Related
I was wondering how some sites let you search by using a form, then present the results as static .htm files.
The reason I ask is that I tend to use ASP to process form information, then give the user a list of results presented on an .asp page. The list is simply drawn from a database in real-time and formatted into a template page.
The problem with this is that search engines can't see any of the information in the database, since they can't do the form submission. Is there a way around this?
View Replies
View Related
When DLLs are compiled in VB, in addition to the dll, there are also
exp and .lib files created. Can somebody tell me what these are for?
Do I need to include them when I deploy my application?
View Replies
View Related
I want to include just the result of a PHP file within an ASP file. <--#include won't work, it just imports the text.Is there an alternate way to do this?
View Replies
View Related
Checking our IIS log files we often get the chinese bots probing our sites. My only concern at the moment is that when an item is called by ID (i.e. select category from table where categoryid = id) and the id is called from either a querystring or a form request, I use CLng (i.e. CLng(request.querystring("id")) to convert the id to a long int to prevent the bots injecting the variable with any non-numeric characters.
View Replies
View Related
how can i do a ftp function to upload and downlaod file to the server without using a 3rd party component?
View Replies
View Related
can somebody advise me, how to put a few text files into zip archive on IIS5
on user request on some asp page?
View Replies
View Related
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??
View Replies
View Related
when the user submit a form, all the form data's will be saved
as a pdf file
is it possible?
yes means. by what way we can get this..?
For doing this we have to use any third party tools..?
View Replies
View Related
I would like to capture the data from a textarea box and save it to a file.
View Replies
View Related
i want to know what is the difference between using a .asp include file and .inc include file.I know how an Asp Include file works , but some place i have seen .Inc as Include file. What is the difference?
View Replies
View Related
Does anyone know of a COM object, or if it is possible to display content in the browser of a file in a zip file.
In other words, I have a zip file with like 100 images. I have a script that will knows which zip to look at and what the file name is inside the zip. What I want is to display in my browser the image that is in the zip file .Not sure if this is possible or not, I've been searching the web for a way to do this. Any help would be great.
View Replies
View Related
I wanted to know whether we can zip files on the fly without using any
components.
View Replies
View Related
i have just installed windows server 2003 standard edition
but when i try to run any asp files it gives this error :
The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.also i couldn't log in my hotmail account
si i searched the help files i found some issue about the security level so i changed the security level and i could log in my hotmail account
View Replies
View Related
how to use ASP for working .DBF files ?
View Replies
View Related
I'm looking into ways of creating zip files on my server without components to install. It's so I can let users of my site select files they would like to download and zip them up on the fly and download.
View Replies
View Related