From: AbsolutTheory on
I have done a search to try and find a sloution before posting, but all I could
find was information relating to DM8, so I apologise if this has already been
answered and I missed it.

I am using DM9 (build 3481), it is a legitimate copy, installed right from the
retail disc and if fully up to date (patches and the like). The problem is that
on seemingly random pages DM will crash, all of these pages have html as well
as cf code in them, the page length doesn't seem to be a factor (both short AND
long pages crash), but not all mixed code pages crash. The documents open fine,
but as soon as I attempt to highlight or edit code DM dies. I have had the same
issue on both XP and Vista and on several different systems. I can open the
same pages in DM8 with no issue.

If anyone has had the same problem and knows how to solve it, your help would
be greatly appreciated. I am a loyal adobe/macromedia user, but this is truly
becoming tiresome. Example of a page that crashed DM is attached (is legacy
code, so please no comments on the code itself).

Thanks is advance.

<cfsilent>
<!--- Defaults and constants --->
<cfparam name="url.mr" default="25" />
<cfparam name="url.sr" default="1" />
<cfparam name="url.nCategoryId" default="" />
<cfparam name="url.nListingLevelId" default="" />

<cfif isDefined('session.storedForms.filterListingContacts')>
<cfset form.nCategoryId =
session.storedForms.filterListingContacts.nCategoryId>
<!--- <cfset form.nListingLevelId =
session.storedForms.filterListingContacts.nListingLevelId> --->
</cfif>
<cfparam name="form.nCategoryId" default="">
<cfparam name="form.nListingLevelId" default="">

<cfset paginationTemplate =
'?module=object&action=object_exportContactDetails&nCategoryId=#form.nCategoryId
#' />

<!--- Get the category and listing level data for the filter form --->
<cfmodule template="queries/qry_getCategories.cfm"
query="getTopLevelCategories" categoryDepth="1">
<cfmodule template="queries/qry_getCategories.cfm" query="getCategories">
<!--- <cfmodule template="queries/qry_getListingLevels.cfm"
query="getListingLevels"> --->

<!--- Get the member list based on search criteria --->
<cfquery name="qListingContactsList"
datasource="#request.server.database.dsn#"
username="#request.server.database.dbuser#"
password="#request.server.database.dbpassword#">
select distinct(tUsers.userId), tUsers.userLogin, tUsers.userFirstname,
tUsers.userLastname, tUsers.userEnabled,
tContacts.contactEmail, tContacts.contactPhone, tContacts.contactMobile

from in_objects tObjects
left outer join in_categories tCategories
on tObjects.objectPrimaryCategoryId = tCategories.categoryId
left outer join in_lu_ownerObjects tO2O
on tObjects.objectId = tO2O.objectId
left outer join in_members tContacts
on tO2O.userId = tContacts.userId
left outer join in_users tUsers
on tO2O.userId = tUsers.userId

where 0 = <cfqueryparam cfsqltype="cf_sql_integer" value="0">
<cfif form.nCategoryId neq ''>
<cfif not findNoCase('_All', form.nCategoryId)>
AND tObjects.objectPrimaryCategoryID = <cfqueryparam
cfsqltype="cf_sql_integer" value="#form.nCategoryId#">
OR tObjects.objectID IN (SELECT objectID FROM in_lu_objectCategories
WHERE categoryID = <cfqueryparam cfsqltype="cf_sql_integer"
value="#form.nCategoryId#">)
<cfelse>
AND tCategories.categorySectionID = <cfqueryparam
cfsqltype="cf_sql_integer" value="#left(form.nCategoryId, len(form.nCategoryId)
- 4)#">
OR tObjects.objectPrimaryCategoryID = <cfqueryparam
cfsqltype="cf_sql_integer" value="#left(form.nCategoryId, len(form.nCategoryId)
- 4)#">
</cfif>
</cfif>
<cfif not isDefined('form.showall')>
AND tUsers.userEnabled = 1
</cfif>
order by tUsers.userLastname asc, tUsers.userFirstname asc
;

</cfquery>

</cfsilent>

<style>
table.searchPanel {
width:100%;
height:24px;
padding:5px;
border:1px solid silver;
line-height:24px;
vertical-align:middle;
}

table.searchPanel .checkbox { position:relative; top:4px; }

table.exportRowView {
width:100%;
/* border-collapse:collapse; */
background-color:#d1d1d1;
}
table.exportRowView tr { background-color:#eee; }
table.exportRowView th { text-align:left; vertical-align:middle; padding:3px
5px; font-weight:normal; }
table.exportRowView td { text-align:left; vertical-align:middle; padding:5px;
color:#666666; }
</style>

<!--- Search form --->
<form name="filterListingContacts"
action="?module=object&action=object_exportContactDetails" method="post">
<input type="hidden" name="storeform" value="1">
<input type="hidden" name="formname" value="filterListingContacts">
<table class="searchPanel">
<tr><td>
<span style="float:left;">
Filter by category:
<cfoutput>
<select name="nCategoryId" id="nCategoryId" class="textBox">
<option value="">All Categories</option>
<option value="">#RepeatString("-", 15)#</option>
<cfloop query="getTopLevelCategories">
<option value="#categoryId#_All" <cfif form.nCategoryId EQ
"#categoryId#_All">selected</cfif>>All #categoryName#</option>
</cfloop>
<option value="">#RepeatString("-", 15)#</option>
<cfloop query="getCategories">
<option value="#categoryId#" <cfif form.nCategoryId EQ
categoryId>selected</cfif>>#RepeatString("&nbsp;&nbsp;",categoryDepth-1)##catego
ryName#</option>
</cfloop>
</select>
</cfoutput>
<label for="showall" style="margin-left:15px;">Include disabled
users?</label><input type="checkbox" class="checkbox" name="showall"
id="showall" value="1" style="margin-right:25px;">
<!---
Filter by listing level:
<cfoutput>
<select name="nListingLevelId" class="textBox">
<option value="">All Levels</option>
<cfloop query="getListingLevels">
<option value="#listingLevelId#" <cfif form.nlistingLevelId eq
listingLevelId>selected</cfif>>#listingLevelName#</option>
</cfloop>
</select>
</cfoutput>
--->
</span>

<span style="float:right;">
<input type='submit' name='search' id='search' value='search'>
&nbsp;&nbsp;
<input type="submit" name="export" id="export" value="export">
</span>

</td></tr>
</table>
</form>

<!--- Pagination --->
<cfmodule template="../../globals/act_generateRecordPaging.cfm"
recordcount="#qListingContactsList.recordcount#"
currentTemplate="#paginationTemplate#">
<br><br>

<cfoutput>
<table class="exportRowView" border="0" cellspacing="1" cellpadding="2">
<tr>
<th style="width:30px;"><span class="formtext">ID</span></th>
<th style="width:220px;"><span class="formtext">Username</span></th>
<th style="width:220px;"><span class="formtext">Last Name</span></th>
<th style="width:220px;"><span class="formtext">First Name</span></th>
<th><span class="formtext">Email Address</span></th>
<th style="width:100px;"><span class="formtext">Phone</span></th>
<th style="width:100px;"><span class="formtext">Mobile</span></th>
<th style="width:45px; text-align:center;"><span
class="formtext">Enabled</span></th>

</tr>
<cfset rowCount = 0>
<cfloop query="qListingContactsList" startrow="#url.sr#" endrow="#url.sr +
url.mr - 1#">
<cfset rowColour = iif(rowCount mod 2 eq 1, de(Request.visuals.rowColor1),
de(Request.visuals.rowColor2))>
<tr style="background-color:###rowColour#;">
<td>#userId#</td>
<td>#userLogin#</td>
<td>#userFirstname#</td>
<td>#userLastname#</td>
<td>#contactEmail#</td>
<td>#contactPhone#</td>
<td>#contactMobile#</td>
<td style="text-align:center;">#iif(userEnabled, de('Yes'), de('No'))#</td>
</tr>
<cfset rowCount = rowCount + 1>
</cfloop>

</table>
<br><br>

<!--- Pagination --->
<cfmodule template="../../globals/act_generateRecordPaging.cfm"
recordcount="#qListingContactsList.recordcount#">
<br><br>

</cfoutput>

From: Katsuey on

"AbsolutTheory" <webforumsuser(a)macromedia.com> wrote in message
news:fvljst$sgm$1(a)forums.macromedia.com...
The documents open fine,
> but as soon as I attempt to highlight or edit code DM dies. I have had the
> same
> issue on both XP and Vista and on several different systems. I can open
> the
> same pages in DM8 with no issue.

I had the same problem (though didn't have DW8 installed and didn't have the
problem on my Vista machine) and found that a repair of DW CSS3 did the
trick. The fact that you have it on both machines is particularly
disconcerning
because it means you have a bad install file - not just something that went
wonkie with one. Try downloading the "trial" file from Adobe (which is
exactly the same feature set - your license # will activate it). Remember to
deactivate your current license before you do this.