Re: Fwd: Subject: How to invoke a method from inside another meth od in a cfc
This should work, unless I have misread the Q :-) cffunction name=method1... ... cfif... method2() /cfif /cffunction cffunction name=method2... ... /cffunction You would obviously need to place it in a Var/return all the necessary bits b bobs. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Ken Wexel To: CF-Talk Sent: Sun Mar 11 22:53:46 2007 Subject: Fwd: Subject: How to invoke a method from inside another method in a cfc can't you just cfinvoke the method from inside the first method? -Ken -- Forwarded message -- From: Mike Oldfield [EMAIL PROTECTED] Date: Mar 11, 2007 4:58 PM Subject: Subject: How to invoke a method from inside another method in a cfc To: CF-Talk cf-talk@houseoffusion.com Hello everybody, somebody knows how can I invoke a method from inside another method in a cfc? Please help me! I have something like this: cffunction name=method1... ... cfif... do method 2 /cfif /cffunction cffunction name=method2... ... /cffunction Thanks for your help ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
Well, it was late when the last reply on this subject came through so I slept on it. And guess what? This morning all zones are reporting the correct time (on _11 _13). I would say this is a bug in the JVM. It was correctly identifying a zone was in new US DST but didn't factor it into the offset until 24hrs later. At least the problem appears to be resolved. Thanks to all who replied. Phew. :) - Original Message - From: Gareth Hughes [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 12:35 AM Subject: Re: Timezone.cfc and US DST changes 'timezone hell'. Oh boy :) Thanks for the reply Paul, I'm reading the blog post now... - Original Message - From: Paul Hastings [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 12:19 AM Subject: Re: Timezone.cfc and US DST changes Gareth Hughes wrote: because of the change in US DST when using the castFromServer method. The welcome to timezone hell: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=77223B6A-20ED-7DEE-2AB7FBB1F37ABD77 ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can I use CLIENT variable storage with MySQL 5?
On 3/11/07, Jonathan B wrote: I'm trying very hard to figure out how to get MySql 5 to work with CF client variable storage. I need that... its a requirement. Has anybody done it before? The CF administrator does not have it built in, and when I try to manually create CFDATA and CFGLOBAL, my front end app errors out with a 500 database error. I know it works. I'm not sure what your problem is specifically tho. Doesn't have what built in? The mysql5 driver? You'll need to go and download a newer version from the mysql.com site. I think 3.0.17-ga is the newest that won't slow you down with the varchar strangeness*. Then you can use other when specifying a DSN type, and configure the datasource for mysql 5. *varchar strangeness is the added milliseconds for each varchar field included in the result set. Actually, I think maybe the updated datadirect drivers might have a newer mysql one? If you haven't gotten them from Adobe already, you should. Anyways, I'm not even sure if that's what you're having troubles with. Wanna clarify? Maybe try dropping the table, and running the create script from CF admin again? :-/ ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can I use CLIENT variable storage with MySQL 5?
With Client variables, I believe you have to first have your datasource set up and working. THEN you go into the CFAdministrator and set up the Client vars. It's a while since i set up Client vars, but if i recall correctly, it has to check the datasource when you 'submit' after changing the details of the client vars. One of hte options at that time is to let it create its own CFDATA and CFGLOBAL tables, and I'd recommend letting it do it. Then you know for sure its all going to work. But i dont believe client vars use any tricky sql at all, so it should work on any database that is avlid datasource for CF. It only does SQLinserts, deletes and selects. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/12/07, Dinner [EMAIL PROTECTED] wrote: On 3/11/07, Jonathan B wrote: I'm trying very hard to figure out how to get MySql 5 to work with CF client variable storage. I need that... its a requirement. Has anybody done it before? The CF administrator does not have it built in, and when I try to manually create CFDATA and CFGLOBAL, my front end app errors out with a 500 database error. I know it works. I'm not sure what your problem is specifically tho. Doesn't have what built in? The mysql5 driver? You'll need to go and download a newer version from the mysql.com site. I think 3.0.17-ga is the newest that won't slow you down with the varchar strangeness*. Then you can use other when specifying a DSN type, and configure the datasource for mysql 5. *varchar strangeness is the added milliseconds for each varchar field included in the result set. Actually, I think maybe the updated datadirect drivers might have a newer mysql one? If you haven't gotten them from Adobe already, you should. Anyways, I'm not even sure if that's what you're having troubles with. Wanna clarify? Maybe try dropping the table, and running the create script from CF admin again? :-/ ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: coldfusion and jboss/tomcat
On 3/11/07, Dave W wrote: JBoss wants everything under the root context (say, /cfusion) I don't use JBoss for CF, but can't you just define the context root as / when you build your CF WAR/EAR? That's how CF works with JRun by default. Yessir, you can set the context to /. But there is some black magic involved in serving .cfm pages from outside the docroot (think jrun4/servers/cfusion.ear/cfusion.war/). Since tomcat expects all the dynamic stuff (.cfm) to be under the docroot, it wants it all there, vs. /srv/www/htdocs/site1/somecool.cfm. All tomcat needs is the WEB-INF folder to create a new context, so I can put one in a project, with a context of / for that project, but I'd have to do that for each project that expects to live at / (still too many :-/). I bet there is some simple way to achieve what I'm after, perhaps a custom servlet of small stature, or something? Some configuration option I missed? It's looking like it's deploying CF for each context too, which means I'm out of RAM pretty quick, I reckon. *sigh* My kingdom for the proper google search term, or some similar sentiment. 8D ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can I use CLIENT variable storage with MySQL 5?
Not sure it will help but this the SQL to create the tables for MS SQL. Note the table names are CDATA and CGLOBAL (not cFdata and cFglobal): CREATE TABLE [dbo].[CDATA] ( [cfid] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [app] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [data] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] CREATE TABLE [dbo].[CGLOBAL] ( [cfid] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [data] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [lvisit] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] - Original Message - From: Jonathan Block [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 1:24 AM Subject: Can I use CLIENT variable storage with MySQL 5? I'm trying very hard to figure out how to get MySql 5 to work with CF client variable storage. I need that... its a requirement. Has anybody done it before? The CF administrator does not have it built in, and when I try to manually create CFDATA and CFGLOBAL, my front end app errors out with a 500 database error. Thank you, Jon ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WSDL error
Has anyone ever run into this error while calling a web service?
Any thoughts on what it means?
Could not generate stub objects for web service invocation.
WSDLException (at /HTML): faultCode=INVALID_WSDL: Expected element
apos;{http://schemas.xmlsoap.org/wsdl/}definitionsapos;.: It is recommended
that you use a web browser to retrieve and examine the requested WSDL document
for correctness. If the requested WSDL document canapos;t be retrieved or it
is dynamically generated, it is likely that the target web service has
programming errors.
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272337
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WSDL error
Is the web server a ColdFusion one?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of the
intended recipient(s). If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Torrent Girl
To: CF-Talk
Sent: Mon Mar 12 11:38:43 2007
Subject: WSDL error
Has anyone ever run into this error while calling a web service?
Any thoughts on what it means?
Could not generate stub objects for web service invocation.
WSDLException (at /HTML): faultCode=INVALID_WSDL: Expected element
apos;{http://schemas.xmlsoap.org/wsdl/}definitionsapos;.: It is
recommended that you use a web browser to retrieve and examine the requested
WSDL document for correctness. If the requested WSDL document canapos;t be
retrieved or it is dynamically generated, it is likely that the target web
service has programming errors.
~|
ColdFusion MX7 and Flex 2
Build sales marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272338
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WSDL error
I don't think it is.
Is the web server a ColdFusion one?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of the
intended recipient(s). If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Torrent Girl
To: CF-Talk
Sent: Mon Mar 12 11:38:43 2007
Subject: WSDL error
Has anyone ever run into this error while calling a web service?
Any thoughts on what it means?
Could not generate stub objects for web service invocation.
WSDLException (at /HTML): faultCode=INVALID_WSDL: Expected element
apos;{http://schemas.xmlsoap.org/wsdl/}definitionsapos;.: It is
recommended that you use a web browser to retrieve and examine the requested
WSDL document for correctness. If the requested WSDL document canapos;t be
retrieved or it is dynamically generated, it is likely that the target web
service has programming errors.
~|
Macromedia ColdFusion MX7
Upgrade to MX7 experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272339
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: WSDL error
Can you browse to the WSDL?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of the
intended recipient(s). If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Torrent Girl
To: CF-Talk
Sent: Mon Mar 12 11:47:54 2007
Subject: Re: WSDL error
I don't think it is.
Is the web server a ColdFusion one?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of
the
intended recipient(s). If you are not the intended recipient(s) please
note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Torrent Girl
To: CF-Talk
Sent: Mon Mar 12 11:38:43 2007
Subject: WSDL error
Has anyone ever run into this error while calling a web service?
Any thoughts on what it means?
Could not generate stub objects for web service invocation.
WSDLException (at /HTML): faultCode=INVALID_WSDL: Expected element
apos;{http://schemas.xmlsoap.org/wsdl/}definitionsapos;.: It is
recommended that you use a web browser to retrieve and examine the
requested
WSDL document for correctness. If the requested WSDL document canapos;t be
retrieved or it is dynamically generated, it is likely that the target web
service has programming errors.
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade see new features.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272340
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WSDL error
yes Can you browse to the WSDL? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Torrent Girl To: CF-Talk Sent: Mon Mar 12 11:47:54 2007 Subject: Re: WSDL error I don't think it is. the intended recipient(s). If you are not the intended recipient(s) please note requested WSDL document for correctness. If the requested WSDL document canapos;t be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272341 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
Gareth Hughes wrote: Well, it was late when the last reply on this subject came through so I slept on it. And guess what? This morning all zones are reporting the correct time (on _11 _13). I would say this is a bug in the JVM. It was correctly identifying a zone was in new US DST but didn't factor it into the offset until 24hrs later. but the CFC is still broken as there is still an issue w/ dateConvert(). did the new one i sent work better? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Median Value
Hi, i am using ms sql server and need to implement get the median of a set of values. i have looked all over the web and cant find a simple explanation. i would appreciate it if anyone can provide me with a very simple explanation. i understand how it works in terms of having to first order the values ascending and then pick the middle value in the list if there is an odd number of rows, or take the 2 middle values and get the average value of these 2 values if there is an even number of rows. however i have no idea on how to implement this into my query The following is the sql statement that i need to adapt, i need to get the median value of the srtot value within the query. select pat_demid, pat_lastname, meas_gendate, meas_id, test_gendate, avg(srtot)as meansrtot, avg(sreff)as meansreff, avg(BFRaw)as BF_Rawmean, avg(BFTGV)as BF_TGVmean, ((stdev(srtot)/avg(srtot))*100) as srtotcv, ((stdev(sreff)/avg(sreff))*100) as sreffcv, ((stdev(BFRaw)/avg(BFRaw))*100) as BF_Rawcv, ((stdev(BFTGV)/avg(BFTGV))*100) as BF_TGVcv, count(srtot)as countsrtot, count(sreff)as countsreff from bodyparametersf where (srtot is not null) OR (sreff is not null) group by pat_demid, pat_lastname, meas_gendate, meas_id, test_gendate i would appreciate any of your advice in relation to this thanks very much ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
but the CFC is still broken as there is still an issue w/ dateConvert(). did the new one i sent work better? Sorry Paul, I didn't receive a new one from you. I tested using the older version I had and the latest version from your site. Both produced the same results. From what I understood of your blog post the issue with dateConvert() is that you can be x hours out during a DST switch over period. Using UTC or epoch as oppose to server time would resolve this. The thing I can't get my head around (and what made me think this was a JVM issue) is the fact that on Sunday: getRawOffset was reported correctly, -5 inDST was reported correctly, yes getDST was reported correctly, +1 getTZOffset was NOT reported correctly, -5 But today, offset is reported correctly as -4. Looking at the code, it doesn't look like dateConvert() factors in the above methods. This stuff is confsing :) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
variables scope app.cfc methods
Does anyone know how to write a variables.var in the onRequestStart() and be able to read it onRequest()? The usual suspects don't seem to work. Oblio This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Obscenity/Bad Words filter udf/cfc?
I don't have a UDF or CFC, but I do have some code for you: !--- list of no-no terms --- cfset VARIABLES.valid = 1 cfset VARIABLES.badterms = MIME-Version,Content-Type,bcc:,Content-Transfer-Encoding,text/plain !--- loop over form fields and see if there's any crap in them --- cfloop index=field list=#FORM.fieldnames# !--- loop over bad terms on this form field --- cfloop index=term list=#VARIABLES.badterms# !--- if there's crap in the form field then cancel the loop and break out --- cfif FindNoCase(term,Evaluate(FORM.field)) cfset VARIABLES.valid = 0 cfbreak /cfif /cfloop !--- if there's crap in the form field then cancel the loop and break out --- cfif NOT VARIABLES.valid cfbreak /cfif /cfloop cfif NOT VARIABLES.valid cflocation url=http://www.fortna.com; addToken=no cfelse FORM GOES HERE /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 6:15 PM To: CF-Talk Subject: Obscenity/Bad Words filter udf/cfc? Before I create something on my own, I was wondering if anyone already has an available obscenity or bad-words filter, either as a udf or a cfc. Something that can evaluate any textfield and replace or remove any bad words. Thank you in advance!! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Convert XML doc to array or structure or query?
I honestly don't have any clue Ben... I'm just thinking that it would be nice to allow people, when they call these Basecamp methods, to specify alternate return data types. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 4:21 PM To: CF-Talk Subject: RE: Convert XML doc to array or structure or query? Andy, Technically, I think an XML document is structured as nested structures and arrays. Can you give us perhaps a super small XML example and what kind of structure you are thinking of creating? ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 3:39 PM To: CF-Talk Subject: Convert XML doc to array or structure or query? Does anyone have code that will take an XML doc (any doc) and convert it to a series of nested structures or arrays or queries or some combination? I'm working on my basecamp API and I'd like to offer users the option of receiving the data in XML (the default format) or other formats. I checked cflib and found lots of stuff that converts those other formats into XML, but none that go the other way. Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WSDL error
What is the URL?
-Original Message-
From: Torrent Girl [mailto:[EMAIL PROTECTED]
Sent: 12 March 2007 11:39
To: CF-Talk
Subject: WSDL error
Has anyone ever run into this error while calling a web service?
Any thoughts on what it means?
Could not generate stub objects for web service invocation.
WSDLException (at /HTML): faultCode=INVALID_WSDL: Expected element
apos;{http://schemas.xmlsoap.org/wsdl/}definitionsapos;.: It is
recommended that you use a web browser to retrieve and examine the requested
WSDL document for correctness. If the requested WSDL document canapos;t be
retrieved or it is dynamically generated, it is likely that the target wwhat
eb service has programming errors.
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272348
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: WSDL error
It can't be accessed from outside..it is pw protected.
What is the URL?
-Original Message-
From: Torrent Girl [mailto:[EMAIL PROTECTED]
Sent: 12 March 2007 11:39
To: CF-Talk
Subject: WSDL error
Has anyone ever run into this error while calling a web service?
Any thoughts on what it means?
Could not generate stub objects for web service invocation.
WSDLException (at /HTML): faultCode=INVALID_WSDL: Expected element
apos;{http://schemas.xmlsoap.org/wsdl/}definitionsapos;.: It is
recommended that you use a web browser to retrieve and examine the requested
WSDL document for correctness. If the requested WSDL document canapos;t be
retrieved or it is dynamically generated, it is likely that the target wwhat
eb service has programming errors.
~|
Macromedia ColdFusion MX7
Upgrade to MX7 experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272349
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WSDL error
i got the same error for not closing the xml tag properly ,please check
ur input file,if u r using xml file as input.
Thanks
Regards
Srinivas
-Original Message-
From: Torrent Girl [mailto:[EMAIL PROTECTED]
Sent: 12 March 2007 11:39
To: CF-Talk
Subject: WSDL error
Has anyone ever run into this error while calling a web service?
Any thoughts on what it means?
Could not generate stub objects for web service invocation.
WSDLException (at /HTML): faultCode=INVALID_WSDL: Expected element
apos;{http://schemas.xmlsoap.org/wsdl/}definitionsapos;.: It is
recommended that you use a web browser to retrieve and examine the
requested
WSDL document for correctness. If the requested WSDL document canapos;t
be
retrieved or it is dynamically generated, it is likely that the target
wwhat
eb service has programming errors.
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272350
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Convert XML doc to array or structure or query?
I'm using that right now, but I just want to offer people alternatives. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, March 11, 2007 3:26 AM To: CF-Talk Subject: Re: Convert XML doc to array or structure or query? Yes: XLMParse() A CF XML object is a series of nested arrays of structs. On 3/10/07, Andy Matthews [EMAIL PROTECTED] wrote: Does anyone have code that will take an XML doc (any doc) and convert it to a series of nested structures or arrays or queries or some combination? I'm working on my basecamp API and I'd like to offer users the option of receiving the data in XML (the default format) or other formats. I checked cflib and found lots of stuff that converts those other formats into XML, but none that go the other way. Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WSDL error
The wsdl wasn't created by my but an outside agency. I will pass this along to them. Thank you i got the same error for not closing the xml tag properly ,please check ur input file,if u r using xml file as input. Thanks Regards Srinivas ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272352 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert XML doc to array or structure or query?
this works to convert from XML file to structure cfset Data=XmlSearch(arguments.requestData,REQUESTDATA/) cfloop from=1 to=#Arraylen(Data[i].XMLChildren)# index=idxData cfset createData[Data[i].XMLChildren[idxenrolmentData].XmlName]=Data[i].XMLChildren[idxData].XmlText /cfloop Thanks Regards Srinivas On 3/12/07, Andy Matthews [EMAIL PROTECTED] wrote: I'm using that right now, but I just want to offer people alternatives. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, March 11, 2007 3:26 AM To: CF-Talk Subject: Re: Convert XML doc to array or structure or query? Yes: XLMParse() A CF XML object is a series of nested arrays of structs. On 3/10/07, Andy Matthews [EMAIL PROTECTED] wrote: Does anyone have code that will take an XML doc (any doc) and convert it to a series of nested structures or arrays or queries or some combination? I'm working on my basecamp API and I'd like to offer users the option of receiving the data in XML (the default format) or other formats. I checked cflib and found lots of stuff that converts those other formats into XML, but none that go the other way. Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Median Value
Hi Richard, Take a look at this post that I found on tek-tips: http://www.tek-tips.com/faqs.cfm?fid=4751 Cheers, Kris Hi, i am using ms sql server and need to implement get the median of a set of values. i have looked all over the web and cant find a simple explanation. i would appreciate it if anyone can provide me with a very simple explanation. i understand how it works in terms of having to first order the values ascending and then pick the middle value in the list if there is an odd number of rows, or take the 2 middle values and get the average value of these 2 values if there is an even number of rows. however i have no idea on how to implement this into my query The following is the sql statement that i need to adapt, i need to get the median value of the srtot value within the query. select pat_demid, pat_lastname, meas_gendate, meas_id, test_gendate, avg(srtot)as meansrtot, avg(sreff)as meansreff, avg(BFRaw)as BF_Rawmean, avg(BFTGV)as BF_TGVmean, ((stdev(srtot)/avg(srtot))*100) as srtotcv, ((stdev(sreff)/avg(sreff))*100) as sreffcv, ((stdev(BFRaw)/avg(BFRaw))*100) as BF_Rawcv, ((stdev(BFTGV)/avg(BFTGV))*100) as BF_TGVcv, count(srtot)as countsrtot, count(sreff)as countsreff from bodyparametersf where (srtot is not null) OR (sreff is not null) group by pat_demid, pat_lastname, meas_gendate, meas_id, test_gendate ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272354 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
Gareth Hughes wrote: Sorry Paul, I didn't receive a new one from you. I tested using the older is this your real email? From what I understood of your blog post the issue with dateConvert() is that you can be x hours out during a DST switch over period. Using UTC or epoch as oppose to server time would resolve this. no, my blog talks about all cf datetime's being server datetimes which maybe not what you intended as far as tz goes. the dateConvert issue is that it doesn't take DST into account when converting. peter farrell's kind of an expert on the subject (at least he knows more about it than i do is willing to discuss the issue) but i can't see anything on his blog about it. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
I updated to _11 yesterday on a machine and it took immediately after I rebooted (I know I only needed to restart the service but...). I knew about the _13 thing but I had thought Adobe only supported _11 and using anything else may void service etc. I needed to call them today and find out since I wasn't the one that footed the bills for those service plans :) anyone else have info from the Adobe side of the house on this issue? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272356 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: variables scope app.cfc methods
Um, put it in the Request scope? Does anyone know how to write a variables.var in the onRequestStart() and be able to read it onRequest()? The usual suspects don't seem to work. Oblio This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
is this your real email? yes. no, my blog talks about all cf datetime's being server datetimes which maybe not what you intended as far as tz goes. Ah, that makes sense... the dateConvert issue is that it doesn't take DST into account when converting. but now I'm confused again :) So how come castFromServer returns the correct itme (including DST)? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
5 domains, one set of templates and one CF hosting account.
I'm looking for some real world advice on how to properly configure my ColdFusion application for one hosting account that will host five different web sites that share the same core templates. Only the images and the databased information will change from site to site. What is the best way to initially determine the domain? (Can CGI variables always be used?) Once determined, what is the best way to maintain its value (and any other necessary specific site values) from page to page? Would session variables be my best bet? I'm sure this has been done before. Especially with sites that are published in multiple languages. Any tips or advice would be appreciated. Thanks, Che ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: variables scope app.cfc methods
Thank you for the work around. However, I was asking about the variables scope, not the request scope. If it can't be done, I'd rather know that. Oblio -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:01 AM To: CF-Talk Subject: Re: variables scope app.cfc methods Um, put it in the Request scope? Does anyone know how to write a variables.var in the onRequestStart() and be able to read it onRequest()? The usual suspects don't seem to work. This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looks like the military is working on a fall-back plan in Iraq
From the LA Times: *Fallback Strategy For Iraq: Train Locals, Draw Down Forces* *(Los Angeles Times, March 12, 2007, Pg. 1)* American military planners have begun plotting a fallback strategy for Iraq that includes a gradual withdrawal of forces and a renewed emphasis on training Iraqi fighters in case the current troop buildup fails or is derailed by Congress. Such a strategy, based in part on the U.S. experience in El Salvador in the 1980s, is still in the early planning stages and would be adjusted to fit the outcome of the current surge in troop levels, according to military officials and Pentagon consultants. But a drawdown of forces would be in line with comments to Congress by Defense Secretary Robert M. Gates last month that if the surge fails, the backup plan would include moving troops out of harm's way. Such a plan also would be close to recommendations of the Iraq Study Group, of which Gates was a member before his appointment as Defense Department chief. -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looks like the military is working on a fall-back plan in Iraq
Hey Bruce, This is cf-talk bro, not community :) -- Timothy Heald Senior Developer/Architect HR/EX/SDD, SA-1, H808F Desk: 202-663-2752 Fax: 202-261-8299 Cell: 703-300-3911 -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:59 AM To: CF-Talk Subject: Looks like the military is working on a fall-back plan in Iraq From the LA Times: *Fallback Strategy For Iraq: Train Locals, Draw Down Forces* *(Los Angeles Times, March 12, 2007, Pg. 1)* American military planners have begun plotting a fallback strategy for Iraq that includes a gradual withdrawal of forces and a renewed emphasis on training Iraqi fighters in case the current troop buildup fails or is derailed by Congress. Such a strategy, based in part on the U.S. experience in El Salvador in the 1980s, is still in the early planning stages and would be adjusted to fit the outcome of the current surge in troop levels, according to military officials and Pentagon consultants. But a drawdown of forces would be in line with comments to Congress by Defense Secretary Robert M. Gates last month that if the surge fails, the backup plan would include moving troops out of harm's way. Such a plan also would be close to recommendations of the Iraq Study Group, of which Gates was a member before his appointment as Defense Department chief. -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272362 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looks like the military is working on a fall-back plan in Iraq
DOH! Sorry for the mix-up. I will move it. On 3/12/07, Heald, Timothy J [EMAIL PROTECTED] wrote: Hey Bruce, This is cf-talk bro, not community :) -- Timothy Heald Senior Developer/Architect HR/EX/SDD, SA-1, H808F Desk: 202-663-2752 Fax: 202-261-8299 Cell: 703-300-3911 -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:59 AM To: CF-Talk Subject: Looks like the military is working on a fall-back plan in Iraq From the LA Times: *Fallback Strategy For Iraq: Train Locals, Draw Down Forces* *(Los Angeles Times, March 12, 2007, Pg. 1)* American military planners have begun plotting a fallback strategy for Iraq that includes a gradual withdrawal of forces and a renewed emphasis on training Iraqi fighters in case the current troop buildup fails or is derailed by Congress. Such a strategy, based in part on the U.S. experience in El Salvador in the 1980s, is still in the early planning stages and would be adjusted to fit the outcome of the current surge in troop levels, according to military officials and Pentagon consultants. But a drawdown of forces would be in line with comments to Congress by Defense Secretary Robert M. Gates last month that if the surge fails, the backup plan would include moving troops out of harm's way. Such a plan also would be close to recommendations of the Iraq Study Group, of which Gates was a member before his appointment as Defense Department chief. -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: variables scope app.cfc methods
It's not a workaround, it's The Right Way. You want to transfer data from OnRequestStart to OnRequest, so you use the Request scope! You can't directly transfer var scoped data because the whole purpose of var-scoping is that it is local to that specific function. (You can of course use the Variables scope, but that offers no advantage over the Request scope, and is more ambiguous about where the variable is used) Thank you for the work around. However, I was asking about the variables scope, not the request scope. If it can't be done, I'd rather know that. Oblio -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:01 AM To: CF-Talk Subject: Re: variables scope app.cfc methods Um, put it in the Request scope? Does anyone know how to write a variables.var in the onRequestStart() and be able to read it onRequest()? The usual suspects don't seem to work. This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: variables scope app.cfc methods
I am not sure if the public VARIABLES scope exists in the OnRequestStart() event method. It might not exist until OnREquest(). If it does, you are probably gonna get all kinds of conflicting issues since VARIABLES is ALSO a scope within the Application.cfc component. Try this... Don't scope the variable at all. Just set variable names. ColdFusion by default puts these into the VARIABLES scope of the page. However, since you are in a component, this might not work (they might go into THIS scope). Try the non-scoping method and see if that works. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:48 AM To: CF-Talk Subject: RE: variables scope app.cfc methods Thank you for the work around. However, I was asking about the variables scope, not the request scope. If it can't be done, I'd rather know that. Oblio -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:01 AM To: CF-Talk Subject: Re: variables scope app.cfc methods Um, put it in the Request scope? Does anyone know how to write a variables.var in the onRequestStart() and be able to read it onRequest()? The usual suspects don't seem to work. This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
db locking
Hi. I have a database table with a single row and following columns: TotalMembers RegisteredToday NewestMember I update this row everytime someone registers. My question is, how should i control simultaneous updates/locking/unloking issues? Please help. Here's what i am doing right now: cftransaction cfquery UPDATE db_sitestats SET TotalMemembers = TotalMenbers+1, RegisteredToday = RegisteredToday+1... /cfquery cfquery name=getstats Select * from db_sitestats /cfquery cfset application.TotalMembers = #getstats.TotalMembers# cfset application.RegisteredToday = #getstats.RegisteredToday# /cftransaction Please tell if i need to do anything else. These Stats are always shown on the homepage of the site. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: variables scope app.cfc methods
Variables (of some form) does exist and is usable: cfcomponent cffunction name=OnRequestStart cfset Apple = Apple/ cfset Request.Ball = Ball/ cfset Variables.Camel = Camel/ /cffunction cffunction name=OnRequest cfdump var=#Apple#/ cfdump var=#Request#/ cfdump var=#Variables#/ /cffunction /cfcomponent This all worked. The Variables in the third dump contained both Apple and Camel. I am not sure if the public VARIABLES scope exists in the OnRequestStart() event method. It might not exist until OnREquest(). If it does, you are probably gonna get all kinds of conflicting issues since VARIABLES is ALSO a scope within the Application.cfc component. Try this... Don't scope the variable at all. Just set variable names. ColdFusion by default puts these into the VARIABLES scope of the page. However, since you are in a component, this might not work (they might go into THIS scope). Try the non-scoping method and see if that works. . Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:48 AM To: CF-Talk Subject: RE: variables scope app.cfc methods Thank you for the work around. However, I was asking about the variables scope, not the request scope. If it can't be done, I'd rather know that. Oblio -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:01 AM To: CF-Talk Subject: Re: variables scope app.cfc methods Um, put it in the Request scope? Does anyone know how to write a variables.var in the onRequestStart() and be able to read it onRequest()? The usual suspects don't seem to work. This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: db locking
You don't need those hashes in the CFSETs. Can't fully answer your question, but have a look at the ISOLATION attribute of CFTRANSACTION for a start. Hi. I have a database table with a single row and following columns: TotalMembers RegisteredToday NewestMember I update this row everytime someone registers. My question is, how should i control simultaneous updates/locking/unloking issues? Please help. Here's what i am doing right now: cftransaction cfquery UPDATE db_sitestats SET TotalMemembers = TotalMenbers+1, RegisteredToday = RegisteredToday+1... /cfquery cfquery name=getstats Select * from db_sitestats /cfquery cfset application.TotalMembers = #getstats.TotalMembers# cfset application.RegisteredToday = #getstats.RegisteredToday# /cftransaction Please tell if i need to do anything else. These Stats are always shown on the homepage of the site. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: variables scope app.cfc methods
Actually... Now that I think of it, since the OnRequest() method includes the content template... The entire page request should use the VARIABLES scope that is private to the Application.cfc... So yeah, that should work fine (although maybe its not exactly the proper VARIABLES scope). The better test might be: cffunction name=OnRequest cfinclude template=#ARGUMENTS[ 1 ]# / /cffunction Then in the included template, do this: cfset foo = bar / cfdump var=#VARIABLES# / See if foo shows up in that one. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 11:09 AM To: CF-Talk Subject: Re: variables scope app.cfc methods Variables (of some form) does exist and is usable: cfcomponent cffunction name=OnRequestStart cfset Apple = Apple/ cfset Request.Ball = Ball/ cfset Variables.Camel = Camel/ /cffunction cffunction name=OnRequest cfdump var=#Apple#/ cfdump var=#Request#/ cfdump var=#Variables#/ /cffunction /cfcomponent This all worked. The Variables in the third dump contained both Apple and Camel. I am not sure if the public VARIABLES scope exists in the OnRequestStart() event method. It might not exist until OnREquest(). If it does, you are probably gonna get all kinds of conflicting issues since VARIABLES is ALSO a scope within the Application.cfc component. Try this... Don't scope the variable at all. Just set variable names. ColdFusion by default puts these into the VARIABLES scope of the page. However, since you are in a component, this might not work (they might go into THIS scope). Try the non-scoping method and see if that works. . Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:48 AM To: CF-Talk Subject: RE: variables scope app.cfc methods Thank you for the work around. However, I was asking about the variables scope, not the request scope. If it can't be done, I'd rather know that. Oblio -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:01 AM To: CF-Talk Subject: Re: variables scope app.cfc methods Um, put it in the Request scope? Does anyone know how to write a variables.var in the onRequestStart() and be able to read it onRequest()? The usual suspects don't seem to work. This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: variables scope app.cfc methods
It is important to remember that there is 2 Variables scope in play here: The Variables scope of the CFC. The Variables scope of the CFM. They are NOT the same. However, things get funky when you use onRequest. The mere presence of onRequest will copy the Variables (and the This scope and the methods) from your Application.cfc file into your CFM file. So you could define a UDF in onRequestStart and since your onRequest exists, it will be copied over. However, that tends to bug me. And if you stop using onRequest, then you can't use this 'by product' of the method. So I'll ditto others. Use the Request scope. It makes sense and helps keep your Variables scope a bit cleaner. (Your Variables should really just be what are defined on the page itself.) On 3/12/07, Peter Boughton [EMAIL PROTECTED] wrote: Variables (of some form) does exist and is usable: cfcomponent cffunction name=OnRequestStart cfset Apple = Apple/ cfset Request.Ball = Ball/ cfset Variables.Camel = Camel/ /cffunction cffunction name=OnRequest cfdump var=#Apple#/ cfdump var=#Request#/ cfdump var=#Variables#/ /cffunction /cfcomponent This all worked. The Variables in the third dump contained both Apple and Camel. I am not sure if the public VARIABLES scope exists in the OnRequestStart() event method. It might not exist until OnREquest(). If it does, you are probably gonna get all kinds of conflicting issues since VARIABLES is ALSO a scope within the Application.cfc component. Try this... Don't scope the variable at all. Just set variable names. ColdFusion by default puts these into the VARIABLES scope of the page. However, since you are in a component, this might not work (they might go into THIS scope). Try the non-scoping method and see if that works. . Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:48 AM To: CF-Talk Subject: RE: variables scope app.cfc methods Thank you for the work around. However, I was asking about the variables scope, not the request scope. If it can't be done, I'd rather know that. Oblio -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:01 AM To: CF-Talk Subject: Re: variables scope app.cfc methods Um, put it in the Request scope? Does anyone know how to write a variables.var in the onRequestStart() and be able to read it onRequest()? The usual suspects don't seem to work. This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: coldfusion and jboss/tomcat
It's actually quite simple to do. Just takes some tinkering with your web.xml file. http://www.fusioncube.net/index.php/coldfusion-from-anywhere.html Steve Brownlee http://www.fusioncube.net/ -Original Message- From: Dinner [mailto:[EMAIL PROTECTED] Sent: Sunday, March 11, 2007 7:52 PM To: CF-Talk Subject: coldfusion and jboss/tomcat Hi! I'm enjoying running CF on jboss/tomcat, with the sole exception being- JBoss wants everything under the root context (say, /cfusion) It wouldn't be a problem if all my projects were set up to not care, but sadly, some of them expect to be @ / vs /cfusion/cfapp/. I could set up a context for each CF app, but I've got like 20 of them, and I don't really want to put a WEB-INF folder in each. Or add 20 tomcat virtual hosts to match my apache virtual hosts. I've got apache set up to use mod_proxy_ajp, and my projects are all hosted at 127.0.0.1, with different host names, using apache NamedVirtualHosts. (http://proj1/, http://proj2/, etc.) Any suggestions on how to use a single CF instance to serve multiple websites when running on top of tomcat/jboss? I like separate instances for production, but I've only got s much RAM locally. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: pie cfchart, start with a vertical?
Bump. I'm interested too. Mik At 12:41 PM 3/9/2007, you wrote: Hi, i have the following code for a chchart: cfchart chartheight=190 chartwidth=160 cfchartseries type=pie colorlist=Red,Green datalabelstyle=none cfchartdata item=Used value=5 cfchartdata item=Free 245 MB value=245 /cfchartseries /cfchart The problem is that the first item Used seems to start at a random angle and I would really like it to start at 0 degrees (straight up). Is there anyway to do this? Thanks, Sam ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 5 domains, one set of templates and one CF hosting account.
You could do this many ways: For multiple languages, I often use session vars (that way the URLS don't get bogged up, but you do use a few more resources having all those sessions flying around I guess) But multiple sites, i.e different domain names on one hosted account I run each site out of it's own folder, then use ISAPI to rewrite the URLS: so www.domain.com/site1/ - www.site1.com This way, you could have a siteroot application.cfc, and then application.cfc's which extend the site root cfc. I've got about 25 sites running out of one hosting account using that technique: only catch is you can't use absolute siteroot URLs. T On 12 Mar 2007, at 14:40, Che Vilnonis wrote: I'm looking for some real world advice on how to properly configure my ColdFusion application for one hosting account that will host five different web sites that share the same core templates. Only the images and the databased information will change from site to site. What is the best way to initially determine the domain? (Can CGI variables always be used?) Once determined, what is the best way to maintain its value (and any other necessary specific site values) from page to page? Would session variables be my best bet? I'm sure this has been done before. Especially with sites that are published in multiple languages. Any tips or advice would be appreciated. Thanks, Che ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
TIMEZONE issues?? anyone?
our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272374 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TIMEZONE issues?? anyone?
All of mine are running fine. Win 200 and W2K3 servers From: Tony [mailto:[EMAIL PROTECTED] Sent: Mon 3/12/2007 12:03 PM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: TIMEZONE issues?? anyone?
what did you do for your win2k boxes? just wondering if we did same stuff. tw On 3/12/07, Adkins, Randy [EMAIL PROTECTED] wrote: All of mine are running fine. Win 200 and W2K3 servers From: Tony [mailto:[EMAIL PROTECTED] Sent: Mon 3/12/2007 12:03 PM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: TIMEZONE issues?? anyone?
Did you do the last step of tzedit?? You need to change timezone then change back for the update to take?? Eric On 3/12/07, Adkins, Randy [EMAIL PROTECTED] wrote: All of mine are running fine. Win 200 and W2K3 servers From: Tony [mailto:[EMAIL PROTECTED] Sent: Mon 3/12/2007 12:03 PM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: TIMEZONE issues?? anyone?
To manually modify time zone settings by using the Time Zone Editor, follow these steps:1.Start Time Zone Editor.2.In the *Time Zones* list, select a time zone, and then click *Edit*. For example, click *(GMT-08:00) Pacific Time (US Canada); Tijuana*, and then click *Edit*.3.In the *Edit Time Zone * dialog box, click to select the *Automatically set Daylight Saving Time*check box. 4.Specify the correct daylight saving time start date and end date. To do this, follow these steps:a. In the *Start Day* box, click the number of the day, the corresponding day of the week, and the month that you want. For example, click *Second*, click *Sunday*, and then click *March*.b. Select the time that you want to start daylight saving time. For example, select *2:00 A.M.*c. In the *Last Day* box, click the number of the day, the corresponding day of the week, and the month that you want. For example, click *First*, click *Sunday*, and then click *November*. d. Select the time that you want to end daylight saving time. For example, select *2:00 A.M.*e. In the *Daylight Bias* list, select how long you want the time to change when daylight saving time is in effect. For example, to set the clock forward 1 hour, leave the default setting of *+1:00*.f. Click *OK*.g. Select another time zone that has changed, and then repeat steps a-e. For more information about the time zones that have changed, click the following article number to view the article in the Microsoft Knowledge Base: 931836http://support.microsoft.com/kb/931836/( http://support.microsoft.com/kb/931836/) February 2007 cumulative time zone update rollup for Microsoft Windows operating systems Repeat steps a through f for every time zone that has changed. When you have finished, click *Close*.h. Click *Start*, point to *Settings*, point to *Control Panel*, and then double-click *Date/Time*.i. Click the *Time Zone* tab.j. Select a different time zone than the *(GMT-08:00) Pacific Time (US Canada); Tijuana* time zone, and then click *Apply*.k. Click *(GMT-08:00) Pacific Time (US Canada); Tijuana*, and then click *OK*. *Note* Steps j and k are required for the new changes to take effect. On 3/12/07, Eric Haskins [EMAIL PROTECTED] wrote: Did you do the last step of tzedit?? You need to change timezone then change back for the update to take?? Eric On 3/12/07, Adkins, Randy [EMAIL PROTECTED] wrote: All of mine are running fine. Win 200 and W2K3 servers From: Tony [mailto:[EMAIL PROTECTED] Sent: Mon 3/12/2007 12:03 PM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272378 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: TIMEZONE issues?? anyone?
yes, that was done. tw On 3/12/07, Eric Haskins [EMAIL PROTECTED] wrote: Did you do the last step of tzedit?? You need to change timezone then change back for the update to take?? Eric On 3/12/07, Adkins, Randy [EMAIL PROTECTED] wrote: All of mine are running fine. Win 200 and W2K3 servers From: Tony [mailto:[EMAIL PROTECTED] Sent: Mon 3/12/2007 12:03 PM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TIMEZONE issues?? anyone?
Didn't do the tzupdater; we did the 1.4.2_13 (14?) update. Had to reboot. -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 12:03 PM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TIMEZONE issues?? anyone?
I did the following steps outlined in KB914387 http://support.microsoft.com/kb/914387/ From: Tony [mailto:[EMAIL PROTECTED] Sent: Mon 3/12/2007 12:16 PM To: CF-Talk Subject: Re: TIMEZONE issues?? anyone? what did you do for your win2k boxes? just wondering if we did same stuff. tw On 3/12/07, Adkins, Randy [EMAIL PROTECTED] wrote: All of mine are running fine. Win 200 and W2K3 servers From: Tony [mailto:[EMAIL PROTECTED] Sent: Mon 3/12/2007 12:03 PM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: TIMEZONE issues?? anyone?
H Took on all 5 of our 2K servers. Although I did hear that some of the other 2K servers needed to use the vbs w/ .reg file version before it worked. Eric On 3/12/07, Tony [EMAIL PROTECTED] wrote: yes, that was done. tw On 3/12/07, Eric Haskins [EMAIL PROTECTED] wrote: Did you do the last step of tzedit?? You need to change timezone then change back for the update to take?? Eric On 3/12/07, Adkins, Randy [EMAIL PROTECTED] wrote: All of mine are running fine. Win 200 and W2K3 servers From: Tony [mailto:[EMAIL PROTECTED] Sent: Mon 3/12/2007 12:03 PM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: TIMEZONE issues?? anyone?
We are working ok now. We run single instance installs on Linux. Following a Adobe TechNote linked from Fort's blog, I downloaded the SDK JVM version 1.4.2_11 on our boxes, and then pointed the jvm.config file so the java.home pointed to the jre folder. After a restart the time started working correctly. We also have added the following to our java.args in the past to pick up the correct time zone: -Duser.timezone=America/Chicago ~Brad -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:03 AM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: TIMEZONE issues?? anyone?
From my previous post I believe the servers that didnt update were our domain controllers but MS released another KB on this (KB931836) Take a look Eric On 3/12/07, Brad Wood [EMAIL PROTECTED] wrote: We are working ok now. We run single instance installs on Linux. Following a Adobe TechNote linked from Fort's blog, I downloaded the SDK JVM version 1.4.2_11 on our boxes, and then pointed the jvm.config file so the java.home pointed to the jre folder. After a restart the time started working correctly. We also have added the following to our java.args in the past to pick up the correct time zone: -Duser.timezone=America/Chicago ~Brad -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 10:03 AM To: CF-Talk Subject: TIMEZONE issues?? anyone? our servers, patched, changed, etc, tzupdater too, are not working right. windows 2000 any ideas? thanks tony ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
changing the underlying webserver from iis - apache
Hi list, has someone ever made experience to change the webserver on a CFMX-production engine (CFMX 6.1) ? We want to move away from IIS 6 to Apache 2.0.x on the same box. I want to keep the downtime as short as possible. Any suggestions ? Uwe ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: changing the underlying webserver from iis - apache
Apache and IIS can run on the same box. My suggestion would be to set up apache on a separate ip (run the IIS tool to make it non-greedy and not take up all the addresses), set up apache on that IP, connect it to CF and do your testing. Once you're satisfied that everything is working, assign the rest of the IPs to apache, stop IIS and restart apache. Total downtime should be only a few seconds... Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 12:52 PM To: CF-Talk Subject: changing the underlying webserver from iis - apache Hi list, has someone ever made experience to change the webserver on a CFMX-production engine (CFMX 6.1) ? We want to move away from IIS 6 to Apache 2.0.x on the same box. I want to keep the downtime as short as possible. Any suggestions ? Uwe ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Obscenity/Bad Words filter udf/cfc?
Thanks Andy. Matt Q actually found me a UDF in cflib that loops pretty much the same way as your code. It does, however, just replaces the profanity with [EMAIL PROTECTED] chars. Michael -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 6:10 AM To: CF-Talk Subject: RE: Obscenity/Bad Words filter udf/cfc? I don't have a UDF or CFC, but I do have some code for you: !--- list of no-no terms --- cfset VARIABLES.valid = 1 cfset VARIABLES.badterms = MIME-Version,Content-Type,bcc:,Content-Transfer-Encoding,text/plain !--- loop over form fields and see if there's any crap in them --- cfloop index=field list=#FORM.fieldnames# !--- loop over bad terms on this form field --- cfloop index=term list=#VARIABLES.badterms# !--- if there's crap in the form field then cancel the loop and break out --- cfif FindNoCase(term,Evaluate(FORM.field)) cfset VARIABLES.valid = 0 cfbreak /cfif /cfloop !--- if there's crap in the form field then cancel the loop and break out --- cfif NOT VARIABLES.valid cfbreak /cfif /cfloop cfif NOT VARIABLES.valid cflocation url=http://www.fortna.com; addToken=no cfelse FORM GOES HERE /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 6:15 PM To: CF-Talk Subject: Obscenity/Bad Words filter udf/cfc? Before I create something on my own, I was wondering if anyone already has an available obscenity or bad-words filter, either as a udf or a cfc. Something that can evaluate any textfield and replace or remove any bad words. Thank you in advance!! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Median Value
thank kris, the problem i am having is that all the information i find is always centered around getting a median using every single row in the table. except i have groups of data in the table and want to work out a median for each group. the group is identified by 4 different columns (the 5th column is what i want to get the median on but for each group not the entire table) and i want to produce a resulting table that has 1 row for each group and therefore contains the median value for the group instead of the individual numbers that it currently has. e.g. the current table is like this column1 column2column3column 4 column5(i need the mean of this) value 1 value 2value 3value 4 1.2 value 1 value 2value 3value 4 1.0 value 1 value 2value 3value 4 1.5 value 2 value 3value 4value 5 0.2 value 2 value 3value 4value 5 0.4 etc... and i need a query to get the results to show like this column1 column2column3column 4 column5(i need the mean of this) value 1 value 2value 3value 4 1.0 value 2 value 3value 4value 5 0.3 etc... This is driving me crazy and i will be very helpful if anyone can help ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Text Similarity Algorithm
Post your email and will contact you directly. My email is chrisl [symbol] higheredjobs [you know] com. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: changing the underlying webserver from iis - apache
Hi Russ, thank you. Sounds fine to me, if it works that way. Too questions: a) Yes i wanted to run both servers on the same box but with different ports. (or different IPs as you mentioned). But what is the IIS tool ? Never heard of it. b) I wonder how ColdFusion can handle the requests of two different webservers at the same time on the same machine - for testing - as you mentioned it? Uwe Apache and IIS can run on the same box. My suggestion would be to set up apache on a separate ip (run the IIS tool to make it non-greedy and not take up all the addresses), set up apache on that IP, connect it to CF and do your testing. Once you're satisfied that everything is working, assign the rest of the IPs to apache, stop IIS and restart apache. Total downtime should be only a few seconds... Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 12:52 PM To: CF-Talk Subject: changing the underlying webserver from iis - apache Hi list, has someone ever made experience to change the webserver on a CFMX-production engine (CFMX 6.1) ? We want to move away from IIS 6 to Apache 2.0.x on the same box. I want to keep the downtime as short as possible. Any suggestions ? Uwe ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Obscenity/Bad Words filter udf/cfc?
Cool...mine is more to prevent form spam abuse, but the principle would be the same. Glad you found something that works for you. -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 12:25 PM To: CF-Talk Subject: RE: Obscenity/Bad Words filter udf/cfc? Thanks Andy. Matt Q actually found me a UDF in cflib that loops pretty much the same way as your code. It does, however, just replaces the profanity with [EMAIL PROTECTED] chars. Michael -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 6:10 AM To: CF-Talk Subject: RE: Obscenity/Bad Words filter udf/cfc? I don't have a UDF or CFC, but I do have some code for you: !--- list of no-no terms --- cfset VARIABLES.valid = 1 cfset VARIABLES.badterms = MIME-Version,Content-Type,bcc:,Content-Transfer-Encoding,text/plain !--- loop over form fields and see if there's any crap in them --- cfloop index=field list=#FORM.fieldnames# !--- loop over bad terms on this form field --- cfloop index=term list=#VARIABLES.badterms# !--- if there's crap in the form field then cancel the loop and break out --- cfif FindNoCase(term,Evaluate(FORM.field)) cfset VARIABLES.valid = 0 cfbreak /cfif /cfloop !--- if there's crap in the form field then cancel the loop and break out --- cfif NOT VARIABLES.valid cfbreak /cfif /cfloop cfif NOT VARIABLES.valid cflocation url=http://www.fortna.com; addToken=no cfelse FORM GOES HERE /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 6:15 PM To: CF-Talk Subject: Obscenity/Bad Words filter udf/cfc? Before I create something on my own, I was wondering if anyone already has an available obscenity or bad-words filter, either as a udf or a cfc. Something that can evaluate any textfield and replace or remove any bad words. Thank you in advance!! ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Web Service Complex Data
Hello, we are trying to consume a web service from ODFL shipping,
unfortunately it wants to see the variable as a string or string array like:
String[] weights = { 555, 0, 0, 0, 0 };
Here is the component script:
http://quote.on-sitesystems.com/odfl/rate_estimate/rate_quote.cfm
cfset xZip = JavaCast(string,30024)
cfinvoke
webservice =
http://quote.on-sitesystems.com/odfl/rate_estimate/RateEstimate.wsdl;
method = calculateRate returnvariable=foo
oZip = #xZip#
oCity= SUWANEE
ERROR
Could not perform web service invocation calculateRate because
java.lang.IllegalArgumentException: argument type mismatch
I tried using this article:
http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1554.htm
DIdn't help much
ANy ideas ?? How do we cast it so it sees it correctly?
Thanks
Sean
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2.
Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272392
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: changing the underlying webserver from iis - apache
If you are using Windows 2003 SP1, I have posted instructions on getting it to work on my blog here: http://www.ruslansivak.com/index.cfm/2007/3/12/Getting-IIS-and-Apache-to-run -side-by-side-on-Windows-2003 If you are using a different OS, let me know and I'll try to find out what the steps are for that OS. Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 1:51 PM To: CF-Talk Subject: Re: changing the underlying webserver from iis - apache Hi Russ, thank you. Sounds fine to me, if it works that way. Too questions: a) Yes i wanted to run both servers on the same box but with different ports. (or different IPs as you mentioned). But what is the IIS tool ? Never heard of it. b) I wonder how ColdFusion can handle the requests of two different webservers at the same time on the same machine - for testing - as you mentioned it? Uwe Apache and IIS can run on the same box. My suggestion would be to set up apache on a separate ip (run the IIS tool to make it non-greedy and not take up all the addresses), set up apache on that IP, connect it to CF and do your testing. Once you're satisfied that everything is working, assign the rest of the IPs to apache, stop IIS and restart apache. Total downtime should be only a few seconds... Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 12:52 PM To: CF-Talk Subject: changing the underlying webserver from iis - apache Hi list, has someone ever made experience to change the webserver on a CFMX-production engine (CFMX 6.1) ? We want to move away from IIS 6 to Apache 2.0.x on the same box. I want to keep the downtime as short as possible. Any suggestions ? Uwe ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls
I (think) I've seen folks recommending cfimport over cf_MyTag and cfmodule template=MyTag for custom tag calls. I usually use a custom tag for header/footer inclusion like this cf_MySiteHeadFoot ... my body /cf_MySiteHeadFoot But was wondering if there's an advantage to cfimport. (Also, does cfimport allow cf-mapped paths now? I read that it didn't used to, at least.) Can someone straighten me out as to the pros and cons of cfimport, cf_MyTag, and cfmodule? Thanks, Jamie ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272394 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: changing the underlying webserver from iis - apache
Here is a shorter URL that hopefully won't wrap: http://www.ruslansivak.com/index.cfm?mode=entryentry=4787B74A-E0C8-34F5-E0B 68C6A0A1B88B1 Russ -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 3:09 PM To: CF-Talk Subject: RE: changing the underlying webserver from iis - apache If you are using Windows 2003 SP1, I have posted instructions on getting it to work on my blog here: http://www.ruslansivak.com/index.cfm/2007/3/12/Getting-IIS-and-Apache-to- run -side-by-side-on-Windows-2003 If you are using a different OS, let me know and I'll try to find out what the steps are for that OS. Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 1:51 PM To: CF-Talk Subject: Re: changing the underlying webserver from iis - apache Hi Russ, thank you. Sounds fine to me, if it works that way. Too questions: a) Yes i wanted to run both servers on the same box but with different ports. (or different IPs as you mentioned). But what is the IIS tool ? Never heard of it. b) I wonder how ColdFusion can handle the requests of two different webservers at the same time on the same machine - for testing - as you mentioned it? Uwe Apache and IIS can run on the same box. My suggestion would be to set up apache on a separate ip (run the IIS tool to make it non-greedy and not take up all the addresses), set up apache on that IP, connect it to CF and do your testing. Once you're satisfied that everything is working, assign the rest of the IPs to apache, stop IIS and restart apache. Total downtime should be only a few seconds... Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 12:52 PM To: CF-Talk Subject: changing the underlying webserver from iis - apache Hi list, has someone ever made experience to change the webserver on a CFMX-production engine (CFMX 6.1) ? We want to move away from IIS 6 to Apache 2.0.x on the same box. I want to keep the downtime as short as possible. Any suggestions ? Uwe ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls
CFImport allows you to create tag prefixes. You can also use a template path (which cf_tagname does not have). I think it's a very elegant way to group tag functionality. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 3:39 PM To: CF-Talk Subject: cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls I (think) I've seen folks recommending cfimport over cf_MyTag and cfmodule template=MyTag for custom tag calls. I usually use a custom tag for header/footer inclusion like this cf_MySiteHeadFoot ... my body /cf_MySiteHeadFoot But was wondering if there's an advantage to cfimport. (Also, does cfimport allow cf-mapped paths now? I read that it didn't used to, at least.) Can someone straighten me out as to the pros and cons of cfimport, cf_MyTag, and cfmodule? Thanks, Jamie ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls
As a negative to this positive, every CFM that wants to use this format has to have a cfimport, while cf_/cfmodule just works fine. This is a very minor negative though. Just making sure you know. On 3/12/07, Ben Nadel [EMAIL PROTECTED] wrote: CFImport allows you to create tag prefixes. You can also use a template path (which cf_tagname does not have). I think it's a very elegant way to group tag functionality. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 3:39 PM To: CF-Talk Subject: cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls I (think) I've seen folks recommending cfimport over cf_MyTag and cfmodule template=MyTag for custom tag calls. I usually use a custom tag for header/footer inclusion like this cf_MySiteHeadFoot ... my body /cf_MySiteHeadFoot But was wondering if there's an advantage to cfimport. (Also, does cfimport allow cf-mapped paths now? I read that it didn't used to, at least.) Can someone straighten me out as to the pros and cons of cfimport, cf_MyTag, and cfmodule? Thanks, Jamie ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls
Very true. Also, I know that CFImport cannot have dynamic template path (ie. No ## in the template attribute). Not sure if CFModule is the same way (but I guess that it probably is). .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:08 PM To: CF-Talk Subject: Re: cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls As a negative to this positive, every CFM that wants to use this format has to have a cfimport, while cf_/cfmodule just works fine. This is a very minor negative though. Just making sure you know. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls
Jamie Jackson wrote: I (think) I've seen folks recommending cfimport over cf_MyTag and cfmodule template=MyTag for custom tag calls. I usually use a custom tag for header/footer inclusion like this cf_MySiteHeadFoot ... my body /cf_MySiteHeadFoot But was wondering if there's an advantage to cfimport. cfimport is a compile-time directive and does not have an execution time overhead (but your compiled template will be inflated). (Also, does cfimport allow cf-mapped paths now? I read that it didn't used to, at least.) It does as long as they are defined at compile time. Jochem ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
What is wrong with this?
Hi, all... I'm getting an invalid format mask on this: Value=#NumberFormat(Get_Property_Details.Sale_Price, )# Why? Thanks, Rick ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Having trouble getting variables from different tables to output
Hey guys! I'm new to ColdFusion and having some problems altering some old cfm pages I've inherited as the new IT guy. I don't know much about ColdFusion but I've been able to stumble around and change a few things but one page (actually, two similar pages) in particular is giving me a problem. We are a print shop and our website is linked to our database through CF. We've got several order pages that display order numbers, order names, stocks, inks, all kinds of print-related information. I've been asked to put our reorder information on the order detail page so that customers can look up a past order and order with that number and not have to submit artwork again. There are two pertinent tables: QOrdLineItems and QHistRO. The first query looks like this: cfquery name=Recordset1 datasource=AR SELECT OrderNum, Status, MainLine, acct_id, date, po_num FROM QOrdLineItems WHERE acct_id = '#COOKIE.id#' ORDER BY date DESC /cfquery My understanding is this pulls five variables from QOrdLineItems when the variable acct_id matches the id in the cookie being set when logged in. I have no idea what ORDER BY date DESC does. The new reorder information I need to output is in the QHistRO table and is in two different columns called reorder_num and control_num. I've tried a bunch of differnet ways to call these variables and none so far have worked, although it may be my output statements that aren't working. Currently I have this query: cfquery name=Recordset2 datasource=AR SELECT reorder_num, control_num FROM QHistRO WHERE reorder_num = '#Recordset1.OrderNum#' OR control_num = '#Recordset1.OrderNum#' /cfquery I'm trying to pull the variables from the table only when the reorder_num/control_num matches the OrderNum in Recordset1 pulled from QOrdLineItems. I'm outputting the variables with (the startrow maxrows are defined elsewhere and not causing problems): table cfoutput query=Recordset1 startrow=#StartRow_Recordset1# maxrows=#MaxRows_Recordset1# cfset realdate = #Mid(Recordset1.date,5,2)#-#Mid(Recordset1.date,7,2)#-#Mid(Recordset1.date, 3,2)# tr td align=center#realdate#/td tdnbsp;#Recordset1.MainLine#/td td align=centera href=/orders/ord.cfm?ID=#Recordset1.ordernum# title=View Order Details#Recordset1.Ordernum# img src=/details.jpg border=0/a/td td align=centernbsp;#stat#/td td align=centernbsp;#Recordset1.PO_num#nbsp;/td /cfoutput td align=centercfoutput#Recordset2.control_num#/cfoutput/td td align=centercfoutput#Recordset2.reorder_num#/cfoutput/td /tr /table I have sucessfully pulled those variables into a different page and got them to output using this code (the URL.ID is the order_num variable): cfparam name=URL.ID default=0TU45375 cfparam name=URL.Ref_1 default=TU cfif #url.id# contains NIcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains TUcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains DQcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains 00cfset newnumber = #mid(url.id,3,6)#/cfif cfquery name=HistRO datasource=AR SELECT invoice_num, reorder_num, control_num FROM QHistRO WHERE reorder_num = '#URL.ID#' or control_num= '#URL.ID#' /cfquery Control #brcfoutput#HistRO.control_num#/cfoutputbr Reorder #brcfoutput#HistRO.reorder_num#/cfoutputbr I don't know a lot about ColdFusion and I've actually accomplished more than I thought I could but I'm hoping someone can help me finish this problem. Thanks, Mike ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Having trouble getting variables from different tables to output
perhaps i'm reading this wrong, but do you have to do 2 queries for this, or can you join the tables, then group the output to get what you need? On 3/12/07, Michael Stevens [EMAIL PROTECTED] wrote: Hey guys! I'm new to ColdFusion and having some problems altering some old cfm pages I've inherited as the new IT guy. I don't know much about ColdFusion but I've been able to stumble around and change a few things but one page (actually, two similar pages) in particular is giving me a problem. We are a print shop and our website is linked to our database through CF. We've got several order pages that display order numbers, order names, stocks, inks, all kinds of print-related information. I've been asked to put our reorder information on the order detail page so that customers can look up a past order and order with that number and not have to submit artwork again. There are two pertinent tables: QOrdLineItems and QHistRO. The first query looks like this: cfquery name=Recordset1 datasource=AR SELECT OrderNum, Status, MainLine, acct_id, date, po_num FROM QOrdLineItems WHERE acct_id = '#COOKIE.id#' ORDER BY date DESC /cfquery My understanding is this pulls five variables from QOrdLineItems when the variable acct_id matches the id in the cookie being set when logged in. I have no idea what ORDER BY date DESC does. The new reorder information I need to output is in the QHistRO table and is in two different columns called reorder_num and control_num. I've tried a bunch of differnet ways to call these variables and none so far have worked, although it may be my output statements that aren't working. Currently I have this query: cfquery name=Recordset2 datasource=AR SELECT reorder_num, control_num FROM QHistRO WHERE reorder_num = '#Recordset1.OrderNum#' OR control_num = '#Recordset1.OrderNum#' /cfquery I'm trying to pull the variables from the table only when the reorder_num/control_num matches the OrderNum in Recordset1 pulled from QOrdLineItems. I'm outputting the variables with (the startrow maxrows are defined elsewhere and not causing problems): table cfoutput query=Recordset1 startrow=#StartRow_Recordset1# maxrows=#MaxRows_Recordset1# cfset realdate = #Mid(Recordset1.date,5,2)#-#Mid(Recordset1.date,7,2)#-#Mid(Recordset1.date, 3,2)# tr td align=center#realdate#/td tdnbsp;#Recordset1.MainLine#/td td align=centera href=/orders/ord.cfm?ID=#Recordset1.ordernum# title=View Order Details#Recordset1.Ordernum# img src=/details.jpg border=0/a/td td align=centernbsp;#stat#/td td align=centernbsp;#Recordset1.PO_num#nbsp;/td /cfoutput td align=centercfoutput#Recordset2.control_num#/cfoutput/td td align=centercfoutput#Recordset2.reorder_num#/cfoutput/td /tr /table I have sucessfully pulled those variables into a different page and got them to output using this code (the URL.ID is the order_num variable): cfparam name=URL.ID default=0TU45375 cfparam name=URL.Ref_1 default=TU cfif #url.id# contains NIcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains TUcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains DQcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains 00cfset newnumber = #mid(url.id,3,6)#/cfif cfquery name=HistRO datasource=AR SELECT invoice_num, reorder_num, control_num FROM QHistRO WHERE reorder_num = '#URL.ID#' or control_num= '#URL.ID#' /cfquery Control #brcfoutput#HistRO.control_num#/cfoutputbr Reorder #brcfoutput#HistRO.reorder_num#/cfoutputbr I don't know a lot about ColdFusion and I've actually accomplished more than I thought I could but I'm hoping someone can help me finish this problem. Thanks, Mike ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What is wrong with this?
Rick Faircloth wrote: I'm getting an invalid format mask on this: Value=#NumberFormat(Get_Property_Details.Sale_Price, )# Is Get_Property_Details.Sale_Price a number? Or, since it's obviously intended as an amount of money, does the value have something else in it, like a dollar sign? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What is wrong with this?
looks fine...what's the value being returned in your var? On 3/12/07, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... I'm getting an invalid format mask on this: Value=#NumberFormat(Get_Property_Details.Sale_Price, )# Why? Thanks, Rick ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What is wrong with this?
Try using single quotes around the . -- Josh - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 1:31 PM Subject: What is wrong with this? Hi, all... I'm getting an invalid format mask on this: Value=#NumberFormat(Get_Property_Details.Sale_Price, )# Why? Thanks, Rick ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: changing the underlying webserver from iis - apache
Hi Russ, thanks again. I will have a look into this. And CF doesn't get a problem with Apache/IIS trying to access simultaneously ? Uwe If you are using Windows 2003 SP1, I have posted instructions on getting it to work on my blog here: http://www.ruslansivak.com/index.cfm/2007/3/12/Getting-IIS-and-Apache-to-run -side-by-side-on-Windows-2003 If you are using a different OS, let me know and I'll try to find out what the steps are for that OS. Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 1:51 PM To: CF-Talk Subject: Re: changing the underlying webserver from iis - apache Hi Russ, thank you. Sounds fine to me, if it works that way. Too questions: a) Yes i wanted to run both servers on the same box but with different ports. (or different IPs as you mentioned). But what is the IIS tool ? Never heard of it. b) I wonder how ColdFusion can handle the requests of two different webservers at the same time on the same machine - for testing - as you mentioned it? Uwe Apache and IIS can run on the same box. My suggestion would be to set up apache on a separate ip (run the IIS tool to make it non-greedy and not take up all the addresses), set up apache on that IP, connect it to CF and do your testing. Once you're satisfied that everything is working, assign the rest of the IPs to apache, stop IIS and restart apache. Total downtime should be only a few seconds... Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 12:52 PM To: CF-Talk Subject: changing the underlying webserver from iis - apache Hi list, has someone ever made experience to change the webserver on a CFMX-production engine (CFMX 6.1) ? We want to move away from IIS 6 to Apache 2.0.x on the same box. I want to keep the downtime as short as possible. Any suggestions ? Uwe ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What is wrong with this?
Something like this works - cfset a = NumberFormat(1234567,) So problem is with the first arguement - Get_Property_Details.Sale_Price Check if its a valid number, use IsNumeric to check that. Also check for NULL value. Thanks, Ashish Gohri Hi, all... I'm getting an invalid format mask on this: Value=#NumberFormat(Get_Property_Details.Sale_Price, )# Why? Thanks, Rick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What is wrong with this?
It's type is decimal in MySQL and the particular value being formatted is 255900 in the database...no dollar signs, commas, or periods. Rick -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:53 PM To: CF-Talk Subject: Re: What is wrong with this? Rick Faircloth wrote: I'm getting an invalid format mask on this: Value=#NumberFormat(Get_Property_Details.Sale_Price, )# Is Get_Property_Details.Sale_Price a number? Or, since it's obviously intended as an amount of money, does the value have something else in it, like a dollar sign? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What is wrong with this?
It's a decimal type in MySQL and the particular value being processed here is 255900 without and dollar signs, commas, or periods. Rick -Original Message- From: Ken Wexel [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:56 PM To: CF-Talk Subject: Re: What is wrong with this? looks fine...what's the value being returned in your var? On 3/12/07, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... I'm getting an invalid format mask on this: Value=#NumberFormat(Get_Property_Details.Sale_Price, )# Why? Thanks, Rick ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What is wrong with this?
That was the first thing I tried...didn't help. Strange... Rick -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:56 PM To: CF-Talk Subject: Re: What is wrong with this? Try using single quotes around the . -- Josh ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: changing the underlying webserver from iis - apache
As far as CF is concerned, it's just another request. I'm not sure if you will have trouble mapping the same instance of CF to both IIS and Apache using the wsconfig tool, but you can always create the configuration manually for apache (or copy it from a dev server). I would suggest testing this in a dev environment before putting it on production. Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:56 PM To: CF-Talk Subject: Re: changing the underlying webserver from iis - apache Hi Russ, thanks again. I will have a look into this. And CF doesn't get a problem with Apache/IIS trying to access simultaneously ? Uwe If you are using Windows 2003 SP1, I have posted instructions on getting it to work on my blog here: http://www.ruslansivak.com/index.cfm/2007/3/12/Getting-IIS-and-Apache- to-run -side-by-side-on-Windows-2003 If you are using a different OS, let me know and I'll try to find out what the steps are for that OS. Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 1:51 PM To: CF-Talk Subject: Re: changing the underlying webserver from iis - apache Hi Russ, thank you. Sounds fine to me, if it works that way. Too questions: a) Yes i wanted to run both servers on the same box but with different ports. (or different IPs as you mentioned). But what is the IIS tool ? Never heard of it. b) I wonder how ColdFusion can handle the requests of two different webservers at the same time on the same machine - for testing - as you mentioned it? Uwe Apache and IIS can run on the same box. My suggestion would be to set up apache on a separate ip (run the IIS tool to make it non-greedy and not take up all the addresses), set up apache on that IP, connect it to CF and do your testing. Once you're satisfied that everything is working, assign the rest of the IPs to apache, stop IIS and restart apache. Total downtime should be only a few seconds... Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 12:52 PM To: CF-Talk Subject: changing the underlying webserver from iis - apache Hi list, has someone ever made experience to change the webserver on a CFMX-production engine (CFMX 6.1) ? We want to move away from IIS 6 to Apache 2.0.x on the same box. I want to keep the downtime as short as possible. Any suggestions ? Uwe ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Having trouble getting variables from different tables to output
If by join the tables you mean make it one table I'm sure that can't be done without a HUGE rewrite of the code that drops data into and reads data out of those two separate tables. And I'm not even up to this task let alone a complete overhaul of the system... -Original Message- From: Ken Wexel [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 1:52 PM To: CF-Talk Subject: Re: Having trouble getting variables from different tables to output perhaps i'm reading this wrong, but do you have to do 2 queries for this, or can you join the tables, then group the output to get what you need? On 3/12/07, Michael Stevens [EMAIL PROTECTED] wrote: Hey guys! I'm new to ColdFusion and having some problems altering some old cfm pages I've inherited as the new IT guy. I don't know much about ColdFusion but I've been able to stumble around and change a few things but one page (actually, two similar pages) in particular is giving me a problem. We are a print shop and our website is linked to our database through CF. We've got several order pages that display order numbers, order names, stocks, inks, all kinds of print-related information. I've been asked to put our reorder information on the order detail page so that customers can look up a past order and order with that number and not have to submit artwork again. There are two pertinent tables: QOrdLineItems and QHistRO. The first query looks like this: cfquery name=Recordset1 datasource=AR SELECT OrderNum, Status, MainLine, acct_id, date, po_num FROM QOrdLineItems WHERE acct_id = '#COOKIE.id#' ORDER BY date DESC /cfquery My understanding is this pulls five variables from QOrdLineItems when the variable acct_id matches the id in the cookie being set when logged in. I have no idea what ORDER BY date DESC does. The new reorder information I need to output is in the QHistRO table and is in two different columns called reorder_num and control_num. I've tried a bunch of differnet ways to call these variables and none so far have worked, although it may be my output statements that aren't working. Currently I have this query: cfquery name=Recordset2 datasource=AR SELECT reorder_num, control_num FROM QHistRO WHERE reorder_num = '#Recordset1.OrderNum#' OR control_num = '#Recordset1.OrderNum#' /cfquery I'm trying to pull the variables from the table only when the reorder_num/control_num matches the OrderNum in Recordset1 pulled from QOrdLineItems. I'm outputting the variables with (the startrow maxrows are defined elsewhere and not causing problems): table cfoutput query=Recordset1 startrow=#StartRow_Recordset1# maxrows=#MaxRows_Recordset1# cfset realdate = #Mid(Recordset1.date,5,2)#-#Mid(Recordset1.date,7,2)#-#Mid(Recordset1 .date, 3,2)# tr td align=center#realdate#/td tdnbsp;#Recordset1.MainLine#/td td align=centera href=/orders/ord.cfm?ID=#Recordset1.ordernum# title=View Order Details#Recordset1.Ordernum# img src=/details.jpg border=0/a/td td align=centernbsp;#stat#/td td align=centernbsp;#Recordset1.PO_num#nbsp;/td /cfoutput td align=centercfoutput#Recordset2.control_num#/cfoutput/td td align=centercfoutput#Recordset2.reorder_num#/cfoutput/td /tr /table I have sucessfully pulled those variables into a different page and got them to output using this code (the URL.ID is the order_num variable): cfparam name=URL.ID default=0TU45375 cfparam name=URL.Ref_1 default=TU cfif #url.id# contains NIcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains TUcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains DQcfset newnumber = #mid(url.id,2,8)#/cfif cfif #url.id# contains 00cfset newnumber = #mid(url.id,3,6)#/cfif cfquery name=HistRO datasource=AR SELECT invoice_num, reorder_num, control_num FROM QHistRO WHERE reorder_num = '#URL.ID#' or control_num= '#URL.ID#' /cfquery Control #brcfoutput#HistRO.control_num#/cfoutputbr Reorder #brcfoutput#HistRO.reorder_num#/cfoutputbr I don't know a lot about ColdFusion and I've actually accomplished more than I thought I could but I'm hoping someone can help me finish this problem. Thanks, Mike ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What is wrong with this?
If you just cfoutput #Get_Property_Details.Sale_Price#, what does it say? -- Josh - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 2:05 PM Subject: RE: What is wrong with this? That was the first thing I tried...didn't help. Strange... Rick -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:56 PM To: CF-Talk Subject: Re: What is wrong with this? Try using single quotes around the . -- Josh ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What is wrong with this?
It coming back as a numeric value... Rick -Original Message- From: Ashish Gohri [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:50 PM To: CF-Talk Subject: Re: What is wrong with this? Something like this works - cfset a = NumberFormat(1234567,) So problem is with the first arguement - Get_Property_Details.Sale_Price Check if its a valid number, use IsNumeric to check that. Also check for NULL value. Thanks, Ashish Gohri ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Having trouble getting variables from different tables to output
I think he meant use a single query to join the tables through code, rather than two statements. At 05:07 PM 3/12/2007, you wrote: If by join the tables you mean make it one table I'm sure that can't be done without a HUGE rewrite of the code that drops data into and reads data out of those two separate tables. And I'm not even up to this task let alone a complete overhaul of the system... -Original Message- From: Ken Wexel [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 1:52 PM To: CF-Talk Subject: Re: Having trouble getting variables from different tables to output perhaps i'm reading this wrong, but do you have to do 2 queries for this, or can you join the tables, then group the output to get what you need? Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: weather module
I'm looking for a weather module to display on a real estate website. Must be compatible with CF query data such as a zip code. Weather.com's module is not flexible enough. Has any one found any such animal? Thanks in advance, Les ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: weather module
weather.gov has an rss feed and a xml feed. -Randy - Original Message - From: Les Irvin [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 5:14 PM Subject: OT: weather module I'm looking for a weather module to display on a real estate website. Must be compatible with CF query data such as a zip code. Weather.com's module is not flexible enough. Has any one found any such animal? Thanks in advance, Les ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What is wrong with this?
Trim it... Might be white space. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:13 PM To: CF-Talk Subject: RE: What is wrong with this? It coming back as a numeric value... Rick -Original Message- From: Ashish Gohri [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:50 PM To: CF-Talk Subject: Re: What is wrong with this? Something like this works - cfset a = NumberFormat(1234567,) So problem is with the first arguement - Get_Property_Details.Sale_Price Check if its a valid number, use IsNumeric to check that. Also check for NULL value. Thanks, Ashish Gohri ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What is wrong with this?
255900.00 It's showing in the database as 255900 but because it's a decimal data type, the .00 is being tacked on the end. Rick -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:10 PM To: CF-Talk Subject: Re: What is wrong with this? If you just cfoutput #Get_Property_Details.Sale_Price#, what does it say? -- Josh - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 2:05 PM Subject: RE: What is wrong with this? That was the first thing I tried...didn't help. Strange... Rick -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:56 PM To: CF-Talk Subject: Re: What is wrong with this? Try using single quotes around the . -- Josh ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: weather module
My CF/Yahoo package has a weather module. Makes it as simple as: cfset weatherAPI = createObject(component, org.camden.yahoo.weather) cfinvoke component=#weatherAPI# method=getWeather returnVariable=result cfinvokeargument name=location value=70508 cfinvokeargument name=units value=F /cfinvoke cfdump var=#result# label=Weather for Lafayette, LA On 3/12/07, Les Irvin [EMAIL PROTECTED] wrote: I'm looking for a weather module to display on a real estate website. Must be compatible with CF query data such as a zip code. Weather.com's module is not flexible enough. Has any one found any such animal? Thanks in advance, Les ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What is wrong with this?
#NumberFormat(Trim(Get_Property_Details.Sale_Price), )# still causes Invalid Mask error... -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:19 PM To: CF-Talk Subject: RE: What is wrong with this? Trim it... Might be white space. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What is wrong with this?
Ashish Gohri wrote: Something like this works - cfset a = NumberFormat(1234567,) I believe in older CF versions (5 maybe, 4.5 for sure), you had to have as many places (or more) in your mask as you had in the number it is formatting. Is this a older version of CF? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What is wrong with this?
If you have the number 255900.00, how do you want to end up looking? I don't know NumberFormat very well, but I'm not sure what you're trying to get by masking it with . -- Josh - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 2:23 PM Subject: RE: What is wrong with this? 255900.00 It's showing in the database as 255900 but because it's a decimal data type, the .00 is being tacked on the end. Rick -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:10 PM To: CF-Talk Subject: Re: What is wrong with this? If you just cfoutput #Get_Property_Details.Sale_Price#, what does it say? -- Josh - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 2:05 PM Subject: RE: What is wrong with this? That was the first thing I tried...didn't help. Strange... Rick -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:56 PM To: CF-Talk Subject: Re: What is wrong with this? Try using single quotes around the . -- Josh ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: weather module
I'm using the cf_weather custom tag on www.cfmjet.com/airports.cfm. http://www.xefteri.com/articles/show.cfm?id=29 -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:14 PM To: CF-Talk Subject: OT: weather module I'm looking for a weather module to display on a real estate website. Must be compatible with CF query data such as a zip code. Weather.com's module is not flexible enough. Has any one found any such animal? Thanks in advance, Les ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SVN Dreamweaver
I am currently using VSS with Dreamweaver on a coldfusion project. I am looking for other options as I need a source control environment that works over TCP-IP for multiple users on different domains. Therefore, I am wondering if anyone around here uses SVN for source control with Dreamweaver? If so, how do you handle locking? A project requirement requires that the source control software only allows one person to checkout a file at a time. Currently, when I use Dreamweaver I notice that you can override the locking settings on files. I cannot find a way to prevent this from happening. If anyone has some recommendations on how to fix this problem please let me know. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What is wrong with this?
That mask is supposed to round the number up to the near who number, or, in this case, 255900 -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:31 PM To: CF-Talk Subject: Re: What is wrong with this? If you have the number 255900.00, how do you want to end up looking? I don't know NumberFormat very well, but I'm not sure what you're trying to get by masking it with . -- Josh ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What is wrong with this?
What happens if you use zeros instead of nines #NumberFormat(Trim(Get_Property_Details.Sale_Price), )# .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:28 PM To: CF-Talk Subject: RE: What is wrong with this? #NumberFormat(Trim(Get_Property_Details.Sale_Price), )# still causes Invalid Mask error... ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What is wrong with this?
That got me closer, Jim. I tried #NumberFormat(Trim(Get_Property_Details.Sale_Price), 999)# and it did take off the decimal and rounded the number to 255900, however the 255900 was then preceded by about 4 blank spaces in the form field. And to think I was trying to round the number to help overcome a problem with JS validation! :oP Rick -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:29 PM To: CF-Talk Subject: Re: What is wrong with this? Ashish Gohri wrote: Something like this works - cfset a = NumberFormat(1234567,) I believe in older CF versions (5 maybe, 4.5 for sure), you had to have as many places (or more) in your mask as you had in the number it is formatting. Is this a older version of CF? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What is wrong with this?
Rick, As a test, have you tried replacing Get_Property_Details.Sale_Price with a hard-coded value? Also, have you tried changing your mask to .99 (or don't you want the decimal to show)? Chris Rick Faircloth wrote: 255900.00 It's showing in the database as 255900 but because it's a decimal data type, the .00 is being tacked on the end. Rick -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:10 PM To: CF-Talk Subject: Re: What is wrong with this? If you just cfoutput #Get_Property_Details.Sale_Price#, what does it say? -- Josh - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 2:05 PM Subject: RE: What is wrong with this? That was the first thing I tried...didn't help. Strange... Rick -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:56 PM To: CF-Talk Subject: Re: What is wrong with this? Try using single quotes around the . -- Josh ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What is wrong with this?
Yep... CF 4.5...however, the mask instructions are straight out of the 4.0 WACK... -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:29 PM To: CF-Talk Subject: Re: What is wrong with this? Ashish Gohri wrote: Something like this works - cfset a = NumberFormat(1234567,) I believe in older CF versions (5 maybe, 4.5 for sure), you had to have as many places (or more) in your mask as you had in the number it is formatting. Is this a older version of CF? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
