Sending Zip File From Database Problems
I'm trying to get an ASP to return a zip file to the remote browser from an
Image (BLOB) field in SQL Server 2000 but Internet Explorer keeps saying:
Cannot open C:Documents and SettingsFrostillicusLocal SettingsTemporary
Internet FilesContent.IE5U7GXENGFfile[1].zip
The URL to open the zip file is like this: doc_view.asp?id=1&ver=2
....where id and ver represent the zip file's version in the database. The
code I've pieced together to return the zip file is as follows (note: this
code works fine for PDF, JPG, DOC, XLS, GIF, and all sorts of files - just
not zip - HOWEVER, if I click "save" instead of "open" in the download box
then open the zip file manually, it works fine - Internet Explorer just
won't load WinZip for me automatically) Code:
View Replies
ADVERTISEMENT
I would like to know how to go about sending a query to a database when a certain image/link is clicked by the user.
By this I mean e.g. table in a database called cd, primary key in table id. Each image/link has its own id number which refers to its record in the table.
So when the user clicks an image or link i would like it to preform a SELECT query using the id number.
How would i go about giving a link/image its own id number? I guess this is simple as i have seen it on many sites and have seen the query string at the bottom of the browser in status bar when you hover over image/link.
View Replies
View Related
I have a guy asking me about the speed of downloads from his web site. I use
ASP code to send the download to the user, and the code I use is basically
like this:
FileName = Request.Form("FileName")
Path = Server.MapPath(FileName)
Set Upload = Server.CreateObject("Persits.Upload")
Upload.SendBinary Path
Set Upload = Nothing
Is there anything that can be done to make this more efficient and to send
the file faster?
View Replies
View Related
I have a member registration form that when the user clicks the submit button the form info is sent to a file name validate.asp.
The file validate.asp checks all the information to see if it correct and now I would like to have the data that was submitted added to an access database named members into a table that I named reginfo (registration info) and I have tried numerous ways to do this and spent countless hours browsing through websites but cant seem to get it to work. Code:
View Replies
View Related
i have an ASP (iis v5.0) application that generates a pdf file and this file
is saved to the server. it is saved in a location not available to web
users. i have an asp script (below) that sends the pdf file to the user as a
binary stream. So that the user specifies which file to upload, the script
performs some security checking and if it passes, it sends the pdf document.
This works great in HTTP, but i want to do this using SSL. When i try the
same thing over SSL, it gives me a 'File Download' dialog box with Open,
Save, Cancel, More Info. The file name is the name of my script and file
type is 'Adobe Acrobat Control for ActiveX'.
When i click Save or Open i get an error message: Internet Explorer cannot
download [scriptname] IE was not able to open this Internet site. The
requested site is either unavailable or cannot be found. Please try again
later.
The key to all this is that the report can change and i need to make sure
the data doesn't get cached along the way. Hence there are a bunch of header
manipulation commands included in the send function. Code:
View Replies
View Related
I’m attempting to insert some basic information (name, address, details) to the sql database and send a notification email (at the same time).
Right now, I can insert the information to the DB after I click submit, but how can I also receive an email? Please give some ideas how to do it.
View Replies
View Related
i want to send an email from a web app with an attached file. the form is for users to enter email addresses to whom they want the attached file sent. I'm using ASP and CDONTS mail. Code:
View Replies
View Related
FP2000 | Access2000
How can I make a page that will grab info from my database and make it into a temporary txt file.
I need to do this in order to use a little component on the text after which I will need another page that will grab the txt file (that is now changed), delete the temporary txt file, and post the new txt to the database.
View Replies
View Related
Okay, I'm doing a project for someone in which random questions are to be pulled and posted so that the user can complete a test/quiz/exam for a grade.
Well, his host apparently doesn't have any database stuff, but I can probably get him to move to another if it's absolutely necessary.
Personally, I'd prefer to stick with files, just because that's what I'm most accustomed with. But if there's a very compelling reason (performance or reliability?) to move to a database, I suppose I could.
Here's a sample of the type of data I'll be using. The format is as follows: Question, Correct Answer, First Answer, Second Answer, Third Answer (If Any), Fourth Answer (If Any). A question is on each line (in this browser window, it may appear that a question is spanning several lines, but it truly isn't). Code:
View Replies
View Related
how to convert a database table into an html
file via FSO and whether more seasoned asp programmers recommned this route.
The main reason I am attempting to do this is becuase we are constantly
being told by so-called marketing gurus that 'html' pages are more search
engine friendly. Code:
View Replies
View Related
is there a way i can read into two tables in the same database access file?and if so.. how would i write the code?the code below is already connected to a database reading from table1.. and i wish to read it from table2 as well...
rsMap.Source = "SELECT * FROM table1 WHERE (State = '" + Replace(rsMap__MMColParam, "'", "''") + "') OR (City LIKE '%" + Replace(rsMap__MMColParam2, "'", "''") + "%') ORDER BY City ASC"
View Replies
View Related
I'm simply trying to copy an intranet database file (VesselConfig.mdb) into the same directory but rename it something else (VesselConfig2.mdb).
Here's the code I have so far: Code:
View Replies
View Related
I'm working on an application that I will make use of "constants". I put
contants in quotes becuase they will change periodically (Logo path, css
path, psw expiration times etc). From a system admin standpoint does it make
sense to put them in a constants file, or put them in a database?
My database argument is that they can be modified by the customer via some
web forms.
My contants include file argument is that they can't be modified as easiliy
by a half wit customer, and there is no database overhead.
View Replies
View Related
How can i upload a file from a asp form to a database?
View Replies
View Related
I want to upload either image or word document into either access or SQL server database so far I am doing some small testings and what I can do is upload the file from first page and display at the next page with (both image or word are working fine).
however, I cann't insert them into the database, Plus, what type should I use in access database? Code:
View Replies
View Related
I worked on a database on PWS (Personnal Web Server). But transferring the database and all the files (html is used for inputting "search" words, asp used for results from database table). Here is my code:
View Replies
View Related
Question about the performance of using an include file or reading from a text file compared to hitting the database.
I set up a client's web site so they can post a weekly message and also post a "of special interest" message on their home page. Originally these messages were stored in and retrieved from an Access 2000 database. I decided to try writing the messages to a text file then retrieving it through include file and also tried the text streaming object.
I used netmechanic.com to gauge the download times for all three methods on a 56K modem. According to the results, using the database was around 4 seconds quicker. Does this sound right? The site is on a shared hosting package using Win2000.
View Replies
View Related
Using MSDE database & ASP file through IIS, both are in separate systems. Database is not connecting from IIS-ASP file.
Given error as "[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found", Using Provider=SQLOLEDB.1 But VB code is connecting using same provider
View Replies
View Related
Actually, I do not know why i can not add records to my access database table by using asp code, I get an error that tells me that the database file or object is read only file even though the file is not readable only from its proprties, I need some helpful information to solve this problem.
View Replies
View Related
I'm having this problem with uploading a file and updating the database at the same time the file will get uploaded but nothing will get updated into the database. Can anyone help me out. The third page is where everything is going wrong but i put all my pages in so you can see whats going on.
Here is my first page .....
View Replies
View Related
I am trying to write a page that lets the user upload any file to a server and this also stores the name of the uploaded file in to the database.
So far I'm not having much luck. I am a novice with ASP and really could do with some help.
I have been trying to use ASP Upload but it is confusing me as how to modify the script to allow me to insert the name of the File in to the database.
Here is my form page (you will notice this checks to see if we are uploading/editing or deleting). Code:
View Replies
View Related
I am methodically working my way through the Sitepoint 'Build your own ASP.NET website' and have been successful in every lesson up to page 279. However I've come stuck when trying to add information to an Access Database. When I try to do so I get the message:
Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
I have tried the solution described in the book but still get the message. I am using IIS and XP Professional. The database works for queries so how do I get it to accept information entries?
View Replies
View Related
I would like some one to help me in how to upload a file at aprticular kind of a file in the server at save it in a database in a feild using an asp.
View Replies
View Related
I had some issues with setting file permissions to write to my database in access. How do I go about, step - by - step setting the file permissions?
View Replies
View Related
I would like to know something about placing a password for a database in an external file, something like a global.asa file or a included file. I'm using an access database and ASP. how do I make this file and how do I attach it to my website. I thought this might be useful for extra database security, is this true?
The database is located in a folder that is protected by the hosting provider and you can only download the database using a login name and password and you can change data trough webpages (update, delete and insert).This has all about database security, I want to make my database as secure as possible, I'm already using SSL certificates.
View Replies
View Related
I would like to know if there are any tutorials out there or websites that can explain more about this? can this be done in asp?
View Replies
View Related
I have two forms, the first of which has a dropdown with which the user specifes how many banner ads he wishes to upload for a client. So say he enters the client info and wants to upload 5 banners. The form passes to another page which uses a loop to output form fields. Each form field name is something like name="msg<%= count%>" or name="url<%=count%>".
In the 3rd-Party script I am using I then have this script ....
View Replies
View Related
I have excel file,from which the all data to store the .mdb database. Any one give an idea.
View Replies
View Related
I want to be able to upload a image to a directory called 'images' on my server and also save the file name in a database. is there anything out there that does this without a COM?
View Replies
View Related
I have a form where a user enters their name, date etc. i also want them to be able to click on a browse button and select a file which will then appear in a textbox. when they press submit i want the file name and path to be put into the database. e.g.
"C:windowsworkwork.doc".
Basically I don't want to UPLOAD the file just enable the user to browse to it and send the filename and path to the database.
View Replies
View Related
I want to provide a function using asp for the users to search for their excel files in their PCs in IE and then upload to my database.
View Replies
View Related
I am trying to create an application feature for an inventory database and I am
wondering about the most efficient way to process the updates. Here's the background information: Code:
View Replies
View Related
I recently installed IIS lockdown, and ever since my ASP pages have been hell. One problem is that now after a user views my ASP page which reads my local Access DB, the temporary file, .ldb, stays in the folder forever!
This temp file is created when a user opens the file, so I checked out the .ldb file and it says the ADMINISTRATOR is opening the file! How can the internet user be using the ADMIN account?! This is not good news! I will share my code for my page; however I have a feeling the code isn't the problem, but a setting is. Code:
View Replies
View Related
