Ask a Question related to Dreamweaver AppDev, Design and Development.
-
sbrenier #1
Parameter Not Passing in Live View
:confused;
I have a simple dataset in ASP.NET VB with a parameter that calls records via
a parameter named frmName. I have it set to select records from the WholeNameA
field. I have my results set up as a table with a repeater. When I attempt to
preview results via the Live Data function, however, no results are returned.
It seems as if the parameter does not pass to the query.
I have attached the code.
This seems as if it should not be difficult to fix but I'm out of ideas.
Help!!!
Steve
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls"
Assembly="DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,cultu
re=neutral" %>
<MM:DataSet
id="dsPersonnel"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_UWS
Central") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETY
PE_UWSCentral") %>'
CommandText='<%# "SELECT PersonnelID, PhotoID, WholeNameA, DispPTelephone,
Email FROM dbo.vw_EmployeeAlpha WHERE WholeNameA LIKE @WholeNameA ORDER BY
WholeNameA ASC" %>'
Debug="true"<Parameter Name="@WholeNameA" Value='<%# "%" +><Parameters>
(IIf((Request.QueryString("frmName") <> Nothing),
Request.QueryString("frmName"), "")) + "%" %>' Type="NChar"
/></Parameters></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<ASP:Repeater runat="server" DataSource='<%# dsPersonnel.DefaultView %>'>
<ItemTemplate>
<table width="610" border="2" cellspacing="2">
<tr>
<td><%# dsPersonnel.FieldValue("PhotoID", Container) %></td>
</tr>
<tr>
<td><%# dsPersonnel.FieldValue("WholeNameA", Container) %></td>
</tr>
<tr>
<td><%# dsPersonnel.FieldValue("DispPTelephone", Container) %></td>
</tr>
<tr>
<td><%# dsPersonnel.FieldValue("Email", Container) %></td>
</tr>
</table>
</ItemTemplate>
</ASP:Repeater>
</body>
</html>
sbrenier Guest
-
live data view
Does anyone know if Contribute 3 has a "live data" view like Dreamweaver? I would like for a non-technical, content owner to be able to pull up a... -
Passing a parameter in SWF
In the sample application that comes with flash mx, when I click on the simpleconnect and look at parameters it has an Application Directory and if... -
Passing in a parameter
Hello All, I've declared my usercontrol in the normal way (page directive) and to load it I'm doing: <webapp:menu runat="server" />. However, is... -
parameter passing from asp to php
Hi all, I've got a script using com objects that will work in asp but not work with php. The asp script creates an object that does something... -
parameter passing from osql
Hi, I want to write a batch file which essentially calls the osql utility (osql -i xxx.sql....) to run a SQL script. How the script can be written... -
Paul Whitham TMM #2 Re: Parameter Not Passing in Live View
Check that the URL string coming into this page has a ?frmName=somevalue
attached to the end of it.
--
Regards
Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]
Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]
"sbrenier" <webforumsuser@macromedia.com> wrote in message
news:d3oh90$81p$1@forums.macromedia.com...via> :confused;
>
> I have a simple dataset in ASP.NET VB with a parameter that calls recordsWholeNameA> a parameter named frmName. I have it set to select records from theattempt to> field. I have my results set up as a table with a repeater. When Ireturned.> preview results via the Live Data function, however, no results areResponseEncoding="iso-8859-1" %>> It seems as if the parameter does not pass to the query.
>
> I have attached the code.
>
> This seems as if it should not be difficult to fix but I'm out of ideas.
>
> Help!!!
>
> Steve
>
> <%@ Page Language="VB" ContentType="text/html"Assembly="DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,c> <%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls"
>
ultuSystem.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING> re=neutral" %>
> <MM:DataSet
> id="dsPersonnel"
> runat="Server"
> IsStoredProcedure="false"
> ConnectionString='<%#
>
_UWSSystem.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABA> Central") %>'
> DatabaseType='<%#
>
SETYDispPTelephone,> PE_UWSCentral") %>'
> CommandText='<%# "SELECT PersonnelID, PhotoID, WholeNameA,BY> Email FROM dbo.vw_EmployeeAlpha WHERE WholeNameA LIKE @WholeNameA ORDER%></td>> WholeNameA ASC" %>'
> Debug="true"> <Parameter Name="@WholeNameA" Value='<%# "%" +> ><Parameters>
> (IIf((Request.QueryString("frmName") <> Nothing),
> Request.QueryString("frmName"), "")) + "%" %>' Type="NChar"
> /></Parameters></MM:DataSet>
> <MM:PageBind runat="server" PostBackBind="true" />
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
> "http://www.w3.org/TR/html4/loose.dtd">
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> <title>Untitled Document</title>
> </head>
> <body>
> <ASP:Repeater runat="server" DataSource='<%# dsPersonnel.DefaultView %>'>
> <ItemTemplate>
> <table width="610" border="2" cellspacing="2">
> <tr>
> <td><%# dsPersonnel.FieldValue("PhotoID", Container) %></td>
> </tr>
> <tr>
> <td><%# dsPersonnel.FieldValue("WholeNameA", Container) %></td>
> </tr>
> <tr>
> <td><%# dsPersonnel.FieldValue("DispPTelephone", Container)> </tr>
> <tr>
> <td><%# dsPersonnel.FieldValue("Email", Container) %></td>
> </tr>
> </table>
> </ItemTemplate>
> </ASP:Repeater>
> </body>
> </html>
>
Paul Whitham TMM Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
