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 would like to add a facility to my web page which allows users to upload basic files (word, excel, text, gif, jpg etc) to the server.
I know there's a facility to do this using HMTL forms, but I don't know how to handle the file on the server side.
What I think I need is an ASP file running some code to manipulate the filesystemobject, allowing me to receive the file and store it in the filesystem on the server. It would be nice to access some of the file properties too (name, type etc).
I've seen a few custom components online which allow you to do this, but I can't depend on installing them. I need to be able to script it myself.
I want to know if there is a way to retrieve the tag from the URL, I don't know if thats its name, so I'll just explain what it is:
showmsg.asp?FID=mn&ID=2467#2529
the tag, as I call it is what follows the # sign, the number 2529, in this case. so, is there a way I can retrieve the tag with ASP, by the request object, or any other way, any Ideas? Another thing I wanted to know, not related to this subject, is how do I change value of a textarea that is placed in another window with VBscript or JAVA. is it possible?
I have three different tables I will be pulling stuff from: user_info, img_inv, activitylog:
user_info I will be using their ID and state img_inv I will be using part number activitylog I will be using part number and date
I'm trying to select the part number from the activities list and match it with the img_inv to make sure it still exist. If it exist I want it to do a total count of how many times it has been looked at by 7 states within a given quarter. Code:
I want to retrieve the value of a cookie to make a form a little more user friendly (our intranet is configured to set a cookie for User First Name, Last Name and Email when they log in)
Unfortunately I can't figure out how to retrieve the value of the cookie. I've been trying:
<% Response.write Request.Cookies(UserLName) %>
But it gives me an error - I used Checky to make sure the cookies are there and they do exist:
i want some help in how to retrieve values from multiple selection listbox. i want the values retrived to be used in the search which i perform from the database. i m doing a search feature which u all often see in job search sites. so someone selects multiple cities to search in i want that to include that in my search query.
I have a form that send values to a second page. i m trying to compare the values received from the form with other values retrieved from a database. so if a value already exists then an error message is displayed. in order to compare the values i need to print them on the second page but I m bit stuck with this. i used request.form("category") in order to retrieve the values from the form but it doesn t work.
I am trying to get a field populated in an oracle database with a time stamp of when a form is submitted.
I have found out that there is a table in Oracle called DUAL which holds the current date and time. At present i can populate the date when the form is submitted using objrs('sub_date')=date() but when i query the database the time element of the field sub_date, the time displayed is 00:00 which is the default time.
So can anyone give me any help in how i can capture the time. I know about select to_char(sub_date,'DD-MON-YYYY HH24:MI') which will bring up the time but i can seem to populate the field sub_date with the time.
I am trying to retrieve the page name. I know this is possible using Server Variable PATH_INFO. The problem I am having though is that when I get to a page in one of my subdirectories the subdirectory name is displayed.
Example: my page index.asp is in the the admin directory so the PATH_INFO displays as /admin/index.asp. How can I strip the page name out so I get index.asp. I cannot use the function Right() since the page name could be any length.
I'm writing a vbscript application that reads UTF-8 XML containing Chinese characters and stores the data in MySql 4.0.x. Does anybody have any experience in this area with regarding codepage and character sets? Ideally I want the scripts to be able to handle Standard European characters and Chinese characters as well. Are there any special considerations for using MySql/ODBC and ADO to get and put the data.
Right I have my files going into the database, and once successfully uploaded, a user is shown a few bits of information in a table such as the primary key, name of file, its size and the content type.Now i want to create <a href> links on the homepage etc so that browsers/users can download these files one at a time. So when they click the link, the Save.Open or Cancel dialog box appears. Have been trying different things for few days now but finally thought I better ask for some help as Im gettin nowhere.