Re: Can SQLServer Express do automated jobs unattended?
Ah good thanks Dave. Just what i needed to know. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Mar 4, 2008 at 6:58 PM, Dave Watts [EMAIL PROTECTED] wrote: I will use coldfusion for part of the job, but can the free MS SQLServer Express run jobs unattended, such as run SSIS jobs to a schedule to copy some of the data from the remote database? No, it can't: http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx However, you can use the Windows task scheduler instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| 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:300382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC, OOP I have another acronym for you.. WTF?
On Monday 03 Mar 2008, Greg Morphis wrote: No, no aborts.. and yeah.. it returns something.. Something's wrong because like I said CF stops processing.. Do you have a per-application or server wide exception handler that could be swallowing the error it looks like it must be throwing ? -- Tom Chiverton Helping to authoritatively conquer guinine m-commerce on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Paging in a customtag
Hi All, I've written a customtag to do paging; Basically, I can pass a recordcount in, and it'll output 1, 2, 3, 4, 5, 6, 7, - This works fine; However, I really need it to do this: 1, 2, 3, ... 8, 9 ,10 as the recordsets I'm now dealing with are getting quite big; Any one know how I can do this? Or has anyone come across a code example I can look at? My code is: !---Paging--- cfif thisTag.executionMode is start cfsilent cfscript page=attributes.page; recordsperpage=attributes.recordsperpage; totalpages=Ceiling(attributes.recordcount/recordsperpage); /cfscript cfif page GT totalpagescfset page=totalpagescfelseif page LT 1cfset page=1/cfif cfscript startrow=(page-1)*recordsperpage+1; endrow=startrow+recordsperpage-1; caller.startrow=startrow; caller.endrow=endrow; /cfscript /cfsilent cfif totalpages GT 1 cfoutputdiv class=paging/cfoutput cfif page GT 1 cfoutputa href=#REReplace(attributes.urlroot ? CGI.QUERY_STRING,'page=[0-9]+','','ALL')#amp;page=#page-1# title=Go to previous page class=previouspagelaquo;/a/cfoutput cfelse cfoutputspan class=previouspage inactivelaquo;/span/ cfoutput /cfif cfloop index=i from=1 to=#totalpages# cfif i EQ page cfoutput#i#/cfoutput cfelse cfoutputa href=#REReplace(attributes.urlroot ? CGI.QUERY_STRING,'page=[0-9]+','','ALL')#amp;page=#i# title=Go to page #i# class=number#i#/a/cfoutput /cfif /cfloop cfif page LT totalpages cfoutputa href=#REReplace(attributes.urlroot ? CGI.QUERY_STRING,'page=[0-9]+','','ALL')#amp;page=#page+1# title=Go to next page class=nextpageraquo;/a/cfoutput cfelse cfoutputspan class=nextpage inactiveraquo;/span/cfoutput /cfif cfoutput/div/cfoutput /cfif /cfif Thanks! T ~| 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:300384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: refactoring a page to use paged results and possible impact o n Google rankings
Both possibly. The page is about 200k, so not massive but not small by any means. I've removed some of this by taking out some small gifs, to see if that makes a difference. But I think the main bottleneck is running over the records and outputting them. Rather like a large CFDUMP can slow the page right down. Problem is, they _like_ this page. A lot. So my words just aren't getting through right now. Maybe I'll cc them on the Fusion reactor alerts and see if that changes their minds! Cheers Will -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: 04 March 2008 00:14 To: CF-Talk Subject: Re: refactoring a page to use paged results and possible impact o n Google rankings I'm thinking it's times when the server is under a heavier load that is when I'm getting these slow page alerts (+ 15 seconds in this case). Have you measured what is taking the time? I.e. is it the server serving up the page data or the client downloading the data to the browswer (or both)? If it is a very heavy page for the user to download then screw whatever SEO benefits there might be - the situation is only going to get worse over time and the page is going to be pretty unusable even once loaded (no one wants to scroll down for ever to find what they're looking for). Im preaching to the converted though I'm sure ;) If they're being stubborn, ask them to find competitors' websites / modern popular sites in general that DON'T paginate their indexes. Not very many I expect! Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| 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:300385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Converting a CFSCRIPT function to a CFFUNCTION function
Have a requirement to convert a function written with CFFUNCTION format into CFSCRIPT function format. Is there anything around that can automate this process? ~| 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:300386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting a CFSCRIPT function to a CFFUNCTION function
Have a requirement to convert a function written with CFFUNCTION format into CFSCRIPT function format. Is there anything around that can automate this process? No, but if it's a single function it shouldn't take too long. However, CFSCRIPT doesn't support everything that CFFUNCTION can do. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| 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:300387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Adding Extra Conditions to an INNER JOIN
I am trying to use INNER JOIN for my query and have additional conditions, what is the right way to add them? When I run the code below, I get the error shown. How do I get this to work? SELECT v.Party, SUM(v.Votes), s.ConstituencyNo ,c.ConstituencyName, c.RegionCode FROM VoteResults v INNER JOIN PollingStation s ON v.AgentPhoneNo = s.AgentPhoneNo WHERE v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo GROUP BY v.Party, s.ConstituencyNo, ,c.ConstituencyName, c.RegionCode Error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo'. ~| 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:300388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding Extra Conditions to an INNER JOIN
I am trying to use INNER JOIN for my query and have additional conditions, what is the right way to add them? When I run the code below, I get the error shown. How do I get this to work? SELECT v.Party, SUM(v.Votes), s.ConstituencyNo ,c.ConstituencyName, c.RegionCode FROM VoteResults v INNER JOIN PollingStation s ON v.AgentPhoneNo = s.AgentPhoneNo WHERE v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo GROUP BY v.Party, s.ConstituencyNo, ,c.ConstituencyName, c.RegionCode SELECT ... FROM VoteResults v INNER JOIN PollingStation s ON v.AgentPhoneNo = s.AgentPhoneNo INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo WHERE v.ResultCategory = 'L' AND v.Party = 'NPP' GROUP BY v.Party, ... ORDER BY ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| 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:300389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: refactoring a page to use paged results and possible impact on Google rankings
On Monday 03 Mar 2008, Will Swain wrote: Any ideas on an answer to this? Will the Google ranking be affected? I'm kind of at a loss about this. I can't think of any reason at all why you'd be marked up or down. Many many other sites use paged result sets. -- Tom Chiverton Helping to economically accelerate scalable deliverables on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Advertising CF as a server side technology
Okay. This may look a little strange but I want to Advertise for CF not for money but because it rocks. Infact I want to introduce it to the hospitals and health center plus any application developers in health industry which I work in. Now people mostly use .Net or PHP to develope such applications and I really believe if they use CF they can develope them more easily and faster than now plus with more options and features. I am not a pro or very experienced programmer and I am just an MD with a history of programming and working with CF from version 6. Right now I am working on a library application for my hospital library. I really enjoy working with CF and I hope other discover the same JOY. Now my questions: 1. Please give me your ideas that how I should introduce CF to others. 2. What resources I should list for the programmers as references (Books, Websites, Blogs, Articles, Examples) 3. What will be the future of CF. Many programmers tell me that .Net will be the number one in the future because of Microsoft support. What should I tell them about CF? 4. Compatibilies is another question everybody asks! Is CF compatible with all DBs and all OSes? Is it compatible with other server side technologies and APPs made with them? 5. Security issues. All the developers ask about the security. I always aswer that CF uses Java as its backbone so it has the best security structure than all others. Am I right? 5. Please give me more because I might not be familiar with more ideas and tips I can use to introduce CF here. Thanks Ali ~| 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:300391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC, OOP I have another acronym for you.. WTF?
Naaa.. I mean we do have an error template but it normally fires with errors.. If I misspell something on a .cfm page, it displays all the error info. I've just noticed that when there's something wrong within a CFC it just stops.. For example if I have a cfoutput#session.user.emplid#/cfoutput cfset qGroupsX = application.userGateway.getGroupsForUser(emplid = '0012345') !--- error in here somewhere --- cfdump var=#application# / The output gets displays but no dump.. I have a login page that created the application.userGateway so it could check security because the onApplicationStart in the .cfc doesn't seem to fire before the login (not sure why). Anyways.. I wonder if that was causing the error.. I wrapped it in a cfif structkeyexists(application,userGateway) ... create the application.userGateway /cfif But I want to test... could 2 creates cause the problem? I would really like some better error messages instead of CF just stopping (only happens in errors within the CFC) what it's doing... On Tue, Mar 4, 2008 at 3:31 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 03 Mar 2008, Greg Morphis wrote: No, no aborts.. and yeah.. it returns something.. Something's wrong because like I said CF stops processing.. Do you have a per-application or server wide exception handler that could be swallowing the error it looks like it must be throwing ? -- Tom Chiverton Helping to authoritatively conquer guinine m-commerce on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC, OOP I have another acronym for you.. WTF?
You have of course been deleting and re-creating the APPLICATION.userGateway object after you've been making these changes, right? On Tue, Mar 4, 2008 at 10:59 PM, Greg Morphis [EMAIL PROTECTED] wrote: Naaa.. I mean we do have an error template but it normally fires with errors.. If I misspell something on a .cfm page, it displays all the error info. I've just noticed that when there's something wrong within a CFC it just stops.. For example if I have a cfoutput#session.user.emplid#/cfoutput cfset qGroupsX = application.userGateway.getGroupsForUser(emplid = '0012345') !--- error in here somewhere --- cfdump var=#application# / The output gets displays but no dump.. I have a login page that created the application.userGateway so it could check security because the onApplicationStart in the .cfc doesn't seem to fire before the login (not sure why). Anyways.. I wonder if that was causing the error.. I wrapped it in a cfif structkeyexists(application,userGateway) ... create the application.userGateway /cfif But I want to test... could 2 creates cause the problem? I would really like some better error messages instead of CF just stopping (only happens in errors within the CFC) what it's doing... On Tue, Mar 4, 2008 at 3:31 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 03 Mar 2008, Greg Morphis wrote: No, no aborts.. and yeah.. it returns something.. Something's wrong because like I said CF stops processing.. Do you have a per-application or server wide exception handler that could be swallowing the error it looks like it must be throwing ? -- Tom Chiverton Helping to authoritatively conquer guinine m-commerce on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC, OOP I have another acronym for you.. WTF?
I have the timeout set for 30 seconds for testing... but as I said below, I wonder if created it twice once in the act_login.cfm page and once in the application.cfc file was causing the problems On Tue, Mar 4, 2008 at 8:05 AM, James Holmes [EMAIL PROTECTED] wrote: You have of course been deleting and re-creating the APPLICATION.userGateway object after you've been making these changes, right? On Tue, Mar 4, 2008 at 10:59 PM, Greg Morphis [EMAIL PROTECTED] wrote: Naaa.. I mean we do have an error template but it normally fires with errors.. If I misspell something on a .cfm page, it displays all the error info. I've just noticed that when there's something wrong within a CFC it just stops.. For example if I have a cfoutput#session.user.emplid#/cfoutput cfset qGroupsX = application.userGateway.getGroupsForUser(emplid = '0012345') !--- error in here somewhere --- cfdump var=#application# / The output gets displays but no dump.. I have a login page that created the application.userGateway so it could check security because the onApplicationStart in the .cfc doesn't seem to fire before the login (not sure why). Anyways.. I wonder if that was causing the error.. I wrapped it in a cfif structkeyexists(application,userGateway) ... create the application.userGateway /cfif But I want to test... could 2 creates cause the problem? I would really like some better error messages instead of CF just stopping (only happens in errors within the CFC) what it's doing... On Tue, Mar 4, 2008 at 3:31 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 03 Mar 2008, Greg Morphis wrote: No, no aborts.. and yeah.. it returns something.. Something's wrong because like I said CF stops processing.. Do you have a per-application or server wide exception handler that could be swallowing the error it looks like it must be throwing ? -- Tom Chiverton Helping to authoritatively conquer guinine m-commerce on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300394 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Feature Creep - Wants More Search Stuff ...
It's OK, when they add stuff outside the original site spec, they pay out the nose for it... Search feature on a site - mostly looks for keywords in the body copy from site pages, which is mostly contained in a database. Functionality is mostly a view or two in the database and then queries on the site side. Nothing too complex. Now they're asking - hey, when we see the search results, can we see the specific sentence that contained the keyword and highlight it? Can anybody point me in a direction to pull something like this off? ~| 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:300395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Feature Creep - Wants More Search Stuff ...
Now they're asking - hey, when we see the search results, can we see the specific sentence that contained the keyword and highlight it? CF7 - by the way ~| 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:300396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Feature Creep - Wants More Search Stuff ...
If you were using verity it'd be easy - cfsearch name = search_name collection = collection_name category = category[,category2,...] categoryTree = tree_location status = type = criteria criteria = search_expression maxRows = number startRow = row_number suggestions = suggestion_option contextPassages = number_of_passages contextBytes = number_of_bytes contextHighlightBegin = html_string contextHighlightEnd = html_string previousCriteria = criteria language = language The contexthilightbegin and contexthilightend would do it for you. Hatton On Tue, Mar 4, 2008 at 9:29 AM, Les Mizzell [EMAIL PROTECTED] wrote: Now they're asking - hey, when we see the search results, can we see the specific sentence that contained the keyword and highlight it? CF7 - by the way ~| 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:300397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding Extra Conditions to an INNER JOIN
Change your WHERE to an AND and it should work. Although, in this case, there is no benefit to putting the additional criteria within the INNER JOIN. You may as well just specify a WHERE clause. It does make sense, however, to specify additional criteia in an OUTER JOIN. http://weblogs.sqlteam.com/jeffs/archive/2007/05/14/60205.aspx m!ke -Original Message- From: Fawzi Amadu [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 5:35 AM To: CF-Talk Subject: Adding Extra Conditions to an INNER JOIN I am trying to use INNER JOIN for my query and have additional conditions, what is the right way to add them? When I run the code below, I get the error shown. How do I get this to work? SELECT v.Party, SUM(v.Votes), s.ConstituencyNo ,c.ConstituencyName, c.RegionCode FROM VoteResults v INNER JOIN PollingStation s ON v.AgentPhoneNo = s.AgentPhoneNo WHERE v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo GROUP BY v.Party, s.ConstituencyNo, ,c.ConstituencyName, c.RegionCode Error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo'. ~| 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:300398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adding Extra Conditions to an INNER JOIN
I have to disagree with no benefit. You might be right in terms of performance, but having all the logic together improves readability/maintainability. On Tue, Mar 4, 2008 at 9:44 AM, Dawson, Michael [EMAIL PROTECTED] wrote: Change your WHERE to an AND and it should work. Although, in this case, there is no benefit to putting the additional criteria within the INNER JOIN. You may as well just specify a WHERE clause. It does make sense, however, to specify additional criteia in an OUTER JOIN. http://weblogs.sqlteam.com/jeffs/archive/2007/05/14/60205.aspx m!ke -Original Message- From: Fawzi Amadu [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 5:35 AM To: CF-Talk Subject: Adding Extra Conditions to an INNER JOIN I am trying to use INNER JOIN for my query and have additional conditions, what is the right way to add them? When I run the code below, I get the error shown. How do I get this to work? SELECT v.Party, SUM(v.Votes), s.ConstituencyNo ,c.ConstituencyName, c.RegionCode FROM VoteResults v INNER JOIN PollingStation s ON v.AgentPhoneNo = s.AgentPhoneNo WHERE v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo GROUP BY v.Party, s.ConstituencyNo, ,c.ConstituencyName, c.RegionCode Error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo'. ~| 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:300399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC, OOP I have another acronym for you.. WTF?
On Tuesday 04 Mar 2008, Greg Morphis wrote: I have the timeout set for 30 seconds for testing... but as I said below, I wonder if created it twice once in the act_login.cfm page and once in the application.cfc file was causing the problems It's possible you have a race condition, I suppose, though the lack of a proper error is a pain. FWIW we create all our application scoped CFCs within a named lock. -- Tom Chiverton Helping to centrally industrialize total e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Feature Creep - Wants More Search Stuff ...
Les... There's a highlight string method on cflib. I've used it before. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 8:27 AM To: CF-Talk Subject: Feature Creep - Wants More Search Stuff ... It's OK, when they add stuff outside the original site spec, they pay out the nose for it... Search feature on a site - mostly looks for keywords in the body copy from site pages, which is mostly contained in a database. Functionality is mostly a view or two in the database and then queries on the site side. Nothing too complex. Now they're asking - hey, when we see the search results, can we see the specific sentence that contained the keyword and highlight it? Can anybody point me in a direction to pull something like this off? ~| 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:300401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Feature Creep - Wants More Search Stuff ...
There's a highlight string method on cflib. I've used it before. Found it - I was working on a method to do this by scanning through the string to find the search term and then replacing it with the appropriate CSS highlight style The harder part is - out of a huge SQL text field, containing almost everything on a page, including some HTML tags, how do I get it to display the one sentence down in paragraph 78 containing the search term? This is the part I'm having trouble wrapping my head around. RESULTS 1 blah blah blah blah blah blah blah blah blah blah blah blah *TERM* blah blah blah blah blah ... RESULTS 2 blah blah blah blah *TERM* blah blah blah blah blah ... ~| 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:300402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Feature Creep - Wants More Search Stuff ...
Do they really want the entire sentence containing the term, or would they be satisfied with just highlighting the search term itself? If they'd be okay with that, the method takes care of that for you. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 9:31 AM To: CF-Talk Subject: Re: Feature Creep - Wants More Search Stuff ... There's a highlight string method on cflib. I've used it before. Found it - I was working on a method to do this by scanning through the string to find the search term and then replacing it with the appropriate CSS highlight style The harder part is - out of a huge SQL text field, containing almost everything on a page, including some HTML tags, how do I get it to display the one sentence down in paragraph 78 containing the search term? This is the part I'm having trouble wrapping my head around. RESULTS 1 . blah blah blah blah blah blah blah blah blah blah blah blah *TERM* blah blah blah blah blah ... RESULTS 2 .blah blah blah blah *TERM* blah blah blah blah blah ... ~| 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:300403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 datasource problem
An ODBC connection to a SAGE line-100 accounts database works perfectly well in CF5 but I can't get it to work at all in CF8 on the same server. (Win2k3 R2 sp2) In CF8, it shows OK in the status column of the Data sources page, also when I 'verify' it, but when I run a query from a page which works OK in CF5: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed. SQLSTATE HY000 SQLSELECT ACCOUNT_NUMBER, ACCOUNT_NAME, THIS_RECORD, PARENT_RECORD FROM SALES_LEDGER VENDORERRORCODE 2217 DATASOURCE SAGE_NMCDATA Additionally, when I get this error, on the server I get a Visual studio Just-in-Time Debugger window popping up with the message: An unhandled exception occurred in swsoc.exe [6138] Has anyone any ideas? Thanks Richard ~| 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:300404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Macromedia 'Certified Professional' Pin
You know the one you get when you get CF certified. Does or has anyone wore them to the office? ~| 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:300405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SPAM: Macromedia 'Certified Professional' Pin
I didn't get a pin...I just got a certificate. Maybe you scored higher than I did? :) -Original Message- From: Don [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 9:30 AM To: CF-Talk Subject: SPAM: Macromedia 'Certified Professional' Pin You know the one you get when you get CF certified. Does or has anyone wore them to the office? ~| 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:300406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Macromedia 'Certified Professional' Pin
You got a pin? Man, I feel gypped...;) Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Don wrote: You know the one you get when you get CF certified. Does or has anyone wore them to the office? ~| 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:300407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC, OOP I have another acronym for you.. WTF?
Are you sure it isn't due to the data type specified in the cfqueryparam? It looks like your ID has leading zeros which would make it a character string rather than numeric... On Tue, Mar 4, 2008 at 10:15 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 04 Mar 2008, Greg Morphis wrote: I have the timeout set for 30 seconds for testing... but as I said below, I wonder if created it twice once in the act_login.cfm page and once in the application.cfc file was causing the problems It's possible you have a race condition, I suppose, though the lack of a proper error is a pain. FWIW we create all our application scoped CFCs within a named lock. -- Tom Chiverton Helping to centrally industrialize total e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Feature Creep - Wants More Search Stuff ...
Andy Matthews wrote: Do they really want the entire sentence containing the term, or would they be satisfied with just highlighting the search term itself? If they'd be okay with that, the method takes care of that for you. A list of results is returned - with the title/link of the practice/attorney (this is a law firm) that returned positive for the search. You get the first X number of characters off the page in question and a link to go to that page. From there you can click the link and go to the full page. Highlighting the search term there isn't that big of a deal, using the highlight string method. Something like (psuedo code) cfoutput query=searchresults h3a href=#pageLINK##Attorney_Name#/a/h3 p#right(bodyCOPY, 150)#/p /cfoutput Instead of the first 150 number of characters from the bodyCOPY field, they'd like to see X number of characters on either side of the specific sentence from the bodyCOPY field that contains the search term. ~| 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:300409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SPAM: Macromedia 'Certified Professional' Pin
I think I got a pin for the CF6 exam but I definately didn't get one for CF7. Would I wear it to the office? Hell no. Would I ever wear it? Hell no :) On 04/03/2008, Andy Matthews [EMAIL PROTECTED] wrote: I didn't get a pin...I just got a certificate. Maybe you scored higher than I did? :) -Original Message- From: Don [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 9:30 AM To: CF-Talk Subject: SPAM: Macromedia 'Certified Professional' Pin You know the one you get when you get CF certified. Does or has anyone wore them to the office? ~| 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:300410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SPAM: Macromedia 'Certified Professional' Pin
Could also be that they dont give them out anymore. I didn't get a pin...I just got a certificate. Maybe you scored higher than I did? :) You know the one you get when you get CF certified. Does or has anyone wore them to the office? ~| 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:300411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Macromedia 'Certified Professional' Pin
Yah, back in the day of CFMX6 Certification you got a pin. I wore mine today for the first time. lol =) You got a pin? Man, I feel gypped...;) Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Don wrote: You know the one you get when you get CF certified. Does or has anyone wore them to the office? ~| 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:300412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Macromedia 'Certified Professional' Pin
When I passed the test right before the merger I did'nt get a pin... Until I emailed and asked for one. The person in charge of the certification process then sent me a really nice email and told me they only had 1 left and they sent it to me. So supposedly, I got the last one. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:300413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SPAM: Macromedia 'Certified Professional' Pin
Sounds about right. I got one for being a MX6 Advanced Developer. I wore it the day we got it, as a gag, but then it went in a drawer. It's probably in a box somewhere in my apt. --Ben Doom Andy Allan wrote: I think I got a pin for the CF6 exam but I definately didn't get one for CF7. Would I wear it to the office? Hell no. Would I ever wear it? Hell no :) On 04/03/2008, Andy Matthews [EMAIL PROTECTED] wrote: I didn't get a pin...I just got a certificate. Maybe you scored higher than I did? :) -Original Message- From: Don [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 9:30 AM To: CF-Talk Subject: SPAM: Macromedia 'Certified Professional' Pin You know the one you get when you get CF certified. Does or has anyone wore them to the office? ~| 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:300414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Feature Creep - Wants More Search Stuff ...
If you want to take a look at Lucene, I believe they have a highlighter that you might be able to use if you want more accurate things. Russ -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 10:35 AM To: CF-Talk Subject: RE: Feature Creep - Wants More Search Stuff ... Do they really want the entire sentence containing the term, or would they be satisfied with just highlighting the search term itself? If they'd be okay with that, the method takes care of that for you. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 9:31 AM To: CF-Talk Subject: Re: Feature Creep - Wants More Search Stuff ... There's a highlight string method on cflib. I've used it before. Found it - I was working on a method to do this by scanning through the string to find the search term and then replacing it with the appropriate CSS highlight style The harder part is - out of a huge SQL text field, containing almost everything on a page, including some HTML tags, how do I get it to display the one sentence down in paragraph 78 containing the search term? This is the part I'm having trouble wrapping my head around. RESULTS 1 . blah blah blah blah blah blah blah blah blah blah blah blah *TERM* blah blah blah blah blah ... RESULTS 2 .blah blah blah blah *TERM* blah blah blah blah blah ... ~| 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:300415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need query help
If you query is highly dynamic, this way may not be best. Let's say the user can specify groups that are of type college, jewish, preschool, catholic, and skinny. Now, you have to join to the type table 5 times and that ain't looking too good. ~Brad -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2008 6:27 PM To: CF-Talk Subject: Re: Need query help No, that'll get one or the other - he wants ones that are both. Aliasing will work, something like this: James, I think I got this to work. My first tests are good. I didn't mention this is a highly dynamic query. I have quite a few other filters in play, but your example would work nicely with it. Thanks much! Will ~| 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:300416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC, OOP I have another acronym for you.. WTF?
Yea its a varchar field in the database. That part is correct On 3/4/08, Sonny Savage [EMAIL PROTECTED] wrote: Are you sure it isn't due to the data type specified in the cfqueryparam? It looks like your ID has leading zeros which would make it a character string rather than numeric... On Tue, Mar 4, 2008 at 10:15 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 04 Mar 2008, Greg Morphis wrote: I have the timeout set for 30 seconds for testing... but as I said below, I wonder if created it twice once in the act_login.cfm page and once in the application.cfc file was causing the problems It's possible you have a race condition, I suppose, though the lack of a proper error is a pain. FWIW we create all our application scoped CFCs within a named lock. -- Tom Chiverton Helping to centrally industrialize total e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need query help
Could do a UNION to gather the results -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 10:56 AM To: CF-Talk Subject: RE: Need query help If you query is highly dynamic, this way may not be best. Let's say the user can specify groups that are of type college, jewish, preschool, catholic, and skinny. Now, you have to join to the type table 5 times and that ain't looking too good. ~Brad -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2008 6:27 PM To: CF-Talk Subject: Re: Need query help No, that'll get one or the other - he wants ones that are both. Aliasing will work, something like this: James, I think I got this to work. My first tests are good. I didn't mention this is a highly dynamic query. I have quite a few other filters in play, but your example would work nicely with it. Thanks much! Will ~| 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:300417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Feature Creep - Wants More Search Stuff ...
On Tuesday 04 Mar 2008, Les Mizzell wrote: cfoutput query=searchresults h3a href=#pageLINK##Attorney_Name#/a/h3 p#right(bodyCOPY, 150)#/p /cfoutput Instead of the first 150 number of characters from the bodyCOPY field, they'd like to see X number of characters on either side of the specific refind() should return you the offset of the match, so then use mid to return pos-50 to pos+50 characters. Optionally scan forwards and back to the next space char. -- Tom Chiverton Helping to authoritatively strategize visionary eyeballs on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Macromedia 'Certified Professional' Pin
HAHA! I guess thats like when a significant other tells you that you were the best! =] On Tue, Mar 4, 2008 at 9:21 AM, Adrian Lynch [EMAIL PROTECTED] wrote: They told me the same thing! :Oo Just kidding :OD Anyone know when the CF8 one is available? I can never find anything about the exams on the site. Heck, where are the lists of people who have passed? I always end up Googling it. Adrian -Original Message- From: Alan Rother Sent: 04 March 2008 15:48 To: CF-Talk Subject: Re: Macromedia 'Certified Professional' Pin When I passed the test right before the merger I did'nt get a pin... Until I emailed and asked for one. The person in charge of the certification process then sent me a really nice email and told me they only had 1 left and they sent it to me. So supposedly, I got the last one. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:300423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need query help
What would that look like? Unioned result sets are not mutually dependant, but Will needs all his criteria to be met. ~Brad -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 10:00 AM To: CF-Talk Subject: RE: Need query help Could do a UNION to gather the results ~| 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:300419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Macromedia 'Certified Professional' Pin
They told me the same thing! :Oo Just kidding :OD Anyone know when the CF8 one is available? I can never find anything about the exams on the site. Heck, where are the lists of people who have passed? I always end up Googling it. Adrian -Original Message- From: Alan Rother Sent: 04 March 2008 15:48 To: CF-Talk Subject: Re: Macromedia 'Certified Professional' Pin When I passed the test right before the merger I did'nt get a pin... Until I emailed and asked for one. The person in charge of the certification process then sent me a really nice email and told me they only had 1 left and they sent it to me. So supposedly, I got the last one. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:300422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 datasource problem
On Tuesday 04 Mar 2008, Richard Meredith-Hardy wrote: An ODBC connection to a SAGE line-100 accounts database works perfectly What database ? Sage's own one ? VENDORERRORCODE 2217 What does this code mean ? Additionally, when I get this error, on the server I get a Visual studio Just-in-Time Debugger window popping up with the message: An unhandled exception occurred in swsoc.exe [6138] What's that .exe ? Why is Studio running/installed ? -- Tom Chiverton Helping to quickly benchmark scalable applications on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Macromedia 'Certified Professional' Pin
But she means it... doesn't she? :O. -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: 04 March 2008 16:29 To: CF-Talk Subject: Re: Macromedia 'Certified Professional' Pin HAHA! I guess thats like when a significant other tells you that you were the best! =] On Tue, Mar 4, 2008 at 9:21 AM, Adrian Lynch [EMAIL PROTECTED] wrote: They told me the same thing! :Oo Just kidding :OD Anyone know when the CF8 one is available? I can never find anything about the exams on the site. Heck, where are the lists of people who have passed? I always end up Googling it. Adrian -Original Message- From: Alan Rother Sent: 04 March 2008 15:48 To: CF-Talk Subject: Re: Macromedia 'Certified Professional' Pin When I passed the test right before the merger I did'nt get a pin... Until I emailed and asked for one. The person in charge of the certification process then sent me a really nice email and told me they only had 1 left and they sent it to me. So supposedly, I got the last one. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:300424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Macromedia 'Certified Professional' Pin
BLAAHHAHAAHHAHAHHAA - I guess thats like when a significant other tells you that you were the best! =] On Tue, Mar 4, 2008 at 9:21 AM, Adrian Lynch [EMAIL PROTECTED] wrote: ~| 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:300425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Macromedia 'Certified Professional' Pin
I'm an ACI and as yet I haven't heard anything about the CF8 stuff... to be honest, we'll probably find out the day after they are released :) On 04/03/2008, Adrian Lynch [EMAIL PROTECTED] wrote: They told me the same thing! :Oo Just kidding :OD Anyone know when the CF8 one is available? I can never find anything about the exams on the site. Heck, where are the lists of people who have passed? I always end up Googling it. Adrian -Original Message- From: Alan Rother Sent: 04 March 2008 15:48 To: CF-Talk Subject: Re: Macromedia 'Certified Professional' Pin When I passed the test right before the merger I did'nt get a pin... Until I emailed and asked for one. The person in charge of the certification process then sent me a really nice email and told me they only had 1 left and they sent it to me. So supposedly, I got the last one. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:300426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8 datasource problem
Tom See below -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: 04 March 2008 16:23 To: CF-Talk Subject: Re: CF8 datasource problem On Tuesday 04 Mar 2008, Richard Meredith-Hardy wrote: An ODBC connection to a SAGE line-100 accounts database works perfectly What database ? Sage's own one ? I believe so, yes. Unfortunately if you do a search on SAGE line 100 and ODBC and 'flaky' or 'unreliable' you get a suprising lot of answers for what is supposed to be 'Britain's No. 1 accounts software'. Also, rather unfortunately I have no option (apart from my efforts to pursuade my client to upgrade his accounts system to something a bit more modern). It does seem to be a bit of a dead-end this one, one hint I found is that the sage ODBC driver isn't ODBC 3 compliant which may explain why it works in CF5 but not CF8 Nevertheless, I was hoping someone might have found a solution. If not, then I'll have to keep CF5 going, doing regular loads into an intermediate mssql db. Not ideal, but workable. VENDORERRORCODE 2217 What does this code mean ? I've absolutely no idea. SAGE charge £1500 for the SDK. Additionally, when I get this error, on the server I get a Visual studio Just-in-Time Debugger window popping up with the message: An unhandled exception occurred in swsoc.exe [6138] What's that .exe ? Why is Studio running/installed ? swsoc.exe is a process associated with the Cold Fusion server from Macromedia Studio: I don't really know, something to do with MSSQL server perhaps? This is my dev box, the 'Business intelligence development studio' is all part of the studio empire isn't it? -- Tom Chiverton Helping to quickly benchmark scalable applications on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need query help
This should work and is much clearer that your original statement. SELECT t.groupid, t.groupimage, t.groupname, t.groupcity, t.state, t.voicingid, t.groupcontactperson, t.country, t.region, x.groupid, x.grouptype, gt.grouptype FROMtblgroups t, INNER JOIN tblgrouptypes gt ON gt.groupid = t.groupid, INNER JOIN tblgrouptypes_x x ON x.grouptype = gt.grouptype WHERE (gt.grouptype = 'College' AND gt.grouptype = 'Jewish') ORDER BY t.groupsortname ~| 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:300428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need query help
How could a value be equal to two things at once? Your where clause requires that the gt.grouptype column simultaneously equal 'College' and 'Jewish'. That query will return no results. ~Brad -Original Message- From: Nicholas Stein [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 10:50 AM To: CF-Talk Subject: Re: Need query help This should work and is much clearer that your original statement. SELECT t.groupid, t.groupimage, t.groupname, t.groupcity, t.state, t.voicingid, t.groupcontactperson, t.country, t.region, x.groupid, x.grouptype, gt.grouptype FROMtblgroups t, INNER JOIN tblgrouptypes gt ON gt.groupid = t.groupid, INNER JOIN tblgrouptypes_x x ON x.grouptype = gt.grouptype WHERE (gt.grouptype = 'College' AND gt.grouptype = 'Jewish') ORDER BY t.groupsortname ~| 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:300429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
IVR / Faxback solutions
I am hoping that maybe someone on here has some experience with this and can point me in the right direction. I am working on setting up a system where a doctor's office would call an IVR system, put in a bit of information on a patient and get the eligibility and information faxed back to them. I have a dedicated windows 2003 server with CF and SQL 2000 that has all the information I need, but I don't have a lot of experience with IVR or faxing solutions. So I am hoping someone on here may have done something similar or maybe can point me in the right direction. In order to save money, we would like to be able to build as much of this ourselves if possible. Whether or not that is possible, I dont really know. I am guessing we would need to purchase the IVR software, but if we could do the actual faxing from ColdFusion, that would be great. Thanks, Dan ~| 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:300430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strange Error from SQL
In this case I believe it's the FusionReactor wrapper drivers. Steve -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2008 4:39 PM To: CF-Talk Subject: RE: Strange Error from SQL Anyone seen an error like this before? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Unhandled token type: Unknown token: 0x30 The error occurred on line 154. It has been coming up on my server lately. It is usually followed by a few null null errors. Some times the token changes, but not often. I've also seen token: 0x0c Google had nothing on this. As far as I can tell this is a driver bug. In that the SQL Server response is unrecognised by the driver and the error is thrown. http://support.microsoft.com/kb/827969 What SQL drivers are you using? MS or the CF in built ones? Are they the latest, greatest versions? Paul ~| 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:300431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need query help
Brad Wood wrote: If you query is highly dynamic, this way may not be best. Let's say the user can specify groups that are of type college, jewish, preschool, catholic, and skinny. Now, you have to join to the type table 5 times and that ain't looking too good. Joining is what databases are good at. Only I would rewrite the query a bit to only have one repeating part and keep it readable: cfset grouptypes = 'college,jewish,preschool,catholic,skinny' cfset i = 1 cfquery SELECT x.* FROM ( SELECT * FROM table WHERE table.y = cfqueryparam value=#ListFirst(grouptypes)# ) x cfloop list=#ListRest(grouptypes)# index=currentType cfset i++ INNER JOIN ( SELECT id FROM table WHERE table.y = cfqueryparam value=#currentType# ) y#i# ON x.id = y#i#.id /cfloop /cfquery Jochem ~| 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:300433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IVR / Faxback solutions
I don't know much about the IVR system you are talking about, but I have used eFax fairly effectively for sending Faxes from ColdFusion. They make it crazy simple. All you do is send a specific email address an email, with an attachment (the document you want to send as a fax) from a specific email address and it just faxes it out. Now there is a per fax charge when you send a FAX and that charge is based on where the FAX is going to. There are also network FAX devices out there that have accessible API's that allow you to send faxes locally using your own phone lines if the per fax charges may become an issue. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:300432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need query help
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2008 12:12 PM
To: CF-Talk
Subject: Re: Need query help
Joining is what databases are good at.
===
Flying is what birds are good at; but why send the whole flock when one
carrier pigeon will do? If there are hundreds of group types, why on
earth would you force your database to join the type table that many
times?
Will the solution work? Yes.
Is it simple and scalable? Not necessarily.
I have already suggested a solution (which no one seems that interested
in exploring) which would meet Will's requirements. It only requires a
single join to the type table and a group by regardless of how many
types there are.
Here is a working (and simplified) example which runs on MS SQL server.
declare @tblgroups table
( groupid int,
groupname varchar(50))
declare @tblgrouptypes table
( groupid int,
grouptype varchar(50))
insert into @tblgroups
(groupid, groupname)
select 1, 'group 1'
union select 2, 'group 2'
union select 3, 'group 3'
union select 4, 'group 4'
union select 5, 'group 5'
insert into @tblgrouptypes
(groupid, grouptype)
select 1, 'Jewish'
union select 1, 'Brave'
union select 2, 'Jewish'
union select 2, 'College'
union select 3, 'College'
union select 3, 'Young'
union select 3, 'Old'
union select 4, 'College'
union select 4, 'Young'
union select 5, 'Jewish'
union select 5, 'Old'
union select 5, 'College'
SELECT t.groupid,
t.groupname
FROM@tblgroups t
INNER JOIN @tblgrouptypes gt ON gt.groupid = t.groupid
WHERE gt.grouptype in ('College','Jewish') -- This would be dynamic
GROUP BY t.groupid,
t.groupname
HAVING count(*) = 2 -- This would be dynamic
ORDER BY t.groupname
~Brad
~|
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:300434
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need full path file browser
In my ColdFusion application, I need to be able to browse the client file system, choose a file, and extract the full path file name the user selected so I can store it in a database. I have played around with input type=file but I don't need to UPLOAD any files. I just want the full path. Later on, I will want to display the full path file. Is this possible? I have read that because of security, web applications can't access client files. Are there any solutions other than storing the files on the web server? Thank You, Becky McDermott ~| 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:300435 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFGRID ajax loading icon
I know this hack, I was wondering if there is a way to customize it through code. You can replace the loading.gif image in cfide/scripts/ajax/resources/cf/images with any image you like. Asim, If you want to change the default CF loading HTML (including the loading.gif icon), just add the following to your page after the head tag, replacing the HTML values with whatever you want: script type=text/javascript // Change cf's AJAX loading HTML _cf_loadingtexthtml=divimg src='/CFIDE/scripts/ajax/resources/cf/images/loading.gif'/; /script -Eric Pfleckl ~| 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:300436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: VPN and 2 NICs
Hey All, I'm trying to setup a Win 2k3 server (standard) in the following way: Connect 1 NIC to a Cisco VPN and keep the other NIC free for local LAN access. A few things: 1) I know this is doable, but don't know how in Windows. I currently use Linux and have setup alternate routes for the VPN using a single NIC...works great! 2) Yes I understand the security implications...no speeches required...but thanks for thinking of me ;-) 3) I really need click this and enter this kind of instructions. Although I'm quite technically competent, networking hurts my brain ;-) I've had too many other explanations that assume I know certain things...and I don't. Thanks in advance for any help Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| 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:300437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: VPN and 2 NICs
For my work I use a VPN client from Netscreen, Netscreen-Remote. It seems to do routing as you describe using only one NIC. If I go to a web site outside the VPN (ie Google) it doesn't route that traffic through the VPN. From my experience the VPN client built into Windows XP pushes everything through the connection once connected. The point of my message is that you'll probably have to get a third-party client to get more advanced routing capabilities. On Tue, Mar 4, 2008 at 2:36 PM, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, I'm trying to setup a Win 2k3 server (standard) in the following way: Connect 1 NIC to a Cisco VPN and keep the other NIC free for local LAN access. A few things: 1) I know this is doable, but don't know how in Windows. I currently use Linux and have setup alternate routes for the VPN using a single NIC...works great! 2) Yes I understand the security implications...no speeches required...but thanks for thinking of me ;-) 3) I really need click this and enter this kind of instructions. Although I'm quite technically competent, networking hurts my brain ;-) I've had too many other explanations that assume I know certain things...and I don't. Thanks in advance for any help Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| 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:300438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need full path file browser
Is this possible? With cross compatible code, the answer is no. If you use Explorer, you will have to make some ActiveX component to do so. provided the use will accept to load it. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:300439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need full path file browser
I don't know if it will be cross browser compatible, but you should be able to do it in IE without an active x control. Put a hidden field in the form. Onchange of the file field, copy the value of it (the full path) into the hidden field. Onsumbit of the form, don't actually submit the form, but send the value of the hidden field as an Ajax call, or copy it over to a second form on the page which doesn't have the file field. I haven't done exactly that, but I believe it should be possible and wouldn't require any applet or active x control. ~Brad -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 1:51 PM To: CF-Talk Subject: Re: Need full path file browser Is this possible? With cross compatible code, the answer is no. If you use Explorer, you will have to make some ActiveX component to do so. provided the use will accept to load 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:300440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need full path file browser
Becky McDermott wrote: I have read that because of security, web applications can't access client files. Are there any solutions other than storing the files on the web server? And you have read correctly. Just take a moment to imagine the havoc if I could write a web application that could root around your file system for any interesting sounding files every time you visited my popular web site? IF the client and server are on the same well defined, internal network. IF your organization is willing to open the client's file system to inspection by users of the network domain. IF you configure your ColdFusion to run as a user of the domain with the required permissions to see the client machine and its file system. You can use cfdirectory... and cffile... tags with UNC paths to access network resources outside of the server's system. I.E. cfdirectory name=clientSpy direcory=\\clientName\c$\windows\system32\ Hmmm I wonder what I could find there? ~| 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:300441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: VPN and 2 NICs
Thanks Sonny, Well I know there is a relatively easy way of setting this upjust having difficulty finding the docs. I bet all the advanced clients do is alter the routing tables. I think all I need to know is WHAT those routing tables should look like. I've done this in Linux with a single NIC, so 2 NICs should be easier ;-) I'll still check out NetscreenI'm all for simple solutions! Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Tue, 2008-03-04 at 14:44 -0500, Sonny Savage wrote: For my work I use a VPN client from Netscreen, Netscreen-Remote. It seems to do routing as you describe using only one NIC. If I go to a web site outside the VPN (ie Google) it doesn't route that traffic through the VPN. From my experience the VPN client built into Windows XP pushes everything through the connection once connected. The point of my message is that you'll probably have to get a third-party client to get more advanced routing capabilities. On Tue, Mar 4, 2008 at 2:36 PM, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, I'm trying to setup a Win 2k3 server (standard) in the following way: Connect 1 NIC to a Cisco VPN and keep the other NIC free for local LAN access. A few things: 1) I know this is doable, but don't know how in Windows. I currently use Linux and have setup alternate routes for the VPN using a single NIC...works great! 2) Yes I understand the security implications...no speeches required...but thanks for thinking of me ;-) 3) I really need click this and enter this kind of instructions. Although I'm quite technically competent, networking hurts my brain ;-) I've had too many other explanations that assume I know certain things...and I don't. Thanks in advance for any help Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| 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:300442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: VPN and 2 NICs
BTWyou may simply be connecting to a VPN conncentrator that allows split tunnelling (VPN traffic through VPN network's firewallall other traffic takes your regular route through you're own router/firewall). For me...the split tunnelling option is turned off - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Tue, 2008-03-04 at 14:44 -0500, Sonny Savage wrote: Netscreen-Remote ~| 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:300443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adding Extra Conditions to an INNER JOIN
Replace your Where with an AND/OR The where clause must be used after any inner joins SELECT v.Party, SUM(v.Votes), s.ConstituencyNo ,c.ConstituencyName, c. RegionCode FROM VoteResults v INNER JOIN PollingStation s --- ON v.AgentPhoneNo = s.AgentPhoneNo AND v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo - GROUP BY v.Party, s.ConstituencyNo, ,c.ConstituencyName, c.RegionCode I am trying to use INNER JOIN for my query and have additional conditions, what is the right way to add them? When I run the code below, I get the error shown. How do I get this to work? SELECT v.Party, SUM(v.Votes), s.ConstituencyNo ,c.ConstituencyName, c. RegionCode FROM VoteResults v INNER JOIN PollingStation s ON v.AgentPhoneNo = s.AgentPhoneNo WHERE v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo GROUP BY v.Party, s.ConstituencyNo, ,c.ConstituencyName, c.RegionCode Error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'v.ResultCategory = 'L' AND v.Party = 'NPP' INNER JOIN Constituency c ON c.ConstituencyNo = s.ConstituencyNo'. ~| 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:300444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TIGER/Line
I've been doing PHP for close to a decade and would be happy to help if you could provide the full error message. !k -Original Message- From: Graham Pearson [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2008 7:15 AM To: CF-Talk Subject: Re: TIGER/Line -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The Blog entry that I am trying to follow is located http://blog.tooleshed.com/?p=16. My ultimate goal is to duplicate this under Coldfusion. Right now I have the 2006 Second Edition 3 GB of Tiger/Line Data downloaded from the Census Bureau and will be importing the data into MySQL this weekend. ~From the Blog entry I have recreated the php files for a working copy before I work on rewriting it for Coldfusion but in the geocode.php file I am getting an error in function calc_position with the line that reads: for ($i=0; $i What all of this Data and PHP Scripts do is take a US Address and Calculates the Latitude/Longitude so a person can utilize this information. This would be one section of my newest project for K-12 School Corporations and Local Businesses however until March 14th I am not going to release any details. Ian Skinner wrote: | Graham Pearson wrote: | -BEGIN PGP SIGNED MESSAGE- | Hash: SHA1 | | Has anyone worked with the TIGER/Line Data in Coldfusion. | No I have not but I would love to ease drop on the conversation. You | may get slightly broader help if you just bring up what the actual PHP | code does that you can't do in ColdFusion. Somebody who has no idea | about TIGER data may still be able to help you translate the PHP. | | | | ~| 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:300445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: TIGER/Line
You just might want to make this easier on yourself and check this out: http://developer.yahoo.com/maps/rest/V1/geocode.html Why hold that much data in your DB when someone else is willing to do it for you? !k -Original Message- From: Graham Pearson [mailto:[EMAIL PROTECTED] Sent: Friday, February 29, 2008 1:57 PM To: CF-Talk Subject: TIGER/Line -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Has anyone worked with the TIGER/Line Data in Coldfusion. I am trying to convert a PHP script over to Coldfusion to utilize this data and running into some problems and would like to chat about it. I would like to create my own Web Service utilizing this instead of Screen Scaping the information from the USPS and geocoder.us websites. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.8 (MingW32) Comment: GnuPT 2.6.2.1 by EQUIPMENTE.DE Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHyGOm3GqPAgBSy90RAlcNAJ9GiFzpx6Tb0r510xeL7vBFB9eLQwCfYUOH 0qtggUV3jFL7dt8luOgbwhs= =Z3ho -END PGP SIGNATURE- ~| 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:300446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: VPN and 2 NICs
I've noticed it by looking at the traffic of the two connections in the task manager. I did find what looks like good detail on what you want to do: http://www.windowsnetworking.com/articles_tutorials/w2kprout.html On Tue, Mar 4, 2008 at 3:14 PM, Bryan Stevenson [EMAIL PROTECTED] wrote: BTWyou may simply be connecting to a VPN conncentrator that allows split tunnelling (VPN traffic through VPN network's firewallall other traffic takes your regular route through you're own router/firewall). For me...the split tunnelling option is turned off - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Tue, 2008-03-04 at 14:44 -0500, Sonny Savage wrote: Netscreen-Remote ~| 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:300447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: VPN and 2 NICs
Thanks for the link ;-) - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| 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:300448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SFTP
Hello List, I have an ftp server I'm using WinSCP to connect to. I have a ppk file and I can move it from one computer to another and connect via WinSCP with no issue. I'd very much like to use coldfusion to somehow connect to this server via what I believe to be key authentication and upload files. I've tried cfsftp, and I looked at the coldfusion 8 secure ftp, but it seems to only support password authentication, not key. I tried using the ppk file in cfsftp tag which uses jsch, but I get this error: CFSFTP.connect;invaid privatekey: c:\id_dsa.ppk, but I know that key works just fine when WinSCP connects. Anyone got this figured out? Regards, Dan ~| 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:300449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Microsoft Live Office
Has anyone tried that? And what's your experience with it? Thanks. ~| 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:300450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cffile read charset Shift_JIS
Using CF MX6 on both dev and prod, moving from a development server to production ran into problem. On development server, cffile action=read charset=Shift_JIS file=myfilePath variable=MyVar (works) On production the same code fails. If I remove the charset=Shift_JIS, tag will read files without problem, but of course I need it to recognize Shift_JIS for the japanese files. ~| 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:300451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Microsoft Live Office
link? On Tue, Mar 4, 2008 at 3:39 PM, Don L [EMAIL PROTECTED] wrote: Has anyone tried that? And what's your experience with it? Thanks. ~| 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:300452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Microsoft Live Office
On 3/4/08, C. Hatton Humphrey [EMAIL PROTECTED] wrote: link? http://www.officelive.com/ ~| 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:300453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need full path file browser
And you have read correctly. Just take a moment to imagine the havoc if I could write a web application that could root around your file system for any interesting sounding files every time you visited my popular web site? They have a new word for this (A.I.R.) ~| 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:300454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: VPN and 2 NICs
For my work I use a VPN client from Netscreen, Netscreen-Remote. It seems to do routing as you describe using only one NIC. If I go to a web site outside the VPN (ie Google) it doesn't route that traffic through the VPN. From my experience the VPN client built into Windows XP pushes everything through the connection once connected. The point of my message is that you'll probably have to get a third-party client to get more advanced routing capabilities. You can configure the Windows L2TP VPN client not to route all traffic through the VPN by clearing the Use default gateway on remote network option under Advanced TCP/IP options. If you have some traffic which does need to be routed, for example to a different network within your LAN border, you can use the route command to add the route you need: (say your VPN connects you to 172.30, and your network also contains 172.29) route add 172.29.0.0 mask 255.255.0.0 172.30.3.1 metric 1 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| 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:300455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Microsoft Live Office
I feel it's very stupid and confusing, looks like someone in charge may actually work for Google... ~| 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:300456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfstat checkbox resetting
Vance Whitehouse wrote: Hello, I've been upgrading our web servers from CF 7 to 8 and I'm not able to enable cfstat on them when they are running CF 8. Every time I check the Enable CFSTAT checkbox in the CF administrator, hit submit, and restart CF then log back in and check the administrator the box is unchecked. The box is even unchecked if I simply refresh the page after submitting it. I have also verified that the Watch configuration files for changes checkbox is not checked. Two of the servers are running Windows 2003 and two are running Red Hat ES 5. Any ideas? Thanks, Vance I just ran into a similar today. I wrote a blog post about it: http://www.stillnetstudios.com/2008/03/04/getting-cfstat-to-work/ But the short of it is - check your neo-metric.xml file. Look for var name='cfstat'number1.0/number/var and change it to var name='cfstat'stringtrue/string/var. If it still doesn't work, look at the cfstatport setting (more details in the blog post). -Ryan ~| 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:300457 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Microsoft Live Office
I think it was in beta at the time and I got a free domain out of the deal so I was like, why not? My impression on using it for a few hours a couple of years ago: Very Easy to use. Very easy to skin. Fairly nice templates. Better than most free offerings at the time. Great wussywig (IE only, go figure). Good for brochure ware sites that need a simple CMS. I was very impressed with the UI (at the time). Well thought out. Very intuitive and easy to figure out for users at the novice or better level. Everything in one place, email, user website admin etc. Of course, it being that easy to use, I got bored with it very quickly and forgot about it. :) It is like Joomla for dummies. I am sure that was their intent. On the down side, I have seen it throw random errors when visiting a local company's website. On Tue, Mar 4, 2008 at 3:39 PM, Don L [EMAIL PROTECTED] wrote: Has anyone tried that? And what's your experience with it? Thanks. ~| 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:300459 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Add form fields dynamically
All, I'm starting to build a basic form where the user can indicate the number of children they have. What I want to do is based on the number of kids value, dynamically generate birthday form fields. Any posts, articles or ideas would be great to get me started. Thanks. form id=form1 name=form1 method=post action= labelNumber of Kids: select name=kids id=kids option value=11/option option value=22/option option value=33/option option value=44/option option value=55/option option value=66/option option value=77/option option value=88/option option value=99/option option value=1010/option option value=/option /select /label pMonth: label select name=month id=month option value=01 selected=selectedJan/option option value=02Feb/option option value=03March/option option value=04April/option option value=05May/option option value=06June/option option value=07July/option option value=08Aug/option option value=09Sept/option option value=10Oct/option option value=11Nov/option option value=12Dec/option n bsp; /select /label Day: label select name=Day id=Day option value=01 selected=selected01/option option value=0202/option option value=0303/option option value=0404/option option value=0505/option option value=0606/option option value=0707/option option value=0808/option option value=0909/option option value=1010/option option value=/option option value=1212/option option value= 1313/option option value=1414/option option value=1515/option option value=1616/option option value=1717/option option value=1818/option option value=1919/option option value=2020/option option value=2121/option option value=/option option value=2323/option option value=2424/option option value=2525/option option value=2626/option option value=2727/option option value=2828/option gt; option value=2929/option option value=3030/option option value=3131/option /select /label Year: label select name=year id=year option value=2004 selected=selected2004/option option value=20052005/option option value=20062006/option option value=20072007/option option value=20082008/option /select /label /p pnbsp;/p /form ~| 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:300460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IVR / Faxback solutions
for IVR, check out angel.com I am hoping that maybe someone on here has some experience with this and can point me in the right direction. I am working on setting up a system where a doctor's office would call an IVR system, put in a bit of information on a patient and get the eligibility and information faxed back to them. I have a dedicated windows 2003 server with CF and SQL 2000 that has all the information I need, but I don't have a lot of experience with IVR or faxing solutions. So I am hoping someone on here may have done something similar or maybe can point me in the right direction. In order to save money, we would like to be able to build as much of this ourselves if possible. Whether or not that is possible, I dont really know. I am guessing we would need to purchase the IVR software, but if we could do the actual faxing from ColdFusion, that would be great. Thanks, Dan ~| 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:300458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFTP - Secure connection
OK- Coldfusion 8 uses JSCH as well as the old tag for 7 did. so the same, mis-spelt error mesage lingers in Coldfusion 8 as in 7 with the user-built CFC(cfsftp)... invaid privatekey: c:\id_dsa.ppk Does anyone know what file format the private key is expected to be in? Is it it still usable if you didn't use a passphrase to encode it? Can you just leave passphrase blank then? I'm trying to connect to Youtube's ftp for uploading video/xml and having no luck. This may be a bit of an under-used feature. ~| 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:300461 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfexecute and dr web or avg - permissions problem
Hey all, I want to scan a file for viruses on upload. I have dr web installed already, as part of Plesk, and AVG is an easy (free) option too. So, I have the following code to try and run dr web to scan a file. The pathways are all correct, and the /ST argument is to run in stealth mode: cfexecute name=#path_to_folder#\drweb32w.exe arguments=/@#file_to_scan# /ST variable=results timeout=10 / But the page just times out. Checking the dr web logs, I see this message: Error (80004015): The class is configured to run as a security id different from the caller So I'm guessing this is a user permissions issue. I can't see an option to run the command line scanner under a specific account in the dr web docs. Anyone had any experience of this and can offer a solution or a point in the right direction. I'd look at other av options too. Cheers Will ~| 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:300462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfexecute and dr web or avg - permissions problem
So I'm guessing this is a user permissions issue. I can't see an option to run the command line scanner under a specific account in the dr web docs. Use the runas command to run a program as a specific user. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| 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:300463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cffile read charset Shift_JIS
Using CF MX6 on both dev and prod, moving from a development server to production ran into problem. On development server, cffile action=read charset=Shift_JIS file=myfilePath variable=MyVar (works) On production the same code fails. If I remove the charset=Shift_JIS, tag will read files without problem, but of course I need it to recognize Shift_JIS for the japanese files. More Information: The prod server burps on the following charsets: shift_jis iso-2022-jp euc-jp euc-kr big5 euc-cn ~| 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:300464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Add form fields dynamically
On Tue, Mar 4, 2008 at 1:31 PM, [EMAIL PROTECTED] wrote:
All,
I'm starting to build a basic form where the user can indicate the number of
children they have.
What I want to do is based on the number of kids value, dynamically generate
birthday form fields.
this will get you started. it's very basic. does NOT account for
days in month (e.g. you could end up with February 31st being
submitted), nor does it remove elements. so if you select 3 kids,
you'll get 3 new options for birthdays. if you change it to 1, you'll
get a 4th. if you change it to 2, you'll get a 5th and 6th... :)
but it's a start.
html
head
title/title
script type=text/javascript
var months =
['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'];
function createBDayFields(n) {
for (var i=0; in; i++) {
// create a div to hold the 3 new select elements
newDiv = document.createElement('div');
newDiv.id = bdayDiv + i;
// create the 'month' dropdown
bdayMonth =
document.createElement('select');
bdayMonth.id= birthdayMonth + i+1;
bdayMonth.name = birthdayMonth + i+1;
for (var j=0; j12; j++) {
bdayMonth.options[j] = new Option(months[j],
j+1);
}
// create the 'day' dropdown
bdayDay =
document.createElement('select');
bdayDay.id = birthdayDay + i+1;
bdayDay.name= birthDayDay + i+1;
for (var j=0; j31; j++) {
bdayDay.options[j] = new Option(j+1, j+1);
}
// create the 'year' dropdown
bdayYear=
document.createElement('select');
bdayYear.id = birthdayYear + i+1;
bdayYear.name = birthDayYear + i+1;
for (var j=0; j5; j++) {
bdayYear.options[j] = new Option(j+2004,
j+2004);
}
// create the new label
newLabel = document.createElement('label');
newLabel.appendChild(document.createTextNode('Birthday
' +
parseInt(i+1) + ': '));
newLabel.setAttribute('for', bdayMonth.id);
// append it to the form
document.getElementById('myForm').appendChild(newDiv);
document.getElementById('bdayDiv' +
i).appendChild(newLabel);
document.getElementById('bdayDiv' +
i).appendChild(bdayMonth);
document.getElementById('bdayDiv' +
i).appendChild(bdayDay);
document.getElementById('bdayDiv' +
i).appendChild(bdayYear);
}
}
/script
/head
body
form id=myForm
label for=kidsKids: /label
select name=kids id=kids
onchange=createBDayFields(this.options[this.selectedIndex].value);
option value=/option
cfloop from=1 to=9 index=idx
cfoutputoption
value=#idx##idx#/option/cfoutput
/cfloop
/select
/form
/body
/html
--
Evelyn the dog, having undergone further modification pondered the
significance of short-person behaviour in pedal depressed,
pan-chromatic resonance, and other highly ambient domains. Arf, she
said.
~|
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:300465
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: VPN and 2 NICs
You can configure the Windows L2TP VPN client not to route all traffic through the VPN by clearing the Use default gateway on remote network option under Advanced TCP/IP options. If you have some traffic which does need to be routed, for example to a different network within your LAN border, you can use the route command to add the route you need: (say your VPN connects you to 172.30, and your network also contains 172.29) route add 172.29.0.0 mask 255.255.0.0 172.30.3.1 metric 1 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Thanks Dave, I'm not familiar with the Windows L2TP VPN client. Any ideas if it will connect to a Cisco VPN concentrator (3000 series)? Or perhaps a better question is whether or not it's a generic VPN client? FYI...what you laid out is EXACTLY what I do in Linux with KVPNC as a GUI (allows you to keep/replace default route) and then I have it set to add the 2 routes I need for the VPN once connected (using VPNC as the actual app doing the connecting). So just looking to do the same thing in Windows, but the Cisco VPN client has no keep default route option and every time I remove the critical route it adds, it just puts it back!! gr (I know...it's doing what it's supposed to). Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| 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:300466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfexecute and dr web or avg - permissions problem
Thanks for the reply Dave. I've not played with runas before, and I'm uncertain as to how to pass the arguments to drweb32w.exe using runas. Any pointers? Thanks Will -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 04 March 2008 21:57 To: CF-Talk Subject: RE: cfexecute and dr web or avg - permissions problem So I'm guessing this is a user permissions issue. I can't see an option to run the command line scanner under a specific account in the dr web docs. Use the runas command to run a program as a specific user. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| 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:300467 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC, OOP I have another acronym for you.. WTF?
Tom.. you mean something like this... ? cflock scope=application timeout=5 type=Exclusive cfset application.userGateway ... cfset application.groupGateway ... /cflock etc.. What timeout should it have? is 5 seconds good enough? Thanks! On Tue, Mar 4, 2008 at 9:15 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 04 Mar 2008, Greg Morphis wrote: I have the timeout set for 30 seconds for testing... but as I said below, I wonder if created it twice once in the act_login.cfm page and once in the application.cfc file was causing the problems It's possible you have a race condition, I suppose, though the lack of a proper error is a pain. FWIW we create all our application scoped CFCs within a named lock. -- Tom Chiverton Helping to centrally industrialize total e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:300468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
LinkedIn CF group
I'm not sure what purpose it serves, but I created a LinkedIn CF group if anyone cares http://www.linkedin.com/groupInvitation?groupID=63526sharedKey=59CB6255962F ~| 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:300469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Advertising CF as a server side technology
Hi Ali, Glad to see that you are all about CF and want to share the love, this kind of enthusiasm is great! A lot of the questions you are asking have already been answered, running a few quick searches on Google should yield some good ammo for your pitch (hint, try searching on Coldfusion is dead, there are many great rebuttals). Also a good place to find advertising material is right on the Adobe.com website. As far as your question #6 is concerned, security boils down to the developer, not the language. I'm sure there might be some exceptions to this rule, but generally speaking its the developers responsibility to build a secure application. Good luck in your quest to promote CF! JAlpino On Tue, Mar 4, 2008 at 8:10 AM, Ali [EMAIL PROTECTED] wrote: Okay. This may look a little strange but I want to Advertise for CF not for money but because it rocks. Infact I want to introduce it to the hospitals and health center plus any application developers in health industry which I work in. Now people mostly use .Net or PHP to develope such applications and I really believe if they use CF they can develope them more easily and faster than now plus with more options and features. I am not a pro or very experienced programmer and I am just an MD with a history of programming and working with CF from version 6. Right now I am working on a library application for my hospital library. I really enjoy working with CF and I hope other discover the same JOY. Now my questions: 1. Please give me your ideas that how I should introduce CF to others. 2. What resources I should list for the programmers as references (Books, Websites, Blogs, Articles, Examples) 3. What will be the future of CF. Many programmers tell me that .Net will be the number one in the future because of Microsoft support. What should I tell them about CF? 4. Compatibilies is another question everybody asks! Is CF compatible with all DBs and all OSes? Is it compatible with other server side technologies and APPs made with them? 5. Security issues. All the developers ask about the security. I always aswer that CF uses Java as its backbone so it has the best security structure than all others. Am I right? 5. Please give me more because I might not be familiar with more ideas and tips I can use to introduce CF here. Thanks Ali ~| 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:300470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cffile read charset Shift_JIS
Randy Messer wrote: Using CF MX6 on both dev and prod, moving from a development server to production ran into problem. On development server, cffile action=read charset=Shift_JIS file=myfilePath variable=MyVar (works) depends on the JDK version. go here: http://www.sustainablegis.com/projects/i18n/charsetTB.cfm and get the CFC run on your server to see what charsets it supports. if it's linux maybe watch out for case (so maybe try one of these Shift_JIS, shift-jis, x-sjis, ms_kanji, shift_jis, csShiftJIS, sjis, pck). ~| 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:300471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Add form fields dynamically
On Tue, Mar 4, 2008 at 2:11 PM, Charlie Griefer [EMAIL PROTECTED] wrote: On Tue, Mar 4, 2008 at 1:31 PM, [EMAIL PROTECTED] wrote: All, I'm starting to build a basic form where the user can indicate the number of children they have. What I want to do is based on the number of kids value, dynamically generate birthday form fields. i'm sure this can be cleaned up quite a bit... but this should do it http://www.nomorepasting.com/getpaste.php?pasteid=12545 -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. Arf, she said. ~| 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:300472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: LinkedIn CF group
I'm game. Just joined. Rob On Tue, Mar 4, 2008 at 3:01 PM, James Wolfe [EMAIL PROTECTED] wrote: I'm not sure what purpose it serves, but I created a LinkedIn CF group if anyone cares http://www.linkedin.com/groupInvitation?groupID=63526sharedKey=59CB6255962F ~| 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:300473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: LinkedIn CF group
+1 On Wed, Mar 5, 2008 at 9:08 AM, RobG wrote: I'm game. Just joined. On Tue, Mar 4, 2008 at 3:01 PM, James Wolfe [EMAIL PROTECTED] wrote: I'm not sure what purpose it serves, but I created a LinkedIn CF group if anyone cares http://www.linkedin.com/groupInvitation?groupID=63526sharedKey=59CB6255962F -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| 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:300474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Add form fields dynamically
Charlie, Thanx for the nomorepasting.com link. Good stuff. P.S. Information is not knowledge. Knowledge is not wisdom. Wisdom is not truth. Truth is not beauty. Beauty is not love. Love is not music. Music is THE BEST. And something about the Wiz that Dale was babbling about... -- As an adolescent I aspired to lasting fame, I craved factual certainty, and I thirsted for a meaningful vision of human life - so I became a scientist. This is like becoming an archbishop so you can meet girls. - M. Cartmill ~| 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:300475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: LinkedIn CF group
me too! ~| 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:300476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need query help
Will Tomlinson wrote: Hey, I've got groups that can have one or more types associated with them. I have a linking table that I'm querying and filtering. But I'm not getting the results I need. Example: A group can be both 'College' and 'Jewish', as listed in the many linking table - tblgrouptypes_x.grouptype In my query below, I'm looking for groups that are both 'College' and 'Jewish', but getting no results. Even though I know there is one in there. Seems simple enough. SELECT tblgroups.groupid, tblgroups.groupimage, tblgroups.groupname, tblgroups.groupcity, tblgroups.state, tblgroups.voicingid, tblgroups.groupcontactperson, tblgroups.country, tblgroups.region, tblgrouptypes_x.groupid, tblgrouptypes_x.grouptype, tblgrouptypes.grouptype FROM tblgroups, tblgrouptypes, tblgrouptypes_x WHERE tblgroups.groupid = tblgrouptypes_x.groupid AND tblgrouptypes_x.grouptype = tblgrouptypes.grouptype AND (tblgrouptypes_x.grouptype = 'College' AND tblgrouptypes_x.grouptype = 'Jewish') ORDER BY tblgroups.groupsortname And ideas would be appreciated. Thanks, Will A problem with your query is that you SELECT the 'grouptype' column. This column cannot show both 'College' and 'Jewish' at the same time. One solution is to return two rows for the single record in tblgroups that you want. One row will have 'College' and the second row will have 'Jewish': - SELECT G.groupid, G.groupimage, G.groupname, G.groupcity, G.state, G.voicingid, G.groupcontactperson, G.country, G.region, X.groupid, X.grouptype, T.grouptype FROM tblgroups G, tblgrouptypes T, tblgrouptypes_x X WHERE G.groupid = X.groupid AND X.grouptype = T.grouptype AND EXISTS ( SELECT 1 FROM tblgrouptypes_x Z WHERE G.groupid = Z.groupid AND Z.grouptype = 'College' ) AND EXISTS ( SELECT 1 FROM tblgrouptypes_x Z WHERE G.groupid = Z.groupid AND Z.grouptype = 'Jewish' ) ORDER BY G.groupsortname - Another solution is to not SELECT the 'grouptype' column(s). This query will only return one row from tblgroups, containing only columns from tblgroups: - SELECT G.groupid, G.groupimage, G.groupname, G.groupcity, G.state, G.voicingid, G.groupcontactperson, G.country, G.region FROM tblgroups G WHERE G.groupid IN ( SELECT DISTINCT D.groupid FROM tblgroups D, tblgrouptypes_x X WHERE D.groupid = X.groupid AND EXISTS ( SELECT 1 FROM tblgrouptypes_x Z WHERE D.groupid = Z.groupid AND Z.grouptype = 'College' ) AND EXISTS ( SELECT 1 FROM tblgrouptypes_x Z WHERE D.groupid = Z.groupid AND Z.grouptype = 'Jewish' ) ) ORDER BY G.groupsortname - You don't mention your database. Both these SQL statements work on SQLServer and MySQL, but you may need to adjust them a bit if you use something else. Hope this helps. -tom- ~| 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:300477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfexecute and dr web or avg - permissions problem
Thanks for the reply Dave. I've not played with runas before, and I'm uncertain as to how to pass the arguments to drweb32w.exe using runas. Any pointers? I think I'd write a batch file to run all this. You'd use CFEXECUTE to invoke CMD.EXE, and pass it everything else as an argument. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| 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:300478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Find/Replace for Eclipse
Does a plugin exist for Find/Replace that is as good as the one for Dreamweaver? I like the option of searching the entire site or folder. ~| 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:300479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Find/Replace for Eclipse
Folder: Click on the folder you want in the Navigator view, then choose Selected Resources in the search dialog. Site: Ditto, but start at the site root Jaime -Original Message- From: j s [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 March 2008 1:11 PM To: CF-Talk Subject: Find/Replace for Eclipse Does a plugin exist for Find/Replace that is as good as the one for Dreamweaver? I like the option of searching the entire site or folder. ~| 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:300480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Find/Replace for Eclipse
From experience (oops!): before doing the big find and replace make sure you refresh your site/folder so that all the files are current. ;) -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com -Original Message- From: Jaime Metcher [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 7:42 PM To: CF-Talk Subject: RE: Find/Replace for Eclipse Folder: Click on the folder you want in the Navigator view, then choose Selected Resources in the search dialog. Site: Ditto, but start at the site root Jaime -Original Message- From: j s [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 March 2008 1:11 PM To: CF-Talk Subject: Find/Replace for Eclipse Does a plugin exist for Find/Replace that is as good as the one for Dreamweaver? I like the option of searching the entire site or folder. ~| 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:300481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
