Ordering Numbers?
i need to oredr a set of numbers. the numbers are "06/9","95/1","95/6","06/3" and so on. the thing is that these need to be ordered form the second number, so it shoudl be ordered thus: "95/1","06/3","95/6","06/9". how can i do this? at the moment just as an attempt im splitting the number either side of the "/" like this:
var regNo = "12/09"
var yearStart = 0
var yearEnd = regNo.indexOf("/")
var year = regNo.substring(yearStart, yearEnd)
var itemStart = regNo.indexOf("/") + 1
var itemEnd = regNo.length
var itemNo = regNo.substring(itemStart, itemEnd)
but where do i go form here?
View Replies
ADVERTISEMENT
what is an easy way to go about sorting my search results through links, you know, like clicking the link at the top of a column. i know how to pass the order by in a querystring:
http://www.example.com?lastname=smith&firstname=john&state=GA&orderlast=desc
where orderlast is the order querystring.
but what about all the other links? what do I do with the previous querystring entries like lastname, firstname, and state? i find if i add orderlast to my lastname column and i click on it, i will have 2 orderlast querystrings
View Replies
View Related
I have an ordering form w/c user can input their information It is about an online ordering of niche(for cremated) and user can select their NicheLevel(1-8) and their LotLocation(Lot1-Lot20).
I have a NicheLevel and NicheLocation in my DB table named CustomerInfo now i want to happen is: if the customer select their NicheLevel and LotLocation the DB validate the NicheLevel and LotLocation and if its already reserved it will not send to my DB and a
response message telling that it was already reserved. Im using ASP & JavaScript.
View Replies
View Related
I have a database with 3 fields in it ... photoname, price, job. I'm hoping to set up a drop down menu, which changes the "ORDER BY" part of the SQL query line, to one of those field names. That would enable a user to order the records (being served from an access database), by either name, price or job.
I know that it's got something to do with "request.form", but I don't know how to get the variable from the form to the SQL query. It would be 100% perfect, if the drop down menu automatically posted, when it was changed, so that it didn't need a submit button. But I think I might need to figure that out myself .
View Replies
View Related
I have an application that rips data from an SQL server and displays it in
columnar form on an ASP page, using a Do until RS.EOF loop.
I wish to add 2 arrows to each column (up and down) and when clicked, orders
the data on the page by that column (up - A-Z and down Z-A etc.....)
Is this possible in ASP or would i need some Javascript/Client side code to
do this?
The problem is the ASP SELECT statement orders the data initially, i just
need to know how the user can re-order the data after it is on the page?
View Replies
View Related
i have a price field that i want to order the prices from smallest to greatest
Set rsProducts = Server.CreateObject("ADODB.recordset")
SQLProducts = "SELECT * FROM tblProducts Where pr_Cat='" & Request.QueryString("Cat") & "' AND pr_SubCat1='" & rsSubcat1("pr_SubCat1") & "' AND pr_SubCat2='" & rsSubcat2("pr_SubCat2") & "' Order By pr_Price Desc"
rsProducts.open SQLProducts, Conn
thats what i have.but it prints out.
$899.00
$1975.00
$1655.00
$1425.00
Can anyone figure this out?
View Replies
View Related
Does anyone know of a good script that already exists to do the following? Allow a user to enter a sort orderIf the order exists replace the existing one with the new and bump the old up or down accordinglyIf it doesn't exist add as newMake sure there are no gaps in numbering.
View Replies
View Related
I'm working on asp project, access 2000 at backend.I can write arabic text and arabic
numbers in textbox and save them in database.but if i see these records, arabic text and arabic numbers,it is ok,if my computer is arabicenable.
If my computer is not arabic enable then it show arabic number into english numbers.
how can i show arabic numbers instead of english numbers if my computer is not arabic
enable.i'm working on a project i have to complete it.How can i convert english numbers that are coming from database and convert that numbers in arabic for show.
I have use
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
I shall be very thankful to you for this purpose.
View Replies
View Related
I've written an ASP page that pulls all records from a table. My query
is 'SELECT * FROM teacher ORDER by Class'
It is working fine... sorta. The table has about 20 records, but only
5 have an entry in the 'Class' field. The 15 records with the blank
class field show up first, then the other 5 records. Is it possible to
have the blank one show after the ones with an entry. Here's how my
results look, IOW. Code:
View Replies
View Related
I'm just wondering if there is ordering online software which has a feature to create a customised user environment (different product and prices for different user) for each login user? I really need that feature for one of my customer.
If it is not available could you please suggest a product that has this feature?
View Replies
View Related
We’re just wondering if there is an ordering online software which has a feature to create a customised user environment (different product and prices for different user) for each login user? We really need that feature for one of our customer.
If it is not available could you please suggest a product that has this feature?
View Replies
View Related
I'm just wondering if there is ordering online software which has a feature to create a customised user environment (different product and prices for different user) for each login user? I really need that feature for one of my customer.
If it is not available could you please suggest a product that has this feature?
View Replies
View Related
Just started learning ASP about ten minutes ago.
Currently experimenting with forms.
could someone please tell me what is wrong with this code:Code:
<%
Resonse.Write Request.Form("myform") + Request.Form("myform2") & "<br />"
%>
Im trying to get two numbers to add together from a form.
I get this error when i use that code:
Quote: Microsoft VBScript runtime error '800a01a8'
Object required: ''
/Jaynesh/asptest.asp, line 14
View Replies
View Related
how can i check if a variable is an even number
View Replies
View Related
i want to add two numbers in server script with VB script. how to do it.
View Replies
View Related
I Have this form in page1:
<form method="post" action="page2.asp">
<input type="checkbox" name="numb" value="10">
<input type="checkbox" name="numb" value="20">
<input type="checkbox" name="numb" value="30">
<input type="checkbox" name="numb" value="40">
</form>
Now what I want is to add the checked values in page2.
For example :
if checkbox1 and checkbox3 gets checked I want to add the values in the
checkboxes which in this case is 10 + 30 and get the total sum (40).
Hope this makes sense?
So how do I retrive the checked values and then add the checked values
with eachother to get the total?
View Replies
View Related
I am converting bites to Megabytes in an operation. How would I trim the result to only go to 2 decimal places?ex:
Response.Write(file.FileName & " (" & (file.Size/1048576) & "Mb)<BR>")
View Replies
View Related
i know how to code it in javascript but failed to do it in asp. there are 12 digits of number. exmple like this 871205106599. i want to check every single digit when user clicks Submit button.
View Replies
View Related
I want to round numbers to include a 0 at the end.
response.write "<td bgcolor=white align=center class=menuText>" & 100 - Round(CTASCAvail,2) & "%</td>"
response.write "<td bgcolor=white align=center class=menuText>" & 100 - Round(Avail,2) & "%</td>"
the following code will round the numbers 2 decimal places but if it is a 0 it will not display it.
View Replies
View Related
how to add two numbers from two different textboxes and display it in the third box.
View Replies
View Related
I believe this is possible using Regular Expressions (which I have never used), but I am unsure of any other way to do it.
Either method would be acceptable for me - I need to learn how to use Regular Expressions some day
How do you ensure that only numbers are entered into an input field.
I need to know this for things like postcodes, phone numbers etc. and a few other things and I've never come across an easy way to do it
View Replies
View Related
Can RSA encrypt a sequence of numbers and letters intermingled together.
I was told that RSA can only encrypt letters,i'm not so sure. So can it bge done
View Replies
View Related
I have 2 textboxes - "from" & "to".
Assume I enter number 1 in "from" and 10 in "to" - I want the ASP to return:
1,2,3,4,5,6,7,8,9,10 and insert this into an Access database over 10 rows
into the 'number' field.
Anyone got any ideas how to do this?
View Replies
View Related
regarding adding or getting sum all of the numbers in the database fields
example of the Fields:
Totay_Payment
10.00
20.00
30.00
40.00
My problem is i cant display the exact SUM of all numbers and it goes like this 10.0020.0030.0040.00 and i want the exact sum like this 100.00
heres the example of my script :
inTotalPayment = rsSumNumber("Total_Payment")
Do While Not rsSumNumber.EOF
intSum = intSum + intTotalPayment
rsSumNumber.MoveNext
Loop
Response.Write(intsum)
View Replies
View Related
I have a problem creating random numbers. I basically have this
Randomize()
iRandom = Int(10 * Rnd + 1)
If I do not wait a few sec before hitting the page again it will create the same random number as generated a few seconds before.Any idea why it is like that? Another way to reprocess the "bug" is to just fit F5 few times in a row and you end up with the same number being generated. Its annoying and I need some help to "fix" it!
View Replies
View Related
I am trying to generate a random number between 1 and 100 into a label, using c#....
View Replies
View Related
In our database I have various phone numbers, and they could start with 082
/ 083 / 084 / 072 / 073 / 074. How do I check any of these and change them
to 2782 / 2783 / 2784 / etc etc?
View Replies
View Related
I've got an ASP app. This app is deployed to two seperate Windows NT machines which I believed were the same. Unfortunately, the app works on one PC, but on the other I get some EOleExceptions from the COM object I use with the page.
Does anyone know how I can check versions numbers of things like what ASP engine I am running (if there is such thing), version numbers etc. etc.
I'm just looking for anyway of telling what the difference is between the two PC's.
P.s. I know this isn't really a 100% ASP based question, but I thought I would get a fast answer on the ASP board.
View Replies
View Related
The number '60' can be written as (50+10) or (25+35) or (15+45) or (7+53) etc... but I want the output as (50+10) only when 60 is typed in a textbox & the Form is submitted. How do I do this?
View Replies
View Related
i have the following equation:
<%
avg_score = total / count_match
%>
what can i do to restrict the result of avg_score to be of 2 decimal places?
View Replies
View Related
How do i make this number shorter?like 65.3846153846154%.how to make it like.let's say 65.39?
View Replies
View Related
I'm using asp, obviously, and mysql. My prices are using the decimal field type... what can I do to make it round up the the nearest 5?
View Replies
View Related
I'm using the follwoing code to retrieve some values from an Access database:
<%
Dim PageStr
PageStr=Request.Querystring("PageStr")
SQL="SELECT * FROM images WHERE page = '" & Replace(PageStr, "'", "''") & "'"
set conn = server.createobject("ADODB.Connection")
conn.open "ContentDBase"
set img=conn.execute(SQL)
%>
This works fine. However, I want to change the 'page' field from a string to a number (i want to filter by the primary key rather than the description), but using the existing code I'm told I have a 'type mismatch' or something. I'm guessing I need to modify the code slightly to deal witha number field as opposed to a text field?
View Replies
View Related