I 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'm trying to display all the jobs that occur during a selected month/s. Here is the code I use: Code:
View Replies View Relatedwhile I store the dates as is in db, I can use a select statement like this:
mySQL="SELECT SUM(total) AS totalSum, month(orderdate) AS monthsql FROM orderDetails GROUP BY MONTH(orderdate)"
but when I use dates as integer, it simply gives me error. Are there any way of getting over that problem?
I am trying to write a SELECT query in ASP to retrieve information from two databases (that must be kept seperate :-().
I have managed it using Access using something similar to the code included below, which I have modified for ASP. Looking around this seems to not be possible in ASP, instead the general recommendation is to link tables??? I would prefer to do it using ASP. Code:
I have a line of code in my script that looks like this:
Set User = objDBCon.Execute("SELECT * FROM tblsUsers WHERE ID = '" & request.form("user") & "'")
This gives me an error of data type not the same. Anyone know what the problem might be?
-Dim cmd As OleDbCommand
-cmd = New OleDbCommand("select * from qmsstats where firstname='jason'",
OleDbConnection1)
-OleDbDataAdapter2.SelectCommand = cmd
-DataGrid1.Visible = True
-OleDbDataAdapter2.Fill(DsQmsStats1)
-DataGrid1.DataBind()
In the above example I need to change 'jason' to a variable. I need the variable to be pulled from a textbox. IE: txtusername.text. Please advise how I can get the value from txtusername.text in place of 'jason'.
i want to display data which is in access database and one date field, i want to show a data from date1 to from date 2.
View Replies View RelatedI 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 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 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'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
%>
I have a list box which has the following values:
Car
bike and Boat
If I select "car" it is fine but when I select "bike and boat" it just takes bike
as the selection. It is taking the space as the end of the string. Is there a way I can
rectify this?
My boss wanted me to add a dropdown to this form. I was able to add in the dropdown and it inserts into my database (Access) just fine. However, I have an edit page also and this is where my trouble comes in.
On the edit page, the dropdown does not "know" which specific option was selected. I tried to write an If statement but I think there is something wrong in my syntax. Code:
I have undertaken a website revision project after not programming for about 6 years. I am beginning to set up a work environment on my pc, and have questions about the software being used verses what could be the ideal software.
I am familiar with classic asp pages, not asp.net. I am also familiar MS Interdev (but am unable to locate my copy and cannot find a torrent file - is this an archaic program now?). The last thing that I'll mentioned is that I prefer to have a debugging capabilities.So the current website uses Dreamweaver 8.0, IIS 6.0, and MSSQL 2000. Question.Given my background, what software would you use to set up a work station?
i need to display results that do not match those in the database.I have an excel file and i upload it,inserting the records in a temp table. han i compare the values in the original table and the temp table.All i want is the values that do not match
sql = "SELECT TempSerial.SerialNo "&_
"FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
"OrderBY TempSerial.SerialNo;"
Set RS = objConn.Execute(sql)
i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.
i need to extract some data from a table called accountantsBids. I want to select the last entry for every accountant based on the date descending.
Table:
entryid = Autonumber
Accountantid = FK
DatePosted
I've tried TOP 1 but that doesn't do it - it only gives one recordset. What would be the best way to get this working.
I have a database with date of gigs in it and am trying to select * from the database the next gig basically, and am compariung against todays date and saying select * more than todays date. Is this right, cause it's not doing it? Code:
dateN = Date()
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "************"
set recsetS= server.createobject("ADODB.Recordset")
sql = "select * from admin where dated > "& dateN &" order by relevance DESC "
recsetS.open sql,conn,3,3
I created a form for Deleting multiple records (from Access db )using checkboxes. However, I would like to add a link or button that would check mark all the checkboxes since I could have hundreds of records.
What is the best way to go about it. Does anyone knows of any samples other than Javascript.
I was wondering if anyone has a moment to look over some code I've written?
I'm involved in the maintenance of an old CMS system I wrote a number of years ago, when I was regularly coding in ASP. These days it takes a while to mobilise the grey matter when it comes to ASP.
Anyhow, basically I am trying to select a specific node and determine the id of the last child of the parent node.
At the moment, I am only returning the first childs id, despite my best efforts. Code:
On the online crm system i've built (using ASP) our customers can create a list of contacts and download/delete/add to this list when they want to and then go and view the list. It will display 20 on a page with forward/back buttons etc.
I have written a routine which queries the MS SQL 2000 database and retrieves all the IDs of the contacts. It will then work out the page it is on and display the appropriate records by reading through the 20 IDs for that page and query the data from each ID it needs to display on the screen.
This works fine for lists of up to 1000-2000 but when it gets to 5000, 10000 records it becomes an issue of performance as it will hold in a variable all of those 5000 or 10000 IDs. There has to be another way of doing this.
I want to select just one field to display using sql and I want to have another variable that counts how many fields of the same value there are. My code looks something like this but i'm getting an error...
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal. Code:
Is it possible to select random images from a directory without creating a "library"
As in I want to have a directory with 25 or so images and want to randomly select an image without having to change the txt document when I add new images.
This is my page that displays a certain players games played below. It sorts by games played and excludes all records that = 0. Now with 9 different grades to show i did not want 9 different pages, so i added in 'strSortGames' so that they can select which grade to view and only one page is needed.
I used a menu (list field) on a previous page to do this, do you no a better way to do this? e.g Text links or some other way? or is a list field a fairly good way? Code:
What query would I have to use to select entries from a database where there first letter is a letter of the alphabet? ie. Select all entries starting with an A etc.
View Replies View RelatedI need help programming a search function. I want to narrow down a search function regarding time. I figure the best way to do this is to select a higher interval and a lower interval, and then have an sql function that grabs the times from within that range.Code:
sql = "SELECT DISTINCT place, time FROM bussystem WHERE time >= '"&timey&"'"
Set rscurrent = Server.CreateObject("ADODB.Recordset")
rscurrent.Open sql, conn, 3, 3
sql = "SELECT DISTINCT place, time FROM bussystem WHERE time <= '"&timey&"'"
Set rsrecent = Server.CreateObject("ADODB.Recordset")
rsrecent.Open sql, conn, 3, 3
Is it possible to select all twelve months in one select query either from a single field name or through an alias name?
I have a field name that conatins dates, and I would like to arrange the value of each month in a grid, jan-dec, monday-saturday. can I accomplish this with one select statement using an access db?
I need Help in inserting the user image in my data base. but
unfortunatly I don't know how.I'm using asp with sql server. I tried to
insert the image and i geuss it worked.for the field in the db in not
null and it have this value <Binary> . but when i try to select it in
gives me this error "An unhandled data type was encountered".
this is my code :
hi there i need to display results that do not match those in the database. I have an excel file and i upload it, inserting the records in a temp table. Than i compare the values in the original table and the temp table. All i want is the values that do not match..i did this:Code:
sql = "SELECT TempSerial.SerialNo "&_
"FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
"OrderBY TempSerial.SerialNo;"
Set RS = objConn.Execute(sql)
i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.
I am trying to set up a component that will allow events that are date sensitive. From this date to that date. What I am trying to do is use drop down menus for selecting the dates, and I am having a hard time finding out how to build these drop downs so when someone is editing an event, the existing dates are pre-selected in the drop downs. But I need to seperate year, month and day for both and then have it change the value of the correct option to selected.What is the easiest way to do this?
View Replies View Related