Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default select

    Hi,

    I have following problem.

    In a form I have a control lsDocent. I want send the value to another page.
    He send the second parameter 'code' but he send the string lsDocent to the
    other page instead of the value of lsDocent.

    What's wrong with this?

    <form name="verwijder" action="vak_info.php?doc=lsDocent&&code=<?echo
    $code?>" method = "post">
    <SELECT name="lsDocent">
    <?php
    while ($line = mysql_fetch_array($resultaat, MYSQL_ASSOC)) {
    ?>


    <!--
    genereren van lijst van docenten
    -->


    <OPTION selected value="<?print $line["Leraarscode"];?>"><?print
    $line["Familienaam"];?> <?print " - "?> <?print
    $line["Voornaam"];?></OPTION>

    <?php
    }
    ?>
    </SELECT>
    </td>
    <td>
    <input type = "submit" Value="OK">
    </td>
    </form>


    </TR>
    ALain


    Alain Dhaene Guest

  2. Similar Questions and Discussions

    1. Select a list of items into an aliased field when doinga select
      OK I know this is going to sound weird, but I'm wondering if this is possible. I have a task table. (tblTask) These tasks can be assigned to...
    2. #25474 [Bgs]: posting arrays from a select box with multiple select is not working properly
      ID: 25474 User updated by: fmuller at cisco dot com -Summary: apache2filter: posting from a multiple select box is not...
    3. #25474 [Fbk->Opn]: posting arrays from a select box with multiple select is not working properly
      ID: 25474 User updated by: fmuller at cisco dot com Reported By: fmuller at cisco dot com -Status: Feedback...
    4. #25474 [Opn->Fbk]: posting arrays from a select box with multiple select is not working properly
      ID: 25474 Updated by: sniper@php.net Reported By: fmuller at cisco dot com -Status: Open +Status: ...
    5. SELECT DISTINCT + ORDER BY gives ERROR 145: ORDER BY items mustappear in the select list if SELECT DISTINCT is specified.
      Dan, You should be able to do this: SELECT Id, FaxID, ReceivedTime, Pages FROM ( SELECT DISTINCT .Id AS Id,
  3. #2

    Default Re: select

    Alain Dhaene <alain.dhaene@worldonline.be> wrote:
    > In a form I have a control lsDocent. I want send the value to another page.
    > He send the second parameter 'code' but he send the string lsDocent to the
    > other page instead of the value of lsDocent.
    >
    > What's wrong with this?
    At first glance nothing (except it quite ugly and inconsistent).
    > <form name="verwijder" action="vak_info.php?doc=lsDocent&&code=<?echo $code?>" method = "post">
    ^^ one & to many
    > <SELECT name="lsDocent">
    [snip]
    > <OPTION selected value="<?print $line["Leraarscode"];?>"><?print
    > $line["Familienaam"];?> <?print " - "?> <?print
    > $line["Voornaam"];?></OPTION>
    What's the output of the script? Is the value realy in the row
    'Leraarscode' and not in 'Leraarcode'?

    --

    Daniel Tryba

    Daniel Tryba Guest

  4. #3

    Default Re: select

    The output is
    lsDocent and the value of the code e.g A

    In the select box I get a row of Stings (the code of a docent). I thought
    when I select one of them then the value of lsDocent will retrieve this
    value and so I post this value to the other form. But I retrieve the text
    lsDocent.

    Alain

    "Daniel Tryba" <news_comp.lang.php@canopus.nl> schreef in bericht
    news:bpntfr$1bi$2@news.tue.nl...
    > Alain Dhaene <alain.dhaene@worldonline.be> wrote:
    > > In a form I have a control lsDocent. I want send the value to another
    page.
    > > He send the second parameter 'code' but he send the string lsDocent to
    the
    > > other page instead of the value of lsDocent.
    > >
    > > What's wrong with this?
    >
    > At first glance nothing (except it quite ugly and inconsistent).
    >
    > > <form name="verwijder" action="vak_info.php?doc=lsDocent&&code=<?echo
    $code?>" method = "post">
    > ^^ one & to many
    >
    > > <SELECT name="lsDocent">
    > [snip]
    > > <OPTION selected value="<?print $line["Leraarscode"];?>"><?print
    > > $line["Familienaam"];?> <?print " - "?> <?print
    > > $line["Voornaam"];?></OPTION>
    >
    > What's the output of the script? Is the value realy in the row
    > 'Leraarscode' and not in 'Leraarcode'?
    >
    > --
    >
    > Daniel Tryba
    >

    Alain Dhaene Guest

  5. #4

    Default Re: select

    Alain Dhaene wrote:
    > Hi,
    >
    > I have following problem.
    >
    > In a form I have a control lsDocent. I want send the value to another page.
    > He send the second parameter 'code' but he send the string lsDocent to the
    > other page instead of the value of lsDocent.
    >
    > What's wrong with this?
    >
    > <form name="verwijder" action="vak_info.php?doc=lsDocent&&code=<?echo
    > $code?>" method = "post">
    > <SELECT name="lsDocent">
    > <?php
    > while ($line = mysql_fetch_array($resultaat, MYSQL_ASSOC)) {
    > ?>
    >
    >
    > <!--
    > genereren van lijst van docenten
    > -->
    >
    >
    > <OPTION selected value="<?print $line["Leraarscode"];?>"><?print
    > $line["Familienaam"];?> <?print " - "?> <?print
    > $line["Voornaam"];?></OPTION>
    >
    > <?php
    > }
    > ?>
    > </SELECT>
    > </td>
    > <td>
    > <input type = "submit" Value="OK">
    > </td>
    > </form>
    >
    >
    > </TR>
    > ALain
    >
    >
    I think it is an error in the first line:
    <form name="verwijder" action="vak_info.php?doc=<? echo $lsDocent;
    ?>&&code=<?echo
    $code?>" method = "post">
    So you must attribute lsDocent in a php script.

    OSIRIS Guest

  6. #5

    Default Select

    I am new to ASP. I have a form created in Frontpage. I am trying to put a
    drill down window that pops up and displays the data from a SQL table and
    then be able to select the entry I want and insert it into the text box in
    the form. then when I click submit on the form it inserts the form into
    another SQL table.

    The only part I need help with is the whole pop up window. I have got it to
    work with a drop down, but can not figure it out with a window. Is this
    possible? Thanks!

    Darren


    Darren Woodbrey Guest

  7. #6

    Default Re: Select

    It sounds to me that what you're actully looking for is support in
    client-side script, typically that that is javascript that runs in the
    browser. I suggest posting in microsoft.public.scripting.jscript or a non
    MS-hosted javascript group.

    Ray at work

    "Darren Woodbrey" <darrenwoodbrey@hpfairfield.com> wrote in message
    news:Oh38mvUAEHA.640@TK2MSFTNGP09.phx.gbl...
    > I am new to ASP. I have a form created in Frontpage. I am trying to put
    a
    > drill down window that pops up and displays the data from a SQL table and
    > then be able to select the entry I want and insert it into the text box in
    > the form. then when I click submit on the form it inserts the form into
    > another SQL table.
    >
    > The only part I need help with is the whole pop up window. I have got it
    to
    > work with a drop down, but can not figure it out with a window. Is this
    > possible? Thanks!
    >
    > Darren
    >
    >

    Ray at Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139