Finding Newest Record
I have a section of code that is supposed to search through a DB comparing a field of when the record was added. Its supposed to find the latest record and move to that record so it can process some other code:
View Replies
ADVERTISEMENT
How To Return The Newest Record
I have a database that has only 3 users in it. (that is the way it will pretty much stay) They will be contributing articles to a web site on occasion. So I have only two tables in the database, one with for the "writers" and one for the "articles". The relation between the two is based on the ID given to each writer.
ON the main page of the site I will have a little table that will display each writer with their picture, date of last entry, and topic. So what I am needing is the code for the Record Set to go and look in the database to find the latest article for each writer so that it can be placed in the table.
Display Newest 10 Records
my select is done and I have all my 200 records..... now I want to display only the 10 newest one.
do I need to specify something special in the Select or a simple Response.write will do the thing? Either way, am at lost as to what to do.
Select Newest File
We down load a text batch every day from the site to the local computer so we can run it through the carriers program to create the labels for items. I want to speed this up as much as possible thus once the item is downloaded a user should open up a page and it should detect the newest file and then begin to edit this.
(Finds | and splits down by product so I can do type of posting and if 2 items need 1 label then don;t waste or if going royal mail instead put into another database!)
So basically - can I select newest file from folder as there is no easy pattern name wise. In terms of the name the batch number goes up once per day and so it xyz99.txt so I would need to find 99.txt etc...
Finding Age
I have a database with date of births stored dd/mm/yyyy (english dating
system) and =date() returns a date in the same format in my server.
how do i find the persons age using these two pieces of date.
Finding Word
i want to make a program to find out and highlight a particular word on the browser using ASP and javascript.
View Replies View RelatedFinding A Path
Is there something similar to PHP's php_info command to tell me all about the server? I need to find the actual path where the site resides.
View Replies View RelatedFinding The Webserver Name
I need to create a new application in our test server. I am using VID for
that purpose. In order to set up the project in VID, it asks me 'which server
you want to use'. However, I do not have the name of the test server. Is
there any way to configure the name of the server here? I have full rights to
the server directory and is mapped on my machine as G drive.
Here Is A Function For Finding Age
Here is a function where you don't have to worry about the leap year.
You will have to still be aware of time differences between you and
the server, and correct your data before entering it into the
function. And of course time zones, yada yada ....
BUT I think that most people using this will just want to say if today
is there bday than they are their new age. Code:
Finding Version
How can I programatically ascertain what version of ASP my ISP has installed ?
View Replies View RelatedPercentages Finding Of
I need help to find percentages, because I missed out on a lot of basic math education, I need it to be real clear step by step instruction for instance how would I go about finding 24 out of 32 one step at a time?
View Replies View RelatedFinding A Port
i know how to find the available server names, how can i find the ports?
View Replies View RelatedFinding A Hotel
I am developing a hotel finder solution in Canada. When some one enters a Postal code, it should be able to display the hotels in 5 KM radius. (With nearer PIN numbers?) I am deleloping this application using ASP, and is there anyway I can such searches?
View Replies View RelatedFinding The Space
I trying to find the memory occupied by the object in RAM, For Example:
Set ObjTest = Server.CreateObject("ADODB.RecordSet")
I need the space occupied by the ObjTest in RAM. Is it possible ?
Finding Max Value In Database
I am trying to find total number of parts in the database for a user by using the COUNT function:
max = HelpDesk.Execute("SELECT count(PartRef) AS 'maximum' FROM MISC_PartInfo WHERE Username = '" username "'")
but when i try to output the result by:
Response.Write max("maximum")
I get the error:
Item cannot be found in the collection corresponding to the requested name or ordinal./Intranet/test/PartInfo.asp, line 82
Finding Every Monday
if anyone can point me in the right direction or has code on this. i'm trying to display the number of occruances of an event during each week of a given month. basically, i'm looking for code that finds every monday of a given month.
View Replies View RelatedFinding No. Of Pages
one cant do a straight division because if i have 20 per page and 22 records, that's two pages. best i've come up with so far is
Code:
iPageCount = fix(iNumRecords / iPageSize)
if( iNumRecords mod iPageSize > 0 )then
iPageCount = iPageCount + 1
end if
anyone managed it better? is there a function like fix that forces a round up?
Finding Maximum Value
How do I find the maximum value of a recordset column? I'd rather do it this way than open a new recordset with Max(column).
View Replies View RelatedFinding Element In Array
I'm creating an array from the querystring, then I want to find if something is in that array..
url = quiz.asp?done=6|3|4
done = Request.QueryString("done")
myArray = Split(done,"|")
For Each i In myArray
If myArray(i) = x Then
do something
End If
Next
I keep getting a "subscript out of range error"
Finding Out The Number Of Requests
I have a form. When I do action="POST" I can see the changes done by looking at ---- for example request("MyBox")
Where MyBox is a dropdown box and by doing request("MyBox") I get the selected value.
Is there a way I can get the number of requests done? (i.e if I had 3 dropdown boxes then I get 3).
Also is there a way to get a list of the names of all the requests (i.e if I had 3 dropdown boxes then I get MyBox1 MyBox2 MyBox3)
Finding And Renaming Image.
Heres what im trying to do, I have mssql databse full of about 15,000 item ID codes. For Example of the ID Code:
The first 2 sometimes 4 letters represents the distributor name, the numbers are the item number and BX for example means Box.
DJ3726
DJ3847BX
DJ3743CD
PD2374
PD2334
PD4334BX
And I have about 15,000 images from my distributrs that mostly match up to the actual ID number, but still a lot dont match up because of a small extra letter like BX Or somehting like that.
So what ive done was write a code that Splits out the Manufature code for example DJ from DJ3726BX, and also the same for the item ID 3726 from DJ3726BX, So when I put thos to together I get just the manufature name and ID code instead of the extra crap I dont need.
And now I take just the Manufacutre name and ID and looping through my database and all of the (images via File Scripting Object).
Then I check to see if the manufacure code and ID is in the item name. For Example
Check if DJ74637
IS In: DJ74637BX.GIF
Then if it finds a match it gos and renames the gif for me. And it loops through untill its done.
My problem is that it just doesnt work, no errors no anything it just doesnt pick up any images when I can visualy go through my self and find some matchs.
Heres my code that I came up with so far ....
Finding Current Directory?
How can I find out the full directory path (i.e. c:path ofile) of a file? I'm logged into a server and the of course, I have an FTP directory root, but I need to know the absolute path.
View Replies View RelatedProblem Finding ID In Database
I have this page that gets a list of catagories from the database and displays them with there id numbers in a select box like this
<select name="catagories">
<option value="1">Catagory 1</option>
<option value="2">Catagory 2</option>
</select>
Then I post it to another page to process the information. This is written in asp and vbscript.
I open a dsnless adodb connection to the database then use it to create a recordset for the catagories table.
the problem is when I check the idnumbers in the database with the one posted selected by the user in the previous page none of them match. Code:
Finding Directory Level
I am using Request.ServerVariables("SCRIPT_NAME") to get the extention from the url and need to know if I am in the root or down a directory. i have two folders, one called 'local' and one called 'group'
View Replies View RelatedASP Not Finding File That Do Exist!
I'm using vbscript in ASP to loop through and rename the files passed to it in a form. When I output the text to the screen of the filenames etc it's all working fine.
However, when I try to get the rename code working, if I select more than one, ASP tells me the 2nd/3rd etc file does not exist. The first one always renames ok.
I presume this is something to do with the Server.MapPath, but what exactly I have no idea! My code is below, can anyone see what I'm doing wrong? Code:
Finding Addresses From Postcode
I'm looking at including the functionality of allowing the user to enter their ostcode / number and for the rest of their address details to be retrieved and populated.I have seen one or two solutions via google but these require you to pay, and I was wondering if this is something that can be achieved for free?
View Replies View RelatedFunction For Finding File Name
i have a person upload a file, that is done, then i want to email the file. I know the location, but not the file name. How do i find the file name to attach to the location addy?
example:
objEmail.AttachFile("d:greguploads" & filename & """) , "SNAIL_File" , 1
Finding Links On A Page
I'm looking for an ASP/VBScript function that would accept a string of text, use a regular expression to find all of the links within that text, and output an array of the links with the text that was linked (i.e. between the "a" tags).
Does anyone have such a thing? Right now I would even settle for just the regular expression pattern. I've done some searching and haven't found what I'm looking for. With some trial and error I could probably create it but I was hoping someone else might be willing to share.
Finding Hidden ASP Variables
I'm working on an ASP page that calls variables from another ASP page that I am unable to access. Is there any way to call all active variables from the other page and list them out, so I can find the variable names that I need to work with?
View Replies View RelatedFinding Variable For Filename In ASP.net
I have tried 3'rd party .dll solutions, and nothing seems to work. (I tried to use aspsmart upload and could not get it to run properly, if you have gotten it to run maybe you could PM me? )
Anyhow for the time being I am using an ASP.net solution which uses the C# language I belive. Now the script works fine, but the only problem is that since I do not know much about asp.net and the included sub-languages I am at a loss as to attempt to record the filenames and store them in a Dbase.
The file is uploaded, then it responds by telling you "test.txt" has been uploaded successfully. But I cannot seem to find any way in which to isolate the part of the code that displays the filename(s), which means I cannot store them and submit them to a Dbase.
So, after all that horrible explaining here is the code which works flawlessly (at least on my system): Code:
Finding The Lenght Of Each Word
how I can find out the length of each word in a string? I'm building a site with CSS and would like to detect the length of each word in a string that a user submits as comments.
What happens is if a word is too long it expands the div.
And wordbreak works only in IE. So i'm thinking of replacing long words before inserting them in the db. So if theres a string like "YAAAAAAAAAAAAAAAAAAAAAAAAAAAA we won", i can replace the long word with anyting I like and proceed. how to do this?
Finding Open Connections
Is there a way to detect open recordset and connection objects easily? I have hundreds of pages of code making up this web application I wrote and I want to make sure I didn't leave any loose ends. Short of going page by page, connection by connection, I'd love to discover any issues a different way. Does anyone know of a strategy?
View Replies View Related0x80004005 Error, Cannot Add Or Change A Record Because A Related Record Is...
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code: