Re: WebDB Be careful with quotes in label text

Thanks for the tip!

Kelly John Carney wrote:

> Don't let this happen to you!
>
> I innocently changed a date column's label text from:
>
> Date Closed:
> to
> Date Closed[example format "05-DEC-99"]:
>
> and blewee. Those embedded quotation marks reaked havoc with
> WebDBs javascript that produces the "Column Formatting and
> Validation" page. Once I had those quotes in the text, the
> editing page wouldn't work anymore. Nothing showed up in
> any of the label text boxes. The Finish/Cancel buttons
> quit working.
>
> Tried dropping the latest/corrupted version of the component
> but clicked too quickly and instead of losing the last
> version, that's the only one I kept. Doh!
>
> I thought I should be able to go into the schema where the
> component was kept and modify the procedure code. I did,
> but that had no effect on the component in WebDB. Hmm.
>
> Finally I tried the Manage Component.Export and that produced a
> page of code that helped me discover where I could fix the problem.
> The clue come from a line that looked like:
> -----
> insert into WWV_MODULE_DETAILS$ values (
> 1017808724,
> 27,
> 9036,
> 'Summary:'||chr(0)||'Part:'||chr(0)||'Close Date[example
> format"05-DEC-99"]:'||chr(0)||'Supplier
> Name:'||chr(0)||'Originator:'||chr(0)||'Originator
> Title:'||chr(0)||'P'||
> 'rogram:'||chr(0)||'Change
> Type:'||chr(0)||'Reason:'||chr(0)||'Notes:'||chr(0)||'Evaluation Sample
> Reqd:'||chr(0)||'Qty:'||chr(0)||'Responsible SQE:'||chr(0)||'SQE Signoff
> Date[i'||
> 'e-12/05/1999]:'||chr(0)||'SQE Impact:'||chr(0)||'Other Signoffs:'||
> null
> )
> -----
> Ah ha! Found the label text was actually stored in the
> WWV_MODULE_DETAILS$
> table. I did a:
> -----
> update WWV_MODULE_DETAILS$
> set value =
> 'Summary:'||chr(0)||'Part:'||chr(0)||'Close Date[example
> format-05-DEC-99]:'||chr(0)||'Supplier
> Name:'||chr(0)||'Originator:'||chr(0)||'Originator
> Title:'||chr(0)||'P'||
> 'rogram:'||chr(0)||'Change
> Type:'||chr(0)||'Reason:'||chr(0)||'Notes:'||chr(0)||'Evaluation Sample
> Reqd:'||chr(0)||'Qty:'||chr(0)||'Responsible SQE:'||chr(0)||'SQE Signoff
> Date[i'||
> 'e-12/05/1999]:'||chr(0)||'SQE Impact:'||chr(0)||'Other Signoffs:'||
> null
> where MODULE_ID = 1017808724 and VERSION = 27 and ATTRIBUTE_ID = 27
> -----
>
> That got rid of the quotations and the WebDB editing page came back to
> life.
Received on Thu Oct 28 1999 - 18:00:12 CEST