micamb
asked on
EOF BOF error classic asp
Hi all,
I have a system where I can give out tasks using text messages. If a task has a given user assigned, he gets a text-message. However, tasks are created without assigning it to a user - meaning that the value is empty. I have some code that queries who an assignment has been given to, but if it hasn't been given to anyone, I get the following error:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
Here's the code:
Probably a simple solution I just can't get my head around.
I have a system where I can give out tasks using text messages. If a task has a given user assigned, he gets a text-message. However, tasks are created without assigning it to a user - meaning that the value is empty. I have some code that queries who an assignment has been given to, but if it hasn't been given to anyone, I get the following error:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
Here's the code:
CaseID = RSDatabase("CaseID")
Assigned= RSDatabase("Assigned")
If status = 1 then status_nr = "<td valign=center align=center bgcolor=FF0000><font color=ffffff><b>Status</b><br>Recieved</font></TD>"
If status = 2 then status_nr = "<td valign=center align=center bgcolor=FFFF00><b>Status</b><br>See comments</TD>"
If status = 23 then status_nr = "<td valign=center align=center bgcolor=009933><font color=ffffff><b>Status</b><br><font color=ffffff>Done</font></TD>"
If status = 24 then status_nr = "<td valign=center align=center bgcolor=FFFFFF><font color=ff0000><b>Status</b><br>Rejected</TD>"
DIM mySQL6, objRS6
mySQL6 = "SELECT User, Name FROM Users WHERE User = '" & assigned & "'"
Set objRS6 = Server.CreateObject("ADODB.Recordset")
objRS6.Open mySQL6, strConnect
DIM strUser
strUser = objRS6("User")
strName = objRS6("name")
If Assigned <> "" Then
show_assigned = "<br><font color='#FF0000'><b>Task assigned to " & strName & "</br></font>"
End if
Probably a simple solution I just can't get my head around.
ASKER
Thanks for the input!
Result: Type mismatch, Line 37
Here's the full code:
Result: Type mismatch, Line 37
Here's the full code:
<!--#include file="db/database_read.inc"--><!--#include file="close_access.inc"--><!--#include file="Include/link.inc"-->
2
3 <html>
4
5 <head>
6 <!--#include file="Include/meta.asp"-->
7 </head>
8 <body><div data-role="page">
9
10 <div data-role="header">
11 <h1>Update your task</h1>
12 </div><%
13 Id = Request.querystring("Id")
14 %>
15 <% Set DATABASE = Server.CreateObject("ADODB.Connection")
16 DATABASE.Open strConnect
17
18 SQLStr = "SELECT * FROM Tasks WHERE Id = '" & Id & "' "
19 Set RSDatabase = DATABASE.Execute(SQLStr)
20
21
22
23 Id = RSDatabase("Id")
24 Name= RSDatabase("Name")
25 Email = RSDatabase("Email")
26 Tlf = RSDatabase("tlf")
27 TaskType = RSDatabase("TaskType")
28 Institution = RSDatabase("Institution")
29 Location= RSDatabase("Location")
30 Priority = RSDatabase("Priority")
31 Description = RSDatabase("Description")
32 DateR = RSDatabase("DateR")
33 DateU = RSDatabase("DateU")
34 Comments = RSDatabase("Comments")
35 Status = RSDatabase("Status")
36CaseID = RSDatabase("CaseID")
37 if not RSDatabase.bof or not RSDatabase then
38 Assigned = RSDatabase("Assigned")
39
40 If status = 1 then status_nr = "<td valign=center align=center bgcolor=FF0000><font color=ffffff><b>Status</b><br>Recieved</font></TD>"
41 If status = 2 then status_nr = "<td valign=center align=center bgcolor=FFFF00><b>Status</b><br>See comments</TD>"
42 If status = 23 then status_nr = "<td valign=center align=center bgcolor=009933><font color=ffffff><b>Status</b><br><font color=ffffff>Completed</font></TD>"
43 If status = 24 then status_nr = "<td valign=center align=center bgcolor=FFFFFF><font color=ff0000><b>Status</b><br>Rejected</TD>"
44
45
46
47 DIM mySQL6, objRS6
48 mySQL6 = "SELECT User, Name FROM Users WHERE User = '" & assigned & "'"
49 Set objRS6 = Server.CreateObject("ADODB.Recordset")
50 objRS6.Open mySQL6, strConnect
51
52 DIM strUser
53 strUser = objRS6("User")
54 strName = objRS6("Name")
55
56
57 If Assigned <> "" Then
58 show_assigned = "<br><font color='#FF0000'><b>Task is assigned " & strName & "</br></font>"
59 End if
60
61 else ' if not RSDatabase.bof or not RSDatabase then ' run the code
62
63 response.write "No Data"
64
65 end if 'if not RSDatabase.bof or not RSDatabase then ' run the code
66 %>
if not RSDatabase.bof or not RSDatabase then
should be
if not RSDatabase.bof or not RSDatabase.eof then
probably better to use
if not RSDatabase.bof AND not RSDatabase.eof then
Lastly, this test needs to go before you use it as in line 22.
should be
if not RSDatabase.bof or not RSDatabase.eof then
probably better to use
if not RSDatabase.bof AND not RSDatabase.eof then
Lastly, this test needs to go before you use it as in line 22.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Horrific solution...
I have a default user in that table. If I fake the code to look like it's assigned to that user it works.
It requires a little bit of manipulating here and there, but...
It ain't pretty, but it works!
I have a default user in that table. If I fake the code to look like it's assigned to that user it works.
It requires a little bit of manipulating here and there, but...
If assigned = "" then
assigned_show = "USERINDATABASE"
Else
assigned_show = assigned
End if
It ain't pretty, but it works!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My solution was/is horrific absolutely! Being a complete amateur doesn't help when you are trying to code stuff... I'm really pressed for time, so I'll appoint your solution as the actual solution since mine is more a beating-around-the-bush-ki nd-of-thin g. Thanks for your effort!
Open in new window