Thanks for finding this- we had seen one other case of lowercase values
being introduced and hadn't been able to localize the problem. This would
affect all case sensitive DBs.
I have merged the below fix into the source tree for the next major release!
-charles
-----Original Message-----
From: Chris Tweney [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 24, 2000 12:48 PM
To: '[EMAIL PROTECTED]'
Subject: Case Sensitivity bug found in Page Template editor
(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.
------------------------------------------------------------------------------
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.
