[DataConnection.ExecuteQuery]: Query: select View_DentalOutlook_Issue_Joined.NodeName as IssueName, View_DentalOutlook_Product_Joined.SKUPrice as DownloadSKUPrice, View_DentalOutlook_Product_Joined.NodeID as DownloadNodeID, ProductLink, View_DentalOutlook_Issue_Joined.NodeGUID as IssueLink, View_DentalOutlook_TableofContents_Joined.*, View_DentalOutlook_Product_Joined.SKUPrice as DownloadSKUPrice, View_DentalOutlook_Product_Joined.NodeID as DownloadNodeID from View_DentalOutlook_Issue_Joined join View_DentalOutlook_TableofContents_Joined on View_DentalOutlook_TableofContents_Joined.NodeParentID = View_DentalOutlook_Issue_Joined.NodeID join View_DentalOutlook_Product_Joined on View_DentalOutlook_Product_Joined.NodeGUID = case when View_DentalOutlook_TableofContents_Joined.ProductLink = '' then null else View_DentalOutlook_TableofContents_Joined.ProductLink end where View_DentalOutlook_Product_Joined.SKUPrice = 0.0 order by dateofissue desc : caused exception: Conversion failed when converting from a character string to uniqueidentifier.

Server Error in '/' Application.

[DataConnection.ExecuteQuery]: Query: select

View_DentalOutlook_Issue_Joined.NodeName as IssueName,
View_DentalOutlook_Product_Joined.SKUPrice as DownloadSKUPrice,
View_DentalOutlook_Product_Joined.NodeID as DownloadNodeID,
ProductLink,
View_DentalOutlook_Issue_Joined.NodeGUID as IssueLink,
View_DentalOutlook_TableofContents_Joined.*,
View_DentalOutlook_Product_Joined.SKUPrice as DownloadSKUPrice,
View_DentalOutlook_Product_Joined.NodeID as DownloadNodeID
from
View_DentalOutlook_Issue_Joined
join View_DentalOutlook_TableofContents_Joined
on View_DentalOutlook_TableofContents_Joined.NodeParentID = View_DentalOutlook_Issue_Joined.NodeID
join View_DentalOutlook_Product_Joined
on View_DentalOutlook_Product_Joined.NodeGUID = case when View_DentalOutlook_TableofContents_Joined.ProductLink = '' then null else View_DentalOutlook_TableofContents_Joined.ProductLink end
where
View_DentalOutlook_Product_Joined.SKUPrice = 0.0
order by
dateofissue desc

: caused exception: Conversion failed when converting from a character string to uniqueidentifier.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: [DataConnection.ExecuteQuery]: Query: select

View_DentalOutlook_Issue_Joined.NodeName as IssueName,
View_DentalOutlook_Product_Joined.SKUPrice as DownloadSKUPrice,
View_DentalOutlook_Product_Joined.NodeID as DownloadNodeID,
ProductLink,
View_DentalOutlook_Issue_Joined.NodeGUID as IssueLink,
View_DentalOutlook_TableofContents_Joined.*,
View_DentalOutlook_Product_Joined.SKUPrice as DownloadSKUPrice,
View_DentalOutlook_Product_Joined.NodeID as DownloadNodeID
from
View_DentalOutlook_Issue_Joined
join View_DentalOutlook_TableofContents_Joined
on View_DentalOutlook_TableofContents_Joined.NodeParentID = View_DentalOutlook_Issue_Joined.NodeID
join View_DentalOutlook_Product_Joined
on View_DentalOutlook_Product_Joined.NodeGUID = case when View_DentalOutlook_TableofContents_Joined.ProductLink = '' then null else View_DentalOutlook_TableofContents_Joined.ProductLink end
where
View_DentalOutlook_Product_Joined.SKUPrice = 0.0
order by
dateofissue desc

: caused exception: Conversion failed when converting from a character string to uniqueidentifier.

Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[Exception: [DataConnection.ExecuteQuery]: Query: select
			
			View_DentalOutlook_Issue_Joined.NodeName as IssueName,
			View_DentalOutlook_Product_Joined.SKUPrice as DownloadSKUPrice,
			View_DentalOutlook_Product_Joined.NodeID as DownloadNodeID,
			ProductLink,
			View_DentalOutlook_Issue_Joined.NodeGUID as IssueLink,
			View_DentalOutlook_TableofContents_Joined.*,
			View_DentalOutlook_Product_Joined.SKUPrice as DownloadSKUPrice,
			View_DentalOutlook_Product_Joined.NodeID as DownloadNodeID
from
			View_DentalOutlook_Issue_Joined
	join	View_DentalOutlook_TableofContents_Joined
		on	View_DentalOutlook_TableofContents_Joined.NodeParentID = View_DentalOutlook_Issue_Joined.NodeID
	join	View_DentalOutlook_Product_Joined
		on	View_DentalOutlook_Product_Joined.NodeGUID = case when View_DentalOutlook_TableofContents_Joined.ProductLink = '' then null else View_DentalOutlook_TableofContents_Joined.ProductLink end
where
			View_DentalOutlook_Product_Joined.SKUPrice = 0.0
order by
			dateofissue desc

: caused exception: Conversion failed when converting from a character string to uniqueidentifier.]
   CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +245
   CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +13
   CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) +324
   CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN, String columns) +100
   CMS.Controls.CMSAbstractQueryProperties.LoadData() +1081
   CMS.Controls.QueryRepeater.ReloadData(Boolean forceReload) +217
   CMS.Controls.QueryRepeater.OnInit(EventArgs e) +254
   System.Web.UI.Control.InitRecursive(Control namingContainer) +333
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Control.InitRecursive(Control namingContainer) +210
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378

Version Information: Microsoft .NET Framework Version:2.0.50727.4216; ASP.NET Version:2.0.50727.4223