Info From Latest Date
I would liek to select certain ESN number from my databas by the latest date. Even if the date on it is not current. Just all info by the latest dat.
Select * From <databasetables> ....
I would liek to select certain ESN number from my databas by the latest date. Even if the date on it is not current. Just all info by the latest dat.
Select * From <databasetables> ....
I want to display a little image next to the topic if the thread is recent and the user hasn't logged on in a while and then get rid of the image if he clicks on it.
What's the simplest way to do this?I obviously don't want to make a read/unread thing for every user.
I have a database with multiple records which are often updated. I am trying to display the latest entry in a certain way (with css div styles) and then list the rest of the entries another, less elaborate way.
Is there a good / preferred way to do this? Right now I have it so that it SELECTS TOP 1, displays that in a certain DIV, and then SELECTS * - however what is wrong with this is that it displays the first record twice.
I wanna write asp code to pick up *.MAI from particular folder and read them. There is no problem with reading the file but how can I pick up the latest file from particular folder?
View Replies View Relatedi have table Comment and Customer. Customer is a registered customer. but, comment can be given by registered or non-registered customer. right now, i have 6 records which are 3 registered customer and 3 non-registered customer in Comment table.
for the non-registered customer, i put as a Guest for their name while registered customer, i have display his/her real name. my problem is, the latest record in Comment is a registered customer and her name is displayed in the html table but the rest registered customers, their names are not displayed. something wrong is there. for the non-registered customer, no problem at all. this is my script. at this page also has paging script. Code:
I downloaded the latest version of the VB scripting engine for Windows 98 as I needed to have support for regular expressions. Everything was fine yesterday but when I switched my pc on this morning and tried to access micros personal web server/web manager via start/programs, the page where I click 'start' does not appear.
I can't get it to run. what has happened and how to rectify it. i am under huge pressure to get something done by the end of today and desperate to sort this out asap.
I have a folder with eight or ten files that can be displayed in a browser. I need to display the file with the latest creation date. I imagine there is some kind of ASP function that could like at the filename's date and pick the file that meets the criteria. How can I do this?
View Replies View RelatedI am trying to come up with a select statement which would select info from the latest 5 dates. I know how to do the latest date using
SELECT * from table1 WHERE PDate = (Select Max(PDate)
Is there an easy way to write a select statement to give the latest 5 dates? My data is in a SQL Server database.
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
Is asp.net similar to vb.net ? What can you create with it ? ,Is there a program you suggest me to use , or even a compiler ?
View Replies View RelatedI need to know where I can get information about learning how to code in ASP. This getting cide snippets and such doesn't work out real well if you don't know what to configure. Also I would like to have my own work not someone elses.
View Replies View RelatedIn different examples I've seen different ways to do the same thing, and I want to know what is best (fastest, easiest to remember, same command for all types of stuff, etc)
For example, to get data from a database, should I use:
[VBS]set rs = conn.execute sqlstmt[/VBS]
or
[VBS]rs.Open sqlstmt, conn[/VBS]
or something else?
what can i use to get my server's ASP information, like with PHP you can use:
PHP Code:
<? phpinfo(); ?>
What can i use in ASP?
I have a form that I use a few option selections from DB table and a insert script at the end.I'd like to have access to aditional info from the same table after choose an option
View Replies View RelatedI am trying to retrieve data from a dropdown listbox in asp using:
<%Response.Write + Request.Form("cboBox")%>
The problem is that I only retrieve the first value of the option. For
example, if my first option was <option value=this that>, I only can
retrieve "this". It won't get the second word.
Recently, I came across a site with information to my area of knowledge. The pages have been designed and consist of the .asp extension in the url.
I'm not able to select the text on the web page, either click right mouse button or anything to copy the information. when I'm trying to print it is not perfect.
So, I would like to know from ASP guru's whether there is any way of saving the information on the web pages, so that the same can be formatted in a word document for printing purpose.
My web site is windows authenticated.
When someone connect to my site, I get his SID with a small active X object
which uses OpenProcessToken and GetTokenInformation (token user etc ...
But now, I also need the SID list from AD user object SIDHistory. (when a
user is moved across domain).
I've got a WYSIWYG editor, that runs off a template page (i.e. template.htm) that gets opened in an iFrame for editing.
How can I get it setup so I cange the template at the click of a button? I've tried doing a form with radio buttons, but can't get it to work.
For example, the iframe source has been set to "strTemplate". My form processing was along the lines of:
<%
If request.form "template" = "template1" then
strTemplate = "template1.htm"
Else
strTemplate = "template.htm"
If request.form "template" = "template2" then
strTemplate = "template2.htm"
Else
strTemplate = "template.htm"
End If
End If
%>
Anyone have anything like this? I don't care what data it is... I just want
to see how to query the AD and place the data into a web page.
Basically I want to be able to send users (if they sign up to it) an SMS alert whenever someone leaves them a message on a webpage. Similar to Hotmail where you can get an SMS when you receive an email, or Ebay where you can get alerts if you are outbid.
I'm thinking maybe something very similar to CDO in terms of coding Code:
im running an asp page where by i can upload a xls file- which adds data to a database provided it passed validation. this then sends a success message to the user. what i need is a button where i can call the data which was recently added into the database- but dont know how to go about it or code.
View Replies View RelatedI am using :
<% FOR EACH field IN size_info.FIELDS
Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>")
NEXT%>
to loop the names of the fields in a DB, but I cannot get it so that is the value of the data in that field is lower than 5 it simply doesn't show, i thought i might be this
<% FOR EACH field IN size_info.FIELDS
if size_info.fields.name.value > 0 then
Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>")
end if
NEXT%>
but that doesn't work.
Is this the right forum for this. Considering using this but not sure, specially considering the price and I would need to add a host. If you have any knowledge please let me know. Also if this the right forum, also let me know and I will give more details. It is an ASP program of course.
View Replies View RelatedCurrently I have one asp page which opens after the proper ID entered by user and it generate <A> tag with application software download link. When the user click on the link (which is pointed to the actual physical file.EXE of Size around 10 - 20 MB) it downloads file. But how do i change the logic so that the activity will get LOG in some text file. Like which user has downloaded which file. (it should log into text file).
I think I need to remove the <A> for direct download instead it shoudl call an asp page whcih should log the event and push the file to user.suggest with sample code if possible.
How can I get ASP and IIS version info?
View Replies View RelatedWhen you hover over one of the topic in this forum a box appear with the first few lines of the message in it. How is this created. What events area used to creat something similar and does anyone know of any good website where i can look at a tutorial for it.
I dont even know what they are called so dont know what to search for even on the web as if i write pop up i get something else which i dont think is what i really want to use, or maybe it is.
I am working on a users system for my site. I have the databases and most of the pages set up. But, I need to create a page called "My Info". This page would display only the information of the person that is logged in.
I am curious as to how I would retrieve only one entry in an access database and display it based on the person logged in.
anyone know how to update the inforation in a select box without refreshing the page or using massive javascript arrays using regular asp(not .net)?
View Replies View RelatedI have an intranet site hosted in IIS 5.0 Win2000, and want to display the name of the user logged into the local machines(WinXP) in the pages they access like 'Welcome JohniBravo'.
So, i used the Request.ServerVariables("LOGON_USER"), but get a blank ("") displayed in the page. And i even tried "REMOTE_USER" but, still the same. from somewhere i got to know that theres something called 'Allow anonymous user' should be enabled to get these info from servers. help me with the same?
i have the users logging in from a database that part works. what i want to do is pull the users information from the data base to the page....
example
John Doe logs in pulls only john does info
marry logs in pull only marry info .
if there is a way of verifying information that is in the registry of the user's computer? Or is there a way of checking if a file is on the c: of the user's computer??
I want to make a certain verification of who is entering my website.
but the IP address is never the same (since it is randomly given to the user) and I can't use the LOGON_USER variable because the users are not all in the same domain. And cookies are too easily destroyed with the IE options.
I never had this happen. When i display my database into a table it displays fine. But if i change the order of the columns some of them won't display. No error codes at all.
i'm using a SQL DB with char, text and datetime fields. What can be wrong?
Currently I have a list of products in a drop down list. not very informative or easy to browse.
browse to check4add.asp at http://www.flowersdirectory.co.uk
I want to be able to open a pop up where the customer can browse the additional products and pass the variable to the parent pages form variables.