SQL: Outer Join w/ criteria

-- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http

Re: Determine the number of form fields...

lds exist to perform this query. Has anyone done something similar to this, what would the best method to employ? Thanks, Peter ------ Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PRO

Re: SQL Question (sorta OT)

to the WHERE clause. When I do this, the query returns 0 records (unmodified, it returns 25 records). Any ideas are greatly appreciated. * John * ------ Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com

RE: QUERY QUESTION

because ID 5 is in there with item id 19,15 and 13 but it seems to only pick up and display the first one Do I need to change my query Kelly -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED]

Re: output query as array

. Any Ideas??? -Eli- ------ Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion

Re: Need to take several row query and make into one row.

pulation isn't practical. Is the answer in sql? structures? arrays? or ? TIA, Rick -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500

Re: lists and variable names

/cfloop cfset Loop1Count = Loop1Count +1 /cfloop There must be some way around this, Ive tried putting the lists into an Array (Im new to arrays) but a had a problem because each list was not the same length. Any recommendations on how to accomplish this...? Th

RE: Looping through an Array

Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ------ -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -

Re: CF logins, authenticate against Novell NDS???how?

S "newbies" in the right direction via URL to stuff on integrating NDS w/ cf4.5? Any help appreciated Steve ------ Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PRO

Re: I want my #$# on the first of the month.

EMAIL PROTECTED] on 05/31/2000 ------ Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -- Archives: http://www.eGroups.com/list/cf-t

Re: OT: Sql for selecting date ranges

:08 PM 5/31/00 -0700, you wrote: What is the best way to go about selecting date ranges. Like selecting everything from today's date up to 5 or 6 days from now? Shawn Regan -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL

Re: CF logins, authenticate against Novell NDS???how?

Paul, You should be able to access NDS directory info via CFLDAP. Your network admins will need to set up an LDAP server on one of your Novell servers -- I don't think it is installed by default on a Novell server. I know others on this list have done this -- to be honest, I haven't but

Re: Shortcut for Getting Form Field

to go through and doing all the copying pasting... -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -- Archives: http

Re: Slightly OT: Lighten things up a little

I know, I know, cf-community... Anyway, who's selling the WWBFD bumper stickers? I'll buy one! Kevin At 06:58 AM 5/9/00 -0500, you wrote: - Have a bumper sticker reading 'WWBFD'. -- Archives:

Re: What's the use of structures, anyway?

Reuben, I totally understand what you're saying. When I first considered structures, they seemed like really complicated mechanisms for holding data that could be just as easily placed into a query or a list. What I've found, however, is that structures can be incredibly powerful if you

Re: What happened to this list?

Marcus, I, for one, would like to know who sent that message to your boss. I'd hate to make the mistake of answering a question for or even bothering to read a post by such a despicable individual. I too lament the recent angry tone on the list. I've been reading CF-Talk for almost 2 years

Re: Deleting Data

to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -- Archives: http

Re: three table sql join

blishing Group 302 Hiram Smith 1545 Observatory Dr. Madison, WI 53706 (608) 265-7923 ------ Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 ---

Re: DB update with email notification

e included in the update form. Currently, we are using a form2email perl script for email notification. I am not familiar with CFMail. Any ideas how this could be accomplished within one form? Thanks! Karen ------ Kevin Marshall Web Application Developer eCalton.com, Inc. Vero

Re:

--- David Ryan - Minister of Information and Culture CRUMBLING EMPIRE PRODUCTIONS 134 W.26th St. 12th Floor New York, NY 10001 (212) 247-0296 -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ec