RE: deadlocks in CFGLOBAL

updating row 1 based on row 2 while a concurrent thread is updating row 2 based on row 1? deadlock Search your code for any client variable updates that might cause the above situation to happen. +---+ Bryan Love Macromedia Certified Professional

RE: Annoying DB question

). That will prevent concurrent threads from inserting the same ID +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Annoying DB question

That's true - thank you for clarification. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Problem writing query result to file

) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my

RE: Query Issue

this... [table] users (FK) [table] users_roles (FK) [table] roles +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Running a query in javascript

:) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace

RE: Coldfusion /MS Exchange

I'd love to see that too, if you don't mind :) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Dynamically Selecting Option with CFSELECT

Syntax CFSELECT NAME=name REQUIRED=Yes/No MESSAGE=text ONERROR=text SIZE=integer MULTIPLE=Yes/No QUERY=queryname SELECTED=column_value VALUE=text DISPLAY=text PASSTHROUGH=HTML_attributes /CFSELECT +---+ Bryan

RE: CFEXECUTE

I've never been able to get CFEXECUTE to work when using arguments +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Slightly OT using a .sql script the create a Access Database

open a new DB select QUERIES from the left side click CREATE QUERY IN DESIGN VIEW click CLOSE at the SHOW TABLES prompt from the top menu click VIEW - SQL VIEW you can run scripts from here. -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 6:29

RE: Client var problem

deletion (according to the CF Administrator)? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: sql error

that's not it. That would give you a DATASOURCE NOT FOUND error. Chances are you just mapped to the wrong DB somewhere or your permissions are screwed up somehow. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer

RE: CFX_IMG, AUTORESIZE, and personal photo DB with 3000 original photos.

why are you trying to load them in a file field?? If you have the tag just do a cfdirectory of your images folder and run the tag on each of the images in that folder. +---+ Bryan Love Macromedia Certified Professional Internet Application

RE: Conditional Query loop

if the query results are ordered by category then just: cfoutput query=myQuery group=category #category#br cfoutput loop through all sub-records here /cfoutput /cfoutput +---+ Bryan Love Macromedia Certified Professional Internet

RE: Conditional Query loop

this particular problem +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let

RE: CFX_IMG, AUTORESIZE, and personal photo DB with 3000 original photos.

inside the custom tag it must be doing a cffile action=upload... change it to do a cffile action=read... and you'll be able to pass it a path to a file instead of using a form field. +---+ Bryan Love Macromedia Certified Professional Internet

RE: can this be done?

(fullName, )#', '#listLast(fullName, )#') .. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: next previous with grouped output

use a DISTINCT clause in your SELECT statement. That way each product will only have one record and the rest of the problem solves itself... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RE: Access SQL

+---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace

RE: How can I do this???

double quotes must be escaped... CFSET target= ' target=new' CFSET new='uploads/'TRIM(Y)target OR, if you use double quoted strings... CFSET target= target=new CFSET new=uploads/TRIM(Y)target +---+ Bryan Love Macromedia Certified Professional

RE: to # or not to #

+---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my

RE: Logging warnings...

page logging you can compare the timestamp in the log to the timestamp in your query string records. Not very friendly, but you don't really have a choice. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database

RE: SQL help

you have two options... leave the isFeatured column out of the SELECT clause so that the DISTINCT operator works, OR order the results by product name then cfoutput query=products group=productName +---+ Bryan Love Macromedia Certified

RE: Directory Name

good one why not make it work on Windows and Unix... Just add a / next to the \... cfset MyDirectory=ListLast(GetDirectoryFromPath(GetCurrentTemplatePath()), \/) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer

RE: Data Farming/Data Mining( what's the difference? )

data farming requires a green thumb :) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Directory Name

, The American Crisis -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 3:58 PM To: CF-Talk Subject: RE: Directory Name good one why not make it work on Windows and Unix... Just add a / next to the \... cfset MyDirectory=ListLast(GetDirectoryFromPath

RE: Which Is Faster, multiple CFQuery or Multiple Query of a Quer y?

bingo +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my

RE: FW: Do you know anything about Securing Class Loader in Java?

Looks like a project requirement (technical spec). http://www.javaworld.com/javaworld/jw-10-1996/jw-10-indepth.html +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems

RE: Query Issue.

#'/cfif cfif isdefined(col4),col4 = '#col4#'/cfif WHERE id = 12345 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Query Issue.

)'#col2#'cfelsecol2/cfif, col3 = cfif isdefined(col3)'#col3#'cfelsecol3/cfif, col4 = cfif isdefined(col4)'#col4#'cfelsecol4/cfif WHERE id = 12345 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RegEx help...

Does anyone know a regular expression that can be used in a rereplace(...) to remove HTML comments from a string? I can't find one that takes into account nested comments... +---+ Bryan Love Macromedia Certified Professional Internet Application

RE: 10 records per page

I've got one... you want it? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must

RE: SELECT TOP n vs MaxRows...

is supported on most DBs (although it's been awhile since I've checked that one)... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Cache size

also, go to START - FIND - Files or Folders type *.cfm in the results page highligh all the files, right click and pick properties the total size is there. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer

RE: Quick question...

char 9 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my

RE: cfinclude passing multiple params

I know you already posted NM, but I want to point out that this is definitely an argument for the use of custom tags. That is what they are for :) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RE: Replacenocase doesn't replace chr(10)?

problem must lie elsewhere... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must

RE: output cf to html

like loading report Give it a 5 second reload time and you'll be set. This way the html report will be created fresh the first time it is called each day. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database

RE: output cf to html

will happen for rows 1 and 3. do inner stuff will happen for row 2. It is crucial that you ORDER BY whatever column you want to group by in your SELECT query. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database

RE: output cf to html

to figure out, but i cant thx -paul -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 6:40 PM To: CF-Talk Subject: RE: output cf to html simple lesson in query grouping... When you specify a group attribute like so... cfoutput query=myQuery group

RE: cfinclude passing multiple params

yep -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 3:52 PM To: CF-Talk Subject: RE: cfinclude passing multiple params I think he meant Turn your included file into a custom tag. -Craig Thomas

RE: Preventing IE 6 from submitting a form on click of Enter

how bout ...onclick=this.form.submit() +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Using CF to populate JS variables efficiently

here's a thought... For quick array creation in JS do this: .. myArray = newArray(#quotedValueList(query.column)#); .. I wrote this ad-hoc, so the syntax might be a little off, but I believe that's it. +---+ Bryan Love Macromedia Certified

RE: CFABORT after CFLOCATION?

directories. who knows... could be anything. Good luck :) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Using CF to populate JS variables efficiently

perspective will pop up. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let

RE: variable not being cleared in a loop?

. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child

RE: Week numbers and dates

multiple years? Put the whole thing in a loop. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Week numbers and dates

; startDate = dateAdd(d,mondayOffset,startDate); /cfscript cfoutput cfloop from=1 to=#maxWeeks# index=i #dateFormat(dateAdd(ww,i-1,startDate),mmm d, )#br /cfloop /cfoutput -- +---+ Bryan Love

RE: Dynamic Var names

cfset client.variable#url.test# = bla bla cfoutput #evaluate(client.variable url.test)# or #evaluate(client.variable#url.test#)# /cfoutput +---+ Bryan Love Macromedia Certified Professional Internet Application Developer

RE: SQL select question

] +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace

RE: querying funky text files

Fixed width makes it easy to convert, but if you are just querying you shouldn't have to convert anything. Just use Find() or something similar... Refind() is capable of returning multiple results if you need that instead... +---+ Bryan Love

RE: connection error

specify a uname and pword in the CFQUERY... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Deadlock

are ever executed by different threads at the same time you have a deadlock because each lock is waiting for the other to finish. Look through your code and make sure you don't have any issues like this one Bryan Love -Original Message- From: Justin Waldrip [mailto:[EMAIL PROTECTED]] Sent

RE: quotes

use the HTMLEditFormat() function like this: input type=text name=bla value=#htmlEditFormat(theValue)# Problem solved :) B -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 3:07 PM To: CF-Talk Subject: quotes Dear All, I'm facing a problem

RE: Sending Message Alerts...

how complicated is the message? you can do it with image pipes... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: An IMG instead of a form SUBMIT button ?

remember if you do this that the next page needs to check for form.submit.x or form.submit.y since it's an image now... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems

RE: Trigger and Sequences

Last I knew you couldn't end a CREATE TABLE command with a comma Why in the world are you doing this from CF??? -Original Message- From: Langford, Bryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 4:40 PM To: CF-Talk Subject: Trigger and Sequences Hi all, I am

RE: Client Variable Scrabble

First off, why bother setting client cookies at all?? If you pass the CFID and CFTOKEN through the URL and vars are stored in the DB, then why set cookies? I don't remember off the top of my head whether CF looks for CFID and CFTOKEN in the cookie first, or in the url string, but you might want

RE: Client Variable Scrabble

of the same group (called at the same time) of includes. But could there be a moment in time, when variables are just local variables, between getting passed between CFWDDX tags when they could be vulnerable to getting mixed up? H. -Original Message- From: Bryan Love [SMTP:[EMAIL PROTECTED

RE: Client Variable Scrabble

be vulnerable to getting mixed up? H. -Original Message- From: Bryan Love [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:37 PM To: CF-Talk Subject: RE: Client Variable Scrabble First off, why bother setting client cookies at all?? If you pass the CFID and CFTOKEN

RE: A little SQL help

WHERE Table1_ID = (600 + Table2_ID) wouldn't it be this... WHERE Table1_ID = (Table2_ID - 600)?? -Original Message- From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 7:23 PM To: CF-Talk Subject: OT: A little SQL help I want to

RE: Client Variable Scrabble

somewhere in your code -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 7:14 PM To: CF-Talk Subject: RE: Client Variable Scrabble MSSQL Server. H. -Original Message- From: Bryan Love [SMTP:[EMAIL PROTECTED]] Sent: Wednesday

RE: CF - Problem with missing Form Data

You aren't enabling/disabling the form fields with Javascript are you? Disabled form fields don't get passed. Also, If the field is a radio button be sure you check one of them by default or the field could be left blank and it won't get passed. Same is true for checkboxes. You might also want

RE: CF - Problem with missing Form Data

email the HTML you get from view source or post the url to the form so we can hit it. -Original Message- From: Vishal Narayan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 10:02 PM To: CF-Talk Subject: Re: CF - Problem with missing Form Data The problem is that these

RE: remove evaluate question...

you only really need one cfscript foo = Evaluate(server.#new_portal_id#); stPortal.name = foo.name; stPortal.prename = foo.prename; stPortal.postname = foo.postname; stPortal.url = foo.url; etc /cfscript +---+ Bryan Love Macromedia

RE: CF/Database Help

Sure: I've found that storing recipes in a rolodex works well, and always store ingredients in a clean, dry area. Be sure to refrigerate those that need it! ;) -Original Message- From: Deborah Curley [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 1:31 PM To: CF-Talk Subject:

RE: CFCOOKIE

to Administrators] so you can see why the cookie ends up being Administrators... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: CFCOOKIE... more...

try this: cfcookie name=SetGroups value=#valuelist(users.group)# expires=NEVER +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: OT: Oracle version of TOP

() and onBlur() to onFocusIn() and onFocusOut(), but I haven't tried it yet... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: JS Question

oops, I accidentally posted this reply under the wrong subject! Here it is again... .. I have a form that, if a user selects a specific item from a select list, then the next section of the form is grayed out, and the required attributes are no longer required. I know how to by-pass the

RE: JS Question

(); } Beware - I've heard that IE6 changed onFocus() and onBlur() to onFocusIn() and onFocusOut(), but I haven't tried it yet... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems

RE: Efficient database inserts

There are many factors to consider, but on average I'd say don't bother. The performance gains you'll see will not be noticeable. Perhaps doing this might save you 1/10 of a second... The only time you MIGHT take notice of this is if you have millions of records and many indexes (since the

RE: Stored procedures pdfs

(without pdf conversion all show up correctly) wouldn't this indicate that the problem is NOT in the stored proc?? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems

RE: deleting session variables when browser is closed

session variables are automatically deleted when the browser is closed. That is their nature. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: deleting session variables when browser is closed

to YES then put this just below the CFAPPLICATION tag: cfcookie name=CFID value=#cookie.cfid# cfcookie name=CFTOKEN value=#cookie.cftoken# +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst

RE: RE: deleting session variables when browser is closed

there...). I must admit I haven't used session variables for years and some of my previous assumptions that I thought were true are faulty. Thanks for straightening me out! +---+ Bryan Love Macromedia Certified Professional Internet Application

RE: RE: deleting session variables when browser is closed

Ah yes... that makes perfect sense. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Need help with mappings in CF Admin

, otherwise it will try the file relative to it's current position in the file system. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Meet my tables

I've revisited this problem a million times and there is no easy solution. Oracle's CONNECT BY is very nice, but if you aren't using Oracle you have few options. You can do it with a loop, but it's not pretty and it won't scale. +---+ Bryan Love

RE: SQLHELP QUICK!

. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace

RE: Creating a new query from two existing queries and then sorti ng the new query

Query of queries would work, but it's not necessary. SELECT bla, bla FROM table1 UNION SELECT bla, bla FROM table2 ORDER BY date The ORDER BY happens AFTER the UNION (not sure of that for SQL 2000, but works in SQL 7, Access, Oracle 8i) +---+ Bryan

RE: CF IIS Virtual Directories

the account CF runs under. In NT go to the Services in the Control Panel and highlight Cold Fusion Application Server. Click STARTUP and at the bottom specify an account that has access to the share. Stop and restart CF. +---+ Bryan Love Macromedia

RE: Update multiple rows

pound signs - yes CFOUTPUTs - no +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must

RE: Slow CF response times?

sorry for long response time... A primary key IS a unique index, and yes - as far as I know a primary key/unique index is safe. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication

RE: Slow CF response times?

and index on the CFID column for both tables (CGLOBAL and CDATA). The query currently does a table scan to find the needed info 2. Make sure that Maintain Connection is checked for the DB you are using for client storage. +---+ Bryan Love Macromedia

RE: CFINCLUDE and virtual directories

relative pathing from folder2 (since that's where you REALLY are). You can CFINCLUDE files that are outside your web root... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication

RE: correct delimiter?

put them together and use them both as the delimiter like this: cfset crlf = chr(13)chr(10) cfloop delimiter=#crlf#... When you specify muliptle characters as the delimiter CF will use EITHER ONE as the delimiter. +---+ Bryan Love Macromedia

RE: Ecommerce??

/ (click on the NetReady links near the center of the page) Email me off-list for more info. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: OnRequestEnd.cfm on linux?

Yes +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my

RE: oracle get tick count?

processes/times through SERVER STATS under the TOOLS menu +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: Deleting Row from Array

session.cart = ArrayDeleteAt(session.cart[1],form.counter) If you aren't storing the items in the above fashion then you'll need to provide more info before you'll find a solution. +---+ Bryan Love Macromedia Certified Professional Internet Application

RE: Deleting Row from Array

= ArrayDeleteAt(session.cart,form.counter) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must

RE: Deleting Row from Array

ourselves! +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day

RE: A-Z 0-9 form validation

. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day

RE: A-Z 0-9 form validation

also, how are you generating the primary key for the insert statement? If you are using SELECT MAX() then you can have issues without using CFTRANSACTION. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer

RE: WDDX

Because not everybody knows XML... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must

RE: WDDX

. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace

RE: How do u add colums in SQL query and do a WHERE on the new co lumn

is nullable... WHERE past_due_30 IS NOT NULL or if past_due_30 doesn't have to have have a value for past_due_60 to have a value... WHERE past_due_30 + past_due_60 + past_due_90 + past_due_120 0 +---+ Bryan Love Macromedia Certified Professional Internet

RE: utterly, utterly bizarre CFEXIT problem (kinda long but fun ny)

nope. What version of CF? What OS? What web server software? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED

RE: I need to do a sum on a secondary (left outer join) table...

SELECT primary.primary_id, primary.initiated, primary.completed, SUM(secondary.received) FROM primary LEFT OUTER JOIN secondary ON primary.primary_id = secondary.primary_id GROUP BY primary.primary_id, primary.initiated, primary.completed +---+ Bryan

<    1   2   3   4   5   6   >