I have files in a folder that I am using the FileSystemObject to read. I can read the files and display links to them no problem, what I want to do is to sort them by date created.What is the best way to go about this?
View RepliesI've gotten a subroutine to almost work as I want it to, but it's refusing to show the newest file. It seems to choke on files created near midnight, just never showing them at all, and the date compare is showing an equal number for two different dates, though it surely shouldn't.
The code is running here: http://www.devedia.com/wiki/
The object is to show most recent file first, oldest file last. I have some leftover code in here to organize files by month created, but I removed the folders for debugging. The program moves any files created the previous month into a folder on the first of the month.
The folder name passed in is an X for recent files, a folder name (like 2005_04) when the files were sorted by folders.
What I'm hoping for from the intelligent people in the forum is either an eyeball on the subroutine to help me find where it's losing the midnight/most recent files, or a better idea on sorting by created date using the file system object and asp only. (NO recordset objects.)
And here is the subroutine. (sorry about the indenting... copy and paste it to read it better?)
Code: ...
I'm struggling with this problem: in a website I developed, XML files are created by users of the site to describe. The creation is OK, the (new) file is present, but it can not be read by any website visitor.
How can the default permission become at least readable?
It's a ASP script running on W2K, using the FileSystemObject component.
I would like to sort (descending) list of files in directory. Parameter is directory url.
How I can to do that with ASP not ASP.NET.
I have a date field in an MS Access database. I need to sort this field and print the results to an ASP page. I have done this plenty of times before except this time the date field data includes BCE data. A sample of the data in the date field is as follows:
1300 BCE
930 BCE
November 29, 1947
May 14, 1948
1465 CE
October 29, 1956
1020 BCE
I know that I can not have the data type of the MS Access field set to date/time. I searched online and didn't find too much.
I have a date field in an MS Access database. I need to sort this field and print the results to an ASP page. I have done this plenty of times before except this time the date field data includes BCE data. A sample of the data in the date field is as follows:
1300 BCE
930 BCE
November 29, 1947
May 14, 1948
1465 CE
October 29, 1956
1020 BCE
I know that I can not have the data type of the MS Access field set to date/time. I searched online and didn't find too much.
I like to pull the top 5 record that are closest to the current date but the date field can not be empty, see some records do not get assigned an expire date and others do. I want to show the closest expiring records.
objconn.commandtext = "SELECT TOP 5 * FROM merchants ORDER BY Expires"
What do I need to add to exclude the emtpy expires field records.
i use this script to generate download links from directories which are first passed to an script to record the number a link is clicked.
the function is calle with a path like:
ListFolderContents(Server.MapPath("/dir1"))
my question now is: can i write this to an multidimensional array (or object oriented?) - and then sort it by date ?? if so how ? Code:
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
i'm having problems trying to find information on how to write an asp
script that lists the files in a directoy
what i am looking to do is just list the 5 most recent files and list
them in descending order (newest) first
can anyone help me out here with a link, or some basic instructions,
i've found plenty of scripts that list files, but they don't explain
how its accomplished, and to me that's more important than simply
dumping a script on the server and using it
I have several (three) CSV files each with different columns and dissimilar data. The only common column is transaction date. What I'd like to do is combine the data chronologically. I can't do a join query because the transaction dates do not line up from file to file and no other columns will match either.
I just want all the rows from the three different files put in chronological order in one place understanding that my columns wont line up since the source columns are different. I've exhausted every effort on the SQL side to combine these, but I'm thinking maybe there's a way to do it with FSO or something else.
I'm using server.mappath to list a directory's contents. The code works fine, but the owner wants to know if there's a way to display the list by the date the file was posted, instead of the alpha order that it is presented by? I haven't been able to find an answer.
Here's what I'm using:
Using the below tage, i successfully add a new Record to my Videos table but the varibale i declare with the newly created rs ID is always blank? Code:
View Replies View RelatedI am facing a strange problem in my application. Its a ASP application. I have a drop down one page. When I select a value from the drop down, its an ASP call, after processing ,new session starts. This doesent happen for the first 3 or 4 times when i select the value from the drop down.
Also I noticed that when the new session is created , the old session is still alive.
Can You suggest me as to Y the Web Server tries to create the new session, when the existing session is still alive.
It is possible to create an image of the format gif, jpg or png with VBScript? If yes can somebody tell me where I can find such references?
View Replies View RelatedAfter restart some time is everithing ok. After some hours - some days, problem start. Only in pool, where dll VB6 is used, aspx pages (asp ok) does not work.
Event:
Failed to execute request because the App-Domain could not be created.
Error: 0x8007000e Not enough storage is available to complete this operation.
Source: ASP.NET 2.0.50727.0
Event ID: 1088
OS: Windows 2003 Server SP1
HW: dual Xeon, 4GB RAM, Server is not Domain server. dll VB6 is used in pool where aspx pages does not work, in other pools aspx pages work.
I have this form that creates a row in my access database. I then put in the action of the form another asp page with a questionmark and some stuff.
What stuff do I put there to help the other page recognize which row I'm talking about and be able to pull the correct information?
Using preferably Asp or an Asp component, but maybe .NET, here is what I need to do:
A user enters a hex value (Or rgb if need be), which then colors a pixel high, n pixels wide gif and saves it to a folder in the sites directory.
The session_onstart event will fire for every pull BECAUSE no SESSIONID cookie is ever created and the server has to assume that every HTTP REQUEST frame is a new session. The response object is actually just setting a header, of course.
Every redirect is sending a header to the browser equivalent to a "meta refresh" and that once again triggers the session_onstart.
I am reading and setting a cookie using JavaScript in the BODY onload
and onunload events respectively. This works fine.
However when I use ASP to set the cookie under some condition where I
want to override the last value set in the onunload event, it has no
effect. The next onload still has the old value.
The following code simulates the problem I experience....
I am trying to do a simple INSERT into SQL. I've done it tons of times before with the same code, but this time is is placing duplicate entries in the table. Any ideas why this would be happening? Here is my ASP code doing the form processing:
<%
set conn=server.createobject("adodb.connection")
conn.Open "Driver={SQL Server}; Server=SERVERNAME; Database=DATABASENAME; UID=USER; PWD=PASSWORD"
set rs = Server.CreateObject("ADODB.RecordSet")
strTitle = Replace(request.Form("title"), "'", "'")
strContent = Replace(request.Form("txtContent"), "'", "'")
strSQL = "INSERT INTO [webPages] ([created], [section], [title], [content]) Values ('" & now() & "','" & request.Form("section") & "','" & strTitle & "','" & strContent & "')"
rs.Open strSQL, conn, 3
%>
I'm having a problem dynamically creating an UPDATE query that will write the string value of an existing record set field into a data base.To be more concrete, I can generate a string that looks like this:
UPDATE Person SET Person.name='objRS("oldname")'
but when I try to execute it, the literal objRS("oldname")gets written into the oldname field of the Person table, as opposed to the value 'Betty'. (In a separate write statement, I've already checked that objRS("oldname") prints 'Betty'.)
And if I change it to:
UPDATE Person SET Person.name=objRS("oldname")
I get an error saying there is an undefined function 'objRS' in expression. Can anyone help me? If I can get this to work I'll be done with this task.
I run a website that reads our own databases and makes the data available to our users. However, recently someone has sent me a link to a php page that contains data they want me to display on our site. The php creates a csv formatted text string.
Example : I type in www.somewebsite.php and the page returns game1,gamedate,gametime,hometeam,visitor,,,, with real values of course being in these values. the ,,, are null fields that have no value as they expect our website to fill in this data for them from our users. how do I read this data with asp into a recordset, or a database?
I have an asp.net application that generates dynamic images (charts). When I run the application in debug mode from visual studio, or refer to the url with localhost in the name, everything works fine. When I try to access the site with the full machine name (not using localhost), or from another machine, the dynamic images only appear as red x's.
I've searched the groups, but can't find anything that seams to relate. I am assuming this is some sort of security setting, which I have messed around with in IIS as
well.
I'm using PerlScript in my ASP page and I have the following problem: Each time the page is refreshed a CSV file is created. I want this file to be available for download. The problem is I can't create the file in the "wwwrootsite" dir, so I can't link to it. I can however create anywhere else on the server.
View Replies View RelatedIs it possible to assign permissions on the fly as you are creating a directory structure on the web server?
I want to create a new folder for each new user of this system I built. Each folder will have the same permissions and will be used for uploading images. Should I just have write permissions on the parent folder and have the folder permissions inherited from the parent? Or is there a better way to do it?
I have created a session, where a user logs in using his/her email address and password.
Howver I now want to display the users name once he/she is logged in. It should be easy,
but I cant quite get my head around it.
I have some cookies created with javascript, I need to be able to delete them (by expiring them) or set their contents to nothing ("") using ASP. However, when I try to do this, it doesn't work. If I try to set their values to nothing by doing:
for each x in Request.Cookies
response.cookies(x)=""
next
It just creates a duplicate of each of the cookies with no content.
If I try to expire the cookies by doing the following:
for each x in Request.Cookies
response.cookies(x).Expires=date-1
next
It does nothing. They don't expire.
How can I get ASP to recognise and modify the actual cookies which are there?
Just installed VS2003 and tried a hello world app. Getting 404 error even
when I explictly specify the start page in the url.
In IIS Mgr (v 5.1), App has .aspx mapped to
C:WINDOWSMicrosoft.NETFrameworkv1.1.4322aspne t_isapi.dll.
The file in question IS in the virtual directory and this is the inetmgr log
file entry that occurs when my browser requests the page: 19:42:27 127.0.0.1
GET /UP1/WebForm1.aspx 404 Code:
I want to delete all the cookies which are created for the application.If i know the names of a cookies i can delete the cookies or i can set the expire properties.
View Replies View RelatedWhen I use a host file entry to point to the host header of the site
that I have created on a Win2k server running IIS5, a cookie is not
created to hold the session id. The result is that Session_OnStart is
run every time a page is requested.
If I set up a DNS entry on the DNS server it all works fine.
I never noticed this problem before we put in Active Directory so it
may have something to do with that.
I have set "allow per session cookies" to promt(under Custom Secrity
settings in IE) to see if this is being attempted and it is not. So
the browser is not even trying to create the session cookie when using
the host file.
I am having trouble loading the result of a VBscript split function into an array. The script is supposed to take the user's login name (the form for this is name separated by underscores such as john_foo or lisa_wilson), split it at the underscores, and load first, middle and last name into an array. The problem I keep getting though, is that I am getting a type mismatch error. Here is the code:
<%dim LogName, NameArray(), FirstName, LastName, MiddleName, LastPage
'Get NT authorized login info
LogName = request.servervariables("logon_user")
NameArray = Split(LogName, "_")
for x = 0 to UBound(NameArray)
response.write NameArray(x) & "<br>"
next
%>
The FirstName, MiddleName, LastName vars are supposed to take the array values later.
I created controls dynamically.I want to capture the information from those
controls. Code: