dear experts,
i'm a newbies with asp so i need you help on this one.
i need a function getparam that returns a siteid as an output.
the input for this function are: HealtSoftware_CustID(that's the parameter we created to link our website to another website) (paramID= 68) this one is fixed and the Parameter value (KlantID).
this function has to run this query :
SELECT ID FROM dbo.tblPRParam
WHERE (ParamID = 68) AND (LangID = 'nl') AND (ParamLevel = 2) AND (Value = 38471422) ** is not fixed one parameter can have more than one value.
also i need to check via the parameter if the KlantID exists and if true than get the siteID, site email and domainname.
and also to check if the user id exists on the above website.

thanks

Use ADO .