Ask a Question related to Dreamweaver AppDev, Design and Development.
-
ala1065 #1
Update Record Server Behavior Error
I've created a search page, result page, and update page that work together,
but I cannot add the update record server behavior to my form.
I've created a recordset on the update page and it correctly displays
information from the results page, but I keep getting the following message
when I try to add the update record server behavior:
"Before using this server behavior, please select a recordset"
Am I doing something wrong or is something wrong with my program?
See code below:
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/conn_workflow.asp" -->
<%
Dim workflow_rs
Dim workflow_rs_numRows
Set workflow_rs = Server.CreateObject("ADODB.Recordset")
workflow_rs.ActiveConnection = MM_conn_workflow_STRING
workflow_rs.Source = "SELECT * FROM all_clients"
workflow_rs.CursorType = 0
workflow_rs.CursorLocation = 2
workflow_rs.LockType = 1
workflow_rs.Open()
workflow_rs_numRows = 0
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="mbcdesign.css" rel="stylesheet" type="text/css" />
</head>
<body bgcolor="#C4C4FF">
<h1> Current Billing Status</h1>
<form name="update" id="update" method="post" action="">
<table width="95%" border="1" cellspacing="0" cellpadding="3">
<tr>
<td width="34%"><h2>Client</h2></td>
<td
width="66%"><p><%=(workflow_rs.Fields.Item("client ").Value)%></p></td>
</tr>
<tr>
<td><h2>Date Received </h2></td>
<td><p><%=(workflow_rs.Fields.Item("date_recd").Va lue)%> </p></td>
</tr>
<tr>
<td><h2>Date of Service</h2></td>
<td><p><%=(workflow_rs.Fields.Item("dos").Value) %> </p></td>
</tr>
<tr>
<td><h2>Setups Keyed</h2></td>
<td> <p>
<input <%If (CStr((workflow_rs.Fields.Item("setups_keyed").Val ue)) =
CStr("Yes")) Then Response.Write("checked") : Response.Write("")%>
name="setups_keyed" type="checkbox" id="setups_keyed"
value="<%=(workflow_rs.Fields.Item("setups_keyed") .Value)%>" />
</p></td>
</tr>
<tr>
<td><h2>Charges Keyed</h2></td>
<td> <p>
<input <%If (CStr((workflow_rs.Fields.Item("charges_keyed").Va lue))
= CStr("Yes")) Then Response.Write("checked") : Response.Write("")%>
name="charges_keyed" type="checkbox" id="charges_keyed"
value="<%=(workflow_rs.Fields.Item("charges_keyed" ).Value)%>" />
</p></td>
</tr>
<tr>
<td><h2>Problem Log Answered</h2></td>
<td> <p>
<input <%If (CStr((workflow_rs.Fields.Item("problem_log").Valu e)) =
CStr("Yes")) Then Response.Write("checked") : Response.Write("")%>
name="problem_log" type="checkbox" id="problem_log"
value="<%=(workflow_rs.Fields.Item("problem_log"). Value)%>" />
</p></td>
</tr>
<tr>
<td><h2>Electronic Medicare Billing Submitted</h2></td>
<td> <p>
<input <%If
(CStr((workflow_rs.Fields.Item("emc_claims_done"). Value)) = CStr("Yes")) Then
Response.Write("checked") : Response.Write("")%> name="emc_claims_done"
type="checkbox" id="emc_claims_done"
value="<%=(workflow_rs.Fields.Item("emc_claims_don e").Value)%>" />
</p></td>
</tr>
<tr>
<td><h2>Paper Claims Billed</h2></td>
<td> <p>
<input <%If (CStr((workflow_rs.Fields.Item("paper_billed").Val ue)) =
CStr("Yes")) Then Response.Write("checked") : Response.Write("")%>
name="paper_billed" type="checkbox" id="paper_billed"
value="<%=(workflow_rs.Fields.Item("paper_billed") .Value)%>" />
</p></td>
</tr>
<tr>
<td> </td>
<td><p>
<input type="submit" name="Submit" value="Update" />
</p></td>
</tr>
</table>
<p>
<input name="ID" type="hidden" id="ID"
value="<%=(workflow_rs.Fields.Item("ID").Value)%>" />
</p>
</form>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</body>
</html>
<%
workflow_rs.Close()
Set workflow_rs = Nothing
%>:disgust;Text
ala1065 Guest
-
Update Record behavior deletes input text after aquotation mark.
Using php and MySQL the Update Record server behavior deletes all text after a quotation mark. The update form has a text box and the data is... -
JavaScript error in Insert Record server behavior
When I attempt to add an Insert Record server behavior in a VBScript-based ASP file, I get the following error message: "While executing onChange in... -
Delete Behavior on Record with FK Constraint ProducesHTTP 500 Internal Server Error
Hello MX Developers, I am inquiring about how to inform the user that a record can not be deleted because the record has a relationship to another... -
Delete Record Server Behavior won't work!
Hi, I have a search & results page that finds the record that I want to delete and even the data bindings show the records fields on the page. ... -
Server behavior ' insert record'
Every time I use this server behavior there comes a red '!' in front of it ?? Does someone know why this happens ?? Thanks a lot Georges J.S.



Reply With Quote

