Displaying reults without pushing search

G

Guest

Hi,

I have My follow up section in my website, where employees will click to see
if they have any follows up. Currently, they would go that section, their
name is autopopulated in a text box, so they will just hit search and will
show their follows up.

Is there anyway, that when they go to My follow up, it will automatically
show the results, without hittting submit?

Any help will be greatly appreciated :)

Thanks,

Shikha
 
T

Thomas A. Rowe

The person would have to have been logged in via a server-side script and database, then based on
their session you can then query the database for additional content related to the current logged
in person.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================
 
G

Guest

Hi Thomas,

Thank you so much for replying. Sorry I am not too sure about server-side
script? Currently when the employees log in, a new session is created, and
their user is name is stored. When they go to my follow ups, thier user id
is alreayd there using <% =Session("UID") %>. But I just don't want them to
hit search, I want the query to display result automaticallly....

Thanks,

shikha
 
T

Thomas A. Rowe

Then you will have to write a script that takes their store UID and then does a automatic query
based on the UID as soon as they hit the page.


--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================
 
G

Guest

Thomas,

Any hints on how to do it auotmatic? I already have a query which works
fine, but employees have to hit the Search button. I am trying to delete hte
search button all together.

Thanks

Shikha
 
T

Thomas A. Rowe

Paste you current query that is using the search button here

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================
 
G

Guest

Hi Thomas,

I am including the code for that file.

thank you soooooooo much :) :)

<% @language="vbscript" %>
<!--#include file="./fpdb/logon.inc"-->
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:blush:="urn:schemas-microsoft-com:blush:ffice:blush:ffice"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

<title>Follow Up Page</title>
<link rel="File-List" href="follow_up_dat2_files/filelist.xml">

<!--[if !mso]>
<style>
v\:* { behavior: url(#default#VML) }
o\:* { behavior: url(#default#VML) }
..shape { behavior: url(#default#VML) }
</style>
<![endif]-->
<meta name="Microsoft Theme" content="studio 010">
<!--[if gte mso 9]>
<xml><o:shapedefaults v:ext="edit" spidmax="1027"/>
</xml><![endif]-->
</head>

<body onload="document.forms[0].Associate_Name.focus();">



<div style="border-style: solid; border-width: 3; width:930; height:384">
<form BOTID="0" METHOD="POST" ACTION="follow_up_dat2.asp">
<table width="100%" align=left bgcolor="#A4A4FF" style="border-collapse:
collapse" cellpadding="0" cellspacing="0" height="27">



<tr>
<td width="55%" bgcolor="#0000FF" height="27">
<p align="right"><span style="position: absolute; left: 13; top:
18"> <img border="0" src="bell.gif" width="120" height="53"></span><font
size="5" color="#FFFFFF" face="Times New Roman"><b>FOLLOW
UP PAGE</b></font></td>
<td width="45%" align=right height="27" bgcolor="#0000FF"><table>
<tr>
<td><font color="#66FFFF"> </font><font color="#FF0000"><font
color="#66FFFF">Follow
Up | </font><a href="secure.asp">
<font color="#66FFFF">Search</font></a></font><font color="#66FFFF">
<u>|</u> </font> <font color="#FF0000">
<u><a href="submission_form_validationblue1.asp"><font color="#66FFFF">
Escalation Form</font></a></u><font color="#66FFFF"> |
<u><a href="Logoutpage.asp"><font color="#66FFFF">Log
Out</font></a></u></font> </font>

</td>
</tr>
</table></td>
</tr>
</table>
<p> </p>
<hr>
<p>
</p>
<table BORDER="0">
<tr>
<td><b> <font color="#0000FF">
<font face="Bell MT">Associate Name: </font></font></b><nobr><input
type="text" name="Associate_Name" size="20" value="<% =Session("UID")
%>"></nobr><b><font color="#A4A4FF"> </font></b></td>
<td><nobr>
<!--webbot bot="DatabaseRegionStart" s-columnnames="Associate_Name"
s-columntypes="202" s-dataconnection="database1" b-tableformat="FALSE"
b-menuformat="TRUE" s-menuchoice="Associate_Name"
s-menuvalue="Associate_Name" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="TRUE" s-recordsource
s-displaycolumns="Associate_Name" s-criteria s-order s-sql="SELECT DISTINCT
Associate_Name FROM Results" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="0" botid="1" u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" preview="
<span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> " startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT DISTINCT Associate_Name FROM Results"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Associate_Name"
fp_sMenuValue="Associate_Name"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=1
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="12026"
--><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> " startspan --><!--webbot
bot="DatabaseRegionEnd" endspan --></nobr></td>
</tr>
</table>
<p align="center"><!--[if gte vml 1]><v:shapetype id="_x0000_t86"
coordsize="21600,21600" o:spt="86" adj="1800"
path="m,qx21600@0l21600@1qy,21600e"
filled="f">
<v:formulas>
<v:f eqn="val #0"/>
<v:f eqn="sum 21600 0 #0"/>
<v:f eqn="prod #0 9598 32768"/>
<v:f eqn="sum 21600 0 @2"/>
</v:formulas>
<v:path arrowok="t" gradientshapeok="t" o:connecttype="custom"
o:connectlocs="0,0;0,21600;21600,10800"
textboxrect="0,@2,15274,@3"/>
<v:handles>
<v:h position="bottomRight,#0" yrange="0,10800"/>
</v:handles>
</v:shapetype><v:shape id="_x0000_s1029" type="#_x0000_t86" alt=""
style='position:absolute;
left:306pt;top:72.75pt;width:6.75pt;height:51.75pt;z-index:1'
filled="t"/><![endif]--><![if !vml]><span
style='mso-ignore:vglayout;position:absolute;z-index:1;left:407px;top:96px;
width:11px;height:71px'><img width=11 height=71
src="follow_up_dat2_files/image001.gif"
v:shapes="_x0000_s1029"></span><![endif]><br>
<!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" "
startspan --><!--webbot bot="SaveAsASP" endspan --><!--[if gte vml 1]><v:rect
id="_x0000_s1027" alt="" style='position:absolute;left:9.75pt;top:134.25pt;
width:726.75pt;height:24pt;z-index:-1' fillcolor="blue" strokecolor="blue">
<v:fill rotate="t" angle="-90" focus="100%" type="gradient"/>
</v:rect><![endif]--><![if !vml]><span style='mso-ignore:vglayout;position:
absolute;z-index:-1;left:12px;top:178px;width:971px;height:34px'><img
width=971 height=34 src="follow_up_dat2_files/image002.gif"
v:shapes="_x0000_s1027"></span><![endif]>
<input TYPE="submit" value="Search"></p>
<hr>
<p> </p>

</form>
<table width="996" border="1" height="107" style="border-collapse:
collapse" cellpadding="0" cellspacing="0">
<thead>
<tr>
<td width="62" bgcolor="#0000FF" height="16">
<font color="#FFFFFF" face="Georgia" size="2"><b>ID</b></font></td>
<td width="149" bgcolor="#0000FF" height="16">
<font color="#FFFFFF" face="Georgia" size="2"><b>
Associate Name</b></font></td>
<td width="118" bgcolor="#0000FF" height="16">
<font color="#FFFFFF" face="Georgia" size="2"><b>
Circuit #</b></font></td>
<td width="148" bgcolor="#0000FF" height="16">
<font color="#FFFFFF" face="Georgia" size="2"><b>
Telephone #</b></font></td>
<td width="109" bgcolor="#0000FF" height="16">
<font color="#FFFFFF" face="Georgia" size="2"><b>
Date & Time</b></font></td>
<td width="74" bgcolor="#0000FF" height="16">
<font color="#FFFFFF" face="Georgia" size="2"><b>Unit</b></font></td>
<td width="71" bgcolor="#0000FF" height="16">
<font color="#FFFFFF" face="Georgia" size="2"><b>Type</b></font></td>
<td width="81" bgcolor="#0000FF" height="16">
<font color="#FFFFFF" face="Georgia"
size="2"><b>Status</b></font></td>
<td width="136" bgcolor="#0000FF" height="16">
<font color="#FFFFFF" face="Georgia" size="2"><b>
Follow Up Date</b></font></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,203,202,202,202,202,202,202,202,135"
s-dataconnection="database1" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="TRUE" s-recordsource="Results"
s-displaycolumns="ID,Associate_Name,PEIN,Circuit_Num,Telephone_Num,Date_Time,Unit,Type,Status,Follow_Up_Date"
s-criteria="[Name] EQ {Associate_Name} + [Follow_Up_Date] NEQ [] | [
] EQ {Associate_Name} + [Status] EQ [Open] | [Associate_Name] EQ
[Refer_To] +" s-order s-sql="SELECT * FROM Results WHERE (Associate_Name =
'::Associate_Name::' AND Follow_Up_Date &lt;&gt; '' OR Associate_Name =
'::Associate_Name::' AND Status = 'Open' OR Associate_Name = 'Refer_To')"
b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="Associate_Name=&amp;Associate_Name=" s-norecordsfound="No
records returned." i-maxrecords="256" i-groupsize="0" botid="0"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td
colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font
color="#000000">This is the start of a Database Results region. The page must
be fetched from a web server with a web browser to display correctly; the
current web is stored on your local disk or network.</font></td></tr>"
b-WasTableFormat="TRUE" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Results WHERE (Associate_Name = '::Associate_Name::'
AND Follow_Up_Date <> '' OR Associate_Name = '::Associate_Name::' AND
Status = 'Open' OR Associate_Name = 'Refer_To')"
fp_sDefault="Associate_Name=&Associate_Name="
fp_sNoRecords="<tr><td colspan=10 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_iDisplayCols=10
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="26959" --><tr>
<td width="62" height="16"><b><font face="Verdana" size="2"
color="#0000FF">
<a target="_blank"
href="Update_Form.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>">
<font color="#FF0000">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-column="ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ID<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn" endspan
i-checksum="62813" --></font></a></font></b></td>
<td width="149" height="16"><font face="Verdana" size="2"
color="#0000FF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-column="Associate_Name" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>Associate_Name<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"Associate_Name")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="41158" --></font></td>
<td width="118" height="16"><font face="Verdana" size="2"
color="#0000FF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-column="Circuit_Num" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>Circuit_Num<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"Circuit_Num")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28982" --></font></td>
<td width="148" height="16"><font face="Verdana" size="2"
color="#0000FF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-column="Telephone_Num" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>Telephone_Num<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"Telephone_Num")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="33783" --></font></td>
<td width="109" height="16"><font face="Verdana" size="2"
color="#0000FF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-column="Date_Time" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>Date_Time<font size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Date_Time")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="17626" --></font></td>
<td width="74" height="16"><font face="Verdana" size="2"
color="#0000FF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-column="Unit" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Unit<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Unit")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="6038" --></font></td>
<td width="71" height="16"><font face="Verdana" size="2"
color="#0000FF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-column="Type" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Type<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Type")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7359" --></font></td>
<td width="81" height="16"><font face="Verdana" size="2"
color="#0000FF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-column="Status" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Status<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Status")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="17178" --></font></td>
<td width="136" height="16"><font face="Verdana" size="2"
color="#0000FF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
s-column="Follow_Up_Date" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="<font
size="-1">&lt;&lt;</font>Follow_Up_Date<font size="-1">&gt;&gt;</font>"
startspan --><%=FP_FieldVal(fp_rs,"Follow_Up_Date")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="40811" --></font></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
align="left" width="100%"><font color="#000000">This is the end of a Database
Results region.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>
</div>
 
S

Stefan B Rusynko

You are using the DBRW and not writing your own ASP code
for some tips on using it see
http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi Thomas,
|
| I am including the code for that file.
|
| thank you soooooooo much :) :)
|
| <% @language="vbscript" %>
| <!--#include file="./fpdb/logon.inc"-->
| <html xmlns:v="urn:schemas-microsoft-com:vml"
| xmlns:blush:="urn:schemas-microsoft-com:blush:ffice:blush:ffice"
| xmlns="http://www.w3.org/TR/REC-html40">
|
| <head>
| <meta name="GENERATOR" content="Microsoft FrontPage 5.0">
| <meta name="ProgId" content="FrontPage.Editor.Document">
| <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
| Edit.
| FP_CharSet = "windows-1252"
| FP_CodePage = 1252 %>
| <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
|
| <title>Follow Up Page</title>
| <link rel="File-List" href="follow_up_dat2_files/filelist.xml">
|
| <!--[if !mso]>
| <style>
| v\:* { behavior: url(#default#VML) }
| o\:* { behavior: url(#default#VML) }
| .shape { behavior: url(#default#VML) }
| </style>
| <![endif]-->
| <meta name="Microsoft Theme" content="studio 010">
| <!--[if gte mso 9]>
| <xml><o:shapedefaults v:ext="edit" spidmax="1027"/>
| </xml><![endif]-->
| </head>
|
| <body onload="document.forms[0].Associate_Name.focus();">
|
|
|
| <div style="border-style: solid; border-width: 3; width:930; height:384">
| <form BOTID="0" METHOD="POST" ACTION="follow_up_dat2.asp">
| <table width="100%" align=left bgcolor="#A4A4FF" style="border-collapse:
| collapse" cellpadding="0" cellspacing="0" height="27">
|
|
|
| <tr>
| <td width="55%" bgcolor="#0000FF" height="27">
| <p align="right"><span style="position: absolute; left: 13; top:
| 18"> <img border="0" src="bell.gif" width="120" height="53"></span><font
| size="5" color="#FFFFFF" face="Times New Roman"><b>FOLLOW
| UP PAGE</b></font></td>
| <td width="45%" align=right height="27" bgcolor="#0000FF"><table>
| <tr>
| <td><font color="#66FFFF"> </font><font color="#FF0000"><font
| color="#66FFFF">Follow
| Up | </font><a href="secure.asp">
| <font color="#66FFFF">Search</font></a></font><font color="#66FFFF">
| <u>|</u> </font> <font color="#FF0000">
| <u><a href="submission_form_validationblue1.asp"><font color="#66FFFF">
| Escalation Form</font></a></u><font color="#66FFFF"> |
| <u><a href="Logoutpage.asp"><font color="#66FFFF">Log
| Out</font></a></u></font> </font>
|
| </td>
| </tr>
| </table></td>
| </tr>
| </table>
| <p> </p>
| <hr>
| <p>
| </p>
| <table BORDER="0">
| <tr>
| <td><b> <font color="#0000FF">
| <font face="Bell MT">Associate Name: </font></font></b><nobr><input
| type="text" name="Associate_Name" size="20" value="<% =Session("UID")
| %>"></nobr><b><font color="#A4A4FF"> </font></b></td>
| <td><nobr>
| <!--webbot bot="DatabaseRegionStart" s-columnnames="Associate_Name"
| s-columntypes="202" s-dataconnection="database1" b-tableformat="FALSE"
| b-menuformat="TRUE" s-menuchoice="Associate_Name"
| s-menuvalue="Associate_Name" b-tableborder="TRUE" b-tableexpand="TRUE"
| b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| i-listformat="0" b-makeform="TRUE" s-recordsource
| s-displaycolumns="Associate_Name" s-criteria s-order s-sql="SELECT DISTINCT
| Associate_Name FROM Results" b-procedure="FALSE" clientside
| suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
| i-maxrecords="256" i-groupsize="0" botid="1" u-dblib="_fpclass/fpdblib.inc"
| u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" preview="
| <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> " startspan --><!--#include
| file="_fpclass/fpdblib.inc"-->
| <% if 0 then %>
| <SCRIPT Language="JavaScript">
| document.write("<div style='background: yellow; color: black;'>The Database
| Results component on this page is unable to display database content. The
| page must have a filename ending in '.asp', and the web must be hosted on a
| server that supports Active Server Pages.</div>");
| </SCRIPT>
| <% end if %>
| <%
| fp_sQry="SELECT DISTINCT Associate_Name FROM Results"
| fp_sDefault=""
| fp_sNoRecords="No records returned."
| fp_sDataConn="database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="Associate_Name"
| fp_sMenuValue="Associate_Name"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=1
| fp_iRegion=BOTID
| %>
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="12026"
| --><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
| b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
| clientside preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> " startspan --><!--webbot
| bot="DatabaseRegionEnd" endspan --></nobr></td>
| </tr>
| </table>
| <p align="center"><!--[if gte vml 1]><v:shapetype id="_x0000_t86"
| coordsize="21600,21600" o:spt="86" adj="1800"
| path="m,qx21600@0l21600@1qy,21600e"
| filled="f">
| <v:formulas>
| <v:f eqn="val #0"/>
| <v:f eqn="sum 21600 0 #0"/>
| <v:f eqn="prod #0 9598 32768"/>
| <v:f eqn="sum 21600 0 @2"/>
| </v:formulas>
| <v:path arrowok="t" gradientshapeok="t" o:connecttype="custom"
| o:connectlocs="0,0;0,21600;21600,10800"
| textboxrect="0,@2,15274,@3"/>
| <v:handles>
| <v:h position="bottomRight,#0" yrange="0,10800"/>
| </v:handles>
| </v:shapetype><v:shape id="_x0000_s1029" type="#_x0000_t86" alt=""
| style='position:absolute;
| left:306pt;top:72.75pt;width:6.75pt;height:51.75pt;z-index:1'
| filled="t"/><![endif]--><![if !vml]><span
| style='mso-ignore:vglayout;position:absolute;z-index:1;left:407px;top:96px;
| width:11px;height:71px'><img width=11 height=71
| src="follow_up_dat2_files/image001.gif"
| v:shapes="_x0000_s1029"></span><![endif]><br>
| <!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" "
| startspan --><!--webbot bot="SaveAsASP" endspan --><!--[if gte vml 1]><v:rect
| id="_x0000_s1027" alt="" style='position:absolute;left:9.75pt;top:134.25pt;
| width:726.75pt;height:24pt;z-index:-1' fillcolor="blue" strokecolor="blue">
| <v:fill rotate="t" angle="-90" focus="100%" type="gradient"/>
| </v:rect><![endif]--><![if !vml]><span style='mso-ignore:vglayout;position:
| absolute;z-index:-1;left:12px;top:178px;width:971px;height:34px'><img
| width=971 height=34 src="follow_up_dat2_files/image002.gif"
| v:shapes="_x0000_s1027"></span><![endif]>
| <input TYPE="submit" value="Search"></p>
| <hr>
| <p> </p>
|
| </form>
| <table width="996" border="1" height="107" style="border-collapse:
| collapse" cellpadding="0" cellspacing="0">
| <thead>
| <tr>
| <td width="62" bgcolor="#0000FF" height="16">
| <font color="#FFFFFF" face="Georgia" size="2"><b>ID</b></font></td>
| <td width="149" bgcolor="#0000FF" height="16">
| <font color="#FFFFFF" face="Georgia" size="2"><b>
| Associate Name</b></font></td>
| <td width="118" bgcolor="#0000FF" height="16">
| <font color="#FFFFFF" face="Georgia" size="2"><b>
| Circuit #</b></font></td>
| <td width="148" bgcolor="#0000FF" height="16">
| <font color="#FFFFFF" face="Georgia" size="2"><b>
| Telephone #</b></font></td>
| <td width="109" bgcolor="#0000FF" height="16">
| <font color="#FFFFFF" face="Georgia" size="2"><b>
| Date & Time</b></font></td>
| <td width="74" bgcolor="#0000FF" height="16">
| <font color="#FFFFFF" face="Georgia" size="2"><b>Unit</b></font></td>
| <td width="71" bgcolor="#0000FF" height="16">
| <font color="#FFFFFF" face="Georgia" size="2"><b>Type</b></font></td>
| <td width="81" bgcolor="#0000FF" height="16">
| <font color="#FFFFFF" face="Georgia"
| size="2"><b>Status</b></font></td>
| <td width="136" bgcolor="#0000FF" height="16">
| <font color="#FFFFFF" face="Georgia" size="2"><b>
| Follow Up Date</b></font></td>
| </tr>
| </thead>
| <tbody>
| <!--webbot bot="DatabaseRegionStart"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,203,202,202,202,202,202,202,202,135"
| s-dataconnection="database1" b-tableformat="TRUE" b-menuformat="FALSE"
| s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE"
| b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| i-listformat="0" b-makeform="TRUE" s-recordsource="Results"
| s-displaycolumns="ID,Associate_Name,PEIN,Circuit_Num,Telephone_Num,Date_Time,Unit,Type,Status,Follow_Up_Date"
| s-criteria="[Name] EQ {Associate_Name} + [Follow_Up_Date] NEQ [] | [
| ] EQ {Associate_Name} + [Status] EQ [Open] | [Associate_Name] EQ
| [Refer_To] +" s-order s-sql="SELECT * FROM Results WHERE (Associate_Name =
| '::Associate_Name::' AND Follow_Up_Date &lt;&gt; '' OR Associate_Name =
| '::Associate_Name::' AND Status = 'Open' OR Associate_Name = 'Refer_To')"
| b-procedure="FALSE" clientside suggestedext="asp"
| s-defaultfields="Associate_Name=&amp;Associate_Name=" s-norecordsfound="No
| records returned." i-maxrecords="256" i-groupsize="0" botid="0"
| u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| u-dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td
| colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font
| color="#000000">This is the start of a Database Results region. The page must
| be fetched from a web server with a web browser to display correctly; the
| current web is stored on your local disk or network.</font></td></tr>"
| b-WasTableFormat="TRUE" startspan --><!--#include
| file="_fpclass/fpdblib.inc"-->
| <% if 0 then %>
| <SCRIPT Language="JavaScript">
| document.write("<div style='background: yellow; color: black;'>The Database
| Results component on this page is unable to display database content. The
| page must have a filename ending in '.asp', and the web must be hosted on a
| server that supports Active Server Pages.</div>");
| </SCRIPT>
| <% end if %>
| <%
| fp_sQry="SELECT * FROM Results WHERE (Associate_Name = '::Associate_Name::'
| AND Follow_Up_Date <> '' OR Associate_Name = '::Associate_Name::' AND
| Status = 'Open' OR Associate_Name = 'Refer_To')"
| fp_sDefault="Associate_Name=&Associate_Name="
| fp_sNoRecords="<tr><td colspan=10 align=left width=""100%"">No records
| returned.</td></tr>"
| fp_sDataConn="database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice="ID"
| fp_sMenuValue="ID"
| fp_iDisplayCols=10
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
| %>
| <!--#include file="_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="26959" --><tr>
| <td width="62" height="16"><b><font face="Verdana" size="2"
| color="#0000FF">
| <a target="_blank"
| href="Update_Form.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>">
| <font color="#FF0000">
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-column="ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ID<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn" endspan
| i-checksum="62813" --></font></a></font></b></td>
| <td width="149" height="16"><font face="Verdana" size="2"
| color="#0000FF">
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-column="Associate_Name" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="<font
| size="-1">&lt;&lt;</font>Associate_Name<font size="-1">&gt;&gt;</font>"
| startspan --><%=FP_FieldVal(fp_rs,"Associate_Name")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="41158" --></font></td>
| <td width="118" height="16"><font face="Verdana" size="2"
| color="#0000FF">
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-column="Circuit_Num" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="<font
| size="-1">&lt;&lt;</font>Circuit_Num<font size="-1">&gt;&gt;</font>"
| startspan --><%=FP_FieldVal(fp_rs,"Circuit_Num")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="28982" --></font></td>
| <td width="148" height="16"><font face="Verdana" size="2"
| color="#0000FF">
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-column="Telephone_Num" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="<font
| size="-1">&lt;&lt;</font>Telephone_Num<font size="-1">&gt;&gt;</font>"
| startspan --><%=FP_FieldVal(fp_rs,"Telephone_Num")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="33783" --></font></td>
| <td width="109" height="16"><font face="Verdana" size="2"
| color="#0000FF">
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-column="Date_Time" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="<font
| size="-1">&lt;&lt;</font>Date_Time<font size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Date_Time")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="17626" --></font></td>
| <td width="74" height="16"><font face="Verdana" size="2"
| color="#0000FF">
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-column="Unit" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Unit<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Unit")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="6038" --></font></td>
| <td width="71" height="16"><font face="Verdana" size="2"
| color="#0000FF">
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-column="Type" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Type<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Type")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="7359" --></font></td>
| <td width="81" height="16"><font face="Verdana" size="2"
| color="#0000FF">
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-column="Status" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Status<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Status")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="17178" --></font></td>
| <td width="136" height="16"><font face="Verdana" size="2"
| color="#0000FF">
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Associate_Name,PEIN,Associate_Tel,Date_Time,Unit,Type,Status,Circuit_Num,Telephone_Num,CLEC,Bell,Contact_Name,Contact_Num,FOC_RAP,Order_Type,Customer_Comments,Primary_Category,Secondary_Category,Tertiary_Category,Call_Notes,Justified_Call,Repeat_Call,Follow_Up_Date,Refer_To,Remote_computer_name,User_name,Browser_type,Timestamp"
| s-column="Follow_Up_Date" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="<font
| size="-1">&lt;&lt;</font>Follow_Up_Date<font size="-1">&gt;&gt;</font>"
| startspan --><%=FP_FieldVal(fp_rs,"Follow_Up_Date")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="40811" --></font></td>
| </tr>
| <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
| b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
| clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
| align="left" width="100%"><font color="#000000">This is the end of a Database
| Results region.</font></td></tr>" startspan --><!--#include
| file="_fpclass/fpdbrgn2.inc"-->
| <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
| </table>
| </div>
|
|
| "Thomas A. Rowe" wrote:
|
| > Paste you current query that is using the search button here
| >
| > --
| > ==============================================
| > Thomas A. Rowe
| > Microsoft MVP - FrontPage
| > ==============================================
| > Agents Real Estate Listing Network
| > http://www.NReal.com
| > ==============================================
| >
| >
| > | > > Thomas,
| > >
| > > Any hints on how to do it auotmatic? I already have a query which works
| > > fine, but employees have to hit the Search button. I am trying to delete hte
| > > search button all together.
| > >
| > > Thanks
| > >
| > > Shikha
| > >
| > > "Thomas A. Rowe" wrote:
| > >
| > >> Then you will have to write a script that takes their store UID and then does a automatic query
| > >> based on the UID as soon as they hit the page.
| > >>
| > >>
| > >> --
| > >> ==============================================
| > >> Thomas A. Rowe
| > >> Microsoft MVP - FrontPage
| > >> ==============================================
| > >> Agents Real Estate Listing Network
| > >> http://www.NReal.com
| > >> ==============================================
| > >>
| > >>
| > >> | > >> > Hi Thomas,
| > >> >
| > >> > Thank you so much for replying. Sorry I am not too sure about server-side
| > >> > script? Currently when the employees log in, a new session is created, and
| > >> > their user is name is stored. When they go to my follow ups, thier user id
| > >> > is alreayd there using <% =Session("UID") %>. But I just don't want them to
| > >> > hit search, I want the query to display result automaticallly....
| > >> >
| > >> > Thanks,
| > >> >
| > >> > shikha
| > >> >
| > >> > "Thomas A. Rowe" wrote:
| > >> >
| > >> >> The person would have to have been logged in via a server-side script and database, then based
| > >> >> on
| > >> >> their session you can then query the database for additional content related to the current
| > >> >> logged
| > >> >> in person.
| > >> >>
| > >> >> --
| > >> >> ==============================================
| > >> >> Thomas A. Rowe
| > >> >> Microsoft MVP - FrontPage
| > >> >> ==============================================
| > >> >> Agents Real Estate Listing Network
| > >> >> http://www.NReal.com
| > >> >> ==============================================
| > >> >>
| > >> >>
| > >> >> | > >> >> > Hi,
| > >> >> >
| > >> >> > I have My follow up section in my website, where employees will click to see
| > >> >> > if they have any follows up. Currently, they would go that section, their
| > >> >> > name is autopopulated in a text box, so they will just hit search and will
| > >> >> > show their follows up.
| > >> >> >
| > >> >> > Is there anyway, that when they go to My follow up, it will automatically
| > >> >> > show the results, without hittting submit?
| > >> >> >
| > >> >> > Any help will be greatly appreciated :)
| > >> >> >
| > >> >> > Thanks,
| > >> >> >
| > >> >> > Shikha
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top