Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Web Programming > Adobe Web Programming > Dreamweaver (all versions)
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 2nd, 2005, 01:12 PM
Authorized User
 
Join Date: Aug 2004
Location: southampton, hants, United Kingdom.
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default Dreamweaver 2004 Building Blocks

Hi
I have now completed all the pages in this section and they all worked in my browser except that "Index asp" only showed the search button and the logo.
Trying to sort this out and then found none of the B. BL. pages would open. I then found my connection with my database was missing.
I reconnected to my database okay but still cannot open the B. BL. pages. And still only get the "search" and Logo on view when trying "Index asp." in browser.

The error reported is as follows;-

Microsoft OLE DB Provider forODBC Drivers(0x80004005)
[Microsoft][ODBC Microsoft Access Driver] general error Unable to open registry key'Temporary (volitile) Jet DSN for process
)x95c Thread Oxaa0 DBCx126a96c Jet'.

Can anybody help me with my two probs ???

Also would like to chat with anyone who is working on Building Blocks
Drop me a line.Will be pleased to discuss anything.

regards

Terry s



Reply With Quote
  #2 (permalink)  
Old March 2nd, 2005, 01:22 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi Terry,

Are you sure the path to the database in the connection string is OK? And that IIS is allowed to write to the database?

When in doubt, check the section about securing your database in the part about TheSoccerSite.

Alternatively, use the OleDb connectionstring that was used in TheSoccerSite. Don't forget to change the path to and the name of the database.....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #3 (permalink)  
Old March 4th, 2005, 01:56 PM
Authorized User
 
Join Date: Aug 2004
Location: southampton, hants, United Kingdom.
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
 I think I've cleared my loading prob, I had two pages the same name and one was faulty. By deleting it my prob has gone. My connection to my database is fine.

However there are furthers probs.

My blockMain.asp page loads into the browser but I don't get the image as per fig 17-8 on page 614.
I get a series of large boxes.
The first box reads " 1 Main Content".
under the box is "Item 1
                  This is the main content for item one".
The next box is item 2
The boxes run from 1 to 5

I checked the recordset of this page and tested. The test shows ID 1 to ID 5
But not ID 7 which I think is the info for this page.
My database is the same as the download.

I'm pulling my hair out !! and there's not much of it left.

You should note once again, that if you follow the instructions in the book to construct this page, and I've done it several times now, you end up with something very to the download.

Best wishes

Terry s


Reply With Quote
  #4 (permalink)  
Old March 5th, 2005, 04:47 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

And once again I should ask you the same question: "How does the code from the download with the database from the download run?"

Do you get what you expect when you run that code? If so, what are the differences between your page and the one from the download?
It's hard for me to say what's going without seeing your code, and without having you check the original code and check the differences....


Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #5 (permalink)  
Old March 5th, 2005, 01:36 PM
Authorized User
 
Join Date: Aug 2004
Location: southampton, hants, United Kingdom.
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Imar

I have enclosed the code as requested. This is the code I create when following the book's instruction for blockMain.asp.[code
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>

<%
var Content__MMColParam = "1";
if (String(Request.QueryString("section")) != "undefined" &&
    String(Request.QueryString("section")) != "") {
  Content__MMColParam = String(Request.QueryString("section"));
}
%>
<%
var Content = Server.CreateObject("ADODB.Recordset");
Content.ActiveConnection = MM_MediaEdge_STRING;
Content.Source = "SELECT ID, Title_Main, Content_Main, Image_Main, Image_Width_Main, Image_Height_Main, Vertical_Space_Main, Horizontal_Space_Main, Background_Main 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;
%>
<%=(Content.Item("Image_Width_Main").Value) %><%=(Content.Item("Image_Height_Main").Value) %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Builing Block Technology</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body,td,th {
    font-family: Arial, Helvetica, sans-serif;
}
body {
    background-color: #FFFFFF;
    margin-left: 0px;
    margin-top: 0px;
    margin-right: 0px;
    margin-bottom: 0px;
}
-->
</style></head>

<body>
<% while ((Repeat1__numRows-- != 0) && (!Content.EOF)) { %>
<table width="<%String (Request.QueryString("width"))%>" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="<%=(Content.Fields.Item("Image_Main").Value) %>" alt="" width="32" height="32" hspace="<%=(Content.Fields.Item("Horizontal_Space_ Main").Value)%>" vspace="<%=(content.Fields.Item("Vertical_Space_Ma in").Value)%>"></td>
  </tr>
  <tr>
    <td><%=(Content.Fields.Item("Title_Main").Value)%> <br>
      <%=(Content.Fields.Item("Content_Main").Value)%> </td>
  </tr>
</table>
<%
  Repeat1__index++;
  Content.MoveNext();
}
%>

</body>
</html>
<%
Content.Close();
%>
[/code]

Please note line 25. This line always appears in the wrong place when using the book's instruction.
The downloaded page (blockMain.asp) works in the browser but generates the wrong image. as described in my last cry for help. I should point out that the box I describe then, is just a line around the caption and not the frame with a scroller.

My blockContent.asp and buildingBlock.asp load correctly and show the correct images (as per the book) when viewed in my browser, and I my database in the same as the downloaded version.
Which is why I think my "connection" and database are sound.

One other point about the book, page 615, fig 17-10. My Dynamic image behavior panel is different. I cannot set the record_set panel to "undefined" and the imgtag to "blank"
My Record_set always reads "content" and the imgtag reads "[mg0]".

My index page, when viewed in the browser just shows the search box and the logo.

Regards

Terry s


Reply With Quote
  #6 (permalink)  
Old March 5th, 2005, 01:56 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

With what action do you get this line:

<%=(Content.Item("Image_Width_Main").Value) %><%=(Content.Item("Image_Height_Main").Value) %>

That line doesn't appear in the original source code that comes with the book.

I am sorry I cannot be of much help with this. I don't have a running version of MediaEdge here, and I don't have the custom server behaviors you created, so I can't really follow along with this project. All I can do is look at your source and search for differences between your code and the stuff from the book....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #7 (permalink)  
Old March 5th, 2005, 02:57 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Update: I couldn't resist, so I followed the book, created the DynamicImage server behavior and followed the steps 1 to 11 from page 614 to 617.

Everything works pretty much as advertised, except for two things: I think there is a mistake in the book with image 17-10 on page 615. The Record_Set drop down should read Content and not undefined.

The other issue is with the image on page 614. I am not sure if that a) is an incorrect image, or b) is the correct image, but taken from a site / database with content different from the "This is the main content for Item One" placeholder content I get.

I don't get your odd line 25, and I can't see a reason (in the 11 steps) for that line to appear. Are you sure you followed every step correctly? And are you sure your DynamicImage Server Behavior is OK?

Does this help?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: The Heat [The Energy] by The Prodigy (Track 7 from the album: Music For The Jilted Generation) What's This?
Reply With Quote
  #8 (permalink)  
Old March 7th, 2005, 01:23 PM
Authorized User
 
Join Date: Aug 2004
Location: southampton, hants, United Kingdom.
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I think you must be correct re my dynamic server behavior.
Line 25 goes in when I use it.
I can get away with using the downloaded file for now, but I think there is a prob with Dreamweaver because when I deleted this behavior,and rebuilding the page to that point, after building a new behavior, when I try to use it, it tells me to create a record set despite having built one.
So, I don't know where to go to resolve that.
In the meantime hopefully I can carry on with the project.
So my next question is why can't I get my index. asp page to show the building blocks ???

Thanks fot your help and encouragment

Terry s



Reply With Quote
  #9 (permalink)  
Old March 7th, 2005, 04:48 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

If I were you, I'd either recreate the entire page from scratch (it's only a few steps), or delete the Server Behavior through the Server Behaviors panel, and then manually clean up stuff that belonged to the recordset. If your page is broken, DW is not able to clean up all the parts that belong to the recordset.

When you recreated the DynamicImage behavior, did you delete the old one first?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Ho Humm by Moloko (Track 11 from the album: Do You Like My Tight Sweater?) What's This?
Reply With Quote
  #10 (permalink)  
Old March 10th, 2005, 01:30 PM
Authorized User
 
Join Date: Aug 2004
Location: southampton, hants, United Kingdom.
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I've now completed blockMain.asp but it still performs as per my earlier mail, and not as shown on page 614 fig 17-8. There is no frame with scroller.
However, I think it work's as per the book's instruction, but surely there is something wrong.
In page buildngBlock.asp, the record-set points to the "section" of the database, and in the browser the frame is shown complete with contents, but in blockMain.asp it points to the "content" of the datbase. So how can it find the info to produce the frame ???
Or am I missing something ???
My other query is how do I load the files into my index page??? When I open this page in the browser all I see is the "Logo" and the "search".
I have now completed all the pages, and checked them against the download, and they all work indivisually in the browser, so it's frustrating not to see the damn thing working.

Cheers

Terry s


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Beginning Dreamweaver/ Building Blocks terry s Forum and Wrox.com Feedback 2 September 8th, 2005 11:16 AM
Building Blocks terry s Dreamweaver (all versions) 1 August 16th, 2005 02:42 PM
Beginning Dreamweaver 2004 Building Blocks terry s Dreamweaver (all versions) 1 February 12th, 2005 03:59 PM
Building Blocks terry s Dreamweaver (all versions) 1 January 12th, 2005 02:03 PM



All times are GMT -4. The time now is 03:58 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.