Suzanne — Sat, 15 Dec 2001 06:37:10 +0000

Conditional -- if it's allowable to edit the script, what you want to do is test the response, and say if there is no response (null), then return the value no.

Little conditional statements are quite easily added to existing scripts if you are allowed to edit the script.

Suzanne

Mark Hensler — Sat, 15 Dec 2001 05:46:01 +0000

Is there any copyright on the script?

rline — Fri, 14 Dec 2001 22:45:47 +0000

Well. I'm quite happy to hack the perl script if there's a way to do it so that EVERY checkbox shows up in the database, even if the user only checks 2 out of 5. If this is possible, I'd love to hack the script.

Mark Hensler — Fri, 14 Dec 2001 07:05:24 +0000

How do you want to solve this problem?
1) hacking the perl script
2) finding a client side solution (DHTML, or other form tricks)

rline — Fri, 14 Dec 2001 05:37:46 +0000

Actually, Mark,

The whole problem arose because checkboxes didn't work. I had checkboxes all over the place, but only the ones which were selected by the user were passed into the flatfile db. This meant that if there were 20 fields total, and 5 were checkboxes, and the user only selected 2 checkboxes, then 3 wouldn't show up, so the db ended up with only 17 fields, when it should have had 20. And then when I use that db to print to the screen the different lines in the db, if there are 3 lines, each with different numbers of fields, it skews the printout.

If you can explain to me how to make the value "-" appear in the db, if that checkbox isn't selected, that would solve most of my problems.

rline — Fri, 14 Dec 2001 05:19:59 +0000

Yes. I had previously had No selected by default. But the person I'm doing it for wanted neither selected, so she could be sure that when a "yes" or a "no" came through, the user had actually selected it. I'm now trying to do it without the hidden field, so that if nothing is selected by the user, the script inserts "NS" for that value. So far much hair being torn out...

Mark Hensler — Fri, 14 Dec 2001 05:14:13 +0000

You could make No selected by default. Or did you also want to allow null values?

rline — Fri, 14 Dec 2001 03:54:38 +0000

Mark,

I would like to make it a radio button, but keep it hidden. Is this possible? The reason I made it hidden is because I only want "yes" and "no" to appear.

Mark Hensler — Fri, 14 Dec 2001 03:12:32 +0000

You could just make that hidden field a radio button.

The other thing I'd suggest is hacking the perl script to put "N/A" if $var==NULL