database lookup with web forms

[citrusstyle]

anyone have experience with database lookups in the web forms module?

web forms 9.7.2
livelink 9.7.1
sql 2005

 

[appnair]

what kind of experience are you saying that you do not know how to use it ?
The example xsl/xsd files show you how to connect to kuaf.
If you put another database in the config section of it you can call other tables in other databases.
The calls are different between old(they call it untrusted connections).If you search the KB somebody has a posting that allows you to use webforms like in the previous versions as well.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[citrusstyle]

i did find a document on the knowledge center that includes some basic examples. i have a pretty custom requirement that i was unsure whether it was possible or not. i just spoke with someone at OT that confirmed what i'm trying to achieve is possible.

once i start the project i'll most likely be returning to this thread for some brief assistance.

 

[citrusstyle]

i found and experimented with the included examples contained within %othome%\module\webform_9_7_2\examples. i also read 'using web forms-examples' from the OT KC.

i am using oracle 10g r2 and have created a web forms database connection from the admin.index

what i'm trying to formulate are my lookups

we are using web forms throughout a lengthy workflow. the master form is initiated and cycled through several workflow steps. each step should render a different web form, based on a database lookup and the results of the lookup query.

from the master form, the initiator will punch in PAF Number (text box) and select how many managers (drop-down) are required to approve. when this information is plugged in, it is written to a table called LL_PAF_FORM. this table contains a few columns such as PAF_Number and Mgr_Required

i need my first lookup to query PAF_Number, this way i can lock in this row and pull additional information into my second db lookup.

PAF_Number is contained within a text box called [LL_FormTag_1_1_3_1 /]

QUESTION ONE: can i pull the value from LL_FormTag_1_1_3_1 into my first lookup query? once i have this value i need to read values within the same row.


now, for my SECOND lookup:
select Mgr_Required from LL_PAF_FORM where PAF_Number = ***ValueFromLookupOne***

QUESTION TWO: how do i pull in the value from LOOKUP1 into LOOKUP2?


make sense? i can explain further if needed. i appreciate everyone's help!

 

[citrusstyle]

i'm going a different direction. rather than perform a query to determine how many text boxes are shown, i've developed a javascript that will find text boxes with null values to hide the entire html table it's contained within....
which is much easier!

i've found and also confirmed with OT that web forms db lookups are simple and can not be dependent on other queries - it's a limitation of the module.