Re: Testing
Nope. I never received it Rick. On Mon, May 19, 2014 at 12:31 PM, Rick Faircloth r...@whitestonemedia.comwrote: Testing... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Testing
Thanks for the confirmation, Mike. I'll keep working on the solution to why you didn't receive it and I didn't receive your notice confirmation my message failure. :-D Rick On 5/18/2014 10:32 PM, Mike K wrote: Nope. I never received it Rick. On Mon, May 19, 2014 at 12:31 PM, Rick Faircloth r...@whitestonemedia.comwrote: Testing... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Testing
Appearances can be deceiving though. On Tue, Apr 5, 2011 at 3:59 PM, dB dbfu...@gmail.com wrote: It *appears* as though I've subscribed... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Testing
However in THIS case, it does seem to be true On Tue, Apr 5, 2011 at 1:05 PM, Michael Grant mgr...@modus.bz wrote: Appearances can be deceiving though. On Tue, Apr 5, 2011 at 3:59 PM, dB dbfu...@gmail.com wrote: It *appears* as though I've subscribed... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Testing for existence of Java library?
Not when someone asks a Java question and not a JavaScript question.
On Sat, Aug 16, 2008 at 12:21 PM, Andrew Scott
[EMAIL PROTECTED] wrote:
I don't know but maybe something like this
Try {
Var test = new Ext.GridPane();
} catch (e) {
// Library not found
}
I suppose you don't think like that?
--
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311087
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing for existence of Java library?
Pseudo code dude..
The solution is the same is it not?
--
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 9015 8628
Mobile: 0404 998 273
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Saturday, 16 August 2008 4:08 PM
To: CF-Talk
Subject: Re: Testing for existence of Java library?
Not when someone asks a Java question and not a JavaScript question.
On Sat, Aug 16, 2008 at 12:21 PM, Andrew Scott
[EMAIL PROTECTED] wrote:
I don't know but maybe something like this
Try {
Var test = new Ext.GridPane();
} catch (e) {
// Library not found
}
I suppose you don't think like that?
--
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311088
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Testing for existence of Java library?
On Fri, Aug 15, 2008 at 3:21 PM, Barney Boisvert wrote: You could attempt to load one of it's classes and catch the resulting exception if it's missing. Based on whether that exception is raised you'll know whether it's available. Yes, that sounds like a good way to do it. FWIW, when I've been utilizing java libraries that I may load through a classloader, I try to abstract the object creation, so I can switch between classloaded classes or classes already loaded in the classpath. I've generally used logic of the type if a classloader is passed in, use it, otherwise, use plain old createObject(java..., vs. just trying and catching, which sounds like a better approach, perhaps. I've actually got some iCal4j specific code, if you're curious. ~Den -- Few of the many wise apothegms which have been uttered have prevented a single foolish action. Thomas B. Macaulay ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:36 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing for existence of Java library?
You could attempt to load one of it's classes and catch the resulting exception if it's missing. Based on whether that exception is raised you'll know whether it's available. cheers, barneyb On Fri, Aug 15, 2008 at 2:19 PM, Pete Ruckelshaus [EMAIL PROTECTED] wrote: Hopefully simple question. How would I test for the existence of a specific Java library (specifically, iCal4j)? Thanks Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing for existence of Java library?
Hopefully simple question. How would I test for the existence of a specific Java library (specifically, iCal4j)? Use an exception handler around your CreateObject call. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing for existence of Java library?
You mean, like check to see if the jar exists? I've never found a way to do it without simply trying to create an instance of it in a try catch block. ~Brad - Original Message - From: Pete Ruckelshaus [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, August 15, 2008 4:19 PM Subject: Testing for existence of Java library? Hopefully simple question. How would I test for the existence of a specific Java library (specifically, iCal4j)? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing for existence of Java library?
I don't know but maybe something like this
Try {
Var test = new Ext.GridPane();
} catch (e) {
// Library not found
}
I suppose you don't think like that?
--
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 9015 8628
Mobile: 0404 998 273
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Saturday, 16 August 2008 7:19 AM
To: CF-Talk
Subject: Testing for existence of Java library?
Hopefully simple question. How would I test for the existence of a specific
Java library (specifically, iCal4j)?
Thanks
Pete
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311082
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing for existence of cfthread
I think the only way to manage threads outside code is to use CF Admin pages. You can built simple admin tag for your own purposes that helps you manage your threads though. You could have the threads register themselves upon start using a shared key space that you can than poll and manage from. For example, if you used an application level array. Each thread will append its name to this array when started. To check whether a thread exists you check the length of array. You can then write a little code that can get information about thread status using associative array notation -- myThread=cfthread[#myThreadName#]. This should also give you insight whether thread failed or myThread.Error variable also status info myThread.Status is available etc. Hope this helps, Bilal ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing a web service signature?
I've done this, but not in CF. There is a Java framework called WSIF (Web Service Invocation Framework) that allows for stubless, or dynamic invocation of a web service as well as exposes the meta data about a web service. You might be able to leverage concepts, or the library itself to get to the information you need. http://ws.apache.org/wsif/ HTH, Rich Kroll ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing For Windows Media Player
I would imagine that you would have to use VBScript (which would only work in IE). MSDN would be a better resource. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Chad McCue wrote: I am looking for a way to test which version of windows media player a person has when visiting my site. I need to run a couple of different things if a user has v. 11 or if a user has v. 10 or below. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Testing for the existence of a dynamic structure that may or may not exist.
StructKeyExists is good for this. cfif NOT StructKeyExists(stWSSB_Tickler,sku) cfset stWSSB_Tickler[sku] = structNew() /cfif Steve Is there any way to do this w/o causing an error/exception if the structure does not exist? cfif NOT isDefined(stWSSB_Tickler[sku]) cfset stWSSB_Tickler[sku] = structNew() /cfif ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing for the existence of a dynamic structure that may or may not exist.
Is there any way to do this w/o causing an error/exception if the structure does not exist? Did you mean the top level struct not existing? You could do this: cfif isDefined(stWSSB_Tickler) cfif NOT StructKeyExists(stWSSB_Tickler,sku) cfset stWSSB_Tickler[sku] = structNew() /cfif /cfif -- Josh ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing for the existence of a dynamic structure that may or may not exist.
Josh, Steve... thanks so much! -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 3:05 PM To: CF-Talk Subject: Re: Testing for the existence of a dynamic structure that may or may not exist. Is there any way to do this w/o causing an error/exception if the structure does not exist? Did you mean the top level struct not existing? You could do this: cfif isDefined(stWSSB_Tickler) cfif NOT StructKeyExists(stWSSB_Tickler,sku) cfset stWSSB_Tickler[sku] = structNew() /cfif /cfif -- Josh ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Testing Database Connection within Application
Rob O'Brien wrote: I tested shutting down my datasource, and it retured false in about 1-2 seconds in my local environment. This looks like exactly what I'm looking for and I really appreciate the effort. I tested the same way. I stop the SQL Server service and then refresh the script. Unfortunately, this still takes 16-18 seconds to return False (tested locally). If you're reporting 1-2 seconds, I'm thinking there's another factor involved. Any ideas? Maybe a 'stealth mode' software firewall. Attach a packetsniffer and see what really happens. Jochem ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275973 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing Database Connection within Application
I think Select null From table Is less taxing, and produces the same results -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com -Original Message- From: Brian Polackoff [mailto:[EMAIL PROTECTED] Sent: Friday, April 20, 2007 1:02 PM To: CF-Talk Subject: RE: Testing Database Connection within Application Rob, This may sound simple, maybe too simple, but how long does your application take to error on a cfquery if the table isn't available? I useed a different approach, rather then testing to see if the DSN was valid, I simply tried to query from it. I have just ran into this problem myself and here's how if configured the application. Hope it helps. In application.cfm in the login code as I create all the session variables do a.. !--- checks to see if the reporting server is available --- cftry !--- table has one record in it with 1 column --- cfquery datasource=rc-report name=testconn Select * from testdsConn /cfquery cfset session.ds = 'rc-report' cfcatch cfset session.ds = 'rc-Live' /cfcatch /cftry !- Again, hope it helps and sorry if this answer in some form has already been given, Brian -Original Message- From: Rob O'Brien [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 5:17 PM To: CF-Talk Subject: RE: Testing Database Connection within Application I tested shutting down my datasource, and it retured false in about 1-2 seconds in my local environment. This looks like exactly what I'm looking for and I really appreciate the effort. I tested the same way. I stop the SQL Server service and then refresh the script. Unfortunately, this still takes 16-18 seconds to return False (tested locally). If you're reporting 1-2 seconds, I'm thinking there's another factor involved. Any ideas? Rob ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing Database Connection within Application
Rob, This may sound simple, maybe too simple, but how long does your application take to error on a cfquery if the table isn't available? I useed a different approach, rather then testing to see if the DSN was valid, I simply tried to query from it. I have just ran into this problem myself and here's how if configured the application. Hope it helps. In application.cfm in the login code as I create all the session variables do a.. !--- checks to see if the reporting server is available --- cftry !--- table has one record in it with 1 column --- cfquery datasource=rc-report name=testconn Select * from testdsConn /cfquery cfset session.ds = 'rc-report' cfcatch cfset session.ds = 'rc-Live' /cfcatch /cftry !- Again, hope it helps and sorry if this answer in some form has already been given, Brian -Original Message- From: Rob O'Brien [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 5:17 PM To: CF-Talk Subject: RE: Testing Database Connection within Application I tested shutting down my datasource, and it retured false in about 1-2 seconds in my local environment. This looks like exactly what I'm looking for and I really appreciate the effort. I tested the same way. I stop the SQL Server service and then refresh the script. Unfortunately, this still takes 16-18 seconds to return False (tested locally). If you're reporting 1-2 seconds, I'm thinking there's another factor involved. Any ideas? Rob ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275943 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing Database Connection within Application
You could wrap your database call in a cftry block and then specify code to run when an error happens. cftry cfquery /cfquery cfcatch type=database code to run in event of database error (cfmail?) /cfcatch /cftry -Original Message- From: Rob O'Brien [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 10:38 AM To: CF-Talk Subject: Testing Database Connection within Application I've done my searching online, throughout several groups, and now I turn to you guys. I've been having trouble figuring out how to detect, from within my ColdFusion application, whether or not my database connection is valid. The DB setup is valid, but my goal is to automatically detect when the database server is temporarily down/unavailable in order to display an automatic maintenance message in the case of a crash or true maintenance when the database is offline. I've tried to put a simple query into my Application file and use CFQUERY's Timeout to force a quick (5 second) error within a CFTRY, but I'm inclined to think that it only has an affect on SQL Server when it's up and running, but taking too long to return a result. With my current attempt, it's taking up to 18 seconds to fail, which is just too long. Even using CFSETTING to set RequestTimeout to a lower value doesn't seem to have an affect. This was my attempt: CFTRY CFQUERY datasource=#DBDATASOURCE# username=#DBUSERNAME# password=#DBPASSWORD# name=testConnection timeout=5 SELECT TOP 1 THEME_ID FROM TBL_THEME /CFQUERY CFCATCH !-- DB Connection failed -- cfinclude template=Maint.cfm CFABORT /CFCATCH /CFTRY If it matters, we're using MSSQL now, though we're planning to switch to MySQL eventually. I know there are timeout differences with CFQUERY's Timeout in conjunction with different DB drivers and I'd like to come up with a single, generic solution. I appreciate any feedback. Rob ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing Database Connection within Application
That's what I'm doing now. Unfortunately, the call to the database is taking too long to timeout (16-18 seconds). I was hoping for a way to speed that up to 3-5 seconds. -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 10:50 AM To: CF-Talk Subject: RE: Testing Database Connection within Application You could wrap your database call in a cftry block and then specify code to run when an error happens. cftry cfquery /cfquery cfcatch type=database code to run in event of database error (cfmail?) /cfcatch /cftry -Original Message- From: Rob O'Brien [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 10:38 AM To: CF-Talk Subject: Testing Database Connection within Application I've done my searching online, throughout several groups, and now I turn to you guys. I've been having trouble figuring out how to detect, from within my ColdFusion application, whether or not my database connection is valid. The DB setup is valid, but my goal is to automatically detect when the database server is temporarily down/unavailable in order to display an automatic maintenance message in the case of a crash or true maintenance when the database is offline. I've tried to put a simple query into my Application file and use CFQUERY's Timeout to force a quick (5 second) error within a CFTRY, but I'm inclined to think that it only has an affect on SQL Server when it's up and running, but taking too long to return a result. With my current attempt, it's taking up to 18 seconds to fail, which is just too long. Even using CFSETTING to set RequestTimeout to a lower value doesn't seem to have an affect. This was my attempt: CFTRY CFQUERY datasource=#DBDATASOURCE# username=#DBUSERNAME# password=#DBPASSWORD# name=testConnection timeout=5 SELECT TOP 1 THEME_ID FROM TBL_THEME /CFQUERY CFCATCH !-- DB Connection failed -- cfinclude template=Maint.cfm CFABORT /CFCATCH /CFTRY If it matters, we're using MSSQL now, though we're planning to switch to MySQL eventually. I know there are timeout differences with CFQUERY's Timeout in conjunction with different DB drivers and I'd like to come up with a single, generic solution. I appreciate any feedback. Rob ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing Database Connection within Application
There is a decent chance that the admin api functionality gives you access to the same thing that happens when you click the verify data source icon in CF Admin. I've never looked, but I am curious now. Of course, if that worked, it would probably just tell you that a database engine was listening on that server and port, but it wouldn't give you any application aware information like are the database objects there, or is replication up-to-date etc. ~Brad -Original Message- From: Rob O'Brien [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 10:38 AM To: CF-Talk Subject: Testing Database Connection within Application I've done my searching online, throughout several groups, and now I turn to you guys. I've been having trouble figuring out how to detect, from within my ColdFusion application, whether or not my database connection is valid. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing Database Connection within Application
Out of curiosity, how are you testing it? Are you turning off your database and then refreshing the page to see what happens? ~Brad -Original Message- From: Rob O'Brien [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 11:30 AM To: CF-Talk Subject: RE: Testing Database Connection within Application That's what I'm doing now. Unfortunately, the call to the database is taking too long to timeout (16-18 seconds). I was hoping for a way to speed that up to 3-5 seconds. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing Database Connection within Application
Doesn't look promising anymore. http://livedocs.adobe.com/coldfusion/7/htmldocs/1738.htm That link tells you how to add data sources to CF with the admin API. The last step says: (Optional) To verify this data source later, click the verify icon in the Actions column. Note: To check the status of all data sources available to ColdFusion MX, click Verify All Connections. If there was a way to do it via the API they probably wouldn't tell you to go to the CF Administrator interface. ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 11:30 AM To: CF-Talk Subject: RE: Testing Database Connection within Application There is a decent chance that the admin api functionality gives you access to the same thing that happens when you click the verify data source icon in CF Admin. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing Database Connection within Application
Here is a stack trace of what CF is doing when it verifies a data source from CF ADMIN. Unfortunately these files are encrypted, so there is no (Legal) way to find out how the code looks. jrpp-88 in Object.wait() - locked 138 (a coldfusion.server.j2ee.sql.pool.JDBCPool) at java.lang.Object.wait(Native Method) at java.lang.Thread.join(Thread.java:1009) at coldfusion.server.j2ee.sql.pool.ConnectionRunner.fetchConnection(Connect ionRunner.java:43) at coldfusion.server.j2ee.sql.pool.JDBCPool.create(JDBCPool.java:519) at coldfusion.server.j2ee.sql.pool.JDBCPool._checkOut(JDBCPool.java:444) at coldfusion.server.j2ee.sql.pool.JDBCPool.checkOut(JDBCPool.java:350) at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java :720) at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManage r.java:123) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.j ava:138) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.j ava:125) at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:37) at coldfusion.sql.Executive.verifyDatasource(Executive.java:260) at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at coldfusion.runtime.StructBean.invoke(StructBean.java:391) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1662) at cfudflibrary2ecfm24721086$funcVERIFYDSN.runFunction(C:\blackstone_update s\cfusion\wwwroot\CFIDE\administrator\datasources\udflibrary.cfm:14) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.j ava:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java: 56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1772) at cfindex2ecfm1536982671._factor11(C:\blackstone_updates\cfusion\wwwroot\C FIDE\administrator\datasources\index.cfm:432) ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 11:43 AM To: CF-Talk Subject: RE: Testing Database Connection within Application Doesn't look promising anymore. http://livedocs.adobe.com/coldfusion/7/htmldocs/1738.htm That link tells you how to add data sources to CF with the admin API. The last step says: (Optional) To verify this data source later, click the verify icon in the Actions column. Note: To check the status of all data sources available to ColdFusion MX, click Verify All Connections. If there was a way to do it via the API they probably wouldn't tell you to go to the CF Administrator interface. ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 11:30 AM To: CF-Talk Subject: RE: Testing Database Connection within Application There is a decent chance that the admin api functionality gives you access to the same thing that happens when you click the verify data source icon in CF Admin. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing Database Connection within Application
Ok, you really got me curious on this one. I googled, and found an old CF dev journal article (http://pdf.sys-con.com/ColdFusion/beyond.pdf) with this function. It doesn't use the admin API, but the service factory. Now keep in mind anything in the service factory is undocumented and therefore technically unsupported by Adobe if you use it in your code. It also kicks butt in my opinion. Here is a good resource on it: http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=10 This function works for me to verify datasources: !--- verify a datasource is working --- cffunction name=verifydsn returntype=boolean cfargument name=dsn type=string required=yes !--- init local variables --- cfset var dsservice= cfset var result=true !--- try/catch block --- cftry !--- get factory --- cfobject action=create type=java class=coldfusion.server.ServiceFactory name=factory !--- get datasource service --- cfset dsService=factory.getDataSourceService() !--- validate dsn --- cfset result=dsService.verifyDatasource(dsn) !--- if any error, return false --- cfcatch type=any cfset result=false /cfcatch /cftry cfreturn result /cffunction ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 11:52 AM To: CF-Talk Subject: RE: Testing Database Connection within Application Here is a stack trace of what CF is doing when it verifies a data source from CF ADMIN. Unfortunately these files are encrypted, so there is no (Legal) way to find out how the code looks. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing Database Connection within Application
There is a decent chance that the admin api functionality gives you
access to the same thing that happens when you click the verify data
source icon in CF Admin.
Yes, you can get this from the adminapi:
cfscript
// you must log in before accessing other adminapi components
adminObj = createObject('component',
'cfide.adminapi.administrator');
adminObj.login('yourCFAdminPassword');
// create the data object and test the DSN
dataObj = createObject('component',
'cfide.adminapi.datasource');
writeOutput(dataObj.verifyDSN('dsnName')); //returns boolean
/cfscript
I tested shutting down my datasource, and it retured false in about 1-2
seconds in my local environment.
HTH,
Rich Kroll
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275875
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing Database Connection within Application
Well, what do you know! I'm quite curious why the live doc I found told you to use the CF Admin interface and didn't mention this. I assume this uses the same back-end functionality the service factory offers. ~Brad -Original Message- From: Richard Kroll [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 12:07 PM To: CF-Talk Subject: RE: Testing Database Connection within Application There is a decent chance that the admin api functionality gives you access to the same thing that happens when you click the verify data source icon in CF Admin. Yes, you can get this from the adminapi: ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing Database Connection within Application
I tested shutting down my datasource, and it retured false in about 1-2 seconds in my local environment. This looks like exactly what I'm looking for and I really appreciate the effort. I tested the same way. I stop the SQL Server service and then refresh the script. Unfortunately, this still takes 16-18 seconds to return False (tested locally). If you're reporting 1-2 seconds, I'm thinking there's another factor involved. Any ideas? Rob ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Testing
On 3/27/07, John P A wrote: Selenium is great for functional testing -- and hooking it into Ant for running nightly/continuous tests is great. Hot dang! That sounds excellent. I'll have to look into that aspect of Selenium-- perhaps it could wear a couple of hats. I think all of the load-testing tools, open and commercial, are a pain. I think if you're after load testing on Windows in the CF world, Paessler's web stress tool is probably the best balance of expense and features. I've used Grinder (open) and Empirix (). Argh. Well thanks for the suggestions, and insight. I can run whatever platforms I need to, for the best tools, so I guess I'll widen my spread (thanks for mentioning Grinder, I'd forgotten that one, been meaning to check it). Sounds like they're all painful tho... hmmm... probably not a good application for CF, neh? That is, creating a CF-based load tester would be like writing a CF-based huge-text-file parser, right? And if they are all that rough to use, it's probably not trivial at all. M yeah, guess I'll check grinder next, and cycle 'round to OpenSTA again. Give 'em some shaking and see what falls out. I'll check out the $$$ ones a bit too, one of my projects might spring for something like that. Makes me wish is was a bit easier to test them out tho... ouch... /me looks at the clock So... Let the annual what are people using testing thread commence! (and if it dies with this post, so be it.) I'm teaching a preconference course on this sort of thing at CFUnited, though starting with the basics of SVN and automation with Ant to make a complete package :) Well that is just plain beautiful. Someday I'll get the Office to pay for me to go to a con... almost made it to a couple of fun ones a bit ago-- if they went for those they'll probably go for something CF related... Luckily I've been blessed with the experience of SVN and ANT, so it sounds like a great course. I'd recommend anyone pick those skills up. May your course be a full one! We need more folks with the knowledge. Thanks for the contribution to this thread, JP! Great stuff! ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Testing
On 3/27/07, Dinner [EMAIL PROTECTED] wrote: I know this is a recurring thread, so I figured I be the one to reoccur it. =] What are folks using for testing? When I say testing, I mean the whole package- unit tests, application tests, application/server load tests... I really like the Selenium plugin for FF, and unless I hear different, I'll be looking into the server side of that whole deal (not quite sure what all is involved). Selenium is great for functional testing -- and hooking it into Ant for running nightly/continuous tests is great. I tried OpenSTA, but it sorta seems to suck. :-/ Could just be my own incompetence, obviously, so if I hear it's the cat's whiskers or the elephant's ankles, I'll put some more neurons to the grinder for it-- from some limited testing tho... niet! I think all of the load-testing tools, open and commercial, are a pain. I think if you're after load testing on Windows in the CF world, Paessler's web stress tool is probably the best balance of expense and features. I've used Grinder (open) and Empirix (). Argh. So... Let the annual what are people using testing thread commence! (and if it dies with this post, so be it.) I'm teaching a preconference course on this sort of thing at CFUnited, though starting with the basics of SVN and automation with Ant to make a complete package :) -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing...
Yo yo, what up? Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, October 23, 2006 12:41 PM To: CF-Talk Subject: Testing... Testing.anybody home? Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257757 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing...
On 10/23/06, Rick Faircloth [EMAIL PROTECTED] wrote: Testing.anybody home? no -- mac jordan home: www.kestrel.org work: www.webhorus.net them: www.jordan-cats.org ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing...
Testing. Ah ah! You're testing your system after having upgrade from CF 4.5 to version 7? ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing...
Ah ah! You're testing your system after having upgrade from CF 4.5 to version 7? ;-) Shit, I'd just wait for 8 at this point. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing...
really off topic. Please do not respond. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257768 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing...
Well, that explains it, then... -Original Message- From: mac jordan [mailto:[EMAIL PROTECTED] Sent: Monday, October 23, 2006 12:54 PM To: CF-Talk Subject: Re: Testing... On 10/23/06, Rick Faircloth [EMAIL PROTECTED] wrote: Testing.anybody home? no ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing...
You wish! (Then you wouldn't have to hear me ask constantly, Is that great feature backwards compatible with CF 4.5.2? :o) Just wondering why there is so little traffic today...maybe Michael blacklisted me for not upgrading. I'm going to wait until CF 8...there'll probably be too much to learn to get up to speed on CF 7, then a bunch more to learn to get up to speed on CF 8, so why go through the learning curve twice? Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, October 23, 2006 12:57 PM To: CF-Talk Subject: Re: Testing... Testing. Ah ah! You're testing your system after having upgrade from CF 4.5 to version 7? ;-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing...
Just seemed like I wasn't receiving any messages from CF-Talk..wondering if something might be wrong... I was getting more email from the SPF-help mailing list! Rick -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Monday, October 23, 2006 12:47 PM To: CF-Talk Subject: RE: Testing... Yo yo, what up? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing...
Exactly... -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Monday, October 23, 2006 1:11 PM To: CF-Talk Subject: Re: Testing... Ah ah! You're testing your system after having upgrade from CF 4.5 to version 7? ;-) I'd just wait for 8 at this point. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257774 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing...
(Then you wouldn't have to hear me ask constantly, Is that great feature backwards compatible with CF 4.5.2? Not really, I'm pretty sure you will have even more questions about all the new features ;-)) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257791 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Testing...
Very true...but I'll wait to begin the barrage for CF 8... -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, October 23, 2006 3:35 PM To: CF-Talk Subject: Re: Testing... (Then you wouldn't have to hear me ask constantly, Is that great feature backwards compatible with CF 4.5.2? Not really, I'm pretty sure you will have even more questions about all the new features ;-)) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: testing after last week
well...looks like that works ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, July 19, 2006 2:47 PM Subject: testing after last week test Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247111 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: testing for an undefined date
cfif isDate(whatsnew.event_date) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for an undefined date
In your query you can do: Where event_date is null Or is not null In your cf you can do cfif len(trim(whatsNew.eventDate)) -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, January 13, 2006 1:09 PM To: CF-Talk Subject: testing for an undefined date I can't seem to get this to work. I have a date field in an Oracle DB, created as event_date date. It has a date field that's not required so it's only filled in when a date is available. How do I test to see if it's empty or not? I did: cfif whatsnew.event_date NEQ undefined cfif whatsnew.event_date NEQ NULL cfif whatsnew.event_date NEQ '' thanks. daniel ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229492 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing for an undefined date
It still seems to be enacting the code. I also tried cfif
isDefined('whatsnew.event_date')
I guess it's a date but an empty date or something like that since isDate
didn't help.
cfif isDate(whatsnew.event_date)
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229493
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing for an undefined date
In your query you can do: Where event_date is null Or is not null I still want the record, but I just don't want to try and display the html for the date if the date doesn't exist. It adds a line for it. thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229494 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing for an undefined date
I have had difficulty trusting the isDate() function also. I fell back to
using
cfif isdefined(whatsnew.event_date) and len(trim(whatsnew.event_date))
gt 0
take action
/cfif
Charlie Hanlon
- Original Message -
From: daniel kessler [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 13, 2006 1:28 PM
Subject: Re: testing for an undefined date
It still seems to be enacting the code. I also tried cfif
isDefined('whatsnew.event_date')
I guess it's a date but an empty date or something like that since isDate
didn't help.
cfif isDate(whatsnew.event_date)
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229495
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for an undefined date
Read further. -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, January 13, 2006 1:30 PM To: CF-Talk Subject: Re: testing for an undefined date In your query you can do: Where event_date is null Or is not null I still want the record, but I just don't want to try and display the html for the date if the date doesn't exist. It adds a line for it. thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229496 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for an undefined date
Just wrap it in a CFIF statement. cfif yourdatefield IS NOT show code/cfif !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, January 13, 2006 12:30 PM To: CF-Talk Subject: Re: testing for an undefined date In your query you can do: Where event_date is null Or is not null I still want the record, but I just don't want to try and display the html for the date if the date doesn't exist. It adds a line for it. thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229497 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing for an undefined date
Read further. ah I didn't see that at the bottom. That values to 0 so it doesn't enact. cool. thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing a string for unicode characters
S. Isaac Dealey wrote: I just noticed today (or rather, John Ashenfelter pointed out to me :) that some regular expression engines include \u to match unicode characters. that's what unicode calls it's level 1 support. bare butt minimum. i'm weak w/regex so take all of the following w/a grain of salt. i think regex in cf is based on perl which is described w/some unicode support via \p, \P, \X, and \u none of which cf seems to support. So I did a couple tests on some data we had in a legacy database (it doesn't have any nvarchar columns... yet) and it turns out that using the \u pattern in a regular expression will mangle the hell out of an ASCII string... I'm also assuming (and I may be way off base) that why can't you use chr()? using #chr(1-32)# (for a nonprinting ascii character) won't always match the same character in a unicode string. (I woudl think it depends on whether or not the string uses single or double-byte for the individual character, since I recall reading that unicode doesn't always use double-byte representation, but I suspect the regex engine does if you use \u.) you're thinking about unicode transforms where the number of bytes can vary per char or maybe in some now rare cases of creating graphemes via combining chars: a+combining char+' = á (latin small a w/acute). if you're dealing w/this internally i wouldn't think that would be an issue. 1) Does the regex engine in CF 6-7 support \u? apparently not. bigA=A; p=refind(\u0041,bigA); p returns 0. i think if you need to use that kind of notation then maybe core java's java.util.regex icu4j also has some nifty search classes that might be useful. 2) am I wrong about #chr(1-32)#? Will it always match the same character in a UTF-8 string? unless you're using EBCDIC?? the original ASCII stuff went straight into unicode as is to keep the adoption uproar to a minimum. 3) if CF 6+ supports \u and #chr(1-32)# won't always match the unicode equivalent, is there a way to test a string in CF to determine if it's unicode (digging into Java maybe)? icu4j has charset detector, core java's java.util.regex might help too. but forensically determining a charset isn't pretty nor always correct. exception of tab (9), newline (10,13) and space (32) characters. This database has some data containing vertical tabs (11) which I'm this won't work? bigA=AA#chr(11)#AA#chr(11)#AA; replacedBigA=replace(bigA,chr(11),,ALL); ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Testing File Upload
From: Lee [mailto:[EMAIL PROTECTED] I have a file upload option on a form page where the user may or may not attach a file. How do I test on the action page if the user attached a file? Isdefined and paramaterexists always come in true. cfif len(form.formFieldName) gt 0 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220607 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Testing File Upload
Just check the length of the file field. cfif len(trim(form.fielfield)) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 4:34 PM To: CF-Talk Subject: Testing File Upload I have a file upload option on a form page where the user may or may not attach a file. How do I test on the action page if the user attached a file? Isdefined and paramaterexists always come in true. Lee Surma ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220613 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing File Upload
I would suggest cfif len(trim(form.formFieldName)) some browsers will append a space to the value submitted. cfif len(form.formFieldName) gt 0 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220614 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing - Not received anything since 7pm Eastern Friday
Anyone out there? Me! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217881 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 22, 2005 9:47 AM
To: CF-Talk
Subject: testing for undefined
I'm returning data back from a database and want to populate
variables the same way as columns are named. I have this working
fine (though any suggested improvements are welcome), but when the
values are undefined, in this case at least, I'd like to make the
variable have a '' (empty quotes) instead for repopulating form
fields. I'm not sure how to test for undefined.
Here's the code:
cfset the_db = StructNew()
cfoutput query=#the_db_name#
cfloop list=#evaluate('#the_db_name#.columnlist')# index=col
cfset the_db_info[col] =
evaluate('#the_db_name#[col][currentRow]')
!--- attempting to make undefined an empty string ---
cfif the_db_info[col] EQ undefined
cfset the_db_info[col] = ''
/cfif
#col#:#the_db_info[col]#br
/cfloop
/cfoutput
Well - first off you don't need the evaluates in there - you can use normal
notation. Something like this.
cfset the_db = StructNew()
cfoutput query=#CurQuery#
cfloop list=#the_db_name.columnlist# index=col
cfset the_db_info[col] = the_db_name[col][currentRow]
/cfloop
/cfoutput
Once that's set I'm confused... you're looping over a known column list so
how could any be column name be undefined?
I guess I'm confused with the_db_info variable and what it does... as it
is in your current code it's being used as an indexed object, but it's never
declared as one... even if it were it would end up overwritten with the last
of row of data in any multi-row recordset.
To convert a one-row recordset to a struct (which is sorta what your code is
doing) I would do this (this will also work for multi-row record sets but
will only convert the first row):
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = CurQuery[CurCol][1] /
/cfloop
By the same token to convert just the last row you modify it to do this:
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = CurQuery[CurCol][CurQuery.RecordCount] /
/cfloop
Now, to convert multi-record queries you need to have something in the
structkey to hold multiple values. (This is where you're original code
confuses me since it doesn't seem to do that.)
For example a logical form is a struct of Arrays (which is, in fact, what a
query object is). To do that conversion you'd do something like this:
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = ArrayNew(1) /
cfloop from=1 to=#CurQuery.RecordCount# index=Cnt
cfset ArrayAppend(MyStruct[CurCol], CurQuery[CurCol][Cnt]) /
/cfloop
/cfloop
Now there's a nifty simplification that comes into play here. Since Query
columns are already arrays (and can be accessed as such you should also be
able to do (more simply) something like this:
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = ArrayNew(1) /
cfset MyStruct[CurCol] = CurQuery[CurCol] /
/cfloop
Those two blocks of code (barring any coding in email email errors should
work identically).
It's also useful in other ways. Let's say you don't want a struct of
arrays, let's say you want a struct of lists (with each list representing
the column of data values). You can do that even more simply like this:
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = ArrayToList(CurQuery[CurCol]) /
/cfloop
Neat, uh?
I'm not sure if any of that actually addresses your problem... but I hope it
does!
Jim Davis
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210215
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
Well - first off you don't need the evaluates in there - you can use normal
notation.
I'll try that, thanks. I try to not use it when I can('t).
Something like this.
cfset the_db = StructNew()
this should've been:
cfset the_db = StructNew()
for it's use below.
cfoutput query=#CurQuery#
cfloop list=#the_db_name.columnlist# index=col
cfset the_db_info[col] = the_db_name[col][currentRow]
/cfloop
/cfoutput
Once that's set I'm confused... you're looping over a known column list so
how could any be column name be undefined?
It's not the column name that's undefined, but it's contents; in other words,
empty, but not an empty quotes. It's the right side of cfset the_db_info[col]
= the_db_name[col][currentRow]
I guess I'm confused with the_db_info variable and what it does... as it
is in your current code it's being used as an indexed object, but it's never
declared as one...
yeah, I meant it to be defined by the structNew on the first line.
even if it were it would end up overwritten with the last
of row of data in any multi-row recordset.
That's ok. This is just going to loop through the recordset and display the
data so I use the same struct for each record, display it and then go on.
To convert a one-row recordset to a struct (which is sorta what your code is
doing) I would do this (this will also work for multi-row record sets but
will only convert the first row):
cfset MyStruct = StructNew() /
cfloop list=#CurQuery.columnlist# index=CurCol
cfset MyStruct[CurCol] = CurQuery[CurCol][1] /
/cfloop
Mine looks like this except for the evaluates and the currentrow that I use.
I'm going to loop through several records so I think my currentrow use is
correct.
I have eliminated the evaluates. They were there because I was using the
database name as a string. I realized I should set the val to the database
instead.
I think I still need to use the string though for the cfoutput
query=#the_db_name# but I should probably take that out of the included file
and just do the variable setting there.
Neat, uh?
yep, very much so. It's making my life much simpler to implement this.
I still have the original problem of testing for undefined.
I'm not sure if any of that actually addresses your problem... but I hope it
does!
thanks for answerin'!
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210230
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
-Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 11:24 AM To: CF-Talk Subject: RE: testing for undefined That's ok. This is just going to loop through the recordset and display the data so I use the same struct for each record, display it and then go on. Now I'm really confused - why do this at all? Is there processing that's not shown? You can display everything as you want using just the query - why waste the time to convert the query to something else to do this? I still have the original problem of testing for undefined. Well - sort of. Queries aren't sparse arrays - their values should always be empty space (although I think exceptions can arise when you build the queries from scratch). I think that cfif MyQuery.Col[Row] NEQ ... defined ... cfelse ... not defined ... /cfif Should do it. However this really isn't defined but empty - CF treats nulls and empty spaces the same in queries. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
Is there any way to set a header item in an outgoing CFHTTP request? I'm working with an API that needs a custom header item inserted in a GET request. I'm thinking something like: CFHTTP url=http://server1/xmlnotify.asp; method=GET HTTP_AUTHORIZATION: Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP or CFHTTP url=http://sync1.bh-bos2.bullhorn.com/xmlnotify.asp?folderType=1folderName=Contacts; method=GET CFHEADER name=HTTP_AUTHORIZATION value=Digest userName=cseibert nonce=a1faa6e2b8a21722a845926368b4f2f1 /CFHTTP Neither of which seem to work. I know that CFHEADER is used to return headers to the browser, I'm just illustrating the syntax I would like to exists, hehe. Ideas? -Chase Chase Seibert | Network and Systems Engineer | Bullhorn Inc. | 617.464.2440 x119 | www.bullhorn.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
You can display everything as you want using just the query - why waste the time to convert the query to something else to do this? I'm trying to make it reusable so that I can include it wherever I need it. If I use the same name everywhere, db_info and then use that in all my queries, then I can repopulate them easily. But that is certainly the way I may end up doing it. I still have the original problem of testing for undefined. Well - sort of. Queries aren't sparse arrays - their values should always be empty space (although I think exceptions can arise when you build the queries from scratch). when I populate that struct, when I set the info to whatever is in the db, the first time it comes to a variable in a form (value='#db_info.blah#') that was populated by an empty column seems to be undefined and I receive an error stating so, on the line that contains the form element. Of course, I won't know that until I can test for undefined and set it to something else. I think that cfif MyQuery.Col[Row] NEQ ... defined ... cfelse ... not defined ... /cfif Should do it. However this really isn't defined but empty - CF treats nulls and empty spaces the same in queries. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing for undefined
-Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 12:48 PM To: CF-Talk Subject: RE: testing for undefined You can display everything as you want using just the query - why waste the time to convert the query to something else to do this? I'm trying to make it reusable so that I can include it wherever I need it. If I use the same name everywhere, db_info and then use that in all my queries, then I can repopulate them easily. But that is certainly the way I may end up doing it. I think you're better off - you can still make a generic query displayer using the indexed notation without conversion. I still have the original problem of testing for undefined. Well - sort of. Queries aren't sparse arrays - their values should always be empty space (although I think exceptions can arise when you build the queries from scratch). when I populate that struct, when I set the info to whatever is in the db, the first time it comes to a variable in a form (value='#db_info.blah#') that was populated by an empty column seems to be undefined and I receive an error stating so, on the line that contains the form element. Of course, I won't know that until I can test for undefined and set it to something else. Weird. Are you talking about an empty column or cell? If a column then wouldn't the whole query be empty? If a cell then it should be empty string not undefined... It's probably worth exploring, but since I really don't think you need the conversion at all it's probably a moot point. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
On Apr 1, 2005 7:23 PM, Rob [EMAIL PROTECTED] wrote: Matt, you live in Fresno? Yep. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing....is this thing on?
Please leave declarations regarding your personal preferences to the CF-Community list ;-) -Original Message- From: Will The Game [mailto:[EMAIL PROTECTED] Sent: Saturday, 2 April 2005 10:45 To: CF-Talk Subject: Re: testingis this thing on? [snip] POOF! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Please leave declarations regarding your personal preferences to the CF-Community list ;-) Sorry about that guys. I shouldn't post that late on a friday evening! Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
If I made a lot of money on advertising, it would be nice. The offer was 100% of what I made in advertising over the last 12 months (not much) plus 1/12 of that per month to keep me on. I've never been in this for the money and my advertising revenue reflects that. :) I gotta ask - was it a nice amount? Enough to put the kiddies through college? :) Ray At 05:59 PM 4/1/2005, you wrote: ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing....is this thing on?
Not much traffic today..is there a US holiday today I'm not aware of? ;-) Yes, it's officially called Friday and comes around only once per week I'm afraid. :-) --- Justin D. Scott Vice President Sceiron Interactive, Inc. www.sceiron.com [EMAIL PROTECTED] 941.378.5341 - office 941.320.2402 - mobile 877.678.6011 - facsimile ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201208 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Not much traffic today..is there a US holiday today I'm not aware of? I was asking myself the same question, but I think the HF server was off for a while. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201214 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Not much traffic today..is there a US holiday today I'm not aware of? ;-) Yup, it's called April Fool's day, aka, St. Stupid's Day. May the Farce be with you! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201224 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Yup, it's called April Fool's day, aka, St. Stupid's Day. May the Farce be with you! and I launched a new app today..so far so good ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com.cfm/54 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201229 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Due to a database crash and long rebuild time (we have a LOT of data), the site was down for a period today. No mail was lost and everything is back running smoothly. Sorry about that and no, it was not april fools. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201231 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
LOL...not April fools to us, but that must have been a nice April fool's joke on you! Sorry, not laughing at you. I sincerely appreciate the insane amount of work you provide for free for us! Have a good weekend all, I am off to down a few beers! Yee-ha, it is the WEEKEND! Ray At 04:50 PM 4/1/2005, you wrote: Due to a database crash and long rebuild time (we have a LOT of data), the site was down for a period today. No mail was lost and everything is back running smoothly. Sorry about that and no, it was not april fools. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201232 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Actually, I just got an email from a (real) company that wants to buy House of Fusion. I had to turn them down. Yeh, it's a lot of work and headaches but it's ours (Judith's and mine) and we run it for the community. And yes, we're fixing all the bugs and adding new features. No one has commented on the thread labeling or random buttons, but it's there. LOL...not April fools to us, but that must have been a nice April fool's joke on you! Sorry, not laughing at you. I sincerely appreciate the insane amount of work you provide for free for us! Have a good weekend all, I am off to down a few beers! Yee-ha, it is the WEEKEND! Ray At 04:50 PM 4/1/2005, you wrote: Due to a database crash and long rebuild time (we have a LOT of data), the site was down for a period today. No mail was lost and everything is back running smoothly. Sorry about that and no, it was not april fools. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201233 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
I gotta ask - was it a nice amount? Enough to put the kiddies through college? :) Ray At 05:59 PM 4/1/2005, you wrote: Actually, I just got an email from a (real) company that wants to buy House of Fusion. I had to turn them down. Yeh, it's a lot of work and headaches but it's ours (Judith's and mine) and we run it for the community. And yes, we're fixing all the bugs and adding new features. No one has commented on the thread labeling or random buttons, but it's there. LOL...not April fools to us, but that must have been a nice April fool's joke on you! Sorry, not laughing at you. I sincerely appreciate the insane amount of work you provide for free for us! Have a good weekend all, I am off to down a few beers! Yee-ha, it is the WEEKEND! Ray At 04:50 PM 4/1/2005, you wrote: Due to a database crash and long rebuild time (we have a LOT of data), the site was down for a period today. No mail was lost and everything is back running smoothly. Sorry about that and no, it was not april fools. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing....is this thing on?
Personally, I think that the random thread that is OT is OK... It can get a little much sometimes, but imagine this as sort of a virtual workplace. Then imagine a workplace where no one ever said anything funny, no anecdotes were told, and no passionate discussions ever held. Booig! I even stopped to share the remark about our US holiday known as Friday with my wife... Here's a potential solution: If everyone were very diligent about labeling an off-topic subject, that was not strictly about coding, with OT at the beginning, then those who want to read only about coding could easily set up filtering rules which simply delete any mail that include OT in the subject. Some would forget, yes...we're human after all (at least some of us ;o)... but it would be a way for people to effortlessly avoid OT topics while letting others have a food fight once in a while to vent. I use Outlook, so I could easily make such a rule and avoid all OT discussions, but some of them I like and participate in for the fun and for the enlightenment of it all. Not every CF-related problem or discussion is *directly* CF-related... (???) I know the discussion about SEO was not directly about CF-coding, but it sure has to do with how I employ that code... Anyway...just another (OT ;o) thought for the mix... Rick -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 5:59 PM To: CF-Talk Subject: Re: testingis this thing on? Actually, I just got an email from a (real) company that wants to buy House of Fusion. I had to turn them down. Yeh, it's a lot of work and headaches but it's ours (Judith's and mine) and we run it for the community. And yes, we're fixing all the bugs and adding new features. No one has commented on the thread labeling or random buttons, but it's there. LOL...not April fools to us, but that must have been a nice April fool's joke on you! Sorry, not laughing at you. I sincerely appreciate the insane amount of work you provide for free for us! Have a good weekend all, I am off to down a few beers! Yee-ha, it is the WEEKEND! Ray At 04:50 PM 4/1/2005, you wrote: Due to a database crash and long rebuild time (we have a LOT of data), the site was down for a period today. No mail was lost and everything is back running smoothly. Sorry about that and no, it was not april fools. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
test Not much traffic today..is there a US holiday today I'm not aware of? ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
On Apr 1, 2005 1:36 PM, Rebecca Wells [EMAIL PROTECTED] wrote: Yup, it's called April Fool's day, aka, St. Stupid's Day. I absolutely couldn't help myself. I called my girlfriend and told here a Mr. Lyon had called looking for her. He sounded distraught and said it was urgent. He left a number for her to call ASAP. When she called me back later she told me she could not get thru to Mr. Lyon. All she got was a recorded message from the Fresno Zoo. I could barely contain myself as I told her a Mr. Rhino had just called and said to keep trying. She's gonna kick my ass when she gets home tonight. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201238 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Sorry, not laughing at you. I sincerely appreciate the insane amount of work you provide for free for us! DITTO!! Have a good weekend all, I am off to down a few beers! Yee-ha, it is the WEEKEND! Beer? what's that?? Off for a few long islands and codin' for me! cfset mydrinkofchoice[longislandicedtea] Willeroo! (.netwill) p.s. I already had a few! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing....is this thing on?
Will's quote of the week... Do you have Long Island Iced Tea in Ing-ger-land? :OD -Original Message- From: Will The Game [mailto:[EMAIL PROTECTED] Sent: 01 April 2005 23:49 To: CF-Talk Subject: Re: testingis this thing on? Sorry, not laughing at you. I sincerely appreciate the insane amount of work you provide for free for us! DITTO!! Have a good weekend all, I am off to down a few beers! Yee-ha, it is the WEEKEND! Beer? what's that?? Off for a few long islands and codin' for me! cfset mydrinkofchoice[longislandicedtea] Willeroo! (.netwill) p.s. I already had a few! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.0 - Release Date: 31/03/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing....is this thing on?
Better yet, some Mike's Hard Lemonade! -Original Message- From: Will The Game [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 3:49 PM To: CF-Talk Subject: Re: testingis this thing on? Beer? what's that?? Off for a few long islands and codin' for me! cfset mydrinkofchoice[longislandicedtea] Willeroo! (.netwill) p.s. I already had a few! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Better yet, some Mike's Hard Lemonade! C'mon connieplease! We're talkin' TJ Toad's Long island Iced tea. 37% alchohol...crap, you should see all the backspaces and corrections I just did here...lmao! I even opened up some window I never knew existed!! Anyway, Mike's ain't bad, but *this* stuff is wicked! What's so bad is I think my codin' is better!! ICK! Willerooni (.netwill, aspwill, willtheinstigationist) How'd I just do that??? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201247 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: testing....is this thing on?
Hell, that does sound, good, pass me one! -Original Message- From: Will The Game [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 5:14 PM To: CF-Talk Subject: Re: testingis this thing on? Better yet, some Mike's Hard Lemonade! C'mon connieplease! We're talkin' TJ Toad's Long island Iced tea. 37% alchohol...crap, you should see all the backspaces and corrections I just did here...lmao! I even opened up some window I never knew existed!! Anyway, Mike's ain't bad, but *this* stuff is wicked! What's so bad is I think my codin' is better!! ICK! Willerooni (.netwill, aspwill, willtheinstigationist) How'd I just do that??? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Matt, you live in Fresno? On Apr 1, 2005 3:40 PM, Matt Robertson [EMAIL PROTECTED] wrote: On Apr 1, 2005 1:36 PM, Rebecca Wells [EMAIL PROTECTED] wrote: Yup, it's called April Fool's day, aka, St. Stupid's Day. I absolutely couldn't help myself. I called my girlfriend and told here a Mr. Lyon had called looking for her. He sounded distraught and said it was urgent. He left a number for her to call ASAP. When she called me back later she told me she could not get thru to Mr. Lyon. All she got was a recorded message from the Fresno Zoo. I could barely contain myself as I told her a Mr. Rhino had just called and said to keep trying. She's gonna kick my ass when she gets home tonight. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Hell, that does sound, good, pass me one! Sorry, too late, it's gone! And so am I... gnight everyone! POOF! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Testing for existance of a Structure within an Array
cfif NOT isStruct(errorArray[#rowid#]) but then .. if you are checking for a struct in a variable, what does that variable contain initially ? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185912 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
Rather than putting the error structure into an array, why not use a structure? Then rather than having an array whuch is mostly empty you'll have a structure which only contains errors. so rather than errorsArray[rowNumber] = stError; you could do errorsStructure[rowNumber] = stError; does that makes sense? or did i misunderstand what you're doing? Cheers Bert On Thu, 02 Dec 2004 08:31:16 -0400, Brant Winter [EMAIL PROTECTED] wrote: if there is an error put the errored text in a structure in an array, the array index will be relevant to the current row id of the query i am looping, and there will be a structure of the errors in each array element ( if that makes sense ) ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185913 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
The structure should initially be empty, or it may contain a value for anyone of 24 different errored fields. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185914 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Testing for existance of a Structure within an Array
So, there is no real reason to check if one exists as it will always contain a struct ;-) -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 02 December 2004 12:55 To: CF-Talk Subject: Re: Testing for existance of a Structure within an Array The structure should initially be empty, or it may contain a value for anyone of 24 different errored fields. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185915 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
well would you run into a problem with the array if you set each array index to the current row of your query loop. For example errorArray[1].etc errorArray[5].etc errorArray[22].etc I thought that when building and array you have to sequence your index values. If this is true you might need to create some other counter with in the loop for example cfset errorIndex = 0 cfloop index=i from=1 to=listLen(arguments.ValidateCSV) cfif an error is found *Increment the error Index cfset errorIndex = errorIndex + 1 *Now append the array* cfset errorArray[errorIndex] /cfif /cfloop /cfloop -- Original Message -- From: Brant Winter [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 02 Dec 2004 08:31:16 -0400 I have spent hours trying to write a function for error checking a csv file. In my function I want to check each field, and if there is an error put the errored text in a structure in an array, the array index will be relevant to the current row id of the query i am looping, and there will be a structure of the errors in each array element ( if that makes sense ) In total I have 24 fields of each row to check, hence me wanting to put the errors in an array so that I can provide an error report to the person uploading the csv file. I have no idea how to test for the existance of the structure for each item i want to test, i create the array first, then i will check each type of field, but i dont want to issue a cfset errorArray[#rowid#]=StructNew() if one is already created. cffunction name=ValidateCSV returntype=array cfargument name=rowid cfargument name=medicarenumber cfargument name=firstname cfset errorArray=ArrayNew(1) ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
Rather than putting the error structure into an array, why not use a structure? Then rather than having an array whuch is mostly empty you'll have a structure which only contains errors. so rather than errorsArray[rowNumber] = stError; you could do errorsStructure[rowNumber] = stError; does that makes sense? or did i misunderstand what you're doing? Cheers Bert On Thu, 02 Dec 2004 08:31:16 -0400, Brant Winter [EMAIL PROTECTED] wrote: if there is an error put the errored text in a structure in an array, the array index will be relevant to the current row id of the query i am looping, and there will be a structure of the errors in each array element ( if that makes sense ) Bert - I think that is I have 24 fields per row, if I have multiple errors per row they wont be able to be written as a group of errors if you know what i mean ? What I want is an array with the row number as the element number, and in that a structure that may have 24 elements in total. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185918 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
set stAllMyErrors = StructNew() loop through each row set tmpErrStruct = StructNew() loop through the columns if this column is bad set tmpErrStruct[columnname] = 'there was an error in this column' /if /loop if NOT structIsEmpty(tmpErrStruct) set stAllMyErrors[thisrow] = tmpErrStruct /if /loop Then stAllMyErrors should contain a structure of any errors for each row which had an error, and nothing else. Yes? No? Bert On Thu, 02 Dec 2004 09:15:05 -0400, Brant Winter [EMAIL PROTECTED] wrote: Bert - I think that is I have 24 fields per row, if I have multiple errors per row they wont be able to be written as a group of errors if you know what i mean ? What I want is an array with the row number as the element number, and in that a structure that may have 24 elements in total. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185920 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
The following code is pretty much doing what I need, but I am not sure how to call it from my code. Basically I read in a CSV file using the following line of code: cfhttp url=20041202_4.csv name=qGetScripts method=GET timeout=40 delimiter=, textqualifier=/cfhttp ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185922 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
The following code is pretty much doing what I need, but I am not sure how to call it from my code. Basically I read in a CSV file using the following line of code: cfhttp url=20041202_4.csv name=qGetScripts method=GET timeout=40 delimiter=, textqualifier=/cfhttp ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185923 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
My example code is being truncated from this list somehow. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185925 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Testing for existance of a Structure within an Array
My example code is being truncated from this list somehow. Prolly the hyphens... If you have -- (or a some other amount) in the code it cuts it. Make sure there isn't and the message isn't too long -- dc ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185928 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing
This is only a test Is this going to count to the final grade? I wish I'd know I would have studied more. larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Testing for file existence across domains
Why not just use CFHTTP to get the specific file?There's nothing saying that CFHTTP HAS to call an HTML page. Jim Davis _ From: Rick Dawson [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 8:27 PM To: CF-Talk Subject: Testing for file existence across domains I need to test for the existence of images that are on another web server based upon an ID number returned from a local SQL query. As an example, I need to see if 143231a - e.jpg exist on http://www.differentserverhere.com/photos/ if my query gives me the ID number of 143231. CFHTTP does not work well in this instance; I need to test for specific files and not just retrieve everything. I'd appreciate any help y'all can give me - if I'm not clear, let me know. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Testing for file existence across domains
Why not just use CFHTTP to get the specific file?There's nothing saying that CFHTTP HAS to call an HTML page. Jim Davis Hi Jim, I need to test for the existence some properties will have more than 8 images (those I can get all eight just fine), and some will have anywheres from none through 8. I only want to display images if they are present, and not resort to using a 1-pixel gif as a substitute if there is no image. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Testing for file existence across domains
Does the remote server have any scripting/CGI abilites or is it running something like PERL, ASP, JSP, CF?If so, you could simply have the remote server check for you.All you would have to do is tell it which files to check in a list.Does the remote server have FTP access?If so, you could use that to check for file existence as well without having to initiate separate connections for each file. On Fri, 16 Jul 2004 20:31:32 -0500, Rick Dawson [EMAIL PROTECTED] wrote: Why not just use CFHTTP to get the specific file?There's nothing saying that CFHTTP HAS to call an HTML page. Jim Davis Hi Jim, I need to test for the existence some properties will have more than 8 images (those I can get all eight just fine), and some will have anywheres from none through 8. I only want to display images if they are present, and not resort to using a 1-pixel gif as a substitute if there is no image. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
