form input with same name

sourceuno · Post by **sourceuno** » Fri Jun 21, 2002 11:11 pm

I have a form with a 2 text inputs used for user queries and both inputs have the same name. I named the inputs "query". It seems my sql statement has a problem when both inputs in the $query variable. I tried putting the inputs in 2 separate forms, but I think they're still using the same $query variable. Is having form inputs with the same name allowed in Vortex?

Post by **John** » Sat Jun 22, 2002 8:50 pm

Yes, it is allowed in Vortex. You will end up with a multivalued variable in Vortex, which will then follow the rules for those in the SQL statement. What problem are you seeing?

Post by **Kai** » Mon Jun 24, 2002 10:07 am

A multi-valued variable parameter passed to <SQL> will become a parenthetical comma-separated list, eg. the values "bill clinton" and "william h. macy" will become "(bill clinton,william h. macy)". This is intended to make a Metamorph set, but depending on the parameter values and the syntax of the SQL statement it may not be what you want.