Re: CFEclipse - mimic amp;quot;automatically upload files to server on saveamp;quot;
Have you looked at Aptana Studio? Its a free downloadable plugin for Eclipse. Not only do you get handy tools like CSS and JavaScript syntax completion and highlighting but there's also a 'view' called Sync Manager. There you set up a remote ftp connection [snip] Apparently you missed the part where FTP is not an option. No, if I can't do it with the OS to a UNC mapping, it's a non-starter for me. (At this job, anyway.) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFEclipse - mimic automatically upload files to server on save
Okay, I want to move to CFEclipse. To date, we've used Dreamweaver. I've used CFEclipse for my own personal stuff, and I like it. The only thing that it doesn't do that Dreamweaver does is automatically upload files to server on save. Our current setup is this: Files are checked out of a code repository to a local (virtual) drive. Sites are set-up in Dreamweaver with the local pointing to that local drive, and the remote is a UNC mapping on our Development server. Since the auto save is on, a file locally saved locally is also saved on the server. I've seen some tutorials for being able to do something similar in Eclipse with FTP, but FTP is not an option in my case. So, is there any way I can mimic that behavior with Eclipse? (Yes, I know a lot of people don't like setting up their development environments like this. I work for the government and this situation is not going to change. I've tried. And tried. There's no need to tell me about it.) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error on site - Error converting data type varchar to numeric
I'll wager somebody's description includes a comma. I'll reinforce: use cfqueryparam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: Recommend web design training
I've got a good handle on CF development. What I don't have a good handle on, and which I'm tasked to do more and more, is basic web DESIGN. I've a basic working knowledge of CSS, but certainly not a deep understanding. The web applications I build are functional and work well, but they're not very pretty. Section 508 is also something that I also need to work with. Budgets are being developed now, and I'm being asked to designate the training I'm going to take for 2008. Can anyone recommend some web design training? Web design for developers as it were. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294776 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFREPORTING weirdness
Okay, this is making me crazy. I have a report that has worked just fine in CFMX 7. Now that we are starting to migrate to CFMX 8, I'm getting a very strange error. The code and the .cfr have not changed. Running against the same code and data it works under 7 but not 8. The specific error I am getting is: Invalid ColdFusion expression in report. If the expression is a string, ensure that it is within quotes. Error: query.PRIOR_PS_NUM is not a valid ColdFusion expression. (Sometimes it is another column: query.PRIORITY_SCORE_NUM) The expression I'm using these columns in originally looked like this: (iif(query.PRIOR_PS_NUM is ,'','LSNumberFormat(query.PRIOR_PS_NUM, ,_)')/iif(query.PRIOR_PERCENTILE_NUM is ,'','LSNumberFormat(query.PRIOR_PERCENTILE_NUM, _._)')) I thought perhaps the iif()'s were suboptimal so I built a couple of functions in the report and changed the expression to ( report.formatPriorityScore(query.PRIOR_PS_NUM) / report.formatPercentile(query.PRIOR_PERCENTILE_NUM) ) My functions look like this: cffunction name=formatpriorityscore cfargument name=priorityScoreValue required=yes type=string cfset var returnString= cfif len(trim(priorityScoreValue)) GT 0 cfset returnString=LSNumberFormat(priorityScoreValue, ,_) /cfif cfreturn returnString /cffunction cffunction name=formatpercentile cfargument name=percentileValue required=yes type=string cfset var returnString= cfif len(trim(percentileValue)) GT 0 cfset returnString=LSNumberFormat(percentileValue, _._) /cfif cfreturn returnString /cffunction However, I'm still getting the same error. I saw a thread on the Adobe forums ( http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1catid=20threadid=1307965enterthread=y ) where someone expressed they were having trouble with null values, although the circumstances were slightly different. However, since my query will sometimes return null I thought it was worth a shot. So, I changed my query to explicitly return an empty string instead of null (Oracle NVL() function). Still the same error. I'm at the end of my rope. If I can't fix this, our CFMX 8 upgrade is dead in the water, as this is affecting reports from our most important application. (There's also another weird error I'm getting with CFDOCUMENT, but that's not related to this.) ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfAnswers.org
What happened to cfAnswers.org? ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dmoz
Just an FYI: The tool to allow the public to suggest sites is once again working. Simply go to the most appropriate category, click Suggest URL and follow the instructions on the form. While it is in the guidelines and displayed prominently on the form, I would like to reinforce that these are suggestions. No site is guaranteed a listing and no timeframe for review can be given. I am a volunteer editor at the Open Directory Project ( http://dmoz.org ). The category for ColdFusion ( http://dmoz.org/Computers/Programming/Internet/ColdFusion/ ) hasn't had any serious work done on it since the CF 5.0 days. I've decided to see if I can get it up to snuff. There was recently a major server crash of the editor server and not all functionality is restored, specifically the ability to suggest sites for inclusion. Still, I'd like to hear from the CF community what they feel are the most useful sites for ColdFusion. If Michael Dinowitz doesn't want that information spammed to this list feel free to send it to me directly. (Putting ODP or dmoz in the subject will help me sort messages.) I'm also interested in hearing ideas about the structure of the subcategories. While ODP has some standard categories, editors usually have wide latitude in how they structure the information. Since you are the community this resource is built for, I want the structure to be as helpful as possible. (This is a truism for the entire directory, of course.) Please note that I am not speaking in any sort of official capacity for the Open Directory Project; I am merely one of several thousand volunteers. No site is guaranteed a listing, and suggestions you offer may or may not be used. But, even if each of you just offered up your top 5 CF websites that would go a long way toward building this category to be more useful. About ODP: http://dmoz.org/about.html Suggesting your site: http://dmoz.org/add.html Category description: http://dmoz.org/Computers/Programming/Internet/ColdFusion/desc.html ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dmoz
I have 3 active yahoo groups lists (one with a lot of spam), the google groups archive for alt.comp.lang.coldfusion and CFCDev. I didn't include the CFDJ list as it's basically dead. Google has about 10 CF lists, but their activity is very limited and spotty. What criteria should I use for a list to include it? You might as well send them all since they'll all have to be reviewed anyway. A mailing list or discussion group should be active and free of spam. A list that's not active may still be listable if there is an extensive archive of useful posts. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dmoz
Thanks. Most of those are already in there but I'll add them to the list to review. Unfortunately, some of the better blogs and other resources will need to go to a category higher in the directory tree because they cover much more than CF. On 12/27/06, Cutter (CFRelated) [EMAIL PROTECTED] wrote: Al, You might include a 'resource' listing (for sites like cfQuickDocs and the ColdFusion Portal), a journal listing (for the ColdFusion Developers Journal, FusionAuthority, etc.), podcasts (like the ColdFusion Weekly, Helms and Peters, etc.), also a ColdFusion Blogs listing (for ray.camdenfamily.com, corfield.org, etc.), and maybe a 'code library' listing (for sites like CFLib, the CFCustomTag site, etc.) Cutter ___ http://blog.cutterscrossing.com Everett, Al (NIH/NIGMS) [C] wrote: My first organizational request would be for a Mailing Lists section to showcase all of the ColdFusion specific mailing lists. This does benefit me a little as each list here is a separate entity (like the various google or yahoo lists), but not all of them are ColdFusion specific. You'll not get every mailing list with its own listing. Since houseoffusion.com is listed in the main category, it's unlikely that any deeplinks from there will be in subcategories. See the editing guidelines: http://dmoz.org/guidelines/site-specific.html#deeplinks I'd be happy to compile a collection of all of the ColdFusion related lists from Google, Yahoo, and independent sources (CFCDev, CFDJ, etc.) Go for it. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
dmoz
I am a volunteer editor at the Open Directory Project ( http://dmoz.org ). The category for ColdFusion ( http://dmoz.org/Computers/Programming/Internet/ColdFusion/ ) hasn't had any serious work done on it since the CF 5.0 days. I've decided to see if I can get it up to snuff. There was recently a major server crash of the editor server and not all functionality is restored, specifically the ability to suggest sites for inclusion. Still, I'd like to hear from the CF community what they feel are the most useful sites for ColdFusion. If Michael Dinowitz doesn't want that information spammed to this list feel free to send it to me directly. (Putting ODP or dmoz in the subject will help me sort messages.) I'm also interested in hearing ideas about the structure of the subcategories. While ODP has some standard categories, editors usually have wide latitude in how they structure the information. Since you are the community this resource is built for, I want the structure to be as helpful as possible. (This is a truism for the entire directory, of course.) Please note that I am not speaking in any sort of official capacity for the Open Directory Project; I am merely one of several thousand volunteers. No site is guaranteed a listing, and suggestions you offer may or may not be used. But, even if each of you just offered up your top 5 CF websites that would go a long way toward building this category to be more useful. About ODP: http://dmoz.org/about.html Suggesting your site: http://dmoz.org/add.html Category description: http://dmoz.org/Computers/Programming/Internet/ColdFusion/desc.html ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Developing for 800 x 600 on monitor at higher resolution
I use a bookmarklet that resizes my browser window. http://bookmarklets.com/tools/windowing/index.phtml Resize Window to 800 x 600 On 2/22/06, Earl, George [EMAIL PROTECTED] wrote: We just got new LCD monitors that have a native resolution of 1280 x 1024 but we develop for 800 x 600 (inTRAnet standard). Like lots of LCDs, these look like crap at anything other than their native resolution. If you are in the same boat, how do you develop for a non-native resolution like 800 x 600 and make sure that everything fits and looks right? Do you pop up an 800 x 600 browser window to view the pages? Use a second monitor set to 800 x 600? Use a utility? Thanks! George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233319 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: Getting a Date Query to wrap to the next year
Try: WHERE event_date = #CreateDate(year(startDATE),month(startDATE),1)# and event_date #threemonths# On 8/3/05, Les Mizzell [EMAIL PROTECTED] wrote: I've got a calendar on a page that should always show the next three months worth of events from the start month you pick from a list. It's working great for events in 2005, or if you skip to an event in 2006 it will show the next three 2006 months. The problem I'm having is getting it to wrap from 2005 to 2006. For example, if I select December, I should see events for December 2005, January, 2006 and Feb 2006. However, it stops at 2005 and won't display any 2006 events until I select a month from 2006. Hope I made that confusing enough for everybody... Here's the query in question: cfquery name=calendar SELECT id, event_date, month(event_date) as theMONTH, event_name FROM eip_events WHERE month(event_date) = #month(startDATE)# and year(event_date) = #year(startDATE)# and event_date #threemonths# ORDER BY event_date,event_time ASC /cfquery The problem is cleary with the first WHERE line month(event_date) = #month(startDATE)# Somehow it needs to also say unless it's November or December, then wrap the month back around to January of the next year. Ideas? -- --- Les Mizzell ~| 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:213594 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfoutput grouping - current row
The counter variable is how I would do it. On 7/28/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, Anyone know if there's a way to get the 'currentrow' within a cfoutput grouping? In other words, if I have 5 groups I'm cfoutputting, I want to be able to access the row # within each group. I know I can do this by setting a counter and incrementing within the 'inside' cfoutput tag, and then resetting it to 1 before that every time, but I'm wondering if there is a cleaner way of doing this. And just to be clear, query.currentrow does not give me that, it gives me the row number in relation to the entire query, not the group. Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213174 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Sites with F5
We've been using BIGIP for years. Works like a champ. Had some growing pains early on, but it worked out fine. On 7/28/05, John Blayter [EMAIL PROTECTED] wrote: Does anyone know of any CF based sites that are up and working with an F5-BIG IP? I have a client that is in the middle of implementing CF7 behind and F5 and they are scared that it is not going to work even though all sale/white paper literature says that it will work. -- John Blayter email: [EMAIL PROTECTED] ~| 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:213181 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: CF Sites with F5
http://new.askallied.com http://www.caddocentral.com On 7/28/05, John Blayter [EMAIL PROTECTED] wrote: I think they are looking for specific websites that run with CF and a F5. On 7/28/05, Al Everett [EMAIL PROTECTED] wrote: We've been using BIGIP for years. Works like a champ. Had some growing pains early on, but it worked out fine. On 7/28/05, John Blayter [EMAIL PROTECTED] wrote: Does anyone know of any CF based sites that are up and working with an F5-BIG IP? I have a client that is in the middle of implementing CF7 behind and F5 and they are scared that it is not going to work even though all sale/white paper literature says that it will work. -- John Blayter email: [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213235 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: Working with OPC (Other People's Code)
Been there. On 7/22/05, Matt Osbun [EMAIL PROTECTED] wrote: Unless, of course, you're currently updating code you wrote during your humble beginnings... I wrote *what*? Matt Osbun Web Developer Health Systems, International -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 1:06 PM To: CF-Talk Subject: RE: Working with OPC (Other People's Code) Yes Ken, it's good to remember our humble beginnings. While we laugh now, we're years after someone who laughed at us. Keeps us humble. :) But at least we can enjoy it now! I guess we've earned our 'stripes'. Dave ~| 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:212609 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: # Signs Causing a different Problem
Spaces and other non-standard characters in filenames will cause issues. You could escape the non-alphanumerics... a href=/documents/interview%20with%20john%20smith%20%231.doc but from my experience that will only work with IE. Firefox/Mozilla will still choke. We're pretty adamant 'round here that filenames that are to be accessible via a hyperlink must contain only letters, numbers, and underscores. On 7/21/05, E C list [EMAIL PROTECTED] wrote: Hi Folks, In my document management application, I have recently run into a problem. I have some documents which were named with pound signs in their name interview with john smith #1.doc for instance. When I link to this file name, the link doesn't work: a href=/documents/interview with john smith #1.docDownload file a/a It will generate a 404 file not found. So the question is, why does this happen? Is this a document encoding issue? Can anyone suggest a solution aside from just renaming the file before its saved? Thank you. Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212402 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: CFQuery and SQLBase - alternative to using asterisk
You shouldn't ever use SELECT *. Name the columns you want. For the other, try PHONE##. On 7/20/05, Perez, Percy [EMAIL PROTECTED] wrote: Hello, I am having problems doing a simple SQL select. When I enter: SELECT * from TABLE1, I get an error message that the asterisk is an invalid character. However, if I used dreamweaver to view data, I get all the columns and records. If I do a select listing some of the fields it works. Also, the original database creators added a PHONE# field. Of course the # sign is not well liked by coldfusion. I trying using a bracket to escape the special character but no go. Unfortunately, I can not alter the table since it is provided by ADP (Payroll Company) and there is a GUI interface provided by them. Any suggestions? Thank you in advanced. Percy Systems Administrator Versa Products Company Inc 22 Spring Valley Road Paramus NJ 07652 Ph:201.843.2400 Fx: 201.843.2931 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFQuery and SQLBase - alternative to using asterisk
It's still sloppy. For one thing, there's no way to tell what columns you're getting back unless you look at the table as well. I find it very rare that I need all columns from any table. Any best practice document I've seen on SQL says to avoid SELECT *. On 7/20/05, Claude Schneegans [EMAIL PROTECTED] wrote: You shouldn't ever use SELECT *. Name the columns you want. Well, ... except if you do need all columns, and SELECT * is standard in SQL, especially for that purpose. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212321 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: Code function
You probably need a fully qualified URL. cfhttp method=Get url=http://127.0.0.1:8500/tests/escapetest.txt; name=onerow On 7/19/05, Ken [EMAIL PROTECTED] wrote: 127.0.0.1:8500/tests/escapetest.txt -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesid=58370t=1 Got Gmail? I have 50 invites to give away. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212233 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: Code function
Try this instead: cfhttp method=Get url=http://127.0.0.1/tests/escapetest.txt; port=8500 name=onerow On 7/19/05, Ken [EMAIL PROTECTED] wrote: Well, My actual code is a fully qualified URL. And besides, its the same code that works fine on CF MX 7, but not on CF 5.0 - Ken On 7/19/05, Al Everett [EMAIL PROTECTED] wrote: You probably need a fully qualified URL. cfhttp method=Get url=http://127.0.0.1:8500/tests/escapetest.txt; name=onerow On 7/19/05, Ken [EMAIL PROTECTED] wrote: 127.0.0.1:8500/tests/escapetest.txt -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesid=58370t=1 Got Gmail? I have 50 invites to give away. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212238 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Code function
You might also need to define the delimiter and textqualifier. On 7/19/05, Al Everett [EMAIL PROTECTED] wrote: Try this instead: cfhttp method=Get url=http://127.0.0.1/tests/escapetest.txt; port=8500 name=onerow On 7/19/05, Ken [EMAIL PROTECTED] wrote: Well, My actual code is a fully qualified URL. And besides, its the same code that works fine on CF MX 7, but not on CF 5.0 - Ken On 7/19/05, Al Everett [EMAIL PROTECTED] wrote: You probably need a fully qualified URL. cfhttp method=Get url=http://127.0.0.1:8500/tests/escapetest.txt; name=onerow On 7/19/05, Ken [EMAIL PROTECTED] wrote: 127.0.0.1:8500/tests/escapetest.txt -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesid=58370t=1 Got Gmail? I have 50 invites to give away. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212239 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
CFUNITED CD
So I got lucky and got the PHBs to pony up for me to go to CFUNITED this year. Awesome. Very glad I went. The bound book of all the presentations is great, but what I'd really like is a CD-ROM. I pulled my little CFUNITED backpack apart and there is no such CD in there. I don't see a place on http://www.cfunited.com/ to download all the presentations, but that doesn't surprise me. The site is a little disorganized. So, can anyone point me to a link? Or make an image of the CD available for FTP? I can burn it myself. -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesid=58370t=1 Got Gmail? I have 50 invites to give away. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211919 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Custom Tags for HTML page layout
On 5/30/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: Well yes and no... given the way you plan to use it, I wouldn't expect you to need to set thistag.generatedcontent to an empty string -- or to output the value of thistag.generatedcontent anywhere in the tag... Well, serves me right for not paying attention and trying to remember a technique I saw without having the context. As I said, brain wasn't fully engaged that day. Thanks. -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesid=58370t=1 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207990 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
Custom Tags for HTML page layout
So, I want to use a custom tag to standardize my page layouts. Basically I want all templates that will display to the user to be constructed this way: cf_pagelayout !--- Page Content Goes Here --- /cf_pagelayout Here's the (very basic) custom tag I wrote: cfsetting enablecfoutputonly=Yes cfif NOT thisTag.HasEndTag cfthrow message=cf_pagelayout requires an end tag. cfexit method=EXITTAG /cfif cfparam name=attributes.pageTitle default=Default Title Text cfif thisTag.ExecutionMode is start cfoutput !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head /cfoutput cfelse cfoutput meta http-equiv=Content-Type content=text/html; charset=utf-8 title#attributes.pageTitle#/title /head body #thisTag.GeneratedContent# /body /html /cfoutput /cfif cfsetting enablecfoutputonly=No When I test it with: cf_pagelayout This is a test... /cf_pagelayout The HTML that is generated is: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head This is a test... meta http-equiv=Content-Type content=text/html; charset=utf-8 titleDefault Title Text/title /head body This is a test... /body /html I am sure it's something simple, but my brain doesn't seem to want to fully engage. -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesid=58370t=1 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207977 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: Custom Tags for HTML page layout
Seems I found the solution. cfset thisTag.GeneratedContent= before exiting the ExecutionMode block for the end tag. Anyone else use this kind of technique have any tips? On 5/29/05, Al Everett [EMAIL PROTECTED] wrote: So, I want to use a custom tag to standardize my page layouts. Basically I want all templates that will display to the user to be constructed this way: cf_pagelayout !--- Page Content Goes Here --- /cf_pagelayout Here's the (very basic) custom tag I wrote: cfsetting enablecfoutputonly=Yes cfif NOT thisTag.HasEndTag cfthrow message=cf_pagelayout requires an end tag. cfexit method=EXITTAG /cfif cfparam name=attributes.pageTitle default=Default Title Text cfif thisTag.ExecutionMode is start cfoutput !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head /cfoutput cfelse cfoutput meta http-equiv=Content-Type content=text/html; charset=utf-8 title#attributes.pageTitle#/title /head body #thisTag.GeneratedContent# /body /html /cfoutput /cfif cfsetting enablecfoutputonly=No When I test it with: cf_pagelayout This is a test... /cf_pagelayout The HTML that is generated is: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head This is a test... meta http-equiv=Content-Type content =text/html; charset=utf-8 titleDefault Title Text/title /head body This is a test... /body /html I am sure it's something simple, but my brain doesn't seem to want to fully engage. -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesid=58370t=1 -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesid=58370t=1 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207978 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How can I avoid Evaluate() function?
Which begs the question: Are there any variable scopes left that cannot be referenced using array notation? On 5/13/05, Barney Boisvert [EMAIL PROTECTED] wrote: #application[cookie.country Rate]# cheers, barneyb On 5/13/05, Phill B [EMAIL PROTECTED] wrote: Is there any better way of doing this? cfinvokeargument name=exchangeRate value=#Evaluate(application. cookie.country Rate)# -- Phillip B. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206653 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Parent-Child Relationships within Table
Academic, really, with Oracle 9i. (Which is what we're using at the day job.) If 7 is the categoryid for Hockey: select categoryid, category, level from catalog start with categoryid=7 connect by parentid = prior categoryid level is a pseudo-column indicates the level of the tree, starting with 1. Throw in SYS_CONNECT_BY_PATH(category,'|') into the SELECT clause and you can display the whole chain as well. On 5/9/05, Kazmierczak, Kevin [EMAIL PROTECTED] wrote: How does everyone handle an N level parent-child type relationship within the same table? Say you have the following table setup for Categories categoryid category parentid You could have any level of categories each with the parent pointing up the path. The problem I'm interested in is how to retrieve data out of that setup. Right now I am using a UDF that opens cursors up and scans the path to match records but that is killing the execution time as traffic builds up on the site. Example: Category Path: Sports - Hockey - Teams - Buffalo Sabres You want to find anything that is a member of the hockey category and any sub category within. One option I am considering is to write out the entire path or write out all the categories in a table or something that would make retrieval faster, but would make an administrative nightmare. What do you recommend? Thanks. --- Kevin Kazmierczak Senior Software Developer Citynet 113 Platinum Drive Bridgeport, WV 26330 Phone: 304.848.5451 http://www.citynet.net ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206102 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
Trusted Cache
Okay, my mind is apparently slipping. I understand that the Trusted Cache setting can give significant performance gains because CF is not checking for a newer version of CFML to compile for each page request. But let's say I have made CFML changes and I need the server to start using them. Can I simply stop and start ColdFusion? Or to I need to: 1. Turn off trusted cache 2. Stop ColdFusion 3. Start ColdFusion 4. Turn on trusted cache -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205570 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: Trusted Cache
On 5/4/05, Dave Carabetta [EMAIL PROTECTED] wrote: 1) Turn off trusted cache 2) Copy out your files and run the new pages so CF compile them, etc. 3) Turn on trusted cache No need to restart your server at all in my experience. Sounds simple enough. I just know that there are circumstances where one or more templates that's been changed will be very rarely touched and will be hard to get to in normal testing. I guess I was hoping there was a way I could just clear the cache so CF will just treat all pages as new and will compile them. Would deleting my .class files accomplish such a thing? (I've got CFMX 6.1 and 7 installations here.) -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205582 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: Options to use instead of mappings?
On 5/3/05, Douglas Knudsen [EMAIL PROTECTED] wrote: relative paths? Where you have to have an absolute path, you could have a var storing teh root pat, say appliction.rootdir. I've had some good success with that and using a UDF called GetRelative. As long as the basic root is known you don't need to know where the current template is in relation. http://cflib.org/udf.cfm?ID=837 -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205392 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: cfqueryparam and null values
Relying on the implicit conversion is lazy and error prone (since many people accidentally invert the condition - either while they're writing the code or, worse, when they're reading other people's code). Which is precisely why I stopped using the shortcut. I only type at a mere 45 WPM, but for the extra clarity it provides the extra keystroke is worth it. I expend more calories scratching myself than typing an extra character (or three). ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204920 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfqueryparam and null values
On 4/27/05, Al Everett [EMAIL PROTECTED] wrote: On 4/26/05, Bryan Stevenson [EMAIL PROTECTED] wrote: cfqueryparam value=#Trim(FORM.txtFirstName)# cfsqltype=cf_sql_varchar null=#YesNoFormat(Len(Trim(FORM.txtFirstName))# This is also the technique I use. Of course I put EQ 0 at the end there. -- a href=http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1;Get Firefox!/a http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204680 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: cfqueryparam and null values
On 4/26/05, Bryan Stevenson [EMAIL PROTECTED] wrote: cfqueryparam value=#Trim(FORM.txtFirstName)# cfsqltype=cf_sql_varchar null=#YesNoFormat(Len(Trim(FORM.txtFirstName))# This is also the technique I use. -- a href=http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1;Get Firefox!/a http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1 ~| 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:204679 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
Are search engine safe URLs really necessary?
For those of you taking a lot of time getting your dynamic site URLs to look like static ones, this article may be of interest to you: http://www.emediawire.com/releases/2005/4/emw232456.htm (I am in no way affiliated with the site. It just happened to come up in a Google Alert and covers a topic I've seen pass through the list more than once.) -- a href=http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1;Get Firefox!/a http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Structures (probably a stupid question)
The thing that helped me understand structures more than anything else was the good old CFDUMP tag. When I could see the structure it all made sense. On 4/24/05, Thane Sherrington [EMAIL PROTECTED] wrote: At 12:57 PM 24/04/2005, Sean Corfield wrote: If you're just getting your head around this stuff, I strongly suggest you buy Jeff Peters' book: ColdFusion Lists, Arrays Structures: http://www.protonarts.com/index.cfm?fuseaction=Books.showBookDetailsISBN=0975264702 Thanks for the suggestion. I think I'll pick that up. T --- [This E-mail scanned for viruses by Declude Anti-Virus] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204318 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: Just a nice little feature for your clients
Do it at the day job. (Large independent Office Supplies B2B company.) Want to know not only what people are searching for, but also how long the query took and how many records come back. Currently analysing results where no results come back to improve the results if it is something we sell. (You'd be shocked how many different ways there are to incorrectly spell scissors.) On 4/13/05, Will Tomlinson [EMAIL PROTECTED] wrote: Hey all, I recently added a simple but very effective feature on my client's site. I just never thought of doing this but once it hit me, I was like yeah! That'd be great. And don't expect any rocket science, it's ol' Will here. :) She asked about tracking what her users were searching for on the volleyball clothing site. I immediately thought, tblsearches (let's not go there :)) - searchID, searchterm, searchdate, etc..etc.. Well it's turned out to be a VERY good addition. I win for obvious reasons, my client wins because we now know that we have quite a few shoppers searching for socks. Ok, so they're also searching for their friends' names, but that's beside the point. lol! The customer wins because we now know what products they're looking for and now we'll work on offering them. Just thought I'd share that little tidbit with you all because I've never seen this in the books I've read, nor heard anyone talking about it here in the forums. I also know some guys that build major e-commerce apps and even THEY don't do anything like this right now, yet it's so simple! Is it not standard practice to log all searches to your db? Thanks for reading, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202672 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Bonhead Move #23887
I didn't do this, but someone I used to work with did. Back in the CF4.5 days, before CF managed the size of its log files itself, you could see a performance hit if the file got overly large. So, we needed something that would rename any log file that got over a certain size and let CF start building a new one. We figured 1 MB was about right. His solution? Use CFFILE to read the file into a variable. Then check the Len() of the variable and, if it was over 100, write the contents of the variable to a new file, then delete the original. It was run by the scheduler, so we didn't initially note how long it took to run. Other people I worked with had a tenuous grasp of basic CF concepts. One of my favorite code snippets was: cfif Len(form.myVariable) GT 0 cfset myVariable=form.myVariable cfelse cfset myVariable= /cfif Of course, my most recent bonehead move was to write a UDF to count the number of times a particular value appeared in a list. What's that you say? There's a function called ListValueCount()? On Apr 1, 2005 10:43 AM, Claremont, Timothy [EMAIL PROTECTED] wrote: This morning all he!! Broke loose when the intranet was spewing errors left and right. Come to find out I was using a poor choice of determining yesterdays date. I was merely subtracting 1 from the day of the month. Hence, I was trying to generate a bunch of stuff with a date of April 0, 2005. Naturally, this mistake did not rear its ugly head until the first of the month. Go ahead... Tell me you have never made such a brilliant mistake! -Tim ** 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 delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201990 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: Form field naming issue
A CFFORM feature is server-side validation. To kick it off, you need specially formatted form field names. One of those is *_DATE. Quoting from http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p38.htm#wp2433198 === Any form field name, from the cfform tag or an HTML form, that ends in one of the following suffixes invokes server-side form validation: * _integer Verifies that the user entered a number. * _float Verifies that the user entered a number. * _range Verifies that a numeric value entered is within specified boundaries. * _date Verifies that the user entered a date; converts to ODBC date format. * _time Verifies that the user correctly entered a time; converts to ODBC time format. * _eurodate Verifies that the user entered a date in a standard European date format; converts to ODBC date format. Do not use these suffixes for your field names. === On Thu, 31 Mar 2005 13:45:45 -0700, Scott Weikert [EMAIL PROTECTED] wrote: Hey all - Got a weird issue happening here. I've got a form that, when submitted, one of the fields doesn't get added to the 'form.fieldlist' variable - hence, doesn't get kicked over to the attributes scope (using CFFormURL2Attributes), and hence, causes an error to kick when that variable isn't present. The variable IS present in the 'form' scope, though - it just isn't in form.fieldnames. Doing a dump of the form scope reveals the variable and the expected value. Doing a dump of the attributes scope, the variable isn't there. The variable name in question is 'Brochure_Request_Date' - and I've since adjusted that field name to simply 'BrochureReqDate' and it works fine now. What in the old variable name could be the issue? The word 'Request'? I know it's not the underscores, as other fields in the same form have underscores in them. --Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201053 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query works in fine CF5 but not CFMX
I would suspect differences in case sensitivity in the database drivers. See if this works on both: CFQUERY NAME=getmember DATASOURCE=#DS# SELECT member FROM login WHERE lower(username) = 'test' and lower(password) = 'test' /CFQUERY On Tue, 8 Mar 2005 13:42:02 -0500, Ronald Gallagher [EMAIL PROTECTED] wrote: I have a simple query against an Oracle database that works in CF 5 but not in CFMX. In CF 5 I get one record which is what I want, but in CFMX I don't get any results. Yet the code is the very same. How do I fix this strange behavior? Here is the query: CFQUERY NAME=getmember DATASOURCE=#DS# SELECT member FROM login WHERE username = 'test' and password = 'test' /CFQUERY No queries are cached, I even cycled CFMX. Not sure what is going on. Any help/advice would be appreciated. Thanks! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197880 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: CF 5.0
Your results are consistent with your query, since you're sorting call_date in descending order (DESC). Change DESC to ASC (or remove it altogether and you should be fine. On Thu, 17 Feb 2005 08:34:10 -0700, Paul Roe [EMAIL PROTECTED] wrote: Hey I'm having a problem I have data in a table that looks like this Call_Date 2005-02-16 00:00:00 Call_Time 7:53:00 Right now I am trying to sort the records so that I get the most recent 5. Here's my qoq: SELECT * FROM getMemberActivity ORDER BY call_date DESC,call_time DESC This returns data that looks like this : 2005-02-16 00:00:00 9:38:00 2005-02-16 00:00:00 8:55:00 2005-02-16 00:00:00 8:34:00 2005-02-16 00:00:00 8:05:00 2005-02-16 00:00:00 8:04:00 2005-02-16 00:00:00 7:53:00 2004-12-16 00:00:00 15:28:00 When what I want is this: 2004-12-16 00:00:00 15:28:00 2005-02-16 00:00:00 9:38:00 2005-02-16 00:00:00 8:55:00 2005-02-16 00:00:00 8:34:00 2005-02-16 00:00:00 8:05:00 2005-02-16 00:00:00 8:04:00 2005-02-16 00:00:00 7:53:00 Any ideas, I'm running cf 5.0 on windowsiis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195182 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Analytics
I'm trying to find the same thing, but I have the opposite problem. I have a single site load-balanced across seven servers. I need something that can work with the logs of each individually and in aggregate. On Mon, 7 Feb 2005 06:04:34 -0500, Dwayne Cole [EMAIL PROTECTED] wrote: Any recommendations on software to help track site visit and performance stats. I know about Web Trends but I was wondering if there others that may be better, less expensive, easier to use etc. I have a co-located box and I host 10 sites. $9,000 is a bit much and even $495 for each site (webtrends cost for the software for each domain)is a bit much. My small client base like our solution but would also like to have web analytics. I'm looking for a way deliver this what is often a standard feature with most host. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193312 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: Stored procedure error
I've always found that error to be thrown by Oracle when it can't tell
you what the error is. It is singularly unhelpful.
I would start with your proc. Run it outside of CF to see if you get a
better error message.
On Sun, 6 Feb 2005 22:38:25 -0500, Doug Hyde [EMAIL PROTECTED] wrote:
Anybody ever encounter this error?
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
It seems to be related to a stored procedure call. See below.
Doug
---
TypeDatabase
Query Error [Microsoft][ODBC SQL Server Driver]Optional feature not
implemented
Native Error Code 0
SQL State S1C00
SQL { call spVisit(?,?,?,?) }
Tag Context CFINCLUDE: Line=1; Column=1
|
+-- CFIF: Line=15; Column=1
|
+-- CFELSE: Line=26; Column=1
|
+-- CFOUTPUT: Line=55; Column=1
|
+-- CFIF: Line=90; Column=1
|
+-- CFELSEIF: Line=113; Column=1
|
+-- CFIF: Line=123; Column=1
|
+-- CFELSEIF: Line=138; Column=1
|
+-- CFINCLUDE: Line=142; Column=2
|
+-- CFOUTPUT: Line=14; Column=1
|
+-- CFINCLUDE: Line=30; Column=22
|
+-- CFOUTPUT: Line=5; Column=1
|
+-- CFSTOREDPROC: Line=79;
Column=1
Source
76: /cfif
77: /cfif
78:
79: cfstoredproc datasource=#dsn# procedure=spVisit
80: cfprocparam dbvarname=userID cfsqltype=CF_SQL_INTEGER
value=#userID# type=In
^ Snippet from underlying CFML source
~|
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:193318
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you change the color of each row?
On Mon, 31 Jan 2005 13:02:18 -0800 (PST), Discover Antartica [EMAIL PROTECTED] wrote: is there a way to do this without CSS? http://cflib.org/udf.cfm?ID=901 ~| 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:192637 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: in need of education
The thing that helped me understand structures more than anything was the cfdump tag. Getting a visual representation of the structures of the...structure was the thing that put it over the top for me. Not that any of these other resources aren't good, but it was that happy little tag that helped me grok structures. On Tue, 1 Feb 2005 12:44:08 -0600, Donna French [EMAIL PROTECTED] wrote: I'd be interested to hear what others have to say about www.eclasses.org ? Considering taking the Cold Fusion course(s) but would like to hear from others so thought this would be appropriate here. TIA, Donna On Tue, 01 Feb 2005 18:18:48 +0100, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: Tim, The O'Reilly book Programming ColdFusion MX is well worth the money - good end to end tutorial with plenty of examples, coupled with a tag and function reference. I've bought both the old CF5 version and the CFMX version because it is the fastest way i know to bring new hires up to speed in CF w/out having to hold their hands. /t -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 5:51 PM To: CF-Talk Subject: in need of education I am rapidly coming to the conclusion that I need some educatin' with respect to structures, arrays, evaluation function, list creation/manipulation .all that sort of stuff I've been doing a lot of learn as you go/googling for solutions etc, but that type of training is costing too much time now.would like to get some structured training on these topics Any suggestions that don't totally empty my wallet would be greatly appreciated... books/classroom/good online training etc. Tim ~| 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:192659 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
Hosting
I know this question comes up a lot on the list, but I'm looking for a new CF hosting company. I know that there was even a conversation about the best ones in the last few months, but I'm not getting any love searching the HoF archives. I don't want to re-hash it all again but could someone point me to an archive of a thread or three? Thanks. -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1 ~| 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:190684 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Hosting
Maybe I should enumerate what it is I'm looking for. I have, to date, been using experthost.com. One thing I like about them is they have a very nice fee schedule for reselling. I use them for a couple of clients' hosting and my cost is under US$10/month per domain. I would like, however, some more control. I'd like it if I could get all of my clients on a single server (none of them are anything near a high-traffic site) to take advantage of some code reuse and would like to be able to to things like define ColdFusion mappings. I'm not ready, though, to pony up for a dedicated server. How much control do these other hosts offer? On Fri, 14 Jan 2005 10:39:51 -0500, Al Everett [EMAIL PROTECTED] wrote: I know this question comes up a lot on the list, but I'm looking for a new CF hosting company. I know that there was even a conversation about the best ones in the last few months, but I'm not getting any love searching the HoF archives. I don't want to re-hash it all again but could someone point me to an archive of a thread or three? ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190709 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: Multivalued Array help
This is new in CFMX. If you use dot notation CFMX assumes you are referencing a structure and creates it if it doesn't exist. CF5 and prior would create a simple variable in the local scope with a dot in it. http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/arrayStruct7.htm On Fri, 14 Jan 2005 13:17:29 -0600, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: I was recently testing something and made an interesting discovery... cfscript thisVar.testStruct.myVal = some value; /cfscript Actually works... without a structNew() call to create it. So... new question... do we go ahead and imply a struct simply by syntax, or do we, for the sake of protocol and readability, insist on an explicit strucNew() call? Personally, I'm for dropping the extra operation and implicity creating a struct. Anybody? Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com On Fri, 14 Jan 2005 13:58:04 -0500, Ben Doom [EMAIL PROTECTED] wrote: Associative arrays in PHP are basically the equivalent of structures in CF. So, in CFSCRIPT... item = structnew(); item.level = level 12; item.ecs = something else; // alternate syntax item[dn] = third data; and so forth. --Ben Charles Heizer wrote: Hello, If I wanted to do a multi-valued array in php I would initialize the array like this, how would I do this in ColdFusion? Thanks, - Charles PHP Example -- $item = array( 'level'= $level, 'ecs' = $expanded, 'dn'= $dn, 'rdn'= $rdn[0], 'icon'= $icon, ); ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190722 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: basic: outputting data from several tables in one CFOUTPUT
Try this: CFQUERY name=get_tasks datasource=taskomatic SELECT tasks.task_id, tasks.name as tasks_name, tasks.deadline, tasks.project_id, tasks.importance_id, tasks.owner_id, projects.project_id, projects.name as projects_name, people.person_id, people.name as people_name, importance.importance_id, importance.importance FROM tasks JOIN projects ON tasks.project_id = projects.project_id JOIN people ON tasks.owner_id = people.person_id JOIN importance ON tasks.importance_id = importance.importance_id /CFQUERY CFOUTPUT query=get_tasks td#tasks_name#/td td#projects_name#/td td#deadline#/td td#importance#/td td#people_name#/td /CFOUTPUT On Mon, 17 Jan 2005 17:55:41 +, Chris Kavanagh [EMAIL PROTECTED] wrote: Dear list, I've got this query that gets data from three tables: CFQUERY name=get_tasks datasource=taskomatic SELECT tasks.task_id, tasks.name, tasks.deadline, tasks.project_id, tasks.importance_id, tasks.owner_id, projects.project_id, projects.name, people.person_id, people.name, importance.importance_id, importance.importance FROM tasks JOIN projects ON tasks.project_id = projects.project_id JOIN people ON tasks.owner_id = people.person_id JOIN importance ON tasks.importance_id = importance.importance_id /CFQUERY But the trouble is, the CFOUTPUT I thought would work doesn't: CFOUTPUT query=get_tasks td#tasks.name#/td td#projects.name#/td td#tasks.deadline#/td td#importance.importance#/td td#people.name#/td /CFOUTPUT ...because it doesn't seem to recognise the scopes (Element TASKS.NAME is undefined in TASKS). But I need the scopes because I (perhaps foolishly) have three fields called name! Do I need to make all the field names in my database unique, or is there another way? TIA! CK. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190800 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: CFmail and receiving 1 copy
Why not add a row to the query before the CFMAIL tag? cfscript QueryAddRow(mail_roster,1); QuerySetCell(mail_roster,student,[EMAIL PROTECTED]); /cfscript Downside is, of course, if you use the query result later on your address is added in. On Fri, 14 Jan 2005 07:33:13 -0500, James Watkins [EMAIL PROTECTED] wrote: When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail Jim Watkins Vice President of Technology Institutional Services ~| Purchase Studio MX with Flash Pro from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=51 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190445 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: getPageContext
Yup. http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt1103.htm#4209678 On Tue, 11 Jan 2005 11:17:20 -0500, Ciliotta, Mario [EMAIL PROTECTED] wrote: Hi, Does getPageContext exist in CFMX 6.0? We have not upgrade top MX6.1 yet and I am not sure when we will. Mario ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189923 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Building a SQL WHERE clause
If form.service_population isn't defined, you have an empty WHERE clause. That's probably the root of the issue. I suggest having something in your WHERE clause that's always true but has no bearing on the returned results, like WHERE 0=0 then add the rest of your dynamic clause. On Mon, 10 Jan 2005 13:10:06 -0500, Daniel Kessler [EMAIL PROTECTED] wrote: I'm doing my first Search utility: http://hhp.umd.edu/studentservices/internships.cfm I'm trying to build a WHERE clause in CF where it check to see if a form field is part of a search and if it is, then it builds into the WHERE string. Unfortunatley when I do, I get the error, SQL command doesn't end properly after clicking Search. Here's some of the code: cfif structKeyExists(Form,service_population) OR structKeyExists(Form,agency) OR structKeyExists(Form,city) OR structKeyExists(Form,state) OR structKeyExists(Form,salary_status) cfoutput --- setup a search --- cfset find_text = WHERE cfif structKeyExists(Form,service_population) !--- cfset find_text =WHERE service_population='children'--- cfset find_text =#find_text#service_population='#Form.service_population#' /cfif cfquery name=getSearchItem datasource=dpch SELECT service_population,agency,city,state,salary_status FROM internships #find_text# ORDER BY agency ASC /cfquery /cfoutput cfelse --- setup some presets --- cfset service_population = '' cfset agency = '' cfset city = '' cfset state = '' cfset salary_status = '' /cfif Also, if someone can just point me to a tutorial on this, then that'd be fine. Really, any help would be appreciated. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| 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:189824 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to get file information?
Use CFDIRECTORY with the Filter attribute. Then you'll only get information about your specific file. On Mon, 10 Jan 2005 14:16:56 -0500, Kazmierczak, Kevin [EMAIL PROTECTED] wrote: How would one get information on a file from CF? I want to know when the file was last modified. I know I could use cfdirectory and loop over the directory contents and get it that way but that seems like WAY too much work just to get the date on one file. How come you can't use cffile variables on anything but an upload? Wouldn't it be helpful on all cffile actions? They should have a cffile action=readattribs or something. Is this too much to ask for? Or am I missing something. This is on cf5. I could probably use a java to pull the information on MX, but that isn't an option. Thanks. Kevin. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189830 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to get file information?
I just tested it with CF5 on a desktop-class machine on a directory of ~ 47,000 GIF and JPEG images each between 15k and 30k in size. CFDIRECTORY with a filename in the Filter attribute came back in 120 ms. 20 of that for CFDUMP and 100 for STARTUP, PARSING, SHUTDOWN. Seems pretty quick to me. On Mon, 10 Jan 2005 15:45:15 -0500, Katz, Dov B (IT) [EMAIL PROTECTED] wrote: Are you positive that CFDIRECTORY doesn't list files and apply the filter? One easy way to tell is to do this file check in a directory with 10,000 files. Id' hypothesize that cfdirectory takes significant longer than a java.io.File construction I could be wrong, as this is all speculation. dov -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 2:54 PM To: CF-Talk Subject: RE: How to get file information? Actually, it wouldn't have to iterate cfdirectory action=list name=qGetDir directory=C:\mydir\mysubdir filter=myfile.ext Should just return the single file. - Calvin -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 2:32 PM To: CF-Talk Subject: RE: How to get file information? CFDirectory is probably not that performant, as it has to iterate through the file list to find the file you want. I suggest CFOBJECT type=java name=MyFile class=java.io.File Cfset myFile.init(#expandpath(yourfile...etc)#) Then you have access to all java.io.File's rich method library, such as length(), canRead(), exists(), delete(), isDirectory() etc Not sure about performance tradeoff, but definitely more features doing it this way... -Dov -Original Message- From: Al Everett [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 2:18 PM To: CF-Talk Subject: Re: How to get file information? Use CFDIRECTORY with the Filter attribute. Then you'll only get information about your specific file. On Mon, 10 Jan 2005 14:16:56 -0500, Kazmierczak, Kevin [EMAIL PROTECTED] wrote: How would one get information on a file from CF? I want to know when the file was last modified. I know I could use cfdirectory and loop over the directory contents and get it that way but that seems like WAY too much work just to get the date on one file. How come you can't use cffile variables on anything but an upload? Wouldn't it be helpful on all cffile actions? They should have a cffile action=readattribs or something. Is this too much to ask for? Or am I missing something. This is on cf5. I could probably use a java to pull the information on MX, but that isn't an option. Thanks. Kevin. ~| 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:189842 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamically creating multiple pages/rows of images from a query
I've done something similar in the past. You just have to be strategic with your tr tags. cfquery name=images' datasource=#DSN# SELECT image_name FROM images /cfquery table tr cfoutput query=images tdimg src=#image_name#/td cfif CurrentRow MOD 3 EQ 0 !--- Current row is a multiple of 3, so close it and start another --- /trtr /cfif /cfoutput /tr /table Simple (and untested) but that should give you the idea. On Fri, 7 Jan 2005 12:11:46 -0500, Charles Nahm [EMAIL PROTECTED] wrote: Would like to create a preview page(s) of results froma search function from an image catalog. Displaying 1 image per row seems easy enough, but we would like to display 3 images per row and either 3 or 4 rows per page. Is a loop or multiple loops within a loop the only way to output 3 results per row as well as multiple rows? Or am I approaching this from a wrong-headed point of view. My mind tells me it should be much easier than what I'm thinking, but for the life of me I can't see how. Thanks, Charles Nahm ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189665 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Blog software?
Ditto from me. That's what I use. On Fri, 7 Jan 2005 18:52:26 +, JediHomer [EMAIL PROTECTED] wrote: You could have a look at Ray Camdens Blog... written in CF http://www.camdenfamily.com/morpheus/blog/ ~| 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:189679 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: get first day of month
This should do it. cfset theDay=Now() cfset theFirstOfTheMonth=CreateDate(Year(theDay),Month(theDay),1) First day of #MonthAsString(Month(theDay))# is #DayOfWeekAsString(DayOfWeek(theFirstOfTheMonth))#. On Fri, 07 Jan 2005 20:20:13 -0500, Ray Champagne [EMAIL PROTECTED] wrote: I figure this has already been done by some out there: I need to get the first day of the month as a string when passing in a date. So far, I see that #FirstDayofMonth(date)# will get me the ordinal day of the year (0-366), but how does one extract the day as a string? THX, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~| 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:189708 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFQUERYPARAM issue
--- Jochem van Dieten [EMAIL PROTECTED] wrote: Duncan I Loxton wrote: While I am here - I have read that using cfqueryparam gives a performance gain over not using it - is there any proof or technical data out there? An explanation over why/how it makes a query faster? http://www.google.com/custom?q=cfqueryparam+execution+plansitesearch=houseoffusion.com I try to use queryparams whenever possible, but I have had occassions where using it resulted in a performance degradation using Oracle 9i. No rhyme or reason I can see, but I did have to remove the queryparam to get better performance on the query. YMMV. __ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189502 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: Conditional CC in email
You can nest a CFML tag inside an HTML tag, but not in another CFML tag.
One way:
cfmail to=[EMAIL PROTECTED]
from=The Website
cc=#Iif(IsDefined('IncludeRequestor'),DE(RequestorEmail),DE(''))#
subject=Data Change Request
replyto=[EMAIL PROTECTED]
type=HTML
Blah blah blah
/cfmail
Another way (to me more readable):
cfif IsDefined(IncludeRequestor)
cfset cc=RequestorEmail
cfelse
cfset cc=
/cfif
cfmail to=[EMAIL PROTECTED]
from=The Website
cc=#variables.cc#
subject=Data Change Request
replyto=[EMAIL PROTECTED]
type=HTML
Blah blah blah
/cfmail
--- Claremont, Timothy [EMAIL PROTECTED] wrote:
Currently my email is done like this:
cfmail to=[EMAIL PROTECTED]
from=The Website
subject=Data Change Request
replyto=[EMAIL PROTECTED]
type=HTML
Blah blah blah
/cfmail
What is the elegant way to CC a recipient if the requesting form has a
checkbox that says IncludeRequetor? The following does not seem to be
working:
cfmail to=[EMAIL PROTECTED]
from=The Website
cfif IsDefined
(IncludeRequestor)cc=RequestorEmailcfif
subject=Data Change Request
replyto=[EMAIL PROTECTED]
type=HTML
Blah blah blah
/cfmail
TIA,
Tim
**
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 delete
it from your system.
This footnote also confirms that this email message has been swept for
the presence of computer viruses.
Thank You,
Viahealth
**
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189522
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Creating zip files on the fly without CreateObject
You might want to look into this CFC: http://www.webclarity.com/developers/zip.cfm --- Marco Antonio C. Santos [EMAIL PROTECTED] wrote: how to create zip files on the fly with CF and without use CreateObject statement? CFX_Zip could be an option but your price is proibitive... what you suggest? = -- Al Everett [EMAIL PROTECTED] Madness takes its toll. Please have exact change. __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: List Contains
Looks like you need ListFind(), not ListContains(). ListFind looks at the entire element, while ListContains looks at substrings. cfset myList=21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6 ListFind(myList,7) will return 15 ListContains(myList,7) will return 5 (which is the element 17) --- Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, I'm having problems with lists. I displayed a list of all article titles (and IDs) that could relate to a specific title and the user can select which ones can be links (via a select form). That part is all good and it inserts the comma separated list into the field articleRelatedLinks (something like 37, 76, 84, 99). Then when I would like the user to be able to update the form is when I have the problem. The problem I'm having below is that it only seems to select the first number in the list - it doesn't see it as a list but one field. pArticle Related Linksbr select name=articleRelatedLinks multiple size=4 cfoutput query=showTitles option value=#showTitles.articleID# cfif ListContains(showArticle.articleRelatedLinks, showTitles.articleID)selected/cfif#showTitles.articleTitle#/option /cfoutput /select /p Is there a way I can loop it through the list or am I going around it the wrong way. Any help will be appreciated. Thanks, Saturday. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Undeliverable CFMAIL: code to handle
--- Anders Green [EMAIL PROTECTED] wrote: At 04:33 PM 11/9/2004, Crawford wrote: Anders Green wrote: You've probably got some sitting in there right now. ;) I do. I experimented and tried copying one of the files to the Spool directory (after changing the To: line so that the recipient wouldn't get confused). Nothing happened, though, and that file is still sitting in my Spool directory. On the Win2000 machine here, if I copy them over to spool *poof* they get sent out within a couple minutes. I don't alter anything. Perhaps something within the file (crappy email address?) that's killing the transfer before it can even dump it back in undelivr? If memory serves, there was a bug in CFMX6.0 that moving files from Undelivr to Spool wouldn't cause them to be sent until CF was restarted. There was also something about the files being renamed (and Undelivered being misspelled, too) and the Spooler wouldn't pick up those files until they were renamed to the proper format. I can't find the technote, though. Fixed in 6.1. All works just fine for me with the latest updater. (Works in CF5.0 too, FWIW.) __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183807 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: Undeliverable CFMAIL: code to handle
I always assumed that the current name was just to have a directory name that was 8 characters or less, for compatibility with something ancient. I was speaking to Richard Crawford's message: I'm actually running CF in a Solaris environment. I executed the following command: $ cd Undelvr $ cp Undelievered_Mailx.cfmail ../Spool But that didn't quite do it. I assume that I need to change the filename when I move it to the Spool directory. That's the misspelling I was talking about. Just one of many reasons to get past 6.0 as fast as possible. __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183809 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bluedragon Server
--- Gert Franz [EMAIL PROTECTED] wrote: Well generally you are right, but who allways writes variables.name or something like that. I do. No unscoped variables in my code. __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183508 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: mod command to alter row color
--- Robert Orlini [EMAIL PROTECTED] wrote: How do I have CF alternate color for each row of a table? Anyone have the code please? I wrote a UDF to do just that. http://cflib.org/udf.cfm?ID=901 On of its perks is that you're not limited to two colors. You can put as many into the list of colors as you like. __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183168 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: SQL Query Help Please.
2.) Can someone please suggest a good book on SQL syntax Teach Yourself SQL in 10 Minutes by Ben Forta. ISBN 0-672-32128-9 ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf pop
What's wrong with: cfpop server=mailserv action="" name=qHeaders cfset UIDlist=ValueList(qHeaders.UID) --- Ricardo Russon [EMAIL PROTECTED] wrote: is there any way to make cfpop return only a list of uids? that would speed things up a great deal for me. thanks Ricardo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: .csv import for CFHTTP but not CFFILE?
You could also try the QueryToCsv UDF. http://cflib.org/udf.cfm?ID=556 --- Ryan Emerle [EMAIL PROTECTED] wrote: Check out: http://www.emerle.net/programming/display.cfm/t/cfx_text2query (it's free) CFX_Text2Query works better than other methods because it can handle empty fields and fields with line breaks.. One alternative, using CFHTTP, requires the file to be web-accessible, and cannot handle empty fields OR line breaks. This often results in the Incorrect number of columns in row. error and a lot of headaches. On Wed, 29 Sep 2004 18:56:47 -0400, Anders Green [EMAIL PROTECTED] wrote: Interesting. Seems that CFHTTP can turn a .csv file into a query easily. But CFFILE can't. So I can pull the file from another server and handle it easily, but not when it's on my own machine? Weird. Ok, I guess I could copy the file to the web root, CFHTTP it from myself, then delete it, but that seems a little roundabout. Or, read it in, parse it, etcetera. Certainly doable, but not as oh-look-its-done-already easy. I have to do that anyway for a different file that's certainly NOT csv, and once would be just fine. :) Anyone want to jump in here? Cheers! Anders +===+ |Anders GreenEmail: [EMAIL PROTECTED] | |Home: 919.303.0218| |Off Road Rally Racing Team: http://linaracing.com/ | +===+ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SESSION vs. CLIENT
We're working in a clustered environment (eight servers in one pool, two in several others) on Windows 2000/IIS 5.0 behind a BigIP load balancer with some CF5 and some CFMX. (Very soon to go all CFMX.) We use Session variables extensively to keep track of user's logon information, which has required us to use stick sessions on the load balancer to keep users stuck to a server. However, we've gone through several exercises with certain customers because of the way their proxy servers/firewall block or trap cookies or other issues. I have suggested that if we were to go to Client variables in a database for that information we would remove the need for sticky sessions. The argument against me has always been that a database transaction is too expensive. Back before our database was tuned and we resolved a bunch of network issues I would have agreed, but we're almost guaranteed to have at least one call to the database on every page load right now and the site is fine. (Oracle 9i running on Solaris.) Does anybody have any good statistical and/or anecdotal evidence on whether Sesssion is better or worse than Client variables, specifically in CFMX6.1? ___ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Session swapping
I encountered virtualy the same issue where various PCs were ghosted from an original image. When setting up that image our site had been visited and the CFID and CFTOKEN cookies ended up being part of the image. Explicitly deleting cookies in the client browser fixed it right up. --- Burns, John D [EMAIL PROTECTED] wrote: We have an internet application running on CFMX hosted locally.Our clients (on a Navy base) are running machines that are restricted by NMCI (Navy-Marine Corps Intranet) and they're using a NAT Proxy Server that all of the users are behind.They just recently got moved to this new system and we noticed an odd problem with this application.Two users sitting at separate machines will pull up the website and go to the login page.Once logged in, they will suddenly both be logged in as the same person and the CFID and CFTOKEN in the URL are the same. We're trying to figure out what's causing this problem and how to fix it. We're meeting with the network team in charge of the NAT Proxy but we're all expecting an it's not our problem response.Can anyone give more info on how CF assigns CFID and CFTOKEN and how we might be able to code against this?Any users with experience with NMCI issues would be especially helpful.Thanks for your time. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Trouble with Two Table Query - Doh!
I think this will do what you want: cfquery name=qArticleByIndustry datasource=#DSN# SELECT A.id, A.article_title, A.article_date, I.indus_name FROM Articles A, Industry I WHERE I.industry_id=A.indus_id ORDER BY I.indus_name, A.article_date DESC /cfquery cfoutput query=qArticleByIndustry group=indus_name #indus_name#br cfoutput query=qArticleByIndustry blockquote #article_title# - #DateFormat(article_date,, )#br /blockquote /cfoutput /cfoutput --- Les Mizzell [EMAIL PROTECTED] wrote: Here's a two table query (SQL Server) that's giving me a problem... Table 1: Articles (Couple hundred of these) --- id article_title article_date indus_id (each article is associated with an industry) Table 2: Industry (and there's maybe 60 industries in the table) industry_id indus_name Now, I've got no problem finding the associated articles and industries on an individual basis, but the client wants a single index page of articles grouped by industry, sorted alpha and then by article date like: AUTOMOTIVE article #1 - May, 1994 article #2 - April, 1994 article #3 - March, 1994 HOUSING AND DEVELOPMENT article #1 - Jan, 1994 article #2 - Dec, 1993 MEDICINE article #1 - June, 1993 article #2 - May, 1992 I keep coming up with convoluted ways of maybe doing this, but none seem to work properly. Pointers please? ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Trouble with Two Table Query - Doh!
Don't you mean group rather than query on the inner CFOUTPUT? Maybe. I was doing it off the top of my head. I didn't test it. Actually, it should probably just be a vanilla cfoutput. Oh, and why not use a JOIN rather than doing it in the WHERE? I dislike the JOIN syntax. I'm used to using Oracle and my previous DBA worked that way. __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Brain Fart...GetTemplatePath(), I don't want it *all*
Another alternative: truncatedPath=Replace(GetCurrentTemplatePath,C:\Inetpub\wwwroot\MySite\,) --- Jeff Small [EMAIL PROTECTED] wrote: When I output GetTemplatePath() on my home page, I see: C:\Inetpub\wwwroot\MySite\index.cfm When I'm on the Gallery page, naturally, I see: C:\Inetpub\wwwroot\MySite\Gallery\index.cfm I'd love to be able to trim everything from here: C:\Inetpub\wwwroot\MySite\ and be left with: index.cfm or Gallery\index.cfm Because I'd like to be able to put a little email a friend this page link and just dynamically add the path beyond http://www.MySite.com/ (http://www.MySite.com/Gallery/index.cfm, and http://www.MySite.com/index.cfm) which GetFileFromPath() won't return. It'll just return index.cfm no matter what directory I'm in, naturally. So, does this make sense? I know it's a simple solution that's just escaping me right now. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Null null error ARGHHH!
See: http://www.talkingtree.com/blog/index.cfm?data=""> --- Alisa Thomson [EMAIL PROTECTED] wrote: I am getting the same error except mine is pointing to a CFQUERY.I am running CFMX 6.1 Updater 3 on Solaris with Sybase 12.5 and jConnect 5.5. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
IIS on WinXP Pro
Okay, so I'm getting that IIS 5.1 on WinXP Pro won't support multiple websites, which really puts a damper on my plans to use this extra box for development. What are my options? Can I download a more robust IIS? Should I go with Apache? Here I thought I had it all figured out... __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=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
RE: DWMX Peeves
--- Stacy Young [EMAIL PROTECTED] wrote: I still catch myself hitting CTRL-3 every so often...lol I miss CTRL-M more than anything. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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 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: DLL file not found after hotfix to 4.5.1SP2
I suspect at this point that it has something to do with the strange Spectra implementation they did. I'm pushing them to upgrade to CFMX, at least to CF5, as soon as possible. --- Howie Hamlin [EMAIL PROTECTED] wrote: That file is in my CFusion\Bin\ folder (on a CF5 installation). Not sure why you don't see it there. At any rate, it's not a path problem as the cfserver.exe should be in the same folder and should look there first for the DLL. I'm not sure when that DLL was introduced in ColdFusion (we have a CF4 box and that DLL is not there). HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Al Everett [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 02, 2002 1:45 PM Subject: DLL file not found after hotfix to 4.5.1SP2 I downloaded and attempted to install the hotfix for CF4.5.1ENT that addresses a bug in the Duplicate() function (http://www.macromedia.com/v1/Handlers/index.cfm?ID=19107method=Full). I followed the instructions in the TechNote and now receive the following error when trying to start CFSERVER.EXE: The dynamic link library xerces-c_1_2.dll could not be found in the specified path Suspecting a problem with my PATH, I searched the whole hard drive for that file. No joy. Nor was such an error mentioned in any other TechNotes, either. Does anyone have any leads I might pursue? I'm pretty sure that the code here wouldn't be affected by the specific bug (I don't know of any Arrays containing Structures) but I'd rather apply the fix than hope to hold out until we can manage to upgrade. As always, thanks for your help. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: createdatetime(??)
12 PM (noon) is 12:00 12 AM (midnight) is 00:00 --- Brook Davies [EMAIL PROTECTED] wrote: When using the createdatetime() function, the format must use a 24 hour clock right? I'm a wee bit confused, how do you show 12am and 12pm. Isn't 12AM 24:00 hours?? I get an error when trying to create a 12AM time like this: #createdatetime(2002,8,2,24,00,00)# Any idea why? I'm sure I'm missing something obvious... Brook __ 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: Show debug output (easy slice of cheese to the winner)
--- Todd [EMAIL PROTECTED] wrote: cfdump is your friend. :) That sucks tho... Well, sure, for the various variable scopes. Any way to get to the queries that were run? Short of something like this, I mean: cfquery name=getUser datasource=#DSN# select firstname, lastname, email from tblUsers where UserID = #FORM.ID# and expirationDate = #CreateODBCDateTime(Now())# /cfquery !--- Debugging output --- !-- cfoutput Query: getUser (datasource: #DSN#, ExecutionTime: #getUser.ExecutionTime#, Records: #getUser.RecordCount#) SQL= select firstname, lastname, email from tblUsers where UserID = #FORM.ID# and expirationDate = #CreateODBCDateTime(Now())# cfoutput -- Or is that what I'm going to have to do? __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: Query Result 2 includes down
It has nothing to do with the CFINCLUDEs. I've seen the same behavior when working with a query inside the loop of another query. The solution is to copy the value to a local variable outside of the inner loop, as you've already done. --- Paul Giesenhagen [EMAIL PROTECTED] wrote: After re-reading I need to be more clear ... The first instance of getProduct.id is being used for every loop after the first loop. It it not moving on to the next id value. If I set cfset variables.prodorderid = getProduct.id that works __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: cfexecute?
Could be a file permissions issue. You're logged in when you run the command, but CF is running under the System Account (in the default setup). --- Tony Weeg [EMAIL PROTECTED] wrote: nada. still doesnt work... but, the odd part, is that it works, when i do it from the command line like this cx_run.bat in_123.xml out_123.xml ? tony -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 11:24 PM To: CF-Talk Subject: Re: cfexecute? What about the full path to the two XML files as well? On Thursday, August 1, 2002, at 06:48 , Tony Weeg wrote: tried the full path, to no avail? here is my code. cfexecute name=d:\www\clients\cx_Web~1\xml_123\cx_run.bat arguments= in_123.xml out_123.xml / Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: SQL query driving me nuts
You can't compare to NULLs. How about this: How about NVL on the date setting a value deep into the past (1/1/80 seems reasonable) that will count as never been viewed? --- Steven Duff [EMAIL PROTECTED] wrote: I've been working on this for a couple of days now, and just can't get this to function in one query. Running MSDE from Office XP, so that's SQL Server 2000, Enterprise Manager from the demo, on Win 2K Pro. [big snip] __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: Increments
--- Matthew Walker [EMAIL PROTECTED] wrote: Yes, as you realise IncrementValue() should generally be avoided. Really? I haven't seen this before. What's the rationale? Is it documented somewhere? __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Increments
Yes, as you realise IncrementValue() should generally be avoided. Really? I haven't seen this before. What's the rationale? Is it documented somewhere? It's a depreciated function - it's still there now, but it may not be in future releases Ah! I'm still stuck in CF4.5.1SP2. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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
Deprecated tags and functions
I know I've scanned the list of stuff deprecated in CFMX, but now I can't for the life of me find it. I've been all over macromedia.com. Maybe I need new glasses. Can some kind soul point me to such a list? Just for curiosity's sake, a list of things that were deprecated in CF5 would be good too. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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 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: Increments
thats deprecated :-p OK, so I can't spell today :P Don't sweat it. Considering the recent performance of the stock market, depreciation is weighing heavily on everyone's minds. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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 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: Deprecated tags and functions
Check out the cfdocs folder in the root of your webserver. In the CFML reference under CFML function summary and CFML tag summary I don't have a CFMX installation available to me. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: Deprecated tags and functions
Can you be more specific? I've been looking through livedocs.macromedia.com and can't find it. its in the documentation for CF -Original Message- I know I've scanned the list of stuff deprecated in CFMX, but now I can't for the life of me find it. I've been all over macromedia.com. Maybe I need new glasses. Can some kind soul point me to such a list? Just for curiosity's sake, a list of things that were deprecated in CF5 would be good too. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: Deprecated tags and functions
Looks like I found what I was looking for: http://download.macromedia.com/pub/coldfusion/documentation/cfmx_migrating.pdf Under Migrating ColdFusion 5 Applications specifically CFML Tags and Attributes and CFML Functions and Variables I'd still like to see the same thing for 4.5 to 5. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: Deprecated tags and functions
Exactly what I was looking for. Thanks! (Damn my eyes!) --- Todd [EMAIL PROTECTED] wrote: Tags: http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt03.jsp#2451739 Obsolete Tags: http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt04.jsp#2451949 Functions: http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/functions-pt04.jsp#3477555 At 02:47 PM 8/2/2002 +0100, you wrote: its in the documentation for CF -Original Message- From: Al Everett [mailto:[EMAIL PROTECTED]] Sent: 02 August 2002 14:50 To: CF-Talk Subject: Deprecated tags and functions I know I've scanned the list of stuff deprecated in CFMX, but now I can't for the life of me find it. I've been all over macromedia.com. Maybe I need new glasses. Can some kind soul point me to such a list? Just for curiosity's sake, a list of things that were deprecated in CF5 would be good too. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: Deprecated tags and functions
If you have 5, it should be in the docs Ain't got 5 either. Still running 4.5.1SP2. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: SQL query driving me nuts
My Oracle DBA here suggests this: SELECT Items.ItemID, Items.Name, Items.LastModified, Viewed.UserID, Viewed.LastViewedDate FROM Items LEFT OUTER JOIN Viewed ON Items.ItemID = Viewed.ItemID WHERE Viewed.UserID = 1 and (Viewed.LastViewedDate Items.LastModified or Viewed.LastViewedDate is null ) ORDER BY Items.ItemID (Note it is completely untested) __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
DLL file not found after hotfix to 4.5.1SP2
I downloaded and attempted to install the hotfix for CF4.5.1ENT that addresses a bug in the Duplicate() function (http://www.macromedia.com/v1/Handlers/index.cfm?ID=19107method=Full). I followed the instructions in the TechNote and now receive the following error when trying to start CFSERVER.EXE: The dynamic link library xerces-c_1_2.dll could not be found in the specified path Suspecting a problem with my PATH, I searched the whole hard drive for that file. No joy. Nor was such an error mentioned in any other TechNotes, either. Does anyone have any leads I might pursue? I'm pretty sure that the code here wouldn't be affected by the specific bug (I don't know of any Arrays containing Structures) but I'd rather apply the fix than hope to hold out until we can manage to upgrade. As always, thanks for your help. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CF 5 App crashing every 5 minutes...
We're seeing some similar behavior here at *mumble*. I suspect improper locking of Session variable is at least partly to blame. Lots of stuff like this: cflock scope=session type=readonly timeout=5 cfset request.strLogin = StructCopy(Session.strLogin) /cflock Or even worse: cflock scope=session type=readonly timeout=5 cfset request.strLogin = Session.strLogin /cflock Where strLogin is a structure of structures (of structures). Inexperienced CF Developers and unreasonable deadlines in the early stages of the project have made a bit of a mess. --- Nathaniel Horwitz [EMAIL PROTECTED] wrote: I'd be more inclined to agree with him. At my previous company, we had some problems with increasing memory usage after restarting. It turned out to be our code- the way we were locking (In our case, not locking at all) the session variables. We'd restart the server at least once a day and when we sorted out the locking problems, it was much less than that. Nathaniel -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:21 AM To: CF-Talk Subject: Re: CF 5 App crashing every 5 minutes... That sounds more like freezing than crashing. I'd check all shared-scope variables for locking (ANY use of a shared-scope variable MUST be locked). I also recommend a MM TechNote called Timeouts and Unresponsive Requests. Chris Norloff - Original Message - From: Joel Blanchette [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 10:07 AM Subject: CF 5 App crashing every 5 minutes... Hello All, I need big help.Last night, I saw that our server was going down, then I noticed that it was not the server but more that the cfserver.exe in the task manager was just stopping. If I restart the serveice it is all good. But I need to do this every 5 minutes...Which is not good...So I wrote a batch file that does it for me. I need to know why this error is happening. It seems like when the cfserver.exe gets around 25 megs or memory use it just stops responding. The task is still there but it will not respond. I'm using CF Server 5 on a Windows server 2000 SP2. Is there something in the threads that I should change? I can post the lines of the error logs of CF here but I need to know which ones u would need. I will need help. I did nothing to the server that would just start doing this. We are getting more traffic then before. Would that be the cause? If yes, there must be a way to fix this. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: CF and SQL
Any clue on how I can display a social security... Im having problems if the first digit is a zero How do I format the number so it displays all of the digits??? First of all, you should use a string datatype in your database (VARCHAR, for instance). Second, assuming you're storing the SSN in the format '012345678' this will format it in the way most people are used to: #Left(SSN,3)#-#Mid(SSN,4,2)#-#Right(SSN,4)# __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: CF Studio autocomplete
Try this: http://www.macromedia.com/software/coldfusionstudio/productinfo/resources/tag_updaters/ --- Jon Hall [EMAIL PROTECTED] wrote: Does anyone know which file dictates which tags have closing tags, and which tags display in the autocomplete dropdown as you are typing in Studio 5? I want the MX tags to autocomplete as well... __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: Good CFCatch code
cfdump isn't available on CF 4.5.x. Then create one. Here's the code from my CF_DUMP tag: cfsetting enablecfoutputonly=yes !--- Usage:cf_dump var = ... Attributes: var (var, required) - variable to be dumped --- !--- attributes validation --- cfparam name=attributes.var cfset var = attributes.var cf_IsWddx input=#var# r_output=decodedVar r_bIsWDDX=bIsWddx cfif bIsWddx cfoutput table border=2 cellspacing=0 cellpadding=1 bgcolor=##ff bordercolor=Black trtd valign=top /cfoutput cf_dump var=#decodedVar# cfoutput /td/tr/table /cfoutput cfelseif IsStruct(var) cfoutput table border=1 cellspacing=0 cellpadding=1 bgcolor=##ee bordercolor=Blue /cfoutput !--- dump keys one by one --- cfloop collection=#var# item=keyName cfoutput tr td valign=top#keyName#/td td valign=top bgcolor=##ff /cfoutput cfif IsSimpleValue( var[keyName] ) cfif Left( var[keyName], 11 ) neq wddxPacket cfoutput#var[keyName]#/cfoutput cfelse cf_dump var=#var[keyName]# /cfif cfelse cf_dump var=#var[keyName]# /cfif cfoutput /td /tr /cfoutput /cfloop cfoutput /table /cfoutput cfelseif IsArray(var) cfoutput table border=1 cellspacing=0 cellpadding=1 bgcolor=##cceecc bordercolor=Green /cfoutput cfset size = ArrayLen(var) !--- dump items one by one --- cfloop index=i from=1 to=#size# cfoutput tr td valign=top#i#/td td valign=top bgcolor=##ff /cfoutput cfif IsSimpleValue( var[i] ) cfif Left( var[i], 11 ) neq wddxPacket cfoutput#var[i]#/cfoutput cfelse cf_dump var=#var[i]# /cfif cfelse cf_dump var=#var[i]# /cfif cfoutput /td /tr /cfoutput /cfloop cfoutput /table /cfoutput cfelseif IsQuery(var) cfset colList = var.columnList cfoutput table border=1 cellspacing=0 cellpadding=1 bgcolor=##ee bordercolor=Red tr bgcolor=##ee cfloop list=#colList# index=colName td valign=top#colName#/td /cfloop /tr /cfoutput !--- scroll thru rows --- cfloop query=var cfoutputtr/cfoutput !--- create deep copy of each field --- cfloop list=#colList# index=col cfoutputtd valign=top bgcolor=##ff/cfoutput cfif IsSimpleValue( var[col][currentRow] ) cfif Left( var[col][currentRow], 11 ) neq wddxPacket cfoutput#var[col][currentRow]#/cfoutput cfelse cf_dump var=#var[col][currentRow]# /cfif cfelse cf_dump var=#var[col][currentRow]# /cfif cfoutput/td/cfoutput /cfloop cfoutput/tr/cfoutput /cfloop cfoutput /table /cfoutput cfelse cfoutput#var#/cfoutput /cfif cfsetting enablecfoutputonly=no __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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: Hack Proofing ColdFusion
Borders is now using Amazon.com for their online fulfillment. Here's the paperback at Barnes Noble: http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?isbn=1928994776 Or try Google (http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=Hack+Proofing+ColdFusion+e-bookbtnG=Google+Search) Here's one I found: http://www.syngress.com/catalog/sg_main.cfm?pid=1935 (I left out the several warez sites and the ones that are Amazon.com affiliates) --- Kris Pilles [EMAIL PROTECTED] wrote: I saw it in Borders the other day -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 9:25 AM To: CF-Talk Subject: Hack Proofing ColdFusion Hi folks, Does anybody knows where I can find the e-book version of Hack Proofing ColdFusion (Greg Meyer, Steven Casco, Sarge, Rob Rusher)? I know that I can find it at Amazon.com but I really avoid shopping there (personal problems in the past)... I'm looking for other places but I only found paper edition, not the eletronic one. Thanks!! Alex __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Show debug output (easy slice of cheese to the winner)
Given all that, does anyone have a chunk of code that simulates (some of) the debugging output, specifically the variables in the various scopes and the queries that were run? I've got a little site in a hosted environment and they won't let me within furlong of CF Administrator. (At least, not on the hosting plan I'm using.) --- Mark A. Kruger - CFG [EMAIL PROTECTED] wrote: 2 things, first, you have to enable debug in the CF administrator AND you have to add your IP address to the list of Ips enabled for debugging. You will see the debug info without having to use the cfsetting showdebugoutput=yes setting. Instead, you will use this attribute to turn debugging OFF when you want to see what the page looks like without it. the yes setting is only useful as a placeholder for the tag (so you don't have to keep commenting it out everytime you want to see the debug). -mk -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 3:28 PM To: CF-Talk Subject: Show debug output (easy slice of cheese to the winner) cfsetting showdebugoutput=Yes Put in my application.cfm, the templates do not append the debug info at the end of the templates. What have I missed? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions __ 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: Passing Application Variables between Applications
CF won't allow you to CFINCLUDE application.cfm or the other default templates Errr...are you sure about that? I do cfinclude template=../Application.cfm all the time. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ 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
