One last LOV question, didn’t get a resolution yet…
Some of our LOVs, prompts are showing up with semi-colons, didn’t used to, doesn’t happen on the test box we used…
I have tried some things, but not successfully… thought maybe it was the ‘initnumericseperator’ thing, nope…
Webi 2.51, teradata / oracle… any ideas? A param to look for? I was thinking there is a “list seperator” param, but I cant find anything specific
Thanks,
Brent
Listserv Archives (BOB member since 2002-06-25)
Uhhh, exactly what do you mean by the prompts are showing up with semicolons? I have run into similar issues when using external vars files, and depending on the way the vars file is formatted along with the syntax of the @variable in the where clause of the object, it can fail in that way. I don’t remember all the excat details, though, perhaps if you can explain more fully it would jog my memory. 
Paul
Listserv Archives (BOB member since 2002-06-25)
It is just kind of annoying for now, but say the prompt is like this
*Dept Code in List:
The default value will come up like:
;ACC
… not all the time, but enough to be a distraction…
ideas?
Brent
Listserv Archives (BOB member since 2002-06-25)
Hmmm… that isn’t what I had encountered…
I take it you can just delete the semicolon and the document then refreshes successfully?
Is this happening on more than one machine? If not, maybe a reinstallation is called for. Just a wild, unscientific suggesstion.
Paul
Listserv Archives (BOB member since 2002-06-25)
I am all over wild suggestions : )
Still in the research mode, but yes, deleting it helps. But, seems to be ok to leave it. more of a hassle, additional confusion…
Brent
Hmmm… that isn’t what I had encountered…
I take it you can just delete the semicolon and the document then refreshes
successfully?
Is this happening on more than one machine? If not, maybe a reinstallation
is called for. Just a wild, unscientific suggesstion.
Paul
Listserv Archives (BOB member since 2002-06-25)
Brent
Are you certain that the LOV is not displaying a NULL value which gets selected along with ACC and is then returned as “;ACC”? If this is the case you could change the LOV query for this object to exclude NULLS.
Mike McErlain
Listserv Archives (BOB member since 2002-06-25)
I think the key to understanding what’s going on is finding out whether it’s happening on just one machine, or multiple machines… and if it’s happening on multiple machines, how widespread it is. That will tell you where the root of thge problem lies - on the machine, in the universe, in the repository, etc.
That is a weird one… sorry I can’t come up with anything better… 
Paul
Listserv Archives (BOB member since 2002-06-25)
I did get resolution to my way earlier issue, eg, semi-colons show up in prompts… Turns out to be a bug with pre 2.52 versions of webi - only happens with multiple prompts, after the first refresh…
Eg
state = ____
county = ;____
user= ;_____
etc
Brent
One last LOV question, didn’t get a resolution yet…
Some of our LOVs, prompts are showing up with semi-colons, didn’t used to,
doesn’t happen on the test box we used…
I have tried some things, but not successfully… thought maybe it was the
‘initnumericseperator’ thing, nope…
Webi 2.51, teradata / oracle… any ideas? A param to look for? I was
thinking there is a “list seperator” param, but I cant find anything specific
Thanks,
Brent
Listserv Archives (BOB member since 2002-06-25)