Im trying to match a list of numbers like this :
if num in (1,2,5,6,8,9) then 'matching any of the number in the list
action
end if
This syntax is wrong, can someone tell me the correct syntex or izzit possible to do something like this using vbscript?
I have an ASP site that allows the user to submit an
Employee Number to an Oracle procedure. The procedure
does some calculations and the results are displayed in
the browser.
Now, the user would like the ability to submit any number
of employee numbers all at once (though not display the
results).
I think this can be done, but I'm not entirely sure how to
go about it? I think the way to approach this would be to
get a comma separeated list if employee numbers and
convert it into and array using SPLIT, and then churn
through the array and pass each record to the Oracle
procedure.
So my question is, how do I get the comma separated list
into ASP? There could be as many as 6000+ entries in the
list.
i have date field in my database table containing date & time value. i want to display records according to system date.
database table name : products
field in database table : pdate
i ahd tried following:
dt = Date
tm = Time
pd = dt & " " & tm
SQL:
select * from products where pdate = #"&pd&"#
u is not working. it gives me syntax error in date.
i had tried all the options like #'pd'#, # " & pd & "# and many more.
I have a search page which has radio buttons for two search options (location, price) and checkboxes for one other option (type). The radio buttons reference the "general" table in my database, and the checkboxes reference boolean records in the "cuisine" table.
My task is to display, on a subsequent page, records that match the two radio buttons selected as well as each checkbox. Code:
I am having 2 problems in asp.
1. I want a form field which retrieve data from Sql database and when button pressed, it should open a pop-up window with a form-text-field and data must present in this text field.
2. I have a database with 4 tables named myname, urname, hername, hisname. What I want is to retrieve data of table-myname into a page and then retrieve those data of other tables which may match the data of table-myname; into same page.
As if table-myname have data like John with code-01 and then these 3 tables must show those codes which are having data like John.
I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.
The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:
I have a page that calls itself using a form. The form has two select elements. In the sql statement I am attempting to match the values of the select element to populate a recordset.
The two fields in teh Access db are of type Text and of type Integer. What baffles me is that one sql statement works fine and the other returns nothing. I am having the issue matching on the bedrooms.
In the first statement I took out all other doo-doo and just matched bedrooms = request("bedrooms"). On the other one I used p.bedrooms but it keeps turning up empty. Code:
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.
How can i list out all the email address into my website from the hotmail caontact list? i am successful log in into the yahoo contact list by using serverxmlhttp and list out all the email address from the page source, but i could not access to hotmail by using the serverxmlhttp. Is any other methos can list out the email address from hotmail contact list?
View Replies View RelatedJust 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
how can i check if a variable is an even number
View Replies View Relatedi want to add two numbers in server script with VB script. how to do it.
View Replies View RelatedI 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?
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?
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>")
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 RelatedI 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.
how to add two numbers from two different textboxes and display it in the third box.
View Replies View RelatedI 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
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
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?
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)
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!
I am trying to generate a random number between 1 and 100 into a label, using c#....
View Replies View RelatedIn 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?
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.
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 Relatedi 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?
How do i make this number shorter?like 65.3846153846154%.how to make it like.let's say 65.39?
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 RelatedI'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?
I'm trying to do a query selecting records the have a number 4, 5, 6, or 7. If I change the datatype to text the statement works. Anyone know why the statement won't query a number?
View Replies View RelatedIs there a way to add numbers (currency) of the one column which is queried with sql from access database?I mean some asp tag or something, or I must use javascript?
View Replies View Related