RE: [KCFusion] Error Executing Database Query

2003-10-16 Thread Bruce Dunwiddie
Title: Message I can't see anything codewise that would cause that. I would think it'd be something in your setup for the otg datasource. Maybe you have it pointing to the wrong database or server? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED]

RE: [KCFusion] cfmail validation in MX

2003-10-13 Thread Matt Jones
Title: Message your best choice would be to validate the emails without trying to send them out, but if you must go that route, you could try something like cftry!--- cfmail stuff goes here --- cfcatch type="Application"cfif not cfcatch.name is "to"!--- do whatever failure stuff you

RE: [KCFusion] cfmail validation in MX

2003-10-13 Thread hartwichr
Why don't you wrap your cfmail tag inside of a cfcatch/try block. Have it rethrow the error when it hits one and put the bad email address into a 2nd table for manual intervention. I think the rethrow tag allows the script to continue where it crashed.

RE: [KCFusion] Client variables

2003-10-09 Thread Matt Jones
yes, it is a SCOPE! what version of cf did you upgrade from? -Original Message- From: Chris Holdman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:21 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Client variables Well I am not sure if this is a problem

RE: [KCFusion] Client variables

2003-10-09 Thread Chris Holdman
, 2003 11:27 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Client variables yes, it is a SCOPE! what version of cf did you upgrade from? -Original Message- From: Chris Holdman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:21 AM To: '[EMAIL PROTECTED]' Subject: RE

RE: [KCFusion] JRun issue when filling Verity on MX

2003-10-09 Thread Bruce Dunwiddie
] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Benjamin Price Sent: Thursday, October 09, 2003 10:47 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] JRun issue when filling Verity on MX I create another Query using the QueryNew, QueryAddRow and QuerySetCell

RE: [KCFusion] CF MX and ODBC datasource with decode stmt

2003-10-01 Thread jabrown
We use decode on ORACLE quite often and haven't had any problems since moving to MX. Can you post an example query? What version of ORACLE? Jeff -Original Message- From: Minor, Beth [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 3:52 PM To: [EMAIL PROTECTED] Cc:

RE: [KCFusion] CF MX and ODBC datasource with decode stmt

2003-10-01 Thread Minor, Beth
, October 01, 2003 4:05 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt We use decode on ORACLE quite often and haven't had any problems since moving to MX. Can you post an example query? What version of ORACLE? Jeff -Original

RE: [KCFusion] CF MX and ODBC datasource with decode stmt

2003-10-01 Thread Minor, Beth
to help some at the time. Beth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:30 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt Beth, You might try using

RE: [KCFusion] CFDirectory MUCH slower in CFMX, any way to speed it up?

2003-09-29 Thread Jeff Young
Title: Message I'd be willing to bet OS considerations and disk drive speed can affect that call as well. Also, as a programmer who has used the APIs, a multiprocessor system doesn't always help. It can sometimes hinder. Especially Intel's HyperThreading. You could get a caching RAID card

Re: [KCFusion] CFLOOP Issue

2003-09-25 Thread Adaryl Wakefield
Umm..maybe im not quite getting something in your questionbut..your cfoutput is outside the loop tags. Since that is the case then headlinePerSection keeps getting reassigned a new value each loop 4 then 5 then 6. Why not put an array in the loop so you could store the value each

RE: [KCFusion] CFLOOP Issue

2003-09-25 Thread Jim T Pickering
that works. Thanks Adaryl From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adaryl Wakefield Sent: Thursday, September 25, 2003 8:27 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] CFLOOP Issue Umm..maybe im not quite getting something in your questionbut..your cfoutput

RE: [KCFusion] CFLOOP Issue

2003-09-25 Thread Jim T Pickering
said..just a differnt(and probaly longer) way of doing it. A. - Original Message - From: Jim T Pickering To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 9:09 PM Subject: RE: [KCFusion] CFLOOP Issue Uh, I just moved the /cfloop tag below

Re: [KCFusion] Meeting Announcement - Hal Helms - Wednesday the 24th

2003-09-18 Thread Katsuey
At 12:57 AM 9/18/2003, you wrote: Coming next Wednesday, September 24th at 6pm... Hal Helms (www.halhelms.com)! Can you better describe the audience that would most benefit? Would a absolute newbie or someone who was thinking of using CF really benefit? Would hard core CF programmers benefit?

Re: [KCFusion] Target audience - next CF meeting

2003-09-18 Thread Katsuey
At 10:53 AM 9/18/2003, you wrote: For those of you new to the list and new to ColdFusion, I can put on an intro to CF meeting for either this user group, or more likely the MMUG sometime in the next few months if there is a demand. I'm just beyond here is a web server and here is how you

RE: [KCFusion] Potential meeting, Wed, Sept 24

2003-09-16 Thread Bruce Dunwiddie
This might possibly be a silly question, but who is Hal Helms? What would the topic be? Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday,

RE: [KCFusion] Job Opportunity

2003-09-16 Thread Justin Hansen
Ryan asked me to repost as text only ... There is a position or two open in my office. Please do not contact me directly regarding this position. If you are interested, please follow company protocol and fax in your resume. Thank you, Justin Hansen

RE: [KCFusion] Job Opportunity

2003-09-16 Thread Justin Hansen
Ryan asked me to repost as text only ... There is a position or two open in my office. Please do not contact me directly regarding this position. If you are interested, please follow company protocol and fax in your resume. Thank you, Justin Hansen

Re: [KCFusion] web server trouble shooting (OT)

2003-09-16 Thread Adaryl Wakefield
PROTECTED] Sent: Tuesday, September 16, 2003 3:06 PM Subject: RE: [KCFusion] web server trouble shooting (OT) Almost sounds like a DNS problem or a localized internet routing problem. Did you by chance ping your server or do a tracert to it? What did you do to "coax&quo

Re: [KCFusion] web server trouble shooting (OT)

2003-09-16 Thread Adaryl Wakefield
a problem. Adaryl WakefieldAviator by passionProgrammer by sheer force of will - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 3:06 PM Subject: RE: [KCFusion] web server trouble shooting (OT) Almost sounds like

RE: [KCFusion] web server trouble shooting (OT)

2003-09-16 Thread cfhelp
ipconfig /flushdns This could happen If your LapTop was on a local network that also hosted the site and used an internal DNS server. When you moved the laptop to another network it still has the old Resolver Cache. After so many attempts the Resolver Cache checks for a new version

RE: [KCFusion] Potential meeting, Wed, Sept 24

2003-09-15 Thread Jim T Pickering
Did you contact Mike Faulkner to see about Centriq? I bet you'd get a bigger turnout if you had the meeting in OP. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:22 PM To: [EMAIL PROTECTED] Subject:

RE: [KCFusion] CFFILE on MAC

2003-09-12 Thread Bruce Dunwiddie
For some odd reason, I don't know that I've run into that problem, and I don't currently have the resources to play and test with it, but I've got a few wacky ideas for you to play with. First, are you supplying any values for the accept attribute for CFFILE? If so, what? If not, have you tried

RE: [KCFusion] CFFILE on MAC

2003-09-12 Thread cfhelp
Rick -Original Message- From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:14 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC For some odd reason, I don't know that I've run into that problem, and I don't currently have the resources to play

RE: [KCFusion] CFFILE on MAC

2003-09-12 Thread cfhelp
: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC Yes, you would be able to upload any file in that case, but the question then comes down to, what is it that you're trying to block out and why? Obviously

RE: [KCFusion] CFFILE on MAC

2003-09-12 Thread Jim T Pickering
Message- From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC Yes, you would be able to upload any file in that case, but the question then comes down to, what is it that you're trying to block out

RE: [KCFusion] CFFILE on MAC

2003-09-12 Thread cfhelp
of users. Thanks for all the input. Oh, I am trimming the field. Rick -Original Message- From: Jim T Pickering [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:23 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFFILE on MAC Been reading the e-mail traffic

RE: [KCFusion] Need CF Studio 4.5 - help!

2003-09-05 Thread Ron Hornbaker
A kind soul helped me already - problem solved! :) -Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron Hornbaker Sent: Friday, September 05, 2003 2:28 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Need CF Studio 4.5 - help! Hi Everyone, Minor

RE: [KCFusion] OP is AT capacity

2003-09-03 Thread Johnny Sewell
Hi Ryan, If it will help I can attend the UMKC location. Johnny -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 1:37 PM To: [EMAIL PROTECTED] Subject: [KCFusion] OP is AT capacity Be

RE: [KCFusion] OP is AT capacity

2003-09-03 Thread Katsuey
At 03:32 PM 9/3/2003 -0500, you wrote: Hi Ryan, If it will help I can attend the UMKC location. Johnny Then how am I to meet you? (-: Peggie Brown ((( ¸.-···- ^~~ ^ ( {ªYª} \ )_ `~-~/´ \,,/,,/ \,,,Í,,Í Brown Holdings LLC Group

RE: [KCFusion] OP is AT capacity

2003-09-03 Thread Johnny Sewell
stuff that we have been working on. His office is in an office complex at about 132nd and Old Metcalf. Johnny -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Katsuey Sent: Wednesday, September 03, 2003 4:05 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OP

RE: [KCFusion] OP is AT capacity

2003-09-03 Thread Katsuey
At 09:32 PM 9/3/2003 -0500, you wrote: Hi Peggie, Well foot, I did not realize you were going to be at Corporate Woods! Oh well, I was just trying to help out. Me too. I'd offered to go to UMKC but Ryan said they still had room at OP. We did have a couple of empty chairs - but not many. Let me

RE: [KCFusion] Wednesday Meeting - 2nd location available, in Overland Park!

2003-09-02 Thread bnnwabu
I'll attend at the Overland Park location. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:20 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Wednesday Meeting - 2nd location available, in Overland Park! Due to popular demand, we are

Re: [KCFusion] Wednesday Meeting - 2nd location available, in Overland Park!

2003-08-29 Thread Girish_Kshirsagar
Ryan, I will be attending the Overland Park location. Thanks, Girish

RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park!

2003-08-29 Thread Fatino, Henry K [ITS]
SECOND THAT -Original Message- From: Glenn Crocker [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:26 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park! Okay, the RSVP emails have officially gotten annoying. Can

RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park!

2003-08-29 Thread Bruce Dunwiddie
Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Fatino, Henry K [ITS] Sent: Friday, August 29, 2003 1:37 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Wednesday Meeting - 2nd

RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park!

2003-08-29 Thread Kory Bakken
to this list. If you really don't want all the emails, you can go to the web log of this list. -Original Message- From: Fatino, Henry K [ITS] [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 2:37 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Wednesday Meeting - 2nd location

RE: [KCFusion] OT: Desktop automation text transfer

2003-08-27 Thread Ellis, Randy
Try using VBA in Excel, Word, or possibly Outlook. Excel Macro example: Sub GetEmails() Dim myApp As New Outlook.Application Dim myNS As NameSpace Dim myFolder As MAPIFolder Dim myItems As Items Dim intLoopCounter As Integer, Idx As Integer Set myNS =

RE: [KCFusion] OT: Desktop automation text transfer

2003-08-27 Thread Keith Purtell
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ellis, Randy Sent: Wednesday, August 27, 2003 8:19 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] OT: Desktop automation text transfer Try using VBA in Excel, Word, or possibly Outlook. Excel Macro example: Sub GetEmails

Re: [KCFusion] Please RSVP for the Wednesday, Sept 3 meeting

2003-08-27 Thread Girish_Kshirsagar
I am planning to attend, Girish

RE: [KCFusion] Studio MX 2004 See It - Win It!

2003-08-27 Thread Hale, Frederick L, WCS
I haven't attended any of the meetings yet but I will try to may this one if you don't mind. Frederick Hale R.O.A.M. Support *Phone: 816-391-7745 * Fax: 816-391-5027 *E-Mail: [EMAIL PROTECTED] -Original Message- From: Ryan Hartwich

RE: [KCFusion] XML error handling

2003-08-26 Thread Bruce Dunwiddie
This should work for you or atleast give you the general idea of how to handle the error. cfhttp url=http://someurl.com; method=Get resolveurl=YES/cfhttp cftry cfset resultcontent = XmlParse(cfhttp.fileContent) cfcatch type=Any !--- Do something else---

RE: [KCFusion] Help please

2003-08-22 Thread jabrown
AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Help please can you be more specific? where on the serverdid you store the CFCs? if you used a cf mapped directory make sure you add the mapping to the testing server. justin -Original Message-From: [EMAIL

RE: [KCFusion] Help please

2003-08-15 Thread Justin Hansen
can you be more specific? where on the serverdid you store the CFCs? if you used a cf mapped directory make sure you add the mapping to the testing server. justin -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 10:56 AMTo:

Re: [KCFusion] Weird problem

2003-08-14 Thread Bradley Miller
Actually -- just asked this question on the DevMX list and got a fast response: To: [EMAIL PROTECTED] From: Todd [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: multipart/alternative; boundary==_61532312==.ALT Subject: Re: [mxdev]

Re: [KCFusion] security question

2003-08-14 Thread Adaryl Wakefield
- From: Luke Templin To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:05 AM Subject: RE: [KCFusion] security question You may want to do everything through a stored procedure(s). As part of that stored procedure you could create multiple sql queries one of which

Re: [KCFusion] security question

2003-08-14 Thread Adaryl Wakefield
is kinda lame too. the best I've got so far is that the user can only delete those tuples that are related to their login. A. - Original Message - From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:33 AM Subject: RE: [KCFusion] security

RE: [KCFusion] security question

2003-08-14 Thread Kory Bakken
]Subject: RE: [KCFusion] security question I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl

RE: [KCFusion] security question

2003-08-14 Thread Bruce Dunwiddie
:54 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] security question Adaryl: Yes, if a person has IEBoster (http:// www.paessler.com/IEB http://www.paessler.com/IEB ) running on their machine, hidden form fields are just a right-click away. You'd be better off putting a ACTIVE field in any

RE: [KCFusion] security question

2003-08-14 Thread Bruce Dunwiddie
I don't know of a way to say make IE send different request headers, but if you're trying to test something, wouldn't cfpost work? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 1:44 PMTo:

RE: [KCFusion] security question

2003-08-14 Thread Luke Templin
with it but given your description that might be a method to investigate. -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:54 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Oh and just to elemenate confusion Im

RE: [KCFusion] security question

2003-08-14 Thread Kory Bakken
, then you could manually review the deletes before committing any of them. That's my 2 cents. Kory -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:48 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question

Re: [KCFusion] security question

2003-08-14 Thread Adaryl Wakefield
Oh and just to elemenate confusion Im trying to come up with a SAFE method..not a save method. A. - Original Message - From: Adaryl Wakefield To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:48 AM Subject: Re: [KCFusion] security question Im sorry

RE: [KCFusion] security question

2003-08-14 Thread Bruce Dunwiddie
them. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl WakefieldSent: Tuesday, August 12, 2003 10:24 AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] security question Ok wait. I have not thought this all the way though I think

Re: [KCFusion] security question

2003-08-14 Thread Adaryl Wakefield
. A. - Original Message - From: Kory Bakken To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:54 AM Subject: RE: [KCFusion] security question Adaryl: Yes,if a person has IEBoster (http://www.paessler.com/IEB)running on their machine, hidden form

Re: [KCFusion] security question

2003-08-12 Thread Adaryl Wakefield
/a Totally breaks my code. A. - Original Message - From: Bruce Dunwiddie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:57 AM Subject: RE: [KCFusion] security question Well the checking in the database to make sure that the user is allowed to delete that record

RE: [KCFusion] Worldwide User Group Meeting - September 3

2003-08-09 Thread Ryan Hartwich
:[EMAIL PROTECTED] On Behalf Of Johnny Sewell Sent: Friday, August 08, 2003 6:32 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Worldwide User Group Meeting - September 3 Ryan, Since I don't see anything about it on the User Group page of Devnet I wondered about what they are going to discuss

RE: [KCFusion] Worldwide User Group Meeting - September 3

2003-08-08 Thread Johnny Sewell
Ryan, Since I don't see anything about it on the User Group page of Devnet I wondered about what they are going to discuss. Will it be Breeze or the 6.1 release of CF or something else? Johnny -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan

RE: [KCFusion] ColdFusion File Security

2003-08-04 Thread Kory Bakken
Bruce: I am just guessing, but is it maybe that the files that you need to protect are the *.class files that MX produces and not the *.cfm files? Kory Bakken -Original Message- From: Bruce Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 8:11 PM To: [EMAIL PROTECTED]

RE: [KCFusion] DateDiff in SQL Query

2003-08-04 Thread Kory Bakken
You cannot treat CustomerEnrollmentDateas a CF Variable until you are outside of that query. The following where clause should get you what you need: WHERE CustomerRefer = #Affiliate_ID#AND CustomerEnrollmentDate between '#DateAdd('d',-7,createODBCDate(now()))#' and

Re: [KCFusion] DateDiff in SQL Query

2003-08-04 Thread Robert
To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 8:10 AM Subject: RE: [KCFusion] DateDiff in SQL Query You cannot treat CustomerEnrollmentDateas a CF Variable until you are outside of that query. The following where clause should get you what you need: WHERE

Re: [KCFusion] DateDiff in SQL Query

2003-08-01 Thread Adaryl Wakefield
Well all my reference books are at work and as it is firday night and im on my way out the door to go party just taking a quick glance at it but (and I may just be missing a piece of the puzzle here) but since you are selecting out CustomerEnrollementDate in the query don't you have to

RE: [KCFusion]

2003-07-30 Thread Matt Jones
cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR" null="Yes" -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:40 AMTo: [EMAIL PROTECTED]Subject: [KCFusion] I have need to update a table and set a value to NULL like

RE: [KCFusion]

2003-07-30 Thread Kory Bakken
If you do not use stored procedures, you could do this: UPDATE blah SET thisAttribute =cfif isdefined('var')#var#cfelseNULL/cfif WHERE someStuff = someOtherStuff The problem you had is that it reads: cfset var = "" as and empty string and cfset var = "NULL" as the actual string

Re: [KCFusion]

2003-07-30 Thread Adaryl Wakefield
2003 10:49 AM Subject: RE: [KCFusion] If you do not use stored procedures, you could do this: UPDATE blah SET thisAttribute =cfif isdefined('var')#var#cfelseNULL/cfif WHERE someStuff = someOtherStuff The problem you had is that it reads: cfset var = "

Re: [KCFusion] No CFUG meeting for July

2003-07-29 Thread Katsuey
At 05:04 PM 7/25/2003 -0500, you wrote: I am always looking for someone to present at a meeting. I am more than willing to assist you in preparing the content (technically as well as presentation skills). This is not rocket science, anyone can do it! Please, volunteer. Presenting helps you

Re: [KCFusion] ColdFusion Query Times Out

2003-07-23 Thread Adaryl Wakefield
Mind if we see the query? A. - Original Message - From: Bruce Phillips To: Sent: Wednesday, July 23, 2003 11:25 AM Subject: [KCFusion] ColdFusion Query Times Out I have a complex query on a template that times out every time after about 25 seconds.

Re: [KCFusion] ColdFusion Query Times Out

2003-07-23 Thread Bruce Phillips
Here is the query. I'm able to run this successfully on my ColdFusion Development Server, just not on my web host's ColdFusion Server. cfquery datasource="#dsn#" name="GetSubmissions" timeout="260"select submissions.*, presenters.*, categories.catname_display,

RE: [KCFusion] ColdFusion Query Times Out

2003-07-23 Thread bnnwabu
You do realize the timeout attribute is in milliseconds? You are telling it to timeout after 260 milliseconds. -Original Message- From: Bruce Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:59 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] ColdFusion

RE: [KCFusion] Updater 3

2003-07-23 Thread jabrown
Thanks. Its not looking like a problem with the Oracle setup. The same thing is occurring in Java. Jeff -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:35 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Updater 3 Jeff, I

RE: [KCFusion] ColdFusion Query Times Out

2003-07-23 Thread jabrown
of the time needed? -Original Message-From: Bruce Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 1:13 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] ColdFusion Query Times Out TIMEOUT attribute in MX is now in seconds and not milliseconds as in CF 5

RE: [KCFusion] Updater 3

2003-07-22 Thread Ryan Hartwich
Jeff, I was unsuccessful at installing Updater 3 on one machine, but I think it was a windows problem. I had no problems on 2 other machines, but these were running MS SQL 2000 and not Oracle. I have not heard of any significant problems with U3 and Oracle, though I haven't been watching for

RE: [KCFusion] Web Based Forums

2003-07-17 Thread Langmack,Lee
If you don't mind php, I think phpBB is one of the best things since sliced bread. Lee LangmackArt Director, Cerner Careers Cerner Corporation 2800 Rockcreek Parkway Kansas City, MO 64117 Direct Phone: 816.201.2698Fax: 816.571.2698 "Man is free at the moment he decides to be."~ Voltaire

RE: [KCFusion] CF5 online docs

2003-07-08 Thread Chad Waldo
Sounds like a projectfun, fun were do I sign up!

Re: [KCFusion] CF5 online docs

2003-07-07 Thread Bryan LaPlante
Thanks Matt. Ryan also emailed me the link to the pdf version of the docs. http://www.macromedia.com/support/coldfusion/documentation.html - Original Message - From: Matt Jones [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 07, 2003 8:59 AM Subject: RE: [KCFusion] CF5 online

Re: [KCFusion] CF5 online docs

2003-07-07 Thread ColdFusionKC
Bryan, Which charting products are you working with? Tom Huff In a message dated 7/7/03 9:01:45 AM Central Daylight Time, [EMAIL PROTECTED] writes: http://livedocs.macromedia.com/cf50docs/ -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003

Re: [KCFusion] CF5 online docs

2003-07-07 Thread Bryan LaPlante
07, 2003 4:38 PM Subject: Re: [KCFusion] CF5 online docs Bryan,Which charting products are you working with?Tom HuffIn a message dated 7/7/03 9:01:45 AM Central Daylight Time, [EMAIL PROTECTED] writes: http://livedocs.macromedia.com/cf50docs/-Original Message-From

RE: [KCFusion] CF5 online docs

2003-07-07 Thread Matt Jones
http://livedocs.macromedia.com/cf50docs/ -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:02 AM To: KCFusion Subject: [KCFusion] CF5 online docs If someone has CF5 installed on a dev machine would you be so kind as to pull up the docs and

Re: [KCFusion] OT: changing IP address in IIS4

2003-06-25 Thread Ramsey Abu-Absi
I think the only reason to use the script is if you have so many virtual sites running on the existing IP that making the changes in the administrative interface would take too long. Ramsey At 02:03 PM 6/25/2003, you wrote: Off topic: We're planning to put a more powerful firewall between a

RE: [KCFusion] an easy one

2003-06-24 Thread Luke Templin
TECTED]Sent: Tuesday, June 24, 2003 12:18 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] an easy one also... SELECT DISTINCT table1.studentID, table2.goalID FROM table1, table2 WHERE table1.studentID = table2.studentID the distinct behavior... I believe t

RE: [KCFusion] an easy one

2003-06-24 Thread Girish_Kshirsagar
BY LastName, FirstName; Hope that helps, Girish Boles, Mark E [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/24/2003 12:17 AM Please respond to CF-List To:[EMAIL PROTECTED] cc: Subject:RE: [KCFusion] an easy one also... SELECT DISTINCT table1.studentID

RE: [KCFusion] an easy one

2003-06-24 Thread Girish_Kshirsagar
by: [EMAIL PROTECTED] 06/24/2003 09:00 AM Please respond to CF-List To:[EMAIL PROTECTED] cc: Subject:RE: [KCFusion] an easy one Adaryl, Mark has given you pretty good clarification (although DISTINCT in conjunction with GROUP BY can be used and won't give you error

Re: [KCFusion] Quotation Marks in Form Field Value

2003-06-24 Thread Ramsey Abu-Absi
Hi Bruce, I would try (not sure if it will work, but it's an easy change to make) is to use the URLEncodedValue function on the field that potentially contains quotes. It should replace the quotes with the hex sequence: value=#URLEncodedValue(form.CATPurpose)# Hope that helps, Ramsey At 02:28 PM

RE: [KCFusion] an easy one

2003-06-23 Thread TKelley
SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy one Its been so long since ive done this i forgot how. In an sql statement i want only unique values of a field. I

RE: [KCFusion] an easy one

2003-06-23 Thread Hale, Frederick L, NSPM
Try DISTINCT instead of Unique Frederick Hale R.O.A.M. Support *Phone: 816-391-7745 * Fax: 816-391-5027 *E-Mail: [EMAIL PROTECTED] -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To:

Re: [KCFusion] an easy one

2003-06-23 Thread Adaryl Wakefield
PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:31 PM Subject: RE: [KCFusion] an easy one SELECT DISTINCT id -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: [KCFusion] an easy one

RE: [KCFusion] an easy one

2003-06-23 Thread TKelley
Are the studentID and goalID unique when combined? -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:55 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Tried that still got a funny record set. Here is a simplifaction

RE: [KCFusion] an easy one

2003-06-23 Thread Justin Hansen
-4273 Office 913-568-7961 Mobile ~~ -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 3:55 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] an easy one Tried that still got a funny record set. Here is a simplifaction

Re: [KCFusion] an easy one

2003-06-23 Thread Adaryl Wakefield
Girish do you have a real world example of the proper usage of the group by clause? My book is real weak on this subject. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 5:00 PM Subject: RE: [KCFusion] an easy one

RE: [KCFusion] an easy one

2003-06-23 Thread Boles, Mark E
an error like... _expression_ not a grouped _expression_ or something real helpful like that.. (sarcasm) Enjoy, -MEB -Original Message-From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]Sent: Monday, June 23, 2003 5:46 PMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] an easy one Girish do

RE: [KCFusion] OT: CSS problem with A HREF

2003-06-19 Thread Keith Purtell
. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Luke Templin Sent: Thursday, June 19, 2003 10:14 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF Here's a longshot experiment. Make sure the doctype has the full reference

RE: [KCFusion] Version Control Evaluation

2003-06-18 Thread Boles, Mark E
Title: RE: [KCFusion] Version Control Evaluation I am not sure what you mean by integrate with CFStudio. I am not sure if CFStudio has plugins to in effect have CSV a part of or extended feature for use in CFStudio. I do know there was such integration for other development tools

RE: [KCFusion] Version Control Evaluation

2003-06-18 Thread Glenn Crocker
Title: RE: [KCFusion] Version Control Evaluation It doesn't seamlessly integrate with CF Studio (or with DW MX, to my knowledge). It just manages the files externally using a separate check-in/check-out application. CVS doesn't use a file locking model. Instead, it does a very very good

RE: [KCFusion] Version Control Evaluation

2003-06-18 Thread Kory Bakken
Title: RE: [KCFusion] Version Control Evaluation From what I understood from the CVS documentation, each developer would check out a version of their site before development began. I assume this would mean that each developer would have to havea web server,CF server, andaccess to each

RE: [KCFusion] Version Control Evaluation

2003-06-18 Thread Glenn Crocker
Title: RE: [KCFusion] Version Control Evaluation I always check in at least once a week, usually daily. For long-term development (like converting a site from access to sql server), CVS supports "branching" so I can check in without impacting the main trunk (until the "b

RE: [KCFusion] OT: CSS problem with A HREF

2003-06-18 Thread Chad Waldo
I'd say that's an IE6 bug only, IE5.5 works fine as well as Opera 6 and 7. I also tested it on Navigator 6 and it worked great. My advise for everyone would be to stay away from IE6 as long as you can. Like Windows Media Player 9, you either can not back up, or its a pain in the ass to do

Re: [KCFusion] OT: CSS problem with A HREF

2003-06-18 Thread Bryan LaPlante
you did link and hover but you forgot visited A.row6:VISITED - Original Message - From: Keith Purtell To: KCFusion (E-mail) Sent: Wednesday, June 18, 2003 4:23 PM Subject: [KCFusion] OT: CSS problem with A HREF I've encountered an odd CSS bug that doesn't

RE: [KCFusion] OT: CSS problem with A HREF

2003-06-18 Thread Keith Purtell
, 2003 4:36 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] OT: CSS problem with A HREF you did link and hover but you forgot visited A.row6:VISITED - Original Message - From: Keith Purtell To: KCFusion (E-mail) Sent: Wednesday, June 18, 2003 4:23 PM Subject: [KCFusion

RE: [KCFusion] OT: CSS problem with A HREF

2003-06-18 Thread Luke Templin
PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF In my real version it includes visited. I just wanted to trim the sample for your viewing. Chad, thanks for checking it in other browsers. I very much appreciate that. I will create a workaround, since I have many users on IE6. Possibly

RE: [KCFusion] OT: CSS problem with A HREF

2003-06-18 Thread Keith Purtell
by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Luke Templin Sent: Wednesday, June 18, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] OT: CSS problem with A HREF In my version

  1   2   3   4   5   6   7   8   9   10   >