RE: Making 2D array

there are a coupld of ways to do this. you have CFSET filearray = ArrayNew(1) CFLOOP List=#file_content# Index=rc Delimiters=#Chr(10)# CFSET rc = ArrayAppend(filearray, rc) /CFLOOP already. therefore, each element of filearray[] is a pipe delimited list over which you can iterate with

RE: Using CFHTTP

perhaps you could create a user account on the target machine who's entire job is to have access to that file/directory. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: counting of domain-acesses

or even more tersely... HTTP_REFERER=http://www.helloworld.com/thepage/that_the/person.came?from cfscript UserDomain=ListGetAt(HTTP_REFERER, 2, /) /cfscript cfoutput#UserDomain#/cfoutput chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: Subtract Null = Error

check out the NVL function. i'm assuming this is SQL server. if you NVL(total, 0) in your sql query, it will substitute 0 for the NULL values. i'm also assuming that negative #newtotal# is ok. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: CFMAIL and MS SMTP

we use IIS's SMTP extensively with CFMAIL. do you have IIS set to allow the CF machine to relay? it's a common error, and one that most security minded folks ignore, since they turn it off by default. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com

RE: Netscape / CF4.0 / Apache / CFLOCATION

that's because CFLOCATION essentially sends a 302 header. it instructs the browser to go to that location because the resource has been moved... sounds like your browser(s) don't know how to follow the link automatically. chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: CF trojen? BackdoorJY.sv

actually, microsoft has a good article on hardening IIS5. don't have the link right now, but go to microsoft.com and search for securing IIS5. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Surma [mailto:[EMAIL PROTECTED]]

RE: DTS from Store Procedure MSQL 7.0

, Christopher Olive, CIO [SMTP:[EMAIL PROTECTED]] wrote: reviving an old topic... i've been looking into doing this for a recent client. i read simon horwith's (very clear) article on CFCOMET. works beautifully...on a machine with both CF ands SQL server on it. of course, this is the test box. when

RE: DTS from Store Procedure MSQL 7.0

reviving an old topic... i've been looking into doing this for a recent client. i read simon horwith's (very clear) article on CFCOMET. works beautifully...on a machine with both CF ands SQL server on it. of course, this is the test box. when i move it to our production servers (two bxes,

RE: DTS from Store Procedure MSQL 7.0

it is saved on the SQL server. CREATE PROCEDURE [MyDTS] AS Exec MASTER..xp_CmdShell 'dtsrun /S (server_name) /U (username) /P (password) /N (name_of_DTS)', no_return -Original Message- From: Christopher Olive, CIO

RE: Print without bringing print dialogue?

actually, you can't. it's a JS security feature. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Nathan Chen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 12:46 PM To: CF-Talk Subject: Print without bringing print

RE: Get Last Item in DB

not technically correct. in an RDBMS, there is no last row. the data exists in a set, not a table. therefore, the last row is only relevant if you mean something like the last row inserted, AND that you have a timestamp on it. therefore, this SQL would look like SELECT TOP 1 column AS

RE: maxrows and blockfactor

BLOCKFACTOR is how many rows are returned along the pipe at one time from the query. for example, if you have BLOCKFACTOR set to 50, and the query would return 400 rows, the DB sends the rows along the network pipe in blocks of 50. chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: Email this page to a friend....

problem with that is that if they haven't configured their email client correctly in their browser (at least have of the clusers i've talked to have not), it won't work well. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From:

RE: UI question

you could do a check server side on the action of the form. CFIF FORM.myselect EQ Other AND NOT Len(FORM.myotherdesc) whatever error processing you want... /CFIF chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jason Lotz

RE: Referencing an array item

array I would have: Application.SM[3][2][1] ? -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 5:49 PM To: CF-Talk Subject: RE: Referencing an array item well, you collapse the three arrays into an uber array, called SM. so

RE: Referencing an array item

: Application.SM1[n][element] Application.SM2[n][element] Application.SM3[n][element] I can't see how else to work around this. -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 8:31 PM To: CF-Talk Subject: RE: Referencing an array item

RE: Referencing an array item

ray has an excellent point. however, why not exploit the nature of arrays? if you make Application.Sm an array with three elements, each one the arrays sm1..3, then you can reference an element in SM(n) by Application.SM[n][element]. you don't have to futz with string evaluation at all. chris

RE: IIS4 Log file

did you select these items in the Logging configuration on both machines? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 3:12 PM To: CF-Talk Subject: OT: IIS4 Log

RE: Strange problem (or still asleep)

that OR should be an AND. something can't be BOTH 5 and 9 at the same time. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:20 PM To: CF-Talk Subject:

RE: E-commerce Dilemma

CFWebstore is EXCELLENT. Mary Jo has created an incredible product that works right out of the box. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Christine Kelley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 3:03

RE: Query Help!! Problems???

are shipfrom and shipto string? if so, you'll get that error on the second query, as you're comparing strings to numbers. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11,

RE: Who's a good merchant these days?

what? boa is FUBAR! i tried to use them, and their tech is WAY behind. they're only now starting to let you use CFHTTP to do the processing (or they will be...within the next 2 or 3 months...) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: SQL query help

SELECT distinct(color) as color WHERE name = 'bar' chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 4:16 PM To: CF-Talk Subject: SQL query help I

RE: Who's a good merchant these days?

. H. just my .02 of a dollar :p G -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 3:17 PM To: CF-Talk Subject: RE: Who's a good merchant these days? what? boa is FUBAR! i tried to use them, and their tech is WAY behind

RE: Simple SQL SELECT

whenever you use an aggregate function (like count()), you have to use the GROUP BY clause. put the rest of your columns there. ie: SELECT phID, phCOL, COUNT(phID) As coPHOTOS FROM photos WHERE phGROUP='#grid#' AND phCOL IS NOT NULL GROUP BY phID, phCOL chris olive, cio cresco technologies

RE: How to Force https vs http

i used to override the custom error from IIS (403.5, i think). write your own redirect script. so when they go to http:// something, they get automatically redirected to https:// something. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: Finding the last item in a loop

maybe cfloop query=qry_show_event_sponsors #EventSponserName#cfif CurrentRow NEQ qry_show_event_sponsors.recordcount,/cfif /cfloop ? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chris Martin [mailto:[EMAIL

RE: Benefits of CFSWITCH vs. CFSCRIPT with SWITCH

that's actually something they warn about in C courses. you must have a break in your case statements, or it will cascade down the cases after the first match. it's defined as bad programming in most cases, but all bad things (infinite loops, etc) have applications in carefully controlled

RE: ' in SQL 2000

perhaps you could post the code you're using. we could take a look. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:42 AM To: CF-Talk Subject: ' in SQL

RE: using NT accounts for username/password login authentication

if you're running IIS, just switch off anonymous access. users will be prompted for their NT password, and the ACL on that directory/file will take over. if they're not authorized, they get a 403.1 error. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com

RE: using NT accounts for username/password login authentication

will be more descriptive in my question. Thanks, Jerre Christopher Olive, CIO wrote: if you're running IIS, just switch off anonymous access. users will be prompted for their NT password, and the ACL on that directory/file will take over. if they're not authorized, they get a 403.1 error. chris

RE: textarea

well, you can't techincally put bullets in there, but if you want to save the carriage returns that people use in your textarea, use the WRAP=HARD attribute in the textarea. when outputting, use ParagraphFormat() to do something about the CRs in the output. chris olive, cio cresco technologies

RE: Character code for a TAB

problem with that is exactly what we're discussing. the answer may not have come into my inbox before i reply to a message. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent:

RE: 100s of FTP Accounts

you could always write a WSH script to use ADSI to do that. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 11:22 AM To: CF-Talk Subject: 100s of FTP

RE: Character code for a TAB

that'd require a synchronous type of situation. the beauty is that people who may be able to answer the question don't have to be there when you are. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Lugassy

RE: 100s of FTP Accounts

have i left you speechless? :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Tobe Goldfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 1:20 PM To: CF-Talk Subject: RE: 100s of FTP Accounts At 11:51 AM

RE: JS-question- transferring text from one template to another

take a look at irt.org and thier JS faq. there are TONS of code snippets there. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:31 PM To: CF-Talk

RE: statement help...

are you only outputting one? as in, do you have QUERY specified in the CFOUTPUT tag? or does your debug show only one returned? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent:

RE: CFTRY / CFCATCH questions

that's incorrect, actually. it will catch them in the order defined. so if there is an ALL first, there will never be any other. basically, it starts at the first CATCH, compares exception types. if it is a match, that handler occurs, if not, it examines the next one in order, ad nauseum,

RE: http 500 Internal Server Error and CF installation

Technologies, Inc. want CF_Freedom? try CFXHosting.com -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 5:43 PM To: CF-Talk Subject: RE: http 500 Internal Server Error and CF installation that depends. i've always had to (per

Bank of America and e-stores and CFHTTP

has anyone had any particular problems or success using CFHTTP to talk to BoA's estores solution? i haven't been able to get it to work, and their techs tell me that people have *definately* used CF in the past to do this. i can follow thei rinstructions and use a standard HTML form post to

RE: Bank of America and e-stores and CFHTTP

the POST command? It's hard to diagnose without a snippet. Thanks, Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Thurs

RE: Bank of America and e-stores and CFHTTP

Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 10:16 AM To: CF-Talk Subject: Bank of America and e-stores and CFHTTP has anyone had any particul

RE: http 500 Internal Server Error and CF installation

gs, remove and recreate the app...should fix it fine -- Stephenie Hamilton Senior ColdFusion Administrator Express Technologies, Inc. want CF_Freedom? try CFXHosting.com -Original Message----- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 3:00 PM T

RE: The Best Clustering Solution

i seem to remember reading that cluster cats DID come with replication. check the docs again. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Paul's Mail [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 6:19 PM To:

RE: Problem browsing web pages in the CFStudio editor window

go to Debug-Development Mappings (Alt-M if you're a shortcut guy) enter the path that studio "sees" as your studio path. this will be the same as the "server path" if you're running IIS/PWS locally. then put "http://localhost/" as your "Browser Path". this is what you would enter if you were

RE: cfif myvar IS true vs cfif myvar

that's CFIF isDefined("myvar"). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Bonnie Betts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 8:45 PM To: CF-Talk Subject: Re: cfif myvar IS true vs cfif myvar I

RE: Query string disappear

the only way to do that is with a javascript generated window. js won't let you touch the "chrome" on a non-js generated window. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent:

RE: Dynamically Displayed Content Weekly?

you don't even really need to do that. if you have queries to pull the data from your database on the "main page" (the one with the weekly data), use the CACHEDAFTER property of CFQUERY. this will cache the results until a certain date. set the date for one week from today, and voila! chris

RE: Dynamically Displayed Content Weekly?

uery should be flushed and reloaded from the database, use: cfquery datasource="MyDSN" name="MyQuery" cachedwithin="#CreateTimeSpan(days, hours, minutes, seconds)#" .SQL... /cfquery - Andy -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTE

RE: Reveral of a field

you could use the listfirst and listlast functions. assuming that your names are alwas Last, First: CFSET thename = "Smith, John" CFOUTPUT #listlast(thename)# #listfirst(thename)# /CFOUTPUT make sense? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com

RE: disabling back or second insert

why not move the check to the action form? that way they can enter the data all they want, and click submit all they want. it won't insert the data if someone by that name's already there. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original

RE: disabling back or second insert

changes to his form entry, they will never be submitted. I would prefer the abilty to kill the back. How are some of you doing this with Javascript? Brian -Original Message----- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 3:52 PM To: CF-Talk Subject

RE: disabling back or second insert

only problem with that particular approach is that HTTP_Referer is not always passed by the browser. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 9:48

RE: adding records

i don't think it will directly do it. i've worked with it, and she wants to populate a textbox, not another drop down. but i think you can abuse the tag by writing your own handler for what it already does. just replace the bit that changes the second select box to populate the text box.

RE: How to Allow a Doesn't Matter Variable in a Search?

if you use checkboxes for the selections, use isDefined() on your action page. if the checkbox for that selection is defined, include it in your where clause ex: SELECT WHERE CFIF isDefined("FORM.hottub") AND hottub field is yes /CFIF chris olive, cio cresco technologies [EMAIL

RE: Line Breaks

that's odd. would have been my answer before today, but i had a template that WOULD NOT put in CRs for me. wierd. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April

RE: Simple validation

isDate(). isNumeric(). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Steven A. del Sol [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 6:04 PM To: CF-Talk Subject: Simple validation I am in desperate need of a

RE: [Oracle Auto-Increment]

just mark something as an identity in the design table form. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 9:58 AM To: CF-Talk Subject: RE: [Oracle

RE: Escaping apostrophes

PreserveSingleQuotes(). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 2:39 PM To: CF-Talk Subject: Escaping apostrophes Hello, This must be a basic

RE: Text area question

when you save it, make sure your form area WRAP attribute is set to HARD. then use paragraphformat on the output side. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Javed Mushtaq [mailto:[EMAIL PROTECTED]] Sent: Thursday,

RE: session time out

you need to enclose your time units in " marks for createtimespan eg: createtimespan("0","1","0","0") chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chang Liu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 3:52 PM

RE: Import List into DB

just use Access' Import function and select "Text File" as a source. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jim Mixon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 6:55 PM To: CF-Talk Subject: Import List

RE: newbie wants to access by rows and columns

technically, you can't do this. some other people have suggested solutions that will give you a close approximation of "the second row". the problem (there is no fault with the suggestions or code) is that the concept of "the second row" is not a constant. because of the way RDBMS systems

RE: SQL Server...

i've never had the defaults/identity stuff transfer successfully, either. even between SQL installs, selecting "Transfer Objects". i've resorted to scripting the tables, sticking the defaults in myself (scripting will capture the identities) and running the scripts on the target system. chris

RE: getting users name

it's NT Challenge/Response. (not that that's important...:) look at CGI.AUTH_USER for the login name. (this question has been asked several times recently. kind of interesting how things seem to run in cycles) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com

RE: SQL + time stamp

try GROUPing on the hour part of the time. similar to: SELECT datepart("hh", dt) as myhour, sum(columnOne) as totalflow FROM tablename WHERE date criteria here GROUP BY datepart("hh", dt) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com

RE: Building Cold Fusion Search - Dynamic SQL

since a multiple select gives you nothing more than a list, try a list loop. SELECT e.empId, es.skillId FROM emp e, empSkills es WHERE e.empId=es.empId CFLOOP INDEX="skillidx" LIST="#FORM.frmSkill#) AND skillId = #frmSkill# /CFLOOP chris olive,

RE: Building Cold Fusion Search - Dynamic SQL

d=es.empId CFLOOP INDEX="skillidx" LIST="#FORM.frmSkill#) AND e.empID IN (SELECT empID FROM empSkills WHERE skillId = #skillidx#) /CFLOOP GROUP BY empId -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27,

RE: Selecting a date range, access DB

well, if you pick all the dates that have a date greater than today AND less than today, you'll get nothing. :) i think you need to rethink your date range. :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Thomas Chiverton

RE: Selecting a date range, access DB

where you will be promptly killed and eaten by the CFTALKers waiting for your return. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Ramonda Ramos [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 11:59 AM To: CF-Talk

RE: browser refresh/reload

that's not strictly correct. the webserver and browser are the ones that handle these variables (CGI and HTTP scoped ones.) not all browsers support them. additionally, the HTTP_REFERER variable you talk about first is only populated when following a link. refreshing a page does not change

RE: A little help with aggregate query, please?

your sum is being GROUPed by each individual donor. it might be more advantageous to calculate it yourself while looping through the "individual donors" query. ex: query cfquery name="GetReportInfo" datasource="tjf" dbtype="ODBC" SELECT Donors.ID, Donors.Fname, Donors.MI, Donors.Lname,

RE: Delimiters...

look at the ListFirst, ListLast, and ListRest functions. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Ethan Rosch [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 4:20 PM To: CF-Talk Subject: Delimiters... Hi all

RE: Pre-made State and Country database tables?

there's country and state tags in the Developers's exchange at allaire. very nice, i use them a lot. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Joby Bednar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 8:18

RE: IIS redirect URL

you don't really need a redirect. just create a virtual site for members.mydomain.com with its root at /userhomepages. that should get you started. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jay E Wigginton

RE: can anyone help?

you need to put the lvalue in for both comparisons. like this: cfif ProdCount LTE "3" AND ProdCount GTE "1" chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15,

RE: Passing a value

looks like you're not terminating the string on the last meta tag. meta http-equiv="refresh" content="0;URL=http://www.workcover.com/search/?ul=ps=10np=0q=#URL.SemioQ ueryString#" notice the closing " on the content piece. chris olive, cio cresco technologies [EMAIL PROTECTED]

RE: Dateformat behaviour

actually, it looks like DateFormat is helping you out by assuming that the second date you supply is the "european" style of mm/dd/. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: INGECOM - D. Delcomminette [mailto:[EMAIL

RE: Server Running Low on Virtual Memory

doing a properties on that file, i see it's description is (helpfully...) "Generic Host Process for Win32 Services". HTH. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Raley, Scott M (MIL) [mailto:[EMAIL PROTECTED]] Sent:

RE: Urgent - Forums 2.05 Anyone Got?

unfortunately, it's not so easy to find the "TODO" list for the forumspot project. i looked all over the site today, as i'm interested in contributing, but could find no place that listed the TODO stuff (as is traditional in open source projects). chris olive, cio cresco technologies [EMAIL

RE: Multiple conditions in a single CFIF statement.

what you wrote was correct. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 11:15 PM To: CF-Talk Subject: Multiple conditions in a single CFIF statement.

RE: Session timeout question

i don't think that's strictly correct. you can't "define the timeouts" of session variables, you define them of the entire session. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent:

RE: ORDER BY?

order by the aggregate function. cfquery name="GetTotalPts" datasource="?" dbtype="ODBC" SELECT ContestantID, SUM (AdjPoints) as TOTALPTS, SUM (MoneyEarned) as TOTALMONEY FROM ResultsManager GROUP BY ContestantID ORDER BY SUM(AdjPoints) /cfquery chris olive, cio cresco

RE: trim a string variable

i was actually going to suggest this. the only problem is if the file name is something like filename.old.cfm or something like that. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]]

RE: Displaying the IP of a server

CGI.REMOTE_ADDR will give you the IP of the client computer, if their browser supports it. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 3:09 PM To:

RE: CFLOCK question

AAMOF, the scope attribute was added in 4.5. you have to use "NAME" in 4.0. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: JB Mentzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 10:25 AM To: CF-Talk Subject:

RE: Syntax error....

you have your ids as text fields when inserting the values. my first thought would be to remove them. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 5:05

RE: Break in attempts?

actually, ran into that error message when i named one of my templated MemberApplication.cfm. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jon Gage [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:37 PM To:

RE: why use 3rd dimensional array??? You dont understand!

take something like a body of information with multiple levels of organization. for example, when i was working for the DOD, i had an installation. this had major commands associated with it. these macoms had people assocated with them. inefficiently, you might index the data so the

RE: Question about CFFILE permissions

you could implement Advanced Security and create a "sandbox" for each user. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 12:17 PM To: CF-Talk Subject:

RE: Query problem

actually, you WANT a cartesian product for this, since you want every row in members compared to every row in details. that means no join. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent:

RE: session application variable

really? i took the fast track and thought it was pretty good. i had tought myself much of what was in it, but it was nice to see why things worked the way they do. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: William J

RE: Email app!

there's the Crazy Cab Email client example application that comes with Server. check it out. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 4:24

RE: DB Query

so you want a list of proucts and both manufacturers? try a double join. (please note. this assumes that there are always values for both ManID and RealManID. if they are not always populated, make the joins OUTER and you'll be good.) SELECT p.pid, p.columns from products,

RE: Random letter/number value

there are tags in the developer gallery for this. search for "password". chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:56 AM To: CF-Talk Subject:

RE: Check filesize BEFORE uploading

the entire point of that thread was that there was not a way in CF to do that. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Roger Lim [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 9:57 PM To: CF-Talk Subject:

RE: Dumb Questions :: About Verity :: Intranets

verity can index queries. look up CFINDEX in the docs. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 8:25 AM To: CF-Talk Subject: Dumb Questions :: About

RE: Driving Me Nuts

actually, it will default to ascending. you don't need to specify. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Stuart Duncan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 1:53 PM To: CF-Talk Subject: Re:

  1   2   >