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:
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
Using ASP I'd like to modify a string that contains HTML. I need to modify the content (the bit that the users see) but not the stuff in the tags. For example, if I had the following string Code:
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?
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 put in a request recently for a script which would return 9 random numbers between 1 and 30. I got a reply which gave me this script, which writes them out.
It works great, but in the loop that writes them out, instead I would like to assign each value to a variable, such as img1,img2,img3,img4, etc. in the for loop, is this possible, or should I write out 9 statement lines, each assigning a value to a variable. I intend to plug the values into a java applet which rotates images.
Come to think of it, I could just put each value of the array right into the img tag, no? <img src="images/<%=random_number(1)=>.jpg"> Code:
If Request.Form("resScreen") = "1024x768" Then screenSize = "big" Else screenSize = "small" End If
this works fine, but when this page is reloaded, it doesn't find this Request.Form("resScreen") (this form is also on another page, which explains why) but can I store this variable "big" the first time it loads somehow?
For Each objitem in Request.Form if request.form(objitem).count > 0 then For intLoop = 1 to Request.Form(objitem).count Objitem = request.form(objitem) End if Next
server error in line of "end if"
I want to collect the values from the form and assign a variable to each value field
I am using Visual Studio I have created a website using HTML code and the pages look fine I now need to do the following.
I have a picture where if some one clicks on it it then needs to query an SQL database and return on a different page the results. How do I assign a sql database to my website and how do I connect to it ?
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?
I'm retrieving the screen resoltion with javascript code, but i can't assign the correct value to asp. the response.write is displaying zero (0) for screen res., although when i do a document.write in the javascript part, then my screen res. is 1004 ...
I have this simple application that I put together using ASP. It has an html form that submits to an access database through a simple ASP file. It’s a survey form basically. One of the departments here wants to get some feedback from their students and in return for filling out the survey they will be entered into a drawing for a gift certificate. The catch is that the survey is anonymous. What they want to happen is each person is given a unique number at the end of the survey and they will pick one of those numbers randomly to see who the winner is. How can I possibly do this? I am stuck.
I think I may know what I need to do:
Pull a unique number from a database and post it onto the HTML form near the submit button. Notate on the page that the user write the number down and when they hit submit it is inserted into the database along with the record. I have absolutely no idea how to do that.
The HTML form submits into the database using this "add.asp" file:
I'm setting the title attribute of an input box to assign a tooltip. If I assign title the value "Agent does not exist", when hovering over the textbox the tooltip will only display "Agent" it's the same with all my tooltips (only the first word is displayed).
I'm having a bit of a problem and I was hoping someone could help me out. I'm trying to create an interface for manipulating historical stock prices obtained through finance.yahoo.com. I need to make a recordset contain the data of a CSV file that Yahoo returns, but the catch is that I want to pass the data along by pointing the recordset to the URL of the CSV files on the Yahoo server.
Yahoo creates its CSV files dynamically through the querystring of its URL (see below), and I would use inputs to my interface to manipulate the URL for specific ticker symbols, dates, etc. I guess the simplest example is that a user could input a ticker to my interface, the recordset would somehow "call" the URL for the correct data, and then that data would be in the recordset, where I could manipulate it, before returning the information back to the user.
I'm just stumped on how to get the CSV data into the recordset on the fly, just by calling the URL.
The following link is an example of what Yahoo does. Manipulating the querystring changes the ticker, date range, and level of detail. You can also change the table.csv to table.txt and return the actual data in one big text file. Code:
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.