Re: FileMaker Pro Backend DB?
The only real reason to use FMP as a back-end database is if people are still access it through the regular FMP interface. Sharon - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 7:05 PM Subject: Re: FileMaker Pro Backend DB? It will take me a while to dig up the info on how to do this -- I will post later. I'd appreciate that. Since the site isn't expecting heavy traffic, I was thinking a migration over to MS Access or MySQL if necessary. I don't think the project warrants moving up to SQL server or similar. - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: WHYYYYY!!!!!!
1, is it in fact necessary in MX and It's pretty much necessary regardless of MX. 2, Is an Application.array the best place to store this kind of thing? That depends. Is the information something that is shared across the application and not something that changes frequently? If so, absolutely. I tend to copy these things (under locking) to Request scope for reading. This way I don't have to have cflock's around large blocks of code. Sharon __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
cfgraph bug
How do I go about reporting a bug with CFGRAPH? It's a glitchy little thing where the graph displayed matches the data, but the rollover values are wrong. I've attached a file that displays the problem. It's self-contained (I wddx-encoded the query in question.) Notice the first two rollover values. They're obviously differently sized bars, as they should be based on the query displayed below the graph. But the rollover values are the same, and one of them is wrong. I've identified it as the .52 value being the problem. I don't know if it happens with any other values. So where do I send this so I can get this bug off my bug list and point QA at Macromedia? Sharon DiOrio __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: cfgraph bug
Forgot the file contents. sheepish grin Sharon - BEGIN CFM FILE- !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head cfset wQuery = wddxPacket version='1.0'header/headerdatarecordset rowCount='6' fieldNames='DAY,TOTAL'field name='DAY'stringMonday/stringstringTuesday/stringstringWednesday/stringstringThursday/stringstringFriday/stringstringSaturday/string/fieldfield name='TOTAL'number0.53/numbernumber0.52/numbernumber0.55/numbernumber0.53/numbernumber0.36/numbernumber0.56/number/field/recordset/data/wddxPacket cfwddx action=WDDX2CFML input=#wQuery# output=qQuery body cfgraph type=bar query=qQuery valueColumn=total itemColumn=day fileFormat=flash valueLabelFont=Arial valueLabelSize=8 valueLocation=overBar showValueLabel=rollover scaleFrom = 0 ScaleTo = 1 colorList=blue barSpacing=4 borderColor=black title=test itemLabelFont = Arial itemLabelSize=8 graphHeight=550 graphWidth=550 depth=1 gridLines=1 /cfgraph cfdump var=#qQuery# /body /html - END CFM FILE- __ 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: Coldfusion Apps You've Built
Well, I did go through this phase when I first learned structures where *everything* was put into a structure and stuffed into Application scope. I brought more than one development server to it's knees doing that. But once that data was loaded, it was downright zippy. I'm more thoughtful about how I save stuff in scope now. Especially since locking came onto the scene. I'll occasionally go back and look at stuff and scratch my head. And sometimes I'll find a gem that impresses me even now. Sharon - Original Message - From: Massimo, Tiziana e Federica [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 14, 2002 2:13 PM Subject: Re: Coldfusion Apps You've Built Was there anything that you guys have built for past clients that you now know could have been coded better? The day I will stop having that kind of feeling I will start worrying :-) Massimo __ 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: ahhh query
Wow, you do know that cfscript would clean up that code something fierce.
cfscript
places = queryNew(name);
queryAddRow(places, 4);
querySetCell(places, 'name', 'University of Alabama The', 1);
querySetCell(places, 'name', 'Florida State University', 2);
querySetCell(places, 'name', 'The BlahBlah Institute', 3);
querySetCell(places, 'name', 'The University of Chicago', 4);
/cfscript
cfscript is your friend. Don't fear it. :-)
Sharon
- Original Message -
From: Andre Turrettini [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 24, 2002 10:21 AM
Subject: RE: ahhh query
Dooh, Beat me to it! I'll post it anyway.
cfset places=querynew('name')
cfset temp = QueryAddRow(places,4)
cfset temp = QuerySetCell(places, 'name', 'University of Alabama The', 1)
cfset temp = QuerySetCell(places, 'name', 'Florida State University', 2)
cfset temp = QuerySetCell(places, 'name', 'The BlahBlah Institute', 3)
cfset temp = QuerySetCell(places, 'name', 'The University of Chicago', 4)
cfset re = ^(University of|The University of|The)
CFOUTPUT query=places
#name##left(rereplace(name,re,,all),1)#br
/CFOUTPUT
Results:
University of Alabama The A
Florida State University F
The BlahBlah Institute B
The University of Chicago C
DRE
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 3:36 PM
To: CF-Talk
Subject: Re: ahhh query
That was in neither English nor Geek.
I'll try again.
cfparam name=letter default=A
cfset ignoreWordList=university,of,the,college,institute
cfquery name=qSchools datasource=...
select * from schools where I care
/cfquery
cfset newNameList=ValueList(qSchools.name,|)
cfloop index=word list=#ignoreWordList#
cfset newNameList=replace(newNameList,word,,ALL)
/cfloop
cfset newNameArray=listToArray(newNameList,|)
cfset temp=queryAddColumn(qSchools,newName,newNameArray)
cfquery name=AlphaSchools datasource= dbtype=query
select * from qSchools where left(newName,1)='#letter#' order by name
/cfquery
Jerry Johnson
[EMAIL PROTECTED] 05/23/02 05:27PM
There are smarter/faster/bettter ways. But here is one.
Create a second field, and have that be the name for selection purposes.
Then sort by actual name.
When you insert into the db, put the data in two fields, RealName and
NewName.
If you don't want to precalc this data, or can't , you can do it live, but
it will cost.
I think a simple mask of words you DONT care about can solve this.
Build a list of words that do not matter for the sort.
cfset IgnoreList=university,of,the,college,institute
select em all.
create a list of the name column ValueList()
replace each word in the ignore list with (cfloop through ignore list,
replacing with newNameList with )
list to array
add a column to the query, populating with array (queryAddColumn
query of query to get the list for A, order by original name field
It ain't quick, but it might work.
[EMAIL PROTECTED] 05/23/02 05:05PM
bla...
I have a template topped by the alphabet, all letters are links and they
need to display the correct info from the database on the page when clicked,
However the info that is being sorted will be names such as.
University of Alabama (A)
Florida State University (F)
The BlahBlah Institute(B)
The University of Chicago (C)
so basically the word I need to check the first letter of could be ANYHWERE
in the name
ANY and ALL ideas are appreciated...(short of finding a new line of
work) : )
__
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: Most efficient way to check if two lists
cfset match = 0 cfloop list=#listA# index=i cfif listFind(listB, i) cfset match = 1 /cfif /cfloop HTH! Sharon DiOrio - Original Message - From: Won Lee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 1:57 PM Subject: Most efficient way to check if two lists Hello, Need to find out which way is the most efficient way to see if a value in list A is a value in list B. List A = 1,2,3 VALID ListMatch List B = 2,3,4 List A = 1,2,3 VALID ListMatch List B = 1,4,6 List A = 1,2,3 NOT VALID ListMatch List B = 7,4,6 As long as it has single matching values it is valid. __ 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: Anybody have a nice CFERROR page for me?
Here is what I use: In the Application.cfm: !--- Turn on error handling and turn off debugging code for users --- cfif REQUEST.mode IS normal !--- Error handling --- cferror type=exception template=error.cfm mailto=[EMAIL PROTECTED] cfsetting showdebugoutput=no /cfif !--- error.cfm CONTENTS --- cfoutput h1We apologize!/h1p You've encountered an error. form action=error_submit.cfm method=post table border=0 cellpadding=0 cellspacing=0 tr td valign=topYour Email:/td tdimg src=/images/spacer.gif height=1 width=10 border=0/td td valign=topinput type=text name=emailfrom size=20/td /tr tr td valign=topDescribe what you were trying to do:/td tdimg src=/images/spacer.gif height=1 width=10 border=0/td td valign=toptextarea name=description cols=30 rows=4 wrap=virtual/textarea/td /tr tr tdNotify you when fixed?:/td tdimg src=/images/spacer.gif height=1 width=10 border=0/td td valign=topinput type=radio value=yes name=notify checkedYes input type=radio name=notify value=noNo/td /tr tr tdimg src=/images/spacer.gif height=10 width=10 border=0/td /tr tr td colspan=3 input type=hidden name=diagnostics value=#HTMLEditFormat(error.diagnostics)# input type=hidden name=dateTime value=#error.dateTime# input type=hidden name=browser value=#error.browser# input type=hidden name=template value=#error.template# input type=hidden name=remoteAddress value=#error.remoteAddress# input type=submit name=formSubmit value=Notify Webmaster /td /tr /table /form /cfoutput - Note that I allow the user to choose whether or not to submit the error. This does a pretty good job of preventing multiple notifications for the same error. (The average user will try the page again, and choose not to re-submit the error.) !--- error_submit.cfm CONTENTS --- cfif isDefined(FORM.formSubmit) cfmail [EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=ERROR on yourdomain DATE: #FORM.dateTime# EMAIL: #FORM.emailFrom# NOTIFY: #FORM.notify# DESCRIPTION: #FORM.description# TEMPLATE: #FORM.template# DIAGNOSTICS: #FORM.diagnostics# BROWSER: #FORM.browser# REMOTE ADDRESS: #FORM.remoteAddress# /cfmail /cfif /cfsilent h1Thank You/h1p Your help is appreciated. HTH! Sharon - Original Message - From: Jon Block [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 12:48 PM Subject: Anybody have a nice CFERROR page for me? Anybody have a really nice CFERROR page that mails the site administrator all of the error information plus a listing of the variables and database queries etc? Thanks... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: [admin] List status - A CHALLENGE
ROTFLMAO! My niece lives in East Palatka. Fortunately she still has all her teeth. Sharon - Original Message - From: Shawnea Carter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 7:44 AM Subject: Re: [admin] List status - A CHALLENGE and alligators, water moccasins and creepy guys that have been to one to many bar (For the natives: the ones (guys) in Central Florida that wear that ball cap like thing . . . think Palatka) I shudder. __ 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: A Tip (maybe new, maybe not)
Or you could just run the undocumented function to release it: CFUSION_DBCONNECTIONS_flush() :-) Sharon DiOrio - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 12:32 PM Subject: A Tip (maybe new, maybe not) I don't know if any of you work with Access much as a database here and there, but I have been developing using an access database and had to upload it to our servers after looking at the data or correcting the data as I was writing scripts ..well as you all know it locks so you cannot FTP over it once it has been accessed. I would stop/start the cf service to get this to run, well it became a pain when my terminal window would timeout and I would have to logg back into my server yadda yadda. If you send a bogus query (one with an error), CF or Access will 'unlock' the file for you... and you are back in FTP business. Many of you might already know this .. but we just figured it out and I thought it was pretty slick! Paul Giesenhagen QuillDesign __ 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: How to detect timeout session??
In the application.cfm: !--- Security (show only the login screen if they aren't already logged in) --- cflock scope=SESSION type=exclusive timeout=10 cfparam name=SESSION.loggedIn default=0 cfset REQUEST.loggedIn = SESSION.loggedIn /cflock cfif NOT REQUEST.loggedIn AND NOT FindNoCase(login.cfm, CGI.script_name)) cflocation url=login.cfm cfabort /cfif On the login page, you'd set the session variable loggedIn to equal 1. This catches people who've timed out as well as people who've not logged in yet. Sharon DiOrio - Original Message - From: Mario Martinez [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 11:49 AM Subject: How to detect timeout session?? Hi friends: I need to find an easy way to detect timeout session to redirect the user to a login page in case he has spent too much time without actvity. Any easy way to detect that at the beginning of one template??? regards and thanks in advance Mario __ 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: [admin] List status - A CHALLENGE
Florida has to be the only state with a maximum highway speed limit of 70 and a minimum of 40. Nothing like doin' the slolam through those snowbird caddies. Sharon DiOrio - Original Message - From: Kevin Schmidt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 2:23 PM Subject: RE: [admin] List status - A CHALLENGE Actually I am afraid of getting run over by one of the thousands of old people driving that can't see 10 feet in front of themselves and can't remember where they are going. -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:21 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE What are you afraid of: terrorists, hurricaines, train derailments, voting scandals, tourist taxes, water shortages, impossible traffic, lightning, speaking spanish, Jimmy Buffet, or sunburn? Certainly there's nothing wrong with Florida that Jeb Bush or Janet Reno can't fix. It helps if you say that over and over. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 02:07PM No way, everything happens in Florida, time to share the wealth. What about Buffalo, NY? -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:47 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Perhaps we should start planning the CF-Talk Expo here in Florida? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 01:36PM We get a free gift with our donation, but we have already been consuming that gift. Kevin [EMAIL PROTECTED] 05/14/02 10:13AM Does this mean, that for a donation, we can get a t-shirt, coffee mug, or license plate with a 'Swirly Thing' on it? -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:08 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Yeah - I usually pledge along about Wednesday, just so they will get back to the news ha. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:43 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE I was just going to say that this strategy works great for NPR: Our goal is $5000 this hour, and we've got $3000. C'mon, call us! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:38 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I think you misread my intentions. I figured that if someone could see that the goal was not yet reached then they would be more inclined to donate. People are sometimes apathetic and need to see that a goal was not reached. If, say, someone waits a few weeks before donating they may throw in 10 bucks because they may figure that there were enough donations. If, however, they could see that the donations were a few thousand short then they may be inclined to donate $100. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 12:30 PM Subject: RE: [admin] List status - A CHALLENGE Don't agree.. (a first for me and you Howie! grin) Michael will put to good use whatever is there, and I'm sure will report on what's left after his decisions are made about how to handle things, and what he's put in place. Knowing him, he'll probabaly ask the group. But I trust Michael and his decisions. Don't get me wrong.. I don't think the numbers should be hidden.. And I have NO doubt that Michael is above that. However, ANYTHING he receives from us will be well worth it, for the priceless information we gain from this list, and ultimately his support. Let him handle it, and let him report to us what's there afterwards, if anything. If anything's left, we can all discuss/vote on what to do with it.. I'm sure. Just my .02 __ 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: Recordset to structure?
It depends on what you want the structure to look like. The query structure is ideally suited to manipulating the data as it's returned from the tables. But structures can be any number of things. I tend to use them to create hierarchies. Give us some more information about what you're trying to do, and we'll be able to help you. Sharon - Original Message - From: Kay Smoljak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 12, 2002 2:13 AM Subject: Recordset to structure? Hi all, I'm wondering what the simplest way would be to convert a query recordset to a structure. I know that a recordset *is* a structure, but I would like to copy it to the session scope and add, edit and remove keys as it goes through various scripts. I can't find anything on the developer's exchange. The two options I can see are looping over each record and copying it to a struct, or using Query functions to manipulate the recordset itself. I haven't worked with the query functions very much - are there any limitations to either of these approaches? How about performance? Any pointers would be greatly appreciated. Kay. __ Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd Level 9/105 St George's Terrace - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au http://developer.perthweb.com.au - Tools for Developers cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt __ 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: Preventing SQL injection attacks...?
cfparam type=date|numeric|string|boolean|UUID|... can be used for validating almost anything. It's an underused function. Sharon DiOrio - Original Message - From: Justin Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 12, 2002 12:30 PM Subject: Re: Preventing SQL injection attacks...? won't execute SQL, but only evaluate it as a string input. So if you're expecting numbers, then validate, using isNumeric() or CFQueryParam. Or if you know a value must be numeric, wrap a val() around it. That will knock any text strings down to 0 and prevent an SQL error from being thrown, as well as allow your app to handle the empty record set just as if any other invalid numeric value had been tossed at it. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com __ 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: Dynamic structure key names
I'm jumping in late on this one, but I wanted to throw in my two cents.
Structures (and arrays) are *so* much easier in cfscript, it's not even funny.
cfset payment = structNew()
cfloop query=queryName
cfscript
if (NOT structKeyExists(payment, pkWebUser) {
payment[pkWebUser] = structNew();
}
/cfscript
/cfloop
Throwing in the if statement prevents the structure from being overwritten if there
are duplicate records in the query. This way you can make nested structures much
easier.
(In case nobody else pointed it out, you don't need the dot when using the array
notation.)
Sharon
- Original Message -
From: Kay Smoljak [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 5:11 AM
Subject: Dynamic structure key names
Hi all,
I'm stuck on the syntax for this. I have a structure. What I'm trying to
do is loop over a query, and create a new structure (dynamically named
with the primary key of the record as a structure key) with three values
from that record. I think I must be doing something wrong syntax-wise,
and I can't find any examples in the docs or the archives.
I have tried these (within a query loop):
cfset payment.[due.pkWebUser] = StructNew()
cfset payment.evaluate(due.pkWebUser) = StructNew()
cfset payment.#due.pkWebUser# = StructNew()
But nothing is working so far. Any ideas on how to do this or how it can
be done easier?
Kay.
__
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
Level 9/105 St George's Terrace - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au
http://developer.perthweb.com.au - Tools for Developers
cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: how to tell if a session has expired
cflock scope=SESSION type=exclusive timeout=10 cfparam name=SESSION.isLoggedIn default=0 cfset REQUEST.isLoggedIn = SESSION.isLoggedIn /cflock cfif NOT REQUEST.isLoggedIn AND CGI.scriptname NEQ /login.cfm cflocation url=login.cfm /cfif (Don't forget to check which page their on...otherwise you can setup a nasty loop.) Sharon - Original Message - From: Ben Densmore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 2:39 PM Subject: how to tell if a session has expired Can someone tell me how you can tell if a session has timed out? I just want to redirect someone to a different page if their session has timed out,I can't find any reference to this anywhere, I know it's gonna be something so simple, but can't seem to find it. Thanks, Ben __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Custom Tag Question
I am trying to write a super simple custom tag but im running into problems getting CFQuery information into the custom tag. Is it possible to pass Query data into a custom tag? Yes. The trick is evaluating it before passing it, you can't pass it by reference. It becomes an attribute of the tag. cf_theS query=#getProductList# From within the tag, you can reference the query as #ATTRIBUTES.query#. I recommend copying it to local scope for ease of typing. Sharon DiOrio __ 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: Customtags custom directory
I don't think it will; it'll recurse through them in the order in which they're defined on the server, if I recall correctly. If you need to refer to specific custom tags, use CFMODULE. That's what I was afraid of. I remember that there was a reason for using CFModule, I just couldn't remember what it was...now I remember. I'm off to update some code. ::: sigh ::: Sharon DiOrio __ 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
Customtags custom directory
I see in CF 5.0 you can set the custom tags directory in the cfadmin, rather than the old registry hack we used to have to do. This is a good thing. But I was curious about custom tags with the same names. How does CF figure out which custom tag to use? For instance, we will have multiple versions of the same application running on the same server. All tags will be in a sub-directory called customtags under the root of the application. How will CF know which custom tags belong to which version? Sharon DiOrio (Who just recently re-subscribed after being bumped from the list) __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
cfgraph height
I refuse to believe this. I'm using CFGRAPH to produce some simple bar charts. Here is a sample of the code: cfgraph type=bar query=getndata valueColumn=TOTAL itemColumn=time fileFormat=flash valueLabelFont=Arial valueLabelSize=8 valueLocation=overBar showValueLabel=rollover scaleFrom = 0 ScaleTo = #peak# colorList=blue barSpacing=1 borderColor=black title=blah itemLabelFont = Arial itemLabelSize=8 graphHeight=250 graphWidth=550 depth=1 gridLines=#axis# /cfgraph When I change the graphHeight, you'd assume that because I'm also setting the graphWidth seperately that they are independently controlled. But the entire graph scales according to graphHeight. Any clues? Macromedia's technotes and forums revealed nothing. Sharon DiOrio __ 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: date massaging
ROTFLMAO! I can see I'm not the only one who read that message first... Sharon DiOrio - Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 5:42 PM Subject: Re: date massaging CFSET numdate=03042002 CFSET mydate=left(numdate,2)/mid(numdate,3,2)/right(numdate,4) Watch those subject lines Nick, I was looking forward to hearing how some guy from Utah was massaging his date. ;D --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 27 Mar 2002 15:21:37 -0700 Anyone care to help out a brain-fried guy? I need to know how to convert strings, like the following: 03172002, into a valid date ( 03/17/2002). Thanks in advance. Nick __ 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: Looping over a query with CFSCRIPT
More like:
cfscript
for (i=1; i LTE selProd.recordcount; i=i+1) {
writeOutput(selProd.PR_NAME[i] br);
}
/cfscript
Sharon
- Original Message -
From: VAN VLIET, SCOTT E (SBCSI) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 25, 2002 6:47 PM
Subject: Looping over a query with CFSCRIPT
Is this possible? If so, sample code would be appreciated.
I tried the following, and got an access error (i understand that you
can't
modify currentrow, etc, but one can wish, right ^_^):
cfscript
while (selProd.CurrentRow LTE selProd.RecordCount)
{
writeOutput(selProd.PR_NAME);
writeOutput(br);
selProd.CurrentRow = selProd.CurrentRow + 1;
}
/cfscript
Thanks in advance!
--
SCOTT VAN VLIET
SENIOR ANALYST
SBC SERVICES, INC
Tel: 858.886.3878
Fax: 858.653.6763
Email: [EMAIL PROTECTED]
__
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: cfparam vs. cfif/isDefined/cfset
I tend to set all the commonly used defaults as Request scope variables. No locking, no cfparam, available anywhere. cfscript REQUEST.dsn = myDSN; REQUEST.dbType = dbtype; REQUEST.webRoot = C:/inetpub/wwwroot/; etc... /cfscript PS, Good to know that UDFs are faster. Are there any exceptions to the rule? Sharon - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 11:35 AM Subject: Re: cfparam vs. cfif/isDefined/cfset 1. You should lock the entire group with a CFLOCK and a scope of application. 2. An IsDefined() with a set is actually slightly faster than a CFAPPLICATION. There's even a UDF that does just this and its still faster even with the small UDF overhead. Note that this is limited to the isdefined() then default. When you start doing the other things that a CFPARAM is useful for then the balance changes. At 11:21 AM 3/26/02, you wrote: Here is my application.cfm file: cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0, 0)# cfparam name=application.appnameroot default=/appname cfparam name=application.includesDir default=/appname/includes cfparam name=application.imagesDir default=/appname/images cfparam name=application.menusDir default=/appname/menus cfparam name=application.templatesDir default=/appname/templates cfparam name=application.smapDir default=/appname/smap Should I be locking these cfparam tags? Should I wrap them all in one lock or should I lock each one individually? What is the difference between using cfparam tags as I have above and using cfif with isDefined and cfset to accomplish the same thing? Is one method a better practice than the other? Thanks! George [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: SSL Certificates - provider recommendations?
Be very careful to save all of the key generation information that you create, including the actual key request. If you're installing the key on IIS, create a key backup file, and store that offsite. I second that!!! Nothing worse than having to pay for a new certificate because the developer that installed the original forgot the passwords, key request files...etc. Sharon DiOrio __ 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: Join up datasources
As far as I know, this isn't possible. What is possible is doing two seperate queries and making your own dataset with either QueryNew() or building a structure. Can you give us some more information? Sharon - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 11:15 AM Subject: Join up datasources Is it possible to have a query where you don't specify a datasource and then inside of the query join up more than one datasource. Something like this cfquery Select DSN.Database.Table.Row, differentdsn.database.table.row From dsn.database.table, differentdsn.database.table /cfquery Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ 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: Returning only one record HELP PLEASE!!!!
OK, is query2 only *supposed* to be outputting one record? I don't think you need to group the first query: CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test QUERY=query1 #column1# nbps; #query2.column2# /CFMAIL Sharon DiOrio - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 1:02 PM Subject: RE: Returning only one record HELP PLEASE I am not allowed to post data. but what I put out is very close to what I have.. I have multiple records in both tables and query2 is only outputting one record. cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:54 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE What are you trying to accomplish? The GROUP attribute will only work with the QUERY specified in the top-level CFOUTPUT tag. If you have grouped data, the you could join in the second table instead of querying it separately. Please post some sample data so that I can try to help you a little more. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:49 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAME COLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Application.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:24 AM To: CF-Talk Subject: Returning only one record HELP PLEASE I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Returning only one record HELP PLEASE!!!!
OK, so are the results in query2 dependent upon what's returned in query1 or is it just listing the query results everytime? Sharon - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 1:24 PM Subject: RE: Returning only one record HELP PLEASE query2 can output up to 7 records.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Sharon DiOrio [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:24 PM To: CF-Talk Subject: Re: Returning only one record HELP PLEASE OK, is query2 only *supposed* to be outputting one record? I don't think you need to group the first query: CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test QUERY=query1 #column1# nbps; #query2.column2# /CFMAIL Sharon DiOrio - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 1:02 PM Subject: RE: Returning only one record HELP PLEASE I am not allowed to post data. but what I put out is very close to what I have.. I have multiple records in both tables and query2 is only outputting one record. cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:54 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE What are you trying to accomplish? The GROUP attribute will only work with the QUERY specified in the top-level CFOUTPUT tag. If you have grouped data, the you could join in the second table instead of querying it separately. Please post some sample data so that I can try to help you a little more. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:49 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAME COLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Application.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:24 AM To: CF-Talk Subject: Returning only one record HELP PLEASE I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12
Re: Passing Arrays to Custom Tags
You need to evaluate the array. cf_ShoppingCart Action=GET Scope=CART Value=ALL varName=#myCart# Sharon - Original Message - From: Jared Stark [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 25, 2002 6:07 PM Subject: Passing Arrays to Custom Tags Hello all, My Wrox ColdFusion book says that arrays can be passed to custom tags just like any other variable, but I am getting errors when I try it. I have the following: cf_ShoppingCart Action=GET Scope=CART Value=ALL VarName=myCart which returns an array of shopping cart items into a variable called 'myCart'. I can run: IsArray(myCart) and it returns YES then I pass it to another custom tag: cfmodule template=addWorkingInvoice.cfm Cart=myCart CustomerID=LDH00 addWorkingInvoice.cfm checks to make sure that attributes.Cart is an array, and it keeps failing. Is this not the way to pass an array to a custom tag? Thanks for your help. Jared __ 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: Is there anywhay to work around there not being an IsNull Function
There are a couple of ways to check the status of a structure. isDefined(myStruct) will tell you if the variable has been created isStruct(myStruct) will tell you if the variable is a structure structCount(myStruct) will tell you if the structure has any keys (and how many keys) You can use any combination thereof. Sharon - Original Message - From: Brian Eckerman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:26 AM Subject: RE: Is there anywhay to work around there not being an IsNull Function Right, but if it exists and hasn't been initialized what would be the default value? Or are you not allowed to create a variable without set it's value? -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 11:30 AM To: CF-Talk Subject: RE: Is there anywhay to work around there not being an IsNull Function Well, if it exists, check for the initialization values. - Matt Small -Original Message- From: Brian Eckerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 11:12 AM To: CF-Talk Subject: Is there anywhay to work around there not being an IsNull Function I was woried about declaring a struct, initializing it, and then being able to tell if the init was successfull. IsDeclared would be of no help in this situation, because you could have a struct without having it set up. What is the best way to validate whether a struct has been initialized properly. Brian Eckerman Web Developer __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: moving from application to application
Are these applications all under the same domain? If so, you can set a cookie and check for the cookie, and automatically log them. Sharon DiOrio - Original Message - From: S R [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 22, 2002 2:48 PM Subject: moving from application to application I've run into a problem where there are 4-5 different CF applications running on the password protected part of my website. I'm using Client variables to maintain state. The one thing I'm trying to do is to let Administrators be able to get into all applications. Since my apps each have a different CFAPPLICATION tag on them obviously, the Administrator can't go from one app to another. What's the best way to get around this? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Running code just one time
Within my index.cfm or application.cfm file I want to check if this is the first time that the index.cfm file is loaded. If so, do something otherwise do nothing. The first time loaded at all? The first time loaded for that user's session? The first time loaded for that user ever? Depending on your definition of the first time you can choose the correct variable scope to set to prevent the code from running again. First time loaded at all: Set an application scope variable First time for that user's: Set a session scope variable First time for that user ever?: Set a cookie that never expires. The concept is the same. If the index.cfm doesn't find that variable, it runs the code, otherwise it skips it. HTH! Sharon __ 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: Running code just one time
Here is the exact code you want. You should put it in the Application.cfm insted of the index.cfm so it gets run regardless of what page the user starts out on (they might have a hyperlink to another page). cflock scope=SESSION type=readonly timeout=10 !--- copy to Request scope whether or not the user is logged in, as defined by the existence of a session variable. --- cfset REQUEST.isLoggedIn = IsDefined(SESSION.isLoggedIn) /cflock cfif NOT REQUEST.isLoggedIn !--- if the user has not logged in (ie, this code has not been run before) run the code --- [insert custom tag call here] cflock scope=SESSION type=exclusive timeout=10 cfset SESSION.isLoggedIn = 1 /clock /cfif Now, when the page runs again, the session variable isLoggedIn will prevent the code from running everytime. If you're not clear on the concept of session scope or the application.cfm, please let us know. It makes all the difference for understanding how this might work. Sharon DiOrio - Original Message - From: phumes1 [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 8:53 AM Subject: RE: Running code just one time At 07:31 AM 3/20/2002 -0800, you wrote: Then what you need to do is set this value - cfset auth = #CGI.AUTH_USER# to a session variable. Then on your index.cfm, just check for that session var and if it has anything in it.. if it does do not run the tag, if there is not any value then run the tag and populate the session var.. Make sense? No. It's not the cgi.auth_user I want to check. I think I'm really messing this up... All I want to do is run a piece of code when the user accesses the web site (index.cfm) for the first time after username/password authentication. When the index.cfm is run anytime afterwards the code is ignored. HTH Clint -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 4:56 AM To: CF-Talk Subject: RE: Running code just one time I just thought by saying I want to output some text I could explain it better. I have a custom tag that goes into the NT security and outputs the groups associated with the user which I'm setting in my application.cfm as... I use this variable on everypage to display the username logged in. The thing is when the index.cfm file is loaded again and again I *don't* want the custom tag to execute. Eventually I want to grab all the information from the custom tag and dump it to a database but only ONCE per session. I hope this is clearer...:-) :-) At 07:27 AM 3/20/2002 -0500, you wrote: Expire the session varibale when the user logs out..if you have them log out. Im not clear on what you are trying to do here.. what is it that you are outputting on the first page visit? -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 7:35 AM To: CF-Talk Subject: RE: Running code just one time OK...but won't this session variable always be 1 when the application.cfm is loaded again? Do I have to set the variable to 2 once I output what I want for the first time. I'm missing something here... At 07:02 AM 3/20/2002 -0500, you wrote: When they get logged in, set a flag in application.cfm, such as a session session.beenHereBefore = 1, then in your index page check the value of the variable and output accordingly. HTH, Mike -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 7:07 AM To: CF-Talk Subject: Re: Running code just one time Hi, This is regarding a post from yesterday. Maybe I didn't explain it properly. I had mentioned a custom tag but for now lets just forget about it. I am running IIS on NT 4. All users have accounts on the system. In IIS under the Default Web Site Properties I went into the Directory Security tab and disabled the Anonymous Access and enabled the NT Windows Challenge/Response only. Now when users try to access the web page they are prompted with a username/password Windows authentication dialog. If the correct username/password are entered the user is redirected to my index.cfm file. This is what I would like to do. Within my index.cfm or application.cfm file I want to check if this is the first time that the index.cfm file is loaded. If so, do something otherwise do nothing. Below is just an example... index.cfm or application.cfm -- - Check to see if this is the first time index.cfm file is loaded (at login time) - If so dump some test pLogged in/p If index.cfm is loaded any other time do nothing I'm not sure how to incorporate
Re: Running code just one time
Oops, My bad. Should be cfset REQUEST.isLoggedIn = isDefined(SESSION.isLoggedIn) Need the quotes. ::: hanging head in shame ::: Sharon DiOrio - Original Message - From: phumes1 [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 11:06 AM Subject: Re: Running code just one time I get the following error... Error Occurred While Processing Request Error Diagnostic InformationAn error occurred while evaluating the expression: REQUEST.isLoggedIn = IsDefined(SESSION.isLoggedIn)Error near line 23, column 11. Error resolving parameter SESSION.ISLOGGEDIN The session variable ISLOGGEDIN does not exist. The cause of this error is very likely one of the following things: The name of the session variable has been misspelled. The session variable has not yet been created. The session variable has timed out.The error occurred while processing an element with a general identifier of (CFSET), occupying document position (23:5) to (23:62).Date/Time: 03/20/02 11:06:35 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; msnca3; Q312461) At 10:43 AM 3/20/2002 -0500, you wrote: Here is the exact code you want. You should put it in the Application.cfm insted of the index.cfm so it gets run regardless of what page the user starts out on (they might have a hyperlink to another page). cflock scope=SESSION type=readonly timeout=10 !--- copy to Request scope whether or not the user is logged in, as defined by the existence of a session variable. --- cfset REQUEST.isLoggedIn = IsDefined(SESSION.isLoggedIn) /cflock cfif NOT REQUEST.isLoggedIn !--- if the user has not logged in (ie, this code has not been run before) run the code --- [insert custom tag call here] cflock scope=SESSION type=exclusive timeout=10 cfset SESSION.isLoggedIn = 1 /clock /cfif Now, when the page runs again, the session variable isLoggedIn will prevent the code from running everytime. If you're not clear on the concept of session scope or the application.cfm, please let us know. It makes all the difference for understanding how this might work. Sharon DiOrio - Original Message - From: phumes1 [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 8:53 AM Subject: RE: Running code just one time At 07:31 AM 3/20/2002 -0800, you wrote: Then what you need to do is set this value - cfset auth = #CGI.AUTH_USER# to a session variable. Then on your index.cfm, just check for that session var and if it has anything in it.. if it does do not run the tag, if there is not any value then run the tag and populate the session var.. Make sense? No. It's not the cgi.auth_user I want to check. I think I'm really messing this up... All I want to do is run a piece of code when the user accesses the web site (index.cfm) for the first time after username/password authentication. When the index.cfm is run anytime afterwards the code is ignored. HTH Clint -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 4:56 AM To: CF-Talk Subject: RE: Running code just one time I just thought by saying I want to output some text I could explain it better. I have a custom tag that goes into the NT security and outputs the groups associated with the user which I'm setting in my application.cfm as... I use this variable on everypage to display the username logged in. The thing is when the index.cfm file is loaded again and again I *don't* want the custom tag to execute. Eventually I want to grab all the information from the custom tag and dump it to a database but only ONCE per session. I hope this is clearer...:-) :-) At 07:27 AM 3/20/2002 -0500, you wrote: Expire the session varibale when the user logs out..if you have them log out. Im not clear on what you are trying to do here.. what is it that you are outputting on the first page visit? -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 7:35 AM To: CF-Talk Subject: RE: Running code just one time OK...but won't this session variable always be 1 when the application.cfm is loaded again? Do I have to set the variable to 2 once I output what I want for the first time. I'm missing something here... At 07:02 AM 3/20/2002 -0500, you wrote: When they get logged in, set a flag in application.cfm, such as a session session.beenHereBefore = 1, then in your index page check the value of the variable and output accordingly. HTH, Mike -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 7:07 AM To: CF-Talk Subject
HTML email images?
I've got a client that wants to email dynamically generated HTML reports. Unfortunately, this is on a secured site. I know how to do an HTML email with images pulled from a website, but is there a way to do an HTML email with images as attachments? Sharon DiOrio __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: isdefined
This should work. cfset formName = FORM.Default#name# cfif isDefined(formName) .. Sharon DiOrio - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 3:04 PM Subject: isdefined Here is a tricky one. I might be passing a variable called FORM.DefaultNAME but I get NAME from a list that I am looping over. So: I want to determine is FORM.Default#listelement# isdefined but evaluate doesn't seem to work within an isdefined. Any thoughts? Neil __ 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
cfgraph...revisited...
I know that CFGRAPH returns a dynamically generated file (either flash or jpg). Is there any way to get it to write that file instead? Thanks! Sharon __ 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: UDF question
The server, admittedly, does not host any extremely-high activity sites. There's the kicker. Locking variables is something you can *usually* get away with on low traffic sites. But put any load on these sites and you start getting odd errors that are seemingly sporadic (if you're not familiar with locking issues.) Since none of us truly knows what kind of load a site might ultimately have to support, getting into the habit of writing solid code from the start is a good idea. Sharon DiOrio __ 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: UDF question
- Original Message -
From: Jim Curran [EMAIL PROTECTED]
Just a thought off the top of my head,
1) copy the session structure to a temporary local structure in
Application.cfm:
cflock ...
cfset session_temp = structcopy(session)
/cflock
Actually, this is one of the more common workarounds for locking issues. Although I
usually use REQUEST scope for this so that the variable is available to all templates,
including custom tags. Depending on how much data you've got stuffed into shared
scopes, you can do a wholesale copy of both scopes.
cflock scope=APPLICATION type=readonly timeout=10
cfscript
REQUEST.application = structNew();
for (i IN APPLICATION) {
REQUEST.application[i] = duplicate(APPLICATION[i]);
}
/cfscript
/cflock
Then do the same thing for Session. It does add overhead to the application. But if
the main concern is cleaner code, this can be a viable workaround.
(structCopy() has been deprecated in favor of the duplicate() function.)
Sharon DiOrio
__
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: locking (was: UDF question)
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 11:05 AM Subject: RE: locking (was: UDF question) I know that this is only a typo, but you meant Not locking variables ..., right? Yep. Missed my morning coffee...thanks! Sharon DiOrio __ 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: CFX custom tag
If I'm understanding the question, you can just set a session variable at login/authentication time indicating that the code has been run. cflock scope=SESSION timeout=10 type=readonly cfset loggedIn = isDefined(SESSION.loggedIn) cflock cfif NOT loggedIn !--- run code --- cflock scope=SESSION timeout=10 type=exclusive cfset SESSION.loggedIn = 1 /cflock /cfif HTH! Sharon - Original Message - From: phumes1 [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 1:28 PM Subject: Re: CFX custom tag Hi, I'm using the following custom tag to output the group(s) of specific users. This is in my index.cfm. How can I run the code below just once at login/authentication time. I'm using NT authentication for login purposes. I don't want to run this everytime the index.cfm page is loaded. Its too much overhead. cfset auth = #CGI.AUTH_USER# cfoutput CFX_Users ACTION=GROUPS SCOPE=Local USER=#auth# /cfoutput table tr class=dirlinks thbuGroup(s)/u/b/th /tr cfif IsDefined(Users) cfif IsQuery(Users) cfloop query=Users tr class=navlinks cfoutput td#Group#/td /cfoutput /tr /cfloop /cfif /cfif /table +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CFX custom tag
Depends on what you're doing with it. I frequently do site-wide security where I set variables in the login.cfm then check for those variables in the Application.cfm. Sharon DiOrio - Original Message - From: phumes1 [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 2:37 PM Subject: Re: CFX custom tag This would go in my index.cfm file, correct? At 02:12 PM 3/19/2002 -0500, you wrote: If I'm understanding the question, you can just set a session variable at login/authentication time indicating that the code has been run. cflock scope=SESSION timeout=10 type=readonly cfset loggedIn = isDefined(SESSION.loggedIn) cflock cfif NOT loggedIn !--- run code --- cflock scope=SESSION timeout=10 type=exclusive cfset SESSION.loggedIn = 1 /cflock /cfif HTH! Sharon - Original Message - From: phumes1 [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 1:28 PM Subject: Re: CFX custom tag Hi, I'm using the following custom tag to output the group(s) of specific users. This is in my index.cfm. How can I run the code below just once at login/authentication time. I'm using NT authentication for login purposes. I don't want to run this everytime the index.cfm page is loaded. Its too much overhead. cfset auth = #CGI.AUTH_USER# cfoutput CFX_Users ACTION=GROUPS SCOPE=Local USER=#auth# /cfoutput table tr class=dirlinks thbuGroup(s)/u/b/th /tr cfif IsDefined(Users) cfif IsQuery(Users) cfloop query=Users tr class=navlinks cfoutput td#Group#/td /cfoutput /tr /cfloop /cfif /cfif /table +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ 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: Confessions of a sloppy non-CFLOCKer
Nah, it's the only scope I don't scope. Largely because when CF loops through the variables scopes looking for what scope to use, it hits the local scope first. And because I scope all other variables, there isn't a security problem. Sharon - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 2:49 PM Subject: RE: Confessions of a sloppy non-CFLOCKer You forgot to scope your variables scoped variables. :) Adam. __ 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: Need help with mappings in CF Admin
What you can do is name all includes with a preceeding naming convention, such as an underscore. Then don't pass the entire name in the URL, add the preceeding naming convention in the cfinclude. Allowable include name: _allowed.cfm template.cfm?filename=taboo.cfm cfinclude template=_#URL.filename# You can enclose in CFCATCH and CFTHROW to catch when someone is trying to feed a template that isn't allowed. You can also prevent includes from being called directly by including a little code in the Application.cfm: !--- Disallow calling files directly --- cfif left(CGI.scriptname, 1) IS _ You cannot call this template directly. cfabort /cfif HTH, Sharon DiOrio - Original Message - From: David Grabbe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 2:55 PM Subject: RE: Need help with mappings in CF Admin Are there any safeguards I can use to protect against this? David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 2:57 PM To: CF-Talk Subject: RE: Need help with mappings in CF Admin [snip] Also, it's worth noting that there's a possible security issue in using information from the browser to build the TEMPLATE attribute of a CFINCLUDE tag, since the end user could potentially change that information to reference a file that you don't want to include. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: UDF question
A consultant asking $250/hour and claiming a need to do a full server-under-load analysis would be viewed as an overpriced blowhard. I am actually considering a career as an overpriced blowhard at those rates... I've got the blowhard thing down. How exactly does one become overpriced? Sharon DiOrio __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Meet my tables
Do you have a limit to how many levels the category hierarchy can be? Sharon DiOrio - Original Message - From: Jason Davis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 3:19 PM Subject: Meet my tables Meet my Products table: CREATE TABLE [Products] ( [Product_id] [int] NOT NULL , [Product_title] [varchar] (200) NULL , [Category_id] [int] NOT NULL , ) Each product has a category, meet my categories table: CREATE TABLE [Categories] ( [Category_id] [int] NOT NULL , [Category_parent] [int] NULL , [Category_title] [varchar] (200) NULL , [Category_count] [int] NULL DEFAULT (0) ) As you can see, each category has a Category_parent which symbolize the above category (categories are sorted hirarchly). Can I do some kind of a loop that will run for each Category_id, and store in Category_count the number of Products available in that category, and all of the hirearchy categories beneath? i.e - if I have the following categories: (1) Printers (2) Laser (category_parent=1) (3) Ink (category_parent=1) and the following products: HP LaserJet (category_id = 2) HP Deskjet (category_id = 3) Canon BJ200D (Category_id = 3) category count will be: (1) Printers = 3 (1+2) (2) Laser = 1 (3) Ink = 2 Help!? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: User Preferences
I'd do something like this: !--- set a variable with the allowed extensions --- cfset allowedExtensions = txt,jpg,gif !--- copy the show all flag from session scope --- cflock scope=SESSION type=readonly timeout=10 cfif isDefined(SESSION.showAll) cfset REQUEST.showAll = SESSION.showAll /cfif /cflock !--- get directory contents --- cfdirectory name=dir path=/path/ cfloop query=dir cfif ListFindNoCase(allowedExtensions, listLast(name, .)) OR isDefined(REQUEST.showAll) #name#br /cfif /cfloop HTH,. Sharon - Original Message - From: phumes1 [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 18, 2002 1:16 PM Subject: Re: User Preferences Hi, I have a web interface that lists files on the server. These files have different file extensions. What I would like to do is omit certain files in the listing based on the extension for different users. I'm not sure how to go about it. By default certain exntensions will be omitted unless the user goes into his/her preferences and checks on the input boxes to enable that extension to be listed. Would I use a Access database for this? Any help would be greatly appreciated. +---+ Philip Humeniuk [EMAIL PROTECTED] [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: UDF question
I'm with Raymond. It was a royal PITA to get used to locking all variable access, but now that I'm in the habit, it isnt' that bad. Like most things, I'll choose the extra level of control at the expense of convenience. Should this thread be appended to the difference between a developer and a coder thread? ;-) Sharon - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 18, 2002 3:25 PM Subject: RE: UDF question (Taking off Macromedia cap and speaking as just one of yall...) The question is - do you want CF to automatically handle everything for you at the sacrifice of speed? __ 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: One call for two pages?
OK, then you'll have to copy the results to SESSION scope and call them from
there.
Something along the lines of:
In the first page:
cflock scope=SESSION timeout=10 type=exlusive
cfset SESSION.myQuery = duplicate(myQuery)
/cflock
Then reference it on the second page by copying to local scope.
cflock scope=SESSION timeout=10 type=readonly
cfset myQuery = duplicate(SESSION.myQuery)
/cflock
HTH,
Sharon
- Original Message -
From: Dave Carabetta [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 16, 2002 12:47 PM
Subject: Re: One call for two pages?
How about having the top frame submit to itself and use javascript to
submit
to the bottom frame? Something like:
cfif isDefined(FORM.formSubmit)
script language=javascript
!--
function submitForm() {
myForm.target=otherFrame;
myForm.action=other_action.cfm;
myForm.submit();
}
--
/script
/cfif
I see what you're saying, but that's not what I'm trying to solve. I know
how to get one frame to submit another frame -- that's easy. Essentially
this comes down to trying to force one CF Server call's results to be
available for a second page. It doesn't have anything to do (as far as I
can
figure out) with JavaScript. This is a huge WDDX packet, so storing it in
a
hidden field in one frame is not feasible either.
Thanks though,
Dave.
__
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: Advice and opinion on client who has a problem paying bills
Enter the change request form. Anytime *any* work is performed outside of the scope of the original document, you essentially re-quote it and get a signature before touching a line of code. With nasty clients, this include the 2-minute type error corrections as well. You write up the form with the short description of work and fax it to her. If she agrees, she signs it and faxes it back. If not, you've only wasted the time to fill out the form. Clients get used to this very easily. Most like it because they can justify to *their* managers how the total got so large. Sharon - Original Message - From: Mark Smeets [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 16, 2002 1:13 PM Subject: OT: Advice and opinion on client who has a problem paying bills Hi All, I realize this is off topic but I could use some advice from everyone on this list. I have a client that is very stingy when it comes to paying bills. I've already had one incident with her and that resulted in her getting out of paying the majority of the bill but this time I fear when she gets her next invoice, I'll have more trouble with her. The thing she likes to do is call me up and tell me there's a problem with the site and of course since I'm just being the nice guy (the kiss of death I know) I can just pull the site code up and see if I can find the problem. Now the latest incident was a case of the links page not working correctly, I told her it would take an hour to track down and fix and she put up quite a fuss when I told her that she would be charged for this. (She tried to argue her way out of paying) In the end I went ahead and fixed the problem and I sent her a confirmation email before the work was started as well. She never replied to that confirmation email even though I asked her too. So now I'm wondering what are my options. I know I'm going to have trouble collecting from her, I mean there's more to their next invoice than this links page and she is well aware of my rates. I don't exactly have the funds to take her to small claims court either. The only option I have come up with is this. I can change the administrative status on her account to Disabled instead of Enabled but I think I run into a problem there because they already paid for the web site last year. These are all new changes and problems. I figure if I go this route then the BS will end and at least I will get my money. (She doesn't have FTP access) Any ideas are most welcome, I'm not exactly in a position to just dump her as client but I'm getting sick and tired of being taken for a ride. -- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Life is a series of small victories - Gene Simmons 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=sts __ 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: One call for two pages?
Ack. I don't have much more to offer, except maybe the possibility of using javascript to pass an array of values between the pages. Not something I have a lot of experience with, but it's an idea. Sharon - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 17, 2002 3:44 PM Subject: Re: One call for two pages? OK, then you'll have to copy the results to SESSION scope and call them from there. Something along the lines of: In the first page: cflock scope=SESSION timeout=10 type=exlusive cfset SESSION.myQuery = duplicate(myQuery) /cflock Then reference it on the second page by copying to local scope. cflock scope=SESSION timeout=10 type=readonly cfset myQuery = duplicate(SESSION.myQuery) /cflock Sharon, thanks for your feedback so far. But as I mentioned in a previous post, I'm in a clustered environment, so SESSION variables are out of the question -- even sticky sessions. And I don't want to resort to client variables because the WDDX packet approaches 15K and the overhead involved in returning it with *every* page call would be highly inefficient. Thanks again, Dave. __ 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: One call for two pages?
How about having the top frame submit to itself and use javascript to submit
to the bottom frame? Something like:
cfif isDefined(FORM.formSubmit)
script language=javascript
!--
function submitForm() {
myForm.target=otherFrame;
myForm.action=other_action.cfm;
myForm.submit();
}
--
/script
/cfif
Sharon
- Original Message -
From: Dave Carabetta [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 15, 2002 6:20 PM
Subject: Re: One call for two pages?
How about having the top frame submit to itself. All processing is done
normally and in the end query is set to a session variable with a unique
name. After that you add 1 javascript function using cfhtmlhead. The
function looks something like:
function reloadBottom() {
top.frames[1].location = 'blahblah.cfm?fromcache=#uniquename#';
}
On the resulting request you just grab the query from the session scope
based on the unique name. If it is large don't forget to delete the
session variable afterwards.
The problem with that is two-fold. First, I'm in a clustered environment,
so
I can't use session variables. Second, I am receiving a 15K WDDX packet
back from a Python server that I am de-serializing. So setting the packet
to
a client variable isn't reasonable either. The resulting variable would be
huge and a burden on the CF server because it would inherently be
retrieved
on every CF call within the application.
Also, as a rule of thumb, I always have my forms submit to themselves.
This
allows me to have self-contained forms which are easy to re-use and
maintain.
Regards,
Dave.
__
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: Session Vars and cfquery - cflock where?
Generally speaking, you don't want to put a lock around a process that might take awhile. It slows everything down. Copy the variable to local or request scope before using. cflock scope=SESSION type=readonly timeout=10 cfset REQUEST.myVar = SESSION.myVar /cflock Sharon - Original Message - From: Brunt, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 15, 2002 2:07 PM Subject: Session Vars and cfquery - cflock where? When using a session variable in a cfquery where should the cflocks be? Around the whole cfquery or just around the line calling the session var? Mike Brunt Sempra Energy 213.244.5226 An elephant is a mouse with an operating system. __ 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: ICQ Hottie Spam Bot Turing Test
Looks like the progam Eliza from way back when in my Mac days. If I'm not mistaken, there used to be a dirty-word version of Eliza that would talk dirty to you. Sharon - Original Message - From: David Schmidt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 11:54 PM Subject: Re: ICQ Hottie Spam Bot Turing Test Hehe... And I thought I was her special one... lol. I saw this same thing about 4 weeks ago. - Original Message - From: Sicular, Alexander [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 5:57 PM Subject: RE: ICQ Hottie Spam Bot Turing Test funny stuff -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 8:10 PM To: CF-Talk Subject: OT: ICQ Hottie Spam Bot Turing Test i don't normally post off-topic, but this is a transcript from about 3pm today -- anyone else noticing that these ICQ spam bots are getting smarter? 153545789(15:57 PM) : Hi there , my name is susy was looking on whitepages for similiar interests and your UIN 37946337 came up. I would like to chat with you, how are you? mediahorse(15:58 PM) : are you a real person or are you an icq spam bot? 153545789(15:58 PM) : whoa, so mean i guess ill leave you alone :( mediahorse(15:58 PM) : i get a lot of icq spam -- sorry; i'm not a mean person. every thirty seconds a message comes up with some bot asking me to check out their nude pics. 153545789(15:59 PM) : I have pics on my site :) right here http://61.129.81.58/cams/sus/1/ mediahorse(16:00 PM) : wait a minute -- you ARE a spam bot? a clever one at that. 153545789(16:00 PM) : :( mediahorse(16:01 PM) : are you saying you don't like being called a ro-b-ot? 153545789(16:01 PM) : how old are you ? http://61.129.81.58/cams/sus/1/ mediahorse(16:01 PM) : i am 27. 153545789(16:01 PM) : try and guess my age http://61.129.81.58/cams/sus/1/ mediahorse(16:01 PM) : your page says you are 19. mediahorse(16:02 PM) : not too hard to guess now is it? 153545789(16:02 PM) : i'm so sorry. http://61.129.81.58/cams/sus/1/ mediahorse(16:02 PM) : my compliments to your programmer. you had me going for like the first 3 seconds. 153545789(16:02 PM) : great see you there! mediahorse(16:02 PM) : yeah! go f--k yourself you bot b--ch. 153545789(16:02 PM) : whoa, so mean i guess ill leave you alone :( mediahorse(16:03 PM) : yeah you better. 153545789(16:03 PM) : what ?. http://61.129.81.58/cams/sus/1/ mediahorse(16:03 PM) : oh nevermind. bye bye. 153545789(16:03 PM) : its ok :)buh bye *kisses* http://61.129.81.58/cams/sus/1/ __ 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: Sprectra (WAS: KILL THE BROADVIEW!)
They don't give it away for free, because believe it or not, there are still some people willing to pay for it. Sharon - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 12:58 PM Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!) Too bad they won't give it out for free. If you have a product that you won't support and you don't sell it anymore, why not give it away? I would love a free copy of Spectra, heck that would let me give some support to the spectra source site. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Brunt, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 12:59 PM To: CF-Talk Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!) You're right, here is the URL. http://spectrasource.macromedia.com Mike Brunt Sempra Energy 213.244.5226 A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine. -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 9:20 AM To: CF-Talk Subject: RE: Sprectra (WAS: KILL THE BROADVIEW!) Sort of. There aren't any new versions of it coming out; but it is still available. I think it was said that it was left to the 'community source' model of support? I guess that means that it's not dead, they just stopped feeding it. At 11:15 AM 3/13/2002 -0600, you wrote: Isn't Spectra dead? [EMAIL PROTECTED] 03/13/02 09:11AM Yes perhaps they should try Spectra. Mike Brunt Sempra Energy 213.244.5226 A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 8:58 AM To: CF-Talk Subject: KILL THE BROADVIEW! Arrg!! Someone please rewrite the Macromedia site in something besides Broadview!! It is so stinking slow! I can't even view the darn CF upgrade pricing list without waiting for 2 minutes __ 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
Re: cached query
This is why I tend to cache queries by putting them into application and session scope. It gives me much more granular control over when something changes. The downside is dealing with locks. cfquery name=getStuff datasource=DSNname SELECT stuff FROM table /cfquery cflock scope=APPLICATION type=exclusive timeout=10 cfset APPLICATION.getStuff = duplicate(getStuff) /cflock Then in the application.cfm, I'll copy it to REQUEST scope for ease of use: cflock scope=APPLICATION type=readonly timeout=10 cfset REQUEST.getStuff = duplicate(APPLICATION.getStuff) /cflock For output: cfoutput query=#REQUEST.getStuff #stuff# /cfoutput Although, I'm far more likely to put commonly accessed information into structures, but I'm a bit of a structure freak that way. Sharon - Original Message - From: FARRAH NG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:33 PM Subject: cached query hi all, i have built a website for a client where the home page is totally dynamics ( the cfm file has almost 10 queries accessing 10 different tables in order to populate the page). Now the client is complaining about the slow load time. they told me they don't need to have the home page accessing the database everytime the page is loaded since a lot of the info in the page is not changed that frequently. I am thinking of using the CACHEDWITHIN with some of the CFQUERY in the page, like CACHEDWITHIN 2 days. What i am worrying about is if the client update the data within those 2 days, the home page will not be able to display the lastest info. Is there a way to refresh all the cached query once the client update the database, so all the cached queries will also be updated instantly without waiting for the CACHEDWITHIN to expire. Anyone has any idea is very welcomed to suggest. thank -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com __ 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
Re: Database and Query issues.......YIKES!
I'm thinking that you don't even need the DayOfTheWeek table, especially if all it contains is an ID related to a Day of the Week (1, Monday|2, Tuesday, etc.) Depending on what you're trying to do, you may not even need the WeekOf table. How are you joining the tables? Send us the query. You might also look into the Week([date]) and DayOfWeek([date]) and DayOfWeekAsString([1-7]) functions in the documentation. Sharon I need to show a page that returns a table of IDs sorted by a WeekOf ID - showing the most recent. Within that result set there needs to be details corresponding to those IDs. [so far that works]. The problem is, how can I return the details sorted by DayOfWeek and show multiple sets of details for the same DayOfTheWeek ID. As of now I have; History Table [shows the ID of the records I want to return] 4 detail Tables [Each has a Descriptions and an ID to the name of the day of the week] JOINED to the DayOfTheWeek Table [1 = Monday] a WeekOf Table [numbering the weeks of the year] _ Do You Yahoo!? Get your free yahoo.com address at http://mail.yahoo.com __ 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
Re: show my stuff
Screen shots and examples of code are all we've ever required (sometimes not even screenshots). Being able to explain the purpose of the application and you're approach to fulfilling it is also a good thing. But code tells all. Sharon At 11:28 AM 10/5/2000 -0700, S R wrote: Hi everyone, I am currently looking for a job but i am running into a problem because I want to interview with people and cannot show them my work because all the stuff I have been doing is on an intranet. I am currently creating a CD rom and basically exporting and modifying my ColdFusion work to run on any desktop. My question is how do I export a database from SQL to another person's system? It's easy to do it with an ACCESS database because you just copy and paste it. Would I do some sort of backup and then just create a device on their system, then restore my Database? How would you go about interviewing if you were in my situation. Do ColdFusion companies accept just screen shots and an explanation of what each page does? I'm lost... Thanks Sal _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Relief from redundancy?
I used to do that, then I started setting some of these "common change items" as variables in the application.cfm. You want to change the background on all pages? One line of code. cfset REQUEST.background = "image.gif" The best part is, because you control how you're using the variable, you don't have to worry about "accidentally" replacing something that belongs. Sharon At 01:00 PM 9/27/2000 -0500, Gavin Myers wrote: I've used Extended Find/Replace quite a bit to run long tedious stuff, like when people say "can you make the background cornflower blue instead of white? because white is so blah, i know that our site spans over 160,000 cfm pages but i'm sure you can do it!" It works for things like that as long as you can find a similarity to replace... otherwise i suggest drinking heavily --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cfloop headache
Try trimming the Posted field, in case you have any spaces in there. cfif trim(posted) IS "GW" Sharon At 10:48 AM 9/28/2000 -0700, Adrian Cesana wrote: What am I doing wrong here...I am trying to evaluate a field and change the outoput based on this. I know I have a few records that meet the cfif get.posted IS "GW" test but they dont get SET to 0 as if the test failed. It appears I am not evaluating on the correct record. Do I need to set a field from the query to a list then loop thru the list perhaps? Seems like I should be able to do it like this somehow... Thanks,Adrian Ive slimmed the query and output down to make it simple: CFQUERY NAME="get" DATASOURCE="blah" SELECT billno,posted,qty FROM blah WHERE blah /CFQUERY cfloop query="get" cfif posted IS "GW" !--- tried get.posted - same result --- cfset NewQty = 0 cfelse cfset NewQty = qty /cfif cfset txtoutput = '"#BillNo#"~"#NewQty#"' cffile action=append file="blah" output="#txtoutput#" /cfloop -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: next row in cfloop
cfloop query="myQuery" this loop: #field# cfif currentRow IS NOT myQuery.recordcount next loop: #query.field[currentRow+1]# /cfif /cfloop HTH Sharon At 02:53 PM 9/5/2000 -0400, Tim Bahlke wrote: Hey all, I am looping through a query and need to get data from the next row. Make sense? While my loop in handling row 5, I need to grab some data from row 6 and do a TimeFormat. I just can't seem to get to that next row. I have tried a number of different ways to do this but have had no luck. It seems that this screams for an embedded loop but I just can't seem to get what I want. If this makes any sense I anyone out there, I would be grateful for any assistance. Thanks, Tim _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: can you store a structure in a client var?
You can't store structures (or arrays, or queries) in client variables unless you serialize them into a wddx packet string. Sharon At 12:44 PM 8/31/2000 -0400, Stas Newdel wrote: I remember that you can't store a structure in either a session or a client var, could anybody please refresh my memory? Thank you --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Structures No? Cached Queries Yes?
OK, gonna jump in on this one now. I don't use cached queries. I use scoped queries. Essentially the same thing, but I like managing my own caching rather than allowing the server to determine what gets cached (based on the rotating list of "last used"). Just a preference. But on the queries vs. structures discussion you're comparing apples and oranges. If you have data that you're going to loop over and output, use a query. That's what they're designed for. But if you're going to call individual pieces of data (particularly organizationally nested pieces of data) than use a structure, much quicker to point to exactly what you want than to loop to find it. Example, a structure that holds school information: schools.schoolname.class.teacher = "[teachername]" In my code (where I know the school and class): #schools[schoolname][class]["teacher"]# will output teacher name. I can pull this information out of a resident structure much quicker than running a query, or even looping through a query to find the information I want. This may not be the best example, but it may help to look at some of the queries you're running to get complex information and see where a nested structure (queried for and built once) saved into application scope (then copied to request scope with cflock for usage) might be a better alternative. I *love* structures and I'm open to any questions on using them efficiently. Sharon P.S., cfscript rules for working with structures, whether it's faster or not. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Structures, Arrays, Array of Structures
At 01:48 PM 9/1/2000 -0400, Peter Theobald wrote: Paul, why did you set the data in a temporary structure, then copy it to the application structure? Did you intend to put a lock around the application structure? I don't know about Paul, but I generally build structures in local scope and then copy them to application (or session) scope with a single cflock for the copy, instead of locking the entire process. Particularly if I'm initializing a bunch of structures, I'll build them all and copy them all under one cflock. Sharon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Javascript - Cold Fusion.
You can use wddx to do this. Essentially cf_wddx will build a javascript array that you can work with. Takes some tinkering, but is very cool. Sharon At 05:26 PM 9/1/2000 -0400, Bill Davidson wrote: This is a multi-part message in MIME format. --=_NextPart_000_018F_01C01439.B56720E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anyone know of an easy method to get Javascript variable = information to CF variables? Or more specifically how to get the = browser dimensions/screen resolution into a CF variable? Is WDDX the = answer? TIA, Bill /intraget --=_NextPart_000_018F_01C01439.B56720E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anyone know of an easy method to = get=20 Javascript variable information to CF variables? Or more = specifically how=20 to get the browser dimensions/screen resolution into a CF = variable? Is=20 WDDX the answer? TIA, Bill /intraget --=_NextPart_000_018F_01C01439.B56720E0-- -- Archives: http://http://www.mail-archive.com/www.mail-archive.com/cf-talk@houseoff usion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talkht tp://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Structures No? Cached Queries Yes?
It would depend a lot on how you're using the information now, that is, how people are accessing it. Structures (particularly nested structures) are great for drill down information. But if you're doing a lot of looping, then queries might be faster. What might work is the nested structure like: APPLICATION.newark["Access Control Systems"] = an ordered array of listings (You can use "non-standard" key names provided you build and access the structure using array notation. I.e., APPLICATION.newark.Access Control Systems would not work.) You *can* loop over structures, either as a collection, or by pulling the keys with a StructKeyList(). I've done some sites where I kept a good portion of the "common" information in large hierarchical structures that I used all over the site. Sometimes I looped over the structure, sometimes I pulled detailed information from several layers into the structure. I liked having one place for all the information. But if I didn't need the information in a structure, I'm just as happy saving a query or two to APPLICATION scope. If you have more detailed information about what you're trying to accomplish, I can give you some more ideas. Sharon At 06:47 PM 9/1/2000 -0700, paul smith wrote: Thanks for jumping in, Sharon. Good suggestions. In just a few minutes mulling over your ideas, I've come up with some possibilities. My app is a Yellow Pages. So one query I have been running is to list all Headings that start with "A" for example (Academies, Access Control Systems, Accessories-Fashion, and so forth...) So your approach would be to load all Headings that begin with A into a structure, all those that begin with B into another structure, and so forth. Right? This eliminates a call to the DB. Another would be to load all Listings in one city, say New York into a structure, all Listings in Newark into another structure, and so forth. Is this the idea? Do you have any specific suggestions for Yellow Pages? best, paul At 09:18 PM 9/1/00 -0400, you wrote: OK, gonna jump in on this one now. I don't use cached queries. I use scoped queries. Essentially the same thing, but I like managing my own caching rather than allowing the server to determine what gets cached (based on the rotating list of "last used"). Just a preference. But on the queries vs. structures discussion you're comparing apples and oranges. If you have data that you're going to loop over and output, use a query. That's what they're designed for. But if you're going to call individual pieces of data (particularly organizationally nested pieces of data) than use a structure, much quicker to point to exactly what you want than to loop to find it. Example, a structure that holds school information: schools.schoolname.class.teacher = "[teachername]" In my code (where I know the school and class): #schools[schoolname][class]["teacher"]# will output teacher name. I can pull this information out of a resident structure much quicker than running a query, or even looping through a query to find the information I want. This may not be the best example, but it may help to look at some of the queries you're running to get complex information and see where a nested structure (queried for and built once) saved into application scope (then copied to request scope with cflock for usage) might be a better alternative. I *love* structures and I'm open to any questions on using them efficiently. Sharon P.S., cfscript rules for working with structures, whether it's faster or not. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: questions about cachedwithin
You would have 10 cached queries, but because CF refers to queries by name, you can only use one of them (the last one executed.) So you'll need to change the name of the query for each loop: cfloop from="1" to="10" index="i" cfquery name="qryName_#i#" datasource="#dsn#" SELECT field1 FROM table WHERE field2 = '#i#' /cfquery /cfloop Sharon -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, August 25, 2000 12:58 PM Subject: questions about "cachedwithin" To paraphrase the CFWACK: 'The ColdFusion caching logic takes cfif, cfloop, and other dynamic structures in queries into account, ensuring that caching is safe to use within a dynamic environment.' OK .. Say I have cfloop from="1" to="10" index="Variables.index" cfquery name="qryName" datasource="#Variables.DSN#" cachedwithin="#CreateTimespan(1,0,0,0)#" SELECT field1 FROM table WHERE field2 = '#Variables.index#' /cfquery /cfloop I'm assuming in this scenario I will end up with 10 different cached queries ... or would all of the queries overwrite each other because they all have the same name? Also, does anyone know how much overhead is associated with removing the oldest cached query from memory and replacing it with the newest when the limit is reached? I'm guessing even if it has to be done a lot, it's still faster than than hitting the database for 15 rows of data, every single time. Todd Ashworth --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: questions about cachedwithin
I may have misunderstood the first question. You could call the cached queries by name because CF *does* cache by SQL (SQL must be *identical* right down to the number of spaces). However, if you ran this cfloop on a page and immediately after it, tried to output the query, it would use the last query run. Sharon -Original Message- From: JF [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, August 25, 2000 2:30 PM Subject: Re: questions about "cachedwithin" That's not the behavior I've seen - CF is smart enough to look at the select criteria of a query and will reuse it based on the criteria, not the name. I wrote a site that used the same query name to dynamically build forms from a data dictionary, and each page (with different select criteria but the same query name) showed as a Cached Query with debugging turned on. ...Jay At 10:53 AM 8/25/2000, you wrote: You would have 10 cached queries, but because CF refers to queries by name, you can only use one of them (the last one executed.) So you'll need to change the name of the query for each loop: cfloop from="1" to="10" index="i" cfquery name="qryName_#i#" datasource="#dsn#" SELECT field1 FROM table WHERE field2 = '#i#' /cfquery /cfloop Sharon -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, August 25, 2000 12:58 PM Subject: questions about "cachedwithin" To paraphrase the CFWACK: 'The ColdFusion caching logic takes cfif, cfloop, and other dynamic structures in queries into account, ensuring that caching is safe to use within a dynamic environment.' OK .. Say I have cfloop from="1" to="10" index="Variables.index" cfquery name="qryName" datasource="#Variables.DSN#" cachedwithin="#CreateTimespan(1,0,0,0)#" SELECT field1 FROM table WHERE field2 = '#Variables.index#' /cfquery /cfloop I'm assuming in this scenario I will end up with 10 different cached queries ... or would all of the queries overwrite each other because they all have the same name? Also, does anyone know how much overhead is associated with removing the oldest cached query from memory and replacing it with the newest when the limit is reached? I'm guessing even if it has to be done a lot, it's still faster than than hitting the database for 15 rows of data, every single time. Todd Ashworth --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Structures, Arrays, and WDDX oh my
Do not limit your usage of structures and arrays based on memory concerns. Spectra makes *heavy* use of both in the realm way beyond what the average CF user would even think of attempting. I have a couple of applications with structures nested 8 layers deep with thousands of records with no visible impact on memory. You should also know that you can save these complex data types (arrays, structures, queries) to scoped variables like SESSION and APPLICATION (with proper locking, of course.) I don't know anything about deleting all structures on a server, but if you run a "structClear()" on a scope (SESSION, SERVER, APPLICATION) it will wipe out all variables stored in that scope because the scopes are actually structures. structDelete() will delete one key from a structure. I also recommend to anyone playing with complex datatypes to either download cf_objectDump from the tag gallary, or if you have Spectra, using cfa_dump to visually "see" your structures, arrays, etc. Sharon -Original Message- From: Robert Everland [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Friday, August 25, 2000 2:59 PM Subject: Structures, Arrays, and WDDX oh my Alright I am going to start using structures and arrays and turn them to wddx so I don't have to rely on hidden form fields anymore. Now the question I have is, when I use a structure and/or array how much memory does it take? I know I can delete structures but I remember seeing that some people would have problems when doing a structure delete all(don't know exact sytax on hand) and it would delete all structures on the machine? Is this still a problem and if so how would I overcome it. Robert Everland III Web Developer Dixon Ticonderoga --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Locking (was RE: Structures, Arrays, and WDDX oh my)
There have been a couple of detailed discussions on this list about locking, but I'll give you a quick synopsis. CF introduced the concept of locking variables to prevent multiple read/writes of the same variable. Three scopes are affected: SESSION, APPLICATION and SERVER. Basically you need to use cflock around any reads or writes of these variables. CF doesn't explicitly require this (unless you turn on the option to throw errors on unlocked variables in the cfadmin) but it does a lot for application stability. !--- on write --- cflock scope="application" type="exclusive" timeout="10" cfset APPLICATION.myVar = "some Value" /cflock !--- then on read --- cflock scope="application" type="readonly" timeout="10" cfoutput#APPLICATION.myVar#/cfoutput /cflock I've found that copying variables to REQUEST scope (a scope available to any template - including custom tags - processed during a *single* request) at the beginning of any template that uses them (and copying them back, if they were changed by the template) to be the most efficient way of doing this. Sharon -Original Message- From: Milks, Jim [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Friday, August 25, 2000 3:30 PM Subject: Sharon - RE: Structures, Arrays, and WDDX oh my Hi Sharon, I was wondering if you could elaborate on your statement: You should also know that you can save these complex data types (arrays, structures, queries) to scoped variables like SESSION and APPLICATION (with proper locking, of course.) I too recently started using structures as session and application variables, but did not use any explicit locking. How is this done? JM -Original Message- From: Sharon DiOrio To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 25/08/00 3:14 PM Subject: Re: Structures, Arrays, and WDDX oh my Do not limit your usage of structures and arrays based on memory concerns. Spectra makes *heavy* use of both in the realm way beyond what the average CF user would even think of attempting. I have a couple of applications with structures nested 8 layers deep with thousands of records with no visible impact on memory. You should also know that you can save these complex data types (arrays, structures, queries) to scoped variables like SESSION and APPLICATION (with proper locking, of course.) I don't know anything about deleting all structures on a server, but if you run a "structClear()" on a scope (SESSION, SERVER, APPLICATION) it will wipe out all variables stored in that scope because the scopes are actually structures. structDelete() will delete one key from a structure. I also recommend to anyone playing with complex datatypes to either download cf_objectDump from the tag gallary, or if you have Spectra, using cfa_dump to visually "see" your structures, arrays, etc. Sharon -Original Message- From: Robert Everland [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Friday, August 25, 2000 2:59 PM Subject: Structures, Arrays, and WDDX oh my Alright I am going to start using structures and arrays and turn them to wddx so I don't have to rely on hidden form fields anymore. Now the question I have is, when I use a structure and/or array how much memory does it take? I know I can delete structures but I remember seeing that some people would have problems when doing a structure delete all(don't know exact sytax on hand) and it would delete all structures on the machine? Is this still a problem and if so how would I overcome it. Robert Everland III Web Developer Dixon Ticonderoga --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFSCRIPT question
cfscript
if (NOT StructKeyExists(SESSION.car, ATTRIBUTES.name)) {
do stuff here
}
else
{
do other stuff here
}
/cfscript
The "else" is actually optional. But I figured I'd throw it in as an
example.
Sharon
-Original Message-
From: Jon Tillman [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, August 25, 2000 3:28 AM
Subject: CFSCRIPT question
I have the following as cfscript:
if (not(structKeyExists(session.cart, attributes.name)))
I would like to use it as a CFIF statement. Any ideas how to go about
constructing said cfif?
--
***
Jon Tillman
LINUX USER: #141163
ICQ: 4015362
http://www.eruditum.org
[EMAIL PROTECTED]
***
Help Jon build a network!
Looking for giveaway computers parts
Current Need: Tape Drive PI/PII processors
Email me to find out how you can help
***
---
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFSCRIPT question
If we're still talking cfscript:
cfscript
if (StructKeyExists(SESSION.cart, ATTRIBUTES.name)) {
myValue = SESSION.cart[ATTRIBUTES.name];
}
else
{
myValue = "not Defined";
}
/cfscript
You can refer to structures either throught dot notation:
SESSION.cart.item
Or with array notation:
SESSION.cart[item] (if item is a variable containing the name OR
SESSION.cart["item"] (if item is a literal value.
Sharon
-Original Message-
From: Andrea Wasik(CancerSource) [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, August 25, 2000 10:05 AM
Subject: RE: CFSCRIPT question
How would you then check for a particular value of a key within the same
cfif? In other words I am doing something similar where I am checking for
the existence of a key but then how do I filter so I get only those whose
value is, say, a specific date?
Thanks
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 9:00 AM
To: [EMAIL PROTECTED]
Subject: Re: CFSCRIPT question
Oops. Left off a )
Should be
cfif not structKeyExists(session.cart, attributes.name)
blah
/cfif
- Original Message -
From: "David E. Crawford" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 12:56
Subject: Re: CFSCRIPT question
cfif not structKeyExists(session.cart, attributes.name
blah
/cfif
- Original Message -
From: "Jon Tillman" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 24, 2000 07:27
Subject: CFSCRIPT question
I have the following as cfscript:
if (not(structKeyExists(session.cart, attributes.name)))
I would like to use it as a CFIF statement. Any ideas how to go about
constructing said cfif?
--
***
Jon Tillman
LINUX USER: #141163
ICQ: 4015362
http://www.eruditum.org
[EMAIL PROTECTED]
***
Help Jon build a network!
Looking for giveaway computers parts
Current Need: Tape Drive PI/PII processors
Email me to find out how you can help
***
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
---
-
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
---
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Switch Statement in CFSCRIPT
Hi,
You were missing quotes around the case values and "breaks" in the case.
This should work:
switch (result) {
case "0":
{
a = "u";
f = "webbox";
o = url.webreq;
if(q.accref is 'A') {
page = "editacc";
}
else {
page = "editref";
}
file = "editboxd.cfm";
break;
}
case "2":
{
a = "i";
f = "webbox";
o = url.webreq;
page = "warn";
file = "editboxd.cfm5";
break;
}
}
HTH!
Sharon
-Original Message-
From: FWA [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, August 25, 2000 12:42 PM
Subject: Switch Statement in CFSCRIPT
This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C00DBB.414D3C00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am having a problem with switch statement in a cfscript block. It is =
always executing the last case, no matter what happens. I have tried =
several different things and none of them seem to work. I have checked =
that the switch expression is one of the cases and the statement seems =
to disregard the variable. Any ideas?
I have done this with and without #'s around result and with and without =
the { } in the cases. THANK YOU!!
switch (#result#) {
case 0:
{
a =3D "u";
f =3D "webbox";
o =3D url.webreq;
if(q.accref is 'A') {
page =3D "editacc";
}
else {
page =3D "editref";
}
file =3D "editboxd.cfm";
}
case 2:
{
a =3D "i";
f =3D "webbox";
o =3D url.webreq;
page =3D "warn";
file =3D "editboxd.cfm5";
}
}
--=_NextPart_000_0015_01C00DBB.414D3C00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1"
META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2I am having a problem with switch =
statement in a=20
cfscript block.nbsp; It is always executing the last case, no matter =
what=20
happens.nbsp; I have tried several different things and none of them =
seem to=20
work.nbsp; I have checked that the switch expression is one of the =
cases and=20
the statement seems to disregard the variable.nbsp; Any =
ideas?/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2I have done this with and without #'s =
around result=20
and with and without the { } in the cases.nbsp;nbsp; THANK =
YOU!!/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2switch (#result#)=20
{BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; case=20
0:BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20
{BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
a =3D=20
"u";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp=
; f =3D=20
"webbox";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=
nbsp;=20
o =3D=20
url.webreq;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs=
p;nbsp;=20
if(q.accref is 'A')=20
{BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n=
bsp;nbsp;nbsp;nbsp;=20
page =3D=20
"editacc";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp=
;nbsp;=20
}BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
else=20
{BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n=
bsp;nbsp;nbsp;nbsp;=20
page =3D=20
"editref";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp=
;nbsp;=20
}BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
file =3D=20
"editboxd.cfm";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20
}BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; case=20
2:BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20
{BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
a =3D=20
"i";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp=
; f =3D=20
"webbox";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=
nbsp;=20
o =3D=20
url.webreq;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs=
p;nbsp;=20
page =3D=20
"warn";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n=
bsp;=20
file =3D "editboxd.cfm5";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20
}/FONT/DIV
DIVFONT face=3DArial size=3D2}/FONT/DIV/BODY/HTML
--=_NextPart_000_0015_01C00DBB.414D3C00--
---
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
Re: nesting queries
You've almost got it. Try this: CFQUERY name="cities" datasource="#dsn#" select city from areas /CFQUERY CFOUTPUT QUERY="cities"#city#br CFQUERY name="neighborhoods" datasource="#dsn#" select neighborhood from areas where city = '#city#' /CFQUERY CFLOOP query="neighborhoods"#neighborhoods.neighborhood#br/CFLOOP /CFOUTPUT HTH, Sharon At 09:09 PM 8/13/2000 -0400, Mark Davies wrote: also a novice, and am stuck. Am trying to nest a query theoretically like the following... CFQUERY name='cities' select city from areas /CFQUERY CFOUTPUT#city#br CFQUERY select neighborhood from areas where city = '#city#' /CFQUERY CFOUTPUT#neighborhood#br/CFOUTPUT /CFOUTPUT I know this has got to be quite simple to do, but I'm just lost in all the unfamiliar phrases and documentation. Can anyone tell me the trick? Cheers, Mark --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: nesting queries
Half asleep. Norman's got the right answer on this one. Sharon At 09:52 PM 8/13/2000 -0400, Norman Elton wrote: From the looks of it, you're trying to get an output like: --- City 1 Neighborhood A Neighborhood B Neighborhood C City 2 Neighborhood D Neighborhood E Neighborhood F --- If so, try this: --- CFQUERY Name="MyQuery" select city, neighborhood from areas order by city, neighborhood /CFQUERY CFOUTPUT Query="MyQuery" Group="City" #City#BR CFOUTPUT #Neighborhood#BR /CFOUTPUT BR /CFOUTPUT --- The query returns all the neighborhoods and their corresponding cities, sorted for a nice pretty output (this is actually important if your cities appear out of alphabetical order in the database). The first CFOUTPUT tells ColdFusion that you will be outputting the query, and you want to group the output by city. The code outside the second CFOUTPUT is only executed once per city. The code inside the second CFOUTPUT is then executed once per record (i.e. in this case, once per neighborhood). Once a new city is reached, this inner loop stops and the process starts over again with the first CFOUTPUT. Hope this helps. If this wasn't what you were trying to do, well now you know! Norman Elton Information Technology College of William Mary -Original Message- From: Mark Ireland [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 13, 2000 9:13 PM To: [EMAIL PROTECTED] Subject: Re: nesting queries Its is as easy as where city = '#cities.city#' At 09:09 PM 13/08/00 -0400, you wrote: also a novice, and am stuck. Am trying to nest a query theoretically like the following... CFQUERY name='cities' select city from areas /CFQUERY CFOUTPUT#city#br CFQUERY select neighborhood from areas where city = '#city#' /CFQUERY CFOUTPUT#neighborhood#br/CFOUTPUT /CFOUTPUT I know this has got to be quite simple to do, but I'm just lost in all the unfamiliar phrases and documentation. Can anyone tell me the trick? Cheers, Mark -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Coldfusion Training..
How would you like a personal CF trainer, for say, oh, I don't know, a week or two? Sharon At 03:51 PM 8/7/2000 -0400, Angél Stewart wrote: I'm in Trinidad..in the Caribbean. Wherever the training is I will have to take a flight. heh heh. I went to Alliare.com and saw their training schedule with locations. Have any of you attended these courses? I am interested in the Advanced CF Development. However, would it be illegal or against licensing for us to purchase say 5 of the CF Development CD,and use that as our Training Materials per say, to walk these 5 people through a sort of CF introductory course? -Gel - Original Message - From: Randy Adkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Depending on your location, I have attended Figleaf's training and found it to be very good and thorough. www.figleaf.com --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: output query as array
cfquery name="getStuff" datasource="#REQUEST.dsn#"
SELECT *
FROM Table
/cfquery
cfoutput
table border=1 cellpadding=0 cellspacing=0
tr
cfloop list="#getStuff.ColumnNames#" index="i"
tdb#i#/b/td
/cfloop
/tr
cfloop query="getStuff"
tr
cfloop list="#getStuff.ColumnNames#" index="i"
td#evaluate("i")#/td
/cfloop
/tr
/cfloop
/table
/cfoutput
(Or you could download the tag "cf_objectDump" from the Developers Exchange.)
Sharon
At 03:51 PM 8/3/2000 -0400, Eli Shechter wrote:
Hi
i was told that a query result set is like a array.
how do i output it with the rows and columns
this will be placed in a table but the rows and columns are both dynamically
created so i cant make static headers on the table.
if i cant just output the whole thing then i would like to make a array and
then output that as a whole.
Any Ideas???
-Eli-
---
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: (syntax) variable naming conventions
Not a bad habit to get into. Spectra uses extensive variable prefixing. Their list is: st = structure a = array q = query w = wddx wst = wddx of a structure (etc.) Sharon At 12:46 PM 8/4/2000 -0400, Michael Dinowitz wrote: I've started to use some variable prefixes in some of my code and was wondering what others were using. I'd like to see a few examples before I post an article on it. My usage at the moment is limited to complex data types: aArray sStructure qQuery oObject I'm sure a case can be made for something like xWDDX, bBoolean, iInteger, nNumber, dDate, tTextString, lList but I'd rather not go that far yet. Who's using something like this? Is it helping you in any way? Is it hindering you in any way? --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Selecting records at random in Oracle
How about this:
!--- in the application.cfm ---
cflock scope="application" timeout="20" type="exclusive"
cfquery name="APPLICATION.get_all_ids" datasource="#REQUEST.dsn#"
SELECT column1, column2, column3
FROM Table
/cfquery
/cflock
!--- on the display page ---
cfoutput
cflock scope="application" timeout="10" type="readonly"
#APPLICATION.get_all_ids[RandRange(1,
APPLICATION.get_all_ids.recordcount)]#
/cflock
/cfoutput
Why requery when you've already gotten all the records?
Sharon
At 01:05 PM 8/4/2000 -0700, Dan Haley wrote:
You can probably do this in many ways, but the trick will be to keep the
amount of calls to the database to a minimum. With that in mind, here's a
first try . . .
!--- all rows in oracle tables have a 'rowid' field ---
cfquery name="get_all_ids" . . .
select rowid
from sometable
/cfquery
!--- now choose the random numbers between 1 and get_all_ids.recordcount
---
umm, you can look this up . . .
!--- now use the random numbers to get your three records ---
cfquery name="get_rand_records" . . .
select field1, field2
from sometable
where rowid in ('#get_all_ids.rowid[randomnumber1]#',
'#get_all_ids.rowid[randomnumber2]#',
'#get_all_ids.rowid[randomnumber3]#')
/cfquery
Dan
-Original Message-
From: Brandon Behrens [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 10:10 AM
To: [EMAIL PROTECTED]
Subject: OT: Selecting records at random in Oracle
Hello all,
I don't know if this is possible but I was wondering if there was a way to
tell oracle (using cold fusion) that I wanted 3 records, but I didn't care
which ones they were. I guess a good analogy would be you load up a page
and you want to display a banner ad, but you don't care which banner ad you
display. Any help would be appreciated.
Thanks in advance,
Brandon Behrens
Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
---
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Functions in Cold Fusion
Cold Fusion doesn't have functions as you'd know them in Java. It has the built-in functions, of course. Cold Fusion achieves "function functionality" through custom tags. Sharon At 10:39 AM 8/1/2000 -0700, you wrote: This is a multi-part message in MIME format. --=_NextPart_000_0016_01BFFBA4.BF744660 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by bastion.theidf.com id e71FbrJ27627 Hello everyone, This may seem like a rookie question, but I cannot figure out a way to ma= ke my own function in Cold Fusion. Am I missing something? I have been working with it for a month and haven=92t seen anything about it. Can I = make calls to a Java class or something like that? Thanks in advance, Brandon Behrens Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com/http://www.theidf.com --=_NextPart_000_0016_01BFFBA4.BF744660 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40" Hello everyone, This may seem like a rookie question, but I cannot figure out a way to make = my own function in Cold Fusion. = Am I missing something? I have = been working with it for a month and haven t seen anything about = it. Can I make calls to a Java = class or something like that? Thanks in advance, Brandon Behrens Brandon Behrens The = Internet Design Firm 512.451.= 5225 brandon@= theidf.com http://w/http://w= ww.theidf.com = /p --=_NextPart_000_0016_01BFFBA4.BF744660-- -- Archives: http://www.mail-archive.com/http://www.mail-archive.com/cf-talk@houseoff usion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talkh ttp://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Custom Tag for Date and Time
If you're putting it in a database, why not just #now()# which creates an ODBC datetime value. Sharon At 11:44 AM 7/28/2000 -0400, Olive, Christopher M Mr NMR wrote: why not just insert '#DateFormat(Now())# #TimeFormat(Now())#' ? Chris Olive, DOEHRS Website Administrator -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, July 28, 2000 11:22 AM To: [EMAIL PROTECTED] Subject: Custom Tag for Date and Time Any one have a custom tag that retrieves both the DateFormat (Now()) and TimeFormat (Now()) as one function that can be inserted into a database? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Allaire Certification Program
I second that. Always ask to see some code. Even if they have to sanitize it to keep to current NDA agreements. We've had candidates who seemed to be perfection on paper and even held their own during the interview, but their code told the truth. Sharon At 08:39 AM 7/10/2000 -0700, Mike Sheldon wrote: Hardly. I can spot fakers in a flat second, and I ALWAYS ask for samples of code (and make them explain why they did it that way). I just don't like working with sheep. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 06:44 To: [EMAIL PROTECTED] Subject: Re: Allaire Certification Program From: "Mike Sheldon" [EMAIL PROTECTED] I would look for someone who *refused* to take it. you would likely end up like an acquaintence, who hired someone who claimed to 'know' coldfusion. So far, this person has had to be taught sql, html, coldfusion, program design, database design, debugging, ... and problems continue. Apparently the new employee's idea of 'knowing' coldfusion was that he read the word on the internet once... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Unless explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: line break as delimiter
I have some code to separate out long selects into multiple selects with the same ID, but I don't see where you're getting the ID from a list. Also, your code would seem to output everything in the list with the value of "1". If you could give me an example of the list, I could probably help. Sharon At 11:30 AM 7/6/2000 -0400, Eli Shechter wrote: Hi im trying to run a list loop from a file that uses separate lines for the items. i would like to use a line break as a delimiter anyone have any ideas?? * select name="screen_names" cfloop index="i" list="#IM_list#" delimiters=" " option value="1" SELECTED#i#/option /cfloop /select * Thanks -Eli- --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Lasso vs Cold Fusion white paper - Your thoughts??
(reposted from my response to the CF-COMMUNITY list.) While my experience with Lasso is somewhat dated, I feel qualified to comment. This paper may have been a decent comparison of the "low-end" database enabled website, but it did not do justice to Cold Fusions exceptional processing, including scoped variables, complex data structures and extensive use of caching. If all you're doing is putting stuff in a database and displaying it, Lasso is pretty nifty. But if you're building an online application, you quickly run into Lasso's inherent limitations. Sharon At 11:20 AM 6/29/2000 +0100, Stephen Moretti wrote: This was posted on the dreamweaver mailing list (incidently run by blueworld) http://www.blueworld.com/blueworld/news/06.28.00LassovsColdFusion.html Its a camparison between Lasso and CF. Anyone care to comment who's used both?? Regards Stephen --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Archive
It's Dave Watt's world. We just live in it. Sharon At 09:17 AM 6/29/2000 -0600, Lee Surma wrote: This list now has a great archive source. Check out http://www.pdm-inc.com/mky_t5_about.cfm to see how you rank. Their search capabilities are far better than eGroups. -- Lee Surma Public Radio International [EMAIL PROTECTED] --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is it possible to have a preview of records before going live??
The simplest answer is to submit the form to a "preview" page, and pass the information along to a "confirm" page as hidden fields. Something like this: !--- input page --- form action="preview.cfm" method="post" textarea name="news" cols="50" rows="10" wrap="virtual"/textarea input type="submit" value="Preview article" /form !--- preview page --- cfoutput form action="addarticle.cfm" method="post" Here is how it will look. Hit "back" to make any changes. formatting stuff #FORM.news# /formatting stuff input type="hidden" name="news" value="#FORM.news#" input type="submit" value="Submit article" /form /cfoutput !--- final page --- cfquery name="insertArticle" datasource="#APPLICATION.dsn#" SQL stuff /cfquery Thanks for your submission! HTH! Sharon At 11:01 AM 6/29/2000 -0400, Jeff Fongemie wrote: Hey everyone, I have a site where the users can add text to a form that will then go to database, and from that a "news page" will get it's information. Easy. But, my client wants a way to add the text, hit enter, then preview it with the ability to make changes before it goes live. After the preview/change process he can hit another submit button to have the info go live. I'm looking for ideas as to where to start. Is this possible? Do I need 2 tables, a beta table that is used before it goes live to the final table? I'd need to figure out how to get the record from the beta table to the live table. Any better/other ideas? All help or suggestions are appreciated on this one... Jeff F. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMAIL Urgent Help Needed...Please!
We ran into this a few months ago when we upgraded to 4.5.1. Apparently they changed the handling of attachments in 4.5.1. You used to do something like this: cfmail from="[EMAIL PROTECTED]" to="[EMAIL PROTECTED]" subject="Dave Watts is King" attachment="c:\mydocs\mypicture.jpg" More interesting stuff /cfmail Now, the good news is you can make multiple attachments. The bad news is you need to change the old code. cfmail from="[EMAIL PROTECTED]" to="[EMAIL PROTECTED]" subject="Dave Watts is King" cfmailparam file="c:\mydocs\mypicture.jpg" cfmailparam file="c:\mydocs\myotherpicture.jpg" More interesting stuff /cfmail Some other things to check: 1. Has the access privileges changed on the directories? 2. Is there enough disk space? HTH! Sharon At 11:06 AM 6/29/2000 -0400, Paul Ihrig wrote: just found this in my local mail log "Warning","TID=-1754369","06/29/00","09:30:34","Unable to move the spooled mail file, C:\CFUSION\MAIL\spool\E0C3.cfmail. Access is denied.." what now? --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Arrays and CFIF
The best way to diagnose an error like this is to display the array. Check out a custom tag called cf_objectdump. It will show you an array, query, or structure. Makes working with complex data structures *much* easier. Or, if you have Spectra, may I also recommend a custom tag that is part of Spectra called cf_dump, which I generally prefer. Sharon At 09:04 PM 6/28/2000 -0400, Chris Farrugia wrote: I have an array that catalogues a bunch of products and categories... for instance, ProductIDArray[1][1] is "Case" and ProductIDArray[1][2] could be "Mid Tower." With that in mind, this is for a system configurator... now, there are checkboxes for SOftware... if they check one, then it goes into the productIDArray... if they check two, then ProductIDArray[21][1] becomes Additional Software and ProductIDArray[21][2] becomes two product ID's like 131,132. So... all I want to do is say "If ProductIDArray[21][2] has a value, then do the following..." How can I do that? The code I'm trying is: CFIF len(#ProductIDArray[21][2]#) IS NOT 0 This comes back with the following error... Error Diagnostic Information The element at position 21 in dimension 1 of object "ProductIDArray" cannot be found. The object has elements in positions 1 through 20. Please, modify the index expression. The error occurred while evaluating the expression: len(#ProductIDArray[21][2]#) IS NOT 0 --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Selecting a value in a dropdown.
What I like doing with commonly used selects is making them custom tags. The code would look something like this: cfparam name="ATTRIBUTES.selected" default="" cfoutput select name="parked" option value="" cfloop index=i from="1" to="52" option value="#i# week/year" cfif ATTRIBUTES.selected IS "#i# week/year" selected/cfif#i# week/year/option /cfloop /select You call the tag like this: cf__selectTag selected="#query.parked#" You don't have to do this as a custom tag, but for commonly used selects, it does neaten up the code considerably. HTH! Sharon At 08:24 AM 6/27/2000 -0600, Erika Foster wrote: I am populating a select input field with a cfloop select name="parked" /select That's all working. This form is also an edit form if a record already exists for this facility. How do I pre-select the value that is in the database for that record from within the loop? Thanks, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: isDefined() on session/application variables
I use an "isDefined()" before reading/writing session/application variables and then if the variable isn't defined, I set it. Mostly this is for error trapping in the unlikely event that the variable isn't defined and you call it (producing an error). If you're 100% sure the variable is there, than you don't need to check for it. But I'm not 100% of anything...grin Sharon At 08:58 AM 6/27/2000 -0700, Troy Johnson wrote: Does anybody have any thoughts on weather you should always do an isDefined() before reading or writing a session/application variable? Why? thanks, tj --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cfscript
cfscript doesn't have functions, so you can't call one even from a page.
But javascript can't interact with CF because CF is executed on the server
and javascript is executed on the browser.
What you can do is use CF to dynamically write the javascript functions you
need.
HTH!
Sharon
At 12:43 PM 6/22/2000 -0400, Tim Bahlke wrote:
Can I call a cfscript function through a link like a javascript function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083
---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Tracking users through a site
You can do this, in fact Spectra does some of this. Spectra uses text logs
because of the overhead involved with using databases to hold all of the
information.
You can log anything a user does, provided you're prepared to capture that.
I use this particular technique during debugging and for the initial
launch of a site. Helps a *lot* to see what kind of data people are
submitting and being able to replicate errors. But you could also use it
to track what people are searching for most often (to reorganize the site)
etc.
My current code looks something like this:
!--- in the application.cfm ---
cfset formList = ""
cfif IsDefined("FORM.fieldnames")
cfloop list="#FORM.fieldnames#" index="i"
cfset formList = formList "/#i#: #evaluate("FORM.#i#")#"
/cfloop
/cfif
cfset logText = "#DateFormat(Now(), "m/d/")# #timeformat(now(), "h:mm
tt")# - #SESSION.UserName# - #CGI.script_name# - #formList#"
cffile action="APPEND" addnewline="Yes"
file="C:\inetpub\myWebSite\logs\log.txt" output="#LogText#"
Because this text file would get *very* big *very* fast, I also have a
script that runs nightly to save to daily log files and start a new one. I
hope this give you some ideas!
Sharon DiOrio
Mindseye Technology
www.mindseye.com
At 03:24 PM 6/22/2000 -0400, Gina Shillitani wrote:
We're looking at about 86,000 hits per day on the reporting server, which is
where I need to collect this information. I'm trying to figure out if there
is a way I can track a single user through each visit to the site and record
the entire session to one record in the table. Example, the user with token
XYZ requested a.cfm, b.cfm?var=keyword, c.cfm?var=keywordvar2=5, on
6/25/2000 at 8:56 AM and spent 15 minutes total on the site. This would be
preferable to recording single page hits and I do need to record any
variables that are passed to individual pages.
-Original Message-
From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 2:03 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Tracking users through a site
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
yes, to a degree the logging tools would be useful, but this
particular set
of information would be used as an audit trail... so it would
have to be
permanently stored in a database, and searchable as well.
You *could* periodically analyze the logfiles stuff the results
into a DB. That's probably a better solution if you're expecting a
huge number of visitors. For an 'average' load (whatever THAT
means...), you should be able to get away with a database approach in
the application.cfm.
Just for reference, our site runs about 1.5 millions hits per month,
runs on CF 4.0.1 on a dual P2 450MHz, 512MB, mirrored drives MSSQL
7. It's VERY database heavy (even our page headers footers are
data-driven). We don't have any problem with overloading the server.
I don't want to scare you off from the databased method, but just
consider that if you're looking at a 'microsoft.com' level of
traffic, it might not be the safest solution...
Best regards,
Zac Bedell
-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com
Comment: Please use PGP!!!
iQA/AwUBOVJU4wraVoMWBwRBEQJfkQCgwIbnCT7JUi4GP9HjhJvolYJkEsoAnR+p
sMT7UJqoSGLTx+x2IUTGtIci
=UCaL
-END PGP SIGNATURE-
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: modifying variable names in a loop
Basically, you're to pass the action page either a number (to indicate the
number of loops) or a list to loop over (sometimes I use a list of IDs on a
multiple update page.)
On the action page:
cfloop from="1" to="#FORM.loopto#" index="i"
cfif Len(evaluate("FORM.name" i))
!--- execute query ---
/cfif
/cfloop
HTH!
Sharon
At 12:28 PM 6/19/2000 -0700, Chris Giminez wrote:
I have a form that may have just one or up to 20 or so sets of data. The
form fields will be passed, but could be blank for all but one set up data.
It's being passed as something like
form.name1
form.address1
form.city1
form.state1
form.name2
form.address2
form.city2
form.state2
... so on.
On the action page, I want to loop over an insert query and only execute the
query if the set of data is not ""
so I need to do a cfif name1 is not "" run the querycfelsedon't run
the query/cfif
How do I run the count in the cfif statement since name#loopcount# won't
work within a cfif statement?
Then if I do the insert, how can I get the value of the variable for the
query. It has to be dynamically generated from the loop
Obviously this is not going to work, but I think it illustrates what I am
trying to do.
CFQUERY NAME="name" DATASOURCE="name"
INSERT INTO tablename
(
name,
city,
...
)
VALUES
(
#name#loopcount##,
#city#loopcount##,
)
/CFQUERY
Thanks!
--
Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000
---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Training?
My recommendation to anyone wanting to get more into CF is to find a company that specializes in it. It's the only way you'll get to see what CF is really capable of. Most corporations don't use 1/10th of the CF power available to them. I believe that in order to get really good with the software, you'll need to be challenged by people wanting more than you can deliver, and surrounded by people who can show you how it's done. I won't say that you can't get good learning by yourself, but it takes a lot more effort on your part. Check out the Allaire Partners on the allaire website. I'm sure there is one near you. When you interview, tell them exactly what you're looking for: an opportunity to become a CF guru. Most of them will be thrilled to talk to you. And these days, having URLs means a lot more than a degree. If actually changing jobs isn't an option now, then join your nearest CFUG. Network your hiney off and find a couple of "coding partners" who would be willing to share ideas, code, and provide a CF sounding board. Sharon At 08:47 PM 6/4/2000 -0400, Marco Gil wrote: Christine, I find myself in a very similar boat. I am currently in the midst of a career change... I have done about 3 websites from scratch using Cold Fusion, some more advanced than others but still not utilizing everything that CF has to offer. If you come across any replies that you found very informative with regards to further pursuing a career in CF development, by all means forward it to me. Thanks again and I hope you find what you're looking for because I to am looking for the same :) Regards, Marco [EMAIL PROTECTED] - Original Message - From: "Christine Kelley" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 31, 2000 10:10 PM Subject: CF Training? This is a multi-part message in MIME format. --=_NextPart_000_0009_01BFCB33.E53B42A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all! I have read CFWACK4.0 cover to cover (along with doing all the = exercises) and am starting on the Advanced book. I'm wondering if I = should attend the training courses by Allaire, FT to CF and Advanced CF = development. I have starting writing applications on the side for = people, but I would like to make this my full-time career (I love this = stuff!). OK CF gurus, how do I get my foot in the door for a career in = CF? My background (I'll keep this short) is a BA in Biology with a = minor in math and some misc additional courses that mean just as little. = The important stuff I've been working on though is self-study in CF, = SQL, Visual Basic, NetObjects Fusion and Access. Please advise!! Thanks, Christine --=_NextPart_000_0009_01BFCB33.E53B42A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3017.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi all!/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; I have read = CFWACK4.0 cover to=20 cover (along with doing all the exercises) and am starting on the = Advanced=20 book.nbsp; I'm wondering if I should attend the training courses by = Allaire, FT=20 to CF and Advanced CF development.nbsp; I have starting writing = applications on=20 the side for people, but I would like to make this my full-time career = (I love=20 this stuff!).nbsp; OK CF gurus, how do I getnbsp;my foot in the door = for a=20 career in CF?nbsp; /FONTFONT face=3DArial size=3D2My background = (I'll keep this=20 short) is a BA in Biology with a minor in math and some = miscnbsp;additional=20 courses that mean just as little.nbsp; Thenbsp;important stuff I've = been=20 working on though is self-study in CF, SQL, Visual Basic, NetObjects = Fusion and=20 Access.nbsp;nbsp; Please advise!!/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; = nbsp;nbsp;nbsp;=20 nbsp;nbsp;nbsp; nbsp;nbsp;nbsp; Thanks,nbsp;=20 Christine/FONT/DIV/BODY/HTML --=_NextPart_000_0009_01BFCB33.E53B42A0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How can I count the number of words in a form submission?
Not so new. #ListLen(FORM.textField, " ")# List functions can be used for more than just lists. HTH! Sharon At 01:06 PM 5/24/2000 -0700, [EMAIL PROTECTED] wrote: Here's a new one for everyone... Let's say for example I was collecting a paragraph of text via a web form and I wanted to check the total number of words entered. How can that be done with ColdFusion? ---mark --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: code to sort a structure?
I believe there may be a "structSort" custom tag floating around on the Developers Exchange. But what you can also do is output the structures as lists and sort the lists. stApp.stPayment cfloop list="#ListSort(StructKeyList(stApp.stPayment), "text")#" index="i" cfloop list="#ListSort(StructKeyList(stApp.stPayment[i]), "text")#" index="ii" #stApp.stPayment[i][ii]#br /cfloop /cfloop I hope you get the idea. If not, let me know. HTH! Sharon At 06:50 PM 5/24/2000 -0400, Lomvardias, Christopher wrote: Hi, Wondering if anyone has developed any code that will sort a nested structure based on values of the keys. I am dynamically generating some nested structures and want to be able to output some of the nested keys in a table. There are four nested structures called stApp.stPayment.V, stApp.stPayment.MC, stApp.stPayment.D, stApp.stPayment.AE that each have four keys named "lengths, validation, startdigits and mask". I want the output to present the values of the four keys in order by stApp.stPayment (meaning I want my table rows in the following order: AE, D, MC, V). Thanks, Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -- --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Can I put a wddx packet into a database and read it back out?
It is very possible.
!--- insert into database ---
cfwddx action="CFML2WDDX" input="myArray" output="myWDDX"
cfquery name="qInsWDDX" datasource="#APPLICATION.dsn#"
INSERT INTO Table (Wddx)
VALUES ('#myWDDX#')
/cfquery
!--- retrieve from database ---
cfquery name="qSelWDDX" datasource="#APPLICATION.dsn#"
SELECT WDDX
FROM Table
WHERE WddxID = #WDDXID#
/cfquery
cfwddx action="WDDX2CFML" input="#qSelWDDX.WDDX#" output="myArray"
It doesn't matter what database you're using because WDDX is just a text
string.
HTH
Sharon
At 11:11 AM 5/17/2000 -0400, zknoll wrote:
I have an 2-D array of information that I convert into a wddx packet to
pass between templates but I would also like to be
able to store the packet into a database and read it out again. A) Is
this possible? B) Is it possible with access 200 as the
backend database? C) If A and B are true can you show me a snippet of
code as to how this would be done?
---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: You have nice cookies .. mind if I have a look?
Because the web is "stateless", each http request is independent of the previous ones. So the web server (any web server, not just CF) needs a way to establish that multiple http requests belong to the same user. Therefore, session state needs to be maintained either by setting cookies or by passing a unique ID in URL variables. In Cold Fusion SESSION management, the temporary cookie only contains CFID and CFToken, values that mean nothing except to the Cold Fusion server that set them, having them stolen is less of a security risk than setting discrete cookies with user specific information. Sharon At 12:44 PM 5/16/2000 -0700, paul smith wrote: Nope. You only need session vars to maintain a session state. You need to set cookies on your visitor's 'puter if you want them to be able to login automagically. best, paul At 03:04 PM 5/16/00 -0400, you wrote: I thought cookies had to be enabled for session scoping to work? --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Session vars in a clustered environment
Also known as "sticky sessions." !--- Insert dirty joke here --- Sharon At 01:41 PM 5/16/2000 -0700, Scott Weikert wrote: We discussed this thing with an Allaire guy just last week. He said that currently, you can't pass session variables around between clustered servers. He did say that things can be set up so that users stick to the server they come into - so you CAN set session variables, and said user will just stay on that server for the duration of his session. The initial choice of what server the user hits would naturally be determined by load balancing... -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: School Days - (was: Lighten things up a little)
Bachelor of Fine Arts here. "Well, the application is busted, but it sho does look purty." Sharon At 01:24 PM 5/15/2000 -0400, Olive, Christopher M Mr USACHPPM wrote: oddly enough, my degree is a split major in writing and computer science. ;) Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -Original Message- From: Stewart McGowan [mailto:[EMAIL PROTECTED]] Sent: Monday, May 15, 2000 1:18 PM To: '[EMAIL PROTECTED]' Subject: RE: OT: School Days - (was: Lighten things up a little) I don't know about in the states but out of ten developers, nine have degrees in technical subjects and well the boss has an english degree :) Stew -Original Message- From:Todd Ashworth [SMTP:[EMAIL PROTECTED]] Sent:15 May 2000 18:30 To: [EMAIL PROTECTED] Subject: Re: OT: School Days - (was: Lighten things up a little) OK .. I'll give you that, but then again, how hard would it really be to pick up on those concepts on your own? I don't doubt the value of that degree in certain situations; It *can* give you an edge. In many cases, especially when dealing with jobs involving new technology, just having the degree is more important than what it's in .. if the degree is even important at all. A college education does tend to make one a more well rounded individual and I suppose that's desirable to some people. Unfortunately, the way I see it is that the college degree won't play a big role for me until I get more experience under my belt and move on up into much more competitive markets. In today's computer age, you can go a good long ways without one, but they really help if you want to get to the top :) So .. I say if you have the chance to go, take it. It can't hurt and will help, even if indirectly. Besides, I just want to say I is edumacated .. That's why I'm going back for a masters in biology. :) Heh .. wonder how I can work that into ColdFusion development? hmmm .. cf_mitosis? Or maybe start a new company, hire Linus Torlvolds and call it Transmetaphase? OK .. I'm just being silly now. Seriously, has anyone had any experience with ColdFusion jobs where the employers were concerned with the level of post secondary education? I'm really curious now. .Todd - Original Message - From: "Olive, Christopher M Mr USACHPPM" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 15, 2000 12:08 PM Subject: RE: Slightly OT: Lighten things up a little | i'm afraid i'd have to disagree with that. i may not "use" anything i | learned in college in respect that they never taught me ASP, CF, IIS, etc. | however, the concept of a stack, queue, linked list, structure, array, etc., | is universal to languages (ok, well, most languages). it is in | *understanding* the concepts of these things that college shows its value. | because of this (fairly) solid foundation in programming *theory*, i am | better able to leverage my skill sets in languages i know. more | importantly, they help me in learning something new. when you boil it down, | all languages are the same (ok, there are sub-types of programming languages | (procedural, functional, OO)), all you need to know is where to put the semi | colons. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFMail with attachments stops working?
We had a little issue with one of our servers this morning. Apparently we were running an Eval copy of CF and we needed to reinstall. We upgraded from 4.5 to 4.5.1 as well. After the reinstall, cfmail wouldn't send attachments anymore. All other servers (using the same email server) are functioning normally. Here is the error: Error Diagnostic Information Unable to write mail message to disk. An unexpected error occurred while attempting to save the mail message. The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (80:1) to (84:62) in the template file. What I've done: 1. Checked the server for disk space. 2. Checked permissions on the spool directory. 3. Verified the email server. Any thoughts? Sharon -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
