How to get several resultsets from SP
Hi all I need to know dynamically the number(and metadata) of resultsets returned after executing a Stored Procedure. I'm using CF MX 6 and SQL Server. With CF I can do that? Any tips? Factory methods? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Version control - how to?
Does anybody have any suggestions for somebody who's never used any source control? We use DW8 as our primary IDE, CF 6.1 in dev/prod server. Subversion is a good application? Works in WindowsXP and CF/IIS(without Apache) with application server? Any example with this settings? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236212 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
threerelatedselects - do you can help?
I was wondering if anyone had a fixed version of the custom tag, ThreeSelectsRelated. The copy that I have doesn't work properly with the default values when using with edit mode forms. Only the value of default1 work. I've been banging my head and pulling my hair out trying to get it to work, but no go. Thanks in advance for your help. MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235645 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Converting application.cfc to application.cfm
Hi all I'm testing stickyCache, a very nice encapsulate model build by Nic Tunney. Your link: http://www.nictunney.com/stickyCache.cfm. stickyCache uses application.cfc to manage your session, init cache.cfc and facade.cfc and so on. Great. Works fine in my dev machine with CF 7. But our prod server haves CF MX 6.1. My simple question: how to convert an application.cfc to application.cfm? Any suggestions? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234463 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT - RegEx gurus - help
Hi all sorry for OT but I need your help RegEx gurus. In my form users can insert a field with this pattern: A|1-3|-B|C|D In resume can insert ? A or A1B or A2B or A3B or A1C, A2C, A3C, A1D, A2D, A3D, A1E, A2E, A3E, AB, AC, AD, B, C, D Validating only letters work fine but that all combinations fail. Suggestions? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT - RegEx gurus - help
Thanx Chris.
Using your sample fails when user enters A6 or B6. Please look my code used
for client JS validation?
^([Aa]{1}[1-3]{0,1}[B-Eb-e]{0,1}|[B-Eb-e]{1})
Using RegEx Coach application works fine allowing only the correct chars.
But when inserting in CF template fails.
What's wrong?
Cheers
MD
2006/3/6, CF [EMAIL PROTECTED]:
Hi Michael.
sorry for OT but I need your help RegEx gurus.
As long as it's CF related, it is not OT. Just my $0.02 ;-)
In my form
users can
insert a field with this pattern:
A|1-3|-B|C|D
In resume can insert ?
A or
A1B or
A2B or
A3B or
A1C, A2C, A3C, A1D, A2D, A3D, A1E, A2E, A3E, AB, AC, AD, B, C, D
Validating only letters work fine but that all combinations fail.
OK. Start with letter A, followed bei 0 or 1 occurence of 1 though 3,
followed by 0 or 1 occurence of B through D. Correct?
Then the following reg exp. should do:
A([123]?)([BCD]?)
Best,
Chris
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234248
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT - RegEx gurus - help
Thanx Ben
We`re using CF 6.1 too |o-)
Using my regex pattern allows this entries-
A8 (incorrect)
C8 (incorrect)
A9B(incorrect)
A1-3B-E|B-E are the correct entry.
Any suggestion?
Cheers
MD
2006/3/6, Ben Doom [EMAIL PROTECTED]:
Michel Deloux wrote:
^([Aa]{1}[1-3]{0,1}[B-Eb-e]{0,1}|[B-Eb-e]{1})
Using RegEx Coach application works fine allowing only the correct
chars.
But when inserting in CF template fails.
It's working for me in a quick test on CF6.1 -- what version are you
using?
--Ben
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234259
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT - RegEx gurus - help
Thanx Chris and Ben
works fine now. After all your code is great. Simple and clear.
Cheers
MD
2006/3/6, Michel Deloux [EMAIL PROTECTED]:
Thanx Ben
We`re using CF 6.1 too |o-)
Using my regex pattern allows this entries-
A8 (incorrect)
C8 (incorrect)
A9B(incorrect)
A1-3B-E|B-E are the correct entry.
Any suggestion?
Cheers
MD
2006/3/6, Ben Doom [EMAIL PROTECTED]:
Michel Deloux wrote:
^([Aa]{1}[1-3]{0,1}[B-Eb-e]{0,1}|[B-Eb-e]{1})
Using RegEx Coach application works fine allowing only the correct
chars.
But when inserting in CF template fails.
It's working for me in a quick test on CF6.1 -- what version are you
using?
--Ben
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234266
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[SOT] RegEx question
Hi all. This is for RegEx gurus: look this example: (;*%3242432424;testing%%*%%from%%regex%*;) How to get all words inside the first (; and ;)? For this simple example will return *%3242432424;delete%%*%%from%%maçã%* Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SOT] RegEx question
;-) Thnx Claude. Great marketer! ;-) 2006/2/24, Claude Schneegans [EMAIL PROTECTED]: This is for RegEx gurus: This is for CF_REextract: 1. go to http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm 2, enter [^a-zA-Zçä]* in RE1 2. enter [^a-zA-Zçã]+|$ in RE2 3. enter *%3242432424;delete%%*%%from%%maçã%* in the sample text area; 4 click Test and see your words in the returned query. Note: I don't know if maçã is a word. Add all releveant characters in the brackets, depending on the language the words belong to. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233394 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SOT] RegEx question
Thanks Claude and Jacob. Works fine. Great job. Cheers MD 2006/2/24, Munson, Jacob [EMAIL PROTECTED]: Try this: cfset myStr = (;*%3242432424;delete%%*%%from%%maçã%*;) cfset reMatch = reFind((\(;)(.*?)(;\)),myStr,1,true) cfoutput Original: #myStr#br / Extracted: #Mid(myStr,reMatch.pos[3],reMatch.len[3])# /cfoutput -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Friday, February 24, 2006 9:26 AM To: CF-Talk Subject: [SOT] RegEx question Hi all. This is for RegEx gurus: look this example: (;*%3242432424;testing%%*%%from%%regex%*;) How to get all words inside the first (; and ;)? For this simple example will return *%3242432424;delete%%*%%from%%maçã%* [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233405 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX errs on Java class .isAuthenticated() method
Hi all It's possible to use .class file with CF MX 6.1? How can I do that? Cheers MD 2006/1/19, RADEMAKERS Tanguy [EMAIL PROTECTED]: -Original Message- Folks--- How do I get around this one? In my CFMX6.1 template I instantiate userObj from a Java User class used for authentication. I want to determine if authentication was successful so I use the Java class's .isAuthenticated() method which fails because MX thinks I'm trying to use the old CF5.0 isAuthenticated() function. Any ideas? Thanks.--- Rob if you have access to the java source, you can look into changing the method name. Otherwise, you could write a little java wrapper for your User class and then call that. Finally, you could mess about with the java reflection APIs from within CF (in theory... YMMV) /t ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Crimson is faster than Xerces?
What's the fastest and reliable XML Parser for CF? Crimson, Xerces? Using Crimson(default for CF 6.1) my script runs slowly. Using Xerces I'll see any improvement? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Creole/Propel for CF World
Hi all CF haves an alternative ORM framework like Propel(PHP)? Propel looks a very interesting framework. But what's Propel? The propel generator creates a class Book for you that has all getter and setter methods for storing and retrieving the data. If you wanted to insert a new book with a certain title into the database then in your php file you could write: $b = new Book(); $b.setTitle(Making things move); $b.save(); Please look this blog entry http://www.betriebsraum.de/blog/2006/01/28/killer-combination-amfphp-propel-and-creole Official website: http://propel.phpdb.org/trac/wiki/Users/Introduction Any comments will be very appreciated. Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230685 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
How to know if a DB is online
Hi all, do you have suggestions about how to know if a external DB is online? I'm using this simple script: cfsetting requesttimeout=500 cftransaction action=begin cftry cfquery name=blabla datasource=#app.DSN# select TOP 1 field from externalDB where 1=1 /cfquery cfcatch type=any Error - DB offline /cfcatch /cftry /cftransaction Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230573 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to know if a DB is online
Thanx Pete and John. That script works fine for me. Looking for improvements. Cheers MD 2006/1/27, John Beynon [EMAIL PROTECTED]: and that's not working? the admin API should be able to verify a DSN for you - if not the factory service can, jb. On 27/01/06, Michel Deloux [EMAIL PROTECTED] wrote: Hi all, do you have suggestions about how to know if a external DB is online? I'm using this simple script: cfsetting requesttimeout=500 cftransaction action=begin cftry cfquery name=blabla datasource=#app.DSN# select TOP 1 field from externalDB where 1=1 /cfquery cfcatch type=any Error - DB offline /cfcatch /cftry /cftransaction Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230582 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to know if a DB is online
Thnx James. Great Ben Forta!! Cheers MD 2006/1/27, James Holmes [EMAIL PROTECTED]: http://www.cflib.org/udf.cfm?ID=685 On 1/27/06, Michel Deloux [EMAIL PROTECTED] wrote: Thanx Pete and John. That script works fine for me. Looking for improvements. Cheers -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
When CF restart?
Hi all After restart a server all applications will wake up right? How to know when(MM/DD/ HH:mm:ss) a server restart? Or an application restart? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: When CF restart?
Thanx Adrian and Dave. What I need to know: when an application starts, one event will be run setting a variable. If CF controls(via applicationtimeout) the application time where I'll view this settings? In server scope? Factory? MD 2006/1/24, Dave Watts [EMAIL PROTECTED]: After restart a server all applications will wake up right? How to know when(MM/DD/ HH:mm:ss) a server restart? Or an application restart? Applications don't wake up until a user requests a page within the application. Server restarts are logged by CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: When CF restart?
And using CFMX 6.1. ;-) 2006/1/24, Dave Watts [EMAIL PROTECTED]: Thanx Adrian and Dave. What I need to know: when an application starts, one event will be run setting a variable. If CF controls (via applicationtimeout) the application time where I'll view this settings? In server scope? Factory? If you're using CFMX 7, you can use the onApplicationEnd event to mark when an application times out. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Sorting array
Hi all I have an array with elements like this: 1 02/03/2006||3||Seattle||20||ATT||o||Overwrite||390||20060203 2 02/07/2006||3||Seattle||20||ATT||a||Append||390||20060207 3 01/26/2006||6||Phoenix||20||ATT||o||Overwrite||390||20060126 I need to sort this elements in date format using the final variable(mmdd). The final result: 1 01/26/2006||6||Phoenix||20||ATT||o||Overwrite||390||20060126 2 02/03/2006||3||Seattle||20||ATT||o||Overwrite||390||20060203 3 02/07/2006||3||Seattle||20||ATT||a||Append||390||20060207 What do you suggest? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230008 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Sorting array
Thanx all! :-) QoQ is a great tip. I'll be using that. Cheers 2006/1/19, Michael Traher [EMAIL PROTECTED]: Hi Michel, Probably too obvious but if you have control of creating the array, would it be possible to just add the final field to the front on the array element and then arraysort should work. Mike T On 1/19/06, Michel Deloux [EMAIL PROTECTED] wrote: Hi all I have an array with elements like this: 1 02/03/2006||3||Seattle||20||ATT||o||Overwrite||390||20060203 2 02/07/2006||3||Seattle||20||ATT||a||Append||390||20060207 3 01/26/2006||6||Phoenix||20||ATT||o||Overwrite||390||20060126 I need to sort this elements in date format using the final variable(mmdd). The final result: 1 01/26/2006||6||Phoenix||20||ATT||o||Overwrite||390||20060126 2 02/03/2006||3||Seattle||20||ATT||o||Overwrite||390||20060203 3 02/07/2006||3||Seattle||20||ATT||a||Append||390||20060207 What do you suggest? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230021 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
The best CFC book is...
Hi all I'm an intermediate CF developer looking for(late 'cause CF 5 version) CFC books to learn how to work with components. Hal Helms wrote Discovering CFCs: ColdFusion MX Components. Do you recommend? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229611 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
isolating transaction - inside loops? or not?
Hi all, I`m developing an application with several table inserts/updates with relational data with. No problem. But I need your help about this: Please look this code: First query - father table: cfset CommitOK = true cftransaction action=begin cftry cfloop collection=#form# item=field CFIF Left(field,14) IS 'StatusConfirms' cfquery name=qryStatusFather datasource=#application.DSN# SET NOCOUNT ON IF EXISTS blablabla /cfquery /CFIF /cfloop cfcatch type=any cfset CommitOK = false /cfcatch /cftry cfif CommitOK bablabla xx Second query - child table: cfset CommitOK = true cftransaction action=begin cftry cfloop from=1 to=#ListLen(IDStatus)# index=i cfquery name=qryChangeStatus datasource=#application.DSN# UPDATE StatusTable ... cfquery /cfloop cfcatch type=any cfset CommitOK = false /cfcatch /cftry blablabla cftransaction COMMIT OR ROLLBACK My question: how to isolate in only one transaction thats 2 statements with unique cfloops? Using outside loop can degrade performance? Inside loops is the best choice? Thanx for your time. Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227794 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Reporting, listing with CF, Java and so on
Hi all I'm searching experiences about reporting or listing with CF. Html tables or Java reporting tools(like ReportMill)? CFReport is not available(I'm using CFMX 6.1). Give me your comment. Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226563 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Creating dynamically array variables
You're right Dave. Works fine now looking like this: session.forms[#FormVariable#][1] Cheers MD 2005/11/27, Dave Watts [EMAIL PROTECTED]: I need to create a dynamically variable inside this code: cfset FormVariable = Subject cfset form.fieldnames = ListSort(form.fieldnames,textnocase) cfloop list=form.fieldnames index=ThisItem cfif ThisItem is not fieldnames AND Len(Evaluate(ThisItem)) !--- HERE BEGIN THE TROUBLE--- cfset ArrayAppend(session.forms.[FormVariable][1],ThisItem) cfset ArrayAppend(session.forms.[FormVariable][2],Evaluate(ThisItem)) /cfif /cfloop Using that code CF 6.1 shows me this error: A CFML variable name cannot end with a . character. What's wrong? You can't use dot and array notation simultaneously. If you have a form variable called myname, you can refer to it as Form.myname or Form[myname], but not Form.[myname]. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Creating dynamically array variables
Hi all I need to create a dynamically variable inside this code: cfset FormVariable = Subject cfset form.fieldnames = ListSort(form.fieldnames,textnocase) cfloop list=form.fieldnames index=ThisItem cfif ThisItem is not fieldnames AND Len(Evaluate(ThisItem)) !--- HERE BEGIN THE TROUBLE--- cfset ArrayAppend(session.forms.[FormVariable][1],ThisItem) cfset ArrayAppend(session.forms.[FormVariable][2],Evaluate(ThisItem)) /cfif /cfloop Using that code CF 6.1 shows me this error: A CFML variable name cannot end with a . character. What's wrong? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225312 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Help system in CF
Hi all I'm looking for examples, tips, tricks, tutorials, ... about how to build a dynamic help system with CF. Data will be stored in DB and users can build the menu and related subjects. Any help will be very appreciated. Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224716 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFC - best practice - locks and so on
Hi all
I'm looking for comments about cfc instantiation and the best
practices for cflock.
Please look this code used in my application.
When user enters in application i call a cfc.
In application.cfm:
---BEGIN application.cfm---
cfif not isDefined('session.Instantiated')
cfset session.ComponentVar =
createObject(component,components.app).init()
cfset session.qryAllProducts = session.ComponentVar.getAllProducts()
several cfset with session variables related to all SELECT queries in cfc
/cfif
-END application.cfm--
In app.cfc:
---BEGIN app.cfc---
cfcomponent output=false
cfset init()
cffunction name=init access=public
cfreturn this
/cffunction
cffunction name=getAllProducts output=false access=public
hint=Get all products returntype=query
arguments list
cfquery name=qryAllProducts datasource=#application.DSN#
SELECT
FROM
Products
/cfquery
!--- query is loaded to session scope ---
cfset session.qryAllProducts = qryAllProducts
cfreturn session.qryAllProducts
/cffunction
several CRUD operations
/cfcomponent
END app.cfc-
- This(using cfc in session scope) is a best practice?
- Need cflock? Where?
- It's possible to optimize this application? How?
Any help will be very appreciated.
Cheers
MD
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222662
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT - Creating dynamically name field with JS
Great Bobby. Works fine now. After several tests our form works
properly. JS is a new world for me. Good job.
Cheers
MD
2005/10/24, Bobby Hartsfield [EMAIL PROTECTED]:
Sorry, I had to run out for a minute. I saw javascript/dynamic fields and
fired off an email. This seems to be a little more dedicated to what you
described and should get you going. (only tested in the latest versions of
IE and FF)
script
function popitup()
{
alert(Put the code to popup your calendar here);
}
function addBtn(incrementer)
{
//Create the button object
var Newbtn = document.createElement('button');
//Give the button a name (if it matters)
Newbtn.name = myBtn + document.getElementById('fldCounter').value;
//Add the text you want to display on the button
var NewbtnText = document.createTextNode('Click here and choose your
date');
//Add the text to the button
Newbtn.appendChild(NewbtnText);
//Add the onclick handler
Newbtn.onclick = popitup;
//Add little pzzazz to it
Newbtn.style.borderWidth = 1;
Newbtn.style.borderColor = #00;
Newbtn.style.backgroundColor = #ececec;
//Add the button to the page
document.getElementById('myContainer').appendChild(Newbtn)
//Add a couple line breaks
document.getElementById('myContainer').appendChild(document.createElement('b
r'));
document.getElementById('myContainer').appendChild(document.createElement('b
r'));
//Don't feel like this HAS to be a button. It could be an image or a
text link, or anything else you can think of.
document.getElementById('fldCounter').value =
Number(document.getElementById('fldCounter').value) + 1
}
/script
input type=hidden id=fldCounter name=fldCounter value=0
a href=javascript:void(0) onclick=addBtn();Add The Button/a
div id=myContainer
/div
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Monday, October 24, 2005 5:51 PM
To: CF-Talk
Subject: RE: SOT - Creating dynamically name field with JS
Look into the createElement() function. Works like a charm.
Here is some pseudo...
script
function addfld(incrementer)
{
//Build the form field
Newfld = document.createElement('input')
Newfld.type = text;
Newfld.name=mynewfield + incrementer;
document.getElementById('myContainer').appendChild(Newfld)
//Add a line break
document.getElementById('myContainer').appendChild(document.createElement('b
r'));
}
/script
a href=javascript:void(0) onclick=addfld('2')Add New Field/a
div id=myContainer
input type=text name=mynewfield1br
/div
Completely off the top of my head so im sure there are errors in it but
hopefully you get the idea.
Just look up createElement() and appendChild(). Let me know if you need
anymore help with it if you decide to go this way. I've got some pretty
cross browser friendly versions of it.
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Michel Deloux [mailto:[EMAIL PROTECTED]
Sent: Monday, October 24, 2005 4:55 PM
To: CF-Talk
Subject: SOT - Creating dynamically name field with JS
Hi all
sorry by OT but I need your help in JS.
I have a form with only one field. I'll like to present that field
with an option for insert more fields like that and/or exclude others
fields. This is my form:
form name=frm action=post
INPUT size=50 maxlength=20 name=datefield onKeyPress=return false;
SCRIPT language=javascript
document.write(input type=button
onclick='popUpCalendar(this,
frm.datefield, \mm/dd/\)' value='Click here and choose your
date')
/SCRIPT
/form
I tested several methods for include/exclude but I don't know how to
insert that popUpCalendar script inside new field with dynamic name
field.
What's wrong? How to create dynamically name field for my popUpCalendar?
Thanx for your time.
Cheers
MD
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:04
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
newbie question - Delete session variable - how?
Hi all
I have one simple form with this fields:
CFIF IsDefined('URL.a') AND URL.a IS e
!--- kill session vars---
cfset ThisItem=ListFind(ArrayToList(Session.Cart.Data),URL.data)
cfset StructDelete(Session,Cart.Data[ThisItem])
cfset StructDelete(Session,Cart.GroupID[ThisItem])
/CFIF
How to kill that Session.Cart.Data and Session.Cart.GroupID?
Thanx for your time
Cheers
MD
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:54
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT - Creating dynamically name field with JS
Hi all sorry by OT but I need your help in JS. I have a form with only one field. I'll like to present that field with an option for insert more fields like that and/or exclude others fields. This is my form: form name=frm action=post INPUT size=50 maxlength=20 name=datefield onKeyPress=return false; SCRIPT language=javascript document.write(input type=button onclick='popUpCalendar(this, frm.datefield, \mm/dd/\)' value='Click here and choose your date') /SCRIPT /form I tested several methods for include/exclude but I don't know how to insert that popUpCalendar script inside new field with dynamic name field. What's wrong? How to create dynamically name field for my popUpCalendar? Thanx for your time. Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222121 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFC - separate or all in one?
Hi all what's the best: separate functions/methods in several components or include all methods in a same component? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221711 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC - separate or all in one?
Thanx Barney. In resume: separate for concerned tasks is the best approach? This is THE OO approach, right? Cheers MD 2005/10/20, Barney Boisvert [EMAIL PROTECTED]: Depends on the component(s). Are the method closely related so as to comprise the behaviour of a single thing, or are they varied in nature? In general, you want each object to be concerned with a single specific task. How big that task is can vary greatly, of course. cheers, barneyb On 10/20/05, Michel Deloux [EMAIL PROTECTED] wrote: Hi all what's the best: separate functions/methods in several components or include all methods in a same component? Cheers MD = -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Using cfinclude with component
Hi all it's possible(recommended) to use cfinclude to include another cfc inside a cfc? I'm using this approach because that cfc is created for other team... Drawbacks? Cheers MD ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using cfinclude with component
YE... Extends!!! Great... Cheers MD 2005/10/18, newsight [EMAIL PROTECTED]: Use instead of including a cfc into a cfc the extends param. Than you can use all the functions of the other cfc. Cheers Artur -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 5:23 PM To: CF-Talk Subject: Using cfinclude with component Hi all it's possible(recommended) to use cfinclude to include another cfc inside a cfc? I'm using this approach because that cfc is created for other team... Drawbacks? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221339 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: URL Variables
You can encrypt newurl value and decrypt it in your action page. Simple and cool. Or use session vars to store that url vars. Cheers. MD 2005/10/18, B G [EMAIL PROTECTED]: Is this possible? I want to pass a string containing URL variables through a URL. For example: www.domain.com/page.cfm?newURL=www.domain.com/page2.cfm?var1=avar2=b In other words on page2.cfm I should reference #URL.newURL# outputs www.domain.com/page2.cfm?var1=avar2=b Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221393 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Invoking query and fails
Hi all
we have a form with simple fields. If session.nameofquery is not
defined I invoke a cfc to get that data. Looks like:
CFIF IsDefined('session.qryMyQuery')
cfdump var=#session.qryMyQuery#
cfoutput query=#session.qryMyQuery#
#ID_namebr /
/cfoutput
CFELSE
cfinvoke component=qryCFC method=getAllNames
/cfinvoke
cfdump var=#session.qryMyQuery#
/CFIF
This is my simple function:
cffunction name=getAllNames output=true access=public hint=Get
all names returntype=void
cfargument name=blablabla type=numeric required=no
cfquery name=session.qryListNames datasource=#application.DSN#
SELECT
blablabla
FROM
blablabla
/cffunction
OK, OK, the good CFC practices Manual don't uses session inside
components. Right. But using application scope don't work... ;-(
In the first call to CFC I invoke that cfc which output a query. But
after cfoutput CF throws an error:
Complex object types cannot be converted to simple values.
Why? That cfc returns a query right? Or I'me wrong?
Cheers
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219973
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Invoking query and fails
Thanx Tom and Taco for your help. Great, really!
By now works fine and I'll would show what I need to do:
In calling page:
CFIF IsDefined('session.qryListNames')
!---DEFINED PROPERLY---
cfoutput query=session.qryListNames
#CDUser#br /
/cfoutput
CFELSE
!---NOT DEFINED - YET---
cfinvoke component=components.qryNames method=getAllNames
returnvariable=qryListNames
/cfinvoke
cfset session.qryListNames = #qryListNames#
/CFIF
In CFC:
cffunction name=getAllNames output=true access=public returntype=query
cfargument name=CDUser type=numeric required=no
cfquery name=qryListNames datasource=#application.DSN#
SELECT foo
from foo
/cfquery
cfreturn qryListNames
/cffunction
After invoking my component with returnvariable in the same name
inside CFC works fine.
Cheers
MD
2005/10/3, Taco Fleur [EMAIL PROTECTED]:
Change the name and remove session.
Then add a return statement
cfquery name=qryListNames datasource=#application.DSN#
SELECT
blablabla
FROM
/cfquery
cfreturn qryListNames /
/cffunction
If you want to set the query in the session scope you should do that after
the call to the function, i.e.
cfset session.qryListNames = obj.getAllNames() /
Taco Fleur - Pacific Fox
an industry leader with commercial IT experience since 1994 .
http://www.pacificfox.com - Web Design and Development
We endorse PayPal, accept payments online now!
-Original Message-
From: Michel Deloux [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 4 October 2005 7:09 AM
To: CF-Talk
Subject: Invoking query and fails
Hi all
we have a form with simple fields. If session.nameofquery is
not defined I invoke a cfc to get that data. Looks like:
CFIF IsDefined('session.qryMyQuery')
cfdump var=#session.qryMyQuery#
cfoutput query=#session.qryMyQuery#
#ID_namebr /
/cfoutput
CFELSE
cfinvoke component=qryCFC method=getAllNames
/cfinvoke
cfdump var=#session.qryMyQuery#
/CFIF
This is my simple function:
cffunction name=getAllNames output=true access=public
hint=Get all names returntype=void
cfargument name=blablabla type=numeric required=no
cfquery name=session.qryListNames datasource=#application.DSN#
SELECT
blablabla
FROM
blablabla
/cffunction
OK, OK, the good CFC practices Manual don't uses session
inside components. Right. But using application scope don't
work... ;-(
In the first call to CFC I invoke that cfc which output a
query. But after cfoutput CF throws an error:
Complex object types cannot be converted to simple values.
Why? That cfc returns a query right? Or I'me wrong?
Cheers
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219985
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Call cfscript inside cfc - its possible?
Hi all It's possible to call cfscript functions(application.cfm's living) inside cfc component? I'm calling this function PrepareSearch and CF returns an error: Variable PrepareSearch is undefined. The error occurred in D:\Inetpub\wwwroot\ghost\components\qryGhost.cfc: line 40 38 :CFIF arguments.UserField is not 39 : 40 : #REReplaceNoCase(PrepareSearch(#arguments.UserField#,user),;,',All)# What's wrong? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Call cfscript inside cfc - its possible?
Thanks all. Works fine now. Do you know how? Simple. Raymond Camden answers for us: http://ray.camdenfamily.com/index.cfm?mode=entryentry=395FCD72-D363-A830-680B85D89C078C0A After create an utility cfc and insert: cfcomponent output=false cfset init() cffunction name=init access=public cfreturn this /cffunction cfscript function blablabla(path) /cfscript /cfcomponent and so on ...bingo! Now you can call all UDF inside utility with cfinvoke. Thanx Ray and all folks. Cheers MD 2005/9/26, Tony [EMAIL PROTECTED]: i do one of two things... http://www.revolutionwebdesign.com/blog/index.cfm?mode=entryentry=F198C61E-A5EF-DAA0-5EC6F1AB9C7357F7 or for the link impaired... http://www.antiwrap.com/?724 or, what i do, is refactor the udf, into a new component or function of the cfc im using, and then i have it to use as a cfc anyway :) tw On 9/26/05, Andy Matthews [EMAIL PROTECTED] wrote: You should be able to use any CF function inside a CFC. I think though that you might have it flipped around. Are you trying to use a custom function, which you have created, inside cfscript? If so, then as long as you've defined the function and instantiated it, you should be able to call it from anywhere on the page. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 2:41 PM To: CF-Talk Subject: Call cfscript inside cfc - its possible? Hi all It's possible to call cfscript functions(application.cfm's living) inside cfc component? I'm calling this function PrepareSearch and CF returns an error: Variable PrepareSearch is undefined. The error occurred in D:\Inetpub\wwwroot\ghost\components\qryGhost.cfc: line 40 38 :CFIF arguments.UserField is not 39 : 40 : #REReplaceNoCase(PrepareSearch(#arguments.UserField#,user),;,',All )# . What's wrong? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219305 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Logging users actions - DB or Log4J?
Hi all what's the best choice to store users actions in a CF application(inserts, updates and deletes)? DB or Log4J could be resolve this? Anyone use log4j? Any approaches? Cheers MD ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218706 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Logging users actions - DB or Log4J?
Thanks all. Using Michael example could be more robust because I can store what I want. Using trigger this is more hard to do, right? Michael do you can share that example using asinc gateway with us? Thanks all MD 2005/9/20, Michael Dinowitz [EMAIL PROTECTED]: I use an async process to log user information into a DB. Fast, effective and has 0 impact on a user session while still having the logs the way I want them (id for user agent, etc.) The only limitation is that you need an async process (enterprise), use a hack to CFMX 7 (http://www.fusionauthority.com/Techniques/Article.cfm/ArticleID:4503), use a web service with no wait or some other situation. If you want the code I'll send it over your way. I've been meaning to write a Fusion Authority article on it. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Converting DOCs to PDF with CF
Thnx Dave and Adam. Adam's suggestion may be more reliable and cheap. ;-) What I need to use COM and convert DOC to HTML? Cheers MD 2005/9/2, Adam Haskell [EMAIL PROTECTED]: WIth MX 7 you can do this pretty easily by converting the word file to HTML (through COM) then using cfdoc to put it into PDF Adam H On 9/2/05, Michel Deloux [EMAIL PROTECTED] wrote: Hi all it's possible to convert DOC and XLS files to PDF using CF MX? Aaron Johnson talks about Jakarta Project and POI to do that. Anyone have experience about? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Converting DOCs to PDF with CF
Hi all it's possible to convert DOC and XLS files to PDF using CF MX? Aaron Johnson talks about Jakarta Project and POI to do that. Anyone have experience about? Cheers MD ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217228 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Get double quotes string inside another string
Hi all please look this var: cfset mylist = 'Rob Munchen Robert Munchen RDM Testing string inside string more testing 'cause Fred Gregg Robinson' How to get strings inside double quotes(RDM Testing string inside string and Fred)? Using GetToken don't work. Any help? Cheers MD ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get double quotes string inside another string
Thanx Claude, Barney and S. Isaac. Why you're using BELL(chr(7)) char like separator for that list? Cheers MD 2005/8/30, S. Isaac Dealey [EMAIL PROTECTED]: Hi all please look this var: cfset mylist = 'Rob Munchen Robert Munchen RDM Testing string inside string more testing 'cause Fred Gregg Robinson' How to get strings inside double quotes(RDM Testing string inside string and Fred)? Using GetToken don't work. Any help? Cheers ListToArray(reReplace(mylist,'[^]*([^]*)',\1 chr(7)),chr(7)) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216821 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get double quotes string inside another string
Right... Great! Great! Thanks guys(especially S. Isaac). Works fine now. Cheers MD 2005/8/30, Claude Schneegans [EMAIL PROTECTED]: Oh I just have a habbit of using the bell character to delimit a list Ah ah: that rings a bell in my head! ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216845 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Listing directories and your size
Hi all We're using this sample structure to save all files for our client: -CA(Size: 3154.44KB - Sum of all cities) ---LA(Size: 3154.44KB - Sum of Marketing and Finance) --Marketing(Size: 2490.62KB) ---2005(Size: 264.43KB) ---meetings2005.pps(23.32KB) ---europe2005.doc(241.11KB) ---2004(size: 1562.37) ---meetings2004.pps(67.01KB) ---europe2004.doc(1180.08KB) ---japan2004.doc(230.17KB) ---nz_australia2004.doc(85.11KB) --Finance(size: 663.82KB) ---2005(Size: 663.82KB) ---government_presentations.xls(108.15KB) ---bills.xls(447.59KB) ---taxes.xls(108.08KB) What I need to do: show that structure(without the filenames) with Directory size using CF... Using cfdirectory list option it's possible to get the size of that father directory but how to do recursive scan and save the size of all son subdirectories? Cheers MD ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Replace accented chars with unaccented ones
Hi all. Our client is a canadian airplanes supplier with a multilanguage web site(french-Canada, english-USA, spanish-Mexico). For french and spanish site visitors users can provide info with accented chars. For USA clients users enter all char with unaccented chars because english language(keyboard) don't have any one accented char. I would like to replace accented chars (like é, è or à) with non accented ones (é - e, è - e, à - a) in our search script. When user enters Montréal I would like to find Montreal and Montréal in our DB. Any help? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215860 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
file size missing with CFFILE use
Hi all after upload files to our server 20% that files don't have file size properties saved to DB. Do you know why CFFILE file size is missing? Maybe using Java getSize directly could be resolve that? Cheers MD ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214860 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusebox, Mach-II, GlueCode... the Oscar goes to...
Ok, ok. It depends. Other question: framework and speed dev are the same thing? Or not? I believe(my point of view) that using frameworks make development harder to code. I'm right? It's possible to separate 100% between M V C? Thanx MD 2005/8/11, Barney Boisvert [EMAIL PROTECTED]: Same answer: it depends. In this case it depends on the dev team and their experience, whether you need a 100% separate between UI and application (for multiple UIs) or if a little (or a lot) fudging is ok, etc. There is rarely a simple answer. If you pick one framework and always use it, you'd doing yourself a great service. If you want to go the next step and be familiar with several and pick the best one for each project, that's even better. But don't try the latter without a legitimate investigation of the pros and cons of each framework, including building at least one complete app with each on you're considering. Personally, I'd go with Fusebox 3 and a CFC backend with 100% separation between UI and application, because that's what I'm most familiar with, and I rarely run into problems that don't have a ready solution. Of course, it might take all of 20 seconds to learn a little bit more about the app in question and realize that's a bad choice, so it's really up in the air. cheers, barneyb On 8/11/05, Z H [EMAIL PROTECTED] wrote: Which method do you recommend for developing a large-scale website/portal? MG -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214680 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusebox, Mach-II, GlueCode... the Oscar goes to...
Thanks Barney. Percieved development speed is governed by the methodology, not a framework.. Really great! MD. 2005/8/11, Barney Boisvert [EMAIL PROTECTED]: I didn't quite understand your question, but I'll try and answer anyway. ;) Frameworks are just pieces of code to help you do something in your code. Fusebox, Mach-II, and Model-Glue are all structure frameworks; they provide a skeleton from which to hang you application code, and take care of the linking stuff together part. You can have frameworks that do other things like caching, entity persistance, etc. Methodologies are a collection of programing standards that might be using a specific framework, following a certain design procedure (like FLiP), certain documentation requirements etc. Percieved development speed is governed by the methodology, not a framework. Using a framework requires more skill to code (or at least more knowledge - you have to understand the framework), but also makes coding faster, maintenance easier, and aids collaboration between developers. 100% separation between MVC is not really possible, in my view. You can get really close, but your view HAS to have some coupling with your controller. The model, however, can (and should) be entirely abstracted away from the controller (and MUST NEVER touch the views). A prime example is an app with flash and HTML interfaces. Same model, entirely separate from the C and V. But the HTML C and V are bound, and the Flash C and V are bound. It's just the nature of the beast. cheers, barneyb On 8/11/05, Michel Deloux [EMAIL PROTECTED] wrote: Ok, ok. It depends. Other question: framework and speed dev are the same thing? Or not? I believe(my point of view) that using frameworks make development harder to code. I'm right? It's possible to separate 100% between M V C? Thanx MD -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214683 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fusebox, Mach-II, GlueCode... the Oscar goes to...
Thanx Barney once more again for your patience in answer questions like that. MD 2005/8/11, Michel Deloux [EMAIL PROTECTED]: Thanks Barney. Percieved development speed is governed by the methodology, not a framework.. Really great! MD. 2005/8/11, Barney Boisvert [EMAIL PROTECTED]: I didn't quite understand your question, but I'll try and answer anyway. ;) Frameworks are just pieces of code to help you do something in your code. Fusebox, Mach-II, and Model-Glue are all structure frameworks; they provide a skeleton from which to hang you application code, and take care of the linking stuff together part. You can have frameworks that do other things like caching, entity persistance, etc. Methodologies are a collection of programing standards that might be using a specific framework, following a certain design procedure (like FLiP), certain documentation requirements etc. Percieved development speed is governed by the methodology, not a framework. Using a framework requires more skill to code (or at least more knowledge - you have to understand the framework), but also makes coding faster, maintenance easier, and aids collaboration between developers. 100% separation between MVC is not really possible, in my view. You can get really close, but your view HAS to have some coupling with your controller. The model, however, can (and should) be entirely abstracted away from the controller (and MUST NEVER touch the views). A prime example is an app with flash and HTML interfaces. Same model, entirely separate from the C and V. But the HTML C and V are bound, and the Flash C and V are bound. It's just the nature of the beast. cheers, barneyb On 8/11/05, Michel Deloux [EMAIL PROTECTED] wrote: Ok, ok. It depends. Other question: framework and speed dev are the same thing? Or not? I believe(my point of view) that using frameworks make development harder to code. I'm right? It's possible to separate 100% between M V C? Thanx MD -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214684 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Fusebox, Mach-II, GlueCode... the Oscar goes to...
Personal point of view: choose the best Framework for CF. Thanks MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214394 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Reading CF log files
Hi all, We're looking for all slow templates used in our application. This information is so important to know what's happening. What I need to do: - read CF log to know the name of that slow files. Using CF is possible to do that? Any tips? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213717 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Queries Totals
Thanks Barney. Great help. I'll think about. One more: using CFC in the middle tier could do that, right? Cheers MD 2005/8/2, Barney Boisvert [EMAIL PROTECTED]: You could write your own debugging template (or more likely, just modify the existing ones - they're not encrypted for this reason) that will tell you. Not sure if you can get per-file stats like you do for execution times, but you might poke around. If nothing else, you can pull the list of queries at the top of your template, record the recordCount, do the same at the end of your template, and subtract the two numbers to figure out how many queries ran. Check the debugging templates as examples of the syntax to use. Just keep in mind that a lot of the features the debugging templates use aren't officially supported CF features, so they might not work across versions. However, each version will have a way to do what you want, in general, because the debugging output doesn't change between versions much. cheers, barneyb On 8/2/05, Michel Deloux [EMAIL PROTECTED] wrote: Hi all it's possible to know the number of queries used in a template, including cfinclude ...? May be when you're using CF debug option. Cheers MD -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213578 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Queries Totals
Hi all it's possible to know the number of queries used in a template, including cfinclude ...? May be when you're using CF debug option. Cheers MD ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213456 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Formatting textarea
Hi all Sorry for OT. I am inserting a textarea into a database and when I retrieve the data I would like to show that same user formats with breaks, returns and so on. But only show inline text without formatting. Using HTMLEditFormat, ParagraphFormat, Replace(UserInputText,chr(13),br,all) and so on don't work... What's happened? Thanx MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212356 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT - Tape library
Hi all. Sorry for OT. I'm looking examples about how to develop a tape library with CF7/Oracle for use with backup tapes. How to manage tapes(LTO, DAT, DLT, etc) in use, tapes life time, dates, and so on. Any tips will be very very useful. Thanx MD ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212106 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using FSO with CF
Thank you S. Isaac... I'll be change our code to Java.io.File routines... Do you have any example about? Tutorials, how to use that Java classes? Thanks once more again. MD 2005/7/7, S. Isaac Dealey [EMAIL PROTECTED]: Thanks S. Isaac Dealey Yes. I need to use FSO with CF(CreateObject). But what I need to setup in our Win2003 Server. With Java I'll get best results? Thanx once more again. I would expect the java classes like java.io.File to be more efficient when using ColdFusion version 6.1 or later. (On version 5 the windows scripting object might be more efficient.) But asside from efficiency, the java classes are more portable since they can be used on any CF app platform, whether that's windows, linux, solaris or some unsupported JBoss instance on a SCO Unix machine. Reflection of the java classes when using ColdFusion 6.1 or later is amazingly efficient in and of itself when you're not relying on the CF native tags like cfdirectory which returns a bunch of information you may or may not need / want about the collection of files in your directory. Cfdirectory is great for the sake of simplicity, but if you really need performance, digging out the underlying java classes is the way to go. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211520 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using FSO with CF
Thanx S. Isaac Dealey... Sun... i'll be there... ;-) Cheers. MD 2005/7/11, S. Isaac Dealey [EMAIL PROTECTED]: Thank you S. Isaac... I'll be change our code to Java.io.File routines... Do you have any example about? Tutorials, how to use that Java classes? Thanks once more again. Welcome, I just read the API documentation on the sun site myself... http://java.sun.com/j2se/1.4.2/docs/api/java/io/package-summary.html java.io.File will handle basic file information (does it exist, is it a file, when was it modified, etc) ... to actually write files you need to use a couple other classes, in particular FileWriter and FileOutputStream -- you may also need an OutputStreamWriter. I'd expect you can probably come up with a tutorial or two by googling java.io.FileWriter or java.io.FileOutputStream. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Using FSO with CF
Hi all I need to know about directories in our Win2003 server with CF7. Using FSO is the best option? What I need to do? Thanx ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using FSO with CF
Thanks S. Isaac Dealey Yes. I need to use FSO with CF(CreateObject). But what I need to setup in our Win2003 Server. With Java I'll get best results? Thanx once more again. MD 2005/7/7, S. Isaac Dealey [EMAIL PROTECTED]: Hi all I need to know about directories in our Win2003 server with CF7. Using FSO is the best option? What I need to do? Are you talking about the Windows scripting File System Object? ... I wouldn't use that with CF7, I'd use java.io.File and related java file-system classes... s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211358 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Delete spaces inside form fields vars
Thank you Matthew. Great great job. Works fine now...
More clear and concise!
2005/6/30, Matthew Walker [EMAIL PROTECTED]:
You seem to be asking for all spaces in submitted values to be removed, yet
your code seems to be changing all double-spaces to single spaces. What
exactly do you want?
Also, your syntax is a bit confusing. I'd write what you have as follows:
cfloop collection=#form# item=field
cfset form[field] = replace(form[field], , , all)
/cfloop
However your code probably wouldn't catch triple spaces, in which case I'd
write:
cfloop collection=#form# item=field
cfset form[field] = reReplace(form[field], [[:space:]]{2,}, ,
all)
/cfloop
Question is -- what are you trying to achieve?
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211006
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Delete spaces inside form fields vars
Hi all I need to delete all spaces between words inside form fields. Please look this simple code included in application.cfm: !--- FORM structure exists and haves content--- cfif NOT isEmpty(FORM) cfoutput cfloop list=#form.fieldnames# index=i !---update all form fields with spaces for your new value without spaces between--- cfscript !---change all 2 spaces for only one space--- StructUpdate(form, #i#, Replace(#StructFind(form, '#i#')#,' ',' ','All')); /cfscript /cfloop cfdump var=#FORM# /cfoutput /CFIF Testing with cfabort show me all form fields without spaces. Using Len after and before show me a correct length. But after insert in DB with SP or simple INSERT with queries all form fields continue with spaces What's wrong? Thanks for your time. MD. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210991 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Install CF 7 with an existing MX installation
Thanx Steve and Jim. Yes... we need to isolate 6.1 apps from our new CF 7 application with improvements(cfforms, cfreport and so). I'll be testing IIS setup for multiple instances of CF... Any suggestions? Thanx for your time. 2005/6/18, TalkingTree.com [EMAIL PROTECTED]: One instance of IIS can be configured for one CFMX server only. If you have, for example, Windows Professional or Server Edition, then IIS can have multiple instances, each configured for a different domain, IP, or port. You can create a new instance of IIS for testing purposes that listens to the same domain or IP, but on a different port. Then IIS instance 1 can be connected to CFMX 6.x server, and IIS instance 2 can be connected to CFMX 7 server at the same time. These do not conflict. Use $CF_HOME\bin\wsconfig.exe (or java -jar $CF_HOME\runime\lib\wsconfig.jar) to launch the wsconfig GUI (Web Server CONFIGurator). From there you can configure IIS for the appropriate CFMX server. For CFMX 7 use only the wsconfig.exe under CFusionMX7/bin, and for CFMX 6.x use only the wsconfig.exe in CFusionMX/bin. Each version of ColdFusion comes with its own wsconfig. Do not attempt to cross them. Alternatively, you can choose to install CFMX 7 without choosing to configure IIS. Then CFMX 7 will run on its built-in webserver, which will be either 8500 or 8501 in most cases. -Steven Erat Michel Deloux wrote: Thanks Will. But how IIS will know what CF version need to run with cfm templates? 2005/6/18, Will Tomlinson [EMAIL PROTECTED]: As far as I'm aware, they should run fine side by side. At least mine do with no problem. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209952 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Install CF 7 with an existing MX installation
Hi all please give me your help. Today our intranet run with CF MX. All works fine. But I need to install CF 7 for our new application(cfforms and cfreport) but I need to preserve CF MX installation and applications running with. It's possible to define that? How to do if this application runs with MX and that with 7? We're running with IIS web server. Thanx a lot. MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Install CF 7 with an existing MX installation
Thanks Will. But how IIS will know what CF version need to run with cfm templates? 2005/6/18, Will Tomlinson [EMAIL PROTECTED]: As far as I'm aware, they should run fine side by side. At least mine do with no problem. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209918 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Appending requesttimeout to URL via application.cfm
That's possible? I need to check if cgi.query_string exists in URL if yes OK; if no I need to insert that variable to all URL in our application... But... How can do that? Thanx all MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Appending requesttimeout to URL via application.cfm
Via application.cfm? How to ensure that config works properly? It's possible to dump cfsetting? Thanx James MD 2005/6/16, James Holmes [EMAIL PROTECTED]: You can use cfsetting to do the same thing. On 6/16/05, Michel Deloux [EMAIL PROTECTED] wrote: That's possible? I need to check if cgi.query_string exists in URL if yes OK; if no I need to insert that variable to all URL in our application... But... How can do that? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209674 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Appending requesttimeout to URL via application.cfm
Thanx James after insert cfsetting var in application.cfm like this: cfset ExecTime = 5 cfoutput CFIF NOT Len(CGI.QUERY_STRING) cfsetting RequestTimeout = #ExecTime# CFELSE cfset HavesString = #FindNoCase(requesttimeout, CGI.QUERY_STRING)# cfif HavesString IS NOT 1 cfsetting RequestTimeout = #ExecTime# cfelse /CFIF /CFIF /cfoutput CF debug shows me this setting in CGI variables: 141 ms 141 ms 1 D:\routers211\testingRequestTimeOut.cfm QUERY_STRING= What's happened? Thanx once more... MD 2005/6/16, James Holmes [EMAIL PROTECTED]: There isn't a structure to dump - just add cfsetting requesttimeout=60 to Application.cfm, replacing 60 with the number of seconds you want (note that this only works in CFMX 6 or above). If you want to test it you can write a template that deliberately pauses past the timeout to see if the correct error is thrown: cfset createObject(java,java.lang.Thread).sleep(61000) On 6/16/05, Michel Deloux [EMAIL PROTECTED] wrote: Via application.cfm? How to ensure that config works properly? It's possible to dump cfsetting? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209697 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Using XForms with CFFORM in CF7
Hi all I'm looking for examples, advantages, disadvantages, requirements about using XForms with CFFORM in CF7. CF Documentation is so small about that subject. Any topic will be very helpful. Thanx MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208053 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using XForms with CFFORM in CF7
Thanx Michael... great!!! MD 2005/5/31, Michael Dinowitz [EMAIL PROTECTED]: This article was published recently in Fusion Authority XForms: The 'Other' New Forms in CFMX 7 http://www.fusionauthority.com/Article.cfm/ArticleID:4430 - Original Message - From: Michel Deloux [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 31, 2005 12:44 PM Subject: Using XForms with CFFORM in CF7 Hi all I'm looking for examples, advantages, disadvantages, requirements about using XForms with CFFORM in CF7. CF Documentation is so small about that subject. Any topic will be very helpful. Thanx MD ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208086 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Viewing files in another server/directory outside CF server
Thanx Dave yes and yes. Please look my simple script(viewfiles.cfm): cfset namefile=Fresno_#CreateUUID()#.doc cfcase value=doc cfheader name=Content-Disposition value=inline;filename=#namefile# cfcontent type=application/msword file=#namefile# /cfcase IE show me a screen with save and cancel options. If user chooses Save IE prompt for viewfiles.cfm automatic file name... 2005/5/25, Dave Watts [EMAIL PROTECTED]: Using attachment or inline options IE don't show Open option only Save and Cancel. And IE recognize original MS Word doc like unknown. If user clicks Save needs to select a directory, name and so on... Using Mozilla works fine: I click in Open File and MS Word shows that... very crazy Are you setting the appropriate MIME type? Are you specifying a filename with the appropriate extension? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207983 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Viewing files in another server/directory outside CF server
Thanks Deanna but displaying all files in Mozilla works fine. But with IE that same code, same link, same properties don't. IE displays a Unknown file - Do you want to save, open, cancel, bla bla bla... What's happening? Thanx for your time. 2005/5/24, Deanna Schneider [EMAIL PROTECTED]: That's the proper behavior. If you want them to display in the browser, you'll ned to change your value=attachment; to value=inline; - Original Message - From: Michel Deloux [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 24, 2005 2:49 PM Subject: Re: Viewing files in another server/directory outside CF server Using CFCONTENT and CFHEADER with MS Word files show me a Save/Download screen in IE. Please look my simple code: view_files.cfm?fileX=file://CA_LA_Fresno/systems/Fresno2004_12.doc in view_files I remove file: and change / bar to \ bar and after:: cfheader name=Content-Disposition value=attachment; filename=#URL.fileX# cfcontent type=application/msword file=#URL.fileX# deletefile=No Whta's happened? Thanx ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207646 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Viewing files in another server/directory outside CF server
Thanx Jim Using attachment or inline options IE don't show Open option only Save and Cancel. And IE recognize original MS Word doc like unknown. If user clicks Save needs to select a directory, name and so on... Using Mozilla works fine: I click in Open File and MS Word shows that... very crazy Thanx all. 2005/5/25, Jim Davis [EMAIL PROTECTED]: As I'm reading it this is normal. The file format may be known but the file itself is unknown - it could pose a security risk. The user is always given the option to ignore the download, open it immediately or save it for later (or for virus checking). What behavior are you seeing in the other browsers? Are they opening the file directly (which seems reckless to me)? Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Viewing files in another server/directory outside CF server
Thank you Pascal for your answer. But don't work for us. With CF I(administrator user) can view all files stored in that protected dir/server. But final user(without rights for read/write) don't... Using cflocation, cffile with read and after write, all fails... Do you have other choice? Can help us? Thanks for your time. 2005/5/23, Pascal Peters [EMAIL PROTECTED]: Use cfcontent to do that cfheader name=Content-Disposition value=attachment; filename=#attributes.filename# cfcontent type=#attributes.mimetype# file=#attributes.file# deletefile=No Pascal -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 16:54 To: CF-Talk Subject: Viewing files in another server/directory outside CF server Hi all I can upload files to CA_LA_Fresno server using CF user. CF user haves administrator properties. But my user don't have permission to access that server/directory. It's possible to my users see that file in your browser or Word? How? Thanks in advance ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207522 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Viewing files in another server/directory outside CF server
Thanx Pascal
I'm using this script to show to the user
a href=### onclick=javascript:
window.open('file://CA_LA_Fresno/Docs/FresnoPower.doc');
title=Please click here to view this documentoFresnoPower.doc/a
All users have READ only access to Docs subdir.
In that situation if user clicks Internet Explorer show this message:
Error message: Cannot find filename. Make sure the path or Internet
Address is correct.
What do you think about?
Thanx in advance.
2005/5/24, Pascal Peters [EMAIL PROTECTED]:
The final user does not need access to that folder, just CF. Let's say I
want to access a file C:\docs\test.doc, but the user doesn't have access
to C:\docs. CF has access to it, and the user has access to a CF
application in the webroot.
Create a file download.cfm under the webroot somewhere and pot the
following code in it:
cfheader name=Content-Disposition value=attachment;
filename=test.doc
cfcontent type=application/msword file= C:\docs\test.doc
deletefile=No
This should enable the users to download the file by calling
download.cfm. You have to make sure that coldfusion has access to the
folder. Sandbox security may also prevent this, but then you have to
talk to the server admin.
-Original Message-
From: Michel Deloux [mailto:[EMAIL PROTECTED]
Sent: 24 May 2005 13:01
To: CF-Talk
Subject: Re: Viewing files in another server/directory outside CF
server
Thank you Pascal for your answer. But don't work for us. With CF
I(administrator user) can view all files stored in that protected
dir/server. But final user(without rights for read/write) don't...
Using cflocation, cffile with read and after write, all fails... Do
you have other choice?
Can help us?
Thanks for your time.
2005/5/23, Pascal Peters [EMAIL PROTECTED]:
Use cfcontent to do that
cfheader name=Content-Disposition value=attachment;
filename=#attributes.filename#
cfcontent type=#attributes.mimetype# file=#attributes.file#
deletefile=No
Pascal
-Original Message-
From: Michel Deloux [mailto:[EMAIL PROTECTED]
Sent: 23 May 2005 16:54
To: CF-Talk
Subject: Viewing files in another server/directory outside CF
server
Hi all
I can upload files to CA_LA_Fresno server using CF user. CF user
haves
administrator properties. But my user don't have permission to
access
that server/directory. It's possible to my users see that file in
your
browser or Word?
How?
Thanks in advance
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207528
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Viewing files in another server/directory outside CF server
Thanx Dave,
CF lives in CA_LA_WS server and all docs lives in CA_LA_Fresno server.
How to show for our users docs stored in CA_LA_Fresno server with IE?
It's possible? For IE I need to store my files in CF server?
2005/5/24, Dave Watts [EMAIL PROTECTED]:
I'm using this script to show to the user
a href=### onclick=javascript:
window.open('file://CA_LA_Fresno/Docs/FresnoPower.doc');
title=Please click here to view this documentoFresnoPower.doc/a
All users have READ only access to Docs subdir.
In that situation if user clicks Internet Explorer show this message:
Error message: Cannot find filename. Make sure the path or Internet
Address is correct.
This has nothing to do with CF's permissions to access files, or your web
server's permissions either. You are providing links directly to files, and
your users would need to be able to resolve UNC paths directly to those
files from their workstations for those links to work.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207531
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Viewing files in another server/directory outside CF server
Thanx Dave. and that your clients have network logon rights to that machine and read access to the share in question... it's impossible! What's UNC? How to setup? Thanx once more again. 2005/5/24, Dave Watts [EMAIL PROTECTED]: CF lives in CA_LA_WS server and all docs lives in CA_LA_Fresno server. How to show for our users docs stored in CA_LA_Fresno server with IE? It's possible? For IE I need to store my files in CF server? You have all sorts of options. You can allow direct access via UNC path to the server in question, although you will also have to ensure that your clients can resolve the NetBIOS name correctly (via WINS, LMHOSTS or AD DNS) and that your clients have network logon rights to that machine and read access to the share in question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207535 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Viewing files in another server/directory outside CF server
Thanx Dave using CFCONTENT and CFHEADER I need to get that file right? After that I can send that file to user browser... Works with users with no server rights? 2005/5/24, Dave Watts [EMAIL PROTECTED]: and that your clients have network logon rights to that machine and read access to the share in question... it's impossible! What's UNC? How to setup? If that's impossible, you won't be able to offer links using the file: pseudo-protocol. If the service account used by the CF server has rights to read those documents, you can use CFCONTENT to fetch those files and serve them to the user. !-- example page with link to file --- a href=getfile.cfm?id=#fileid##filename#/a !--- getfile.cfm --- cfquery name=qGetFile ... SELECT Filename, MIMEType FROM File WHEREFileID = cfqueryparam cfsqltype=cf_sql_integer value=#URL.fileid# /cfquery cfheader name=Content-Disposition value=inline; filename=#qGetFile.FileName# cfcontent file=#qGetFile.FileName# type=#qGetFile.MIMEType# In the above example, the presumption is that you're storing information about those files within your database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Viewing files in another server/directory outside CF server
Using CFCONTENT and CFHEADER with MS Word files show me a Save/Download screen in IE. Please look my simple code: view_files.cfm?fileX=file://CA_LA_Fresno/systems/Fresno2004_12.doc in view_files I remove file: and change / bar to \ bar and after:: cfheader name=Content-Disposition value=attachment; filename=#URL.fileX# cfcontent type=application/msword file=#URL.fileX# deletefile=No Whta's happened? Thanx 2005/5/24, Dave Watts [EMAIL PROTECTED]: using CFCONTENT and CFHEADER I need to get that file right? After that I can send that file to user browser... Works with users with no server rights? Yes, you would be fetching the file with CF, then returning it to the browser. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207583 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Viewing files in another server/directory outside CF server
Hi all I can upload files to CA_LA_Fresno server using CF user. CF user haves administrator properties. But my user don't have permission to access that server/directory. It's possible to my users see that file in your browser or Word? How? Thanks in advance ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207421 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Using CFIF inside CFReport Builder
Hi all it's possible to use CFIF statements inside CF Report Builder? I need to use CFIF's for control titles and display selected informations. It's possible? How to? Thanks in advance for any help. Michel ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206742 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[SOT] Reports in HTML with CF
Hi all I'm need to create reports in HTML mode. But how to use pagebreaks, headers in that pagebreaks, footers, and so with HTML? Do you have any example about how to use HTML in reports with CF? Cheers Michel ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206591 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[OT] SQL Audit with CF - or maybe triggers?
Hi all I'm a CF newbie and look for any sort of help for my application. How to audit update and delete operations in our DB? I have try to use trigger but how to pass parameters for triggers like userID, fields changed, etc? Do you have any example about how to do that? Cheers Michel Deloux ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [OT] SQL Audit with CF - or maybe triggers?
Thanks Jochem We're using SQL Server 2000. Internally? But how to pass CF parameters and save that parameters in... AuditTable? It's possible? 2005/5/11, Jochem van Dieten [EMAIL PROTECTED]: Michel Deloux wrote: I'm a CF newbie and look for any sort of help for my application. How to audit update and delete operations in our DB? Which DB? Some databases provide this functionality internally. I have try to use trigger but how to pass parameters for triggers like userID, fields changed, etc? Can't you get that information from the :new and :old pseudorows? Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [OT] SQL Audit with CF - or maybe triggers?
Yes. Our application is done and tomorrow my boss send an email about Audit Control... ;-( Thanx 2005/5/11, Jochem van Dieten [EMAIL PROTECTED]: Michel Deloux wrote: We're using SQL Server 2000. Internally? Doubt so, I only know of plugins for MVCC databases. But how to pass CF parameters and save that parameters in... AuditTable? It's possible? With triggers you can access all the information in the update, but not random CF variables. Are you trying to bold auditing on to an existing system? If so, how does that existing system do access control? Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206409 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
