Re: Form in CFWINDOW - currently CHEATING to get parent to refresh...
If my understanding is correct, and if you can launch the editing window with regular js call, then, as suggested, use opener, and DOM method, it's very easy to update the corresponding data in the parent window, I just did, less than 3 minutes if we deducted my typo error, typical me... FYI, with IE, I don't have to do this, just inline editing... but FF has its advantage too... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ssot: Ext window customization
I posted a gig to cf-jobs several days ago for an expert in Ext, got some responses, however, none of them knows Ext and CSS truly well to do the job, so, sorry have to bug this list for a bigger pool. I am able to customize an Ext window to some degree, however, I'm no expert in CSS, hence, to get it done quickly I'd like someone who's extremely well versed in both Ext (2x) and CSS to help me out for the little task of creating an Ext window that resembles cf8 window, fair compensation is negotiable, if you meet the bill shoot me an email don at yahoo do t com Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: alternative to cfwindow
Thanks, Cutter, I need to go a step above that with Ext. What I'd like to do is: launch two windows (one main with attribute show="true" and the other small one with attribute show="false") then upon certain event or its trigger, send one form element to the small window (its underlying cf script), then, run a query, change the attribute show to "true" and display data while main window stays open, so the small window sort is floating over the main one. Easy to do with cf8 but haven't found helpful resources to do the same with EXT. Currently I'm using ColdExt for window management, the starter question is, how to create an Ext js function similar to cf8's ColdFusion.navigate, which would submit the form, and then, I could reference the var for the small window and use the Ext method of show to display it, like varSmallWin.show(); Or alternatively, lauch main window, upon an event trigger launch the small window and send a form element to the small win and have it float over the main window. Much appreciated. Don ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RegExp puzzle
Great. Then would this [EMAIL PROTECTED] read: find everything other than A through Z, a through z, 0 through 9, and @, and %, and $ ? Thanks. Don Li --- Matthew Walker <[EMAIL PROTECTED]> wrote: > > > > > This will succeed if any white space, %, or # is > found. Is that what you > want? Watch > > > > -Original Message- > From: LI, Chunshen (Don) [mailto:[EMAIL PROTECTED] > Sent: Thursday, 23 October 2003 3:46 p.m. > To: CF-Talk > Subject: RegExp puzzle > > > > Hi, > > Some RegExp expertise would be appreciated. > > Goal: find nonstandard characters in the string no > matter where they appear. > Nonstandard characters include white space, %, # in > this case. > > > > output the whole str > -- in this case, it should return the str > > > Thanks. > > Don Li > > > > _ > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RegExp puzzle
Hi, Some RegExp expertise would be appreciated. Goal: find nonstandard characters in the string no matter where they appear. Nonstandard characters include white space, %, # in this case. output the whole str -- in this case, it should return the str Thanks. Don Li [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Data Visualization (OT?)
Hope not OT. Maybe, some one would label Data Visualization (DV) as a subset of Usability. Personally I would think DV stands on it own, anyway, that does not really matter. The point is, DV could probably help a lot in user's use of information. Here's a link to an impressive DV implementation (demo app), http://www.inxight.com/demos/st_demos/bestbuy_applet.html. Q1, has anyone done anything similar (function-wise) with CF + Flash Remote? If so, can I see some sample app(s)?; Q2, what might be a good and relatively inexpensive strategy to improve data output presentation with the assistance of DV in CF environment? Any papers, pointers and/or implementation would be greatly appreciated if any. Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137994 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
OT: recommendation of web site(s) for selling/auctioning apps/scripts etc.
>Hi, > > Sorry this is an OT but I guess some of you could > probably provide some lead/pointer to the question > in > the subject line. > > Thanks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
MVDB
Hello, I'm wondering if anyone has ever worked on a Multi-valued Database system like UniData from ROI. Thanks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
clustered processing?
Hi, It strucks me that there must be a way to do some sort of 'clustered' processing, which is sort of analogous to 'server clustering' if my basic understanding of 'server clustering' is correct. Hear this, one complex request (the request actually has several parts) needs an extremely complex query, now, is there any way to delegate 'each part' of a complex request to 'each process unit/script', then, make 'each process unit' return resultset to a common resultset unit? Or this sort of problem is usually adequately solved by CF servers clustering? Since I've never used server clustering I'm in the dark about that. Any ideas/thoughts? Thanks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
How would Flash work for this app?
Hi, I'm not a Flash user/developer but I 'imagine' Flash might be a great tool for solving the following problem. Here's the deal. Say, I have a simple Event visual application, key requirements: 1) list event inside a rec. box (about size of the box, default to 400w x 300h but if more than 30 events then the box should be expandable, sort of like re-sizable Window); 2) inside this box, when a user highlight/select an event, another box appears next to it with top position slightly below it, this new box contains all the participants of this event, functional feature for the box size etc. should be similar to the first one; 3) a line or arrow is automatically drawn to link the two boxes to further illustrate the event development. Is the above easy with Flash? If so, how about the ability to drag the second box (move it around when a user sees fit)? Thanks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
OT: selling blood
I'm ready to sell blood. Does anyone need any? Thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
TOT: any pointer to CF-related project?
Things are likely to go as I would expect, but for the moment I need an immediate project to keep light on, any pointer to CF-related immediate project would be very much appreciated. Li, Chunshen (Don) Maryland ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JDBC Driver problem with MS SQL Server 2000
My environment, CFMX Prof, Windows XP Pro OS, MS SQL
Server 2000 DB server.
The following query executes fine with Query Analyzer
and the query execution shows up fine by CF debugging,
however, I got the following annoying err msg, please
note, I must use column alias for referencing later,
and if I don't use column alias the JDBC driver seems
to be OK but how come? column alias is a simple
function with any DBMS, no reason JDBC driver fails to
support it. Any one shied some light? Thanks.
"Macromedia][SQLServer JDBC
Driver][SQLServer]Incorrect syntax near the keyword
'as'.
...
136 : set nocount on
137 : declare @obj varchar(150)
SQL stmt ommitted here
DATASOURCE XXXyyyZZZds
VENDORERRORCODE 156
SQLSTATE HY000
declare @obj varchar(150)
declare @col1 varchar(25)
declare @col2 varchar(350)
declare @col3 varchar(350)
declare @chkCols int
select @chkCols =
(select count(name)
from syscolumns
where id = 2137058649);
select @obj =
(select name
from sysobjects
where id = 2137058649);
select @col1 =
(select name
from syscolumns
where id = 2137058649
and colid = 1);
select @col2 =
(select name
from syscolumns
where id = 2137058649
and colid = 2);
select @col3 =
(select name
from syscolumns
where id = 2137058649
and colid = 3);
set nocount off;
if (@chkCols >= 3)
Begin
EXEC('select ' + @col1 + ' as col1, ' + @col2 + '
as col2, ' + @col3 + ' as col3 from ' + @obj + ' order
by ' + @col2);
End
else
Begin
EXEC('select ' + @col1 + ' as col1, ' + @col2 + '
as col2 from ' + @obj + ' order by ' + @col2);
End
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: give-away
Hi, Following is generic search tool for MS SQL Server -based database. Tested against SQL 7 and 2000. Should work for SQL 6.5 as well but would be good and fun to see testing result with 6.5. Assumptions for using the tool: the searchable database is a non-operational or non-transactional database if a large number of users are going to use the tool; many frequently searched columns should be indexed. Only requirements to make it work for you: 1. Make a directory called DONLI under your CF / CFMX CustomTags installation and copy 3 modules there 2. Place 4 or fewer cf framework files in your search application, of which, set some configuration parameters for your application: Minimal configuration * enter your datasource point to the database to be searched. Standard configuration: * enter your datasource point to the database to be searched; * table(s) to be excluded; * column(s) to be excluded a few more ... Sample application URL, http://68.32.61.40/datadata/ddSearch.cfm Drop me a line at [EMAIL PROTECTED] if you want source code. Welcome feedback. Li, Chunshen (Don) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Security Alerts for Windows OS
Folks, Checks your Windows OS, especially the services for possible security breach. I've requested permission to go into detail. Don Li, Chunshen (Don) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
TOT (Totally Off Topic): other prime CF community around? URL?
First my apology for TOT. I like this community a lot but I need to expand reach. Thanks. Don Li, Chunshen (Don) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Complex logic within CFFORM
CFQUERY named "getColumns" statement here. The following code works for CF generated "Required" attribute validation: #column_name#: The following more complex code won't: -- the IIF function can be embedded into the other stuff like field Help or not here ... Why? Secondly, there are two types of validations, 1) field required or not, msg responds to that; 2) field data_type, msg responds to that. But there's only one Message attribute. What's a good systematic way to address it? Thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Code Reuse
Code Reuse -- How to make a reusable component to provide more value to customers? Hope the topic is not OT. I'm not sure if Dr. Carma McClure's claim that "software reuse is the best answer to the decade-old software crisis" is all that accurate. But I'm a firm believer in code reuse, probably it's a common practice by many developers, and I'd like to do better in this area. The intention of this posting is to seek wisdom and ideas. It's necessary to revisit some key benefits of code reuse to put the subject matter into perspective without going into detail: * Increased developers' productivity by reducing development time; * Increased software quality (premise: reusable components are reliable and of good quality); * Reduced cost; * Improved software interoperability; * conducive to maintenance and future enhancements Despite all these great benefits code reuse faces a few formidable challenges. Chief among them, IMHO, Context Prediction. Allow me to use a specific case to demonstrate the challenge, SureFire, a reusable component, URL, http://68.32.61.40/datadata/ddSearch.cfm. This simple component lets one search for data against any user table of a given database (MS SQL Server -based in this case). Say, in one environment/context, the business may not want certain table or tables to be accessable/searchable by the application. Easy solution, the component has a mechnism to handle this situation and the component configuration is easy as well. Now, in another environment, the business does not want data in certain columns to be viewed by the application users. Again, the component has a little nice mechnism to handle that. OK, now, the third business environment's given database has all this cryptic column names like fn, ln for firstName and lastName respectively, again, no problem, the component can address the semantic problem adequately. Now, the real challenge, it seems to me, is the enormous difficulty of adapting to many different usage contexts (failure to anticipate possible usage context(s)). How could a developer possibly do better in this area? Let's use the particular case when referencing concept(s). BTW, I read a bit on domain analysis by SEI, though informative, I can't extract practical value or to be more accurate, apply it to this case. Aother less important thing, can we consider the above mechnisms as "adaptable architecture"? Your thoughts and ideas would be appreciated. Li, Chunshen (Don) [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Interface Assessment
Hi, The subject matter is new to me and I'll make it short and "sweet?". So, I'll just throw out something raw, and pls help me to chew it. Major premise: I think it's more about Interface Usability Assessment, rather than functionality assessment. The way to tackle it is first to decompose all the components of the Interface, then each screen under each component. Question, would compoment A weigh more than component B? Would screen A weigh more than screen B? Yes? depending on each's contribution to system/application functionality? Consult with the client as well? What's the usual practice here? Secondly, what's the value of Interface Assessment if it is done without correlation to Functionality Assessment? A nice-looking house built on sand won't stand. Thanks. Li, Chunshen (Don) http://68.32.61.40/datadata/DataMan.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick search --- alway appreciate your thought
Hope this is not OT. For reasons that I don't know, I'm always interested in exploring ways to search for data, especially structured data, effectively and efficiently. Various search algothrithms exist and continue to evolve, to name a few, SLI, which seems powerful and yet it seems extremely resource-intensive as well. My view is, for non-gigantic databases, say, just a few GB, SQL alone is good enough. And I would say, a quick search utility like this one, URL, http://68.32.61.40/DataData/ddSearch.cfm would do the job (totally reusable, you may use other database/datasource), but I would appreciate input/thought(s) on scenarios that this approach is way more cost-effective than others and vice versa. I've explored hy-brid search mechnism a bit as well. Thanks. Li, Chunshen (Don) [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MM Survey Status
Hi, Does anyone know if MM's recent Survey is still open? Thanks. Li, Chunshen (Don) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Functionality, Usability and Pricing
I believe, the "Usability" thread all in all has produced some positive results thanks to almost everyone who responded, which I appreciated. Now, I'd like to go a step further. Forgive me if you perceive the topic OT. Functionality IMHO, an application or utility must be able to accomplish what it is intended to do. That is the number one important objective. Secondly, reliability or consistency, the application/utility must not behave one way one day and another way another day unless intended. Third, efficiency, an application can't take forever to excute. Fourth and fifth, scalability and flexibity, I would think the order of importance for them would depend on situation/scenario. Usability Per thread, http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=25404&forumid=4 Question, what might be a quick way to measure the above two attributes? Say, use the data admin tool for an example, URL, http://68.32.61.40/datadata/DataMan.cfm Email me ([EMAIL PROTECTED]) for full features like semantic layer, data duplication check mechnism, file upload etc. Pricing What is THE most important determinant for it? Thanks. Li, Chunshen (Don) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Usability
This is not a new question, however, IMHO, it won't hurt to talk about it again. In my view, some assumptions are made by developers when they think of an application's usability, for instance, for data validation, when a developer's help doc says something like "You need to enter an integer for this entry/field", the assumption is that the user knows what an integer is (any one who went to primary school knows what an integer is). Now, one may argue that "You need to enter some number for this entry/field" may sound easier to average user's ears. I would beg to disagree here. "Some number" could be 728, or it could be "728.25" while the later would fail because the data type is set to INT. Secondly, I think presentation and usability are closely tied together, and depending on the nature of the application, presentation may need to be highly polished or it need not to. For instance, a fancy car web site, presentation is certainly very important while a data admin application/utility for just two or three users does not need fancy presentation at all, e.g. http://68.32.61.40/datadata/DataMan.cfm What's your thought(s)? Li, Chunshen (Don) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
remote module call
Hi all, I thought some one mentioned that one can call a module remotely back a few years ago. Now, I'm revisiting this issue. I've reviewed the CFMODULE doc for CFMX and haven't found any info indicating that it can be done. One logical attempt was to call a local module with IP|localhost like However, the attempt failed. If this feature is available, it would be truly empowering, security can be addressed via CF Admin, to permit call from what what IP(s) and what not etc. I'd appreciate your thought(s) very much. Sincerely, Li, Chunshen (Don) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
People, I need your opinion!
Hello all, I have a little toy that I designed and developed within last few days (on and off, so, it's hours). I had some assumptions. Mainly data entry and data update types of data manipulation functions is essential to many businesses. So, if my assumption has some validity, some CF shops could save hell lots of time by using this toy for part of their project(s). Please take a look at it at URL, http://68.32.61.40/Test/admin_main.cfm URL parameter of demoDS would provide switch from one datasource to another, e.g. http://68.32.61.40/Test/admin_main.cfm?demoDS=publisherXYZ would switch the application (toy) to the classical publisher database albeit its design sucks. Notes: 1. navigation assistance could be improved; 2. usage documentation could be improved Thanks. Li, Chunshen (Don) your fellow CF developer living in hell for now! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about Datasources and connections
Mario, I'll be happy to assist offline if you send me more detailed problem description. Don Li --- "Ciliotta, Mario" <[EMAIL PROTECTED]> wrote: > Hi, > > I was wondering if anyone might be able to assist > me. I have been having problems lately with my CF > server returning the following error messages: > > Unable to instantiate environment for 'ORACLE80.' > Unable to instantiate environment for 'ODBC.' > > It seems to be happening more and more lately and I > have been unable to find a solution. I am currently > running Cf 4.5 on Windows NT. I use either or > Oracle or SqlServer depending on the application. I > can send more information if needed (like timeout > request and such as soon as get an admin to look > into the setting). I am just wondering what might > be causing these errors. > > I was told to use the Native Drivers for Oracle and > OLE-DB for my SQLServer connections. Is this > correct or should I be using ODBC for SqlServer. My > DBA's will not let me use ODBC for Oracle - only > native Drivers. > > Thanks in advance, > > Mario > > This message is for the named person's use only. It > may contain sensitive and private proprietary or > legally privileged information. No confidentiality > or privilege is waived or lost by any > mistransmission. If you are not the intended > recipient, please immediately delete it and all > copies of it from your system, destroy any hard > copies of it and notify the sender. You must not, > directly or indirectly, use, disclose, distribute, > print, or copy any part of this message if you are > not the intended recipient. CREDIT SUISSE GROUP and > each legal entity in the CREDIT SUISSE FIRST BOSTON > or CREDIT SUISSE ASSET MANAGEMENT business units of > CREDIT SUISSE FIRST BOSTON reserve the right to > monitor all e-mail communications through its > networks. Any views expressed in this message are > those of the individual sender, except where the > message states otherwise and the sender is > authorized to state them to be the views of any such > entity. > Unless otherwise stated, any pricing information > given in this message is indicative only, is > subject to change and does not constitute an offer > to deal at any price quoted. Any reference to the > terms of executed transactions should be treated as > preliminary only and subject to our formal written > confirmation. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Public Access To Wish List (was RE:__cffunction_arguments_"[und...)
I also like the concept. Along this line, I would think Bug Fixes should take higher priority than New Feature Requests or Enhancements. The fine line is that sometimes people have different perception of "bug" or "enhancement" from different position, a source of dispute. Learning from experience, personally I'd rather find a way to get around a problem myself than asking MM to fix it, this route seems more productive but not the best option. Oh, some categorization may also help. Don Li http://www.hegelsoftware.com --- Dave Carabetta <[EMAIL PROTECTED]> wrote: > >... does anyone on the list know if any of the > contents of the submissions > >to the wish-form are made public? Personally I > think it would be really > >nice > >to see just what has been suggested in a > url-accessible fashion, and have > >the ability for members of the CF community to > "vote" for a given wish-form > >item by logging in on the MM site, viewing the > wishform and hitting a > >button > >that says "yes, I think we need this". I think we > can largely trust the cf > >community that people won't be creating bogus MM > site logins just to fill > >the ballot box as it were. Plus -- it might also > make the wish-form easier > >for the folks at MM to manage if they simply sort > by votes descending, > >rather than having to wade through hundreds of > individual requests and > >match > >up the texts to say "okay, these 3 say roughly the > same thing"... > > I had asked Debbie Dickerson at MM a while about > this exact request, and she > had replied that there was no public access to the > existing wish list. She > said "It is something they're investigating for the > future though, so > hopefully it'll be a reality at some point!" > > Maybe somebody at MM could expand on what that may > or may not mean. Maybe > this feature will be a part of the re-designed MM > site that's rolling out > soon? I don't know. > > But I, too, think a system that you have proposed > would be immensely > beneficial not only to the developer community, but > to the employees at > Macromedia who have to wade through redundant > e-mails just to categorize > requests, let alone respond to them. > > Maybe this access could be a perk as part of a > DevNet subscription? (Just > spitballing there, but it's a thought, even though I > would imagine there > will be a negative reception to that suggestion) > > I will say, though, that I have made a few requests > via the URL that's > constantly posted here to the wish form, and MM has > always been courteous to > respond that they have received my request and are > considering its inclusion > in the next cycle. At least I know they're reading > the requests. Maybe I > just got lucky though!! > > Regards, > Dave. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Request for Comment
Greetings to all, First of all, I have to say, there are times that I may seem to be "a bull in chinashop", so, for that I want to hit myself in the head a couple of times :) Here's an ad hoc query tool designed and developed in Cold Fusion for MS SQL Server (7,2000), Oracle(8x and 9x) and IBM DB2 UDB (7x and 8x). Please take a look at URL, http://www.hegelsoftware.com/regURL.htm, and kindly let me know your thoughts and/or comments. If interested in advanced features such as multi-DBMSs, multi-dbs, semantic translation, XML, reporting, data dice/slice etc. drop me a line. Cheers, Don Li [EMAIL PROTECTED] http://www.hegelsoftware.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP: Installation of SQL Server 2000 under WinXP Professional
I've installed eval copy of SQL2000 on my XP Prof Edition without any problem. The account I used during installation belongs to "System administrator" group. Don Li --- Peter Tilbrook <[EMAIL PROTECTED]> wrote: > It does not appear to be the draconian measures > instilled by the > "Administrators" of our new work network install of > WinXp Pro. At the very > end of the SQL Server 2000 install (Personal > Edition) a permissions error is > encountered and the install fails. > > I've tried the install at home with the same result > (licensed XP and SQL > Server). > > Any ideas on how to get SQL Server 2000 installed > under XP Pro? This is > straight off the CD-ROM so I cannot even apply the > SP2 as yet. > > Grateful for any help - even though MySQL is good - > very good - our > production environment is SQL. > > Thanks! > > PT! > > == > Peter Tilbrook > ColdGen Pty. Ltd. > > http://www.coldgen.dns2go.com/ > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Inquiry
Thanks anyway, I thought it's him but he said "them", I have no idea who "them" are. --- "Hoffman, Joe (NIH/CIT)" <[EMAIL PROTECTED]> wrote: > No ... that is Mr. Dinowitz ... my email address is > not @houseoffusion.com. > > My counts are not official in any way ... just for > fun reference. > > Joe Hoffman mailto:[EMAIL PROTECTED] > National Institutes of Health > Center for Information Technology > Division of Computer System Services > > -Original Message- > From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 02, 2003 6:38 PM > To: CF-Talk > Subject: Re: And the award goes to > > > Hi Joe, > > Are you managing "CF-Talk" > <[EMAIL PROTECTED]> > list? Thanks. > > Don > > --- "Hoffman, Joe (NIH/CIT)" <[EMAIL PROTECTED]> > wrote: > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: And the award goes to ....
Hi Joe, Are you managing "CF-Talk" <[EMAIL PROTECTED]> list? Thanks. Don --- "Hoffman, Joe (NIH/CIT)" <[EMAIL PROTECTED]> wrote: > And for the most number of posts to > [EMAIL PROTECTED] by unique > email addresses out of 51,498 posts > ... the award goes to . > > Dave Watts [EMAIL PROTECTED] >1673 > > runners up include: > S. Isaac Dealey [EMAIL PROTECTED] >1121 > Jochem van Dieten [EMAIL PROTECTED] > 987 > Matt Liotta [EMAIL PROTECTED] > 901 > Mark A. Kruger - CFG[EMAIL PROTECTED] > 701 > Tony Weeg [EMAIL PROTECTED] > 681 > Sean A Corfield [EMAIL PROTECTED] > 678 > Stacy Young > [EMAIL PROTECTED] 635 > Raymond Camden > [EMAIL PROTECTED]613 > Jon Hall[EMAIL PROTECTED] > 594 > [EMAIL PROTECTED] > [EMAIL PROTECTED] 578 > Dick Applebaum [EMAIL PROTECTED] > 552 > Douglas Brown [EMAIL PROTECTED] > 549 > Jeffry Houser [EMAIL PROTECTED] > 477 > [EMAIL PROTECTED][EMAIL PROTECTED] > 470 > Paul Giesenhagen[EMAIL PROTECTED] > 437 > Bryan Stevenson > [EMAIL PROTECTED]437 > Matt Robertson [EMAIL PROTECTED] > 406 > Lee Fuller [EMAIL PROTECTED] > 343 > Alex[EMAIL PROTECTED] > 340 > > > Previous years results > -- > CF-talk posts for the year 2001 total 41,474 > > Dave Watts [EMAIL PROTECTED] 1,101 > Philip Arnold - ASP [EMAIL PROTECTED] 757 > Howie Hamlin[EMAIL PROTECTED] 451 > Jon Hall[EMAIL PROTECTED] 436 > Dylan Bromby[EMAIL PROTECTED] 425 > Bud [EMAIL PROTECTED] 394 > Michael Lugassy [EMAIL PROTECTED] 370 > Jeffry Houser [EMAIL PROTECTED] 349 > Thomas Chiverton[EMAIL PROTECTED] 332 > Michael Dinowit [EMAIL PROTECTED] 323 > Tony Schreiber [EMAIL PROTECTED] 306 > Raymond Camden [EMAIL PROTECTED]257 > Dick Applebaum [EMAIL PROTECTED] 253 > Bryan Love [EMAIL PROTECTED]233 > Russel Madere [EMAIL PROTECTED]221 > Jim McAtee [EMAIL PROTECTED] 220 > Jochem van Dieten [EMAIL PROTECTED] 204 > Duane Boudreau [EMAIL PROTECTED] 201 > Andy Ewings [EMAIL PROTECTED] 198 > Dave Hannum [EMAIL PROTECTED] 197 > > > CF-talk posts for the year 2000 total 48,444 > > [EMAIL PROTECTED]1,644 > > others in the top 20 are : > [EMAIL PROTECTED]517 > [EMAIL PROTECTED] 460 > [EMAIL PROTECTED] 426 > [EMAIL PROTECTED] 416 > [EMAIL PROTECTED] 399 > [EMAIL PROTECTED] 386 > [EMAIL PROTECTED] 365 > [EMAIL PROTECTED] 364 > [EMAIL PROTECTED] 355 > [EMAIL PROTECTED]322 > [EMAIL PROTECTED]307 > [EMAIL PROTECTED] 306 > [EMAIL PROTECTED] 302 > [EMAIL PROTECTED] 292 > [EMAIL PROTECTED] 290 > [EMAIL PROTECTED] 288 > [EMAIL PROTECTED] 279 > [EMAIL PROTECTED] 269 > [EMAIL PROTECTED] 266 > > By unique 'from' email addresses, not checked for > duplicates. > Preliminary ... probably final ... especially since > there > were no chads and I have never lived in Florida. > > > 1999 cf-talk 40,427 posts by email > > FromAddress Cnt > -- > [EMAIL PROTECTED] 833 > [EMAIL PROTECTED] 551 > [EMAIL PROTECTED]540 > [EMAIL PROTECTED]499 > [EMAIL PROTECTED] 477 > [EMAIL PROTECTED] 446 > [EMAIL PROTECTED]429 > [EMAIL PROTECTED] 387 > [EMAIL PROTECTED]369 > [EMAIL PROTECTED]363 > > > Joe Hoffman mailto:[EMAIL PROTECTED] > National Institutes of Health > Center for Information Technology > Division of Computer System Services > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Some idea about the Efficiency of UDFs
When I say "secretary", I meant it jokingly and implied, I would appreciate it if some else would do it, unfortunately taken literally. But Matt Liotta seems such a person that he prefers to refer others as objects "he is > interested in and he didn't submit a request for it. > " If you know my name use my NAME or you don't have to talk about me (I didn't ask you to). I don't like individuals belittling others. --- Jerry Johnson <[EMAIL PROTECTED]> wrote: > Typing too fast again. > > ,3,"#chr(10)#")> > > =) > > Jerry Johnson > > > > >>> [EMAIL PROTECTED] 01/02/03 02:37PM >>> > Does anyone else want to chip in for some panty > untwisters. > > They definitely seem needed. > > Jerry Johnson > > >>> [EMAIL PROTECTED] 01/02/03 02:13PM >>> > Um, no it's not. You just read on the mailing list > what feature he is > interested in and he didn't submit a request for it. > > Matt Liotta > President & CEO > Montara Software, Inc. > http://www.montarasoftware.com/ > 888-408-0900 x901 > > > -Original Message- > > From: Christian Cantrell > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, January 02, 2003 1:59 PM > > To: CF-Talk > > Subject: Re: Some idea about the Efficiency of > UDFs > > > > Well, it's hard for us to know that you are > interested in a feature if > > you don't submit a request for it. I don't > consider submitting > feature > > requests to be secretary work, so I'll be happy to > take care of it. > > > > Christian > > > > On Thursday, January 2, 2003, at 12:10 PM, Li > Chunshen ((Don)) wrote: > > > > > Christian, > > > > > > No, I didn't submit it (I don't like to be a > > > secretary), you please, no, you are not a > secretary > > > either :) for that may be part of your job. > > > Thanks. > > > > > > Don Li > > > > > > --- Christian Cantrell <[EMAIL PROTECTED]> > > > wrote: > > >> Good point. You could always call the other > > >> functions using the same > > >> routine that CFM pages would be expected to > use, but > > >> I can see where it > > >> would be easier (more maintainable) to keep > several > > >> functions in a > > >> single file. I have several functions that > call > > >> other functions, and > > >> many of them are only one or two lines, so I'm > sure > > >> it would get > > >> annoying having directories full of files with > > >> functions containing > > >> only a single line. The idea Jim proposed gets > > >> around this limitation > > >> nicely (dir.file.function). > > >> > > >> Thanks for the feedback, everyone. Li, did you > > >> submit this, or shall I? > > >> > > >> Christian > > >> > > >> On Thursday, January 2, 2003, at 09:34 AM, Ben > Doom > > >> wrote: > > >> > > >>> One thing to think about: CF probably > shouldn't > > >> require one and only > > >>> one > > >>> UDF per file. Occasionally it makes sense for > me > > >> to write UDFs that > > >>> call > > >>> other UDFs (either because the functionality > > >> already exists, will be > > >>> needed > > >>> elsewhere, or it just makes the 'main' UDF > easier > > >> to read) and I > > >>> generally > > >>> include those subroutines in the same file. > If I > > >> had to have a > > >>> separate > > >>> file for each, it would be rather confusing > IMHO. > > >>> > > >>> > > >>> -- Ben Doom > > >>> Programmer & General Lackey > > >>> Moonbow Software, Inc > > >>> > > >>> -Original Message- > > >>> From: Christian Cantrell > > >> [mailto:[EMAIL PROTECTED]] > > >>> Sent: Wednesday, January 01, 2003 6:01 PM > > >>> To: CF-Talk > > >>> Subject: Re: Some idea about the Efficiency of > > >> UDFs > > >>> > > >>> > > >>> Interesting idea. So how exactly would this > work? > > >> Would ColdFusion > > >>> expect one function per
CFMX / JDBC err while SQL Query Analyzer OK
A simple query against a SQL2000 database as follows: select top 10 OrderID,ProductID,UnitPrice,Quantity,Discount,Amount from [dbo].[Order Details] order by OrderID desc CFMX using JDBC for connection throws the following err: [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. while SQL Analyzer executes fine and returns expected resultsets. Data type: int(4), int(4), money(8), smallint(2), real(4), real(4) NULLABLE (only this column) SAMPLE DATA: 10248 11 14 12 0 168 10248 42 9.8 10 0 98 10248 72 34.85 0 174 10249 14 18.69 0 167.4 10249 51 42.440 0 1696 10250 41 7.7 10 0 77 10250 51 42.435 0.151261.4 What's going on? I'd like to make 'friends' with CFMX but CFMX doesn't seem to feel the same way, but we're in the same boat, so, we are stuck together now. Thanks. DL __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Some idea about the Efficiency of UDFs
Christian,
No, I didn't submit it (I don't like to be a
secretary), you please, no, you are not a secretary
either :) for that may be part of your job.
Thanks.
Don Li
--- Christian Cantrell <[EMAIL PROTECTED]>
wrote:
> Good point. You could always call the other
> functions using the same
> routine that CFM pages would be expected to use, but
> I can see where it
> would be easier (more maintainable) to keep several
> functions in a
> single file. I have several functions that call
> other functions, and
> many of them are only one or two lines, so I'm sure
> it would get
> annoying having directories full of files with
> functions containing
> only a single line. The idea Jim proposed gets
> around this limitation
> nicely (dir.file.function).
>
> Thanks for the feedback, everyone. Li, did you
> submit this, or shall I?
>
> Christian
>
> On Thursday, January 2, 2003, at 09:34 AM, Ben Doom
> wrote:
>
> > One thing to think about: CF probably shouldn't
> require one and only
> > one
> > UDF per file. Occasionally it makes sense for me
> to write UDFs that
> > call
> > other UDFs (either because the functionality
> already exists, will be
> > needed
> > elsewhere, or it just makes the 'main' UDF easier
> to read) and I
> > generally
> > include those subroutines in the same file. If I
> had to have a
> > separate
> > file for each, it would be rather confusing IMHO.
> >
> >
> > -- Ben Doom
> > Programmer & General Lackey
> > Moonbow Software, Inc
> >
> > -Original Message-
> > From: Christian Cantrell
> [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 01, 2003 6:01 PM
> > To: CF-Talk
> > Subject: Re: Some idea about the Efficiency of
> UDFs
> >
> >
> > Interesting idea. So how exactly would this work?
> Would ColdFusion
> > expect one function per file, with the requirement
> that the file and
> > the function have the same name? Then you could
> call any arbitrary
> > UDF, and the CF server would look in the proper
> directory for the right
> > file, then execute the function in that file. How
> else could this
> > work?
> >
> > Let's flesh it out a bit here, then I invite you
> to submit your idea to
> > Macromedia at the following URL:
> >
> >
>
http://www.macromedia.com/support/email/wishform/?6213=3
> >
> > Christian
> >
> > On Wednesday, January 1, 2003, at 04:40 PM, Li
> Chunshen ((Don)) wrote:
> >
> >> According to Macromedia's CFMX References on
> Using
> >> UDFs effectively:
> >>
> >> "Consider the following techniques for making
> your
> >> functions available to your ColdFusion pages:
> >>
> >> If you consistently call a small number of UDFs,
> >> consider putting their definitions on the
> >> Application.cfm page.
> >> If you call UDFs in only a few of your
> application
> >> pages, do not include their definitions in
> >> Application.cfm.
> >> If you use many UDFs, put their definitions on
> one or
> >> more ColdFusion pages that contain only UDFs. You
> can
> >> include the UDF definition page in any page that
> calls
> >> the UDFs. "
> >>
> >> I agree with everything it states, and I think it
> >> might help more if CFMX predefines a UDF library
> path
> >> such as UDFlib under CFMX installation instead of
> an
> >> arbitrary directory, I can see several benefits
> of
> >> this approach:
> >> consistency -- especially helpful for large
> >> development environment;
> >> easier for reuse -- across applications/projects
> >> (this one is similar to CFMODULE's dot notation
> >> method, I love it)
> >>
> >> And I don't see any downside of it. Thanks.
> >>
> >> DL
> >>
> >>
> >> --- Matthew Walker <[EMAIL PROTECTED]>
> wrote:
> >>> These two cfmx UDFs from cflib.org may help:
> >>>
> >>>
> >>>
> >>> function DSNExists(DSN) {
> >>> var factory =
> >>>
> >>
>
createObject("java","coldfusion.server.ServiceFactory");
> >>> var DSNs =
> >>> factory.getDataSourceService().getNames();
> >>> return
> >>> yesNoFormat(listFindNoCase(arrayToList(DSNs),
> >>> DSN));
> >>&
Re: Some idea about the Efficiency of UDFs
That's exactly what I have in my UDFlib directory and
my thought of how it may work but of course it's up to
MM to make it work as you described.
btw, you need to help me to push MM to fix some
problems as well, such as the Oracle8i driver and
request timeout. Matthew Walker's 2 UDF referrals are
interesting, however, they failed to solve the request
timeout problem.
Thanks.
DL
--- Christian Cantrell <[EMAIL PROTECTED]>
wrote:
> Interesting idea. So how exactly would this work?
> Would ColdFusion
> expect one function per file, with the requirement
> that the file and
> the function have the same name? Then you could
> call any arbitrary
> UDF, and the CF server would look in the proper
> directory for the right
> file, then execute the function in that file. How
> else could this work?
>
> Let's flesh it out a bit here, then I invite you to
> submit your idea to
> Macromedia at the following URL:
>
>
http://www.macromedia.com/support/email/wishform/?6213=3
>
> Christian
>
> On Wednesday, January 1, 2003, at 04:40 PM, Li
> Chunshen ((Don)) wrote:
>
> > According to Macromedia's CFMX References on Using
> > UDFs effectively:
> >
> > "Consider the following techniques for making your
> > functions available to your ColdFusion pages:
> >
> > If you consistently call a small number of UDFs,
> > consider putting their definitions on the
> > Application.cfm page.
> > If you call UDFs in only a few of your application
> > pages, do not include their definitions in
> > Application.cfm.
> > If you use many UDFs, put their definitions on one
> or
> > more ColdFusion pages that contain only UDFs. You
> can
> > include the UDF definition page in any page that
> calls
> > the UDFs. "
> >
> > I agree with everything it states, and I think it
> > might help more if CFMX predefines a UDF library
> path
> > such as UDFlib under CFMX installation instead of
> an
> > arbitrary directory, I can see several benefits of
> > this approach:
> > consistency -- especially helpful for large
> > development environment;
> > easier for reuse -- across applications/projects
> > (this one is similar to CFMODULE's dot notation
> > method, I love it)
> >
> > And I don't see any downside of it. Thanks.
> >
> > DL
> >
> >
> > --- Matthew Walker <[EMAIL PROTECTED]>
> wrote:
> >> These two cfmx UDFs from cflib.org may help:
> >>
> >>
> >>
> >>function DSNExists(DSN) {
> >>var factory =
> >>
> >
>
createObject("java","coldfusion.server.ServiceFactory");
> >>var DSNs =
> >> factory.getDataSourceService().getNames();
> >>return
> >> yesNoFormat(listFindNoCase(arrayToList(DSNs),
> >> DSN));
> >>}
> >>
> >>
> >>
> >>
> >> RETURNTYPE="boolean">
> >> >> REQUIRED="yes">
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>>> TYPE="JAVA"
> >>
> >> CLASS="coldfusion.server.ServiceFactory"
> >> NAME="factory">
> >>
> >>>> dsService=factory.getDataSourceService()>
> >>
> >>result=dsService.verifyDatasource(dsn)>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>> -Original Message-
> >>> From: Li Chunshen (Don)
> [mailto:[EMAIL PROTECTED]]
> >>> Sent: Wednesday, 1 January 2003 11:37 a.m.
> >>> To: CF-Talk
> >>> Subject: Request Time
> >>>
> >>>
> >>> specs: CFMX on WinXP Pro; remote datasources on
> >> Win2k
> >>> Pro.
> >>>
> >>> Requestimeout set to 40 seconds via CF admin
> >> (server
> >>> has been rebooted, my friend). Expect cf server
> >> to
> >>> throw requestimeout msg, better, gracefully,
> >>> regardless of the types of request. Problem,
> when
> >>> trying to connect to an unavailable remote
> >> datasource
> >>> (who can garanttee it's always available?),
> >> instead
> >>> of 40 seconds timeout, CFMX keeps on trying and
> >> trying
> >>> though asked otherwise, what's going on? With
> >> CF5, an
> >>> undocumented tag of Is_CFdatasource takes care
> of
> >> the
> >>> problem very well. Thanks.
> >>>
> >>> DL
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> __
> >>> Do you Yahoo!?
> >>> Yahoo! Mail Plus - Powerful. Affordable. Sign up
> >> now.
> >>> http://mailplus.yahoo.com
> >>>
> >>
> >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Some idea about the Efficiency of UDFs
According to Macromedia's CFMX References on Using
UDFs effectively:
"Consider the following techniques for making your
functions available to your ColdFusion pages:
If you consistently call a small number of UDFs,
consider putting their definitions on the
Application.cfm page.
If you call UDFs in only a few of your application
pages, do not include their definitions in
Application.cfm.
If you use many UDFs, put their definitions on one or
more ColdFusion pages that contain only UDFs. You can
include the UDF definition page in any page that calls
the UDFs. "
I agree with everything it states, and I think it
might help more if CFMX predefines a UDF library path
such as UDFlib under CFMX installation instead of an
arbitrary directory, I can see several benefits of
this approach:
consistency -- especially helpful for large
development environment;
easier for reuse -- across applications/projects
(this one is similar to CFMODULE's dot notation
method, I love it)
And I don't see any downside of it. Thanks.
DL
--- Matthew Walker <[EMAIL PROTECTED]> wrote:
> These two cfmx UDFs from cflib.org may help:
>
>
>
> function DSNExists(DSN) {
> var factory =
>
createObject("java","coldfusion.server.ServiceFactory");
> var DSNs =
> factory.getDataSourceService().getNames();
> return
> yesNoFormat(listFindNoCase(arrayToList(DSNs),
> DSN));
> }
>
>
>
>
>
> REQUIRED="yes">
>
>
>
>
>
>
>
>
>
>TYPE="JAVA"
>
> CLASS="coldfusion.server.ServiceFactory"
> NAME="factory">
>
>dsService=factory.getDataSourceService()>
>
>
>
>
>
>
>
>
>
>
>
>
> > -Original Message-
> > From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, 1 January 2003 11:37 a.m.
> > To: CF-Talk
> > Subject: Request Time
> >
> >
> > specs: CFMX on WinXP Pro; remote datasources on
> Win2k
> > Pro.
> >
> > Requestimeout set to 40 seconds via CF admin
> (server
> > has been rebooted, my friend). Expect cf server
> to
> > throw requestimeout msg, better, gracefully,
> > regardless of the types of request. Problem, when
> > trying to connect to an unavailable remote
> datasource
> > (who can garanttee it's always available?),
> instead
> > of 40 seconds timeout, CFMX keeps on trying and
> trying
> > though asked otherwise, what's going on? With
> CF5, an
> > undocumented tag of Is_CFdatasource takes care of
> the
> > problem very well. Thanks.
> >
> > DL
> >
> >
> >
> >
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> > http://mailplus.yahoo.com
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Request Time
Number One, the CF admin should overrule any specific setting(s) by script; Number two, what the heck, YES, this cfquery does have a timeout(40 seconds) set in case CF admin fails. However, in this situation both FAILS, FAILS. Thanks anyway. --- Rob Rohan <[EMAIL PROTECTED]> wrote: > I think you want a timeout on the > All your base, > Rob > > -Original Message- > From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 31, 2002 2:37 PM > To: CF-Talk > Subject: Request Time > > > specs: CFMX on WinXP Pro; remote datasources on > Win2k > Pro. > > Requestimeout set to 40 seconds via CF admin (server > has been rebooted, my friend). Expect cf server to > throw requestimeout msg, better, gracefully, > regardless of the types of request. Problem, when > trying to connect to an unavailable remote > datasource > (who can garanttee it's always available?), instead > of 40 seconds timeout, CFMX keeps on trying and > trying > though asked otherwise, what's going on? With CF5, > an > undocumented tag of Is_CFdatasource takes care of > the > problem very well. Thanks. > > DL > > > > > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Request Time
Unfortunately not. The following code hangs there
forever when a DS is not available, thanks anyway.
DS THERE
remote ds not available.
--- Matthew Walker <[EMAIL PROTECTED]> wrote:
> These two cfmx UDFs from cflib.org may help:
>
>
>
> function DSNExists(DSN) {
> var factory =
>
createObject("java","coldfusion.server.ServiceFactory");
> var DSNs =
> factory.getDataSourceService().getNames();
> return
> yesNoFormat(listFindNoCase(arrayToList(DSNs),
> DSN));
> }
>
>
>
>
>
> REQUIRED="yes">
>
>
>
>
>
>
>
>
>
>TYPE="JAVA"
>
> CLASS="coldfusion.server.ServiceFactory"
> NAME="factory">
>
> dsService=factory.getDataSourceService()>
>
>
>
>
>
>
>
>
>
>
>
>
> > -Original Message-
> > From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, 1 January 2003 11:37 a.m.
> > To: CF-Talk
> > Subject: Request Time
> >
> >
> > specs: CFMX on WinXP Pro; remote datasources on
> Win2k
> > Pro.
> >
> > Requestimeout set to 40 seconds via CF admin
> (server
> > has been rebooted, my friend). Expect cf server
> to
> > throw requestimeout msg, better, gracefully,
> > regardless of the types of request. Problem, when
> > trying to connect to an unavailable remote
> datasource
> > (who can garanttee it's always available?),
> instead
> > of 40 seconds timeout, CFMX keeps on trying and
> trying
> > though asked otherwise, what's going on? With
> CF5, an
> > undocumented tag of Is_CFdatasource takes care of
> the
> > problem very well. Thanks.
> >
> > DL
> >
> >
> >
> >
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> > http://mailplus.yahoo.com
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Request Time
specs: CFMX on WinXP Pro; remote datasources on Win2k Pro. Requestimeout set to 40 seconds via CF admin (server has been rebooted, my friend). Expect cf server to throw requestimeout msg, better, gracefully, regardless of the types of request. Problem, when trying to connect to an unavailable remote datasource (who can garanttee it's always available?), instead of 40 seconds timeout, CFMX keeps on trying and trying though asked otherwise, what's going on? With CF5, an undocumented tag of Is_CFdatasource takes care of the problem very well. Thanks. DL __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMX doesn't seem to like Oracle8 CLOB data
The one that came with CFMX, to use OCI native drivers for Oracle 8i I need to read some docs, do you know any good one other than that which comes with it? Thanks. --- Sean A Corfield <[EMAIL PROTECTED]> wrote: > Which Oracle driver are you using? The one that > ships with CFMX or a > newer one downloaded from Oracle Tech Net? If you're > using CLOB/BLOB > data extensively, I'd recommend looking into the OCI > native drivers for > Oracle 8i. > > On Friday, Dec 27, 2002, at 14:52 US/Pacific, Li > Chunshen ((Don)) wrote: > > > Hi folks, > > > > Here's the scoop, > > > > System info: > > CFMX Prof. Edition on WinXP Prof. machine accesses > a > > remote Oracle8 Database on Win2K Prof machine; the > > datasource connection has been tested to work; > CLOB > > enabled; Long Text Buffer (chr) > > is set to 64000; Allowed SQL: SELECT and SP. > > > > DB info: > > The Oracle table's CLOB column stores binary image > > file, which has been converted to Base64 > presentation > > with ToBase64 function before insertion; the > images > > size are all less than 64k; > > > > No problem with CF5 while > > Prob desc for CFMX: > > When the CLOB data is retrieved and attempted to > be > > converted back to original binary format with > toBinary > > function, CFMX throws an err, > > "The parameter 1 of function ToBinary, which is > now > > "/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJC > > .. (omitted) > > h86A3+N+s7v49/KQpyafj9jwoG/x/0dz8f/2Q==" must be a > > Base-64 encoded string." > > > > Hmmm, what's going on? Thanks. > > > > DL > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CFMX doesn't seem to like Oracle8 CLOB data
Hi folks, Here's the scoop, System info: CFMX Prof. Edition on WinXP Prof. machine accesses a remote Oracle8 Database on Win2K Prof machine; the datasource connection has been tested to work; CLOB enabled; Long Text Buffer (chr) is set to 64000; Allowed SQL: SELECT and SP. DB info: The Oracle table's CLOB column stores binary image file, which has been converted to Base64 presentation with ToBase64 function before insertion; the images size are all less than 64k; No problem with CF5 while Prob desc for CFMX: When the CLOB data is retrieved and attempted to be converted back to original binary format with toBinary function, CFMX throws an err, "The parameter 1 of function ToBinary, which is now "/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJC .. (omitted) h86A3+N+s7v49/KQpyafj9jwoG/x/0dz8f/2Q==" must be a Base-64 encoded string." Hmmm, what's going on? Thanks. DL __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Seemingly different interpretation of logic (CF5 vs. CFMX) = CFMX bug
The following CFMX Updater Release Notes reveals the problem: "A cfloop tag that looped over a query object incorrectly executed a single loop if the query returned an empty result set. 47733" I need to apply the Updater. --- "Li Chunshen (Don)" <[EMAIL PROTECTED]> wrote: > Chris, thanks for the catch, but NO, NO, it's one > of > the famous typos, the only thing/cause I can think > of, > this logic is embeded within a much larger one, > well, > I have a solution to it, however, everythere this > similar logic appears would have to be addressed as > well, bomber. Don > > --- Chris Montgomery <[EMAIL PROTECTED]> wrote: > > Howdy Li, > > > > Thursday, December 26, 2002, 8:16:01 AM, Li > Chunshen > > (Don) wrote: > > > > > > > >datasource="#request.ds#" > > > EXEC sp_getHim @param1='sdsd', > > @param2='sdsdsdfs' > > > > > > > You seem to be missing a closing '>' bracket in > your > > cfquery tag. Could > > that be it? > > > > -- > > Chris Montgomerymonty @ airtightweb.com > > Airtight Web Services http://www.airtightweb.com > > Web Development, Web Project Management, Software > > Sales > > 210-490-3249/888-745-7603 > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Seemingly different interterpretation of logic (CF5 vs. CFMX)
Chris, thanks for the catch, but NO, NO, it's one of the famous typos, the only thing/cause I can think of, this logic is embeded within a much larger one, well, I have a solution to it, however, everythere this similar logic appears would have to be addressed as well, bomber. Don --- Chris Montgomery <[EMAIL PROTECTED]> wrote: > Howdy Li, > > Thursday, December 26, 2002, 8:16:01 AM, Li Chunshen > (Don) wrote: > > > > >> EXEC sp_getHim @param1='sdsd', > @param2='sdsdsdfs' > > > > You seem to be missing a closing '>' bracket in your > cfquery tag. Could > that be it? > > -- > Chris Montgomerymonty @ airtightweb.com > Airtight Web Services http://www.airtightweb.com > Web Development, Web Project Management, Software > Sales > 210-490-3249/888-745-7603 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Seemingly different interterpretation of logic (CF5 vs. CFMX)
Do this or that ... I don't see any logical flaw with the above code, CF5 execute it well, but CFMX fails its logic, specifically at ... Any thoughts appreciated. Don Li __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CF50 and CFMX Co-existence Problem
Samuel, CF5 was already installed using IIS on port 8750. Yes, good point for development and testing, why not use the web server that comes with CFMX on port 8500, and yes, that got me to have CFMX partially working, the Java Plug-in, version 1.3.1_01 is no longer working, I've checked app mapping, JVM mapping, they all seem correct. Thanks. Don err mgs: Java(TM) Plug-in: Version 1.3.1_01 Using JRE version 1.3.1_01 Java HotSpot(TM) Client VM User home directory = C:\Documents and Settings\someUser Proxy Configuration: Manual Configuration Proxy: Proxy Overrides: 127.0.0.1, c: clear console window f: finalize objects on finalization queue g: garbage collect h: display this help message l: dump classloader list m: print memory usage q: hide console s: dump system properties t: dump thread list x: clear classloader cache 0-5: set trace level to java.lang.UnsatisfiedLinkError: getIDsOfNames at sun.plugin.javascript.ocx.JSObject.getIDsOfNames(Native Method) at sun.plugin.javascript.ocx.JSObject.invoke(Unknown Source) at sun.plugin.javascript.ocx.JSObject.call(Unknown Source) at coldfusion.applets.CFJsoWrapper.sendData(CFJsoWrapper.java:58) at coldfusion.applets.CFBaseApplet.setBrowserFormParam(CFBaseApplet.java:131) at coldfusion.applets.CFGridTableModel.forceFormVariableUpdate(CFGridTableModel.java:385) at coldfusion.applets.CFGridApplet.doEditModeFormVariableInit(CFGridApplet.java:185) at coldfusion.applets.CFGridApplet.init(CFGridApplet.java:139) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) --- "Samuel R. Neff" <[EMAIL PROTECTED]> wrote: > When installing CF5 and CFMX on the same box, > usually one would install CF5 > with IIS and CFMX standalone (using internal JRun > HTTP server) so CF5 is on > port 80 and CFMX is on port 8500. > > Are you trying to install both CF5 and CFMX to run > against the same > instance of IIS? Is there any reason why you are > opposed to using the > internal web server for CFMX (fine for development)? > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CF50 and CFMX Co-existence Problem
Folks, I bought a copy of CFMX Prof. Edition for Windows yesterday, and I'm having a hell time in getting it to work (first such experience in my whole life). My Windows XP Prof machine had a trial copy of CF5.0 running, and I'd like to keep it for some time, so, I chose to co-exist when asked during CFMX intallation process. The installation completed "successfully", I use IIS 5.1 as a web server, so, I verified my apps to see if .cfm file is mapped to JRUN, and yes, they are. However, the CF scripts failed to be executed by the CFMX server, err msg: A dynamic link library (DLL) initialization routine failed (when IE's friendly err msg was turned off) otherwise, HTTP 500 Internal Server Error. I've disabled the built-in web server at port 8500 via jrun.conf file, two changes of true and false per technote 23390 I've also read some other technotes, none seems applicable here. Any idea what's going/what's wrong? much appreciated. Don P.S.: I tried to re-install it by removing the original CFMX installtion, it did, but the preview now indicates it's an evalation copy, fine for now, I want to get it up and working first. P.S.2: CF50 seem not dead yet P.S.3: I had CFMX trial versiona installed as well, that was fine, and it peacefully co-existed with CF50. My guess is, the installation process (so-called shild) messed up. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Slightly OT: SQL VIEW gets out of sync??
I believe with SQL 7, each time when a view is created
('saved'), it saves and maps the underlying schema for
the view, hence, later on, if there's any schema
revision, e.g. a column is added, the new stuff (the
new column) won't be returned by the view.
At least that's the theory, I haven't tested it
myself.
Don Li
Hegel, LLC
http://www.hegelsoftware.com
--- Ben Doom <[EMAIL PROTECTED]> wrote:
> What DB?
>
>
>
> --Ben Doom
> Programmer & General Lackey
> Moonbow Software
>
> : -Original Message-
> : From: Les Mizzell [mailto:[EMAIL PROTECTED]]
> : Sent: Monday, December 16, 2002 2:18 PM
> : To: CF-Talk
> : Subject: Slightly OT: SQL VIEW gets out of sync??
> :
> :
> : Anybody ever seen this before...
> :
> : Got a View set up in a SQL Database using inner
> joins...which is then
> : displaying data on a CF page. View looks like:
> :
> : SELECT app_Master.*, app_register.*, app_1.*,
> app_2.*, app_3.*,
> : app_4.*, app_5.*
> : FROM dbo.app_Master INNER JOIN
> : dbo.app_register ON
> : dbo.app_Master.MSTR_UserID =
> dbo.app_register.Reg_UserID
> : INNER JOIN
> : dbo.app_1 ON
> : dbo.app_Master.MSTR_AppID =
> dbo.app_1.App1_AppID
> : INNER JOIN
> : dbo.app_2 ON
> : dbo.app_Master.MSTR_AppID =
> dbo.app_2.App2_AppID
> : INNER JOIN
> : dbo.app_3 ON
> : dbo.app_Master.MSTR_AppID =
> dbo.app_3.App3_AppID
> : INNER JOIN
> : dbo.app_4 ON
> : dbo.app_Master.MSTR_AppID =
> dbo.app_4.App4_AppID
> : INNER JOIN
> : dbo.app_5 ON
> : dbo.app_Master.MSTR_AppID =
> dbo.app_5.App5_AppID
> :
> : I'm not calling any specific fields in any
> tables
> :
> : All works fine until I go into a specific table in
> the SQL
> : Administrator any
> : add or change a row to the table. If I now look at
> my CF display
> : pagencalling the view, the displayed stuff will be
> "off" - say,
> : last name is
> : now displaying where the first name should be or
> something - the SQL View
> : has gotten data "out of sync" somehow.
> :
> : Only way I can fix it is to go back into the SQL
> administrator and resave
> : the view.
> :
> :
> : Ideas?
> :
> :
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
RE: _date feature in CF5.0, possibly CFMX as well
I would respectfully argue for the "worth the time to implement it" not because a large number of developers would have this problem but rather the assumption/oversight of server-side validation such as _date prefix that there won't be column name ending with _date has proven to be incorrect/clear. In addition, when CF is used to built software tool, the notion of "workaround", honestly, IMHO, not acceptable, for it seriously compromises code efficiecy. So, here, again, I was and am asking MM to remedy the server-side validation oversight. Thanks. Don Li P.S. 1. One of my postings related to this topic never showes up in the list; P.S. 2. In that particular posting, as I recall, I said something like, "I hope, you and other folks would be on my side to ask MM to ..." but later, the "I hope" did not appear in the quote, which made it sound like I demanded ... that was not the intention. --- "S. Isaac Dealey" <[EMAIL PROTECTED]> wrote: > Ahh... I suppose that could be done in the CF > Administrator... although I > doubt it's liable to be a high enough priority for > enough people to make it > worth the time to implement it. > > > s. isaac dealey, > > > I believe you misread my msg, I propose that MM to > > "Add enable/disable 6 server-side validation rules > via > > CFadmin, for backward compatibility, default to > > enabled", not to remove them. Thanks. > > > Don Li > > > --- "S. Isaac Dealey" <[EMAIL PROTECTED]> wrote: > >> >> > Considering that this behavior has existed > >> since CF > >> >> > 1.5, I think, I suspect it's unlikely to > change > >> any > >> >> > time soon. > >> >> > >> >> Your observation is true, however, you and > other > >> folks > >> >> will be on my side to push Macromedia to do > this > >> >> little thing for the good of this community. > >> > >> > I'd prefer that they fix existing bugs, > >> personally. This > >> > isn't something > >> > that I care about all that much, since I'm used > to > >> it. > >> > But, as Jochem said, > >> > feel free to submit this to the wishform. > >> > >> There are also still a number of applications > which > >> depend on this feature > >> -- it is a feature -- for server-side form > >> validation, and while it may be > >> mildly annoying on occasion for those of us who > >> don't use the feature, > >> personally I would rather deal with that minor, > >> occasional annoyance than to > >> be told that I must change large amounts of my > code > >> because a particular > >> feature has been arbitrarily removed from further > >> versions of the server. As > >> I say, I don't use it -- but I'd rather put up > with > >> the minor inconvenience > >> for the sake of the community at large than for > MM > >> to remove it just because > >> I don't use it. > >> > >> s. isaac dealey954-776-0046 > >> > >> new epoch > http://www.turnkey.to > >> > >> lead architect, tapestry cms > >> http://products.turnkey.to > >> > >> certified advanced coldfusion 5 developer > >> > > > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > >> > >> > >> > > > > ~~ > > ~~~| > > Archives: > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > > Subscription: > http://www.houseoffusion.com/cf_lists/index. > > cfm?method=subscribe&forumid=4 > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > Structure your ColdFusion code with Fusebox. Get > the > > official book at > http://www.fusionauthority.com/bkinfo.cfm > > > s. isaac dealey954-776-0046 > > new epoch http://www.turnkey.to > > lead architect, tapestry cms > http://products.turnkey.to > > certified advanced coldfusion 5 developer > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: _date feature in CF5.0, possibly CFMX as well
s. isaac dealey, I believe you misread my msg, I propose that MM to "Add enable/disable 6 server-side validation rules via CFadmin, for backward compatibility, default to enabled", not to remove them. Thanks. Don Li --- "S. Isaac Dealey" <[EMAIL PROTECTED]> wrote: > >> > Considering that this behavior has existed > since CF > >> > 1.5, I think, I suspect it's unlikely to change > any > >> > time soon. > >> > >> Your observation is true, however, you and other > folks > >> will be on my side to push Macromedia to do this > >> little thing for the good of this community. > > > I'd prefer that they fix existing bugs, > personally. This > > isn't something > > that I care about all that much, since I'm used to > it. > > But, as Jochem said, > > feel free to submit this to the wishform. > > There are also still a number of applications which > depend on this feature > -- it is a feature -- for server-side form > validation, and while it may be > mildly annoying on occasion for those of us who > don't use the feature, > personally I would rather deal with that minor, > occasional annoyance than to > be told that I must change large amounts of my code > because a particular > feature has been arbitrarily removed from further > versions of the server. As > I say, I don't use it -- but I'd rather put up with > the minor inconvenience > for the sake of the community at large than for MM > to remove it just because > I don't use it. > > s. isaac dealey954-776-0046 > > new epoch http://www.turnkey.to > > lead architect, tapestry cms > http://products.turnkey.to > > certified advanced coldfusion 5 developer > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: _date bug in CF5.0, possibly CFMX as well
--- Dave Watts <[EMAIL PROTECTED]> wrote: > > You mentioned about > > " > > > > UPDATE mytable > > SETOrderEntry_Date = > value="#Form.OrderEntryDate#" > > " > > But here, it's a SELECT statement, besides, > > Form.OrderEntryDate does not contain "_date". > > > SELECT OrderEntry_Date AS OrderEntryDate ... > > The problem is it compromises efficiency, yes, we know that a tbl_column can be aliased into tbl_colas, suppose, in this situation, say, we have to dynamically determine the table name, now, I have to SELECT CASE WHEN THEN ... or something to that nature MUCH LESS EFFECIENT code-wise. And for Macromedia, to add "enable/disable these six rules from CF ADMIN" it should be fairly easy to do, why not > > You said "So, again, this isn't a bug. If you > design > > a database schema for use with a CF application", > > the fact is, in lot of cases, databases are not > > designed for a particular client language, > database > > design is essentially based on business > requirements > > including business rules, it shouldn't and care > less > > what language will be used to interface with it. > > That's exactly what my argument was, one should > not > > attempt to "bend" a given database. > > That's true enough, but still not a big deal. You're > free to use one field > name in your database, and use another field name in > your HTML form. So, I > don't really see this as a serious problem - while I > generally would > recommend that you use the same names for your HTML > form fields as your > database columns, I'd make an exception in this > case. Well, making HTML form field name not to correspond with respective table column is a step toward 'misfortune'. > > Considering that this behavior has existed since CF > 1.5, I think, I suspect > it's unlikely to change any time soon. Your observation is true, however, you and other folks will be on my side to push Macromedia to do this little thing for the good of this community. Regards, Humble Don > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: _date bug in CF5.0, possibly CFMX as well
Dave, thanks for the response. But, here's the problem. You said "So, again, this isn't a bug. If you design a > database schema for use with a > CF application", the fact is, in lot of cases, databases are not designed for a particular client language, database design is essentially based on business requirements including business rules, it shouldn't and care less what language will be used to interface with it. That's exactly what my argument was, one should not attempt to "bend" a given database. You mentioned about " UPDATE mytable SETOrderEntry_Date = IMHO, the real solution to this problem/bug (one's free to argue that it's not a bug), is to set flag in CF admin, that can turn these six server-side validation rules on or off, preferably one by one. Thanks. Don --- Dave Watts <[EMAIL PROTECTED]> wrote: > > Long time ago, I found form field suffix with > _date > > would be ignored/unrecognized by CF5.0 either > using > > regular FORM submit or CFFORM submit. I may be > caused > > by the CFFORM's date type validation and > unwittingly > > extended to FORM as well. > > I let it slip for guessing other people would come > > cross it as well and report it, then, Macromedia > would > > issue a patch to fix it. So far, I'ven't heard of > > such a patch. > > > > No workaround, some database column ends with > _date, > > e.g. OrderEntry_Date, which is totally normal and > > common, and one is not supposed to change a given > > database's structure, some one argues that a > column > > name should not contain "_" (underscore), I think > > that's nonsense, it does not break any > normalization > > rules. > > > > Folks, correct me, if I'm wrong. > > This isn't a bug, and doesn't have anything to do > with CFFORM validation. > Within any HTML form, there are some reserved > suffixes for use with CF's > built-in server-side validation rules. The suffix > "_date" is one of them. If > you name a form field "dob" (for "date of birth"), > say, and you want to > enforce the entry of only date values, you could add > a hidden form to your > field called "dob_date": > > Date of Birth: > > > > So, again, this isn't a bug. If you design a > database schema for use with a > CF application, you may want to avoid the use of > field names that end with > "_date" or any of the other six validation rule > suffixes. Or, if you're > determined to use those field names, you simply have > to deal with it in your > SQL statements: > > > UPDATE mytable > SETOrderEntry_Date = value="#Form.OrderEntryDate#" > ..> > WHERE ... > > > I'm pretty sure this is listed somewhere within the > documentation, as well. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
_date bug in CF5.0, possibly CFMX as well
Long time ago, I found form field suffix with _date would be ignored/unrecognized by CF5.0 either using regular FORM submit or CFFORM submit. I may be caused by the CFFORM's date type validation and unwittingly extended to FORM as well. I let it slip for guessing other people would come cross it as well and report it, then, Macromedia would issue a patch to fix it. So far, I'ven't heard of such a patch. No workaround, some database column ends with _date, e.g. OrderEntry_Date, which is totally normal and common, and one is not supposed to change a given database's structure, some one argues that a column name should not contain "_" (underscore), I think that's nonsense, it does not break any normalization rules. Folks, correct me, if I'm wrong. Don __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: OT: DB - CF - Treeview
Paul, If it's MS SQL Server -based (7 or 2000)or if you're willing to export/upgrade to SQL Server, we should talk. The only thing is relational tables and tree? hmm, I don't know. Thanks. Don Li Hegel, LLC http://www.hegelsoftware.com --- "Paul E. Cross" <[EMAIL PROTECTED]> wrote: > Can someone help me, and yes, I'll pay?!. I want an > Access database that I > can edit that contains link information. Pretty much > a representation of the > Windows favorites directory. > > I want to query it and represent the information in > an explorer- like > treeview menu. A database driven tree structure as > discussed by these guys > in experts exchange: > > http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20120662.html > > Seen a working example? Have one you wanna give or > sell, point me to, etc. > Please? > > --Paul Cross > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CF Studio like free editor and CFGRAPH with CF50
Thanks, Robertson-Ravo and Josh. I'll skip the editor thing for now. An immediate, pressing problem: Cfgraph does not display graph (it seems jrun configuration and IIS configuration mismatch something). Here is the configuration scoop. * CF50 * Windows XP Pro * IIS 5.1 JRunScripts --> using CF5.0 jrun (I had CFMX) * JRun server = ColdFusion Management Repository Server (jrun-cfam-config file indicated so) * CFgraph fileFormat = jpg Error: graph/image not found(or not generated) image property revealed (http://127.0.0.1:8723/CFGraphingPage.cfm?Action=GetGraph&GraphFile=/cfgraphs/bar.swt&Key=-... well, 1) couldn't find "CFGraphingPage.cfm" anywhere? is it generated on demand? 2) current directory URL prefix is http://127.0.0.1:8723/thisDir, so, even if CFGraphingPage.cfm is generated on demand, should it be located at /[current directory]/CFGraphingPage.cfm? As for cfgraphs/bar.swt, it's under [CF_ROOT_DIR] I've looked at CF admin, can't tell, what would be a worthy try? Thanks. DL --- Josh Trefethen <[EMAIL PROTECTED]> wrote: > Bummer, works great for me... > > -- > Josh Trefethen > > :[ Exciteworks, Inc ]::[ http://exciteworks.com > ]:. > ::[ cf hosting on linux ]::[ consulting ]::[ > expertise ]::. > > > -Original Message- > From: Robertson-Ravo, Neil (REC) > [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 18, 2002 2:01 AM > To: CF-Talk > Subject: RE: CF Studio like free editor? > > > I have found this to be very unstable with JRE > 1.4.1. It crashes both > Windows XP and 2000 when you exit the application. > > > > -Original Message- > From: Josh Trefethen > [mailto:[EMAIL PROTECTED]] > Sent: 17 November 2002 01:33 > To: CF-Talk > Subject: RE: CF Studio like free editor? > > > You should try Jedit -- look at www.jedit.org and > www.joshuasmiller.com/jedit > > -- > Josh Trefethen > > :::::[ Exciteworks, Inc ]::[ http://exciteworks.com > ]:. > ::[ cf hosting on linux ]::[ consulting ]::[ > expertise ]::. > > > -Original Message- > From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] > Sent: Saturday, November 16, 2002 3:50 PM > To: CF-Talk > Subject: CF Studio like free editor? > > > Probably, I'm going to buy a copy of HomeSite soon > (for lack of alternatives), (HomeSite eval has > expired), but before that, I'd like to try some CF > Studio like free editor naturally without CF end TAG > insertion? Does any one know anything like that > exist? Thanks. > > DL > > > > __ > Do you Yahoo!? > Yahoo! Web Hosting - Let the expert host your site > http://webhosting.yahoo.com > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CF Studio like free editor?
Probably, I'm going to buy a copy of HomeSite soon (for lack of alternatives), (HomeSite eval has expired), but before that, I'd like to try some CF Studio like free editor naturally without CF end TAG insertion? Does any one know anything like that exist? Thanks. DL __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Seeking potential business alliance
Sorry, meant to sent to Tony Weeg only. --- "Li Chunshen (Don)" <[EMAIL PROTECTED]> wrote: > Hi Tony, > > I notice you're also Maryland-based. Could you take > a > look at my company's web site to see there's some > possibility for complimentary business relationship > when you have a chance? Thanks. > > Don Li > Hegel, LLC > http://www.hegelsoftware.com > 10 N. Calvert Street, Suite 102 > Baltimore, MD 21202 > 410-783-4949 > > > --- Tony Weeg <[EMAIL PROTECTED]> wrote: > > clint. > > > > this is the opposite of what he wanted, > > and doesn't make sensecheck your logic :) > > > > > no records found > > > display records > > > > > should be > > > > > display records > > > none to show > > > > > Happy Halloween Everyone! > > > > ..tony > > > > Tony Weeg > > Senior Web Developer > > Information System Design > > Navtrak, Inc. > > Fleet Management Solutions > > www.navtrak.net > > 410.548.2337 > > > > > > -Original Message- > > From: Clint Tredway > > [mailto:ctredway@;fishermenstudios.com] > > Sent: Thursday, October 31, 2002 8:30 AM > > To: CF-Talk > > Subject: RE: basic question - testing for no > reuslts > > from query > > > > > > > no records found > > > display records > > > > > HTH > > > > -Original Message- > > From: Tim Laureska [mailto:hometeam@;goeaston.net] > > Sent: Thursday, October 31, 2002 7:27 AM > > To: CF-Talk > > Subject: basic question - testing for no reuslts > > from query > > > > > > I'm ashamed to say I've been banging my head on > this > > for an hour. what > > is a simple way to code a statement that displays > a > > message when a query > > produces no results.. like: > > > > > > NO RESULTS > > > > #RESULTS# > > > > I'm looking for what the "blah, blah" would be?? > > > > Tim Laureska > > > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Seeking potential business alliance
Hi Tony, I notice you're also Maryland-based. Could you take a look at my company's web site to see there's some possibility for complimentary business relationship when you have a chance? Thanks. Don Li Hegel, LLC http://www.hegelsoftware.com 10 N. Calvert Street, Suite 102 Baltimore, MD 21202 410-783-4949 --- Tony Weeg <[EMAIL PROTECTED]> wrote: > clint. > > this is the opposite of what he wanted, > and doesn't make sensecheck your logic :) > >no records found >display records > > should be > >display records >none to show > > Happy Halloween Everyone! > > ..tony > > Tony Weeg > Senior Web Developer > Information System Design > Navtrak, Inc. > Fleet Management Solutions > www.navtrak.net > 410.548.2337 > > > -Original Message- > From: Clint Tredway > [mailto:ctredway@;fishermenstudios.com] > Sent: Thursday, October 31, 2002 8:30 AM > To: CF-Talk > Subject: RE: basic question - testing for no reuslts > from query > > >no records found >display records > > HTH > > -Original Message- > From: Tim Laureska [mailto:hometeam@;goeaston.net] > Sent: Thursday, October 31, 2002 7:27 AM > To: CF-Talk > Subject: basic question - testing for no reuslts > from query > > > I'm ashamed to say I've been banging my head on this > for an hour. what > is a simple way to code a statement that displays a > message when a query > produces no results.. like: > > > NO RESULTS > > #RESULTS# > > I'm looking for what the "blah, blah" would be?? > > Tim Laureska > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Anybody want to start a petition for CF Studio!
Last word on CF Studio, yes, Homesite's functionality is very much similar to that of CF Studio. Probably Macromedia's rationale for merging CF Studio and Homesite into one was to have a broader user community for this tool, however, I think a lot of us who love CF Studio really miss it, and I agree with another CFer that it would have been nice if MM had lent its ears, at this point, probably it would be easier to move forward with what's out there. Don Li (a long long time CFer since version .9?) http://www.hegelsoftware.com __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: what sites/forums CFO, CIO frequently visit?
Thanks. My apology, for off topic. Don Li __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
