RE: WSE Security - anyone have any experience with it?
I first looked into this and than we decided to simply run authentication over SSL to protect our services. In our situation, the amount of development didn't justify the end result. We also found that even with the Java upgrade to allow the Encrypt tag more functionality, we had problems as .NET defaults to UTF-16 whereas CF uses UTF-8 which can play havoc while passing encoded initialization vectors and encrypted strings. If you end up trying to conquer this, let me know and I'd be happy to work on this with you. Cheers, !k -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:50 PM To: CF-Talk Subject: WSE Security - anyone have any experience with it? My client has asked for advice on what the ramifications might be for his site if he shares content with another company who uses WSE Security. The content will require secure access - there's dollars being passed back and forth - and this other company is a .net site, and they use WSE security. So .. now II have to bone up on what it means for a CF7.0.2 enterprise/Win2003 environment. Can anyone point me at any resources so I can learn about it. preferably not anything from Microsoft I have the greatest difficulty learning anything from their documentation. -- 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 ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274499 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFX_XMLParser in MX 7.02
Thanks Neil, We have this code across quite a few of our applications and don't really have the time to start changing it all at the moment. That's why I thought I'd ask. Cheers, James ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274501 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Query Help
having brain fart here ... ughh scenario: customer table, invoice table I'd like to do a query to list the last invoice for each customer. Can someone point me in the right direction please? TIA, Jenny ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help - Answered
removing the DISTINCT did the trick. Thank you both. Josh Nathanson wrote: I don't think you need DISTINCT at all if you are using GROUP BY. GROUP BY will group all the matching rate values together automatically, so the result will be all distinct values. Try something like (not tested) SELECT Count(rate) as ratecount, rate FROM myrates etc. GROUP BY rate Dump that and see if you're any closer to what you want. -- Josh - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, April 03, 2007 2:09 PM Subject: Re: SQL Help - Answered I'm going to have to look at something. I'm still not getting what I anticipated. There are over 3700 records of which 1775 of them are distinct values for RATE. However, I am only getting values of 1 for COUNT(DISTINCT rate) as rateCount. I was trying to find out how many records are there for each distinct value in the RATE field. I need to chart how many records there are for each value in RATE. Thanks for the help. Greg Morphis wrote: No problem, if you want to know why take a look at aggregate functions, which is what count is, as well as others.. On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thank you Greg Morphis wrote: You need a group by in your query.. SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 GROUP BY rate ORDER BY rate On 4/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Why do the first two queries work and the last one fail? The only difference is adding the comma and additional field to the SELECT statement. cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery cfquery datasource=myDSN name=Rates SELECT rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery FAIL cfquery datasource=myDSN name=Rates SELECT count(DISTINCT rate) as rateCount, rate FROMmyrates WHERE my_code = 385 and year = 2005 ORDER BY rate /cfquery ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with Access driver and Windows 2003 Server
Jake, Did you ever get this resolved? I am having the same problem. Thanks, Jeff ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Disregard check box/flash form issue
I have decided to abandon using Flash Forms for this stuff since it is starting to get suckey. I am going back to HTML/Tables. -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274513 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
testing...
Just testing, I have not received any cf-talk since last night at around 8:30 pdt. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274509 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Hardware load balancers (lower-end)
Folks, I'd like to know what you're using for lower-end *hardware* load balancing for your ColdFusion apps. I've got an application to deal with that doesn't have a lot of network bandwidth but does have a lot of processor load, so I don't need a paired set of BIGIPs to manage it :) I'd prefer a packaged hardware solution that supports sticky sessions -- the app was not really designed for clustering. Something like an old Cisco LocalDirector off ebay is probably about the right speed! Details: CFMX7 *Standard*, servers are Windows 2003, Web edition. Using java sessions. Currently using Sonicwall and Cisco in the network infrastructure. Thoughts/recommendations? -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274506 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: advantages/disadvantages of using CF and XSLT.
Greetings, Have a general question about XML/XSLT and CF. One of the powers that be is making noises about limiting the use of CF etc., etc., etc. One of the arguments he's using is that XML/XSLT can handle most data display. Unfortunately I know know enough about XML/XSLT to discuss the issue intelligently and show where he's incorrect with this. So in general, what are the advantages/disadvantages of using CF in conjunction with XML/XSLT over just using XML/XSLT alone? Any suggestions are appreciated. thx, larry ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274515 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: chart images distorted when creating PDF
I didn' t actually, since I don't use JPG for chart images - I like the look of the flash charts better. On the Linux boxes where I use the JPG charts, I haven't had a problem. Have you played with the various file formats? I was just applying hotfixes and since I use cfchart, I figured What the heck. After it hung CF on startup, I decided to postpone that upgrade until it was part of a cumulative hotfix down the road. Sorry I can't help you more on fixing the original problem, but glad I could help on this one :-) Jon On Apr 3, 2007, at 8:02 PM, Rafael Marquez wrote: Thanks! I can breathe again! I still have the issue with the broken chart images, though.. How did you fix that problem? RM -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 7:00 PM To: CF-Talk Subject: Re: chart images distorted when creating PDF Rafael, If you installed the hotfix by uploading the .jar through the CFAdmin, you can revert by deleting (or moving) the .jar file. On a windows machine this is usually located at: C:\CFusionMX7\lib\updates I had a similar problem with the charting hotfix when I installed it, but it wasn't a critical update for me so I skipped trying it again until the next cumulative hotfix. Once you delete the file, you should be able to restart and go. HTH, Jon On Apr 3, 2007, at 6:49 PM, Rafael Marquez wrote: Mark: This is my jvm.config: - # # VM configuration # # Where to find JVM, if {java.home}/jre exists then that JVM is used # if not then it must be the path to the JRE itself java.home=C:/CFusionMX7/runtime/jre # # If no java.home is specified a VM is located by looking in these places in this # order: # # 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix) # 2) ../jre # 3) registry (windows only) # 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre) # # Arguments to VM java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS - Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC -Dcoldfusion.classPath={application.home}/../../classes, {application.home}/. ../lib/updates,{application.home}/../lib/,{application.home}/../ gateway/lib/, {application.home}/../wwwroot/WEB-INF/cfform/jars,C:\\CFusionMX7\ \CustomTags \\cfx_text2Query.jar,C:\\CFusionMX7\\CFXTags\\cfx_excel2query.jar # # commas will be converted to platform specific separator and the result will be passed # as -Djava.ext.dirs= to the VM java.ext.dirs={jre.home}/lib/ext # # where to find shared libraries java.library.path={application.home}/../lib,{application.home}/../ jintegra/b in,{application.home}/../jintegra/bin/international system.path.first=false # # set the current working directory - useful for Windows to control # the default search path used when loading DLLs since it comes # before system directory, windows directory and PATH java.user.dir={application.home}/../../lib # JVM classpath java.class.path={application.home}/servers/lib, {application.home}/../lib/mac romedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar, {application.home} /lib - it doesn't look wrong... -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 6:29 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Rafael, Why don't you post the contents of the /runtime/bin/jvm.config file. It might have a clue or 2. -mark -Original Message- From: Rafael Marquez [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 5:12 PM To: CF-Talk Subject: RE: chart images distorted when creating PDF Mark: I did not have any troubles doing uploading the jar. I do have a backup, but it's for the whole server This is what I read in the out log: Thanks Server coldfusion ready (startup time: 5 seconds) Starting Macromedia JRun 4 (Build 84683), coldfusion server 04/03 18:07:23 warning Unable to open C:\CFusionMX7\runtime/lib/license.properties 04/03 18:07:24 info JRun Naming Service listening on *:2920 04/03 18:07:24 warning No sessionSecret has been specified in jrun.xml. Installing a self generated sessionSecret. 04/03 18:07:24 info No JDBC data sources have been configured for this server (see jrun-resources.xml) 04/03 18:07:25 info JRun Proxy Server listening on *:51011 04/03 18:07:25 info Deploying enterprise application Macromedia ColdFusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:25 info Deploying web application Macromedia Coldfusion MX from: file:/C:/CFusionMX7/ 04/03 18:07:26 INFO License Service: Flex 1.5 CF Edition enabled 04/03 18:07:26 INFO Starting Flex 1.5 CF Edition 04/03 18:07:26 user JSPServlet: init 04/03 18:07:27 user
RE: Mailer Service Bean Issues (MG and CS)
Thanks for getting back to me buddy, Looks as if all my woes were caused by a spelling mistake, my fault for making a variable name so damn long, I has setOutgoingServer() but getOutogingServer(). All sorted now and my contact forms working a charm, Thanks, Rob -Original Message- From: Dinner [mailto:[EMAIL PROTECTED] Sent: 04 April 2007 02:42 To: CF-Talk Subject: Re: Mailer Service Bean Issues (MG and CS) On 4/3/07, Robert R wrote: You'll have to excuse me a little on this one guys, there's a fair amount of code involved as I'm unsure as to where the error is occurring. Looked fine to me, with a cursory glance. Have you just plain cfdumpedcfaborted at each stage along the way, as a sorta sanity check from one bit to the next? I find that straightforward and brutal method to work well in most cases. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Query Help
Maybe something like this (which I cannot test): SELECT c.id, c.name, i.* FROM customer c LEFT OUTER JOIN ( -- Get max (most recent) id (assuming pkey) of -- each invoice as grouped by client. SELECT i2.customer_id MAX( i2.id ) AS invoice_id FROM invoice i2 GROUP BY i2.customer_id ) AS inv ON c.id = inv.customer_Id LEFT OUTER JOIN invoice i ON inv.invoice_id = i.id We create an interim table that has JUST the customer id and MAX invoice Id. Then we join that to customers, and then join that to invoices (only were the max id = the invoice id). .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 8:58 AM To: CF-Talk Subject: SQL Query Help having brain fart here ... ughh scenario: customer table, invoice table I'd like to do a query to list the last invoice for each customer. Can someone point me in the right direction please? TIA, Jenny ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFIF - Not to show
I am missing something here. I want to stop next page navigation from showing if there are less than 25 records over all. This is what I have. cfif NOT URL.ShowAll AND TotalRows GT RowsPerPage !--- Shortcut links for Pages of search results --- Page cfinclude template=NextNIncludePageLinks.cfm !--- Show All Link --- cfoutput a href=#CGI.SCRIPT_NAME#?ShowAll=YesShow All/a /cfoutput /cfif cfif NOT URL.ShowAll!--- Provide Next/Back links ---cfinclude template=NextNIncludeBackNext.cfm/cfif I thought I would right it this way; it does disappear, but doesn't matter how many records there are. cfif URL.ShowAll LT 25cfelsecfinclude template=NextNIncludeBackNext.cfm/cfif Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274512 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IE6 restore down maximize window then frame will display in full
I have a frame in coldfusion that only displays in full once i go and click restore down and the maximize then it will display in full. How can I get the browser window to maximize on initial page load? Just to be clear, I mean specifically the kind of maximize that happens when you press the maximize button on the upper right hand corner of the browser window...not the as big as possible in the intermediate state between maximize and minimize (there's a difference of at least 1 pixel in size...) ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274502 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
is this thing on?
Not seeing any list traffic..so I thought I'd make my own ;-) 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. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Listing TODOs in CF files
I need to get a list of all the TODOs in a list of (primarily .cfm) files. In the unlikely event of people not being familiar with TODOs, they're just CFML comments like this: !--- TODO: Thing I have to do --- The presence of the TODO: then flags up that something needs to be addressed. Very useful when you want to shove in some dummy data and return later to fix it. (Good editors can flag TODOs - eg: CFEclipse puts a blue bar next to the scrollbar) Currently I've got some regex to convert file contents into a pipe-delimited list, but I've been getting odd results and it has now started giving me buffer overflow errors for no clear reason. Here's the current code: cfset Tasks = REReplace(Contents,'.*?(!--- TODO:)(.*?)(?=---)([^]|[^!]|!--[^-]|!---\s+[^T])*','\2|','all')/ ul cfloop index=i list=#Tasks# delimiters=| li#i#/li /cfloop /ul I'm sure there has to be a better way of doing it than that, but I think I've been working on the problem for too long to figure it out myself, so if anyone here is able to offer a better solution it would be very much appreciated. Thanks. -- \ \ Peter Boughton blog.bpsite.net / / ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274514 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Query Help
Assuming the invoice numbers increase each time, you can use MAX() and GROUP BY to get what you need. SELECT customer, MAX(invoiceNum) AS lastNum FROM table GROUP BY customer If invoices are not numbered sequentially, hopefully you have a date field that you can add to the grouping. M!ke -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 7:58 AM To: CF-Talk Subject: SQL Query Help having brain fart here ... ughh scenario: customer table, invoice table I'd like to do a query to list the last invoice for each customer. Can someone point me in the right direction please? TIA, Jenny ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274520 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Session or Cookie or....?
This is probably a stupid question, but I have no pride. Consider the Adobe Forums. Let's say I login to the forums on my computer at work. Now, let's say I close my browser, go home, call in sick the next day, and return to the office a day later. When I return to the Adobe Forums on the same computer, I am still logged in. How, exactly, is this being handled? Does the session I created when I first logged in have a really long timeout? Is this being handled by a cookie? Or is there something else going on? Thanks ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274503 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Session or Cookie or....?
When I return to the Adobe Forums on the same computer, I am still logged in. Not having used the Adobe Forums myself, I can't say how they do it specifically, but it could be that they are setting a cookie with a session ID of some kind outside the usual ColdFusion session cookies that has a longer timeout. This cookie would then be linked up to your profile in their database so they know who you are. -Justin Scott | GravityFree Client Care Special Forces Unit 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.com ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274516 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Query Help
Need more info: What would the query be to return the last invoice for a single customer? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 8:58 AM To: CF-Talk Subject: SQL Query Help having brain fart here ... ughh scenario: customer table, invoice table I'd like to do a query to list the last invoice for each customer. Can someone point me in the right direction please? TIA, Jenny ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274519 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Getting the value out of a CheckBox in FlashForm
Good morning, I have a checkbox in a Flash Form and I am trying to get the value of it when I submit it. All that is getting sent to the server is true and false. The code looks like this: cfinput type=checkbox name=EmailGroup_#GroupID# value=#GroupID# label=#GroupName# This is inside of a cfoutput query. What I want is to get the group ID and use that as the input value instead of true/false. Here is my code to insert: cfparam name=FieldCount default=0 cfloop list=#Form.FieldNames# index=x cfif (FindNoCase(EmailGroup_, x) GT 0) AND len(trim(form[x])) GT 0 AND (TRIM(form[x])) NEQ False cfset FieldCount = Right(x, 1) /cfif /cfloop cfif FieldCount GT 0 DELETE FROM tblCouncilEmailGroup WHERE MemberID = #Form.councilmemberID# /cfif cfloop from=1 to=#FieldCount# index=i cfset groupfield = EmailGroup_ i cfquery datasource=#Request.dsource# INSERT INTO tblCouncilEmailGroup (MemberID, GroupID) VALUES (#Form.councilmemberID# cfif len(StructFind(form, groupfield)) ,#StructFind(form, groupfield)#) /cfif /cfquery /cfloop Thanks, -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274510 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: is this thing on?
Likewise - until just now when it's kicked in. Not seeing any list traffic..so I thought I'd make my own ;-) 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. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274518 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hardware load balancers (lower-end)
Seems like you answered your own post :-) This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: John Paul Ashenfelter To: CF-Talk Sent: Wed Apr 04 14:57:34 2007 Subject: Hardware load balancers (lower-end) Folks, I'd like to know what you're using for lower-end *hardware* load balancing for your ColdFusion apps. I've got an application to deal with that doesn't have a lot of network bandwidth but does have a lot of processor load, so I don't need a paired set of BIGIPs to manage it :) I'd prefer a packaged hardware solution that supports sticky sessions -- the app was not really designed for clustering. Something like an old Cisco LocalDirector off ebay is probably about the right speed! Details: CFMX7 *Standard*, servers are Windows 2003, Web edition. Using java sessions. Currently using Sonicwall and Cisco in the network infrastructure. Thoughts/recommendations? -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274522 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFIF - Not to show
1) just curious... why not use cfif URL.showAll GTE 25 and omit the cfelse rather than have an empty condition? 2) is URL.showAll a numeric value or a boolean? at one point you set it as YES... but in your conditional you're evaluating whether or not it's less than 25? On 4/4/07, Steve LaBadie [EMAIL PROTECTED] wrote: I am missing something here. I want to stop next page navigation from showing if there are less than 25 records over all. This is what I have. cfif NOT URL.ShowAll AND TotalRows GT RowsPerPage !--- Shortcut links for Pages of search results --- Page cfinclude template=NextNIncludePageLinks.cfm !--- Show All Link --- cfoutput a href=#CGI.SCRIPT_NAME#?ShowAll=YesShow All/a /cfoutput /cfif cfif NOT URL.ShowAll!--- Provide Next/Back links ---cfinclude template=NextNIncludeBackNext.cfm/cfif I thought I would right it this way; it does disappear, but doesn't matter how many records there are. cfif URL.ShowAll LT 25cfelsecfinclude template=NextNIncludeBackNext.cfm/cfif Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274521 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFIF - Not to show
cfparam name=URL.ShowAll type=boolean default=No Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 3:55 PM To: CF-Talk Subject: Re: CFIF - Not to show 1) just curious... why not use cfif URL.showAll GTE 25 and omit the cfelse rather than have an empty condition? 2) is URL.showAll a numeric value or a boolean? at one point you set it as YES... but in your conditional you're evaluating whether or not it's less than 25? On 4/4/07, Steve LaBadie [EMAIL PROTECTED] wrote: I am missing something here. I want to stop next page navigation from showing if there are less than 25 records over all. This is what I have. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274524 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session or Cookie or....?
There is way it would be a SESSION with a super long timeout - that would eventually kill the server I think (as the session information would be stored in the server's RAM). It must be a cookie is my guess. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 8:27 AM To: CF-Talk Subject: Session or Cookie or? This is probably a stupid question, but I have no pride. Consider the Adobe Forums. Let's say I login to the forums on my computer at work. Now, let's say I close my browser, go home, call in sick the next day, and return to the office a day later. When I return to the Adobe Forums on the same computer, I am still logged in. How, exactly, is this being handled? Does the session I created when I first logged in have a really long timeout? Is this being handled by a cookie? Or is there something else going on? Thanks ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274525 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Query Help
Well, it's not a brain fart. That query is kinda kinky. Use this as an example, replacing your tables and fields, it should work BASED ON DATE! SELECT DISTINCT T.CustomerID, T.TransactionDate, T.ID AS InvoiceID FROM dbo.Transactions T INNER JOIN (SELECT MAX(TransactionDate) AS maxdate, CustomerID FROM Transactions WHERE deleted = 0 GROUP BY CustomerID) maxresults ON T.CustomerID = maxresults.CustomerID AND T.TransactionDate = maxresults.maxdate WHERE (T.Deleted = 0) AND (T.Status 'Pending') AND (T.AccountType = 'Customer') GROUP BY T.CustomerID, T.TransactionDate, T.ID Hope this helps. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 3:39 PM To: CF-Talk Subject: RE: SQL Query Help Need more info: What would the query be to return the last invoice for a single customer? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 8:58 AM To: CF-Talk Subject: SQL Query Help having brain fart here ... ughh scenario: customer table, invoice table I'd like to do a query to list the last invoice for each customer. Can someone point me in the right direction please? TIA, Jenny ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: is this thing on?
Not seeing any list traffic..so I thought I'd make my own ;-) You guys start goin into convultions when there's no list traffic dont'cha! :) Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: maxlength on text area - how to approximate
Check out the javascript on https://wmg.tmomail.net/customer_site/jsp/messaging_lo.jsp It will not let you past 140 characters. Does anybody have a really good way to create the equal of maxlength on a text area? The server running site in question is only running CF 6 something, not 7, so cftextarea won't work... I've tried a couple of javascript ideas, and as long as you're typing input, it works. But, everything I tried so far will allow pasting more than the max set. I'm checking server side before the data insert, but the client wants to see something client side while the form is being filled out. Ideas? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Captivate2 Data Export $Assistance
Looking for programmer who can show me how to capture basic test data from Captivate2 project for import into Db using CF. I can provide sample test. $50 hr. - up to 2 hours to develop sample code for capturing test score, users answers. Hope this is acceptable post. I'm under time constraints to show a proof of concept working demo. Can contact me directly by email if interested or need add'l details. [EMAIL PROTECTED] Once again this is Adobe Captivate2, not Macromedia Captivate. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Listing TODOs in CF files
Peter, Open your site as a project in CFEclipse, then find the Tasks view (where view=panel). Alter the filter on the tasks view to show only tasks from the currently open project, then open one of the .cfm files from your project. Instantly you should see a list of all the tasks in your project. You can select the contents of the tasks view and paste into something else, like Excel or whatever. -- nathan strutz http://www.dopefly.com/ On 4/4/07, Peter Boughton [EMAIL PROTECTED] wrote: I need to get a list of all the TODOs in a list of (primarily .cfm) files. In the unlikely event of people not being familiar with TODOs, they're just CFML comments like this: !--- TODO: Thing I have to do --- The presence of the TODO: then flags up that something needs to be addressed. Very useful when you want to shove in some dummy data and return later to fix it. (Good editors can flag TODOs - eg: CFEclipse puts a blue bar next to the scrollbar) Currently I've got some regex to convert file contents into a pipe-delimited list, but I've been getting odd results and it has now started giving me buffer overflow errors for no clear reason. Here's the current code: cfset Tasks = REReplace(Contents,'.*?(!--- TODO:)(.*?)(?=---)([^]|[^!]|!--[^-]|!---\s+[^T])*','\2|','all')/ ul cfloop index=i list=#Tasks# delimiters=| li#i#/li /cfloop /ul I'm sure there has to be a better way of doing it than that, but I think I've been working on the problem for too long to figure it out myself, so if anyone here is able to offer a better solution it would be very much appreciated. Thanks. -- \ \ Peter Boughton blog.bpsite.net / / ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: is this thing on?
Not seeing any list traffic..so I thought I'd make my own ;-) You guys start goin into convultions when there's no list traffic dont'cha! :) Will Yep...as soon as I see no traffic I start thinking there is a US holiday I don't know about ;-) 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. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Listing TODOs in CF files
I'm sure there has to be a better way of doing it than that, You're quite right: Have a look at CF_REextract: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274531 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFUNITED news: Tyson Vanek on Caching, Topic survey, podcasts
Here is the ColdFusion and Fusebox news: * 10 reasons to attend CFUNITED * Topic survey - win a ticket to CFUNITED http://cfunited.com/go/survey * New CFUNITED podcasts released http://cfunited.com/blog/index.cfm/podcast - Kelly Tetterton - Managing a Project: From the Developer's Point of View - Kurtis D. Leatham - Arrays Structures Multidimensional Arrays and Arrays of Structures * Fusebox.org website prototype in progress * Interview with Tyson Vanek on Are You 'Cashing In' on Caching? Application development involves rapidly evolving technologies. Anyone in the industry who does not actively pursue expanding their knowledge will quickly become obsolete. CFUNITED looks to provide the best value for my education dollar. -Clay Mabbitt, (CFUNITED attendee) * 10 reasons to attend CFUNITED 1. If you take your ColdFusion and web development seriously, this is the one event you won't want to miss. Learn what's new, directly from Adobe. Ben Forta calls CFUNITED, now in its 8th year, the premier CF-specific event. 2. Meet other developers who share your interests. Find people who have already solved that problem that's giving you headaches back at the office; schmooze with speakers late-night at the bar; discuss the future of development. Often putting a face to that email that you've been chatting with on lists is the best part of CFUNITED. 3. Are members of your team new to ColdFusion? Then the CFUNITED bootcamp track will teach them the basics in a few days. From CFOUTPUT to looping, from SQL to database design - they'll learn all this and more from top experts in the field. 4. Flex is hot right now and we have a whole track on Flex, Ajax and Apollo. Learn Flex and pick up advanced techniques for Rich Internet Applications. 5. Meet the engineers from Adobe who create ColdFusion, ask them questions, and give them your 2 cents on what you'd like to see in the future. 6. See the latest tools for web development. We are expecting several new releases at CFUNITED, so visit our expo area and be prepared to have your socks blown off! 7. The After Party. Let your hair down, play games with your buddies, or challenge famous speakers to a game of pool. You might even have a technical conversation or two between the beers! 8. A year of info packed into 4 days! If you are hungry for technical information or want to ask questions, this is the place for you! We have regular sessions, long sessions and - if that is not enough - Birds-of-a-Feather evening sessions that go long into the night! Basic CF, Advanced CF, Better SQL, XML, CSS, Accessibility, Usability, Fusebox, security, PDFs, SMS, CFCs, OO, RSS, UDFs,debugging, arrays, structures, caching, web services, testing, charting, Flex, Ajax, Apollo, ColdSpring, Prototyping, MVC, CFEclipse, Spry, Design patterns, project management, and more. 9. Want to get your hands dirty? Attend our hands-on pre-conference classes taught by top speakers. Bring your own laptop, and code along with the pros! 10. Bags, t-shirts and goodies galore. Printed slides for every talk, so you don't have to print them out yourself. Plus online access to presentations, code samples and audio of any sessions you may have missed. * Topic survey - win a ticket to CFUNITED http://cfunited.com/go/survey Help us pick the most popular topics to put in larger rooms and to possibly repeat on Saturday. One entry will be chosen to win a FREE CFUnited 4 Day Pass based on the best reason for going to the event (in the opinion of CFUnited staff). The winner will be picked on Friday 4/20/07. http://cfunited.com/go/survey * New CFUNITED podcasts released - Kelly Tetterton - Managing a Project: From the Developer's Point of View - Kurtis D. Leatham - Arrays Structures Multidimensional Arrays and Arrays of Structures CF = RAD, and there's a Project Manager in charge -- so the developer is just along for the ride, right? Wrong! Learn some tips tricks to make sure your projects go as smoothly as possible. http://cfunited.com/blog/index.cfm/2007/4/1/Kelly-Tetterton--Managing-a-Project-From-the-Developers-Point-of-View Ever run across a problem where you needed to store data into a multidimensional array that contains a multidimensional array that contains a structure? What would the logical storage container look like that houses a companies org chart? This topic will show you how to create such a complex container, populate it with data, and then get the data back out. We cover Arrays and Structures and ways that you can mix and match these containers to create one huge container for your complex data. This discussion covers a real world example of an application that uses a complex container to automatically generate dynamic reports for several different people at different times throughout the year. The complex container that will be discussed houses information about the report itself, information about the people getting
RE: Hardware load balancers (lower-end)
I know you said hardware, but if you're not going to implement redundancy anyway, you might just want to use a software solution like Apache's mod_proxy_balancer or LVS. Can install it on top of Free VMWare Server, using CentOS and have a total cost of $0 (plus time required to implement. With LVS I believe you can even set up clusters, so should the primary machine hosting LVS go down, another one can pick up. Russ -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 9:58 AM To: CF-Talk Subject: Hardware load balancers (lower-end) Folks, I'd like to know what you're using for lower-end *hardware* load balancing for your ColdFusion apps. I've got an application to deal with that doesn't have a lot of network bandwidth but does have a lot of processor load, so I don't need a paired set of BIGIPs to manage it :) I'd prefer a packaged hardware solution that supports sticky sessions -- the app was not really designed for clustering. Something like an old Cisco LocalDirector off ebay is probably about the right speed! Details: CFMX7 *Standard*, servers are Windows 2003, Web edition. Using java sessions. Currently using Sonicwall and Cisco in the network infrastructure. Thoughts/recommendations? -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: is this thing on?
The answer: A circle is equal to a square and a piece of pie. just in case someone was looking for something psuedo-meaningful in this thread :). ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274534 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Listing TODOs in CF files
D'oh, I knew I should have put a please don't refer me to the Eclipse Task view in my post. :P The Task list isn't flexible enough for what I'm doing. (Which is building an interface for managing a project with, which will be scanning all the files and doing other stuff as well as listing TODOs) Anyway, I've got a script which works. Not as pretty as I'd like, but it'll do unless anyone can come up with anything better. cfset Matches = REReplace(Contents, !---\s*TODO:\s*([^]*?)\s*--- ,'øTODO:\1ø','all')/ cfloop index=i list=#Matches# delimiters=ø cfif Left(i,5) EQ 'TODO:' li#Replace(i,'TODO:','')#/li /cfif /cfloop Peter, Open your site as a project in CFEclipse, then find the Tasks view (where view=panel). Alter the filter on the tasks view to show only tasks from the currently open project, then open one of the .cfm files from your project. Instantly you should see a list of all the tasks in your project. You can select the contents of the tasks view and paste into something else, like Excel or whatever. -- nathan strutz http://www.dopefly.com/ On 4/4/07, Peter Boughton [EMAIL PROTECTED] wrote: ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274535 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Hardware load balancers (lower-end)
I'd prefer a packaged hardware solution that supports sticky sessions -- the app was not really designed for clustering. Something like an old Cisco LocalDirector off ebay is probably about the right speed! eBay and uBid are your friends here. I've had better success with uBid for computer hardware, myself. Some of the used Radware hardware solutions can be picked up pretty cheap. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274536 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: advantages/disadvantages of using CF and XSLT.
Have a general question about XML/XSLT and CF. One of the powers that be is making noises about limiting the use of CF etc., etc., etc. One of the arguments he's using is that XML/XSLT can handle most data display. Unfortunately I know know enough about XML/XSLT to discuss the issue intelligently and show where he's incorrect with this. So in general, what are the advantages/disadvantages of using CF in conjunction with XML/XSLT over just using XML/XSLT alone? Any suggestions are appreciated. He's right, that XSLT can be used for any data display needs. However, writing XSLT is ... comparatively painful. As in, tear-your-own-head-off painful. I write XSLT for use with Google appliances pretty often, and, well, yecch. I suggest you have him write a sample XSLT stylesheet (and accompanying XML data file, which would still need to be generated in something like CF in the vast majority of cases) while at the same time, you write a CF page to generate your HTML. Bet him something big, like his job vs your bonus. Then, enjoy your winnings! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274537 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Listing TODOs in CF files
Thanks Claude, that looks impressive. I don't pay for code though - let me know when it's open-source. ;) I'm sure there has to be a better way of doing it than that, You're quite right: Have a look at CF_REextract: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274538 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Listing TODOs in CF files
I don't pay for code though - let me know when it's open-source. ;) Out of curiosity, do you get paid for writing code yourself? I'm genuinely curious. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274539 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Listing TODOs in CF files
Pete, I don't know what the REExtract thing does exactly, but it might be something like this: http://www.bennadel.com/index.cfm?dax=snippets:11.view This users Java regular expressions to grab all matching content and return it in a ColdFusion array. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 5:27 PM To: CF-Talk Subject: Re: Listing TODOs in CF files Thanks Claude, that looks impressive. I don't pay for code though - let me know when it's open-source. ;) ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274540 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Listing TODOs in CF files
Another option at CFLIB - http://www.cflib.org/udf.cfm/reget On 4/4/07, Ben Nadel [EMAIL PROTECTED] wrote: Pete, I don't know what the REExtract thing does exactly, but it might be something like this: http://www.bennadel.com/index.cfm?dax=snippets:11.view This users Java regular expressions to grab all matching content and return it in a ColdFusion array. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Peter Boughton [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 5:27 PM To: CF-Talk Subject: Re: Listing TODOs in CF files Thanks Claude, that looks impressive. I don't pay for code though - let me know when it's open-source. ;) ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274541 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hardware load balancers (lower-end)
I have used both Radware WSD and Cisco Content Services Switch. Both worked fine for me. Not *cheap* though. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 6:58 AM To: CF-Talk Subject: Hardware load balancers (lower-end) Folks, I'd like to know what you're using for lower-end *hardware* load balancing for your ColdFusion apps. I've got an application to deal with that doesn't have a lot of network bandwidth but does have a lot of processor load, so I don't need a paired set of BIGIPs to manage it :) I'd prefer a packaged hardware solution that supports sticky sessions -- the app was not really designed for clustering. Something like an old Cisco LocalDirector off ebay is probably about the right speed! Details: CFMX7 *Standard*, servers are Windows 2003, Web edition. Using java sessions. Currently using Sonicwall and Cisco in the network infrastructure. Thoughts/recommendations? -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274542 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WSE Security - anyone have any experience with it?
Thanks Dave and Kevin, this is indeed very helpful. The plan is at business plan stage now. I was asked does this WSE Security thing mean it's going to be doable if we go ahead or not? The management people are discussing all the business and legal aspects of the two sites working together, and if they go ahead, then the two sites are going to have to pass a lot of info back and forth including money and personal information. Their site is much bigger than ours and they use WSE Security. So we needed to know up front if it's going to be doable or not. The deal they're talking about is far bigger in impact than the technical issue of the web site. If it comes down to it, the IT guys are going to be told make it happen, dont give me reasons why it cant be done. If you have problems, get around them! So at this point we needed to know if 'they, a much bigger site than ours will need to be asked to change the way they handle security. Not a good look for this deal. The bottom line, for now, is that it's tricky and messy but doable, I think. When/if the deal proceeds it'll be some late nights and studying I think. 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 4/4/07, Kevin Aebig [EMAIL PROTECTED] wrote: I first looked into this and than we decided to simply run authentication over SSL to protect our services. In our situation, the amount of development didn't justify the end result. We also found that even with the Java upgrade to allow the Encrypt tag more functionality, we had problems as .NET defaults to UTF-16 whereas CF uses UTF-8 which can play havoc while passing encoded initialization vectors and encrypted strings. If you end up trying to conquer this, let me know and I'd be happy to work on this with you. Cheers, ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274543 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: advantages/disadvantages of using CF and XSLT.
XML/XSLT does not query databases or produce structures that can be forwarded to web services and other applications. CF is a good framework/backend tool that can serve raw data to be altered by XSL. - Original Message From: Larry Lyons [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, April 4, 2007 12:09:00 PM Subject: SOT: advantages/disadvantages of using CF and XSLT. Greetings, Have a general question about XML/XSLT and CF. One of the powers that be is making noises about limiting the use of CF etc., etc., etc. One of the arguments he's using is that XML/XSLT can handle most data display. Unfortunately I know know enough about XML/XSLT to discuss the issue intelligently and show where he's incorrect with this. So in general, what are the advantages/disadvantages of using CF in conjunction with XML/XSLT over just using XML/XSLT alone? Any suggestions are appreciated. thx, larry ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274544 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hardware load balancers (lower-end)
Radware!!! :) but $$$ Russ is onto something there with LVS. All a radware is, is a PC running their version of linux Eric On 4/4/07, Jacob [EMAIL PROTECTED] wrote: I have used both Radware WSD and Cisco Content Services Switch. Both worked fine for me. Not *cheap* though. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 6:58 AM To: CF-Talk Subject: Hardware load balancers (lower-end) Folks, I'd like to know what you're using for lower-end *hardware* load balancing for your ColdFusion apps. I've got an application to deal with that doesn't have a lot of network bandwidth but does have a lot of processor load, so I don't need a paired set of BIGIPs to manage it :) I'd prefer a packaged hardware solution that supports sticky sessions -- the app was not really designed for clustering. Something like an old Cisco LocalDirector off ebay is probably about the right speed! Details: CFMX7 *Standard*, servers are Windows 2003, Web edition. Using java sessions. Currently using Sonicwall and Cisco in the network infrastructure. Thoughts/recommendations? -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Listing TODOs in CF files
On 4/4/07, Peter Boughton [EMAIL PROTECTED] wrote: I need to get a list of all the TODOs in a list of (primarily .cfm) files. In the unlikely event of people not being familiar with TODOs, they're just CFML comments like this: !--- TODO: Thing I have to do --- The presence of the TODO: then flags up that something needs to be addressed. Very useful when you want to shove in some dummy data and return later to fix it. (Good editors can flag TODOs - eg: CFEclipse puts a blue bar next to the scrollbar) My Dp_Libraries has a mechanism for doing this. Not a TODO but that could be done in the same way. I use a custom HTML tag called dpDoc - I document all sorts of things with it not handled by CF natively: revision information, author information, plans (the equivalent of TODO), and some method-specific stuff (return and exception information). Information here: http://www.depressedpress.com/Content/Development/ColdFusion/DPLibraries/Art icles/Tutorial_DPCFCs/DPDocs.cfm Both CF and HTML ignore the tag so it works out well. I've got a documentation CFC that provides methods for extracting this information (and in the case of CFCs combining it with the standard CF introspection data). Another long URL: http://www.depressedpress.com/Content/Development/ColdFusion/DPLibraries/Doc umentation/DocViewer.cfm?Component=cfc_DepressedPress.Utility.DP_Documentati on Note that the documentation for all the CFCs is generated using this component. I've been exceedingly pleased with this system. All the code is open-source so you might get some ideas or find something worth ripping. Jim Davis ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274546 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Quick Books Import
I am looking for someone who is familiar with quick books. I have a customer who has about 30 online orders per day. The orders are not tied into quick books in any way so at the end of each day the customer has to go back and manually insert each order. I have never used Quick Books and I am not sure where to begin. Does anyone know of a batch import through xml or csv? If so I think it would be really easy for me to provide the customer a download of these orders in one of those formats so they can enter them much quicker. Any help is grateful. -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274547 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Books Import
I can't really answer your question, but I do know that Quicken can import a correctly formatted file. I used to use a tool on my Palm that would dump out a plain text file, and then Quicken could import it. Do some googling, I'll bet there's a way to do it. On 4/4/07, Dan Vega [EMAIL PROTECTED] wrote: I am looking for someone who is familiar with quick books. I have a customer who has about 30 online orders per day. The orders are not tied into quick books in any way so at the end of each day the customer has to go back and manually insert each order. I have never used Quick Books and I am not sure where to begin. Does anyone know of a batch import through xml or csv? If so I think it would be really easy for me to provide the customer a download of these orders in one of those formats so they can enter them much quicker. Any help is grateful. -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hardware load balancers (lower-end)
Isn't that what all these boxes are? Just some of them are not standard PC's are using customized versions of Linux... It looks like it's really easy to set things up with Apache 2.2... From docs: http://httpd.apache.org/docs/2.2/mod/mod_proxy.html ProxyPass /special-area http://special.example.com/ smax=5 max=10 ProxyPass / balancer://mycluster stickysession=jsessionid nofailover=On Proxy balancer://mycluster BalancerMember http://1.2.3.4:8009 BalancerMember http://1.2.3.5:8009 smax=10 # Less powerful server, don't send as many requests there BalancerMember http://1.2.3.6:8009 smax=1 loadfactor=20 /Proxy So looks like it support sticky sessions, and different load methods... And the bonus is if you don't feel like setting up a linux server, you can just install Apache on windows (you can even do it in VMWare, and my guess is you're not even going to notice it, as it won't produce any load). I haven't tried it myself yet, we use a shared LB at HostMySite, but I'd be interested to know if anyone's set this up. Russ -Original Message- From: Eric Haskins [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 7:58 PM To: CF-Talk Subject: Re: Hardware load balancers (lower-end) Radware!!! :) but $$$ Russ is onto something there with LVS. All a radware is, is a PC running their version of linux Eric On 4/4/07, Jacob [EMAIL PROTECTED] wrote: I have used both Radware WSD and Cisco Content Services Switch. Both worked fine for me. Not *cheap* though. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 6:58 AM To: CF-Talk Subject: Hardware load balancers (lower-end) Folks, I'd like to know what you're using for lower-end *hardware* load balancing for your ColdFusion apps. I've got an application to deal with that doesn't have a lot of network bandwidth but does have a lot of processor load, so I don't need a paired set of BIGIPs to manage it :) I'd prefer a packaged hardware solution that supports sticky sessions -- the app was not really designed for clustering. Something like an old Cisco LocalDirector off ebay is probably about the right speed! Details: CFMX7 *Standard*, servers are Windows 2003, Web edition. Using java sessions. Currently using Sonicwall and Cisco in the network infrastructure. Thoughts/recommendations? -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Books Import
I am looking for someone who is familiar with quick books. I have a customer who has about 30 online orders per day. The orders are not tied into quick books in any way so at the end of each day the customer has to go back and manually insert each order. I have never used Quick Books and I am not sure where to begin. Does anyone know of a batch import through xml or csv? If so I think it would be really easy for me to provide the customer a download of these orders in one of those formats so they can enter them much quicker. Any help is grateful. I looked into doing this in the past, Intuit has some third-party solutions that will give you an API to run through to generate an import file, then you had to manually import the transactions. This was in 2003 though, not sure what has updated since then. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick Books Import
-Original Message- From: Dan Vega [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 9:08 PM To: CF-Talk Subject: Quick Books Import I am looking for someone who is familiar with quick books. I have a customer who has about 30 online orders per day. The orders are not tied into quick books in any way so at the end of each day the customer has to go back and manually insert each order. I have never used Quick Books and I am not sure where to begin. Does anyone know of a batch import through xml or csv? If so I think it would be really easy for me to provide the customer a download of these orders in one of those formats so they can enter them much quicker. Any help is grateful. We did this years ago when the company was going through a fat client phase having purchased a stake in Managing Your Money. It's actually not that hard - the Quicken File format (QIF file) is really pretty simple: plain text and easy to generate in CF (probably easier since the last time I did it was using CF 2.0). Here's some docs: http://web.intuit.com/support/quicken/2002/win/1177.html Unfortunately it looks like Quicken is moving away from QIF and towards OFX (Open Financial Exchange) - but you may still be able to do what you want with QIF. If they don't let you do this with QIF it doesn't look like there's much other choice for small shops: you'll have to call Intuit and ask what they suggest. Jim Davis ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4