Is it possible to have a select with 2 lines?

I think that you will have to create your own component for that.

Do you mean that the actual SQL text of the select statement is very long? If so, simply put carriage returns in where you want them.

For example:

select *
  from mytable
 where mycolvalue = 'a'
   and mycolvalue2 <> 'b'

If you mean to return two rows in a recordset rather than one, then you can't really unless you can union the two together.

Lee

this is a text for my selecy html

"Arquivo Morto = [ Solicitação/Arquivamento de documentos do arquivo morto; solicitação de cópias de notas fiscais. ]"

but it is very long and I'd like something like this way:

Arquivo Morto = [ Solicitação/Arquivamento de documentos do
arquivo morto; solicitação de cópias de notas fiscais. ]

a select with two lines

thanks

hummm

I think I will have to reduce the text.

Is there any way to make my select drop down box with 8 rows at least ?

Ahh, my mistake, I assumed SQL. Sorry :)

This is not possible within a select list in HTML.

<select multiple="multiple" size="8">

Well that makes it a multiple select box allowing you to choose more than one option. I think the question author wants to display a drop down whereby extended text in it appears as more than one row rather than a wide drop down or in some cases a drop down that shows part of the long text in it.

Lee

what about the textarea in the second link ID:35769146?

thanks very much