navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

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

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
 

Advanced search
Recent Posts

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

Microsoft MVP

 

Passing a variable

 
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 >> Passing a variable 		Page: [1]
 
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		Passing a variable - 4/1/2005 14:10:15   
This may be simple to some of you but how can I pass a varialbe to a DRW page so that a database lookup can be done based on the variable being passed?

Example:

One page one a user will select from a drop down menu. Based on this selection I pass (via the web page line the IP field value (IP address) of the record to another page.

On this page I want to look up a record based on the field that was passed (IP Address) via a DRW.

So, how can I insert into the DRW a variable being passed from a different page? 

<html>
<head>
	<title></title>
</head>

<body bgcolor="white" text="black" link="blue" vlink="blue" alink="blue">

<FORM NAME="GetDev">
	<INPUT TYPE="hidden" NAME="DevInfo">
</FORM>

<SCRIPT LANGUAGE="javascript">
	var locate = window.location
	document.GetDev.DevInfo.value = locate

	var text = document.GetDev.DevInfo.value

	function IP1(str)
		{
			theleft = str.lastIndexOf("IP=") + 3;
			theright = str.lastIndexOf("IP=") + 6;
			return(str.substring(theleft, theright))
		}
	function IP2(str)
		{
			theleft = str.indexOf("IP=") + 3;
			return(str.substring(theleft, str.length))
		}
</SCRIPT>

<!--#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 DSLAMS WHERE (IP_Address =  <script language="javascript>IP2(text)</script>) ORDER BY IP_Address ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="DataNetworks"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="IP_Address"
fp_sMenuValue="IP_Address"
fp_sColTypes="&Type=202&Management=202&Shelf_Location=202&Remote=202&Shelf#=4&Circuit_ID=202&Pinged?=11&IP_Address=202&Shelf_Type=202&Term_CO=202&Term_CO_2=202&Term_Dev=202&Term_Shelf#=4&Transport=202&Intermapper_Location=202&Intmap=202&Alm=202&Model=202&Ver=202&Fan Iss=11&"
fp_iDisplayCols=20
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="20401" -->
				document.write("<font color=\"#0000FF\">City: </font><b><u>"+<%=FP_FieldHTML(fp_rs,"Shelf_Location")%>+"</u></b>"); 
				document.write("<font color=\"#0000FF\">Device Type: </font><b><u>"+<%=FP_FieldHTML(fp_rs,"Type")%>+"</u></b>");
				document.write("<font color=\"#0000FF\">IP:</font> <b><u><a>"+<%=FP_FieldHTML(fp_rs,"IP_Address")%>+"</a></u></b>"); 
<!--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 -->
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		RE: Passing a variable - 4/1/2005 14:19:58   
Is the variable coming from a hyperlink or from a form?

If from a form, and the form is posting to your page with teh sql, its simply SELECT * FROM table WHERE (fieldname='::selecteditem::')

If it is from a hyperlink, its SELECT * FROM table WHERE (fieldname=&request.querystring("whatever")&)

is that what your looking for?

(in reply to SirAldemar)
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		RE: Passing a variable - 4/1/2005 15:21:59   
Yes, this does help.

But how can I use the variables that the DRW from the second page produces outside of the database section? I want to be able to display certain fields in specific locations on my screen.

If I use <%=FP_FieldHTML(fp_rs,"Shelf_Location")%> it keeps telling me I need another file...

(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		RE: Passing a variable - 4/1/2005 15:34:50   
You will more than likely need to create a variable within the database section...

--include file 1
<%
variable=fp_field(fprs,"field1")
%>
--include file 2

then, you can call that variable anywhere on your page (as long as it is below the code it was created) like so:

The color of this screen is <%=variable%>. That will print whatever the value of variable is wherever you wish to have it printed.

(in reply to SirAldemar)
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		RE: Passing a variable - 4/1/2005 15:52:22   
quote:

You will more than likely need to create a variable within the database section...

--include file 1
<%
variable=fp_field(fprs,"field1")
%>
--include file 2


Thank you for the suggestions but this is not working. When I add...

<%Variable=fp_field(fprs,"field1")

and save the file, FP removes this information.

I next tried it by removing...

<!--webbot bot="DatabaseRegionStart" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-columntypes="202,202,202,202,4,202,11,202,202,202,202,202,4,202,202,202,202,202,202,11" s-dataconnection="DataNetworks" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="DSLAMS" s-displaycolumns="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-criteria="[IP_Address] EQ (IP2(text)) +" s-order="[IP_Address] +" s-sql="SELECT * FROM DSLAMS WHERE (IP_Address = (IP2(text))) ORDER BY IP_Address ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" 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" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan -->

When I saved the document it did not disappear but neither did it show up on the page when viewed.

Can you possible tell me what I am doing wrong?

(in reply to dzirkelb1)
rdouglass

 

Posts: 9187
From: Biddeford, ME USA
Status: offline

  		RE: Passing a variable - 4/1/2005 16:02:41   
quote:

and save the file, FP removes this information.


To prevent this from happening, you need to put the page on a Spooky Diet:

http://www.outfront.net/spooky/adv_drw_diet.htm

Just be sure to back it up first. :)

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to SirAldemar)
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		RE: Passing a variable - 4/1/2005 16:06:16   
Follow-up to my last comment:

I got the variable to stay in the DRW area now. But the Select statement seems no to be working. I did not notice this at first.


I use this code to get the information from the hyperlink and it is working just fine. 
<FORM NAME="GetDev">
	<INPUT TYPE="hidden" NAME="DevInfo">
</FORM>

<SCRIPT LANGUAGE="javascript">
	var locate = window.location
	document.GetDev.DevInfo.value = locate

	var text = document.GetDev.DevInfo.value

	function IP1(str)
		{
			theleft = str.lastIndexOf("IP=") + 3;
			theright = str.lastIndexOf("IP=") + 6;
			return(str.substring(theleft, theright))
		}
	function IP2(str)
		{
			theleft = str.indexOf("IP=") + 3;
			return(str.substring(theleft, str.length))
		}
</SCRIPT>


This is what I changed in the DRW to account for the code from above. 

fp_sQry="SELECT * FROM DSLAMS WHERE (IP_Address =  (IP2(text))) ORDER BY IP_Address ASC"


Any more thoughts on this?

(in reply to SirAldemar)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		RE: Passing a variable - 4/1/2005 16:13:29   
The drw changed your sql (it does that when goign to the diet)...change it to:

fp_sQry="SELECT * FROM DSLAMS WHERE (IP_Address = (IP2(text)) ORDER BY IP_Address ASC"

it seemed to add a )

see if that works, if it doesn't, type:

<%=fp_sQry%>
before your include file 1 and copy / paste what is printed to the screen




(in reply to SirAldemar)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		RE: Passing a variable - 4/1/2005 16:14:11   
also, post the whole drw region if you could from include file to include file 2

(in reply to dzirkelb1)
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		RE: Passing a variable - 4/1/2005 16:22:58    
		<!--webbot bot="DatabaseRegionStart" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-columntypes="202,202,202,202,4,202,11,202,202,202,202,202,4,202,202,202,202,202,202,11" s-dataconnection="DataNetworks" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="DSLAMS" s-displaycolumns="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-criteria="[IP_Address] EQ (IP2(text)) +" s-order="[IP_Address] +" s-sql="SELECT * FROM DSLAMS WHERE (IP_Address =  (IP2(text))) ORDER BY IP_Address ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" 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" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" 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 DSLAMS WHERE (IP_Address =  (IP2(text))) ORDER BY IP_Address ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=20 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="DataNetworks"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Type=202&Management=202&Shelf_Location=202&Remote=202&Shelf_Num=4&Circuit_ID=202&Pinged?=11&IP_Address=202&Shelf_Type=202&Term_CO=202&Term_CO_2=202&Term_Dev=202&Term_Shelf#=4&Transport=202&Intermapper_Location=202&Intmap=202&Alm=202&Model=202&Ver=202&Fan Iss=11&"
fp_iDisplayCols=20
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="19061" --><tr>
<%
Type1=FP_FieldVal(fp_rs,"Type")
%>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" 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" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Management" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Management<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Management")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29633" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Shelf_Location" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Shelf_Location<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Shelf_Location")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="40580" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Remote" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Remote<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Remote")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15080" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Shelf_Num" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Shelf_Num<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Shelf_Num")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="19933" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Circuit_ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Circuit_ID<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Circuit_ID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21521" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Pinged?" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Pinged?<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Pinged?")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12739" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="IP_Address" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>IP_Address<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"IP_Address")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="27374" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Shelf_Type" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Shelf_Type<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Shelf_Type")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29322" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Term_CO" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Term_CO<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Term_CO")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12467" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Term_CO_2" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Term_CO_2<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Term_CO_2")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14912" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Term_Dev" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Term_Dev<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Term_Dev")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15678" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Term_Shelf#" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Term_Shelf#<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Term_Shelf#")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29240" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Transport" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Transport<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Transport")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="22345" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Intermapper_Location" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Intermapper_Location<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Intermapper_Location")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="59190" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Intmap" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Intmap<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Intmap")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15671" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Alm" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Alm<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Alm")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="2754" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Model" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Model<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Model")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="9091" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Ver" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Ver<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Ver")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3207" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Type,Management,Shelf_Location,Remote,Shelf_Num,Circuit_ID,Pinged?,IP_Address,Shelf_Type,Term_CO,Term_CO_2,Term_Dev,Term_Shelf#,Transport,Intermapper_Location,Intmap,Alm,Model,Ver,Fan Iss" s-column="Fan Iss" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Fan Iss<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Fan Iss")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="11773" --></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" 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>

(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		RE: Passing a variable - 4/1/2005 16:27:32   
Change the sql code above (remove the parenthees) and add <%=fp_sQry%> right after the include file1 and see what it displays please.

(in reply to SirAldemar)
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		RE: Passing a variable - 4/1/2005 16:38:57   
No worky....


Here are the changes I made (if I understood your notes correctly)...

(Note: This code has been put on a diet.... LOL) 
<body bgcolor="white" text="black" link="blue" vlink="blue" alink="blue">

<FORM NAME="GetDev">
	<INPUT TYPE="hidden" NAME="DevInfo">
</FORM>

<SCRIPT LANGUAGE="javascript">
	var locate = window.location
	document.GetDev.DevInfo.value = locate

	var text = document.GetDev.DevInfo.value

	function IP1(str)
		{
			theleft = str.lastIndexOf("IP=") + 3;
			theright = str.lastIndexOf("IP=") + 6;
			return(str.substring(theleft, theright))
		}
	function IP2(str)
		{
			theleft = str.indexOf("IP=") + 3;
			return(str.substring(theleft, str.length))
		}
</SCRIPT>

<SCRIPT LANGUAGE="javascript">
{
	document.write(IP1(text) + " - \"" + IP2(text) + "\""); 
}
</SCRIPT>				

<table width="100%" border="1">
<!--#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 DSLAMS WHERE (IP_Address = IP2(text)) ORDER BY IP_Address ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=20 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="DataNetworks"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Type=202&Management=202&Shelf_Location=202&Remote=202&Shelf_Num=4&Circuit_ID=202&Pinged?=11&IP_Address=202&Shelf_Type=202&Term_CO=202&Term_CO_2=202&Term_Dev=202&Term_Shelf#=4&Transport=202&Intermapper_Location=202&Intmap=202&Alm=202&Model=202&Ver=202&Fan Iss=11&"
fp_iDisplayCols=20
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<%=fp_sQry%>
<%
Type1=FP_FieldVal(fp_rs,"Type")
%>
		<tr>
			<td>
			<%=FP_FieldVal(fp_rs,"Type")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Management")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Shelf_Location")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Remote")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Shelf_Num")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Circuit_ID")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Pinged?")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"IP_Address")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Shelf_Type")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Term_CO")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Term_CO_2")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Term_Dev")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Term_Shelf#")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Transport")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Intermapper_Location")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Intmap")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Alm")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Model")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Ver")%></td>
			<td>
			<%=FP_FieldVal(fp_rs,"Fan Iss")%></td>
		</tr>
<!--#include file="_fpclass/fpdbrgn2.inc"-->
</table>

<center>

Did it work <%=Type1%>

(in reply to dzirkelb1)
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		RE: Passing a variable - 4/1/2005 16:49:53   
Follow-up:

I replaced the Query with the following and it worked great.... 

fp_sQry="SELECT * FROM DSLAMS WHERE (IP_Address =  '10.10.4.10') ORDER BY IP_Address ASC"


Now, how do I get the IP2(text) variable to work in the query?

(in reply to SirAldemar)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		RE: Passing a variable - 4/1/2005 16:57:54   
Does the page display an error with the code or does it display no results? If it displays no results, with the little bit of code added it should write out the sql statement on your screen...what does it say?

(in reply to SirAldemar)
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		RE: Passing a variable - 4/1/2005 17:02:06   
10. - "10.10.4.10"

Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.


Did it work

(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		RE: Passing a variable - 4/1/2005 17:03:35   
I'm not sure if this will work or not, but its my last guess :(

fp_sQry="SELECT * FROM DSLAMS WHERE (IP_Address = &IP2(text)&) ORDER BY IP_Address ASC"

I am not sure cause it is a javascript function varialbe we're trying to call...(which I just now figured out is what you've been trying to get the whole time...sorry!!!)

Give that a whirl, best of luck...if that doesnt' work, hopefully someone will have the answer here or try google for passing varibles from javascript to asp (I looked a little bit, but the office is closing down now)

hope it works!

(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		RE: Passing a variable - 4/1/2005 17:05:17   
For that problem, everyone suggests going to this link http://www.frontpagewebmaster.com/m-175524/tm.htm to find out what the true error is...(its a sticky at top of this forum)

(in reply to SirAldemar)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		RE: Passing a variable - 4/1/2005 17:10:21   
Ok, found something...not sure if its what you want to hear or not, but its this:

basically, can't call a clients side variable in asp (javascript to asp) unless its passed on a querysrting...so, somehow need to do a redirect to a new page with the javascript:

<%
response.redirect"page.asp?IP="<SCRIPT LANGUAGE="javascript">
var locate = window.location
document.GetDev.DevInfo.value = locate

var text = document.GetDev.DevInfo.value

function IP1(str)
{
theleft = str.lastIndexOf("IP=") + 3;
theright = str.lastIndexOf("IP=") + 6;
return(str.substring(theleft, theright))
}
function IP2(str)
{
theleft = str.indexOf("IP=") + 3;
return(str.substring(theleft, str.length))
}
</SCRIPT>%>

Now, I have absolutely no idea if that will work, but its a start

then, on the sql, it would be:

fp_sQry="SELECT * FROM DSLAMS WHERE (IP_Address = &request.querystring("IP")&) ORDER BY IP_Address ASC"

(I know the sql is correct, not sure on the link however)

The page I found that info is http://www.faqts.com/knowledge_base/view.phtml/aid/15755

(in reply to dzirkelb1)
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		RE: Passing a variable - 4/1/2005 17:12:14   
10. - "10.10.4.9"

Database Results Wizard Error
Description: Undefined function 'IP2' in expression.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine


Did it work

(in reply to dzirkelb1)
Spooky

 

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

  		RE: Passing a variable - 4/1/2005 21:07:58   
Whats the current code? it seems you are trying to use a client side script inside a server side script - it wont work.

_____________________________

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

§þ:)k¥


(in reply to SirAldemar)
SirAldemar

 

Posts: 111
Joined: 3/4/2004
Status: offline

  		RE: Passing a variable - 4/1/2005 21:59:45   
OK.

I now understand that I can't use server side variables with client side scripts or vice-a-versa.

How can I get the main page to pass a variable to my display page?

here is the code I am using on the main page: 
<script type="text/javascript" language="JavaScript">
	function OpenPage(ob) 
		{
			Variables = ob.options[ob.selectedIndex].value;

			window.open("status.html?"+Variables,'iFrame_Top');
			ob.selectedIndex = 0;
        }

</script>

</HEAD>

<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0">

<script language="javascript">
	window.open("iFrame01.html","main");
</script>

<p align="center">
<font size="5" color="#0000FF"><b>Devices by Location</b></font><br>

<!--#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 DSLAMS WHERE (Shelf_Location LIKE 'A%') ORDER BY Shelf_Location ASC,Remote ASC,Shelf_Num ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="DataNetworks"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Shelf_Location"
fp_sMenuValue="IP_Address"
fp_sColTypes="&Type=202&Management=202&Shelf_Location=202&Remote=202&Shelf_Num=4&Circuit_ID=202&Pinged?=11&IP_Address=202&Shelf_Type=202&Term_CO=202&Term_CO_2=202&Term_Dev=202&Term_Shelf#=4&Transport=202&Intermapper_Location=202&Intmap=202&Alm=202&Model=202&Ver=202&Fan Iss=11&"
fp_iDisplayCols=20
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="10000" -->
<select style="width:100%; font-family:Courier New; font-size:8pt" name="menu" onchange="OpenPage(this)" size="1">
	<option selected>A</option>
	<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62210" -->
	<option VALUE="City=<%=FP_FieldHTML(fp_rs,"Shelf_Location")%>&Type=<%=FP_FieldHTML(fp_rs,"Type")%>&IP=<%=FP_FieldHTML(fp_rs,"IP_Address")%>">
	<script language="javascript">
		if ("<%=FP_FieldHTML(fp_rs,"Circuit_ID")%>"=="")
			{document.write("           ");}
		else
			{document.write("<%=FP_FieldHTML(fp_rs,"Circuit_ID")%>");}
	</script>
	<%=FP_FieldHTML(fp_rs,"Shelf_Location")%>-<script language="javascript">
		if ("<%=FP_FieldHTML(fp_rs,"Remote")%>"!="")
			{document.write("<%=FP_FieldHTML(fp_rs,"Remote")%>-");}
	</script><%=FP_FieldHTML(fp_rs,"Shelf_Num")%>
	[<%=FP_FieldHTML(fp_rs,"Type")%>]
	</option>
	<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62218" -->
</select><!--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></form>

(in reply to Spooky)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Passing a variable 		Page: [1]
Jump to: 1





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


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.