anyone can check my ASP code about pulldown menu? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

anyone can check my ASP code about pulldown menu?

anyone can check my ASP code about pulldown menu?# Database - 数据库

h*r2002-04-10 07:04

1 楼

. I have a table named users. I want to set the first one as a menu list
page, once someone select a username from the drop down list, the second asp
page will retrieve information about the user from the users table, but my asp
page does not show anything. need help.
// the first html page//

h*e2002-04-10 07:04

2 楼

ft, u didn't set anything for the QueryString, how can u use it?

asp

【在 h****r 的大作中提到】

: . I have a table named users. I want to set the first one as a menu list
: page, once someone select a username from the drop down list, the second asp
: page will retrieve information about the user from the users table, but my asp
: page does not show anything. need help.
: // the first html page//
:
:
:

h*r2002-04-10 07:04

3 楼

But how to set it? pls.thanks

asp

【在 h****r 的大作中提到】

o*z2002-04-10 07:04

4 楼

'try add this:
username=Request("username")
if (username <> "") then response.write username
'see what you get
'were you using 1,2... as the usernames?

【在 h****r 的大作中提到】

: But how to set it? pls.thanks
:
: asp

h*r2002-04-10 07:04

5 楼

it still does not work. No, I set the username as the real name, not number.
wuwu

【在 o***z 的大作中提到】

:
: 'try add this:
: username=Request("username")
: if (username <> "") then response.write username
: 'see what you get
: 'were you using 1,2... as the usernames?

o*z2002-04-10 07:04

6 楼

really? the output should be numbers
have you tried something like
test.asp?username=Lindsey

【在 h****r 的大作中提到】

: it still does not work. No, I set the username as the real name, not number.
: wuwu

k*d2002-04-10 07:04

7 楼

Try this in the first page:
Should work. Good luck

h*r2002-04-10 07:04

8 楼

none of them works.

number.

【在 o***z 的大作中提到】

: really? the output should be numbers
: have you tried something like
: test.asp?username=Lindsey

k*d2002-04-10 07:04

9 楼

???!!!
Did you try to make some changes in the first page?
Change the values of the options to the usernames instead of numbers
Also see my TZ above

【在 h****r 的大作中提到】

: none of them works.
:
: number.

h*r2002-04-10 07:04

10 楼

ya, i tried all suggestions, but none of works. that is ok. i have sent my
code to an expert of ASP. hope can solve this problem finally
thanks

【在 k*******d 的大作中提到】

: ???!!!
: Did you try to make some changes in the first page?
: Change the values of the options to the usernames instead of numbers
: Also see my TZ above

o*z2002-04-10 07:04

11 楼

then i think the problem lies in your asp page
how about this?
Set objDC = Server.CreateObject("ADODB.Connection")
objdc.open "dsn=users;pwd=letmein"
sqltext="SELECT * FROM users WHERE (username = '" & request("username") &"')"
Response.Write "

"&sqltext&"
"
Set objRS=objdc.Execute(sqltext)
if NOT ...
......

【在 h****r 的大作中提到】
: none of them works.
:
: number.

h*e2002-04-10 07:04

12 楼

HTML 4.0 好象不再支持这种 selected value
所以你想显示这个东西是显示不出来的
可以用onchange event来active 个javascript记录

k*d2002-04-10 07:04

13 楼

Not really. Drop down box is implemented by syntax of

【在 h****e 的大作中提到】

: HTML 4.0 好象不再支持这种 selected value
: 所以你想显示这个东西是显示不出来的
: 可以用onchange event来active 个javascript记录

h*r2002-04-10 07:04

14 楼

It works. hahha
the problem is very funny.
cause I set autonumber for my table records, and later i deleted the first
five records, so the autonumbre begins from 6, that is why i cannot get the
value shown up. because my option value passed to asp begins from 1 to 3.
whatever. thanks all.
btw, why do I always make this kind of stupic mistake. too careless.
在 huster (huster) 的大作中提到: 】

k*d2002-04-10 07:04

15 楼

Usually, it will take 3 times longer time for debugging and maintaining the
code than writting the code. Which will let programmers always have work to do
number.