Re: FileMaker Pro Backend DB?

2002-10-10 Thread Sharon DiOrio
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

Re: WHYYYYY!!!!!!

2002-09-23 Thread Sharon DiOrio
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,

cfgraph bug

2002-06-21 Thread Sharon Diorio
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

Re: cfgraph bug

2002-06-21 Thread Sharon Diorio
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

Re: Coldfusion Apps You've Built

2002-06-14 Thread Sharon Diorio
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

Re: ahhh query

2002-05-24 Thread Sharon Diorio
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,

Re: Most efficient way to check if two lists

2002-05-21 Thread Sharon Diorio
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

Re: Anybody have a nice CFERROR page for me?

2002-05-17 Thread Sharon Diorio
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

Re: [admin] List status - A CHALLENGE

2002-05-16 Thread Sharon Diorio
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,

Re: A Tip (maybe new, maybe not)

2002-05-16 Thread Sharon Diorio
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

Re: How to detect timeout session??

2002-05-16 Thread Sharon Diorio
(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

Re: [admin] List status - A CHALLENGE

2002-05-15 Thread Sharon Diorio
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

Re: Recordset to structure?

2002-04-12 Thread Sharon Diorio
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

Re: Preventing SQL injection attacks...?

2002-04-12 Thread Sharon Diorio
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

Re: Dynamic structure key names

2002-04-11 Thread Sharon Diorio
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) {

Re: how to tell if a session has expired

2002-04-11 Thread Sharon Diorio
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

Re: Custom Tag Question

2002-04-11 Thread Sharon Diorio
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

Re: Customtags custom directory

2002-04-10 Thread Sharon DiOrio
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

Customtags custom directory

2002-04-09 Thread Sharon Diorio
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

cfgraph height

2002-03-27 Thread Sharon Diorio
. 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

Re: date massaging

2002-03-27 Thread Sharon Diorio
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

Re: Looping over a query with CFSCRIPT

2002-03-26 Thread Sharon DiOrio
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:

Re: cfparam vs. cfif/isDefined/cfset

2002-03-26 Thread Sharon DiOrio
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

Re: SSL Certificates - provider recommendations?

2002-03-26 Thread Sharon DiOrio
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

Re: Join up datasources

2002-03-26 Thread Sharon DiOrio
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

Re: Returning only one record HELP PLEASE!!!!

2002-03-26 Thread Sharon DiOrio
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

Re: Returning only one record HELP PLEASE!!!!

2002-03-26 Thread Sharon DiOrio
: 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

Re: Passing Arrays to Custom Tags

2002-03-25 Thread Sharon Diorio
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

Re: Is there anywhay to work around there not being an IsNull Function

2002-03-22 Thread Sharon Diorio
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

Re: moving from application to application

2002-03-22 Thread Sharon Diorio
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

Re: Running code just one time

2002-03-20 Thread Sharon Diorio
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?

Re: Running code just one time

2002-03-20 Thread Sharon Diorio
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

Re: Running code just one time

2002-03-20 Thread Sharon Diorio
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

HTML email images?

2002-03-20 Thread Sharon Diorio
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

Re: isdefined

2002-03-20 Thread Sharon Diorio
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

cfgraph...revisited...

2002-03-20 Thread Sharon Diorio
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

Re: UDF question

2002-03-19 Thread Sharon Diorio
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

Re: UDF question

2002-03-19 Thread Sharon Diorio
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

Re: locking (was: UDF question)

2002-03-19 Thread Sharon Diorio
...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

Re: CFX custom tag

2002-03-19 Thread Sharon Diorio
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

Re: CFX custom tag

2002-03-19 Thread Sharon Diorio
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

Re: Confessions of a sloppy non-CFLOCKer

2002-03-19 Thread Sharon Diorio
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

Re: Need help with mappings in CF Admin

2002-03-19 Thread Sharon Diorio
, 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

Re: UDF question

2002-03-19 Thread Sharon Diorio
? 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

Re: Meet my tables

2002-03-19 Thread Sharon Diorio
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

Re: User Preferences

2002-03-18 Thread Sharon Diorio
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 =

Re: UDF question

2002-03-18 Thread Sharon Diorio
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

Re: One call for two pages?

2002-03-17 Thread Sharon DiOrio
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

Re: Advice and opinion on client who has a problem paying bills

2002-03-17 Thread Sharon DiOrio
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

Re: One call for two pages?

2002-03-17 Thread Sharon DiOrio
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

Re: One call for two pages?

2002-03-16 Thread Sharon DiOrio
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;

Re: Session Vars and cfquery - cflock where?

2002-03-16 Thread Sharon DiOrio
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

Re: ICQ Hottie Spam Bot Turing Test

2002-03-15 Thread Sharon DiOrio
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

Re: Sprectra (WAS: KILL THE BROADVIEW!)

2002-03-13 Thread Sharon Diorio
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

Re: cached query

2002-03-13 Thread Sharon Diorio
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

Re: Database and Query issues.......YIKES!

2002-03-12 Thread Sharon Diorio
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.

Re: show my stuff

2000-10-05 Thread Sharon DiOrio
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

RE: Relief from redundancy?

2000-09-28 Thread Sharon DiOrio
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

Re: cfloop headache

2000-09-28 Thread Sharon DiOrio
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

Re: next row in cfloop

2000-09-05 Thread Sharon DiOrio
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

Re: can you store a structure in a client var?

2000-09-01 Thread Sharon DiOrio
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

RE: Structures No? Cached Queries Yes?

2000-09-01 Thread Sharon DiOrio
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

Re: Structures, Arrays, Array of Structures

2000-09-01 Thread Sharon DiOrio
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

Re: Javascript - Cold Fusion.

2000-09-01 Thread Sharon DiOrio
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

RE: Structures No? Cached Queries Yes?

2000-09-01 Thread Sharon DiOrio
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

Re: questions about cachedwithin

2000-08-25 Thread Sharon DiOrio
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

Re: questions about cachedwithin

2000-08-25 Thread Sharon DiOrio
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

Re: Structures, Arrays, and WDDX oh my

2000-08-25 Thread Sharon DiOrio
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

Locking (was RE: Structures, Arrays, and WDDX oh my)

2000-08-25 Thread Sharon DiOrio
a 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 DiO

Re: CFSCRIPT question

2000-08-24 Thread Sharon DiOrio
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

Re: CFSCRIPT question

2000-08-24 Thread Sharon DiOrio
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:

Re: Switch Statement in CFSCRIPT

2000-08-24 Thread Sharon DiOrio
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";

Re: nesting queries

2000-08-13 Thread Sharon DiOrio
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

RE: nesting queries

2000-08-13 Thread Sharon DiOrio
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

Re: Coldfusion Training..

2000-08-07 Thread Sharon DiOrio
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

Re: output query as array

2000-08-04 Thread Sharon DiOrio
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

Re: (syntax) variable naming conventions

2000-08-04 Thread Sharon DiOrio
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

RE: Selecting records at random in Oracle

2000-08-04 Thread Sharon DiOrio
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

Re: Functions in Cold Fusion

2000-08-01 Thread Sharon DiOrio
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.

RE: Custom Tag for Date and Time

2000-07-28 Thread Sharon DiOrio
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

RE: Allaire Certification Program

2000-07-10 Thread Sharon DiOrio
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

Re: line break as delimiter

2000-07-06 Thread Sharon DiOrio
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.

Re: Lasso vs Cold Fusion white paper - Your thoughts??

2000-06-29 Thread Sharon DiOrio
(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,

Re: Archive

2000-06-29 Thread Sharon DiOrio
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

Re: Is it possible to have a preview of records before going live??

2000-06-29 Thread Sharon DiOrio
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

RE: CFMAIL Urgent Help Needed...Please!

2000-06-29 Thread Sharon DiOrio
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

Re: Arrays and CFIF

2000-06-28 Thread Sharon DiOrio
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

Re: Selecting a value in a dropdown.

2000-06-27 Thread Sharon DiOrio
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

Re: isDefined() on session/application variables

2000-06-27 Thread Sharon DiOrio
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,

Re: cfscript

2000-06-22 Thread Sharon DiOrio
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

RE: Tracking users through a site

2000-06-22 Thread Sharon DiOrio
e 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 pe

Re: modifying variable names in a loop

2000-06-19 Thread Sharon DiOrio
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))

Re: CF Training?

2000-06-04 Thread Sharon DiOrio
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

Re: How can I count the number of words in a form submission?

2000-05-24 Thread Sharon DiOrio
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

Re: code to sort a structure?

2000-05-24 Thread Sharon DiOrio
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

Re: Can I put a wddx packet into a database and read it back out?

2000-05-17 Thread Sharon DiOrio
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"

RE: You have nice cookies .. mind if I have a look?

2000-05-16 Thread Sharon DiOrio
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

RE: Session vars in a clustered environment

2000-05-16 Thread Sharon DiOrio
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

RE: OT: School Days - (was: Lighten things up a little)

2000-05-15 Thread Sharon DiOrio
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

CFMail with attachments stops working?

2000-05-15 Thread Sharon DiOrio
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

  1   2   >