<html><div style='background-color:'><DIV>
<P>Hi,</P>
<P>Hi,<BR>> <BR>> I keep getting this error and I can't figure out what the problem is.
I<BR>join two tables, category and job opening and I am trying to display the<BR>category with each job opening under
the appropriate category. Here is my<BR>code. Any suggestions!! Thanks </P>
<P>PS I am using SQL Server<BR> <%<BR> Set rst =
Server.CreateObject("ADODB.Recordset")<BR> sqlstring = "SELECT DISTINCT
tbl_category.CategoryName,<BR>tbl_category.CategoryID, tbl_jobopenings.JobID,
tbl_jobopenings.JobTitle,<BR>tbl_jobopenings.StartDate, tbl_jobopenings.EndDate FROM tbl_category LEFT<BR>JOIN
tbl_jobopenings ON tbl_category.CategoryName =<BR>tbl_jobopenings.CategoryName"<BR> rst.Open sqlstring, Cnn, 0,
1<BR> %><BR><BR> <% <BR> If rst.EOF
Then <BR> %><BR> <TR><TD>Sorry,
there are no Job Categories.</TD></TR><BR> <%<BR>
Else<BR> rst.movefirst
%><BR> <BR> <% while NOT rst.EOF
%><BR> <% MyPosition= rst.fields("CategoryName")
%><BR> <BR>
<TR><BR> <TD bgcolor="#ccccff" width="50%"
class="body"><BR>
<a<BR>href="edit_category.asp?mode=edit&categoryid=<%=rst.Fields("CategoryID")%>"><BR&g
t;<%=rst.Fields("CategoryName")%></a></b>  
;</P>
<P><TD align=right> </P>
<P><a<BR>href="edit_category.asp?mode=edit&categoryid=<%=rst.Fields("CategoryID")%>">
;<BR>Edit</a>&nbsp;&nbsp;<BR>
<a<BR>href="edit_category.asp?mode=view&categoryid=<%=rst.Fields("CategoryID")%>"><BR&g
t;View Full</a>&nbsp;&nbsp;<BR>
<a<BR>href="edit_category.asp?mode=delete&categoryid=<%=rst.Fields("CategoryID")%><BR>&
amp;">Delete</a><BR>
</TD><BR>
</TD><BR>
<TR><TD></TD></TR><BR> <BR&g
t; <% do while MyPosition =
rst.fields("CategoryName")%><BR> <BR> &nb
sp; <TD bgcolor="#ffcccc" width="50%" class="body"
"align=center"><BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a<BR>href="edit_jobo
penings.asp?mode=edit&jobid=<%=rst.Fields("JobID")%>"><%=rst.<BR>Fields("JobTitle")%&g
t;</a></b><br><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;<b><%=rst.Fields("StartDate")%><BR>&nbsp;
<%=rst.Fields("EndDate")%></b><br><br><BR> &nbs
p; <TD align=right><BR>
<a<BR>href="edit_jobopenings.asp?mode=edit&jobid=<%=rst.Fields("JobID")%>">Edit</a&
lt;BR>&nbsp;&nbsp;<BR>
<a<BR>href="edit_jobopenings.asp?mode=view&jobid=<%=rst.Fields("JobID")%>">View<BR>F
ull</a>&nbsp;&nbsp;<BR>
<a<BR>href="edit_jobopenings.asp?mode=delete&jobid=<%=rst.Fields("JobID")%>&">Dele
<BR>te</a>&nbsp;&nbsp;<BR>
</TD><BR>
</TD><BR>
</TR><BR> <BR> <
;BR> <%rst.movenext<BR>
loop%><BR>
<TR><TD>&nbsp;</TD></TR><BR> &
;nbsp;<BR> <% wend
%><BR> <BR> <% end
if%><BR> <TR><td
class="body">&nbsp;<br><br><a
href="admin.asp">Admin<BR>Home</a><br>&nbsp;</td></tr>&
lt;BR> </table><BR> <%<BR> rst.close<BR> set rst =
nothing<BR> Cnn.close<BR> set
Cnn=nothing<BR> %><BR> <!--#include
file="footer.asp"--><BR> <BR> <BR>
<BR><BR><BR></P></DIV></div><br clear=all><hr>Join the world?s largest e-mail
service with MSN Hotmail. <a href='http://g.msn.com/1HM105401/16'>Click Here</a><br></html>