with the results in the first table, i want the first table to check with the second table if there are identical fields(in this case the first field of the two tables is the same). if there the results are found true, say sumthing like "there is a record!", if false then, "no such record!".
is this possible? any help would be very much appreciated, thx in advance.
ok, currently i am doing my school project. the project is about an online booking system for users to book facilities from my school.
the purpose why i want to compare matching fields is for users to check whether they have bookings.
when they come to the school, they are required to scan their card and their user name and password is stored in a new database. the new database is then compared with the the other database(the database that stores the bookings made earlier).
if there are matches, then response.write "you have a booking!", else response.write "sorry, you do not have a booking."
what i am trying to do here is provide some sort of validation for the users and display the results on an ASP page.
' rs("name") is from the first table, pcrs("userName") is from the second.
if rs("name") = pcrs("userName") then
response.write "You have a booking!"
response.write "Sorry, you do not have a booking."
my lecturer then told me sumthin about compare strings.. it goes like..
if StrComp (AA,BB,1)=0 then
can i directly swap AA with rs("name") and BB with pcrs("userName")?
or do i need to perform CStr to convert them to string first?