Ask a Question related to ASP Database, Design and Development.
-
Alain Dhaene #1
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
-
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... -
#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... -
#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... -
#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: ... -
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, -
Daniel Tryba #2
Re: select
Alain Dhaene <alain.dhaene@worldonline.be> wrote:
At first glance nothing (except it quite ugly and inconsistent).> 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?
^^ one & to many> <form name="verwijder" action="vak_info.php?doc=lsDocent&&code=<?echo $code?>" method = "post">
[snip]> <SELECT name="lsDocent">What's the output of the script? Is the value realy in the row> <OPTION selected value="<?print $line["Leraarscode"];?>"><?print
> $line["Familienaam"];?> <?print " - "?> <?print
> $line["Voornaam"];?></OPTION>
'Leraarscode' and not in 'Leraarcode'?
--
Daniel Tryba
Daniel Tryba Guest
-
Alain Dhaene #3
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...page.> Alain Dhaene <alain.dhaene@worldonline.be> wrote:> > In a form I have a control lsDocent. I want send the value to anotherthe> > He send the second parameter 'code' but he send the string lsDocent to$code?>" method = "post">>> > 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> ^^ one & to many
>> [snip]> > <SELECT name="lsDocent">>> > <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
-
OSIRIS #4
Re: select
Alain Dhaene wrote:
I think it is an error in the first line:> 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
>
>
<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
-
Darren Woodbrey #5
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
-
Ray at #6
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...a> I am new to ASP. I have a form created in Frontpage. I am trying to putto> 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> work with a drop down, but can not figure it out with a window. Is this
> possible? Thanks!
>
> Darren
>
>
Ray at Guest



Reply With Quote

