Partners

SELECT [Website] ,[City]+', '+[StateName]+' '+[ZipCode] as CityState ,[Phone] as tel ,[Fax] ,[Street1] as addr1 ,[Street2] as addr2 ,[CompanyId] as co_id ,[Name] as co_name FROM [companies].[vCompany] WHERE (CompanyId=)

Details for this company cannot be found.

"

#encodeForHTML(rsCompany.co_name)#


Website Not Available

#encodeForHTML(rsCompany.co_name)#

Website

#encodeForHTML(strURL)#

Address

#encodeForHTML(rsCompany.co_name)#
#encodeForHTML(rsCompany.addr1)#
#encodeForHTML(rsCompany.addr2)#
#encodeForHTML(rsCompany.cityState)#
Phone: #encodeForHTML(rsCompany.tel)#
Fax: #encodeForHTML(rsCompany.fax)#

#encodeForHTML(rsProducts.product_category_desc)#

  • #encodeForHTML(rsProducts.product_desc)#
---> SELECT DISTINCT psv.[Category] as product_category_desc ,psv.[Articles] as product_desc FROM [drm_indianauniv].[dbo].[CIPProductStringsView] as psv INNER JOIN [drm_indianauniv].[dbo].[ContractIPProductXRef] as cipx ON psv.ContrIPProductID=cipx.ContrIPProductID INNER JOIN [drm_indianauniv].[dbo].[ContrIP] as cip ON cipx.ContrIPID=cip.ContrIPID INNER JOIN [dbo].[contrLicenseeXRef] cLXR on cip.ContrId=cLXR.contrID INNER JOIN [dbo].[Companies] c on c.CompanyID=cLXR.CompanyID WHERE ((c.CompanyID=) and (not(psv.Category='Historical SKU')) and (not(psv.Category='Escape Room')) and (not(psv.Category='Historical SKU')) and (not(psv.Inactive=1))) ORDER BY psv.Category, psv.Articles

Products

#encodeForHTML(rsProducts.product_category_desc)#

  • #encodeForHTML(rsProducts.product_desc)#

Sorry, an error has occurred, please try again.