Parsing form fields using pl/sql - not a newbie, but this one has me stumped.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Rick Owen
    #1

    Parsing form fields using pl/sql - not a newbie, but this one has me stumped.

    Greetings,

    I have a form that, when submitted, calls a plsql procedure. The form
    has a number of fields (text, hidden, select, radio) but the
    particular field that is giving me problems is a <selectwhich allows
    multiple selection. When I receive the form values in my procedure I
    getting only the first value of those that are selected. For example
    if I select 1000, 1100, 1200, 1300 in the list I only get 1000 in my
    procedure. If I send the form to a ColdFusion template that dumps the
    contents of the form fields I get

    org_list_pick=" 1000,1100,1200, 1300"

    but when I get the contents of the form fields in the plsql procedure
    I only see the 1000.

    My procedure is defined as:

    PROCEDURE eadoc_setup (searchwhat IN VARCHAR2 DEFAULT 'emp',
    report_emp IN VARCHAR2 DEFAULT NULL,
    orgqry IN VARCHAR2 DEFAULT NULL,
    report_org_id IN VARCHAR2 DEFAULT NULL,
    org_code_pick in varchar2 default null,
    ckmatrix IN VARCHAR2 DEFAULT 'no',
    report_code IN VARCHAR2 DEFAULT NULL,
    report_code_lis t IN VARCHAR2 DEFAULT NULL,
    listqry in varchar2 default null,
    org_code_list in varchar2 default null,
    startdate IN VARCHAR2 DEFAULT '01/01/1950',
    orderby IN VARCHAR2 DEFAULT 'org' ,
    searchtype IN VARCHAR2 DEFAULT 'simple') IS


    org_code_pick is the variable that is causing me the problems.

    We are using OAS on an HPUX box. I'm not sure of the version of OAS.
    Our database is 8.1.7.

    I have tried submitting the form with both get and post with the same
    results. This is actually the first time I have tried parsing a
    select statement with "MULTIPLE" using pl/sql, however I have been
    parsing forms with pl/sql for several years.

    What am I doing wrong?

    TIA,
    Rick.
    Tags: None
    • Rick Owen
      #2
      Re: Parsing form fields using pl/sql - not a newbie, but this one has me stumped.

      yorelnewo-lists@yahoo.com (Rick Owen) wrote in message
      news:<ad8adf2d. 0310290713.4a96 0ee2@posting.go ogle.com>...

      Just to clarify. The form is an HTML form (not an oracle form). The
      form tag looks like:

      <form action="http://server/psl/acc/rpt_eadoc.eadoc _setup"
      method="post" onSubmit="retur n verify(this);" name="myform">

      Greetings,
      >
      I have a form that, when submitted, calls a plsql procedure. The form
      has a number of fields (text, hidden, select, radio) but the
      particular field that is giving me problems is a <selectwhich allows
      multiple selection. When I receive the form values in my procedure I
      getting only the first value of those that are selected. For example
      if I select 1000, 1100, 1200, 1300 in the list I only get 1000 in my
      procedure. If I send the form to a ColdFusion template that dumps the
      contents of the form fields I get
      >
      org_list_pick=" 1000,1100,1200, 1300"
      >
      but when I get the contents of the form fields in the plsql procedure
      I only see the 1000.
      >
      My procedure is defined as:
      >
      PROCEDURE eadoc_setup (searchwhat IN VARCHAR2 DEFAULT 'emp',
      report_emp IN VARCHAR2 DEFAULT NULL,
      orgqry IN VARCHAR2 DEFAULT NULL,
      report_org_id IN VARCHAR2 DEFAULT NULL,
      org_code_pick in varchar2 default null,
      ckmatrix IN VARCHAR2 DEFAULT 'no',
      report_code IN VARCHAR2 DEFAULT NULL,
      report_code_lis t IN VARCHAR2 DEFAULT NULL,
      listqry in varchar2 default null,
      org_code_list in varchar2 default null,
      startdate IN VARCHAR2 DEFAULT '01/01/1950',
      orderby IN VARCHAR2 DEFAULT 'org' ,
      searchtype IN VARCHAR2 DEFAULT 'simple') IS
      >
      >
      org_code_pick is the variable that is causing me the problems.
      >
      We are using OAS on an HPUX box. I'm not sure of the version of OAS.
      Our database is 8.1.7.
      >
      I have tried submitting the form with both get and post with the same
      results. This is actually the first time I have tried parsing a
      select statement with "MULTIPLE" using pl/sql, however I have been
      parsing forms with pl/sql for several years.
      >
      What am I doing wrong?
      >
      TIA,
      Rick.

        Comment

        Previous template Next
        Working...