Running SQL queries from a form

I'm trying to figure out who to perform a database lookup to populate fields on an HTML form. Can anyone help me out either with some sample code or instruction?

Find more posts tagged with

Comments

Donna Nalls

I'm sure there are other approaches, but I have done this using custom attributes...then the queries are run with the oscript and used to populate attribute values or valid values or whatever you need.Donnadnalls@wisteria-it.com

Michael_Burmeister

That's what I had in mind at first, but the problem I ran into is that apparently oscript is not executed from within the HTML view that my form is using. It seems to be interpretted as text only. Maybe I'm doing something wrong here.

Donna Nalls

hhhmmm, that's curious...i just tested mine and it seems to be working fine - even when i export the html and use a view.i wrote this module several years ago in 9.1 -- and even though the html looks goofy because of the 9.2 styles, it is all working fine in 9.2.i have two custom attributes -- one that fills in a text value and one that fills in valid values for a drop-down.have you tested the attributes just as attributes - are they working properly there???