This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01C00DB7.5A03581E
Content-Type: text/plain;
charset="iso-8859-1"
Hi Chris
Just a thought but you may be able to use DHTML to synchronize your frames.
Have a look at this URL and see if it's any use, it explains how to achieve
a kinda 'excel freeze panes' effect.
http://www.webreference.com/dhtml/column17/
Hope this is of use
Rich
-----Original Message-----
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: 24 August 2000 06:16
To: Cf-Talk
Subject: Frames Dilemma
Ok, I've successfully avoided using frames for five years and now it's
time for me to pay the piper. I need a little help, though. Here's the
situation:
I'm running two queries - one retrieves a parts inventory list from info
submitted in a search form and the other retrieves location data based
on customer locations. What I want to do (or rather my client wants me
to do) is split the screen into three horizontal frames. The top
frame(frame1.cfm) will display nav buttons on the left, a page heading
(e.g. "Search Results") and then a blurb saying how many records were
found (from the results of the parts query). The middle frame
(frame2.cfm) will just contain the table column headings: Part# (static
text), Description (static text), and from one to eight additional
column headings for locations depending on customer location data (these
column headings will be generated from the query getting customer
locations). The bottom frame (frame3.cfm) will display the results of
the search in columns under the column headings in frame two.
I have this all running fine right now in a single page, but don't fully
understand how to break up the outputs of the queries over the three
frames. To complicate matters, a search can result in thousands of
retrieved records and I'm using a "Next N" implementation to limit the
number of records displayed to 100 per page. Also, the number of
records being displayed at the time (e.g., "Displaying records 201
through 300") needs to go in the top frame, under the page heading, and
the "next 100 records" link goes at the bottom of the records being
displayed in the third frame.
To make things simple for illustration, let's assume the search form
page calls a file "mainframe.cfm" which holds this frameset:
<frameset rows="33%,15%,*">
<frame name="topframe" src="frame1.cfm" marginwidth="10"
marginheight="10" scrolling="auto" frameborder="0">
<frame name="midframe" src="frame2.cfm" marginwidth="10"
marginheight="5" scrolling="auto" frameborder="0">
<frame name="botframe" src="frame3.cfm" marginwidth="10"
marginheight="10" scrolling="auto" frameborder="0">
</frameset>
Now my question: should both queries be run in the mainframe.cfm file
and then the results somehow passed to the frames where they are used
(if this is even possible), or should the queries be run individually in
the separate frames? Or since the frames share the results of the
queries, do I need to run duplicate queries in each of the frames?
To review, the top (frame1) and bottom (frame3) frames will need to use
the results of the query that retrieves parts info from whatever the
customer enters in their search. Frame 2 uses results from the query to
dynamically build the column headers for locations. But the bottom
frame (frame3) will also use a list of variables created by the results
of the query that gets customer location info (I loop over the location
variables to retrieve quantities under each location heading). Does
this make sense?
Any pointers on how to approach this would be greatly appreciated. TIA!
Chris Montgomery [EMAIL PROTECTED]
Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner & NetObjects Reseller
210-490-3249/888-745-7603 Fax 210-490-4692
Find a Job in San Antonio http://www.sajobnet.com
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------_=_NextPart_000_01C00DB7.5A03581E
Content-Type: application/octet-stream;
name="Richard Moger (E-mail).vcf"
Content-Disposition: attachment;
filename="Richard Moger (E-mail).vcf"
BEGIN:VCARD
VERSION:2.1
N:Moger;Richard
FN:Richard Moger (E-mail)
ORG:James Villa Holidays Ltd
TITLE:IT Manager
TEL;WORK;VOICE:+44 (01732) 840846
TEL;CELL;VOICE:+44 (0777) 953 8192
TEL;WORK;FAX:+44 (01732) 872093
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Regents Court=0D=0ALondon
Road;Addington;Kent;ME19 5PL;United Kingdom
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Regents Court=0D=0ALondon Road=0D=0AAddington,
Kent ME19 5PL=0D=0AUnited Kin=
gdom
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20000707T003119Z
END:VCARD
------_=_NextPart_000_01C00DB7.5A03581E--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
