Loged in user DRW stuff

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Loged in user DRW stuff

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Loged in user DRW stuff

Page: [1]


walrus Posts: 554 Joined: 3/13/2003 From: London Status: offline	Loged in user DRW stuff - 3/20/2003 15:35:06 Hi, I have this rather awkward html on a page where the loged in user can select their own records from DRW. It works well, but I would like to remove the submit button and do it automatically. Can any of you expert guys and gals tidy this up for me? <form BOTID=" 0" METHOD=" POST" ACTION=" edit.asp" > <table BORDER=" 0" > <tr> <td><b>Username</b></td> <td><input TYPE=hidden NAME=" Username" VALUE=" <%=Session(" Username" )%>" size=" 20" ><%=Session(" Username" )%></td> </tr> </table> <input TYPE=" Submit" > </form> Thanks _____________________________ I hope The Boss isn't reading this, ...she thinks I program everything!


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Loged in user DRW stuff - 3/20/2003 22:08:47 What you need to do, is add the username to the SQL string. When you query with an SQL string, you may have something like this : " Select * from table where this=' this" and that=' that' " It will change to : " Select * from table where this=' this" and that=' that' AND Username=' " &Session(" Username" )&" ' " _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to walrus)


walrus Posts: 554 Joined: 3/13/2003 From: London Status: offline	RE: Loged in user DRW stuff - 3/21/2003 14:44:50 Im trying this; <% fp_sQry=" SELECT * FROM Results WHERE Username=' " " &Session(" " Username" " )&" " ' " fp_sDefault=" " fp_sNoRecords=" <tr><td colspan=28 align=left width=" " 100%" " >No records returned.</td></tr>" fp_sDataConn=" input" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice=" ID" fp_sMenuValue=" ID" fp_iDisplayCols=28 fp_fCustomQuery=True BOTID=0 fp_iRegion=BOTID %> but it doesn' t seem to work Any clues. Im using FP2000 _____________________________ I hope The Boss isn't reading this, ...she thinks I program everything! (in reply to Spooky)

Spooky

Posts: 26617
Joined: 11/11/1998
From: Middle Earth
Status: offline

RE: Loged in user DRW stuff - 3/21/2003 16:20:46

fp_sQry=" SELECT * FROM Results WHERE Username='  " &Session(" Username" )&"  '  "

Spaces for clarity only - it was on a diet?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

��k�

Database / DRW help Check out the Tutorials for Frontpage Databases

Forum FAQ' s

Developers Edition Spooky Login User Registration and Management tool

Personalized Frontpage Hosting

(in reply to walrus)


walrus Posts: 554 Joined: 3/13/2003 From: London Status: offline	RE: Loged in user DRW stuff - 3/21/2003 17:14:22 Yes _____________________________ I hope The Boss isn't reading this, ...she thinks I program everything! (in reply to Spooky)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Loged in user DRW stuff - 3/21/2003 22:54:48 Sweet? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to walrus)


walrus Posts: 554 Joined: 3/13/2003 From: London Status: offline	RE: Loged in user DRW stuff - 3/22/2003 3:51:00 Spooky, Is it right that the user is identified by this... " <%=Session(" Username" )%>" ..in a form and your post for the DRW is... ' " &Session(" Username" )&" ' ... which I have copied to the SQL statment but it doesn' t pick up the User, although it does verify ok. I am using this on a new page, not one of yours. Should I be including any files at the top of the page? If I look at this statement in html view it reads fp_sQry=" SELECT * FROM Results WHERE Username=' " " &Session(" " Username" " )&" " ' " which seems odd. Please help me to get this working. Thanks < Message edited by walrus -- 3/23/2003 4:07 AM > _____________________________ I hope The Boss isn't reading this, ...she thinks I program everything! (in reply to Spooky)