WebDB Be careful with quotes in label text

From: Kelly John Carney <Kelly_Carney_at_maxtor.com>
Date: Thu, 28 Oct 1999 15:15:24 GMT
Message-ID: <38186853.17A9703B_at_maxtor.com>

[Quoted] 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 - 17:15:24 CEST