(Resending after a previous try bounced back...)

We have found and fixed a bug in the Webtop under:
        Site Designer -> Site Layout Mgr ->  Page Templates -> Edit Template

The file /opt/allaire/spectra/handlers/system/pagetemplate/edit.cfm,
used to edit an existing page template, contains a variable,
"stRef.compositiontype" that feeds into an SQL statement through 
cfa_recordselect.cfm (an undocumented system tag).  The results of the 
query are stored as qSites, populating the select control for the page 
template's Site Owner.

Unfortunately the stRef.compositiontype is in lowercase, which causes
Oracle to return 0 records, rendering the Edit Template page useless.

The bad line is line 172.
Original code:
        <cfset stRef.compositiontype = "site">

Fixed code:
        <cfset stRef.compositiontype = "SITE">

Our setup: Spectra 1.01, CF 4.51, Oracle 8i, all running on the same
Solaris 7 machine.


Chris Tweney
Media Application Developer
roundpeg
www.roundpeg.com
1700 California Suite 260
San Francisco, CA. 94109
Ph. 415-437-3900 
Fax 415-437-3904
------------------------------------------------------------------------------
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to