.asp search

consider a .asp file on the net.here i have to enter a number (say rollnumber) and then it give me the results related to that number.
e.g- i give some exam QWERTY and my roll number is 12345. so when results for the exam are announced i go to the site and open the corresponding .asp(say result.asp). i enter my nnumber 12345 and press enter. now it will show my name and my score in QWERYTY exam.
here's my question: is there any way i can search for a name (say Sam) and get all other information related to Sam (his score and roll number etc)???
any answers??

Well,

I sounds as if you have a database file with the rollnumber as the unique primary key field. You run a parameterised query that pulls the record with the unique roll number that you enter.

The simple answer is to write another query with the "name" field as the entry/search parameter. Depending on the size of the databse it might work more efficiently if you defined name as a secondary key.

Remember that people can have the same name, so the field cannot be a unique key, and that your query may pull more than one record as a result.

:)

i appreciat ur concern to answer but if you check the site www.cbseresults.nic.in and select 'results for XII standard' link, you'll know what i mean. you will have no choice but to enter the roll number. what do i do in that case?? isn't there a program that can be made so that it tries every rollnumber and displays the result which contans the required result????

Well from what I can see the website just serves you a form to run a query somewhere over a database somewhere.

Unless you have access to that database and the query writing tool you cannot do what you are suggesting.

The database seems to accept 7 characters so 9,999,999 possibilities exist, even more if you include alphabetic characters. So looking them up individually is out of the question :)

The answer has to be "no" without a copy of the database.

:)

ok
what if i know the range in which the roll numbers are assigned? that will reduce the number of possibilities.

CAN YOU PLEASE HELP ME IN MAKING THE PROGRAM IN MENTIONED ABOVE???

I THINK IT WILL BE GOOD LESSON

OK,

My first comment is that before you embark upon a project you should prepare a plan. Now in this case the big question has to be volume or scale?

So:

1. What is the range of numbers? (size of task)
2. What computer hardware do you have? (processing capacity)

Log into the internet, connect to the site and to the screen where you enter the roll number. Then enter your roll number...

Now have a watch to hand, and count from the time that you hit enter to the time you get the answer on your screen. (transaction response time) Please tell me what that is.

I must point out that what I think you are contemplating IS NOT A GOOD IDEA

When a systems administrator sees multiple hits from the same ISP address his system should alert him? Now, a teacher may make 30 requests..............the head of school maybe 300 requests...........when it gets to 10,000 requests that is when YOU will start to have problems?

PLEASE GIVE THAT SOME THOUGHT

:)

ok
fine i give up
i think it will be taken as DOS attack and i'll be in deep trouble
THANKS AGAIN FOR YOUR CONCERN :-)

by the way it took 2.54 seconds for my result to appear

Hi elfguy

I know what is going on. You are at a boarding school and are now home? You want to know what your school pals scored?

Now I am sure that this information is published in newspapers all over India? but obviously not in one place? so I would not consider it "classified" or even "confidential"................?

I do not know how to access a source database, for what you want, but I am sure they must be available. Please try the newspaper in the town where your school is located.

Your 2,54 seconds is horrific! :eek: and that was my point about planning. Say at the outside, it takes the .54 to resolve to the screen, that still leaves you 30 minutes per 1,000 records, saving straight to file?..........

Good luck, but don't bite the hand UNTIL it has fed you :D

And fellow members, please stop negging this guy...............I played to my gut intuition and won?

:D ....................and it is July 4th. so you are all too drunk to have an opinion?

Have a good one!

hi nihil,
thankx 4 understanding my problem

correction: time taken was 2.52 and not 2,52

so are you saying that it wont be illegal???

i think if i use a broadband i can reduce the time.

even if i am not able to accomplish my mission can you suggest how i should go about making the program i described. it could come in handy some day and you will have a new and kewl program to ur credit.
i'll be greatfull

Hi elfguy, not sure with cbse but icse had a feature that displays the results of whole school and only that school has the special roll number that displays the result for whole school.
You can ask your school principal if he/she allows to have a copy of that.

Referring to this thread
Can you please tell us why did you used two handles for asking same question... just for information ;)



- :S:

Hey elfguy

This is a pan-global site?......................

Quote:

---

so are you saying that it wont be illegal???

---

I cannot comment upon what is legal in your country, and it would be wrong of me to speculate? You will need advice from one of your fellow Indian members.

What I will say is that if you attempt such a thing YOU RISK BIG TROUBLE I would advise against it.............SERIOUSLY

Say I were to write you a program that were to do what you think (it would not be difficult, they are already out there on the internet :) and I have written loads of automation scripts as have many on this site) it would put a sudden and sustained demand on the host system? That would stand out and would ALMOST CERTAINLY be interpreted as an attack.

The mere fact that you use broadband disguises or does nothing. A lot depends on the speed of the responding site...................................and a monitoring system is looking for number of connections from a location? not their speed.

Yes, you spotted my typographic error..................I did mean 2.52 seconds.............I was very warmed by that ................2,54....................you must have thought that I meant a lakh? :D

Yes you are right again, I am afraid that it would be misinterpreted as a DoS attack.

I am afraid that in your situation I would use my contacts and get a copy of the database.....it is not confidential, only consolidated?

I am certain that you are NOT malicious..............your questions are all wrong for someone like that

But PLEASE BE CAREFUL

:D

I MUST SAY I REALLY APPRECIATE YOUR CONCERN FOR A NEWBIE.

THANKX FOR THE PRECIOUS ADVISE

NOTE:This is for all you gentlemen who think I am trying to hack into the site I mentioned to get Information.THAT IS NOT TRUE. If you gentlemen happen to open that site you will notice that there is no password required and no personal data has been displayed on the site (except for name).

dear singh bhajji
sat-sri-akal
tuhadi gal tan sahi hai. par mera dost koi hor school wich pad da see te aude nal mera koi contact hai ni.

menu tuhada khanda janga lageya. kithon leya???

Hi, elfguy

I wonder if there might be a simple solution?

How many records are you interested in? If it is only a few (your classmates) then why not use the enquiry system, and your roll number as the seed?

For example, if you are 12345, enter 12346 and see who you get? It should be another member of your class, as I am sure that the numbers were issued in blocks. Then just go up and down until you have all the results.

Tell me what version of Microsoft Office you have access to and I will show you how to design and build a database from the information you have gathered.

Then we can look at database manipulation and updating/population.

I am afraid that I misunderstood your original question because examination results are a favourite example in database analysis/design/manipulation courses. I actually thought it was some homework you were doing :D

For those who missed the subtlety: the comma "," in the Indian enumeration system represents a "lakh", or 100,000 (one hundred thousand) so my typographic error of "2,52 seconds" implied 252,000 seconds..................even my ISP can manage slightly better than that :D

Cheers

wow are u saying there is a way??? :)
i have MS Office 2003 and Ms office XP

what do i do???

i at want about 30-40 results (my class). you are right about the pattern of assigning rollnumbers

OK that is simple, just enter the numbers above and below you until you do not recognise that person, and write the information down.

We can then create an Access database and enter them............OK you can probably do most of what you want in Excel, but that will not teach you about relational databases :D

It is not worth trying to automate the process for that number of records, and you will just look like a teacher, so will not create any trouble for yourself.

Cheers :)

whats the fun in that??

thats excatly what i had to do ultimately

see my primary aim was to learn some practical programming.

"

Quote:

---

whats the fun in that??

---

Information Technology is not about "fun", it is about providing simple, cost effective solutions.

;)