How I can clear the cached SQL Parameters?

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
7/4/2009 10:32:45 AM
Gravatar
Total Posts 550

How I can clear the cached SQL Parameters?

Hi  All

How I can clear the cached SQL Parameters?. After changing the sequence of sql parameter in the Data Layer I get "parameter's name doesn't match cached parameters" message.

Best,

Asad

 

 

 

7/4/2009 10:41:18 AM
Gravatar
Total Posts 18439

Re: How I can clear the cached SQL Parameters?

Recycle the app by touching Web.config, this will clear the cache. 

7/4/2009 11:44:41 AM
Gravatar
Total Posts 550

Re: How I can clear the cached SQL Parameters?

 Hi Joe,

I know when set CacheMSSQLParameters up to false, the parameters not cache , but when I set it to false I get the same message in other intracts  against database, for instance when I visit the setup page. I forget your josh :)

Best,

Asad

 

7/8/2009 3:44:52 AM
Gravatar
Total Posts 108

Re: How I can clear the cached SQL Parameters?

Morning,

I had the same error yesterday, and realised that my sproc parameters in my db didnt match the ones in my data layer as i manually added a new function (i had the same number of parameters, just miss spelt it in my code)

Thanks

Tim

 

 

 

7/8/2009 11:00:01 PM
Gravatar
Total Posts 131

Re: How I can clear the cached SQL Parameters?

I had been getting this error a bunch as well when I was working on my stored procs.  Couldn't get it to clear.   Recently, I switched to the enterprise library 4.1 data layer and have been upgrading the code in my custom modules to that whenever i touch it.  I never get the error on basic mojo functionality, so it is likely that changing the procs in the background is causing it due to some other error, but I do like Ent Lib much better.  Every think of upgrading, Joe?

 

You must sign in to post in the forums. This thread is closed to new posts.