Rather complex question

Hi All,

I have a rather complex question for you.
I have an ASP page with a field, a
field and a .
I fill the field with the values from a table like stated below:


<% Do while NOT rs.EOF %>
<% = rs("User") %>
<%
rs.MoveNext
loop
%>

onClick="javascript:GetEmailAddress()"">

Now I want the user to click the button "Email Address" and let a java code
or somekind to fill the text field
"psmfrom" with the Email Address from the corresponding user. It should go
into the recordset and fetch the
right address like:

GetUser = "the value of the
<% rs.open "Select * From Login Where User='" & GetUser & "'",cn %>
psmfrom=" & <% rs("EmailAddress") %> & "

This is however not working.

Any ideas? Or suggestions to do this different?

Marco
The Netherlands

Re: Rather complex question

am 07.01.2005 12:23:14 von McKirahan

"Marco Krechting" wrote in message
news:1e20d$41de613a$3e3af2ad$17017@news1.versatel.nl...
> Hi All,
>
> I have a rather complex question for you.
> I have an ASP page with a

field, a

> field and a .
> I fill the field with the values from a table like stated below:
>
>
> <% Do while NOT rs.EOF %>
> <% = rs("User") %>
> <%
> rs.MoveNext
> loop
> %>
>
> > onClick="javascript:GetEmailAddress()"">
>
> Now I want the user to click the button "Email Address" and let a java
code
> or somekind to fill the text field
> "psmfrom" with the Email Address from the corresponding user. It should go
> into the recordset and fetch the
> right address like:
>
> GetUser = "the value of the
> <% rs.open "Select * From Login Where User='" & GetUser & "'",cn %>
> psmfrom=" & <% rs("EmailAddress") %> & "
>
> This is however not working.
>
> Any ideas? Or suggestions to do this different?
>
> Marco
> The Netherlands

1) "Java" and "JavaScript" are not the same!

2) You're going back to the server to get the e-mail address; just
include each as a "value" of the option.

Try this. Watch for word-wrap.


<% Do while NOT rs.EOF %>
"><% = rs("User") %>
<%
rs.MoveNext
loop
%>

onClick="javascript:GetEmailAddress()">

Re: Rather complex question

Thank so far,

There's one lie giving me an error:

"><% = rs("User") %>

Microsoft VBScript runtime (0x800A01C2)
Wrong number of arguments or invalid property assignment
/Admis/formpage.asp, line 53


Marco


"McKirahan" wrote in message
news:-v-dne7XH-BA7UPcRVn-1Q@comcast.com...
> "Marco Krechting" wrote in message
> news:1e20d$41de613a$3e3af2ad$17017@news1.versatel.nl...
>> Hi All,
>>
>> I have a rather complex question for you.
>> I have an ASP page with a field, a
>
>> field and a .
>> I fill the field with the values from a table like stated below:
>>
>>
>> <% Do while NOT rs.EOF %>
>> <% = rs("User") %>
>> <%
>> rs.MoveNext
>> loop
>> %>
>>
>> >> onClick="javascript:GetEmailAddress()"">
>>
>> Now I want the user to click the button "Email Address" and let a java
> code
>> or somekind to fill the text field
>> "psmfrom" with the Email Address from the corresponding user. It should
>> go
>> into the recordset and fetch the
>> right address like:
>>
>> GetUser = "the value of the
>> <% rs.open "Select * From Login Where User='" & GetUser & "'",cn %>
>> psmfrom=" & <% rs("EmailAddress") %> & "
>>
>> This is however not working.
>>
>> Any ideas? Or suggestions to do this different?
>>
>> Marco
>> The Netherlands
>
> 1) "Java" and "JavaScript" are not the same!
>
> 2) You're going back to the server to get the e-mail address; just
> include each as a "value" of the option.
>
> Try this. Watch for word-wrap.
>
>
> <% Do while NOT rs.EOF %>
> "><% = rs("User") %>
> <%
> rs.MoveNext
> loop
> %>
>
> > onClick="javascript:GetEmailAddress()">
>
>
>
>

Re: Rather complex question

"Marco Krechting" wrote in message
news:9beb1$41de92d6$3e3af2ad$12854@news1.versatel.nl...
> Thank so far,
>
> There's one lie giving me an error:
>
> "><% = rs("User") %>
>
> Microsoft VBScript runtime (0x800A01C2)
> Wrong number of arguments or invalid property assignment
> /Admis/formpage.asp, line 53
>
>
> Marco

[snip]

Ooops. I for got the "="; try this:

"><%=rs("User")%>

Re: Rather complex question

Thanks it's working just great.

Marco

"McKirahan" wrote in message
news:wdGdnSFnu_WQOUPcRVn-rw@comcast.com...
> "Marco Krechting" wrote in message
> news:9beb1$41de92d6$3e3af2ad$12854@news1.versatel.nl...
>> Thank so far,
>>
>> There's one lie giving me an error:
>>
>> "><% = rs("User") %>
>>
>> Microsoft VBScript runtime (0x800A01C2)
>> Wrong number of arguments or invalid property assignment
>> /Admis/formpage.asp, line 53
>>
>>
>> Marco
>
> [snip]
>
> Ooops. I for got the "="; try this:
>
> "><%=rs("User")%>
>
>