|
| |
|
|
hzarabet
Posts: 1539
From: New Milford CT USA
Status: offline
 |
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
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: I screwed up! - 3/22/2001 17:13:00
Dang ![]("http://www.frontpagewebmaster.com/ubb/smile.gif") 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
Posts: 1539
From: New Milford CT USA
Status: offline
|
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
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
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
Posts: 1539
From: New Milford CT USA
Status: offline
|
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 ![]("http://www.frontpagewebmaster.com/ubb/mad.gif") 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
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
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
Posts: 1539
From: New Milford CT USA
Status: offline
|
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 ![]("http://www.frontpagewebmaster.com/ubb/biggrin.gif") ------------------
www.Signingshotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
| |
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: I screwed up! - 3/23/2001 15:03:00
Youll definitely need to do it as NOT a DRWThe 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
Posts: 1539
From: New Milford CT USA
Status: offline
|
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 ![]("http://www.frontpagewebmaster.com/ubb/rolleyes.gif") 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
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
