Dreamweaver CS3 cannot master detail page in .asp

I am having a problem in creating a Master/Detail page set in Dreamweaver cs3 in .asp

I created a Recordset on the results page to pull in records from an access db which it does correctly.

When I open Insert/DataObjects/MasterDetailPageSet I get the three top ticks OK but the last item in the list is unticked
4 Create a recordset.

Of course the recordset already exists.

Any ideas what may be going wrong please?

I recreated the Site Cache but this changed nothing.

Can anyone see where I may be going wrong  please?

Many thanks

John
johnhardyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason C. LevineNo oneCommented:
When you use the wizards, DW actually looks for you to do each of the steps and complains if you don't.  The complaints usually have no bearing on whether or not the application works, so publish the page and test it.  If it works, you're done :)

FYI you will see similar behavior out of DW if you manually alter recordset code or server behavior code to make it do something different.  The behaviors or recordsets will get the red exclamation point in the server behavior window even though the code is perfectly valid and functional.  

In other words, don't let DW boss you around.  Show that program who's in charge!
0
Wayne BarronAuthor, Web DeveloperCommented:
Hello John.
If you do not mind me asking.
Why are you using DW to generate your code for you?
You can learn to do it yourself, it is not that hard to get started.
I have a tutorial that will halo guide you in learning the basics.
http://ee.cffcs.com/Q_24801116/Q_24801116.asp
code
http://ee.cffcs.com/Q_24801116/Q_24801116.zip

Also, I will be releasing some video tutorials on this as well.

Reason I am telling you this.
DW generates an overkill of code, that is, in a better since of the words, just too much of crap code.

Good luck
Carrzkiss
0
johnhardyAuthor Commented:
Thanks Jason,
Long time no speak!
That's a new slant on the way to look at DW. I still dont understand why I cannot create master / Details forms.
I have done this many times before and its always worked.

I expect I will need to create the pages manually and then link them?
Regards

John
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

johnhardyAuthor Commented:
Thanks Carrzkiss
When I try to open q_24801116.asp dreamweaver crashes.
Maybe I did something wrong.

I often hear that DW creates some difficulties but I find that it also creates a path whereby a non coder can create quite comprehensive information recovering methods.
It has limitations I agree but its a lot more straight forward (for me) than many other methods.

Yes I have torn my hair out!

Regards

John
0
Jason C. LevineNo oneCommented:
Hi yourself, John.  What can I say?  You don't post DW questions (or WordPress) and I don't answer :)

Dreamweaver's version of a Master/Detail recordset is simply:

<a href="detail.asp?someID=recordsetvalue>linkity link</a>

on the master page and a recordset that filters on the URL parameter by someID on the detail page.  So really, you don't need the wizard.

Post the page code as it currently stands.  Maybe there's some other reason why DW doesn't like it.
0
johnhardyAuthor Commented:
Got real rusty doing other things for some time now so perhaps DW feels neglected.

I tried creating a repeat area but it still asks for a recordset, already in existence!

I attach the page code and an image which may help
Repeat Area
Many thanks
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/BFSN_OLEDB.asp" --><%
Dim rsCruisers__MMColParam
rsCruisers__MMColParam = "Power Cruisers"
If (Request("MM_EmptyValue") <> "") Then 
  rsCruisers__MMColParam = Request("MM_EmptyValue")
End If
%><%
Dim rsCruisers
Dim rsCruisers_cmd
Dim rsCruisers_numRows

Set rsCruisers_cmd = Server.CreateObject ("ADODB.Command")
rsCruisers_cmd.ActiveConnection = MM_BFSN_OLEDB_STRING
rsCruisers_cmd.CommandText = "SELECT * FROM Boats WHERE Category = ?" 
rsCruisers_cmd.Prepared = true
rsCruisers_cmd.Parameters.Append rsCruisers_cmd.CreateParameter("param1", 200, 1, 50, rsCruisers__MMColParam) ' adVarChar

Set rsCruisers = rsCruisers_cmd.Execute
rsCruisers_numRows = 0
%>
<%
Dim rsCruisers__MMColParam
rsCruisers__MMColParam = "power cruisers"
If (Request("MM_EmptyValue") <> "") Then 
  rsCruisers__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsCruisers
Dim rsCruisers_cmd
Dim rsCruisers_numRows

Set rsCruisers_cmd = Server.CreateObject ("ADODB.Command")
rsCruisers_cmd.ActiveConnection = MM_BFSN_OLEDB_STRING
rsCruisers_cmd.CommandText = "SELECT * FROM CategoryBoats WHERE Category = ?" 
rsCruisers_cmd.Prepared = true
rsCruisers_cmd.Parameters.Append rsCruisers_cmd.CreateParameter("param1", 200, 1, 50, rsCruisers__MMColParam) ' adVarChar

Set rsCruisers = rsCruisers_cmd.Execute
rsCruisers_numRows = 0
%><!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">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<script type="text/javascript" src="p7pm/p7popmenu.js"></script>
<style type="text/css" media="screen">
<!--
@import url("p7pm/p7pmv6.css");
-->
</style>
<link href="Styles.css" rel="stylesheet" type="text/css">
</head>

<body onLoad="P7_initPM(0,6,1,-20,10)">
<table width="800" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="6"><!--#include file="Header.asp" --></td>
  </tr>
  <tr>
    <td width="208"><!--#include file="navbar.asp" --></td>
    <td width="592">&nbsp;</td>
    <td width="592">&nbsp;</td>
    <td width="592">&nbsp;</td>
    <td width="592">&nbsp;</td>
    <td width="592">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><%=(rsCruisers.Fields.Item("RecNo").Value)%></td>
    <td><%=(rsCruisers.Fields.Item("Manufacturer").Value)%></td>
    <td><%=(rsCruisers.Fields.Item("Model").Value)%></td>
    <td><%=(rsCruisers.Fields.Item("MyFName").Value)%>&nbsp;<%=(rsCruisers.Fields.Item("MyLName").Value)%></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>




</body>
</html>
<%
rsCruisers.Close()
Set rsCruisers = Nothing
%>

Open in new window

0
Wayne BarronAuthor, Web DeveloperCommented:
DWCS3, is a buggy addition.
I have not used it in a while, I do know that when I did use CS3, it used to crash all the time on me, so I gave up the ghost, and got CS4, and use it.

I do not use none of its features, except for the auto-complete during typing.
And sometimes, I do not even use it.

Good Luck in your work.
0
Jason C. LevineNo oneCommented:
It looks like the recordset got written incorrectly and that's why you're having issues using DW behaviors.  If DW can't detect its own code, it makes using its wizards difficult.

I would delete all behaviors and dynamic text from the page and start over.
0
johnhardyAuthor Commented:
Thanks
I created a new results page  but still the recordset is not recognised.
When I run one line of the results shows OK but I cannot create a repeat region.

I opened a page in another site which has a repeat region but when I tried to examine this DW crashed.

I think DW may need reinstalling. Have you any hints how this should be undertaken?

Regards

John


0
Jason C. LevineNo oneCommented:
Don't reinstall.

What OS is this?
0
johnhardyAuthor Commented:
xp sp3
0
Wayne BarronAuthor, Web DeveloperCommented:
If you do not have no extension installed in DW, then simply go to add/remove programs

Uninstall DW
Reboot computer
Defrag the drive (Partition) that you had DW installed in, as well as C:\ drive.
Go to Windows Update, and download and install anything that may need to be installed, mainly any .net service packs, if you do not already have them installed.

However, you can do this over and over again.
DW3, is a Buggy program. It is one that Adobe, finally refused to do support for, as they were getting in way to many complaints, so they spend a little extra time, correcting issues in it, to release in CS4.

You can download the FREE trial of CS5.5, and give it a shot.
I think it has a 30 day trial, of which, you will be able to not only test your code, but you will also be able to test the code that I provided you a link for as well.

Download for CS5.5
http://www.adobe.com/cfusion/tdrc/index.cfm?product=dreamweaver

Good luck
Carrzkiss
0
Jason C. LevineNo oneCommented:
If DW crashes on one particular page it means the WinFileCache-xxxxxx.dat file is corrupt and needs to be deleted.  It's located in your config folder under c:\documents and settings\username\application data\adobe\dreamweaver\configuration\en-us\ IIRC.
0
johnhardyAuthor Commented:
I think I caused the crash by opening a file from another site in order to see existing code! Sorry to mislead...
Next
I deleted the WinFileCache-xxxxxx.dat file but didnt seem to make a difference.

I created a test page (in the correct site) and applied some code as below.
With no repeating a single line shows OK
But when I apply the repeat code (not generated by a wizard) nothing appears in the body.

Thanks carrzkiss for reinstall instructions I assume I could reinstall cs3 in the same way?





<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="Connections/conn_BFSN_OLEDB.asp" -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "Power Cruisers"
If (Request("MM_EmptyValue") <> "") Then 
  Recordset1__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_conn_BFSN_OLEDB_STRING
Recordset1_cmd.CommandText = "SELECT * FROM Boats WHERE Category = ?" 
Recordset1_cmd.Prepared = true
Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 200, 1, 50, Recordset1__MMColParam) ' adVarChar

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
  <% 
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) 
%>
<%=(Recordset1.Fields.Item("RecNo").Value)%>
<%=(Recordset1.Fields.Item("Manufacturer").Value)%>
<%=(Recordset1.Fields.Item("Model").Value)%>
  <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
Wend
%>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>

Open in new window

0
Jason C. LevineNo oneCommented:
Line 33 looks wrong.

should be while ((Recordset1__numrows <> 0
0
Wayne BarronAuthor, Web DeveloperCommented:
Yes, on the reinstalling CS3.
Although, I strongly suggest that you give CS5.5 a test drive.
It is not buggy.

Good luck
Carrzkiss
0
johnhardyAuthor Commented:
I changed line 33 but it made no difference.

Some time ago I installed VisualStudio8 onto this machine and had problems with it so in the end I un-installed  VS but have since had errors with the JustinTime debugger and a few others where the machine does not shutdown correctly.

I wonder if this could be having an effect?

0
Wayne BarronAuthor, Web DeveloperCommented:
If you are experiencing issues, then I strongly suggest backing up your data and re-installing your system.

Question.
Do you have multiple partitions or drives in the system, or just a single drive/Partition?

If you have multiple drives and or partitions, then backing up and re-installing, will be a breeze.

Carrzkiss
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnhardyAuthor Commented:
Thanks for that observation

I do have multiple drives and I do complete backups weekly.

I have a contact who is very experienced in this area and I will talk to him, hopefully he may be able to assist me.

John
0
Wayne BarronAuthor, Web DeveloperCommented:
OK.
Installing systems is a no brainer.
I have a complete instructional example here somewhere on EE.

Good Luck
Carrzkiss
0
johnhardyAuthor Commented:
"I have a complete instructional example here somewhere on EE"
Do you have a url for this Carrzkiss?

I found
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/XP/Q_26451368.html?sfQueryTermInfo=1+10+30+carrzkiss+instal+re+xp

Would that be it?

I have an old dell perhaps I should have a practice on that first the OS system number is on the bottom of the machine.



0
Wayne BarronAuthor, Web DeveloperCommented:
That is one of them.
Let me do some checking.
I have a complete step-by-step that I did here
Back a year or so ago.

Give me a few minutes, and I will see what I can come up with for you.
0
johnhardyAuthor Commented:
Thanks for your help carrzkiss
0
Wayne BarronAuthor, Web DeveloperCommented:
Hey John.
I have run into some issues of my own, with trying to get a site released before Christmas.

Doing a quick YouTube search, I found this
Install Windows XP (Clean Install)

This should give you everything you need.
I will take a look at the video here in a few minutes, to let you know if it gives what I will suggest or not.
0
Wayne BarronAuthor, Web DeveloperCommented:
Never mind, that video is about crap.
Listen, if you want, I can do a writeup for you on how to backup and install
Windows XP.
You will have to open a new Question for it.
If you do, post the link in here, but do not make it just a question for me.
Because others may come in to try to assist as well.
0
johnhardyAuthor Commented:
I seems I have problems with this computer so I think I will need to reinstall xp.

I will raise a new question re this

Thanks Jason and carrzkiss for all the help.
0
johnhardyAuthor Commented:
Thanks for all the help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.