For More Rep Points
I have alot to learn!!! If i use the connection below, after i have done my select statement, how do i make a statment to say, if the results are null then write....postcode dissallowed else go on.. Code:
dim post_code
dim pcservice
pcservice = service
post_code = left(Request.Form("postcode"), 4)
connDB.open
Set rsPC = Server.CreateObject("ADODB.Recordset")
rsPC.open "SELECT *, PDA_PD_SER_TAG AS servicetag, PDA_AREA AS area FROM tblPostcode_Disallowed_Area WHERE (PDA_PD_SER_TAG = '" & service & "') AND (PDA_AREA = '" & post_code & "')" connDB, 1, 2 ...
View Replies
let's say there will be 4 files for 2 questions. Qn1.asp Q2.asp Check1.asp Check2.asp
Check1.asp consist of the codes below to check Q1.asp and Check2.asp is to check Q2.asp
What do i need to put in the "" in both check1.asp and check2.asp so that if the user answer both the qn correctly it will 2 out of 2.. both wrong 0 out of 2 and so on.. I want the points to be stored inside a database.. Code:
View Replies
View Related
I remember seeing a post with a link to a ranking of members rep points, but I can't find it again. Is it still available? Can anyone post the link or maybe alter the User CP or members pages to include a permanent link? Or have a sticky post?
View Replies
View Related
there will be 4 files for 2 questions. Qn1.asp Q2.asp Check1.asp Check2.asp
Check1.asp consist of the codes below to check Q1.asp and Check2.asp is to check Q2.asp
What do i need to put in the "" in both check1.asp and check2.asp so that if the user answer both the qn correctly it will 2 out of 2.. both wrong 0 out of 2 and so on.. I want the points to be stored inside a database..
<%
r1=Trim(request.form("r1"))
r2=Trim(request.form("r2"))
r3=Trim(request.form("r3"))
I=Trim(request.form("I"))
urans=Trim(request.form("Answer1"))
result= Round(CLng(r3)*CLng(I)/(CLng(r2)+CLng(r3)))
if (CStr(result) = CStr(urans)) then
" "
elseif (CStr(result) <> CStr(urans)) then
" "
End if
%>
View Replies
View Related
I have to do several operations with values that i capture from textfields, but these values will be integer sometimes and float some other times. I use Cdbl(expression) to get them to double subtype, but i the input have to be in comas for it to work. Like 2,75 instead of 2.75, if the input is like 2.75 it will take 275 as the value..
Anyway I wrote a javascript that takes care of that, changes the textfield input for comas. The thing is, all of the people i tell this act stranged and tell me they have never needed to use comas instead of points, does anybody know why is this? Im affraid my code will not work on some browsers maybe?
View Replies
View Related
I have this situation:
each user has some amount of points, for example:
table:users
user_id --- user_name --- points
1 --- user1 --- 100
2 --- user2 --- 100
3 --- user3 --- 100
4 --- user4 --- 200
5 --- user5 --- 500
-------------------
total points: 1000
I want to generate random selection of user, according to their points respectively, so the more points he has, the more likely he will be selected:
user1 in 10% cases
user2 in 10% cases
user3 in 10% cases
user4 in 20% cases
user5 in 50% cases
this percentage is respective to their points; I put some rounded numbers in the example - so total points of 1000 equals 100% - but they can have any amount of points: 1, 200, 3672 etc.
View Replies
View Related
I have an ASP/SQL 7 application that rips data from SQL Views onto an ASP
page. I have a money column in a SQL table that contains money income values.
When data is input to this field it needs to be displayed as money (to 2
decimal places - 10.00 or 7.60)
However, this only seems to be occurring when the user puts in the extra 0,
and if 7.6 is entered, it is still displayed as 7.6
I need all data to be displayed as money values (and it is selected as money
in SQL), so is there any way (either in the table design, View design, or
display on the ASP page) to get the data to 2 decimal places, no matter
what?
View Replies
View Related
I try to debug ASP aplication. I use Visual InterDev 6.0 and Windows
server 2003,but Visual InterDev Debugger Skips Server-Side Break Points. I read thisbug was in asp.dll version 4.02.0622 (WIN NT), but why doesn't it work on WINserver 2003
View Replies
View Related
