Re: nesting custom tags

2004-04-09 Thread Jennifer Knoblock
The first tag...

cfset dsn=caller.dsn

cfquery name=getSets datasource=#dsn#
select * from TMSSets where TMSSETID='#attributes.setid#' order by tmssetid
/cfquery

	cfif getsets.Router is 1
	cfset Complist=GWS,ADUA,DSA,Router
	cfelse
	cfset Complist=GWS,ADUA,DSA
	/cfif
	
	cfloop list=#CompList# index=i
	
	cf_TMSStatusColor setid=#attributes.setid# type=#i#
	cfquery datasource=#dsn#
	update ComponentStatus set FENStatus='#FENStatusBackground#' where setid='#attributes.setid#' and comptype='#i#'
	/cfquery
	
	cf_TMSStatusColorIAVA setid=#attributes.setid# type=#i#
	cfquery datasource=#dsn#
	update ComponentStatus set IAVAStatus='#IAVAStatusBackground#' where setid='#attributes.setid#' and comptype='#i#'
	/cfquery
	/cfloop
	
	cfset FullList=GWS,ADUA,DSA
	cfif getsets.router is 1
	cfset FullList=ListAppend(FullList, Router)
	/cfif
	cfif getsets.TACLANE is 1
	cfset FullList=ListAppend(FullList, TACLANE)
	/cfif
	
	cfloop list=#FullList# index=i
	cf_TMSStatusColorAI setid=#attributes.setid# type=#i#
	cfquery datasource=#dsn#
	update ComponentStatus set AIStatus='#AIStatusBackground#' where setid='#attributes.setid#'
	/cfquery
	/cfloop
/cfloop

CFQUERY NAME=getComps datasource=#dsn#
select * from componentstatus where setid='#attributes.setid#'
/CFQUERY

cfloop query=getcomps
cfif (getcomps.fenstatus is 'red') OR (getcomps.iavastatus is 'red') OR (getcomps.aistatus is 'red')
cfset myoverallstatus='red'

cfelseif (getcomps.fenstatus is 'green' and getcomps.iavastatus is 'green' and getcomps.aistatus is 'green')
cfset myoverallstatus='green'

cfelseif (getcomps.fenstatus is 'yellow' OR getcomps.fenstatus is 'green') and (getcomps.iavastatus is 'yellow' OR getcomps.iavastatus is 'green') and (getcomps.aistatus is 'yellow' OR getcomps.aistatus is 'green')

cfelse
cfset myoverallstatus='cyan'
/cfif

cfquery datasource=#dsN#
update componentstatus set Overallstatus='#myoverallstatus#' where setid='#attributes.setid#' and comptype='#i#'
/cfquery
/cfloop
hr
cfloop query=getsets
CFQUERY NAME=getComps2 datasource=#dsn#
select setid,overallstatus from componentstatus where setid='#attributes.setid#'
/CFQUERY
!---create list and loop over list looking for red, then yellow and finally greens---

cfset StatusList=valuelist(getcomps2.overallstatus)
cfloop query=getcomps2
cfif len(statuslist) is 0
cfset MySetoverallstatus='green'
cfelse
	cfif ListContainsNoCase(statuslist, 'red')
	cfset MySetoverallstatus='red'
	cfelseif ListContainsNoCase(statuslist, 'yellow')
	cfset MySetoverallstatus='yellow'
	cfelse
	cfset MySetoverallstatus='green'
	/cfif
/cfif
/cfloop
cfquery datasource=#dsn#
update TMSSets SET Overallstatus='#mysetoverallstatus#'
where tmssetid='#attributes.setid#'
/cfquery

TMSStatusColor - the first custom tag that the one above calls...

cfset dsn=#caller.dsn#
cfif attributes.type is not 'TACLANE'
cfquery name=getsoftware datasource=#dsn#
select * from dmssoftwarebaseline where dmscomponent='#attributes.type#'
/cfquery
cfset THECriteria=

cfloop query=getsoftware
cfset statusbackground=orange
cfset TheSoftware=Getsoftware.DMSComponent  getsoftware.DMSProduct
cfset thecriteria=TheSoftware  '='    'yes'    ' OR '  TheCriteria
/Cfloop
cfset thecriteria=left(Thecriteria, len(thecriteria)-4)
cfset Thecriteria='('  TheCriteria  ')'
cfset THecriteria= thecriteria  ' and (Fens.Status = ''Closed. Applicable to TMS''
and FenFinal.finalrecommendation=''Closed. Applicable to TMS''
and Fens.Fennumber=Fentestlabreview.fennumber 
AND FENs.FENNumber NOT IN (select FENNUMBER 
			from FEN2COmponent 
			where TMSSETID=''#attributes.setid#'' 
			AND DMSCOmponent=''#attributes.type#''))'	

cfquery name=getfens datasource=#dsn#
select FENs.fennumber, FENTestlabReview.InstallNLTDate
from Fens, FenTestLabReview, FENFinal
where #preservesinglequotes(TheCriteria)# 
/cfquery
cfset caller.FENstatusbackground=orange
	cfif getFENs.recordcount is 0
	cfset caller.FENStatusBackground=green
	
	cfelse
		Cfloop query=getFENs
		cfset CompareDate=DateCompare(getFENs.installnltdate, now(), 'd')
			cfif CompareDate LT 0
			cfset caller.FENStatusBackground=red
			cfbreak
			Cfelseif comparedate gte 0
			cfset caller.FENStatusBackground=Yellow
			/cfif
		/Cfloop
	/cfif
cfelse
cfset caller.FENstatusbackground=green
/cfif
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




nesting custom tags

2004-04-08 Thread Jennifer Knoblock
I have a custom tags that calls other custom tags they are work individually, but I need some help getting them to work altogether. 

Ideally, the parent tagruns a query and loops over the other three child tags and fills in their attribute values with results from the query. The child tags run their update queries and return to the parent tags that then doe sthe final arithmetic and returns a value to the calling page. 

But, my child tags won't run. It says the attribute is undefined.

What am I missing? 

My server is running CF 4.5, so CFCs and UDFs are not an option.
Thanks!
Jen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: nesting custom tags

2004-04-08 Thread Jennifer Knoblock
Can you give some example code?

!---parent tag---
query to get value

loop query !---figure individual component status in each of three areas---

cf_childtaga attribute1=#query.value1#
cfquery updates table with values from childtag a

cf_childtagb attribute1=#query.value1#
cfquery updates table with values from childtag b

cf_childtagc attribute1=#query.value1#
cfquery updates table with values from childtag c

end loop

another loop !---figure components overall status based on status of three areas calculated above---
query processes new inserted values and creates another new value

query updates another table with the new value
end loop

another loop !---figure sets overall status based on the status of the compoents it contains---
query processes new inserted value and processes another new value

query updates another table with the new value
end loop
!---end parent tag---

The attributes the child tags are expecting is a setid and a component type each. I didn't use cfinclude becuase I didn't think I could pass attributes to it. What's cfmodule?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: nesting custom tags

2004-04-08 Thread Jennifer Knoblock
Actually, I think I want it to run both ways. I want the parent tag to set the child tags attributes and then for the child tag use those attribute sto create a new value and to send the new to the parent tag for updating and further calculating. 

Did I just ask for too much?

If I read you correctly, you want the parent tag to update attributes sent
to the child tag. You need to switch it around though. The parent can set
data that the child tag can read using getBaseTagData().
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: nesting custom tags

2004-04-08 Thread Jennifer Knoblock
Oops. Okay, I should probably get the semantics right. (:

Will the 'sorta' code I posted in rplky to the previous post work?

 I have a custom tags that calls other custom tags they are 

I'm not sure what exactly you mean by nested custom tags - it sounds like
you're actually calling one custom tag from within another, but that's not
what people generally mean by nested custom tags. For example, you might
have something like this:

cf_foo attribute=value
	cf_bar attribute=value
	cf_bar attribute=value
/cf_foo

In this nested custom tag example, the CF_BAR custom tag isn't being called
by CF_FOO, but rather by the same page that calls CF_FOO. However, these
custom tags can share variables in various ways - any attributes passed to
either instance of CF_BAR can be associated with CF_FOO using CFASSOCIATE,
and CF_BAR can read attribute values received by CF_FOO using
GetBaseTagData().

In any case, you'll probably have to post the code for the custom tag calls,
as well as for the custom tags themselves, to get a useful answer.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Can Coldfusion Verity be this clever ???

2003-01-16 Thread Jennifer Knoblock
In the ColdFusion Developer's Journal, Vol. 2 Issue 6, there's an article called 
Making the Most of Verity that covers this exactly (with code). I used (and continue 
to use) it myself. It's really slick.
http://www.sys-con.com/coldfusion 

HTH.
Jen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




protecting non-cf files

2002-02-25 Thread Jennifer Knoblock

I'd like to protect some streaming media files for a subscription
based service that would be powered by CF. The server that
ColdFusion runs on isn't powerful enough to run both the streaming
server and the CF server, so the streaming software is on another
server. How can I protect the media files with ColdFusion?

I figured out that I can restrict access to the html/cfm pages
that have links to the media files, but not the media files
themselves. Is there any way to do this?

Thanks!
Jen
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



excessive server restarts

2002-02-06 Thread Jennifer Knoblock

My CF Server 4.5 SP2 Professional for Linux has restarted 11 times
already today (11:30 am). Yesterday it restarted 30 times. A few
days ago it was only 5 or 6 times. Can someone tell me why it's
doing this and how to fix it?

Thanks!
Jen
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: excessive server restarts

2002-02-06 Thread Jennifer Knoblock

I don't know what to look for. There's a bunch of timeouts, but not any
more than we usually see in a day.
Jen

Douglas Brown wrote:

 Take a look in your CF logs and see what is going on.

 There are two major products that come out of Berkeley: LSD and [Unix]
 BSD. We don't believe this to be a coincidence.

 Doug Brown
 - Original Message -
 From: Jennifer Knoblock [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, February 06, 2002 8:37 AM
 Subject: excessive server restarts

  My CF Server 4.5 SP2 Professional for Linux has restarted 11 times
  already today (11:30 am). Yesterday it restarted 30 times. A few
  days ago it was only 5 or 6 times. Can someone tell me why it's
  doing this and how to fix it?
 
  Thanks!
  Jen
 
 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: excessive server restarts

2002-02-06 Thread Jennifer Knoblock

Is it really going to make that much difference? Does 5.0 on Linux run th
at much
better?

Michael Corrigan wrote:

 Yeah, upgrade to 5.0 ;-)

 Michael Corrigan
 Programmer
 Endora Digital Solutions
 1900 S. Highland Avenue, Suite 200
 Lombard, IL 60148
 630-627-5055 x-136
 630/627-5255 Fax
   - Original Message -
   From: Jennifer Knoblock
   To: CF-Talk
   Sent: Wednesday, February 06, 2002 10:37 AM
   Subject: excessive server restarts

   My CF Server 4.5 SP2 Professional for Linux has restarted 11 times
   already today (11:30 am). Yesterday it restarted 30 times. A few
   days ago it was only 5 or 6 times. Can someone tell me why it's
   doing this and how to fix it?

   Thanks!
   Jen

 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



corrupted server memory

2002-02-01 Thread Jennifer Knoblock

Being new to CF, I launched an application that used session
variables without single-threading or locking anything. I now know
that not doing these things can corrupt server memory. I've since
turned on single-threading until I get everything locked, but I
was wondering if I had really messed up the server. Will
restarting the server fix any memory corruptions (that dumps all
the CFIDs and CFTOKENs right?)? I've noticed in the logs that the
CF server keeps restarting (several times a day), is it because
the server's memory is corrupted or maybe something else?

Any help would be much appreciated.
Thanks!
Jen
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



IE 5 and session variables

2002-01-24 Thread Jennifer Knoblock

Is there something weird about how IE 5 handles session
variables/cookies? I created a password-protected site that uses
session variables to keep track of what folks have access to after
they login, but users with IE 5.0 keep having problems. The nice
folks at Figleaf gave me a little app. to make sure that cookies
were being set, so I know that these users have cookies turned on.
After they login it they get the succesful login screen, but then
trying to go to any other page they get the access denied page. My
site works with IE 5.5 and IE 6 and Netscape 4.7x and above (can't
find anybody with a lower version).

Any suggestions?
Jen
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



what is going on??

2001-12-04 Thread Jennifer Knoblock

I can't figure out what's going on with this code. I create a
simple page that has a cfoutput block. I upload it to the server
and the cfoutput block and everything in it disappears, but the
static HTML code still renders like it should. Although extra HTML
code appears when I view the page source. I've recreated this page
in CF Studio, Dreamweaver and good old Notepad and this keeps
happening.  Has anyone had this problem before? What's going on?

Here are the original and the source from the parsed document:

My original:
html
head
/head

body bgcolor=yellow
cfquery name=getinfo datasource=elrsub2
select ContactName, ContactEmail, SubID
from Subscribers
where SubID=8391
/cfquery

pYour account's username and password were sent to cfoutput
query=getinfo#ContactName# at #ContactEmail#./cfoutput/p

pIf this person is longer at your organzation, please contact
[EMAIL PROTECTED]/p

/body
/html


The parsed document:
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN

html
head
titleUntitled/title
/head
body
/body
/html

html
head
/head

body bgcolor=yellow
pYour account's username and password were sent to /p
pIf this person is longer at your organzation, please contact
[EMAIL PROTECTED]/p
/body
/html

If you want to see it,
http://www2.eli.org/elr/dummy/getpassword.cfm.
Thanks!
Jen
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: what is going on??

2001-12-04 Thread Jennifer Knoblock

The application.cfm has the html code in it and browser is rendering it?  That sounds 
very possible. I'll check that out.

Jen
Gantz, Shlomy wrote:

 I would also check your application.cfm for that additional HTML.

 Shlomy

 -Original Message-
 From: Jennifer Knoblock [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, December 04, 2001 5:17 PM
 To: CF-Talk
 Subject: what is going on??

 I can't figure out what's going on with this code. I create a
 simple page that has a cfoutput block. I upload it to the server
 and the cfoutput block and everything in it disappears, but the
 static HTML code still renders like it should. Although extra HTML
 code appears when I view the page source. I've recreated this page
 in CF Studio, Dreamweaver and good old Notepad and this keeps
 happening.  Has anyone had this problem before? What's going on?

 Here are the original and the source from the parsed document:

 My original:
 html
 head
 /head

 body bgcolor=yellow
 cfquery name=getinfo datasource=elrsub2
 select ContactName, ContactEmail, SubID
 from Subscribers
 where SubID=8391
 /cfquery

 pYour account's username and password were sent to cfoutput
 query=getinfo#ContactName# at #ContactEmail#./cfoutput/p

 pIf this person is longer at your organzation, please contact
 [EMAIL PROTECTED]/p

 /body
 /html

 The parsed document:
 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN

 html
 head
 titleUntitled/title
 /head
 body
 /body
 /html

 html
 head
 /head

 body bgcolor=yellow
 pYour account's username and password were sent to /p
 pIf this person is longer at your organzation, please contact
 [EMAIL PROTECTED]/p
 /body
 /html

 If you want to see it,
 http://www2.eli.org/elr/dummy/getpassword.cfm.
 Thanks!
 Jen
 [EMAIL PROTECTED]

 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: what is going on??

2001-12-04 Thread Jennifer Knoblock

It should print the contact name and email address, but it's just not printing 
anything in the cfoutput tags. The
line should read Your account's username and password have been sent to Joe Schmoe 
and [EMAIL PROTECTED]
Instead the sentence stops at have been sent to and then nothing.
Jen

Bryan Stevenson wrote:

 Do you mean you just can't see the CF code in view source (which you
 shouldn't be able to) or the actual CF code is being removed from the file
 itself?

 Bryan Stevenson
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 p. 250.920.8830
 e. [EMAIL PROTECTED]

 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: what is going on??

2001-12-04 Thread Jennifer Knoblock

Okay, dyslexia had kicked in. I was reversing two digits in the select
statement and there were no results for my transposed number, so when I tried
Mack's idea I had an idea where to look.

Also Shlomy told me to look in the application.cfm file for the extra HTML
code. I had used a blank web document in CF Studio to make my Application.cfm
file and hadn't removed the html tags. That worked great. It's been bothering
me for a long time.

*Sigh* it's been a long day. I feel really stupid.

You guys are great. Many thanks!
Jen

Macarie Neculai wrote:

 
  pYour account's username and password were sent to cfoutput
  query=getinfo#ContactName# at #ContactEmail#./cfoutput/p
 

 Did you check the number of records returned by the query? If the number of
 records is 0 then the CFOUTPUT block will not be displayed.

 Mack.
 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cfloop and group

2001-07-10 Thread Jennifer Knoblock



Bryan Love wrote:

 wow.

 First of all it looks like you've forgotten to use #innerloop# anywhere in
 your code.  The query is hard-coded to use [1] and [2] from the second
 dimension of your array.  Perhaps each item in the first dimension contains
 a sub-array of only two items (documentID and headingID).  If this is the
 case then why are you looping over the second dimension?  This would cause
 the exact same query to be run twice, outputting the same single record each
 time.  If this is the case then just eliminate the inner CFLOOP and remove
 GROUP= from the CFOUTPUT.

The innerloop was a leftover from the code in Chapter 9 of the Developing Web 
Applications with ColdFusion book.
Where I hard coded the 1 and 2 had been where innerloop would've been. I knew that 
column 1 was headingids and
column 2 was docids, but I needed to loop through all the pairs of ids to find and 
output the actual names of
documents and headings. I took the innerloop and group out and got the same result was 
before.


 Secondly, putting a query inside a double nested loop is not a very good
 idea.  CFOUTPUT was given a GROUP attribute to avoid this kind of situation;
 it's just a matter of learning to use it correctly.  It looks like you are
 basically trying to  print the collection of documents stored in the
 original array.

The only reason the query is inside the loop is so I can refer to the elements inside 
the array in my query. I'm
not trying to use cfloop to group it, just use it to retreive the ids for the array so 
the query can use them to
get the names (and other associated information). I don't know how else to retreive 
the information in the array
without looping.


 a query like this would be much more efficient:

 SELECT ...
 FROM ...
 WHERE document.documentid IN (...docID list...)
 AND headingid IN (...headingID list...)
 AND (join document and heading somehow here so ensure the proper
 records are related to each other)
 and document.nameno=articlenames.nameno
 and document.documentid=article.documentid
 order by headingname, articlename

 Then you can use the GROUP attribute in your CFOUTPUT to control the output

 FYI:  GROUPs can be nested...

 cfoutput query=myQuery group=group1
 cfoutput group=group2
 cfoutput
 


That last AND (join document and heading somehow here so ensure the proper records are 
related to each other) is
the problem. I can't figure out how to do it without cfloop. The two columns of the 
array were originally 2
query-driven lists that I converted into an array. So I thought I'd use listgetat to 
synchronize the position in
the lists, but that would require using a loop to go through the lists.

Any ideas on how to sync the lists without looping?

Thanks!
Jen


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cfloop and group

2001-07-05 Thread Jennifer Knoblock

Hello! (It's good to see all of you back!)

I posted this on Allaire/Macromedia support forums also, but I
really, really need an answer to this...
Is there some reason CF group wouldn't work if it was wrapped up
in cfloop tags? I can't get this query to group the the articles
underneath the headingname.

cfloop index=outerloop from=1 to=#arraylen(anotherarray)#
cfloop index=innerloop from=1
to=#arraylen(anotherarray[outerloop])#

cfquery name=lastone datasource=elrcumulative
select Document.documentid, document.nameno, volume,
page, articlenames.nameno, articlename, article.documentid,
authors, authorsextra, headingid, headingname
from document, articlenames, article, heading
where document.documentid=#anotherarray[outerloop][2]#

   AND headingid=#anotherarray[outerloop][1]#
   and document.nameno=articlenames.nameno
   and document.documentid=article.documentid
   order by headingname, articlename
/cfquery

cfoutput query=lastone group=headingname
H4#HEADINGNAME#/H4
UL
cfoutput
LI#articlename#/LI
/cfoutput
/UL
/cfoutput


/cfloop
/cfloop

Thanks!
Jen


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



self-referring table?

2001-06-27 Thread Jennifer Knoblock

Hi!

I have an Access table that holds the hierarchy of headings (for a
topical index) for a large law and policy journal, and I'm very,
very confused about how to use it. The columns it has are
parentheadingID, childHeadingID fields, and haschildren (which
somehow relates to the number of levels). When the ParentID and
Child ID are equal that's a top heading. Then you bounce down the
rows to the final heading for that branch by matching the
childheading id of the first row to the parentheading id of
another row, then take that row's childheadingid to find the next
parentheadingid...ad nauseum... until the last childheadingid
doesn't appear as another parentheadingid.

I'm sure this type of table or logic has a name and has been used
before. What is it called? Are there some examples I can see to
better understand how to use this in my CF code?

Thanks!
Jen







~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cfm-resources?

2001-05-14 Thread Jennifer Knoblock

They went down over the weekend to install a wireless t1 connection for the
freebie sites.

From an email I got last week from cfm-resources.com...
 We'd like to let you know that we have just ordered a Wireless T1
connection strictly for the free sites, therefore we will be turning
them off for two days.  Starting May 11th, 2001 until May 13th, 2001.  This
is a necessary action, to provide better service and much more
reliability.

A dedicated T1 connection will be in place only for the free server,
therefore giving our free customers faster access and more uptime!  We
do however appologize for the downtime, but it is necessary for the
system to be installed on that machine.  After May 13th, 2001 you will no
longer  experience downtime.  All paying sites (Bronze and higher, will remain
up with no changes to the sites, whatsoever).

HTH!
Jennifer


Kay Smoljak wrote:

 Hi all,

 I was wondering if anyone else was having problems with free accounts at
 cfm-resources.com? First my password stopped working, and when I got no
 response to repeated emails, I gave up and signed up for another account.
 (Incidently, after a number of errors were thrown in the registration
 scripts, I ended up with three accounts but that's a different story.)

 Attempts to FTP in are successful after on average three or four timeouts.
 Everytime I do actually manage to connect, it timeouts before I can upload
 any files. The site itself takes ages to load and then I get server errors.
 The cfm-resources control panel is not even up.

 Now, before you tell me that you get what you pay for, I totally agree. I'm
 developing a site for a non-profit organisation with next to zero funding,
 which promotes science and technology career paths for high school students,
 girls in particular. The aim is to create a site that they can update and
 maintain themselves, thereby requiring no more funding for web work. My plan
 being, if I can get the site running on the free hosting service, and they
 see how great and easy it is and maybe interest some benefactors, I will get
 them to move to one of the low cost hosting services. Hell, I was even
 planning to pay for some of it myself. I'm not expecting great reliability
 or speed out of a free service. But at the moment *I* can't even view the
 site, and it's been like that all week.

 What I would like to know is, what is the reliability like on their paid
 accounts? I'd be reluctant to risk them after my experiences with the free
 service. What are the other low cost hosting services out there like?

 Sorry to bitch but this is driving me insane!

 Kay.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT but VIQ: Denial of Service Attacks

2001-04-30 Thread Jennifer Knoblock

Cyberwar! Are web sites combatants or the battleground?

Also, I have dedicated server at my ISP for my CF site. What questions do I need to be 
asking my ISP about security
and how do I find out what I need to do (or can do) to protect my site? I'm just 
starting and don't know much about
security or servers

Thanks!
Jennifer

Michael Dinowitz wrote:

 *** Team Allaire ***
 I do a security scan of my system every now and again using whisker from RFP
 (http://www.wiretrip.net/rfp/2/index.asp). I suggest everyone either do the
 same or ask someone you trust to do it for you. It takes little time to do
 and the rewards could be massive (especially with the supposed cyberwar
 coming).


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists