Ask a Question related to Dreamweaver AppDev, Design and Development.
-
zol31 #1
Dreamweaver error message
Hi,
I am currently working through the text "Dreamweaver MX 2004 ASP, Coldfusion
and PHP". In lesson 9 I have run into an error mesage listed below and I am
stumped as to how to correct the error. I have gone through the Macromedia
help site with no relief. Does anyone have an answer?
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.
/newland/tourprice_processor.asp, line 33
Keith
zol31 Guest
-
Error Message - Dreamweaver vs Internet Explorer
I have created buttons with pop up menus (drop down menus) in Dreamweaver MX. On my local computer browser (internet explorer 6.0) for testing them... -
Dreamweaver 8 Error Message on Contribute Could NotContact the Publishing Services Server Because dcaahqw1areturned an
:clock; Whenever I check in a new file to the remote site or check the file out, I get an error box with the following message: Contribute... -
Contribute Error Message in Dreamweaver
I am receiving the following Contribute error message in Dreamweaver: "The file required for Contribute compatibility does not exist on the server.... -
error message from sql server to dreamweaver pages
Hi.. I've some constraints on my db to restrict some character to be inserted into certain column.. so how could I use Dreameaver page to alert the... -
Dreamweaver MX error message
Hey, I just installed Dreamweaver MX on my computer and created a simple xhtml page that linked to a simple css style. Now I continue to get random... -
Manuel Socarras #2 Re: Dreamweaver error message
probably your query to the DB is returning an empty recordset. check the
SELECT stament and the table(s)
HTH,
manuel
zol31 wrote:> Hi,
> I am currently working through the text "Dreamweaver MX 2004 ASP, Coldfusion
> and PHP". In lesson 9 I have run into an error mesage listed below and I am
> stumped as to how to correct the error. I have gone through the Macromedia
> help site with no relief. Does anyone have an answer?
>
> ADODB.Field error '800a0bcd'
>
> Either BOF or EOF is True, or the current record has been deleted. Requested
> operation requires a current record.
>
> /newland/tourprice_processor.asp, line 33
>
>
> Keith
>
>Manuel Socarras Guest
-
gerry - dergal #3 Re: Dreamweaver error message
your going to see that one a lot!
As mentioned - its the recordset returning nothing ...
G
"zol31" <webforumsuser@macromedia.com> wrote in message
news:d16v9q$fnv$1@forums.macromedia.com...Coldfusion> Hi,
> I am currently working through the text "Dreamweaver MX 2004 ASP,am> and PHP". In lesson 9 I have run into an error mesage listed below and IMacromedia> stumped as to how to correct the error. I have gone through theRequested> help site with no relief. Does anyone have an answer?
>
> ADODB.Field error '800a0bcd'
>
> Either BOF or EOF is True, or the current record has been deleted.> operation requires a current record.
>
> /newland/tourprice_processor.asp, line 33
>
>
> Keith
>
>
gerry - dergal Guest
-
-
zol31 #5 Re: Dreamweaver error message
Thanks, but do you have a fix that I can use? Or is this a Dreamweaver problem?
Keith
zol31 Guest
-
zol31 #6 Re: Dreamweaver error message
Hi
Being new to this aspect of dynamic websites I have copied the page in
question that is giving me the problem can you point out where the select
statement is?
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252" %>
<!--#include file="Connections/conn_newland.asp" -->
<%
Dim rs_tourprices_filtered__MMColParam
rs_tourprices_filtered__MMColParam = "1"
If (Request.Form("tourName") <> "") Then
rs_tourprices_filtered__MMColParam = Request.Form("tourName")
End If
%>
<%
'Queries the database for the tour name, adult price, and child price; data is
filterd so that the only record retrived corrsponds to what the user entered in
the form.
Dim rs_tourprices_filtered
Dim rs_tourprices_filtered_numRows
Set rs_tourprices_filtered = Server.CreateObject("ADODB.Recordset")
rs_tourprices_filtered.ActiveConnection = MM_conn_newland_STRING
rs_tourprices_filtered.Source = "SELECT tourID, tourName, basePriceAdult,
basePriceChild FROM tbl_tours WHERE tourID = " +
Replace(rs_tourprices_filtered__MMColParam, "'", "''") + ""
rs_tourprices_filtered.CursorType = 0
rs_tourprices_filtered.CursorLocation = 2
rs_tourprices_filtered.LockType = 3
rs_tourprices_filtered.Open()
rs_tourprices_filtered_numRows = 0
%>
<%
' Form validation script; redirects users back to tourprice.asp if form fields
do not have numeric values.
If Not IsNumeric (Request.Form("numadults")) or Not
IsNumeric(Request.Form("numchildren"))Then
Response.Redirect("tourprice.asp?error=notnumeric" )
End If
%>
<%
'Collects data for number of adults and children, and the prices for both
adults and children multiplies data to calculate total
Dim numAdult, numChild, basePriceAdult, basePriceChild, tourPrice
numAdult=Request.Form("numAdult")
numChild=Request.Form("numChildren")
basePriceAdult=rs_tourprices_filtered.Fields.Item( "basePriceAdult").Value
basePriceChild=rs_tourprices_filtered.Fields.Item( "basePriceChild").Value
tourPrice=(numAdult * basePriceAdult)+(numChild * basePriceChild)
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Newland Tours: About</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="css/newland.css" rel="stylesheet" type="text/css" />
</head>
<body>
<a href="#top"><img src="images/spacer.gif" alt="Skip to main page content."
width="1" height="1" border="0" align="left" /></a>
<table width="750" border="0" cellpadding="3" cellspacing="0">
<tr>
<td><img src="images/banner_left.gif" width="451" height="68" alt="Newland
Tours Banner, Left" /></td>
<td width="280"><img src="images/banner_right.jpg" width="276" height="68"
alt="Newland Tours Banner, Right" /></td>
</tr>
<tr>
<td><img src="images/navbar.gif" name="navbar" width="450" height="20"
border="0" usemap="#navbarMap" /></td>
<td><img name="copyright_bar" src="images/copyright_bar.gif" width="272"
height="20" border="0" /></td>
</tr>
<tr>
<td colspan="2">
<h1><br />
<a name="top" id="top"></a>Tour Price Calculator </h1>
<p>The estimated cost of your tour,
<% If Not rs_tourprices_filtered.EOF Or Not rs_tourprices_filtered.BOF
Then %>
<strong><%=(rs_tourprices_filtered.Fields.Item("to urName").Value)%></strong>
<% End If ' end Not rs_tourprices_filtered.EOF Or NOT
rs_tourprices_filtered.BOF %>
, is <strong>
<%Response.Write(FormatCurrency(tourPrice))%></strong>.</p>
<p>Prices include hotel, accommodation, and travel expenses during the
tour. They do not include airfare to the starting destination.</p>
<p><a href="tourprice.asp">Calculate</a> another tour.</p>
<p><a href="contact.asp">Contact</a> one of our qualified agents. </p>
<p> </p></td>
</tr>
</table>
<br />
<br />
<map name="navbarMap"id="navbarMap">
<area shape="rect" coords="1,0,62,20" href="index.asp" alt="Home" />
<area shape="rect" coords="71,0,117,20" href="about.asp" alt="About" />
<area shape="rect" coords="129,0,196,20" href="tours.asp" alt="Find Tours" />
<area shape="rect" coords="209,0,311,20" href="profiles.asp" alt="Country
Profiles" />
<area shape="rect" coords="327,0,434,20" href="contact.asp" alt="Contact An
Agent" />
</map>
</body>
</html>
<%
rs_tourprices_filtered.Close()
Set rs_tourprices_filtered = Nothing
%>
Thanks
Keith
zol31 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
