Script Question

[BlurredVision]

I have the following code. It works if all the information is found, but if a field is null, it fails. Does anyone know how to get around this?

//Retrieve the collection of users in the Crystal Enterprise environment
var Users = IStore.Query("SELECT SI_NAME, SI_LAST_RUN_TIME, SI_DESCRIPTION, SI_UPDATE_TS FROM CI_INFOOBJECTS WHERE SI_PROGID='CrystalEnterprise.Report'ORDER BY SI_NAME"


//Display the list of the users.
Response.Write('List of Report Information From Crystal Enterprise: <BR><BR>');
for (i=1; i <= Users.Count; i++)
{




Response.Write(Users.Item(i).Properties.Item('SI_NAME'));
Response.Write(',');
Response.Write(Users.Item(i).Properties.Item('SI_LAST_RUN_TIME'));
Response.Write(',');
Response.Write(Users.Item(i).Properties.Item('SI_UPDATE_TS'));
Response.Write(',');
Response.Write('<BR>');
}

Thanks for your time!

 

[Turkbear]

Hi,
How does it fail? Does is show 'undefined' for missing values or just not run?

 

[BlurredVision]

Thanks for the reply. It fails with the error 'Item SI_LAST_RUN_TIME was not found in the collection' If the field is not null, it doesn't have any problem.


Brian

http://www.crystalcommunity.com

 

[mrees]

Do you need to check for nulls before each Response.Write?

So something like

If IsNull(Users.Item(i).Properties.Item('SI_NAME')Then
Response.Write &quot; &quot;
Else
Response.Write(Users.Item(i).Properties.Item('SI_NAME'));
End If

Don't quote me on the syntax, but its close.





Response.Write(Users.Item(i).Properties.Item('SI_NAME'));

 

[BlurredVision]

That should work!.. Thank you very much

Brian

http://www.crystalcommunity.com