Is there any way to check for .zip or .txt files prior to a file upload starting. The method I have working currently checks immediately before saving but only after the processes has uploaded the file. Can the extension (and file size) be checked as they are selected by browsinf via a form.
I suspect this is not possible but it must be possible to check them before doing anything further.
strSQL = "SELECT SUM(price) AS XX FROM ...."
set objRec = objConn.execute(strSQL)
if objRec.EOF then
A = 0
else
A = objRec("XX")
end if
Response.Write "total : " & A
There is no records return, but output printed "total : <empty>"
I thought the IF statement check for 0 records and assign value "0" to it ? And it should return "total : 0"
The statement that assign value to variables A is wrong ?
I need a solution that will run through all the files in a folder (specified path), and make sure that there names arn't the same as the file I have.
View Replies View RelatedI want to upload images from people and save the name of the files in a database so I can later populate from there. The uploading part is working fine, except that when I use SaveAs, if the file exist it rewrites the existing file...
I did do a search in the forums and tried to use a code that memnoch posted but it wont work since the aspsmartupload objetc doesnt support the FileExist Method... the code from Memnoch that i tried to use is the following: Code:
I would like to inquire how would it be possible to use asp to check the format of the excel being uploaded? Like the first row in cloumn A is named Results, column B is named Example and so on.
I've already able to use asp to to extract the data from the excel and insert them into the access ab. Now I would like to know how to be able to check the format of the excel file being uploaded, if it is the way i want then it would proceed to insert the values into the access db, if not the user will be informed that the format of the excel file was not the standard one.
I would like to inquire how would it be possible to use asp to check the format of the excel being uploaded? Like the first row in cloumn A is named Results, column B is named Example and so on...
I've already able to use asp to to extract the data from the excel and insert them into the access ab.
Now I would like to know how to be able to check the format of the excel file being uploaded, if it is the way i want then it would proceed to insert the values into the access db, if not the user will be informed that the format of the excel file was not the standard one.
Is there a general way of placing an 'error_check' include file into
my website, and put the include line onto all 'asp' pages. In the
event that any error occurs on any asp page or with the database,
instead of the user seeing the error on screen, they would be
redirected to a custom error page ?
When you have a FILE input in your form (ie. <input type="file">), is there any way of forcing the filetype to a certain type (eg. .DOC, .XLS) when you hit the browse button?
View Replies View RelatedVery LAST part of the project:
I want users to pick a file from a pool (=folder) in which they should be 'locked'. I tried using this method:
<input type="file" name="image1">
Once clicked the browse button, it takes the user to a client folder. I want to take the user to the pool on the server which has the uploaded images. Is this possible?
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?
View Replies View RelatedCan I check uploaded file type? This is my code:
if (file.ContentType=="application/vnd.ms-excel")
But if I rename a txt file to .xls it not run.
I m using
<input type="file" name="abc">
But when I retrieve the contents sent after browsing the file from the system using
Request.Form("abc")
the retrieved value is null, ie., blank.
Why is that occuring??
I wanted to write a simple page to let me choose a directory and then list
the files in it. The end goal was to make an easy way to copy all the
file names in a directory. I tested with Opera7, Mozilla 1.4 and IE6 -- all
on windows XP Pro
Here is the code. In all three, when I select a file, the complete path
is displayed in the file input box. In Opera, reading the form field gives
me the same full path. But in IE and Moz I get only the filename -- none of
the path information. Code:
I need to make a check for file type at client end, ie allow only files that are images to be uploaded and prevent the others. I tried using the HtmlInputFile.Accept Property, but it somehow doesn't seem to work.
moreover, it claims to support only few browsers. Also, javascript in itself, gets very dirty, if i start making validations for every thing. Does ASP.NET support any control which can cause these validations? what is the most elegant way to do this?
I'm trying to input image file using this synax.
<input type=file name="tx_file" accept="image/*"
class=boxText>
But when open file dialouge appears, it shows all the file and user can select any file and i.e. i dont want.
Have been struggling over the last 2 days trying to submit an XML form through to 3rd party application. Have tried XMLHTTP, and ServerXMLHTTP, and these are all good for normal form input types but i need to submit a input type of file called 'XML', to a resource which I cant control how it processed it.
Anyone have any ideas of how to do this, I can save and open an XML document from a the dbase created string, but when I send the serverXMLHTTP variable XML = contents of the file it doesnt get processes as a noraml XML document.
Have a look at the function I have, which submits but doesnt see the submitted variable as an XML document. Code:
I'm building a system where a presenter uploads a PPT to my server and
then I show it to all the participants. The problem is that most of the
media in the PPT is usually linked, so I'll need to upload all that
too.
Assuming I can parse the PPT and figure the exact name and
location of each of the media files I need from his hard-disk, is there
any way I can upload all these files automatically, without having to
make the user choose each of these files manually? If that's not
possible, can I atleast show the user a page with a list of input boxes
of type file, pre-populated with the file-path and name of the media
files I need, so that the user can just click 'Submit' without having
to browse and select each of them?
Please say yes. It would be a major usability crisis if my users had to
keep hitting the browse button so many times for each PPT! Especially
when I know exactly what files I need and where they are! I know that
this has a lot to do with browser security, but there's got to be SOME
way out?
How verify type or extension of file using ASPUPLOAD? I check documentation, but I didn't find anything else yet.
View Replies View RelatedI got a problem while running an application. The code for this is as follows:
aList = Split(strMsg,";")
For nX = 0 to UBound(aList)
strarry=split(aList(nX),"_")
var_year=left(strarry(2),4)
var_month=mid(strarry(2),5,2)
var_day=mid(strarry(2),7,2)
var_date=var_day&"-"&var_month&"-"&var_year
var_time1=mid(strarry(2),9,2)
var_time2=mid(strarry(2),11,2)
var_time=var_time1&":"&var_time2
set rs1=conn.execute("insert into tbl_BackupfileInfo(Filename,Createddate,Createdtim e)values('" &aList(nX)&"','"&var_date&"','"&var_time&"')")
Next
while runnig this application some times it works fine .But some times it giving an error
Error Type:Microsoft VBScript runtime (0x800A000D) Type mismatch: 'UBound'.
I have some ASP pages on my intranet site providing a helpdesk to my users. As part of logging a helpdesk call I am prompting them to link to a file using input type="file".
The file is on a network drive and the problem is when you click on the browse button it defaults to the clients desktop as the starting point of the browsing process. I would like to set a default location to start browsing eg etwork_serverhelpdesk to avoid confusion. Does anyone know of a way to do this ?
<INPUT TYPE="FILE" SIZE="50" NAME="FILE2">
I have this form field that I'm processing on another ASP page on submission. How do i determine if this field has had any data input? I tried
<% Request.Form("FILE2") %>
but it does not have any value. What am i doing wrong?
i need to display a name of a file retreived from database in the <input type="file">
field. The code is:
<INPUT class="txt" TYPE="file" NAME="filename" SIZE="15" value=<%=filename%>>
I have done the select statement and assigning of the value into variable "filename".
But, the value doesn't get displayed.
need to display in file input type cos user may need to select another file.
I have a form as follows:
<form action="dropboxsubmit.asp" method="post" enctype="multipart/form-data">
<input type="file" name="FILE1" size="30">
<input type="text" name="def" value="0" size="10">
etc.....
and can't get my asp to recognize data in other form input boxes using Request.Form
Any thoughts?
I am trying to send a fax from my asp application and am getting the follwoing error on the hghlighted line:
Error Type:
(0x80004005)
Unspecified error
If anyone knows why..Code:
I have a table with four fields, ID (auto increment), question (varchar(200)), answer (Text), and shop (tinyint(3). When I connect to the database in an ASP page and write this code
Response.Write rs("question") & "<br />" & rs("answer")
I get an error that reads "Type Mismatch"
but if I change the type of the answer field to type varchar I don't get the error but am limited in the length of the field's contents. I just also noticed that if I keep the type at TEXT and change the collation to ascii_general_ci I don't get the mismatch error but all the ' characters turn into ? characters? Oh woe is me.
I have this table that has two columns Department and RecId. what I am doing is I need to give access to different people in different departments. So if I am in billing I say billing 76 which is my rec id and than if I also need acess to accounting I say Accounting 76.
So now in my asp page I open this records set to check and see who has access to what departments and give them the access Code:
I want to check whether the value in recordset is "=> 3 ".
I try "If rs => '3' then...".
But it doesn't seems working. Can I can't check the condition by using the recordset like how i written above?
Or do I need get the value in recordset and assign to a variable in order to check the condition. Please advice.
Let say my rs now stores a value of "2". Can I check with the following code.
[code]
set rs = server.createobject("...")
rs.open "Select...", objconn
if rs >=3 then 'THIS LINE DOESN"T SEEMS WORKING
....
[code]
I want to do some error checking using on resume next to determine whether to commit an ADO transaction. However we have a custom 500 error page which we use through out the rest of the site. Can I remove the on error resume next after I have rolled back the transaction and raise a normal error.
View Replies View RelatedI'm trying to qualify email addresses. Is there any reason why the following line would not catch an email address beginning with "www." ?
ElseIf Left(Session("em"),4) = "www." Then
I put in a dummy email address: www.mydomain@aol.com and it goes through....
<%=Left(Session("em"),4)%> does reflect "www."
why?
Is it possible to have an ASP page which checks if a user is in a certain group in Active Directory (AD). For example jbloggs is logged in and belongs to the group "project_allowed". When jbloggs goes to project.asp it will allow him access
However when jsmith is logged in and belongs to no groups and tries to access project.asp it will deny him access.
The script is designed as a form validator which checks fields for various criteria and then sends a mail with the form contents. Since 40 different forms will be plugged into this script, there needed to be complete seperation between the two.
I've managed it so far by checking for required fields by putting the word 'required' into the name of the field. The script then sources out any fields which has this text and checks them to see if they are filled out.
The problem I've come across now is that I need to check for field length. My idea was to put the amount of characters needed into the name of the field in the form and then have the script check with a Reg Exp. However, Im not too sure of the regular expression needed to check for this.
Can someone suggest one? The one I have at the moment is [1-14] but say I had a field like this: <input type="text" name="passwordrequired12"> That would match bout for 1 and 12. Any ideas?
How can I check whether a variable is set as a value, integer, etc .. ??? (So that when a user submits a value via a web form and its a letter, i can give them an error note.)
View Replies View RelatedI am writing a script that lets me brows the contents of a web server. The problem is the account that is running ASP does not have permissions to every folder. Don't ask me why ... I have no idea but it can't be changed.
What I would like to do is perform a check for:
Microsoft VBScript runtime error '800a0046':Permission denied
And if this happens display an error message saying they do not have permission to view this directory. Code: