Re: cfinclude application.cfm
On Fri, 1 Oct 2004 12:15:55 -0700, Barney Boisvert <[EMAIL PROTECTED]> wrote: > The root of your application has Application.cfm, and then every sub > application has it's own Application.cfm, of which the first line is > . You can store all your > global stuff in the root Application.cfm, and keep all the subapp > stuff segregated. Yup, this is exactly how the applications on macromedia.com work - we have a single, central Application.cfm with all the cross-application stuff in the root directory, then we have per-application Application.cfm files that begin with an explicit include of the root Application.cfm file... -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 6 invites "If you're not annoying somebody, you're not really alive." -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: removing directories that are not empty
Stephenie Hamilton wrote: > does anyone know of a udf or custom tag that will easy remove directories that are not empty? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Server dropping zeros
Stan Winchester wrote: > I had the strangest thing; I've got a varchar field in a SQL Server 2000 > table that stores zip codes. When we import the zip codes leading and > trailing zeros drop off when inserted, for example: 07080 will become 708. How are you importing the zip codes? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: removing directories that are not empty
> does anyone know of a udf or custom tag that will easy remove directories > that are not empty? I developed a CFC that does this (and much more), it's in beta stage right now, drop me an email if you would like to give it a try Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: removing directories that are not empty
http://www.emerle.net/programming/deltree.cfm > does anyone know of a udf or custom tag that will easy remove > directories that are not empty? > > > steph [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Postgresql setup
Hi Everyone. Can anyone explain or point me in the direction of a web page that explains how to set-up a Postgresql database with CFMX. Thanks. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Postgresql setup
Andrew Dixon wrote: > > Can anyone explain or point me in the direction of a web page that > explains how to set-up a Postgresql database with CFMX. http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Postgresql setup
Excellent thanks. Andrew. - Original Message - From: Jochem van Dieten <[EMAIL PROTECTED]> Date: Sat, 02 Oct 2004 16:13:32 +0200 Subject: Re: Postgresql setup To: CF-Talk <[EMAIL PROTECTED]> Andrew Dixon wrote: > > Can anyone explain or point me in the direction of a web page that > explains how to set-up a Postgresql database with CFMX. http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSS and tableless tables
Try a validator, or check the resulting html. When you use the link tag, make sure that the path is correct (relative, or absolute? are you using base/href tag?) -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - |-Original Message- |From: Phillip Perry [mailto:[EMAIL PROTECTED] |Sent: Saturday, October 02, 2004 01:57 |To: CF-Talk |Subject: OT: CSS and tableless tables | |Sorry for the OT post but i need help. | |The CSS I am using for a CSS table format works on 3 different |browsers when the css is embedded in the individual pages, but |when I do a or the formatting goes to hell. |Is there any css experts out there that can explain what I'm |doing wrong? | |Thanks | |Phillip Perry | | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
proxy and cookies/session
Hi, I am currently running a setup with CFMX deployed on tomcat, and accessed through Apache and mod_proxy. It seems to work fairly good, but sessions and cookies seems to be mixed up, I assume that Apache is not forwarding that information. Does anyone know hot to fix/work around this? -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSS and tableless tables
Send me some links so I can take a look. Just curious, are you trying to show tabular data without tables? If so, why? Tables are fine for tabular data, just (IMHO) not for layout. Sandy Clark http://www.shayna.com CF Pretty Accessible at http://www.shayna.com/blog Now offering 4 days Hands on CSS training October 11-14th. Rockville, MD. For more information go to: http://www.teratech.com/training/oc_classes.cfm#css _ From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Friday, October 01, 2004 7:57 PM To: CF-Talk Subject: OT: CSS and tableless tables Sorry for the OT post but i need help. The CSS I am using for a CSS table format works on 3 different browsers when the css is embedded in the individual pages, but when I do a or the formatting goes to hell. Is there any css experts out there that can explain what I'm doing wrong? Thanks Phillip Perry _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSS and tableless tables
I believe he fixed it. Think he said he had some weird chars in his css. Ive been seeing a lot of delayed double posts lately. Someone will ask a ?, itll get answered, then a while later the original ? will pop up again. _ From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: Saturday, October 02, 2004 11:32 AM To: CF-Talk Subject: RE: CSS and tableless tables Try a validator, or check the resulting html. When you use the link tag, make sure that the path is correct (relative, or absolute? are you using base/href tag?) -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - |-Original Message- |From: Phillip Perry [mailto:[EMAIL PROTECTED] |Sent: Saturday, October 02, 2004 01:57 |To: CF-Talk |Subject: OT: CSS and tableless tables | |Sorry for the OT post but i need help. | |The CSS I am using for a CSS table format works on 3 different |browsers when the css is embedded in the individual pages, but |when I do a or the formatting goes to hell. |Is there any css experts out there that can explain what I'm |doing wrong? | |Thanks | |Phillip Perry | | | | | _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:180338"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] [HYPERLINK "https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation s and Support] _ HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=37" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSS and tableless tables
I think someone changed the subject, an added "OT:". I have set my mailer to sort/group the mails according to subject, so they got sorted separately, I saw the responses later. -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - |-Original Message- |From: Ewok [mailto:[EMAIL PROTECTED] |Sent: Saturday, October 02, 2004 18:23 |To: CF-Talk |Subject: RE: CSS and tableless tables | |I believe he fixed it. Think he said he had some weird chars |in his css. |I've been seeing a lot of delayed double posts lately. | |Someone will ask a ?, it'll get answered, then a while later |the original ? |will pop up again. | | | | | | _ | |From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] |Sent: Saturday, October 02, 2004 11:32 AM |To: CF-Talk |Subject: RE: CSS and tableless tables | | | |Try a validator, or check the resulting html. When you use the |link tag, make sure that the path is correct (relative, or |absolute? are you using base/href tag?) | |-- |Hugo Ahlenius | |- |Hugo Ahlenius E-Mail: [EMAIL PROTECTED] |Project Officer Phone:+46 8 230460 |UNEP GRID-Arendal Fax: +46 8 230441 |Stockholm Office Mobile: +46 733 467111 | WWW: http://www.grida.no |- | | | ||-Original Message- ||From: Phillip Perry [mailto:[EMAIL PROTECTED] ||Sent: Saturday, October 02, 2004 01:57 ||To: CF-Talk ||Subject: OT: CSS and tableless tables || ||Sorry for the OT post but i need help. || ||The CSS I am using for a CSS table format works on 3 |different browsers ||when the css is embedded in the individual pages, but when I do a || or the formatting goes to hell. ||Is there any css experts out there that can explain what I'm doing ||wrong? || ||Thanks || ||Phillip Perry || || || || || | | _ | |[HYPERLINK |"http://www.houseoffusion.com/lists.cfm/link=t:4"Todays |Threads] [HYPERLINK |"http://www.houseoffusion.com/lists.cfm/link=i:4:180338"This |Message] [HYPERLINK |"http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] |[HYPERLINK |"http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678 .598.4"Fast |Unsubscribe] [HYPERLINK |"http://www.houseoffusion.com/signin/"User Settings] |[HYPERLINK |"https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+ of+Fusion&bus |iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xc lick"Donation |s and Support] | | _ | |HYPERLINK |"http://www.houseoffusion.com/banners/view.cfm?bannerid=37" \n | | |--- |Incoming mail is certified Virus Free. |Checked by AVG anti-virus system (http://www.grisoft.com). |Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 | | | |--- |Outgoing mail is certified Virus Free. |Checked by AVG anti-virus system (http://www.grisoft.com). |Version: 6.0.767 / Virus Database: 514 - Release Date: 9/21/2004 | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Encrypt Decrypt?
We need to Encrypt and email private info. Then using the same key decrypt on the receiving end. However, our Decrypt tag throws and error, not liking some of the Encrypted code. The example below works under the same circumstances. Encrypting in one template and decrypting in another template (by error. The thing I can think of is there is something that is different in the encrypted code than appears to be visible and copy/pasted?? Should the encrypted code be conditioned or ?? before trying to Decrypt? Thanks, Nick Example, The string: #string# The key: #key# Encrypted: #encrypted# Decrypted: #decrypted# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFStoredProc vs CFQuery
I'm late to this thread but thought it worth mentioning that "ColdFusion MX
Bible" cites a method for caching a single result set stored procedure, as
follows:
cachedwithin="#createtimespan(0,12,0,0)#">
{ CALL sp_getAuthors('Churvis') }
~Dina
- Original Message -
From: Robertson-Ravo, Neil (RX)
To: CF-Talk
Sent: Thursday, September 30, 2004 1:01 AM
Subject: RE: CFStoredProc vs CFQuery
Yeah if you must cache, then use CFQUERY but you can also just duplicate
the
results into a new query object and cache that.
_
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 29 September 2004 20:35
To: CF-Talk
Subject: RE: CFStoredProc vs CFQuery
> Are there any benefits to calling stored procedures using
> CFStoredProc vs. CFQuery? All the stored procs return a
> single record set.
>
> The limitation I am running in to is how to cache the results
> of a query that is created calling CFStoredProc.
In this case, I'd recommend using CFQUERY to call your stored procedure,
as
Mike recommended. It works just as well, and you can cache it.
Alternatively, you can cache recordsets from CFSTOREDPROC within the
Session, Application or Server scopes.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Dreamweaver Templates..?
Thanks Damien, I agree with you. >Dreameaver templates are 100% dependent on the developer's system, >that's where all the templating is done. The web server and visitor >only see finished HTML. >Personally I recommend using a server-side scripting language (CF, PHP, >etc) to do your templating rather than Dreamweaver's templates as I >found them to be unreliable on larger sites. >-- >*Damien McKenna* - Web Developer - [EMAIL PROTECTED] > >The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 >"Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver Templates..?
On Fri, 01 Oct 2004 09:34:36 -0400, Damien McKenna <[EMAIL PROTECTED]> wrote: > Dreameaver templates are 100% dependent on the developer's system, > that's where all the templating is done. The web server and visitor > only see finished HTML. Correct, although if you view source you'll see the commented sections of the page that indicate DW templates were used. > Personally I recommend using a server-side scripting language (CF, PHP, > etc) to do your templating rather than Dreamweaver's templates as I > found them to be unreliable on larger sites. Could you elaborate on that? We use DW templates across the majority of macromedia.com's 40,000+ static pages with no reliability problems. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 6 invites "If you're not annoying somebody, you're not really alive." -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfstored proc returning value
Anyone see whats wrong with the following stored procedure call, I keep getting the following error when trying to return an integer (last ID)... "Invalid data for CFSQLTYPE CF_SQL_INTEGER." CF Stored Proc Call procedure="INSERT_COMMUNITY_BUSINESS" datasource="#application['stcGlobalVars']['dsn_insert']#"> cfsqltype="CF_SQL_INTEGER" value="#Trim(attributes['businessType'])#" null="#YesNoFormat(Trim(attributes['businessType']) EQ 0)#" /> cfsqltype="CF_SQL_VARCHAR" value="#Trim(attributes['businessName'])#" null="no" /> cfsqltype="CF_SQL_VARCHAR" value="#Trim(attributes['division'])#" null="#YesNoFormat(Len(Trim(attributes['division'])) EQ 0)#" /> cfsqltype="CF_SQL_INTEGER" type="Out" variable="newId" /> And the T-SQL stored proc... CREATE PROCEDURE INSERT_COMMUNITY_BUSINESS @VAR_BUSINESS_TYPE_ID INT, @VAR_BUSINESS_NAME VARCHAR(50), @VAR_BUSINESS_DIVISION VARCHAR(50), @VAR_NEW_ID INT OUTPUT AS INSERT INTO COMMUNITY_BUSINESS ( BUSINESS_TYPE_ID, BUSINESS_NAME, BUSINESS_DIVISION ) VALUES ( @VAR_BUSINESS_TYPE_ID, @VAR_BUSINESS_NAME, @VAR_BUSINESS_DIVISION ) SELECT @VAR_NEW_ID = SCOPE_IDENTITY() GO Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cflogin ?
i cant ever find anything that tells how to check for more than 1 acceptable roles so, say there are 2 roles (admin, user) and both can access the same pages would it be? i cant find any docs that give any info on it tia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Server dropping zeros
Using a tab delimited text file. >Stan Winchester wrote: >> I had the strangest thing; I've got a varchar field in a SQL Server 2000 >> table that stores zip codes. When we import the zip codes leading and >> trailing zeros drop off when inserted, for example: 07080 will become 708. > >How are you importing the zip codes? > >Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cflogin ?
Look in the CFMX Bible if you have it, if you don't then get it! It's a GREAT book! >i cant ever find anything that tells how to check for more than 1 acceptable roles > >so, say there are 2 roles (admin, user) and both can access the same pages >would it be? > > > > > > > > >i cant find any docs that give any info on it >tia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cflogin ?
i have most every book and they all say samething only give example for 1 roles, same with the liv docs and blah blah blah -- Original Message -- From: Stan Winchester <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Sat, 02 Oct 2004 22:36:43 -0400 >Look in the CFMX Bible if you have it, if you don't then get it! It's a GREAT book! > >>i cant ever find anything that tells how to check for more than 1 acceptable roles >> >>so, say there are 2 roles (admin, user) and both can access the same pages >>would it be? >> >> >> >> >> >> >> >> >>i cant find any docs that give any info on it >>tia > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfstored proc returning value
I've had no problems using the return variables instead of a full result set with SQL 2000. It appears that you aren't using the DBVARNAME attribute. I know that CFSTOREDPROC will execute in the order that they are declared, but I don't know if the same holds true for output params. Try using the the varname as well. Also, I got the same error you did initially. but it ended up being that my procparam for teamdesc was set to CF_SQL_INTEGER when it was a VARCHAR in the proc itself. (cut and paste error). Here is a query that works for me. value="#form.newTeamNum#"> value="#form.currentDistrict#"> value="#form.teamDesc#"> variable="newID"> And here is the stored proc script. CREATE PROC rgis_TeamAdd2 @TeamNumber int, @DistrictID int, @TeamDesc varchar(100), @newTeamID int OUT AS SET NOCOUNT ON INSERT INTO trefTeams(TeamNumber, DistrictID, TeamDesc) VALUES (@TeamNumber, @DistrictID, @TeamDesc) SET @newTeamID = (SELECT Scope_Identity()) SET NOCOUNT OFF HTH, Jeff Garza _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Saturday, October 02, 2004 5:23 PM To: CF-Talk Subject: cfstored proc returning value Anyone see whats wrong with the following stored procedure call, I keep getting the following error when trying to return an integer (last ID)... "Invalid data for CFSQLTYPE CF_SQL_INTEGER." CF Stored Proc Call procedure="INSERT_COMMUNITY_BUSINESS" datasource="#application['stcGlobalVars']['dsn_insert']#"> cfsqltype="CF_SQL_INTEGER" value="#Trim(attributes['businessType'])#" null="#YesNoFormat(Trim(attributes['businessType']) EQ 0)#" /> cfsqltype="CF_SQL_VARCHAR" value="#Trim(attributes['businessName'])#" null="no" /> cfsqltype="CF_SQL_VARCHAR" value="#Trim(attributes['division'])#" null="#YesNoFormat(Len(Trim(attributes['division'])) EQ 0)#" /> cfsqltype="CF_SQL_INTEGER" type="Out" variable="newId" /> And the T-SQL stored proc... CREATE PROCEDURE INSERT_COMMUNITY_BUSINESS @VAR_BUSINESS_TYPE_ID INT, @VAR_BUSINESS_NAME VARCHAR(50), @VAR_BUSINESS_DIVISION VARCHAR(50), @VAR_NEW_ID INT OUTPUT AS INSERT INTO COMMUNITY_BUSINESS ( BUSINESS_TYPE_ID, BUSINESS_NAME, BUSINESS_DIVISION ) VALUES ( @VAR_BUSINESS_TYPE_ID, @VAR_BUSINESS_NAME, @VAR_BUSINESS_DIVISION ) SELECT @VAR_NEW_ID = SCOPE_IDENTITY() GO Thanks! Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
