simple question but want help.....

[chris]

Hi, I got a ASP problem wanna ask....

Sql_check = "select * from user_table where user_id =' " & user & " ' "
Set Rs_check = Conn.Execute(Sql_check)

In the user_table , there is an attribute called password, I wanna display
the password of the specified user name, what should I do?? Is that there is
something like Rs_check.password?? Please help


THANKS alot....

[Ray at]

Simple questions are fine. :]
<%
Sql_check = "SELECT [Password] FROM user_table WHERE user_id='" & user & "'"
''Did you want spaces before and after the '?
Set Rs_check = Conn.Execute(Sql_check)
If Not Rs_check.EOF THen
Response.Write "The password is " & Rs_check.Fields.Item(0).Value
Else
Response.write "That user wasn't found."
End If

Rs_check.Close : Set Rs_check = Nothing
Conn.Close : Set Conn = Nothing
%>


Also, please read these:

[url]http://www.aspfaq.com/show.asp?id=2096[/url]
[url]http://www.aspfaq.com/show.asp?id=2080[/url]

Ray at work


"chris" <router88@sinaman.com> wrote in message
news:bra0hh$lkd81@imsp212.netvigator.com...

> Hi, I got a ASP problem wanna ask....
>
> Sql_check = "select * from user_table where user_id =' " & user & " ' "
> Set Rs_check = Conn.Execute(Sql_check)
>
> In the user_table , there is an attribute called password, I wanna display
> the password of the specified user name, what should I do?? Is that there

is

> something like Rs_check.password?? Please help
>
>
> THANKS alot....
>
>

[chris]

Thanks alot! It's too good for me already!

^_^ cheers~

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> ¼¶¼g©ó¶l¥ó·s»D
:#VU3wl$vDHA.1272@TK2MSFTNGP12.phx.gbl...

> Simple questions are fine. :]
> <%
> Sql_check = "SELECT [Password] FROM user_table WHERE user_id='" & user &

"'"

> ''Did you want spaces before and after the '?
> Set Rs_check = Conn.Execute(Sql_check)
> If Not Rs_check.EOF THen
> Response.Write "The password is " & Rs_check.Fields.Item(0).Value
> Else
> Response.write "That user wasn't found."
> End If
>
> Rs_check.Close : Set Rs_check = Nothing
> Conn.Close : Set Conn = Nothing
> %>
>
>
> Also, please read these:
>
> [url]http://www.aspfaq.com/show.asp?id=2096[/url]
> [url]http://www.aspfaq.com/show.asp?id=2080[/url]
>
> Ray at work
>
>
> "chris" <router88@sinaman.com> wrote in message
> news:bra0hh$lkd81@imsp212.netvigator.com...

> > Hi, I got a ASP problem wanna ask....
> >
> > Sql_check = "select * from user_table where user_id =' " & user & " ' "
> > Set Rs_check = Conn.Execute(Sql_check)
> >
> > In the user_table , there is an attribute called password, I wanna

display

> > the password of the specified user name, what should I do?? Is that

there

> is

> > something like Rs_check.password?? Please help
> >
> >
> > THANKS alot....
> >
> >

>
>