Ask a Question related to Dreamweaver AppDev, Design and Development.
-
Gm3512 #1
View a variable??
We are having some trouble and need to see what the variable is getting. How
can we show what the variable is being populated with.I am posting the code and
then the sql command. We are using an example of updating multiple records to a
table using check boxes. It works great for one record, however if we choose
more then one it does not work. So we want to capture what is going to one of
the variables so that we can debug. I have attached the code and I have
attached the sql statement that we are using. We want to see what is being
captured in the updatelease_info or the param_lease variable.
This is the sql statment:
UPDATE TerminalData
SET leaseNumber = 'param_info'
WHERE termName IN ('param_lease')
The variables are:
if(Request.QueryString("lease_info") <> "") then updateleaseinfo__param_info =
Request.QueryString("lease_info")
if(Request.QueryString("update_leaseinfo") <> "") then
updateleaseinfo__param_lease = Request.QueryString("update_leaseinfo")
Code Below::::
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/cn.asp" -->
<%
if(Request.QueryString("lease_info") <> "") then updateleaseinfo__param_info =
Request.QueryString("lease_info")
if(Request.QueryString("update_leaseinfo") <> "") then
updateleaseinfo__param_lease = Request.QueryString("update_leaseinfo")
%>
<%
set updateleaseinfo = Server.CreateObject("ADODB.Command")
updateleaseinfo.ActiveConnection = MM_cn_STRING
updateleaseinfo.CommandText = "UPDATE TerminalData SET leaseNumber = '" +
Replace(updateleaseinfo__param_info, "'", "''") + "' WHERE termName IN ('" +
Replace(updateleaseinfo__param_lease, "'", "''") + "')"
updateleaseinfo.CommandType = 1
updateleaseinfo.CommandTimeout = 0
updateleaseinfo.Prepared = true
updateleaseinfo.Execute()
%>
<%SET updateleaseinfo = nothing
%>
<!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>
</body>
</html>
Gm3512 Guest
-
View-View Event Processing
I am not getting View to View Event processing to work. I have looked through most of the Flex 2 and Flex 3 docs plus several of the Flex books to... -
DW Split View - Design View
When working in DW in Split View, when the user clicks into the Design View window the view automatically updates the view if code view has changed.... -
Standard View vs. Layout View
view>table view joe "lilyeq" <webforumsuser@macromedia.com> wrote in message news:bfm6gt$qla$1@forums.macromedia.com... making tables. In... -
Code view & Layout view
Hello all, I have a problem! I have a .htm document where I can see the code view, but I can't see anything in the Layout view. Only the tables.... -
Wierd error when going to Design View from HTML view
When I go from HTML view (in a webform) to Design View I get the following error: Could not open in Design view. Quote values differently inside a... -
Manuel Socarras #2 Re: View a variable??
Response.Write yourVar
Response.End
Gm3512 wrote:
> We are having some trouble and need to see what the variable is getting. How
> can we show what the variable is being populated with.I am posting the code and
> then the sql command. We are using an example of updating multiple records to a
> table using check boxes. It works great for one record, however if we choose
> more then one it does not work. So we want to capture what is going to one of
> the variables so that we can debug. I have attached the code and I have
> attached the sql statement that we are using. We want to see what is being
> captured in the updatelease_info or the param_lease variable.
>
> This is the sql statment:
>
> UPDATE TerminalData
> SET leaseNumber = 'param_info'
> WHERE termName IN ('param_lease')
>
>
> The variables are:
>
> if(Request.QueryString("lease_info") <> "") then updateleaseinfo__param_info =
> Request.QueryString("lease_info")
>
> if(Request.QueryString("update_leaseinfo") <> "") then
> updateleaseinfo__param_lease = Request.QueryString("update_leaseinfo")
>
>
>
> Code Below::::
>
>
> <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> <!--#include file="Connections/cn.asp" -->
> <%
>
> if(Request.QueryString("lease_info") <> "") then updateleaseinfo__param_info =
> Request.QueryString("lease_info")
>
> if(Request.QueryString("update_leaseinfo") <> "") then
> updateleaseinfo__param_lease = Request.QueryString("update_leaseinfo")
>
> %>
> <%
>
> set updateleaseinfo = Server.CreateObject("ADODB.Command")
> updateleaseinfo.ActiveConnection = MM_cn_STRING
> updateleaseinfo.CommandText = "UPDATE TerminalData SET leaseNumber = '" +
> Replace(updateleaseinfo__param_info, "'", "''") + "' WHERE termName IN ('" +
> Replace(updateleaseinfo__param_lease, "'", "''") + "')"
> updateleaseinfo.CommandType = 1
> updateleaseinfo.CommandTimeout = 0
> updateleaseinfo.Prepared = true
> updateleaseinfo.Execute()
>
> %>
>
>
>
>
> <%SET updateleaseinfo = nothing
> %>
>
> <!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>
>
> </body>
> </html>
>Manuel Socarras Guest
-
Gm3512 #3 Re: View a variable??
Manuel thanks for the response. We were trying to do this. Were do we put the response in the code? Also should it be surrounded with <%%>
Thanks
Greg
Gm3512 Guest
-
Manuel Socarras #4 Re: View a variable??
try this:
<%
if(Request.QueryString("lease_info") <> "") then
updateleaseinfo__param_info = Request.QueryString("lease_info")
if(Request.QueryString("update_leaseinfo") <> "") then
updateleaseinfo__param_lease = Request.QueryString("update_leaseinfo")
Response.Write "updateleaseinfo__param_info: " & updateleaseinfo__param_info
Response.End
%>
Gm3512 wrote:> Manuel thanks for the response. We were trying to do this. Were do we put the response in the code? Also should it be surrounded with <%%>
>
> Thanks
> GregManuel Socarras 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
