Ch 16 buildingBlock.asp Help!

kwperry · October 10th, 2003, 11:21 AM

Ok I added IUSR_Kperry and this time it looks like it worked however it now gets this error...Error Type:
Microsoft JScript runtime (0x800A138F)
'Section__MMColParam' is null or not an object
/MediaCSB/TMP2mnjmjuju.asp, line 6

In which my code looks like this for line 6 :

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>

<%
var Section = Server.CreateObject("ADODB.Recordset");
Section.ActiveConnection = MM_MediaEdge_STRING;
Section.Source = "SELECT * FROM Sections WHERE ID = "+ Section__MMColParam.replace(/'/g, "''") + "";
Section.CursorType = 0;
Section.CursorLocation = 2;
Section.LockType = 1;
Section.Open();
var Section_numRows = 0;
%>

Oh PS Imar nice job on the book...not sure why I'm getting this error...of course I will look again on google but I think you have a better grasp!

Thanks

kwperry · October 10th, 2003, 01:27 PM

Ok fix that page now moving to your blockContent.asp get this error Microsoft JScript runtime (0x800A01B6)
Object doesn't support this property or method
/MediaCSB/TMP4npz6mk0hs.asp, line 36

here is the code for this page:

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>

<%
var Content__MMColParam = "1";
if (String(Request.QueryString("sectionID")) != "undefined" &&
    String(Request.QueryString("sectionID")) != "") {
  Content__MMColParam = String(Request.QueryString("sectionID"));
}
%>
<%
var Content = Server.CreateObject("ADODB.Recordset");
Content.ActiveConnection = MM_MediaEdge_STRING;
Content.Source = "SELECT ID, Title, Link, Image, Image_Height, Image_Width, Vertical_Space, Horizontal_Space, Description FROM Content, Section_Content WHERE ID = Content_ID AND Section_ID = "+ Content__MMColParam.replace(/'/g, "''") + "";
Content.CursorType = 0;
Content.CursorLocation = 2;
Content.LockType = 1;
Content.Open();
var Content_numRows = 0;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
Content_numRows += Repeat1__numRows;
%>
<html>
<head>
<title>Building Block Technology</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="blockStyles.css" rel="stylesheet" type="text/css">
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<% while ((Repeat1__numRows-- != 0) && (!Content.EOF)) { %>
<table width="<%String(Request.QueryString("width"))%> border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="92"><img src="<%=(Content.Item("Image").Value)%>" alt="" width="<%=(Content.Item("Image_Width").Value)%>" height="<%=(Content.Item("Image_Height").Value)%> vspace="<%=(Content.Fields.Item("Vertical_Space"). Value)%> hspace="<%=(Content.Fields.Item("Horizontal_Space" ).Value)%>"></td>
    <td width="98"><a href="<%=(Content.Fields.Item("Link").Value)%>"><% =(Content.Fields.Item("Title").Value)%></a><br> <%=(Content.Fields.Item("Description").Value)%> </td>
  </tr>
</table>
<%
  Repeat1__index++;
  Content.MoveNext();
}
%>
</body>
</html>
<%
Content.Close();
%>

When opening the buildingBlock.asp the outside images work but the blockContent.asp does not display page get above error...help just following the book

Thanks Kevin

kwperry · October 10th, 2003, 01:36 PM

NEVER mind...Yep its offical I'm an idiot! TYPOS TYPOS TYPOS thats for everyones help I got it now!

Imar · October 10th, 2003, 01:51 PM

So, is everything working as expected now?

Great!!

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

kwperry · October 13th, 2003, 04:09 PM

Hey Imar one question on both blockMain.asp, blockMainPayPay.asp I get the following error:

Object doesn't support this property or method
/MediaCSB/TMPkqo66mpryj.asp, line 36

Line 36 I have the code:

<td> <img src="<%=(Content.Item("Image_Main").Value)%>" alt="" width="<%=(Content.Item("Image_Width_Main").Value) %>" height="<%=(Content.Item("Image_Height_Main").Valu e)%>" hspace="<%=(Content.Fields.Item("Horizontal_Space_ Main").Value)%>" vspace="<%=(Content.Fields.Item("Vertical_Space_Ma in").Value)%>"></td>

If I replace Content.Item with Content.Fields.Item it works sortof. I get the page to display with text but no images display just get red X on the page, and I notice the DynamicImage Server behaivor gets a ! point next to it? Whats the trick to get this to work?

Your help please...

Kevin

Imar · October 14th, 2003, 02:20 AM

Well, you definitely need Content.Fields.Item("Image_Main").Value for the same reason as one of your earlier posts.

Are you sure your recordset is set up correctly? Does Image_Main contain a value? What happens when you clean up the page (just keep the necessary recordset, while removing any test recordsets you may have added) and then check out the Test button on the Recordset dialog? Does it return any records? Does it return the expected records?

How does the src attribute for your image look like in the browser (the one that ends up as a red X)? Does it point to an image that does not exist on the server? Did you upload / Put all the required images to the remote or testing server?

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.