I screwed up! (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

hzarabet -> I screwed up! (3/22/2001 16:11:00)

Hi Spooky:

I deleted your answer to the question of having a user log in and have a database open based on his username. The answer you did give gave me the "no records returned" answer, which is why the thread is still open.

Sorry for the goof-up

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada




Spooky -> RE: I screwed up! (3/22/2001 17:13:00)

Dang

That was the session username for the query?

You can really only use that format via asp (or naked DRW) as the web bot wont take asp




hzarabet -> RE: I screwed up! (3/22/2001 17:18:00)

I am sure I am not saying this correctly. When a promoter logs in, they enter event information. So now a promoter "A" can log in ,but input info and say that he is promoter "B" and enter info under promoter "B's" name. I am sure with Spooky login there is a way that whoever logs in is FORCED to have the info pass through with whatever user name was entered.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada




Spooky -> RE: I screwed up! (3/22/2001 17:39:00)

So you perhaps want to hard code the entry field as Session("Promoter") and not worry about the database query?

ie add a hidden field with the promoters name based on their session login




hzarabet -> RE: I screwed up! (3/22/2001 23:56:00)

I sort of lost you. I was thinking that I wouldn't need an entry field. That somehow the login name would act like a seach request on the database. Unfortunately, I am so lame at this asp thing I am getting more frustrated than anything

Could you explain it to me a little simpler (if that is possible)

Thanks again Spooky

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada




Spooky -> RE: I screwed up! (3/23/2001 20:09:00)

Define what you want to do

Do you want to add a record or find a record.
I thought you were adding no?




hzarabet -> RE: I screwed up! (3/23/2001 20:23:00)

Here is what I THINK I want to do. In my WHERE statement, I want to incorporate the session login info.

WHERE "session login info"=Promoter.company

This is simplified, but I guess you get the idea. The login name will match a field in my Promoter table, so when they login, only that promoters info will come up.

I was incoherent when I wrote the previous part of the thread. Hope this makes more sense.

Thanks for your patience

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada




Spooky -> RE: I screwed up! (3/23/2001 15:03:00)

Youll definitely need to do it as NOT a DRW

The reason is that the session variable is not one of the collections that the DRW can read.
It can be read in asp, but not the webbot.

So after the diet, you would have an sql string like :

"Select * from table where Promoter.company='"&Session("UserName")&"'"

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!




hzarabet -> RE: I screwed up! (3/23/2001 15:09:00)

BTW, I always put the code on a diet first. Now, if I remeber correctly, this is what you recommned after I deleted my thread and I kept getting "No Records Returned". I will tackle it again. Maybe I didn't copy it exactly.

Thanks.

------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625