I em experiencing an intermittent issue where some parameters I am passing to text areas in a html file will be stripped of leading and trailing quotes. The parameters are supposed to be like 'KSAC' but sometimes will be passed as KSAC causing errors in my WHERE statements. It seems to happen when I am making changes to other parts of the html file, but I am not really sure. For the parameters to get the quotes back I found that closing and reopening Developer Studio does the trick. Not really an ideal solution and a bit of a pain.

Has anyone else experienced a similar issue to this? If so have found what causes this to happen, I imagine I could figure some work around, but it would be nice to know the cause. Maybe some sort of caching in the viewer? Any insight would be appreciated, Thanks.

This message has been edited. Last edited by: <Kathryn Henning>,

A quick throw-away comment, not sure if it's relevant as you do not give too much info, but ...

Have you tried using &variable.QUOTEDSTRING within your WHERE statement?

T

I am afraid that using QUOTEDSTRING will cause problems when the quotes are actually being passed like I want.

The reason that I need to pass the quotes is because I am passing parameters like 'var1' OR 'var2'. I have a pre-fex running on an html 'menu' page that is passing variables that are used to filter the reports according to what the user should see. Some of the users need to have access to multiple areas and I need multiple variables passed to the WHERE condition.

This was working well in WF7 and for the most part in WF8, but the fact that now while I am making changes to the html page the quotes are (seemingly) randomly being stripped is somewhat disconcerting.

Maybe I am trying to approach this the wrong way? I appreciate the help.