[MaryTheG(r)eek]

Originally Posted by KozmoK

Errors so Far:
1) Must have a Deparments defined even though you have them shut off, or sometimes you will get a sql error.

I'll check it

Originally Posted by KozmoK

2) must use SQL Safe strings on insertions/updates.

In all inputs I'm using input->clean_array_gpc to clean the inputs. Seems that there is a confusinion between TYPE_STR and TYPE_NOHTML. I thought that TYPE_NOHTML adds also slashes before ' which causes SQL errors. I'll check it.

Originally Posted by KozmoK

Things that should be addressed:

1) Force to Pick a department if Deparments are enabled.
2) Force to Pick a Product.

Even if I remove the option "Please select", I do believe that users who don't like to "waste" their time, will let the default value. I must try to find a way (with javascript) to use with "onchange".

Maria

If these forces are not there, they show up blank, and it doesnt work right.[/quote]