H
Heather
Hi
I have been struggling with this problem for days now and not really
getting anywhere. I am new to this so apologies for bad coding etc.
I have a form where the student enters his enrolment number and this
number is passed from the asp form to a SQL database. So far so good.
Now when he doesnt have an enrolment number he writes his name. Now,
I want to pass the enrolment number as 0, that bit is working ok, and
pass the name into a special field called s1.
My code is passing too much. It passes the enrolment number as 0, the
name as s1 but also sends the "click here to continue" text.
Here is a snippet of the code. I feel that I am putting in too
many/leaving out quote marks.
I would be grateful for any help.
Many thanks
Heather
dim var
dim choice
dim stname
dim stcoursecode
dim stcoursename
dim enrol
dim stdob
stdob = request.form("stdob")
enrol = request.form("enrolment")
choice = request.form("stchoice")
stname = request.form("stName")
stcoursecode = request.form("stcoursecode")
stcoursename = request.form("stcoursename")
var = request.form("stlevel")%>
<% if var = "1" then
Response.Write "<a href= ""http://perception/q/open.dll?NAME="
&Recordset1("enrolment") & "&SESSION=7234121865394181" & "s1="
&Recordset1("stName") & ">" & "Please click here to continue" & "</a>"
else
if var = "2" then
Response.Write "<a href= ""http://perception/q/open.dll?NAME="
&Recordset1("enrolment") & "&SESSION=9952819590936663" & "s1="
&Recordset1("stName") & ">" & "Please click here to continue" & "</a>"
else
if var = "3" then
Response.Write "<a href= ""http://perception/q/open.dll?NAME="
&Recordset1("enrolment") & "&SESSION=6083780287200261" & "s1="
&Recordset1("stName") & ">" & "Please click here to continue" & "</a>"
end if
end if
end if %>
</strong> </font> </p>
</form>
I have been struggling with this problem for days now and not really
getting anywhere. I am new to this so apologies for bad coding etc.
I have a form where the student enters his enrolment number and this
number is passed from the asp form to a SQL database. So far so good.
Now when he doesnt have an enrolment number he writes his name. Now,
I want to pass the enrolment number as 0, that bit is working ok, and
pass the name into a special field called s1.
My code is passing too much. It passes the enrolment number as 0, the
name as s1 but also sends the "click here to continue" text.
Here is a snippet of the code. I feel that I am putting in too
many/leaving out quote marks.
I would be grateful for any help.
Many thanks
Heather
dim var
dim choice
dim stname
dim stcoursecode
dim stcoursename
dim enrol
dim stdob
stdob = request.form("stdob")
enrol = request.form("enrolment")
choice = request.form("stchoice")
stname = request.form("stName")
stcoursecode = request.form("stcoursecode")
stcoursename = request.form("stcoursename")
var = request.form("stlevel")%>
<% if var = "1" then
Response.Write "<a href= ""http://perception/q/open.dll?NAME="
&Recordset1("enrolment") & "&SESSION=7234121865394181" & "s1="
&Recordset1("stName") & ">" & "Please click here to continue" & "</a>"
else
if var = "2" then
Response.Write "<a href= ""http://perception/q/open.dll?NAME="
&Recordset1("enrolment") & "&SESSION=9952819590936663" & "s1="
&Recordset1("stName") & ">" & "Please click here to continue" & "</a>"
else
if var = "3" then
Response.Write "<a href= ""http://perception/q/open.dll?NAME="
&Recordset1("enrolment") & "&SESSION=6083780287200261" & "s1="
&Recordset1("stName") & ">" & "Please click here to continue" & "</a>"
end if
end if
end if %>
</strong> </font> </p>
</form>