Abnormal End Of File

[George Fernett]

Hi all,

I have the following in an ASP script:

(note: "ccode" is a checkbox collection from a previous ASP script)



<%
dim choices, oCmd, oRS
set oConn = GetConnection()
choices = Request.Form("ccode")
choices = Split(choices, ",")

For Each member in choices
oCmd = "SELECT * FROM jsppf WHERE jspcde = '" & member & "'"
Set oRS = oConn.Execute(oCmd)
While Not oRS.eof 'EOF IS ON AFTER FIRST NAME
Response.Write("<span class=""head"">Course Code: " &
oRs.fields("jspcde") & "</span>")
Response.Write("<span class=""subhead"">— " &
oRs.fields("jspdsc") & "</span>")
oRS.movenext
Wend
Next
%>

"choices" contains NewYork,Trenton

If "choices" contains 1 name, this works fine
If "choices" contains more than 1 name, the first name works fine, but the
next one returns "oRS" as EndOfFile.

I am guessing that EOF is still on from the previous name, so how do I
"RESET" the EOF flag?

Any and all help is appreciated.

Happy Holidays!

George

[McKirahan]

"George Fernett" <georgef@njcf.org> wrote in message
news:upb9LcYyDHA.1272@TK2MSFTNGP12.phx.gbl...

> Hi all,
>
> I have the following in an ASP script:
>
> (note: "ccode" is a checkbox collection from a previous ASP script)
>
>
>
> <%
> dim choices, oCmd, oRS
> set oConn = GetConnection()
> choices = Request.Form("ccode")
> choices = Split(choices, ",")
>
> For Each member in choices
> oCmd = "SELECT * FROM jsppf WHERE jspcde = '" & member &

"'"

> Set oRS = oConn.Execute(oCmd)
> While Not oRS.eof 'EOF IS ON AFTER FIRST NAME
> Response.Write("<span class=""head"">Course Code: " &
> oRs.fields("jspcde") & "</span>")
> Response.Write("<span class=""subhead"">— " &
> oRs.fields("jspdsc") & "</span>")
> oRS.movenext
> Wend
> Next
> %>
>
> "choices" contains NewYork,Trenton
>
> If "choices" contains 1 name, this works fine
> If "choices" contains more than 1 name, the first name works fine, but the
> next one returns "oRS" as EndOfFile.
>
> I am guessing that EOF is still on from the previous name, so how do I
> "RESET" the EOF flag?
>
> Any and all help is appreciated.
>
> Happy Holidays!
>
> George

Insert "oRS.movefirst" after "Wend"

[Mark Schupp]

> Wend
oRS.close

> Next

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"George Fernett" <georgef@njcf.org> wrote in message
news:upb9LcYyDHA.1272@TK2MSFTNGP12.phx.gbl...

> Hi all,
>
> I have the following in an ASP script:
>
> (note: "ccode" is a checkbox collection from a previous ASP script)
>
>
>
> <%
> dim choices, oCmd, oRS
> set oConn = GetConnection()
> choices = Request.Form("ccode")
> choices = Split(choices, ",")
>
> For Each member in choices
> oCmd = "SELECT * FROM jsppf WHERE jspcde = '" & member &

"'"

> Set oRS = oConn.Execute(oCmd)
> While Not oRS.eof 'EOF IS ON AFTER FIRST NAME
> Response.Write("<span class=""head"">Course Code: " &
> oRs.fields("jspcde") & "</span>")
> Response.Write("<span class=""subhead"">— " &
> oRs.fields("jspdsc") & "</span>")
> oRS.movenext
> Wend
> Next
> %>
>
> "choices" contains NewYork,Trenton
>
> If "choices" contains 1 name, this works fine
> If "choices" contains more than 1 name, the first name works fine, but the
> next one returns "oRS" as EndOfFile.
>
> I am guessing that EOF is still on from the previous name, so how do I
> "RESET" the EOF flag?
>
> Any and all help is appreciated.
>
> Happy Holidays!
>
> George
>
>

[Xenopheonix]

looks like a bunch of japanese to me haha ha ha hahaa am i
right or am i right?

>-----Original Message-----
>Hi all,
>
>I have the following in an ASP script:
>
> (note: "ccode" is a checkbox collection from a

previous ASP script)

>
>
>
><%
> dim choices, oCmd, oRS
> set oConn = GetConnection()
> choices = Request.Form("ccode")
> choices = Split(choices, ",")
>
> For Each member in choices
> oCmd = "SELECT * FROM jsppf WHERE jspcde

= '" & member & "'"

> Set oRS = oConn.Execute(oCmd)
> While Not oRS.eof 'EOF IS ON AFTER

FIRST NAME

> Response.Write("<span

class=""head"">Course Code: " &

>oRs.fields("jspcde") & "</span>")
> Response.Write("<span

class=""subhead"">— " &

>oRs.fields("jspdsc") & "</span>")
> oRS.movenext
> Wend
> Next
>%>
>
>"choices" contains NewYork,Trenton
>
>If "choices" contains 1 name, this works fine
>If "choices" contains more than 1 name, the first name

works fine, but the

>next one returns "oRS" as EndOfFile.
>
>I am guessing that EOF is still on from the previous

name, so how do I

>"RESET" the EOF flag?
>
>Any and all help is appreciated.
>
>Happy Holidays!
>
>George
>
>
>.
>