Trouble with CF 9 Spreadsheet functions

2012-11-27 Thread Dave Phillips
Hi, I'm going nuts trying to retrieve VALUES out of an Excel 2007 workbook with ColdFusion 9. What's happening is that I'm getting the 'formulas' instead of the 'values'. The formulas are 'cross sheet' formulas (meaning they refer to another sheet in the same workbook). I'm assuming this h

Excel 2003/2007 Recalculating Interaction

2012-05-22 Thread Dave Phillips
;recalculate' in the Excel 2007 file when I have it open in CF? Or is there some other solution someone has an idea for? Thanks! Dave Phillips ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Ado

Challenge

2012-01-17 Thread Dave Phillips
seems like Adobe left this 'feature' out of the exchange features, which may be true, but I'm convinced there has to be a way to set it. Let me know your thoughts. Thanks, Dave Phillips ~| Order the Adobe Col

Fwd: Re: [DFW CFUG] cfexchangecalendar busyStatus property

2012-01-14 Thread Dave Phillips
Anyone know how to expose the underlying Java objects of the Exchange variety? -- Forwarded message -- From: "Dave Phillips" Date: Jan 12, 2012 5:22 PM Subject: Re: [DFW CFUG] cfexchangecalendar busyStatus property To: I'd like to try that but not sure how I find

cfexchangecalendar busyStatus property

2012-01-11 Thread Dave Phillips
Hi all, I tried to send this through a few hours ago, but it hasn't gone through and other messages have, so I'm not sure why. Anyways, if it ends up here twice, please forgive the dual posting. I am trying to set the busyStatus property of an appointment with cfexchangecalendar (the 'Show A

RE: problem with a condition cfif in a cfquery

2010-03-03 Thread Dave Phillips
l be null. If you want another default value such as 'N/A', then you would just wrap it all with another function like this: SELECT isNull(isNull(emailaddr1,emailaddr2),'N/A') as emailaddr Hope this helps! Dave Phillips -Original Message- From: alex poyaoan [mailt

RE: problems querying date in access 2007

2010-03-03 Thread Dave Phillips
Just use this: WHERE expenseDate > Then you don't have to worry about the format and it's also not DB dependent code. Dave Phillips -Original Message- From: GLM [mailto:g...@glmdesigns.com] Sent: Wednesday, March 03, 2010 7:14 AM To: cf-talk Subject: RE: problems que

RE: CFIF within CFmail?

2010-02-22 Thread Dave Phillips
Oops, I spoke too soon. That's what I get for NOT reading all the code. You can do this if you want to do it INLINE: Dave Phillips -Original Message- From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] Sent: Monday, February 22, 2010 9:23 AM To: 'cf-talk@houseof

RE: CFIF within CFmail?

2010-02-22 Thread Dave Phillips
Actually, that's not true. You can easily put CFIF inside of your cfmail tag. I've done it for 12+ years! Your only problem was that you used the equals sign (=) instead of EQ. This should work for you: cc="te...@test2.com" Subject="New Jersey"> -Original Message- From: I. Addoum. [m

RE: Total Two Field From Two Tables

2010-02-16 Thread Dave Phillips
Instead of this: (#NumberFormat(zip.fdcount)#) Use a QofQ (Query of Queries) - it will be faster: SELECT fdcount FROM zip WHERE zip.fdd_id = (#NumberFormat(qZipCheck.fdcount)#) This will avoid having to loop through your zip query for every time through your story loop. Also,

RE: Total Two Field From Two Tables

2010-02-15 Thread Dave Phillips
What didn't work with the second set of queries? Did you get an error message? That logic is sound. There might be some syntax issues as I didn't test it... Dave -Original Message- From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] Sent: Monday, February 15, 2010 10:28 PM To: cf-t

RE: Total Two Field From Two Tables

2010-02-15 Thread Dave Phillips
ode = #fdd_name# (#qGetThisZipCount.zip_count#) This is using query of queries so you don't have to hit the database twice. There are a number of ways to accomplish this. Dave Phillips ~| Want to reach the ColdFusion c

RE: How to query encrypted password

2010-01-06 Thread Dave Phillips
cally impossible to break algorithm that then locks down your data so hard that it can never be unlocked. Of course, the practical implications are limited. Dave Phillips (one who watches Numb3rs too much!) -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, Janua

RE: cftransaction

2009-12-11 Thread Dave Phillips
I'm pretty sure the rollback is not occurring because your cfstoredproc call inside your saveDataToDatabase() function is running in it's own transaction. I think you'd need to include a "rollback;" command inside your stored procedure if you have a failure. Dave -Original Message- From

RE: convert this cfscript back to tag?

2009-12-10 Thread Dave Phillips
Glyn, Hope this helps! Dave Phillips -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Thursday, December 10, 2009 8:43 AM To: cf-talk Subject: convert this cfscript back to tag? Hi all, could someone convert this cfscript back to tag

RE: \ColdFusion8\Mail\Spool

2009-12-08 Thread Dave Phillips
John, Anything revealing in your mail log? I've seen this behavior before, but not with CF 8. It was with older versions. We ended up scheduling a nightly restart of the service to alleviate things like this occurring. Dave Phillips -Original Message- From: John M

RE: CFLogout confusion

2009-11-10 Thread Dave Phillips
ed into affiliate2's site and vice versa. Dave Phillips -Original Message- From: Stefan Richter [mailto:ste...@flashcomguru.com] Sent: Tuesday, November 10, 2009 8:03 AM To: cf-talk Subject: CFLogout confusion I'm using cflogin and cflogout on my site. A user is logged int

RE: Session is invalid error is driving me nuts!

2009-11-04 Thread Dave Phillips
Oh, I meant to add that if you are using application.cfc instead of .cfm, then you would put your code to redirect in the OnSessionEnd function. Dave -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, November 04, 2009 1:02 PM To: cf-talk Sub

RE: Session is invalid error is driving me nuts!

2009-11-04 Thread Dave Phillips
options some may have here on the list as well. Dave Phillips -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, November 04, 2009 1:02 PM To: cf-talk Subject: Session is invalid error is driving me nuts! All, Ok, this is a little pet p

RE: Education

2009-10-24 Thread Dave Phillips
I can remember coding I did from more than 10 years ago, but I can't remember to pick up milk when I go to the grocery store for diapers (or vice versa!). I suppose that' what 40 will do to you! BTW - to chime in on the whole education thread - I have a BA degree in Religion which, as you can te

RE: CF8, 64 bit, and Microsoft Access

2009-10-15 Thread Dave Phillips
If it's shared hosting, then you're probably out of luck because you are at their mercy. If you have a virtual server, however, then maybe you can try installing the access 32 bit odbc driver on your 64 bit system, and then use it through the ODBC Socket driver in ColdFusion.it's worth a try.

RE: Sorting 2d arrays

2009-10-15 Thread Dave Phillips
Now instead of looping through an array to do a match, you simply do a query of query: SELECT sql_id FROM qMySuggestions WHERE (put your condition here to find a match) qFindMatch.sql_id is the record you want. Dave Phi

RE: Browser not recognizing CFM tags

2009-10-13 Thread Dave Phillips
d with the .cfm files would actually be opening it. It might open 'in-line' in the browser, or externally in the associated program. I haven't attempted this, just trying to explain what may have gotten you those results in the past. Dave Phillips -Original Message- From: T

Upgrading from CF MX6.1 to 8 - Verity question....

2009-10-08 Thread Dave Phillips
long. Has anyone run into this and, if so, can it be explained? Is there possibly something wrong? Thanks! Dave Phillips ~| Want to reach the ColdFusion community with something they want? Let them know on the Hou

RE: modifying a query object

2009-10-07 Thread Dave Phillips
er is a definite option. ~Brad Original Message ---- Subject: RE: modifying a query object From: Dave Phillips Date: Wed, October 07, 2009 3:47 pm To: cf-talk Chad, I had to do this very same thing for cfindex. There is another alternative - look for a stored procedure code for your dat

RE: modifying a query object

2009-10-07 Thread Dave Phillips
Chad, I had to do this very same thing for cfindex. There is another alternative - look for a stored procedure code for your database server that strips HTML. If you can find one, you can transform it in the database before you get it. Dave -Original Message- From: b...@bradwood.com [

RE: ssl

2009-10-02 Thread Dave Phillips
it takes me to http://www.www.beeculture.com/ > > www. Should not be part of CGI.ServerName right? > > > > > -Original Message- > > From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] > > Sent: Friday, October 02, 2009 3:16 PM >

RE: ssl

2009-10-02 Thread Dave Phillips
be part of CGI.ServerName right? > -Original Message- > From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] > Sent: Friday, October 02, 2009 3:16 PM > To: cf-talk > Subject: RE: ssl > > > How about a client side redirect? > > > >

RE: ssl

2009-10-02 Thread Dave Phillips
site with ssl and it works fine. I know the certificate is good. https://www.beeculture.com/ This one has me stumped. > -Original Message- > From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] > Sent: Friday, October 02, 2009 2:58 PM > To: cf-talk > Subjec

RE: ssl

2009-10-02 Thread Dave Phillips
My guess is you don't have a valid security certificate on the server. If you have any cert installed, Firefox is first going to get that cert info from the web server before your request ever gets to ColdFusion. What you probably need to do is turn off the SSL on that site if you don't want peo

RE: GROUP BY problem...

2009-10-02 Thread Dave Phillips
Which database server are you using? Some allow you the ability to return an aggregate of values in the form of a comma delimited list. You might be able to get your result set to look like this: EMPID NAME OFFICES 1 DaveBoston (NE), Dallas (SW), Miami (SE) 2 JohnSan Di

RE: Code being truncated...

2009-09-02 Thread Dave Phillips
but specifically ColdFusion. Anyway, just wanted to pass along the solution for those searching for this quirky behavior in the future. Dave Phillips ~| Want to reach the ColdFusion community with something they want? Let the

Code being truncated...

2009-09-02 Thread Dave Phillips
ran it on a Windows MX 6.1 server and it works without a problem. 4. We've changed the filename to a .html extension and it loads just fine in the Linux environment without truncating any content. Any ideas what might be causing this? (and yes Brad, I know - I always get t

Code being truncated...

2009-09-02 Thread Dave Phillips
ran it on a Windows MX 6.1 server and it works without a problem. 4. We've changed the filename to a .html extension and it loads just fine in the Linux environment without truncating any content. Any ideas what might be causing this? (and yes Brad, I know - I always get t

Code being truncated...

2009-09-02 Thread Dave Phillips
ran it on a Windows MX 6.1 server and it works without a problem. 4. We've changed the filename to a .html extension and it loads just fine in the Linux environment without truncating any content. Any ideas what might be causing this? (and yes Brad, I know - I always get t

Code being truncated...

2009-09-02 Thread Dave Phillips
ran it on a Windows MX 6.1 server and it works without a problem. 4. We've changed the filename to a .html extension and it loads just fine in the Linux environment without truncating any content. Any ideas what might be causing this? (and yes Brad, I know - I always get t

RE: Using CFReport in a Websphere (linux) environment

2009-08-28 Thread Dave Phillips
o find it easily (if that is even a possibility). Any thoughts? I'm copying the DFW CFUG group on this so sorry for anyone who gets it twice. Oh, and yes, the environment is headless - it is a 'websphere server farm'. I'll copy Dave on this e-mail as well. Thanks! Dave Phil

Using CFReport in a Websphere (linux) environment

2009-08-27 Thread Dave Phillips
DF or type=FlashPaper and get it with both of them. I've confirmed that the report works fine on my local windows development machine, so there is nothing wrong with the report file or the CFM file. Thanks! Dave Phillips

RE: Regex Help - Can this be simplified?

2009-08-13 Thread Dave Phillips
oldFusion. But an alternate method should not be shot down as "not simplified" especially when the provider of the alternate method was just trying to help. Dave Phillips -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Thursday, August 13,

RE: Regex Help - Can this be simplified?

2009-08-13 Thread Dave Phillips
I'm not an expert with Regex, but you could do this: ","","all"),"","","all"),"","","all") > Again, this is not regex, but it is a much more simplified (and faster I believe) way of doing the same thing

RE: valueList not giving me what i want.. quick look

2009-08-11 Thread Dave Phillips
I think Francios meant something like this: select aid from getAce where title = aid: #valueList(qAids.aid)# That should give you your comma delimited list of only the aid values that match the current title in the grouping. Dave Phillips -Original

RE: Decipher CFLDAP date values

2009-07-31 Thread Dave Phillips
#x27;t know what the correct date/time stamp actually is: #dateFormat(iLogonTime," dd, ")# #timeFormat(iLogonTime,"hh:mm:ss")# Dave Phillips -Original Message- From: Wally Randall [mailto:wally.rand...@comcast.net] Sent: Friday, July 31, 2009 3:31 PM To: cf-t

Application.cfc question

2008-11-22 Thread Dave Phillips
Hi - I'm trying to use application.cfc on a new app I'm building and I'm having a strange occurrence. I'm sure it's just because I'm not as familiar with it as application.cfm, but I am trying to 'avoid' just switching back to application.cfm. Here's the issue: I have the following code. Whe

Re: Quick question on session issue (hopefully)

2008-11-15 Thread Dave Phillips
Well, that didn't help either. I moved it to another server and it works fine, so apparently my code is not the issue. I restarted ColdFusion and that didn't help the situation either. The bottom line is, my session variables aren't getting persisted, but only on this machine. Again, I've tr

Re: Quick question on session issue (hopefully)

2008-11-15 Thread Dave Phillips
Same application name. I even tried this: Instead of redirecting, I did the following in login_exec.cfm: Statistics When I got to this page, I could see my session.isAuthorized was set to false before the and true after it. Then, I clicked on the statistics link, and the on that page s

Re: Quick question on session issue (hopefully)

2008-11-15 Thread Dave Phillips
To answer both Brad and Dan: Brad: Yes, I have dumped the session and CFID, CFTOKEN and SESSION ID are all the same in both dumps. The dump in login_exec.cfm that shows session.isAuthorized value of true, and the dump in statistics.cfm that shows session.isAuthorized false, right after the cl

Quick question on session issue (hopefully)

2008-11-15 Thread Dave Phillips
Hey folks, I have a quick question (hopefully). Something weird is going on, and I can’t place it, and I’m feeling like I'm having a brain freeze…. This shouldn’t be an issue. I have a simple application in MX 7. Application.cfm has the following: I have an index.cfm with a simple

Adobe Certified ColdFusion Developer Directory

2008-11-03 Thread Dave Phillips
Hi all, Macromedia had a page on their site that allowed someone to verify that a person was a Certified ColdFusion MX 7 Developer or Advanced Certified ColdFusion MX 7 Developer. Does anyone know where this page can be found? I have not been able to located it on Adobe's website. ~

cfschedule action="run" .... asynchronous or not?

2008-10-03 Thread Dave Phillips
Hi all, I'm on CF8 - linux OS. Trying to find out why my tag is not running asynchronously. I was under the impression that it should execute the task and then continue on, not making the user wait. Am I wrong about this? Thanks! Dave ~

Re: (ot) How do you preload a SWF file?

2008-09-09 Thread Dave Phillips
Hey, i know I'm a week late in responding (I was on vacation, forgive me!), but I do have one more question about this: Are there any concerns around the additional load on the web server from having to load the swf file for every user, even those that may never actually launch the application?

RE: Wildcard characters in filepath?

2008-08-30 Thread Dave Phillips
Have you tried: /2008_0830_??/ ? That's how you would do it at the command line in windows anyway. Dave -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 10:56 AM To: CF-Talk Subject: Wildcard characters in filepath? How can I use

(ot) How do you preload a SWF file?

2008-08-29 Thread Dave Phillips
the app to load, then, when they click one of the links/graphics to launch the app, it will come up very quickly because it's already in the browser cache. 1) Can you confirm this is possible and 2) Do you have any sample code or a reference that I can use to go by? Th

RE: Here's an interesting little problem...

2008-08-26 Thread Dave Phillips
Because the column name will be represented by whatever the FIRST select is, and in this case, that is 'top_shooter_class'. Try this: select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con,

RE: Here's an interesting little problem...

2008-08-26 Thread Dave Phillips
Rick, What database are you using? One thought that comes to mind is to do TWO selects with a UNION and give each their own ORDER BY clause. Something like this: Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC UNION ALL Select . where class in ('A','AA','AAA') ORDER BY

RE: query of queries or something else

2008-08-23 Thread Dave Phillips
m sure you could get this all in one query instead of using QofQ (unless of course you're talking about different datasources, which it doesn't look like you are). Dave Phillips http://www.dave-phillips.com/ -Original Message- From: Andrew Whone [mailto:[EMAIL PROTECTED] Sent: S

RE: cflayout weird problem

2008-08-22 Thread Dave Phillips
BJ, Okay, not familiar with cf_betterselect, but the below should still work for you: Change your cfform tag to this: IN your area, add the following: function doSubmit() { var oForm = document.newEmpInsertForm; if(oForm.p_supervisor.selectedIndex == 0) { alert('must select a supervi

RE: cflayout weird problem

2008-08-22 Thread Dave Phillips
BJ, Post your form code (or a snippet) and what fields you're trying to validate and what you want validated and we can help. Also, check out the CF docs for CFFORM as it has a lot of built-in javascript validation that you can utilize through CF tags like CFINPUT and so on. Dave -Original

RE: cflayout weird problem

2008-08-22 Thread Dave Phillips
To my knowledge, this is a browser issue, not a cflayout issue, as you will get different results in different browsers. You can avoid this completely by using javascript to validate your fields. Dave -Original Message- From: BJ McShane [mailto:[EMAIL PROTECTED] Sent: Friday, August 22,

RE: Query Too Complex for Access?

2008-08-20 Thread Dave Phillips
David, I don't know if it will or not, you will just need to test. I'm sure there is some upper limit as to how many bytes you can send in a call to the DB, but I'm also betting that's driver dependent. Oh, if there is a possibility that getActiveWorks might be empty, you will want this: A

RE: Query Too Complex for Access?

2008-08-20 Thread Dave Phillips
Acutally, the first part is correct. The listQualify() function actually just places 'single quotes' around each of the values in your valuelist since that would be required by the DB. List qualify doesn't check any variables. I noticed you had a stray tag. Were you missing a condition as you

RE: Query Too Complex for Access?

2008-08-20 Thread Dave Phillips
Have you tried: AND Works.ThisInventory not in (#listQualify(valueList(getActiveWorks.ThisReference),"'")#) ?? Dave -Original Message- From: David Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2008 1:18 PM To: CF-Talk Subject: Query Too Complex for Access? I know I am s

RE: (ot) SQL question...

2008-08-19 Thread Dave Phillips
BY source ORDER BY source DESC Sincerely, Dave Phillips http://www.dave-phillips.com -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 9:11 AM To: CF-Talk Subject: (ot) SQL question... Hello all. I'm looking to output the total numb

RE: Web Service Issue , pls help

2008-08-19 Thread Dave Phillips
e describe in more detail exactly what you are trying to do with the data returned from the web service and post any code you may already be using. Sincerely, Dave Phillips -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 9:01 PM To: CF-Talk

RE: Accessing Session and Application variables from another app

2008-08-18 Thread Dave Phillips
Sorry Andy, I didn't read your whole message. It appears you already tried this. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 4:21 PM To: CF-Talk Subject: RE: Accessing Session and Application variables from another app Couldn&

RE: Accessing Session and Application variables from another app

2008-08-18 Thread Dave Phillips
Couldn't you create a CFC in your main app that will return a value of a variable, something like this: Expose the CFC to public and use from your 'child' app. You could also access it with if you would rather do that. Similar to your solution below, but more secure as it doesn't j

RE: Creating a database with repeated information

2008-08-18 Thread Dave Phillips
Melissa, I think I have a little better understanding of what you want now. You are talking about the initial 'records' in your database (before the user can modify them) right? So, what you could do is set up a few lines of code (maybe put in a cfinclude even) that will query to see if that 'st

RE: Creating a database with repeated information

2008-08-18 Thread Dave Phillips
Melissa, This is exactly what ColdFusion is designed to do. You will have ten separate ".cfm" files and each of the files represents one of your 10 pages. Whatever information is 'static' for each page (in other words, whatever information stays the same for every state) can be hardcoded into the

RE: Announcement: CF8 Exam Buster released for ColdFusion 8 certification

2008-08-16 Thread Dave Phillips
eloper certification. It's a great program! Thanks Brian Sincerely, Dave Phillips My new blog: http://www.dave-phillips.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date G

RE: cfform validation for newbie

2008-08-14 Thread Dave Phillips
Sorry, I thought the field was required. Try this: if(oForm.discode.value.length > 0 && !(oForm.discount.value == 'xyz123' || oForm.discount.value == 'abc1234')) { This says if they enter a value, and that value is NOT 'xyz123' or 'abc1234', then display the error. If they don't enter a value,

RE: Outputting columned UL tags

2008-08-14 Thread Dave Phillips
n answer to the question can be very disappointing to a developer who has already banged their head against the wall for several minutes, hours or days before making themselves vulnerable by asking a question in an open forum like this. They sure don't need sarcastic remarks and/or time wa

RE: javascript question

2008-08-14 Thread Dave Phillips
other browsers. Hope this helps! Sincerely, Dave Phillips http://www.dave-phillips.com -Original Message- From: BJ McShane [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2008 10:25 AM To: CF-Talk Subject: javascript question I built a form for my users where they enter IP addr

RE: cfform validation for newbie

2008-08-14 Thread Dave Phillips
Christine, I believe you will need to do some custom javascript validation for this (someone who has used cfform a lot can surely suggest otherwise). Here's how you could do it: Add the following to cfform tag 'onsubmit="return doSubmit();" Then, inside your tags, add the following: vunction

RE: Outputting columned UL tags

2008-08-13 Thread Dave Phillips
Andy, Check out Ben Nadel's blog entry from March last year: http://tinyurl.com/5tjcmf Sincerely, Dave Phillips http://www.dave-phillips.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 2:54 PM To: CF-Talk Subject: Outpu

RE: cfarguments... determining which argument to use based on passed variables

2008-08-13 Thread Dave Phillips
Scott, Although it is not well-formed ColdFusion, you could leave off the tags altogether. They are not required. Then do whatever logic you want #arguments[1]# #arguments[2]# You will see a dump of a structure with two keys, and

RE: cfarguments... determining which argument to use based on passed variables

2008-08-13 Thread Dave Phillips
Scott, Is your 'list' a list of person id's ? Dave -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 9:19 AM To: CF-Talk Subject: cfarguments... determining which argument to use based on passed variables Sorry for the cryptic subject In

RE: Submit ASP form using CFHTTP

2008-08-12 Thread Dave Phillips
They might be setting some cookies initially and also a session id of sorts. What you may need to do is hit their 'form' page once and capture the cookies (just dump the cfhttp scope after an initial hit and you can find them there - I think http-cookie scope, not sure). Then you will need to incl

RE: Redirection old ID values to new ID values

2008-08-11 Thread Dave Phillips
Paul, Can you change the old code? If so, you could just add something like the following to the top of each of the pages that use the ID's: (I don't know ASP syntax, but I think you will get the picture) asp code to access your new data source... SELECT new_id from new_table where old_id =

RE: Using CFLoop to Define Variables

2008-08-11 Thread Dave Phillips
> From http://www.cfquickdocs.com/?getDoc=SetVariable#SetVariable: > >Description >This function is no longer required in well-formed ColdFusion pages. Well, that's good news. So all it comes down to then is preference. Although I do second Yuliang's comment that using an array might be better d

RE: Using CFLoop to Define Variables

2008-08-11 Thread Dave Phillips
ble() with a concatenated variable name, I prefer to use the first method I indicated above. However, I can't confirm this performance issue, although maybe someone else on the list has done some performance testing with 'evaluations' and can comment on that. Dave Phillips

RE: select problem

2008-08-11 Thread Dave Phillips
Have you looked at your 'view source' code to see if 'selected' is every being generated? Are there any records in your table that have an empty cty_iso2 column? Dave -Original Message- From: Eclectic User [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 1:07 PM To: CF-Talk Subj

RE: Installation of CF 8 (developer edition) is not working

2008-08-07 Thread Dave Phillips
>>Is there a better source to download from? No. Delete the download you have (permanently) and then download it again. Maybe even to a different location to be safe. Then check the size/md5 hash to be sure you have a good download. Dave ~~

RE: Installation of CF 8 (developer edition) is not working

2008-08-07 Thread Dave Phillips
hen, if you can confirm you have a good download, go ahead and uninstall. Then remove all the coldfusion directories. I don't know if it's just c:\ColdFusion8 or not, maybe someone more familiar with 8 could pipe up on that one. There might be some registry entries to remove as well.

RE: Installation of CF 8 (developer edition) is not working

2008-08-07 Thread Dave Phillips
Tgirl, When you tried re-install, did you first 'uninstall' CF, and then remove all existing CF directories so that you were doing a 'fresh' install? Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic re

RE: CFQueryparam and NULLs.

2008-08-07 Thread Dave Phillips
I always use: null="#NOT len(trim(form.whatever))#" as that catches everything. Dave -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2008 9:55 AM To: CF-Talk Subject: RE: CFQueryparam and NULLs. If FORM.makeID is either zero or a number: Ma

RE: Multiple documents in a single

2008-08-05 Thread Dave Phillips
>"cfdocument site:livedocs.adobe.com/coldfusion/8/" And if you don't remember that syntax, just google: cfdocument 8 By adding the 8, it will generally get you the version 8 results (you can do the same for 7 usually, 6 & 6.1, sometimes and 5 rarely) :) Sin

Deleting Session on Browser Close

2008-08-05 Thread Dave Phillips
decision. ) Has anyone experienced this before? Here's the code I'm using (FYI - this same code works for an app hosted on a Windows box): Sincerely, Dave Phillips ~~~

SOT: Forms Generator

2008-08-05 Thread Dave Phillips
Anyone know of a quick way to generate some forms for several database tables? I'm using oracle, but that's not even a requirement at this point. Just looking for something to start with to save me some time. Preferably something "Open". Thanks! Sincerel

RE: Query of Queries

2008-08-05 Thread Dave Phillips
ger than you need to be. Sorry I can't be of more help! Sincerely, Dave Phillips -Original Message- From: heath stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 8:55 AM To: CF-Talk Subject: Re: Query of Queries Thanks Dave, I actually did this out side of the cur

RE: Query of Queries

2008-08-05 Thread Dave Phillips
Heath, Can you run the following in a test.cfm file on your server (OUTSIDE OF YOUR EXISTING APP): SELECT ID FROM WHATEVER (just use a simple query here) SELECT ID FROM qTest Just trying to narrow down the issue. Sincerely, Dave Phillips -Original Message- From: heath stein

RE: Installation of CF 8 (developer edition) is not working

2008-08-05 Thread Dave Phillips
Tgirl, I also just thought to ask are you on a VPN? When I'm on my VPN, I cannot access localhost as they have it locked down. I have to disconnect from VPN for it to work OR use my IP address as Scott is recommending below in #2. Dave -Original Message- From: [EMAIL PROTECTED] [mailto

RE: When is a struct not a struct ?

2008-08-05 Thread Dave Phillips
>>Hmm, so how can I reliably tell I'm holding a struct and not a CFC ? >>isStruct() and not isObject() ? I think you can tell when you are holding a struct and not a CFC like this: this is a struct this is an Object Since isObject() will only return true if it is an object, if you che

RE: how to access the query

2008-08-04 Thread Dave Phillips
Eclectic, You might get a better response posting this to a fusebox forum. I haven't used fusebox in years, but I'll take a stab. You said, " Now I am trying to display the results of qryUsers but qryUsers is not available there. I am creating an object but I don't know how to use it to access t

RE: Null/empty values from the database.

2008-08-04 Thread Dave Phillips
>> James Holmes said: Right - you are in a cfoutput loop and when there are no results in the query the variable "return" is never populated as the loop never runs. Ioannis, James is exactly right. Here's what you need: .. (I'm assuming Return is getting set to some other con

RE: Installation of CF 8 (developer edition) is not working

2008-08-04 Thread Dave Phillips
> I changed the port to 8300 and it still doesn't work Did you restart service after changing the port? Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.do

RE: cfswitch

2008-08-04 Thread Dave Phillips
Brian, Yes, I believe that is true and this is the circumstance where you must use CFIF/CFELSE/CFELSEIF. There's an article on this topic (cfswitch/cfif) at: http://blog.dasignz.com/blog/post/2008/07/CFSWITCH-Vs-CFIF.aspx (sadly posted on a .NET site though) Sincerely, Dave Phi

RE: Installation of CF 8 (developer edition) is not working

2008-08-04 Thread Dave Phillips
Hi, Here's something you can also do. Open the jrun.xml file located at: {Cfroot}\servers\cfusion\SERVER-INF\jrun.xml Look for a line with 'WebService' in it (mine is like this (but it's MX7): Scroll down to the attribute for "port" and see which port number it is. If it is one you have alre

RE: Installation of CF 8 (developer edition) is not working

2008-08-04 Thread Dave Phillips
Okay, check your 'services' panel to make sure the service is running. Also, at the risk of sounding 'help deskish', have you rebooted? :) Dave -Original Message- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2008 9:05 AM To: CF-Talk Subject: Re: Installation of C

RE: Installation of CF 8 (developer edition) is not working

2008-08-04 Thread Dave Phillips
tGirl, Are you browsing that link directly, or did you get to it from your Start -> Programs ... link for the administrator? If not, try that link and see what happens. It might be a different port. For instance, mine is http://localhost:8300/CFIDE/Administrator. Also, you didn't mention wheth

RE: When is a struct not a struct ?

2008-08-04 Thread Dave Phillips
>> From my understanding, I thought an object was a special kind of structure - a structure with processes (methods). On the other hand, it may look and act like an object, but it isn't one. The code below shows that you can create a structure that 'looks' like an object, (with what appears to be

RE: 2 questions: ensuring a file is only included once, and scrubbing form and url scopes

2008-08-01 Thread Dave Phillips
Pete: 1. You could check for the existence of a variable (or function) in the cfinclude, like this: 2. There are some custom tags/udfs out there for this, but I haven't used them. I'd check CFLIB.ORG, or maybe someone else here can recommend something specific. Dave -Original

  1   2   3   4   >