SetJoinTable
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
SetJoinTable

 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server
Author Message
jeromeQc
Guest
Posted: Wed Oct 26, 2005 4:51 pm    Post subject: SetJoinTable Reply with quote
Hi there

I am very new to CS. I gotta display information coming from
separate DB,
on the same SQL server running CS.

I read that the best way to do it is with th
CatalogManager.SetJoinTable method.

Here's an example

Imports CATALOGLi

Dim catalogManager As New CatalogManage
catalogManager.Initialize("SiteName", False
catalogManager.SetJoinTable("WebSiteDB.dbo.Packages", "PackageCode",
"PackageCode", CatalogJoinTypeEnum.CMS_OUTER_JOIN_RIGHT

I keep on getting the following error: "The specified target join-ke
is
invalid

And I'm sure the names are right

Any advice would be greatly appreciated

Thanks

Jerom
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB