Hi
I can't seem to get this working, if anyone has any idea..
I need to do the following:
if str = "" or str = "" or str = "" then
print this table saying - please complete form
else
set up the connection and retrieve all data where NI = NI or UN = UN or PW = PW OR Email = Email
if no records found then user not in db so submit to db
else if records found then (check individually for which record has been found)
if NI = rsNI then
print this table saying you are already registered
else if UN = rsUN then
print this table saying enter a different UN
else if PW = rsPW then
print this table saying enter a different PW
else if Email = rsEmail then
print this table saying email already in use
<%end if%>
<%end if%>
Should I use a select case here? Confused.
Thanks Lee
I can't seem to get this working, if anyone has any idea..
I need to do the following:
if str = "" or str = "" or str = "" then
print this table saying - please complete form
else
set up the connection and retrieve all data where NI = NI or UN = UN or PW = PW OR Email = Email
if no records found then user not in db so submit to db
else if records found then (check individually for which record has been found)
if NI = rsNI then
print this table saying you are already registered
else if UN = rsUN then
print this table saying enter a different UN
else if PW = rsPW then
print this table saying enter a different PW
else if Email = rsEmail then
print this table saying email already in use
<%end if%>
<%end if%>
Should I use a select case here? Confused.
Thanks Lee