|
DocEVL
Starting Member
USA
19 Posts |
 Posted - 02 April 2001 : 12:55:22
|
This is kinda forum related but not really. It is based off the forum code anyways. What I keep getting is Unspecified error when trying to execute on a sql search of the database. Can anyone look at the code below and see what if anything I am doing wrong? It errors on line 270, which I marked in the code...
<!--#INCLUDE FILE="config.asp" -->
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE FILE="inc_top.asp" -->
<%
if Request.QueryString("mode") = "open" then
strSql = "SELECT " & strTablePrefix & "RAIDS.R_NAME "
strSql = strSql & "FROM " & strTablePrefix & "RAIDS "
set rs = my_Conn.Execute (strSql)
if rs.eof or rs.bof then %>
<table border="0" width="100%">
<tr>
<td width="33%" align="left" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="<%=strImageURL %>icon_folder_open.gif" height=15 width=15 border="0"> <a href="default.asp">All Forums</a><br>
<img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"> Guild Raids<br>
</font></td>
</tr>
</table>
<br>
<table bgcolor="<% =strTableBorderColor %>" border="0" cellpadding="0" cellspacing="0" width="100%" align="center">
<tr>
<td align=center bgcolor="<% =strHeadCellColor %>" nowrap valign="top"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">Guild Raids</font></b></td>
</tr>
<tr>
<td align="center" bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>">No Current Raids</font></td>
</tr>
</table>
<% else %>
<table border="0" width="100%">
<tr>
<td width="33%" align="left" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="<%=strImageURL %>icon_folder_open.gif" height=15 width=15 border="0"> <a href="default.asp">All Forums</a><br>
<img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"> Guild Raids<br>
</font></td>
</tr>
</table>
<br>
<table bgcolor="<% =strTableBorderColor %>" border="0" cellpadding="0" cellspacing="0" width="100%" align="center">
<tr>
<td align="center" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Guild Raids</font></b></td>
</tr>
<% do until rs.eof %>
<tr>
<td align="center" bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><a href="raids.asp?R_NAME=<%=rs("R_NAME")%>&mode=desc"><%= rs("R_NAME") %></font></td>
</tr>
<% rs.MoveNext
loop %>
</table>
<% end if
elseif Request.QueryString("mode") = "desc" then
strSql = "SELECT " & strTablePrefix & "RAIDS.R_NAME, "
strSql = strSql & strTablePrefix & "RAIDS.R_ID, "
strSql = strSql & strTablePrefix & "RAIDS.R_DESC, "
strSql = strSql & strTablePrefix & "RAIDS.R_DATE, "
strSql = strSql & strTablePrefix & "RAIDS.R_TIME, "
strSql = strSql & strTablePrefix & "RAIDS.R_LEADER "
strSql = strSql & "FROM " & strTablePrefix & "RAIDS "
set rs = my_Conn.Execute (strSql)
if rs.eof or rs.bof then %>
<table border="0" width="100%">
<tr>
<td width="33%" align="left" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="<%=strImageURL %>icon_folder_open.gif" height=15 width=15 border="0"> <a href="default.asp">All Forums</a><br>
<img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="raids.asp?mode=open"> Guild Raids</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"> Guild Raid Details<br>
</font></td>
</tr>
</table>
<br>
<table bgcolor="<% =strTableBorderColor %>" border="0" cellpadding="0" cellspacing="0" width="100%" align="left">
<tr>
<td align=center bgcolor="<% =strHeadCellColor %>" nowrap valign="top"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">Guild Raid Description</font></b></td>
</tr>
<tr>
<td align="center" bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>">No Current Raids</font></td>
</tr>
</table>
<% else %>
<table border="0" width="100%">
<tr>
<td width="33%" align="left" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="<%=strImageURL %>icon_folder_open.gif" height=15 width=15 border="0"> <a href="default.asp">All Forums</a><br>
<img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="raids.asp?mode=open"> Guild Raids</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"> Guild Raid Details<br>
</font></td>
</tr>
</table>
<br>
<table bgcolor="<% =strTableBorderColor %>" border="0" cellpadding="2" cellspacing="0" width="100%" align="left">
<tr>
<td align="left" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>"> <%if rs("R_LEADER") = strDBNTUserName then %><a href="raids.asp?mode=manage&R_ID=<%= rs("R_ID") %>">Manage Raid</a><% else %><a href="raids.asp?mode=list&R_ID=<%= rs("R_ID") %>">List Raid Members</a><% end if %></font></b></td>
<td align="center" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Guild Raid for <%=rs("R_NAME")%> - Raid Leader: <%=rs("R_LEADER")%></font></b></td>
<td align="right" bgcolor="<% =strHeadCellColor %>"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>"><a href="javascript:openWindow2('pop_join_raid.asp?R_ID=<%= rs("R_ID") %>')">Join Raid </a></font></b></td>
</tr>
<% do until rs.eof %>
<tr>
<td align="left" bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><b>Date:</b> <%= rs("R_DATE") %></font></td>
<td align="left" bgcolor="<% =strForumCellColor %>" valign="top" rowspan="2" colspan="2"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><b>Details:</b> <%= rs("R_DESC") %></font></td>
</tr>
<tr>
<td align="left" bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><b>Time:</b> <%= rs("R_TIME") %></font></td>
</tr>
<% rs.MoveNext
loop %>
</table>
<% end if
elseif Request.QueryString("mode") = "list" then
strSql = "SELECT " & strTablePrefix & "RAID_ATTEND.R_ID, "
strSql = strSql & strTablePrefix & "RAID_ATTEND.MEMBER, "
strSql = strSql & strTablePrefix & "RAID_ATTEND.M_CLASS, "
strSql = strSql & strTablePrefix & "RAID_ATTEND.M_LEVEL "
strSql = strSql & "FROM " & strTablePrefix & "RAID_ATTEND "
strSql = strSql & " WHERE " & strTablePrefix & "RAID_ATTEND.R_ID = " & Request.QueryString("R_ID")
set rs = my_Conn.Execute (strSql)
int x
x = 0
if rs.eof or rs.bof then
%>
<table border="0" width="100%">
<tr>
<td width="33%" align="left" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="<%=strImageURL %>icon_folder_open.gif" height=15 width=15 border="0"> <a href="default.asp">All Forums</a><br>
<img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="raids.asp?mode=open"> Guild Raids</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="JavaScript:history.go(-1)"> Guild Raid Details</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"> Guild Raid Attendees<br>
</font></td>
</tr>
</table>
<br>
<table bgcolor="<% =strTableBorderColor %>" border="0" cellpadding="0" cellspacing="0" width="100%" align="left">
<tr>
<td align=center bgcolor="<% =strHeadCellColor %>" nowrap valign="top"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">Guild Raid Attendees</font></b></td>
</tr>
<tr>
<td align="center" bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>">No One Attending Current Raid</font></td>
</tr>
</table>
<% else %>
<table border="0" width="100%">
<tr>
<td width="33%" align="left" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="<%=strImageURL %>icon_folder_open.gif" height=15 width=15 border="0"> <a href="default.asp">All Forums</a><br>
<img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="raids.asp?mode=open"> Guild Raids</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="JavaScript:history.go(-1)"> Guild Raid Details</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"> Guild Raid Attendees<br>
</font></td>
</tr>
</table>
<br>
<table bgcolor="<% =strTableBorderColor %>" border="0" cellpadding="2" cellspacing="0" width="100%" align="left">
<tr>
<td align="center" bgcolor="<% =strHeadCellColor %>" colspan="3"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Guild Raid Attendees</font></b></td>
</tr>
<tr>
<td align="center" bgcolor="<% =strCategoryCellColor %>" width="33%"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Name</font></b></td>
<td align="center" bgcolor="<% =strCategoryCellColor %>" width="33%"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Class</font></b></td>
<td align="center" bgcolor="<% =strCategoryCellColor %>" width="33%"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Level</font></b></td>
</tr>
<% do until rs.eof %>
<tr>
<td align="center" bgcolor="<% =strForumCellColor %>" width="33%"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><%= rs("MEMBER") %></font></td>
<td align="center" bgcolor="<% =strForumCellColor %>" width="33%"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><%= rs("M_CLASS") %></font></td>
<td align="center" bgcolor="<% =strForumCellColor %>" width="33%"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><%= rs("M_LEVEL") %></font></td>
</tr>
<% x = x + 1
rs.MoveNext
loop %>
<tr>
<td align="center" bgcolor="<% =strForumCellColor %>" colspan="3"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><hr>Total Members signed up for raid: <% =x %></font></td>
</tr>
</table>
<% end if
elseif Request.QueryString("mode") = "manage" then
strSql = "SELECT " & strTablePrefix & "RAID_ATTEND.R_ID, "
strSql = strSql & strTablePrefix & "RAID_ATTEND.MEMBER, "
strSql = strSql & strTablePrefix & "RAID_ATTEND.M_CLASS, "
strSql = strSql & strTablePrefix & "RAID_ATTEND.M_LEVEL "
strSql = strSql & "FROM " & strTablePrefix & "RAID_ATTEND "
strSql = strSql & " WHERE " & strTablePrefix & "RAID_ATTEND.R_ID = " & Request.QueryString("R_ID")
set rs = my_Conn.Execute (strSql)
int x
x = 0
if rs.eof or rs.bof then %>
<table border="0" width="100%">
<tr>
<td width="33%" align="left" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="<%=strImageURL %>icon_folder_open.gif" height=15 width=15 border="0"> <a href="default.asp">All Forums</a><br>
<img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="raids.asp?mode=open"> Guild Raids</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="JavaScript:history.go(-1)"> Guild Raid Details</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"> Guild Raid Management<br>
</font></td>
</tr>
</table>
<br>
<table bgcolor="<% =strTableBorderColor %>" border="0" cellpadding="0" cellspacing="0" width="100%" align="left">
<tr>
<td align=center bgcolor="<% =strHeadCellColor %>" nowrap valign="top"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor %>">Guild Raid Attendees</font></b></td>
</tr>
<tr>
<td align="center" bgcolor="<% =strForumCellColor %>"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>">No One Attending Current Raid</font></td>
</tr>
</table>
<% else %>
<table border="0" width="100%">
<tr>
<td width="33%" align="left" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="<%=strImageURL %>icon_folder_open.gif" height=15 width=15 border="0"> <a href="default.asp">All Forums</a><br>
<img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="raids.asp?mode=open"> Guild Raids</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"><a href="JavaScript:history.go(-1)"> Guild Raid Details</a><br>
<img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_blank.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_bar.gif" height=15 width=15 border="0"><img src="<%=strImageURL %>icon_folder_open_topic.gif" height=15 width=15 border="0"> Guild Raid Management<br>
</font></td>
</tr>
</table>
<br>
<table border="0" cellpadding="2" cellspacing="0" width="100%" align="left">
<tr>
<td align="center" bgcolor="<% =strHeadCellColor %>" colspan="3"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Guild Raid Attendees</font></b></td>
</tr>
<tr>
<td align="center" bgcolor="<% =strCategoryCellColor %>" width="33%"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Name</font></b></td>
<td align="center" bgcolor="<% =strCategoryCellColor %>" width="33%"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Class</font></b></td>
<td align="center" bgcolor="<% =strCategoryCellColor %>" width="33%"><b><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strHeadFontColor%>">Level</font></b></td>
</tr>
<% do until rs.eof
x = x + 1 %>
<tr>
<td align="center" bgcolor="<% =strForumCellColor %>" width="33%"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><%= rs("MEMBER") %></font></td>
<td align="center" bgcolor="<% =strForumCellColor %>" width="33%"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><%= rs("M_CLASS") %></font></td>
<td align="center" bgcolor="<% =strForumCellColor %>" width="33%"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><%= rs("M_LEVEL") %></font></td>
</tr>
<% rs.MoveNext
loop %>
<tr>
<td align="center" bgcolor="<% =strForumCellColor %>" colspan="3"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><hr>Total Members signed up for raid: <% =x %></font></td>
</tr>
<tr>
<td><% x = (Fix(x / 6) + 1) %><br># of Groups Needed: <% =x %><br></td>
</tr>
<%
Set rs2 = Server.CreateObject("ADODB.Recordset")
strSql1 = "SELECT " & strTablePrefix & "RAID_FORMAT.R_ID, "
strSql1 = strSql1 & strTablePrefix & "RAID_FORMAT.MEMBER, "
strSql1 = strSql1 & strTablePrefix & "RAID_FORMAT.GROUP, "
strSql1 = strSql1 & strTablePrefix & "RAID_FORMAT.POSITION "
strSql1 = strSql1 & "FROM " & strTablePrefix & "RAID_FORMAT "
strSql1 = strSql1 & " WHERE " & strTablePrefix & "RAID_FORMAT.R_ID = " & Request.QueryString("R_ID")
*** Here is where it fails *****************
set rs2 = my_Conn.Execute (strSql1)
*******************************************
if rs2.eof or rs2.bof then %>
<tr>
<td><br>No Groups assigned!<br><br><a href="pop_raid_assign.asp?R_ID=<%= rs2("R_ID") %>">Assign Groups</a></td>
</tr>
</table>
<% else
do until x = 0 %>
<tr>
<td align="center" colspan="3"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strForumFontColor%>"><b>Group <% =(x -(x - 1)) %></b>
<table align="center" border="1" cellpadding="0" cellspacing="0" width="40%">
<tr>
<td width="100%">Group Leader:
<% rs2.MoveFirst
do until rs2.eof
if rs2("POSITION") = 1 & rs2("GROUP") = (x -(x - 1)) then %>
<%= rs2("MEMBER") %>
<% end if
rs2.MoveNext
loop %>
</td>
</tr>
<tr>
<td width="100%">Member 1:
<% rs2.MoveFirst
do until rs2.eof
if rs2("POSITION") = 2 & rs2("GROUP") = (x -(x - 1)) then %>
<%= rs2("MEMBER") %>
<% end if
rs2.MoveNext
loop %>
</td>
</tr>
<tr>
<td width="100%">Member 2:
<% rs2.MoveFirst
do until rs2.eof
if rs2("POSITION") = 3 & rs2("GROUP") = (x -(x - 1)) then %>
<%= rs2("MEMBER") %>
<% end if
rs2.MoveNext
loop %>
</td>
</tr>
<tr>
<td width="100%">Member 3:
<% rs2.MoveFirst
do until rs2.eof
if rs2("POSITION") = 4 & rs2("GROUP") = (x -(x - 1)) then %>
<%= rs2("MEMBER") %>
<% end if
rs2.MoveNext
loop %>
</td>
</tr>
<tr>
<td width="100%">Member 4:
<% rs2.MoveFirst
do until rs2.eof
if rs2("POSITION") = 5 & rs2("GROUP") = (x -(x - 1)) then %>
<%= rs2("MEMBER") %>
<% end if
rs2.MoveNext
loop %>
</td>
</tr>
<tr>
<td width="100%">Member 5:
<% rs2.MoveFirst
do until rs2.eof
if rs2("POSITION") = 6 & rs2("GROUP") = (x -(x - 1)) then %>
<%= rs2("MEMBER") %>
<% end if
rs2.MoveNext
loop %>
</td>
</tr>
</table>
</td>
</tr>
<% x = x - 1
loop %>
</table>
<% end if
end if
end if %>
Edited by - DocEVL on 02 April 2001 13:09:21
Edited by - DocEVL on 02 April 2001 13:49:38 |
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 03 April 2001 : 07:16:27
|
It really depends on what the error is. My first guess is that one of these fields is
not on RAID_FORMAT: R_ID, MEMBER,GROUP or POSITION. The
other possibility is that R_ID is a text field and needs quotes around the field.
Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead |
 |
|
Topic Locked
