Okie doke.
I modified the code to the below;
else
rsIns.AddNew
rsIns.Fields("Username") = idValue
rsIns.Fields("Author_email") = idValue
rsIns.Fields("Signature") = idValue
rsIns.Fields("Password") = idValue
rsIns.Fields("User_code") = idValue
rsIns.Fields("Time_offset") = "+"
rsIns.Fields("Time_offset_hours") = "0"
rsIns.Fields("Join_Date") = idValue
rsIns.Fields("MSN") = idValue
rsIns.Fields("ICQ") = idValue
rsIns.Fields("AIM") = idValue
rsIns.Fields("YAHOO") = idValue
rsIns.Fields("Show_Email") = False
rsIns.Fields("Real_Name") = idValue
rsIns.Fields("Last_visit") = idValue
rsIns.Fields("Occupation") = idValue
rsIns.Fields("No_of_posts") = idValue
SQL = "SELECT Group_ID FROM tblGroup WHERE Minimum_posts <= " & rs("M_POSTS") & " ORDER BY Minimum_posts DESC"
set rsGroup = conn.execute(SQL)
rsIns.Fields("Group_ID") = rsGroup("Group_ID")
rsIns.Update
SQL = "DELETE * FROM tblAuthor WHERE username = '" & idValue & "'"
set rsDel = conn.execute(SQL)
IDValue = IDValue + 1
End if
This will mean that it'll update each field with the idValue, like it was doing for the username etc - except time_offset and time_offset_hours, which have been set to update with '+' and '0', and show_email which has been set to 'false'.
However, when I run it, I get the following error;
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/wwf/forum/admin/database/convert.asp, line 92
Line 92 has been highlighted red in the code above. Is there something I'm doing wrong? I realise that in that part it's matching the post count to the relevant ranking group in tblGroup.
Topic Options
Post Options
Thanks(0)
! 
MortiOli wrote:
