How to retrieve "Last modified" & "FileName" from all files in a specific folder (called MyDocs) and display on the ASP page?
eg. (in MyDocs folder) - MikesWork.doc - MyResume.xls - HouseExpenses.xls
Situation Let's assume that i just modified MyResume.xls file and save it today(10/30/2003) on my computer, then i upload it into the internet. On my asp page, i want to show all files Filename (Last Modified) in MyDocs folder. eg. Your Documents 1. MikesWork.doc (last modified 10/24/2003) 2. MyResume.xls (last modified 10/30/2003) 3. HouseExpenses.xls (last modified 9/15/2003)
I know it has to do with fso or something close to it... but totally have no idea (zero) of its logic or how it works. Please help me by giving me with full example.
Can anyone help with the following: I wrote an ASP script with allows me to select an MS Access database from a folder, and it shows the tables in this database. If I click a table, the fields are displayed. And then I have a button to create a HTML form to suit this table. My problem is, fields that are essential.I would like to mark appropriate form fields as 'essential' . Is there any way I can get the attributes of a field, so I know if it will accept null values?
Is there any way to list all the properties that an object has? For example if I do a CDO.Message object and call it NewMail. Is there anyway I can find the properties of that the object supports. IE NewMail.From, NewMail.To etc
I want to ask are there any other ways to get the file properties such as file name, path, date created... other than using 1. FileSystemObject or 2. file upload with encType="multipart/form-data".
For FileSystemObject, I can get it work in my local computer but not on the server(coz the server are not mapped to the network drive).
And for case 2, although I can use HTTP_CONTENT_TYPE to retrieve form values but I think I cannot use request.form("aa").count or request.form("aa").item(i) to get select option values.
I ve probably a very simple question but i really can't find an answer. I d like to know in an ASP page what is the URL of the page, the full URL invoked by the client to get the page. I looked in the server object but i did not find.
I am in need of knowledge about how to control the properties. By properties, I mean font, hyperlink, and color information. I'd like the spreadsheet to have the same data as the HTML page it's getting the data from, but in a different format.
I have been searching in several places, including the Excel Help files, but cannot find any info on how to do this. I'm not asking anyone to tell me how to do this; just looking for where to find out how to do this.
According to Access my ADO connection has a value of 16 for the Transaction DDL property. Does anyone know what this equates to? I've found this page -
I've uploaded an image to the server and was wondering if there is any possible way to get the dimensions of the image through ASP.
dim iWidth, iHeight, iType sub ImgDimension(img) dim myImg, fs Set fs= CreateObject("Scripting.FileSystemObject") if not fs.fileExists(img) then exit sub set myImg = loadpicture(img) iWidth = round(myImg.width / 26.4583) iHeight = round(myImg.height / 26.4583)
Is it possible to set a cell property in Excel from an ASP page. We have numerical data that is taken from a database and then displayed in Excel. I would like ideally all the data to be set at 2 decimal places, is there anyway of setting this from the ASP page?
Does anyone know of a way to access the document properties of an office document using ASP? I need to be able to read things like the Title, Author, and Comments fields and pull that information into a web page.
Before there was XML my world was in order, I would once a year write some small ASP script, it would perhaps take me all weekend, but it was doable, now the devil has entered my life, in form of an XML file ... Code:
I have a date entry on a form that must be at least 30 days from the current date. It is a delivery request date and the soonest it can be processed is 30 days from the request. I need code to validate and message should they enter a date less than 30 days from the current date.
I've been given a task to write an function to validate URL's used on a website. The URL's are going to be kept in a table with other fields to indicate if the URL is valid and when it was last validated.
Any URL's that aren't valid won't be displayed on the site. Is there a way in ASP to check if any given URL returns a 404 error?
I have created one of those change your password forms whereby the the old password and new password are provided.
What I am having trouble with is ensuring that the old password entered actually exists already. Below is what I have tried, but I am getting a syntax error:
Code:
'Check Password
if request.form("CusPassword")<>rsCheckUser.fields("CustomerPassword") then
response.write "Invalid password"
end if
Else
if request.form("CusPassword")= rsCheckUser.fields("CustomerPassword") then
'write new password to databasestrSQL ="UPDATE Customer Set CustomerPassword ='"& NewPassword& "',CustomerPasswordverified ='"& NewPassword& "' where CustomerEmail = '"&CusEmail&"' "
I have a form which consists of a few fields. The problem that i encountered was it seemed like just checking the first field only rather than all the fields. Code:
I am looking for a way to do a validation in the form that who ever is filling the form is a true person & not a automatic system. there is a way to do it with letters in an image & the user must enter the same letters in a text field.
I am wondering if there is a way to validate a user's login from 2 different tables. Currently I have a sql string that pull info from a table based on the users login and password.Code:
sqlStr = "Select * From authorised_user_table where username = '" & Request.Form("username") & "' and password = '" & Request.Form("password") & "'"
My problem is I the passwords in this table are old, and I have a new table with all new passwords (same structure, just different passwords). I'm thinking most of the users don't remember their new passwords just the old. So is there a way I can query both tables? Something like Select * from table1..... else Select * from table2
I once saw somewhere, and I cannot recall the site / article... But I believe there is a way that you can "Check" an E-Mail Address to make sure that it is a Valid Email Address. NOT Syntax checking... But to actually determine if the email address typed in is a "Real" and "Active" E-Mail Address.
I realize this is not solely an ASP question, but I thought you guys might know the answer and I couldn't find anywhere else to post this. If you have suggestions for this I am more than happy to post somewhere else.
How can I, using ASP code, validate whether or not an email address is a real one? For example, if I have the email address called Join Bytes! how can I determine if it is real?