i try to change a little bit my code and i write the below code. it's been execute correct but do not print the word friday of the monday
if (select count(*) from klinwtrapezigr.subscritption WHERE email='sdfsaf@hotmail.com') > 0
BEGIN
PRINT 'Friday'
END
ELSE BEGIN PRINT 'dfgd' END

 The values of the databaseOwner and objectQualifier you got from the web.config file where it have to set.  If you used tables, procedures functions and views on a DotNetNuke instance those Parameters habe to be used on programming for the T-SQL scripts, who are used on the install of the module or Provider.

Also the SQL feature of the DNN instance on host uses thos prameters and set them automaticly with the values of the instance.

---

Regards

Matthias

DNN MVP

www.aarsys.de

Metro7 Skin

ShoutCastStats Module for DNN