Hi Mark,
You might want to check the <cf_PrimaryKey> tag in the page your list is calling to see if the primary key is indeed an
integer key.
Are you using MS SQL 2000? I ran into a problem like this the other day when I did a database synchronization. I am not
sure Plum is picking up the correct data type for the primary key. My primary and alternate keys were mixed up. Check
the table in your Plum project and make sure that AreaID is the primary key for your table.
Jeff
Mark Fuqua wrote:
Hello All,
I have added a link to a list page. When I click on the link, the browser
is redirected to errors/ViewExceptionMessage.cfm?message= Data type mismatch
in criteria expression (%20's removed for readability).
I have looked at the displayLinkList.cfm and it didn't help me much. I
looked at the database and the data type is set to integer which I suppose
is what it should be
(AreaId=#URLEncodedFormat(Trim(Attributes.listQuery.Areas_AreaId[currentRow]
))#&FromDrill=1">Assigned Estimate Items<)
Any ideas what I can try?
Thanks,
Mark Fuqua
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
