I have an articles_tbl . How do i create a select statement which only brings back the latest 3 records added to this table (the database has a field called 'date_added') so the information of when they were added is present.
I was just wondering how to bring back only THREE records and showing them, instead of bringing back the entire table content and then showing three out of them..
i am designing a search engine, you select the search options from five choices in a drop down box, each option reveals a table, but the tables have fixed positions on the html page.
i need it so that if only one option is picked to search and it is the last option on the drop down list, that it will appear at the top of the page? i dont have a clue what type of function to write to do this or what techniques will be involved!
The following code should select the specified number of records randomly from the database .....
View Replies View RelatedI want to know the number of records in my database when performing a query by sql. I am getting -1 as number of records.
<%
connectme="DSN=hotel"
sqltemp="SELECT Count([All Rooms].Engaged) AS CountOfFREEROOM FROM [All Rooms] GROUP BY [All Rooms].Engaged HAVING ((([All Rooms].Engaged)=False));"
set rstemp=Server.CreateObject("adodb.Recordset")
rstemp.open sqltemp, connectme, adopenstatic
howmanyrecs=rstemp.recordcount
response.write howmanyrecs & " records in<br>" & sqltemp
rstemp.close
set rstemp=nothing
%>
my project is on an online hotel reservation. I want to have the number of rooms available each time the page loads.
I want to select the bottom 25 of records in my table. How would I do this?
View Replies View Relatedi want to select some records from my database by random. i want also to set a limit (limit=9).
View Replies View RelatedI want to select multiple records using the WHERE function. Currently my SQL query is as below:-
strSQL = "SELECT albums.* FROM albums WHERE id = 1"
As well as selecting id = 1, I would like to select id = 2 and id = 3 . How can I write this? I have tried seperating it by commas and spaces but this didn't work.
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 RelatedI have a tough question that i ca't get over it for all the day.
I have two different news tables. I can't get any of them and list.
Bu i want to do something different. I want to get both and randomize them and list them.
for example,
1. news (from the 1st db)
2. news (from the 2nd db)
etc.
is that possible, because i couln't find any solution for this.
I am having trouble coming up with the correct SELECT statement to use when I only want to select the records from a certain month. In this case, the current month. In my database all the date records are in this format:
MM/DD/YYYY HH:MMAM
I figured out what "this" month is by doing the following:
thisMonth = split(now, "/")
so thisMonth(0) will give me the numerical value for this month. In todays case, its 9.
I am then trying to select all records from my database that have their date field starting with the number 9. Here's what I'm trying:
"select hitDate from hits where hitDate like '%" & thismonth(0) & "/%/2003%' order by hitDate"
But this is not working. It keeps returning 0 results. Anyone know what i'm doing wrong, or better yet, a proper way to do what I'm trying to do?
Any build in function that can calculate number of records in a table?
View Replies View RelatedI have a results page which retrieves a number. I am using "Repeat record" to get a list of all the number records of the database.
I would like to make a sum of all these records at the end of the result page.
record1 = 100 (repeat region)
record2 = 500
record3 = 100
and then, how can I make a sum of these records?
Total = 700
how to query data which spesific the number of record from 'start' to the 'end'?let say i have 20 records,then i only wanto to query record from row number 10th to 16th like that.
View Replies View RelatedI was wondering if you could help me with the following problem. I have 2 listboxes in my
webpage, 1 has cities, and the other lists the streets of the city from the first listbox.
When I click on a city, I want the 2nd listbox to populate with all streets in the city. The city and streets are saved in a database, so when the user selects the city, I will run a query on the database and populate the 2nd listbox with all streets.
How can I do this with normal ASP? I know how to do this with ASP.NET, but don't know how to activate this with normal ASP?
I just want to return the number of records in a database:
<%
Set cn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT COUNT(*) FROM alumni_baby"
cn.Open ("dsn=mssql;database=web;uid=aaa;pwd=aaa;")
rs.Open sql, cn
%>
<% Response.Write (sql) %>
But that spits out the sql statement, not a number. What am I doing wrong?
how do I display only n number of records? then create links to the next set of n?
View Replies View Relatedhow can i get a total number of filtered records? what's the code?
View Replies View RelatedI have built and app where people can add records to a database the problem is while the next page is loading some people are impatient and click refresh adding another same record with slightly different time stamp.
Is there anyway to limit the number of records insterted to my SQL database from my asp pages to one.
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
i need to go through a list of items and check to see if items on list 1 are on list 2 and vise-versa. so im going to look at item 1 on list 1, and go through all the items on list 2. if i find a match, ill update the record on list 1, if i dont find a match ill update the record on list 2.
im going to need a nested loop. in c++ i know how i could do this, but im not sure as how to do it in vbs/asp. can you do for each "record" in "myrecordset"? or do i have to get the number of records in the table and run the loop that many times? which would be eaister?
I'm trying to set up a "simple" page to display six items at a time in a 2 col x 3 row grid I've succeeded in doing this and displaying all the records but am struggling to only display six at a time I've searched on recordset paging and no one seems to cover this sort of problem Anyone any ideas? Code:
View Replies View RelatedI'm trying to specify how many records to be display per page. I put a limit of 40 records and i'm getting only 2 per page. The number of pages it seems ok but the records displayed are only 2 instead of 40. Code:
View Replies View Relatedhow can i Count and display number of records in table?
View Replies View RelatedHow do I show a double with 2 decimal places in vbscript? Also is there a way to show a string that is holding a number with two decimal places or does it need to be converted to doulbe first and then converted back to string after manipulating the double?
View Replies View RelatedI am a C#-Coder and now I have the duty to rewrite a ASP-Website and add some functionality. The problem is that I have never seen ASP before and I don't have the time to learn everything necessary to complete my work.
It's a very simple problem and would be really great if someone could tell me what to do or show me a small code-example. I think "learning by reading code" is the best way to get new information
I have an ASP-Website with a very long list (out of a SQL-Query). If I scroll down the page I can't see the list-header any more <- THATs my problem. What I need is an ASP-Website with a fixed section that can't be moved and below a common, scrollable website.
The header of my SQL-Query should be in this fixed section and the datasets should be in the scrollable section.
I have variable, say "total". It can be an integer or floating number.
No matter what value it stores (5 or 5.1 or 5.24), when I display it, is
there a way I can make it display it with fixed 2 decimal digits, like 5.00?
I posted a similar problem a while ago but never found a solution. I am passing an integer value (called NoElements)from a html form (which gets created using javascript) to an asp page. The value of NoElements is used to create an asp array of that size. At first I was confronted with the following error:
Expected integer constant
I then was advised to initialise the array (to say 100) and then do a ReDim Preserve. I now get this error message:
This array is fixed or temporarily locked? What should (or at least I thought) be a simple porcedure is making my life a nightmare.
i'm getting an instance of a form field value being cut off when input into a MS SQL db. i can't figure out where it's doing it. the field datatype is set to VARCHAR with a size of 100. the data is being cut at 30 characters. here is the form field: Code:
View Replies View Relatedi got this error when trying to looping through an array
Quote: Microsoft VBScript runtime error '800a000a'
This array is fixed or temporarily locked
Here are my code:
i know how to create text files using ASP, but is there any way to create fixed width text file using ASP? i need to have the data lined up in the same location at each row.
View Replies View RelatedI have a DB that contains several columns named Line1, Line2, Line3, and Line4. After that I there are 50 columns named Data0 through Data49. Data0 and Data1 will always contain text but Data2 through Data49 may or may not be empty.
I am trying to take the values out of the database and put them into arrays. Since Line1 through Line4 never change I have no problem getting them into one array but I am lost on the logic/syntax on how to not only determine how many Data(n) cells are populated but then how to get them into a new array.
How would one extract the number of (days) from (today) and a (future fixed
date)- eg: February 12, 2003. ....where today will always be Date().
Thus:
02/12/04 - Date(now) = 27 days.
Can anyone help me here?
username2 = Request.Cookies("wo_username")
sql = "SELECT * FROM customer WHERE customer.username = " & username2
is there anything wrong with this ?