(ot) Need Oracle Service_Name but have SID
Hi all, I have a bit of a dilema, I need to connect to an oracle database, but I can't use a TNSNames file. However when I asked for the connection info they gave me a tnsnames.ora file and told me to figure it out from there. In the tnsnames file is a SID. However the software I am trying to use (SSIS) needs [host]:[port]\[service_name]. [host]:[port]\[sid] wont work and I can't find anything helpful through google on what I need to do to find the service_name. I know a couple of you are Oracle gurus, so I'm hoping you can help. Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) ColdFusion Builder serial number not being accepted.
Hi all, Sorry for the OT but I don't know who to contact. I have a student edition of ColdFusion Builder 2 and it was installed on my laptop, but that laptop died. Now when I try to install on my replacement laptop, it tells me the serial number is invalid when I try to install CF Builder 2. Does anyone know who I should contact about this? Thanks Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
New computer set up
Thanks for the idea, but I am a student and this is a freeriatools.adobe.com installation (yes I am still a full time student). So no online account. I still have the original email from adobe that I installed it with before. I have the feeling it is one of those things that you have to remove the serial number from the old computer, but it completely died. No possibility of choosing to remove it from the old computer. I'd start by making sure you have the right serial number. You can log into Adobe.com using the account you used to purchase/register CFB and you should find the serial number in your purchase history. If that doesn't work you can call Adobe's support line, but give yourself at least an hour (and maybe a Xanax) to deal with the call. -Cameron ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349775 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
New computer set up
Hi all, Just wondering what all of the guru's here install when they get a new laptop. Its a windows based machine, but will probably be dual booting a form of Linux before the end of the week. Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with pound signs
I tried it out. It works sort-of. It only lists the first time the single pound sign happened. While this identifies the file you have to rescan just to find the next error. Someone else mentioned that manually fixing would be boring and tedious. I agree with that but when one programmer decides to do a mass search and replace and totally destroys a code base, then management directs you to do it by hand. :( Steve Sent from my iPhone On Jun 25, 2011, at 5:01 PM, Raymond Camden rcam...@gmail.com wrote: I'll forgive you - once. ;) I'm still waiting to here back from Steven to see if this method worked for him. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with pound signs
Yeah but for us that involved getting another group involved and lots of programmer down-time. Sent from my iPhone On Jun 27, 2011, at 1:45 PM, Dave Watts dwa...@figleaf.com wrote: Someone else mentioned that manually fixing would be boring and tedious. I agree with that but when one programmer decides to do a mass search and replace and totally destroys a code base, then management directs you to do it by hand. :( backup and restore? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem with pound signs
All these responses are really helping!
Ok so here is what I'm going to do so far...
I have a CF Application that can search through the code base and find
stuff inside of tags or between opening and closing tags, but I have
to tell it what tag and give it regex to do the search.
I'm breaking this down into two steps first I'm going to search for
the color codes in between cfoutputs that have a single #. From what
I've been reading so far I think this regex should work:
[^#]#[a-fA-F0-9]{3,6}
If I'm correct it would pick up #FF3366 but not ##FF3366.
What do you think about that regex?
I'll deal with the missing # signs later after I get the color codes fixed.
Thanks,
Steve
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345632
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Problem with pound signs
Hi all, I've been given some code to fix that others have tried but had little luck. I believe I've found the major culprit, but I want to use regex to find it but I'm a little stumped. The errors are usually one of two things, either single pound signs in between cfoutputs (ie: font tag with color) or many places where the original programmers meant to use a variable but only put a pound sign on one side of the variable. Any ideas of the regex I should use? Steve Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: scoping
You keep saying variables in the local scope. You may want to say the current page because there is a local scope. In functions if you cfset var myvar = something / it is in the local scope and you don't attach a scope to it. I believe in CF 9 they actually added the local scope for this purpose as well. Sent from my iPhone On May 18, 2011, at 9:59 PM, Eric Roberts ow...@threeravensconsulting.com wrote: A good question that was brought up by one of our developers. When you don't scope a var it has to search through the various scopes to find it, in order of precedence. If you are using alocal scope, is there a performance hit if you don't scope it since variables is implied or does it still go into search mode? Also...is this negated of you use a cfset on the top of the page (again...this is only referring to local vars.) Eric -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Wednesday, May 18, 2011 01:36 PM To: cf-talk Subject: Re: scoping Here's my take on it: http://www.cfgears.com/index.cfm/2010/9/22/The-importance-of-proper-variable -scoping Thanks, Eric Cobb http://www.cfgears.com Help me make a difference this summer -http://bit.ly/i8dJvQ On 5/18/2011 11:51 AM, Eric Roberts wrote: We had a discussion at work as to whether or not we should scope local vars with the variables. scope since that is implied in a cfset. One camp says it is not needed because of the implicit scoping when using cfset...the other camp says it is better to tack on variables. and make it explicit for security and readability. Any thoughts? Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 SQL Server 2008 XML bulkload
First SQL has to be running under an account that has access to that directory.
Then it is easiest if you make a share, then you reference it as
\\sernername\sharename\filename
Steve
Sent from my iPhone
On May 3, 2011, at 12:48 AM, Kam Heydari heyda...@yahoo.com wrote:
Hi,
Anyone know how to pass file name to the bulkload when sqlserver and
coldfision servers are on different physical servers; The following xml load
works when both SQl and CF servers are residing on the same physical server.
- How I can refer to the local file where sqlserver can access it?
- Any alternative ways?
Thanks
K
EXEC('
INSERT INTO [ProjectXML](Code, Reference, xmlFileName, [xmlDocument])
SELECT '''+'2503'+''','''+'455'+''', ''' +
'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp'
+ ''', xmlData FROM ( SELECT * FROM OPENROWSET (BULK ''' +
'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp'
+ ''' , SINGLE_BLOB) AS XMLDATA ) AS FileImport (XMLDATA) ')
Error when on different servers:
Message: Error Executing Database Query.
Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot bulk load
because the file
C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp4527544419188947137.tmp
could not be opened. Operating system error code 3(The system cannot find
the path specified.).
sqlStatement: HY000
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344155
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem Using QueryNew
Varchar(max) was added to mssql 2005 2000 has a limit of Varchar(8060) Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Wordpress.com equivalent
Hi all, I was wondering if we have an equivalent to wordpress.com? I'm not talking about codebases like blogcfc or mango blog. I mean an actual site where people can sign up for a free or premium account and just start blogging. Steve Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Wordpress.com equivalent
I was looking at it more from the point of WordPress was php's *flagship* (for lack of a better word) site and code base that made it really popular (or so I'm told). I was wondering if we have anyone out there working on it or something else like it to make ColdFusion/Railo more popular to the masses. Steve -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, March 25, 2011 11:47 AM To: cf-talk Subject: Re: Wordpress.com equivalent if you mean written in CF then no I am not aware of any, but then MangoBlog is so easy to deploy do you really need that, it only takes minutes to deploy really? Any old CF host should do the job. After all if you are a total non coding noob, then you wouldn't be looking for CF blog software or even know what it is, there are more than enough solutions out there for people like that. And besides wordpress.com is totally closed, you cannot get at the code and customise it, you have a small selection of plugins to choose form and that is it. If you want more then you have to install and run your own copy of wordpress anyway. It also depends what you want out of your blog. If you code in CFML only and want the ability to customise and write plugins, then MangoBlog or BlogCFC are your best choices. If you don't want to get your hands dirty and just want an out of box blog with more plugins than you can wave a stick at,or you know PHP as well then it is hard to suggest anytying other than Wordpress for its shear wealth of plugins. Although there are many other good options if you have specific feature requireemnt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The vagaries of QueryNew
First, let me say that anything that can be done in the database should be. But, if you must do it this way, why don't you have the db return the extra columns as nulls then set the cell values. That way you don't have the extra query object being built. Steve Sent from my iPhone On Mar 23, 2011, at 7:18 AM, Kevin Parker tras...@internode.on.net wrote: I have a query where I need to add some extra stuff not in the database so decide to create another query object with QueryNew. I loop over a query of the table to set cell values and add extra values to each row etc. I output the record count for the original query and it shows 3 rows (which is correct - there are three rows in the table) but when if do a cfdump of the new query object its shows 6 rows, 3 with the original data and an extra 3 with all cells showing [empty string] I have no idea where it's getting this from. Any clues please? TIA! ++ Kevin Parker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: customtag not being found
You say that you added the mapping, but did you also tell CF that this was a custom tag directory? They are two different things. Steve Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342974 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 9 install problem
Hi all, I've tried googling this and haven't had any luck. Here is the history. I had cf9 multiserver installed on my test laptop. Then I needed to upgrade from vista 64 to win7 64. So I uninstalled CF and jrun (along with a bunch of other stuff) and did the upgrade. Now when I try to install cf9 multiserver is grayed out with a message that jrun is installed on the system. I have searched and the jrun directory is gone, there are no registry entries I can find and no jrun service running. Any idea what I have to do to get cf9 to install multiserver? Steve Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 9 install problem
Nevermind. I just missed one of the registry entries. Sent from my iPhone On Mar 7, 2011, at 11:08 AM, Steven Durette st...@durette.org wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFImage at 300dpi
Has anyone heard anything? Is he ok? Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Code Review Tool
I believe codecop is still available on riaforge.org. Sent from my iPhone On Jan 11, 2011, at 5:48 AM, dev losh devl...@gmail.com wrote: Can anyone recommend any good tool that can be used for Coldfusion Code Reviews? I tried Sonar but could'nt find coldfusion plugin for the same. Thanks, Devlosh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bug in CFAdmin?
I had an error like this once. I copy and pasted the date to another program (I don't remember which it was a long time ago) and it showed me I had a high character that displayed as a blank. I wiped out the field and re-entered the date. The problem went away. Steve Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bug in CFAdmin?
If you go into the details of the scheduled task and wipe out and reenter the date. I ended up doing each one until I got the one that caused the error in cfadmin. It was one of the entries that showed up before the error. If I remember correctly I had two of them. Fixed one then got more tasks listed. Then went through those until I found the other one. Then the error went away. Sent from my iPhone On Dec 23, 2010, at 10:08 AM, Stefan Richter ste...@flashcomguru.com wrote: Thanks Steve. The problem I have is that this is in CF Admin after simply navigating to the scheduled tasks page. I'm not sure where this date comes from or why and it's certainly not based on user input either. Regards, Stefan On 23 Dec 2010, at 14:09, Steven Durette wrote: I had an error like this once. I copy and pasted the date to another program (I don't remember which it was a long time ago) and it showed me I had a high character that displayed as a blank. I wiped out the field and re-entered the date. The problem went away. Steve Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMail problem since upgrading to CF9
Smtp error 421 is the service is not available and the connection will be closed It is from the smtp server not ColdFusion, so you issue is the smtp server. Steve Sent from my iPhone On Dec 10, 2010, at 12:04 PM, Rick Root rick.r...@gmail.com wrote: We've been having significantly more trouble getting CF to send mail to our MDaemon server ... after we upgraded to CF9, we started seeing a lot of these errors in the mail.log: [Error,scheduler-4,12/10/10,11:40:51,,Could not connect to SMTP host: 69.41.172.242, port: 25, response: 421 and [Error,mailWorker-6,12/10/10,10:50:29,,Could not connect to SMTP host: 69.41.172.242, port: 25, response: 421 (the only difference there is the thread that is logging the error I guess) However, the mail server is absolutely up and running and the vast majority of our mail IS going out. In the mail settings, we have Maintain connection.. checked ... the timeout is set to 60 seconds.. Would a connection timeout be reported as response 421? Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339984 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMail problem since upgrading to CF9
Actually the CF error is correct. CF tried to connect to the smtp server and all it got back was error 421. So connection couldn't be made. Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339988 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: custom error message - sometimes cf ignores me and displays the standard error message
Nick, Request and validation errors can only use cferror to redirect to HTML files that can include cferror references. Any other cell in those pages will cause your error page to generate an error. Steve Sent from my iPhone On Dec 7, 2010, at 11:24 AM, nick way n...@southeastpublishing.com wrote: hi guys For security (and appearance) reasons I don't ever want my users to be shown the default CF error message. Therefore in application.cfm I have the following: cferror type=validation exception=any template=/errorDocs/myErrorHandler.cfm / cferror type=request exception=any template=/errorDocs/myErrorHandler.cfm / cferror type=exception exception=any template=/errorDocs/myErrorHandler.cfm / My understanding is that *any* error message will result in the error being handled by myerrorhandler.cfm - however. If I execute this code in a .cfm page cfoutput#/cfoutput The user is shown the default CF error message (complete with info about line numbers etc). ie - CF has ignored my instruction in application.cfm on this occasion and allowed the user to see the standard CF error message??? Any thoughts as to how this can be as I'm stumped! TIA chaps. Nick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: custom error message - sometimes cf ignores me and displays the standard error message
That should read any other cfml. Sent from my iPhone On Dec 7, 2010, at 11:38 AM, Steven Durette st...@durette.org wrote: Nick, Request and validation errors can only use cferror to redirect to HTML files that can include cferror references. Any other cell in those pages will cause your error page to generate an error. Steve Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: custom error message - sometimes cf ignores me and displays the standard error message
Correct. If you use request or exception error types they cannot use any other cfml. You can see the cferror specs at http://www.cfquickdocs.com/cf8/#cferror Sorry no cfmail with request and validation. Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339885 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: custom error message - sometimes cf ignores me and displays the standard error message
Nick, What you have been using for years is exception error reporting. You have just added request and validation to the mix and they have different rules. Nothing has changed, you are just expanding your horizons! :) Steve Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9/Win7 64 bit issues
Not when one of the major fixes is to make it install better with a webserver. Sent from my iPhone On Dec 7, 2010, at 8:54 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I guess that makes sense -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Monday, December 06, 2010 17:45 To: cf-talk Subject: RE: CF9/Win7 64 bit issues You would think so wouldn't you. The reason I read it isn't is because this would require re-testing the installer on all platforms, which is too time consuming, Russ -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: 06 December 2010 23:19 To: cf-talk Subject: RE: CF9/Win7 64 bit issues Shouldn't the download be 9.01? I guess the better question should be when was 9.01 released. I downloaded the installer maybe a month ago. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Monday, December 06, 2010 17:33 To: cf-talk Subject: RE: CF9/Win7 64 bit issues Which may confuse people seeing as you have to install cf9 first then cf9.0.1, so you cannot install CF to IIS during the initial install, you have to update to 9.0.1 then use the web config tool. Russ -Original Message- From: Andy Allan [mailto:andy.al...@gmail.com] Sent: 06 December 2010 22:52 To: cf-talk Subject: Re: CF9/Win7 64 bit issue FYI: You need the IIS6 management console for CF9.0 but NOT for 9.01 Andy On 6 December 2010 21:54, Eric Roberts ow...@threeravensconsulting.com wrote: You da man Nathan :-D I turned on IIS6 compatibility and it worked. Thanks!! -Original Message- From: Nathan Strutz [mailto:str...@gmail.com] Sent: Monday, December 06, 2010 15:48 To: cf-talk Subject: Re: CF9/Win7 64 bit issues I'm not a pro in this field, but I know a few tricks. First, did you install the IIS 6 management console? If not, CF has trouble connecting to IIS7. I think you just have to have it installed, you can still manage via IIS7 tools. Second, you can always use the built-in web server. You can enable it through an XML file somewhere, but I find it's easier to reinstall CF and turn on the internal web server in the installer. Finally, my last trick is the wsconfig app, Web Services Configuration Tool in your start menu. You should be able to delete and recreate the connection to your web server. As for debugging, I wonder if your CF server thinks somehow it has a different context root other than just / - you could look for that and who knows, maybe you will find your /inetpub/wwwroot/*.cfm files answer to localhost/cfusion/*.cfm. Weird, but I guess possible. nathan strutz [http://www.dopefly.com/] [http://hi.im/nathanstrutz] On Mon, Dec 6, 2010 at 2:29 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I have banging my head on this for the past couple of days. I cannot get CF9 (either 64 bit or 32 bit) to install properly on a fresh install of Win7 Ultimate 64 bit. It adds the .cfm doc, but there isn't an entry for the handler. If I fire up the connector program to add it, it acts like it is already there, but no connectors are listed and when I try to add, if I go to put in the directory, it is greyed out and won't let me add it, and the site is listed as None and that is the only option. I have tried uninstalling CF.uninstalling both cf and IIS7 and then reinstalling (IIS then CF).no joy. When I get done with the installation and it directs you to the administrator, even though I am going to the right path, I get a 404 error. If I try to go to a html page using the same path, it comes up with no issues. Any ideas or does anyone know of a site that has info? I am totally stumped. Usually this just works. I just reinstalled my OS to clean up some stuff and it was previously installed and running with no issues prior to the reinstallation. Thanks! Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339901 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Schedule task more frequent than 1 inute
This sounds like you need a directory watcher gateway. I know it is available with CF8 Enterprise but I don't know about other versions. Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9/Win7 64 bit issues
Really? I thought if you got the latest download from Adobe that it was v9.0.1 Sent from my iPhone On Dec 6, 2010, at 6:33 PM, Russ Michaels r...@michaels.me.uk wrote: Which may confuse people seeing as you have to install cf9 first then cf9.0.1, so you cannot install CF to IIS during the initial install, you have to update to 9.0.1 then use the web config tool. Russ -Original Message- From: Andy Allan [mailto:andy.al...@gmail.com] Sent: 06 December 2010 22:52 To: cf-talk Subject: Re: CF9/Win7 64 bit issue FYI: You need the IIS6 management console for CF9.0 but NOT for 9.01 Andy On 6 December 2010 21:54, Eric Roberts ow...@threeravensconsulting.com wrote: You da man Nathan :-D I turned on IIS6 compatibility and it worked. Thanks!! -Original Message- From: Nathan Strutz [mailto:str...@gmail.com] Sent: Monday, December 06, 2010 15:48 To: cf-talk Subject: Re: CF9/Win7 64 bit issues I'm not a pro in this field, but I know a few tricks. First, did you install the IIS 6 management console? If not, CF has trouble connecting to IIS7. I think you just have to have it installed, you can still manage via IIS7 tools. Second, you can always use the built-in web server. You can enable it through an XML file somewhere, but I find it's easier to reinstall CF and turn on the internal web server in the installer. Finally, my last trick is the wsconfig app, Web Services Configuration Tool in your start menu. You should be able to delete and recreate the connection to your web server. As for debugging, I wonder if your CF server thinks somehow it has a different context root other than just / - you could look for that and who knows, maybe you will find your /inetpub/wwwroot/*.cfm files answer to localhost/cfusion/*.cfm. Weird, but I guess possible. nathan strutz [http://www.dopefly.com/] [http://hi.im/nathanstrutz] On Mon, Dec 6, 2010 at 2:29 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I have banging my head on this for the past couple of days. I cannot get CF9 (either 64 bit or 32 bit) to install properly on a fresh install of Win7 Ultimate 64 bit. It adds the .cfm doc, but there isn't an entry for the handler. If I fire up the connector program to add it, it acts like it is already there, but no connectors are listed and when I try to add, if I go to put in the directory, it is greyed out and won't let me add it, and the site is listed as None and that is the only option. I have tried uninstalling CF.uninstalling both cf and IIS7 and then reinstalling (IIS then CF).no joy. When I get done with the installation and it directs you to the administrator, even though I am going to the right path, I get a 404 error. If I try to go to a html page using the same path, it comes up with no issues. Any ideas or does anyone know of a site that has info? I am totally stumped. Usually this just works. I just reinstalled my OS to clean up some stuff and it was previously installed and running with no issues prior to the reinstallation. Thanks! Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion Mailing list
All, I am in search of a prebuilt mailing list application. Here are the requirements. * Announce only type of emails (only one or two people can send to the list). * 400 or fewer recepients (probably less than 200). * Has to be ColdFusion (I can't install software because it's a hosted site). It can do more but that is what I need. Any ideas/suggestions? Thanks, Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion 7.0 Tags and Functions Poster
I think he's talking about the big blue and white one from Adobe, not the TeraTech version. I don't know where to get one, I got mine at CFUnited 06. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 2:04 PM To: CF-Talk Subject: Re: ColdFusion 7.0 Tags and Functions Poster Talk to Michael at Tera-tech...he's probably already seen your post ;-) - - This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. = = EMF idahopower.com made the previous annotations. ~| 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:270533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: Breeze Presentation problem
Hi all, I'm trying to view a saved breeze presentation (http://adobe.breezecentral.com/p15449246 Setting up Coldfusion, Apache, mySql on Linux). The presentation seems to work, but I've found a couple of problems. First, the sound is out of sync with what is displayed on the screen. This can really be a pain when trying to do the same set up, but you get the instructions almost 2 minutes before the code is on the screen. Second, everyonce in a while the breeze presentation will switch to seeking and just sit there. I have to close the window, then open a new one and start over (trying to seek to where I was). Is there any way to copy a breeze presentation to my local computer so I can watch it properly? Or, if you have any other suggestions for viewing this, it would be helpful. Thanks, Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244137 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Where does everyone blog?
I know this comes up in the list every once in a while, but the search isn't giving me really great results. What I want to know is where everone blogs at. Do most of you blog on your own site, or use a centralized site to blog. I'm thinking of starting up a blog and I want to know where everyone else is at. For now, my blog will be mostly CF related. PS - I'm not looking for blog software, just where everyone else is blogging. Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243992 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Homesite and Dreamweaver tag defs for 7.0.1
Hi All, Does anyone know if or when updaters with the new tag information will be available for the updates in 7.0.1 that we can add to Dreamweaver MX 2004 and Homesite 5.5+ ? Thanks, Steve Durette ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Passing List into Stored Proc
Hello John,
Tuesday, January 27, 2004, 6:55:52 AM, you wrote:
Jm DELETE
Jm FROM DBO.a
Jm WHERE DBO.a.FOLDERNAME IN ('jim','ben','tom')
Jm AND DBO.a.CUSTOMERID = 1
John,
Are you making sure that the @folderlist items are separated by commas
and each item is surrounded by ' ?
Steve
--
Best regards,
Steven mailto:[EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
JRun with ColdFusion
Hi all, I have a question about the JRun that is installed with ColdFusion Enterprise (second install option). Do I have to install Macromedia's JRun updaters or are they already added in? Would future patches show up in the ColdFusion Support or JRun support? (I mean, I didn't purchase JRun, it came with it, so wouldn't they link to it from the CF support pages) Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFMX61 on JRun4, JVM (multiple sort of related questions)
Opps, I forgot to add: Win2K Server IIS 5 CFMX 6.1 Enterprise (currently at CFMX Enterprise) The JVM we have to go to is Sun 1.4.2_01 Nothing else running on the box. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL formatting question
Eric, Tuesday, January 6, 2004, 7:03:36 PM, you wrote: EC I have a table with column of phone numbers. The phone EC numbers have been entered in a number of different formats some EC containing . or - or /. Some with area codes with (). What I want EC to do is get them all the same. Now I can take all the records and EC get them all in a simple 10 digit sequence but I then want to EC convert them all to (123)456-7890 format. The field that houses EC the phone number is a varchar(50) field. EC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re[2]: Two Selects
You might also want to check out a tutorial I wrote for easycfm.com It deals with homegrown multiple selects related that can be used multiple times within a form. The article can be found at http://tutorial196.easycfm.com There is also an example at http://www.durette.org/tutorials/MultiSelect.cfm Steve -- Best regards, Steven mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re[5]: Two Selects
All, I have just tested the Multi Selects Related demo for the tutorial on the following browsers: IE 6.0.2800.106.xpsp2.030422-1633 Opera 7.23 Mozilla 1.5.0.2003100716 Mozilla Firebird 0.7 Netscape 7.1 MyIE2 0.9.12 And it passed all of them with flying colors.Are there any other major browsers that you suggest that I check?I am on a WinXP system, so I can't check Linux or MacOS web browsers. Thanks Steve SD Hello Calvin, SD Mine was tested on IE, but I used the _javascript_ 1.3 pdf from SD Netscape's web site to ensure that the _javascript_ would be processed SD properly an not use any JS that was IE specific. SD I have just recently started to download other browsers for testing at SD home. The place that I work has a closed intranet where the SD browser/version is dictated to us by IT. SD I will do some testing and see what I find out. SD Steve SD Wednesday, December 31, 2003, 9:52:17 PM, you wrote: CW Looks fairly close to what I submitted, what browser CW versions has yours been tested on? -- Best regards, Steven mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: evaluate
The major difference is that attributes.query is set to caller.[insert query name here] And that's how this works.The custom tag has worked for years, I just wanted to get rid of the evaluates. Thanks for the info though Steve - Original Message - From: Jim Davis To: CF-Talk Sent: Friday, October 10, 2003 11:39 PM Subject: RE: evaluate Actually I think that would look for a query IN the Attributes scope.I think that the original post indicated that only a query name was being passed in the attributes scope.If the query itself were being passed into the tag then this would work but the problem is that Query is a really poor variable name.If the variable name were curQuery then this would work: Attributes.curQuery.recordcount (actually Attributes.Query.recordcount might work - but I think that query is a reserved word.) If you're on MX any scope can be used in this way so all of the following would work: Variables[Attributes.Query].RecordCount Session[Attributes.Query].RecordCount Form[Attributes.Query].RecordCount This[Attributes.Query].RecordCount And so forth - it really depends on which scope holds the query in question. Jim Davis -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 5:07 PM To: CF-Talk Subject: Re: evaluate #Attributes['#Query#'].recordCount# Joe - Original Message - From: DURETTE, STEVEN J (AIT) To: CF-Talk Sent: Friday, October 10, 2003 4:37 PM Subject: evaluate Hi all, I have a lot of files written by another programmer that I now have to update. Most of these files have things like:CFSET myEval = evaluate(#Attributes.Query#.RecordCount) I know that evaluate should be avoided, but how would I convert that to not use the evaluate() function? Thanks, Steve _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: evaluate
The String of the name of the query. - Original Message - From: Jim Davis To: CF-Talk Sent: Saturday, October 11, 2003 1:38 PM Subject: RE: evaluate But is it being set to the string of the name or the query itself? That's the key. Jim Davis -Original Message- From: Steven Durette [mailto:[EMAIL PROTECTED] Sent: Saturday, October 11, 2003 12:41 PM To: CF-Talk Subject: Re: evaluate The major difference is that attributes.query is set to caller.[insert query name here] And that's how this works.The custom tag has worked for years, I just wanted to get rid of the evaluates. Thanks for the info though Steve - Original Message - From: Jim Davis To: CF-Talk Sent: Friday, October 10, 2003 11:39 PM Subject: RE: evaluate Actually I think that would look for a query IN the Attributes scope. I think that the original post indicated that only a query name was being passed in the attributes scope.If the query itself were being passed into the tag then this would work but the problem is that Query is a really poor variable name.If the variable name were curQuery then this would work: Attributes.curQuery.recordcount (actually Attributes.Query.recordcount might work - but I think that query is a reserved word.) If you're on MX any scope can be used in this way so all of the following would work: Variables[Attributes.Query].RecordCount Session[Attributes.Query].RecordCount Form[Attributes.Query].RecordCount This[Attributes.Query].RecordCount And so forth - it really depends on which scope holds the query in question. Jim Davis -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 5:07 PM To: CF-Talk Subject: Re: evaluate #Attributes['#Query#'].recordCount# Joe - Original Message - From: DURETTE, STEVEN J (AIT) To: CF-Talk Sent: Friday, October 10, 2003 4:37 PM Subject: evaluate Hi all, I have a lot of files written by another programmer that I now have to update. Most of these files have things like:CFSET myEval = evaluate(#Attributes.Query#.RecordCount) I know that evaluate should be avoided, but how would I convert that to not use the evaluate() function? Thanks, Steve _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFLOCK and CFFILE
Hi all, It has been suggested to me to use CFLocks around my cffile write and cffile appends. This is to prevent file errors that we have been having lately where the append tries to start before the original write is complete. What would the syntax for this cflock be? I know that I would probably want type = Exclusive and timeout = so many seconds, but what about the scope? There is no FILE scope. If anyone has any examples, that would be great. Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RDS on CFMX
Hi All, Does anyone here know why RDS might suddenly stop working on a CFMX server? It was working fine until a couple of days ago and then it just suddenly stopped. We are using the Enterprise edition of CFMX on a Win2K server with IIS. We are not using advanced security. Also, I have noticed that occasionally the debug information stops displaying at the bottom of my web pages. I have a static ip, so no dhcp problems. When this happens and I go into cf admin, the debuggin option has turned itself off. I have confered with my co-workers and no one has gone in and changed any settings, the server just seems to do it on it's own every once in a while. By the way, I turn it back on and it works until some random time in the future when it shuts itself back off. Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfmx and jre problem with cfgrid (not the standard problem).
Hi all, I am having a problem with CFMX and CFGRID, every time a user browses to the cfgrid they have to download 1.3 They browse away and come back, they have to download again. Has anyone else had this problem and if so, how was it fixed. Also, I have been trying to find the answer on the forums, but the consensus that I get there is that MX is 1.4... not 1.3... If that's the truth, why might MX be forcing 1.3... on the user? Lastly, is it possible to upgrade the jre for MX? If so how? Sorry about all of the questions, but this is really driving a few of us at work a little loopy! Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MX Server installs and Microsoft Security Toolkits
There's plenty of documentation out there on all these topics, also. Unfortunately, it's not all in one place, really; CF information is provided by Macromedia, IIS information by Microsoft, general web application security information by others, and so on. Fig Leaf Software offers a one-day seminar on securing CF servers running Windows, if you're interested in that. Information is available at http://training.figleaf.com/. There are plenty of books and online references available, also. I just got a good book called Hack Proofing Coldfusion. It's geared towards CF5 but has an MX section. PLUS... It also has sections about IIS, Microsoft Security Toolkit, *nix security, NTFS security and many others. I have just read the first few pages and have already found ways to secure my sites. Steve Durette ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Code Summary: Recursive File Delete
Just a quick note. I do just this sort of thing to deal with temporary files. It is scheduled to run every two hours. One problem that we came across is if the file is being used. We ended up adding a cftry..cfcatch setup to ensure that if one file was being used, the cf page would continue with the rest of the files. Without this combo, the page would crash at the first file it couldn't delete. This can be a major problem if IIS has locked a file. just my .02 Steve Durette - Original Message - From: David Adams [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 5:15 PM Subject: Code Summary: Recursive File Delete For the benefit of others the following is a summary of the code snippets sent in from the various developers. Thanks to all that responded. Dave Adams CFUG Ottawa cfexecute name=c:\winnt\system32\cmd.exe parameters=/c del c:\trash\*.* /q / OR cfset mypath = expandpath(my/directory/path) / cfdirectory action=list name=rsfile directory=#mypath# / cfloop query=rsfile cfif rsfile.type is file cffile action=delete file=#mypath#/#rsfile.name# / /cfif /cfloop OR cfset root=c:\inetpub\wwwroot\yourdirectory\ cfdirectory name=dGetDir directory=#root# action=List cfloop query=dGetDir cfif type NEQ DIR cffile action=DELETE file=#root##dGetDir.name# variable=content /cffile /cfloop OR CFSET TargetDir = c:\foo CFDIRECTORY ACTION=LIST DIRECTORY=#TargetDir# NAME=TheFiles CFLOOP QUERY=TheFiles CFIF (Type IS File) AND (Name IS NOT .) AND (Name IS NOT ..) CFFILE ACTION=DELETE FILE=#TargetDir#\#Name# /CFIF /CFLOOP OR cfdirectory action=list directory=mydirectory name=dirlist cfoutput query=dirlist cffile action=delete file=#name# /cfoutput ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
cfscript equivalent for cfloop?
Is there an equivalent of to be used with cfscript? I have code similar to this: lt;cfloop query=#34;myQuery#34;gt; lt;cfif myQuery.myColName IS 1gt; lt;cfset myVar = 1gt; lt;/cfifgt; lt;/cfloopgt; This loop is surrounded on both sides by cfscript blocks and I would like to make it all one cfscript block. Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Cfloop equivalent in cfscript?
Didn't see this hit the list, so I thought that I would try again. Is there an equivalent of to be used with cfscript? I have code similar to this: cfloop query=myQuery cfif myQuery.myColName IS 1 cfset myVar = 1 /cfif /cfloop This loop is surrounded on both sides by cfscript blocks and I would like to make it all one cfscript block. Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFFILE WRITE TO EXCEL SHEET
Jamie, If this is to be text, make sure that the field has a ' in front of the field. That's how excel deals with numbers that need to be text. Steve Durette - Original Message - From: JAIME HOI [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 31, 2002 2:54 AM Subject: CFFILE WRITE TO EXCEL SHEET hi i got a question here. i am writing some data into an excel sheet using CFFILE tag. However when the data happen to be a string like 0040, the first 2 zeros will be removed automatically once its written to the excel sheet. Is there any way to disable this function? Any help will be greatly appreciated. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Dreamweaver Keyboard mapping (cf studio user forced to convert!)
Can any one tell me if there is a way to get the ctrl-m functionality from Studio to work in Dreamweaver. Many times I have to work through other peoples cfcode and the ability to jump to the end tag for the current tag is extremely helpful. Thanks Steve Durette ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Screwy Excel Query Result
Ian, I have seen this behavior before. It seems that sometimes when you use excel even if you declare a field text and you then enter a number into it excel will convert it to a number instead! Before I get flamed stating that this doesn't happen, it has happened to me. The easiest way to fix from your point of view should be that when you call in the zip column add some code to check for the length of the zip and if it is less than 5 characters long, keep adding zeros to the beginning until it is 5 characters long. If this were sql I could come up with some really slick code to do the trick. I usually don't do this kind of stuff directly from CF. Normally I would pull the data into my SQL server and work on it that way. Steve - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 28, 2002 11:42 AM Subject: Screwy Excel Query Result I'm querying an Excel spreadsheet that includes a ZIP column. For some reason the query drops all ZIP codes that start with 0. I'm using CF5, and my query is really simple: SELECT * FROM dealerinfo The ZIP column is TEXT format in the spreadsheet. I'd love to switch to CSV but I need this to be really, really simple for my client - ideally they should be able to upload the .xls file and be done with it. Has anyone else seen this behavior? Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: HTML to PDF
How about the HTML2PDF3 tag in the devexchange? It uses htmldoc to create the pdf files. HtmlDoc was recently made opensource and therefor free. A compiled version of HtmlDoc is included in the tag download. Steve - Original Message - From: Michael Vinson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 9:27 PM Subject: Re: HTML to PDF Hi gang... same thing but on the windows side... I'm looking for a cheap (not necessarily free) ez, quick, etc solution. Crystal Reports is a decent way to get the job done but what a big flaky piece of software. Bugs quirks galore! At this point, all I need to do is convert a pretty complex cfm/html report to pdf. After 2 days of messing with crystal (and trying to strengthen my weak sql), I'm determined to throw a little money at the problem... any suggestions / price info would be very helpful. Thanks, Mike Stephen M. Aylor wrote: www.pdflib.com - appears to be the linux industry standard. Try that yet? www.fastio.com - may do the deal too. www.planetpdf.com - Original Message - From: Jille Floridor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 6:14 AM Subject: HTML to PDF Hi list, anyone got some advice/hints on how to create a pdf from a html/cfm template? I know there are various custom tags, but the server is running on RedHat Linux, so that excludes many of them.. I've seen some java based tags, but none of those did the job properly (adding images seems to be difficult). So, any ideas? Jille __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Calculations in Query?
Ann, This might not have worked if you have any zeros in the D_Goal column. This would work for SQL Server, and should work for Access, but I'm not sure. SELECT D_ID, D_Name, (CASE D_Goal WHERE 0 THEN 0 ELSE D_Loss/D_Goal*100) as MyValue FROM diet Steve - Original Message - From: Ann Harrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 17, 2002 11:25 PM Subject: RE: Calculations in Query? Thanks, Nathan. I didn't work for me, but that probably has more to do wi th the lateness of the hour than anything. I'll start fresh in the morning. Ann Harrell -Original Message- From: Nathan Chen [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 11:01 PM To: CF-Talk Subject: Re: Calculations in Query? Of course it is possible. Try SELECT D_ID, D_Name, D_Loss/D_Goal*100 as MyValue FROM diet Then put a % after the output value. e.g. cfoutput#MyValue#/cfoutput % - Original Message - From: Ann Harrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, February 17, 2002 8:41 PM Subject: Calculations in Query? I'm trying to figure a percentage in a query. I don't know if it's possible. I would like to D_Loss / D_Goal and then output the percentage. I'm u si ng an Access database if that helps. CFQUERY NAME=QDiet DATASOURCE=met SELECT D_ID, D_Name, D_Loss, D_Goal FROM diet ORDER BY diet.D_Name /CFQUERY Thanks! Ann Harrell __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFStoredProc vs CFQUERY
I was just wondering if any one knew the difference between the
following:
CFSTOREDPROC PROCEDURE=usp_myproc DATASOURCE=mydatasource
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO
dbVarName = @param2
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_INTERGER VARIABLE =
BAR dbVarName = @param3
/CFSTOREDPROC
AND THIS:
CFQUERY Name=qryMyQuery DATASOURCE=mydatasource
{CALL usp_myproc(01/23/1971, 31)}
/CFQUERY
Also, when the stored procedure returns a query, how would you access it
through the first method? The second method at least allows you to name
the query so that you can access the resulting recordset.
Thanks,
Steve Durette
Database Administrator/Web Developer
Engineering/Construction System Support
SBC/Ameritech
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFStoredProc vs CFQUERY
I was just wondering if any one knew the difference between the
following:
CFSTOREDPROC PROCEDURE=usp_myproc DATASOURCE=mydatasource
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO
dbVarName = @param2
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_INTERGER VARIABLE =
BAR dbVarName = @param3
/CFSTOREDPROC
AND THIS:
CFQUERY Name=qryMyQuery DATASOURCE=mydatasource
{CALL usp_myproc(01/23/1971, 31)}
/CFQUERY
Also, when the stored procedure returns a query, how would you access it
through the first method? The second method at least allows you to name
the query so that you can access the resulting recordset.
Thanks,
Steve Durette
Database Administrator/Web Developer
Engineering/Construction System Support
SBC/Ameritech
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFAPPLICATION question.
Can answer this for me? Will users in a sub-application keep the outer application from timing out? Here is an example: I have a CF application that user log into an then have the option to log into a sub application. The sub application is actually in a subdirectory off of the main application. The outer application has a timeout of 10 minutes. The inner application also has a timeout of 10 minutes. While the users are clicking away in the sub-app are the clicks stopping the outer app from timing out or will the have to log back in after 10 minutes are up and they finally decide to click the link back to the main application? Thanks, Steve Durette Database Administrator/Web Developer Engineering Construction Systems Support SBC/Ameritech __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFAPPLICATION question.
Thanks for the info I think that it will really help out with what I'm woking on. However, I don't think that I made myself clear... I don't ne ed to access any variables, I'm just worried that I'm going to get complaint s if the users have to keep logging in. I'm just wondering if the fact tha t they are clicking pages will keep the outer application from timing out. The particular applications that I am working on have seperate CFAPPLICAT ION tags in their own application.cfm's. Since they are already in one CFapp , is the second CFApp nested within the first? If they are nested, does th at mean that clicks (forms filled in, hyperlinks taken, etc.) will keep the outer application from timing out? Thanks again, PS the answers given already just helped me solve a different problem I w as working on. Steve - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 21, 2002 11:37 PM Subject: RE: CFAPPLICATION question. Yeah - that's what I was implying -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 6:07 PM To: CF-Talk Subject: RE: CFAPPLICATION question. Mark, If someone creates an application within an application, they don't nee application.cfm as CF will search backwards till it finds one. The only reason you would cfinclude a previous application.cfm is to make it par t of the same original session for the user. But as you said If there is a different cfapplication used with a different name then you ende up with not being able to share variables scopes at all -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 22 January 2002 2:54 PM To: CF-Talk Subject: RE: CFAPPLICATION question. Steve, In my experience, if they both have separate cfapplication tags with separately named applications, you are actually dealing with 2 differen t scopes - however if you are doing a cfinclude of the first application.cf m file in the second (sub) application.cfm file, and there is only one cfapplication tag, they are sharing the same application scope. If you include an application.cfm file in the inner (sub) directory that does N OT have a cfapplication tag in it, you are NOT still in the prior applicatio n scope - instead you are without an application scope altogether (becaus e there is no cfappplication running). At least that is how I understand it. Someone else could perhaps shed a bit more light. mark -Original Message- From: Steven Durette [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 5:43 PM To: CF-Talk Subject: CFAPPLICATION question. Can answer this for me? Will users in a sub-application keep the outer application from timing out? Here is an example: I have a CF application that user log into an then have the option to log into a sub application. The sub application is actually in a subdirectory off of the main application. The outer application has a timeout of 10 minutes. The inner application also has a timeout of 10 minutes. While the users are clicking away in the sub-app are the clicks stopping the outer app from timing out or will the have to log back in after 10 minutes are up and they finally decide to click the link back to the main application? Thanks, Steve Durette Database Administrator/Web Developer Engineering Construction Systems Support SBC/Ameritech __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFStoredProc vs CFQUERY
Thanks for the info, does anyone know if one is faster than the other?
Steve
- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, January 21, 2002 8:29 PM
Subject: RE: CFStoredProc vs CFQUERY
Use the CFPROCRESULT name=MyQueryObject inside the CFSTOREDPROC
tags
(normally the last one specified)...
Using cfstoredproc tags eliminates a bunch of errors - in the CFQuery
call,
how do you know the Date is a proper format? the cfprocparam tags
handle
any neccessary conversion (within reason) for you.
Also, with cfstoredproc, you can have multiple recordsets returned, and
have
access to the Stored Procedures return value. You can't do that with
CFQuery.
Shawn Grover
-Original Message-
From: Steven Durette [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 6:15 PM
To: CF-Talk
Subject: CFStoredProc vs CFQUERY
I was just wondering if any one knew the difference between the
following:
CFSTOREDPROC PROCEDURE=usp_myproc DATASOURCE=mydatasource
CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO
dbVarName = @param2 CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_INTERGER
VARIABLE=
BAR dbVarName = @param3
/CFSTOREDPROC
AND THIS:
CFQUERY Name=qryMyQuery DATASOURCE=mydatasource
{CALL usp_myproc(01/23/1971, 31)}
/CFQUERY
Also, when the stored procedure returns a query, how would you access
it
through the first method? The second method at least allows you to
name
the query so that you can access the resulting recordset.
Thanks,
Steve Durette
Database Administrator/Web Developer
Engineering/Construction System Support
SBC/Ameritech
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: PRINTING-SOME WORDS DROP
I had somewhat the same problem with a few sites that I had. The resolution (which might not work for you.) was to change the color of the font. The variables were color coded for emphasis on the displayed page and the printers that the user had was seeing the light color I used as white. I chose a darker color and it printed for him fine. Steve Durette [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 1:57 PM Subject: PRINTING-SOME WORDS DROP I have an application which dynamically generates a web page, based on form inputs and queries. Some of the viewable words on the page, which happen to be variables like CFOUTPUT#var#/CFOUTPUT, show up fine on the displayed page in both IE and NS, but disappear when printed on SOME printers. Everything prints fine from my browser to an old HP Laserjet III printer, but I have a couple of customers complaining about these words disappearing, when printed. The only real difference I know of is that I am running W2K server and they are using Win 98. Any suggestions or ideas? John Grubb [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Newbie Syntax Help
You might be able to speed up the query and get it to work if you make a few minor changes. In the form instead of : marketplace.cfm?request=cat marketplace.cfm?request=twn marketplace.cfm?request=alpha change it so the options are: marketplace.cfm?request=category marketplace.cfm?request=town marketplace.cfm?request=busname Then in the marketplace.cfm file make these changes: CFPARAM NAME=URL.request DEFAULT=category CFQUERY NAME=GetResults DATASOURCE=Reminder SELECT * FROM customer ORDER BY #URL.request# /CFQUERY The CFPARAM ensures that there is a value for the url.request variable (prevents errors) and the change to the CFQUERY means that it doesn't have to evaluate 3 CFIFs. If for some strange reason you can't do this, then to correct your original code, change CFIF request = to CFIF request IS Steven Durette MGR. - Engineering Construction System Support Database Administrator/Web Developer Ameritech/SBC (810)466-7654 [Office] [EMAIL PROTECTED] [work email] [EMAIL PROTECTED] [work email] - Original Message - From: Jeffrey Cohen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, September 09, 2001 2:11 AM Subject: Newbie Syntax Help Help!!! Please!!! OK..I'm new at this, so be kind... I have a pulldown menu, that returns a URL like: marketplace.cfm?request=cat marketplace.cfm?request=twn or marketplace.cfm?request=alpha Then, in marketplace.cfm, I am trying to ORDER BY the variable above, like CFQUERY NAME=GetResults DATASOURCE=Reminder SELECT * FROM customer cfif request = catorder by category/cfif cfif request = twnorder by town/cfif cfif request = alphaorder by busname/cfif /CFQUERY Of course, this blows up! (CAT is Undefined...), even though debugging tell me URL parameters request=cat. How am I supposed to pass a variable from a url to my sql query??? Thanks in advance! Jeffrey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfquery Question
What your looking for is: CFQUERY Name=myTables Datasource=yourDataSource SELECT * FROM sysobjects WHERE xtype = 'U' /CFQUERY Type U is user tables and S is system tables. There are others, but I'm not sure what they are. Steven Durette MGR. - Engineering Construction System Support Database Administrator/Web Developer Ameritech/SBC (810)466-7654 [Office] [EMAIL PROTECTED] [work email] [EMAIL PROTECTED] [work email] - Original Message - From: Edward Chanter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 8:09 AM Subject: cfquery Question I'm probably being a dunce here but does anyone know a sql query that will list out all the tables in a particular sql7 database...? Thanks in advance... -= Ed ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DateAdd Strangeness? (Or is it me?) --it's you!!
Don't forget, some fiscal years start and end in February. Therefore, fiscal 1Q 2001 would be Feb-Apr. - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 28, 2001 2:46 PM Subject: RE: DateAdd Strangeness? (Or is it me?) --it's you!! Yes.. But... (isn't there always one?? ;) You're correct.. Except that a Quarter, when used in calendar terms, means Jan-Mar, Apr-Jun, Jul-Sep, and Oct-Dec. So by using the first test, with now() as the date it answers correctly. However, when using a random date, it does not... It simply adds 3 months. Maybe it's just me assuming that quarter is for calendar quarter. But when someone says Q1 2001.. We all assume they mean Jan-Mar of 2001. And if you add 1 to the Q1, you get Q2, which is Apr-Jun of 2001. Oddly enough.. If you use Quarter(now()) it returns the number based on calendar quarters. So if you're trying to modify a date to get the next calendar quarter.. It would be simple to use the dateadd to add a quarter and voila! But.. Sadly it doesn't work that way. :( -Original Message- From: Saro [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 28, 2001 11:27 AM To: CF-Talk Subject: Re: DateAdd Strangeness? (Or is it me?) --it's you!! First the date is in mm/dd/ format and 3 represents 1st quarter so adding another 1 quarter results in 6.. by the way a quarter is 3 months. - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 28, 2001 11:07 AM Subject: DateAdd Strangeness? (Or is it me?) Try this... cfset nextq = #month(dateadd(q, 1, now()))# cfoutput #nextq# /cfoutput You should get (if you try this in July) the month returned as 10... No problem. However.. Try this... cfset newdate = 3/5/2001 cfset nextq = #month(dateadd(q, 1, newdate))# cfoutput #nextq# /cfoutput And you get the month returned as 6. Huh?? I thought quarters were January, April, July and October? How does one get a 6 as the first month in a quarter? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
