We have been using the SQLView module, and the module has been periodically losing the stylesheet. I will update the stylesheet, and then come back an hour later and it will have reverted to the grid view version. Any ideas as to why this is happening? I have changed the stylesheet name. Is the module cacheing the stylesheet anywhere?

I could also try and figure out the problem myself if I had the source code. Is it for sale, and if yes, how much?

Thanks in advance.

Paul

Hi Paul,

The stylesheet (module.css) is automatically attached by the DNN core, SQLView isn't responsible for doing that. When you say you renamed the stylesheet, do you mean you renamed module.css to something else? If you rename it, it won't be attached at all and you'll lose the styles unless you enter the styles you want to use into portal.css or default.css. What version of DNN are you using?

The source code is available only with a 1 Year Site Subscription (Source Code) membership.

Sorry about that, when I was talking about the stylesheet, I meant the xslt. It seems to be losing the fact that it is supposed to be using xslt to transform the data and instead defaulting back to just showing the gridview.

I'm not caching the xslt source or anything like that .. in fact there is no caching other than what the DNN core provides in SQLView. Are you jumping back and forth between http and https or something like that?

Do you have a url where I can take a look at it?

No we don't because it is on a development site that is currently on our intranet. Do you think that changing the xslt file name would be causing the problem?

No, once the xslt file name has been set it shouldn't be a problem. What path are you specifying for the xsl src? Are you using a path relative to the portal root or a full url including http://?

No, I am just uploading it to the portal and picking it from the dropdown list. Should I specify the full path instead?

No, that should work fine. I can't think of why it would be losing it unless there is something going on with the DNN cache. Are you caching the module at all?

I'll check the cacheing settings and get back to you tomorrow. Thanks for your quick response.