Using a Session Variable in DRW (Full Version)

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



Message

SerenityNet -> Using a Session Variable in DRW (1/25/2002 1:24:25)

Hi,

I've got a session variable called "account" that I'm successfully passing between my pages. I have no problem capturing it (by using <%=session("account")%> ) and using it in forms posting to different database tables. However, I'm having ZERO success in using it as criteria to constrain database results.

While in the DRW, I select "Custom Query" and have input:
SELECT firstname, lastname, telephone, emailaddress, additional
FROM UserData
ORDER BY lastname ASC,firstname ASC

The above works fine, but it is not constrained by the "account" session variable. I want to return only DB records where account = session(account). I've tried all sorts of ways to enter this, without success.

I need help!!!

Thanks in advance,
Andrew


Andrew<BR>webmaster@serenitynet.net<BR> - - - - - - - - - - - - <BR>"But the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness, and self-control..." Gal. 5:22



Spooky -> RE: Using a Session Variable in DRW (1/25/2002 15:43:44)

It will have to be a dieted DRW using :

SELECT firstname, lastname, telephone, emailaddress, additional
FROM UserData WHERE Account='"&Session("Account")&"'
ORDER BY lastname ASC,firstname ASC

This query can only be set in the red page code (no wizard)

§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login



whitec00 -> RE: Using a Session Variable in DRW (1/25/2002 21:32:06)

Spooky, it never fails for me. I do exactly as you say, but I always get some type of error.
The diet works fine, but the session variable parameter is not working. I get this error code:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'username='.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers
I want to personalize the page by pulling the username's actual first name.
Here is my statement...what am I doing wrong here???
fp_sQry="SELECT * FROM user WHERE username="'&Session("username")&'"



SerenityNet -> RE: Using a Session Variable in DRW (1/25/2002 21:53:37)

Spooky,

Thank you so much. The diet did the trick. It's now lean and mean.

But maybe too lean and mean. I used to be able to have the "additional" field display as HTML code. Now it doesn't and I really want it to do that. Is there a way to have the field display HTML in its new lean version?

WhiteC00
I've pasted my working code below, if it helps.


<table>
<tbody>
<!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT firstname, lastname, telephone, emailaddress, additional FROM UserData WHERE account='"&Session("Account")&"' ORDER BY lastname ASC,firstname ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=5 align=left width=""100%""></td></tr>"
fp_sDataConn="kit"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=5
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<tr>
<td>
<b><br><%=FP_FieldVal(fp_rs,"firstname")%>  <%=FP_FieldVal(fp_rs,"lastname")%></b><br>
<%=FP_FieldVal(fp_rs,"telephone")%><br>
<%=FP_FieldVal(fp_rs,"emailaddress")%><br>
<%=FP_Field(fp_rs,"additional")%><br><br>
</td>
</tr>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>

Andrew<BR>webmaster@serenitynet.net<BR> - - - - - - - - - - - - <BR>"But the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness, and self-control..." Gal. 5:22



Spooky -> RE: Using a Session Variable in DRW (1/26/2002 16:51:09)

When you say "display html" do you mean have your text formatted with html , or show the raw code like <b>text</b>?

<%=FP_Field(fp_rs,"additional")%> should send the code to the page with no formating whatsoever. ie youd get text





§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login



Spooky -> RE: Using a Session Variable in DRW (1/26/2002 16:53:08)

WhiteC00 - your qoutess are around the wrong way :)

fp_sQry="SELECT * FROM user WHERE username= ' " &Session("username")& " ' "

The spaces are for clarity only!



§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login



whitec00 -> RE: Using a Session Variable in DRW (1/26/2002 16:59:29)

The smallest details need to be emphasized in my brain somehow.... The problem was that I needed a closing quote after the last quote in the script. It works now. Thanks !!!!

Where's the "any" key?



SerenityNet -> RE: Using a Session Variable in DRW (1/26/2002 17:23:39)

Thanks everyone.

RE: "Display HTML"
Yes, I meant and want to show text formatted by HTML code. I don't want the tags displayed or printed.

Thanks,
Andrew

Andrew
webmaster@serenitynet.netBut the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness, and self-control..." Gal. 5:22



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625