|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
I am trying to build a table that lists the different down times of different applications according to 1 of 4 different codes. When an application has no listing for such a procedure, it should put up a blank space in the cell where the info should have been. Whenever this runs, I hit an error on the first point in which data is not found in the field for that recordset. I tried to correct it by writing "if then" statements, but it is not working to place a blank space in if the field is null. instead, it puts the error code and message in that cell in the table. Any help would be appreciated. Here is the code:
if obj1rs.eof then 'Do nothing, end the table response.write("<tr><td> There are no Application Objectives associated with this application</td></tr>") else 'Add the records response.write("</td></tr>") response.write("<tr><td><table border='2' style='border-collapse: collapse' width='100%'>") response.write("<tr BGCOLOR='ffffe0'><td align='center'><b>RTO</b></td>") response.write("<td align='center'><b>RPO</b></td><td align='center'><b>SRTO</b></td><td align='center'><b>SRPO</b></td></tr>") do until obj1rs.eof response.write ("<tr><td align='center'>") if obj1rs("goal_hrs")="" then response.write (" </td>") else response.write (obj1rs("goal_hrs") & "</td>") end if response.write("<td align='center'>") if obj2rs("goal_hrs")="" then response.write (" </td>") else response.write (obj2rs("goal_hrs") & "</td>") end if response.write("<td align='center'>") if obj3rs("goal_hrs")="" then response.write (" </td>") else response.write (obj3rs("goal_hrs") & "</td>") end if response.write("<td align='center'>") if obj4rs("goal_hrs")="" then response.write (" </td>") else response.write (obj4rs("goal_hrs") & "</td></tr>") end if obj1rs.movenext loop end if response.write("</table></td></tr>") Last edited by rshaff23 : May 23rd, 2007 at 10:15 AM. Reason: Trying to add screenshot... |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Database Development > Error "80020009" |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|