Re: Source control in CF
Why not just have a local VMware image for developer unit testing? Sent from my iPhone On Jan 31, 2013, at 7:51 AM, Michael Christensen mich...@strib.dk wrote: First of, let me thank all of you for your (quite lively) inputs. The discussion did spiral a bit out of control in a GIT vs SVN tussle, but I understand and can respect that people have strong opinions as to which systems they prefer. I also wholeheartedly agree, that there are certain advantages to be gained by each developer having a working copy of the code on their local machines. I would, however, contest the absoluteness of this as the only way to go. While it is true, that the CF Developer licensing does allow for each developer to run a CF server locally without paying a license fee, the time spent by the IT department setting up and supporting 50+ websites (plus our backend/admin software) on each developer machine does come at a cost. Add in the cost of additional licenses for 3rd party components (like ImageGlue or ISAPI rewrite for example) and the cost of being able to run code locally can add up quite quickly. For us at least, running on a shared codebase with 1 development server and all code available via a webpath (usually mounted as a drive for convenience) works quite well and has done so without major snafus for 10+ years. Is this an oldschool approach? Very much so. Is it a good solution? Maybe not for every company, but it works for us. I understand, that our setup makes running version/source control very difficult and it is a conclusion that I feared I might reach, when I posted the question initially. I think that I may have to go back and have a long, hard think about how we will proceed from here. If any of you, who are running a setup where each developer runs the code locally, I would be very appreciative if you could give me 30 minutes to an hour of your time, so I might pick your brain as to how you have gone about getting this setup and how you maintain it (I think this is probably best done over Skype). So once again, thank you guys so much for all your input :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF MX inserting xmlns:xsi into my WSDL
CF MX is over-riding my WSDL definitions. Where I have: wsdl:types s:schema elementFormDefault=qualified targetNamespace=http://developer.intuit.com/; s:element name=serverVersion /s:element s:element name=serverVersionResponse s:complexType s:sequence s:element minOccurs=1 maxOccurs=1 name=serverVersionResult type=s:string / /s:sequence /s:complexType /s:element The Service Call results in: ?xml version=1.0 encoding=utf-8?soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Body ns1:serverVersionResponse soapenv:encodingStyle=http://schemas.xmlsoap.org/soap/encoding/; xmlns:ns1=http://qbwc.opensource; serverVersionReturn xsi:type=xsd:stringTesting/serverVersionReturn /ns1:serverVersionResponse /soapenv:Body /soapenv:Envelope What is going on??? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322134 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Hand Crafting Soap Response
I can not get MX 8 to return the following: ?xml version=1.0 encoding=UTF-8? SOAP-ENV:Envelope xmlns:SOAP-ENV=http://schemas.xmlsoap.org/soap/envelope/; xmlns:ns1=http://developer.intuit.com/; SOAP-ENV:Body ns1:authenticateResponse ns1:authenticateResult ns1:string15c9ce293bd3f41b761c21635b14fa06/ns1:string ns1:string/ns1:string /ns1:authenticateResult /ns1:authenticateResponse /SOAP-ENV:Body /SOAP-ENV:Envelope I am currently using the following CFC: CFCOMPONENT style=RPC namespace=http://developer.intuit.com/; bindingname=http://developer.intuit.com/; cffunction access=remote name=serverVersion output=no returntype=string cfreturn Testing /cffunction cffunction access=remote name=clientVersion output=no returntype=string cfargument name=strVersion type=string required=yes cfreturn O:2.0.0.135 /cffunction cffunction access=remote name=authenticate output=no returntype=any cfargument name=strUserName type=string required=yes cfargument name=strPassword type=string required=yes cfset var arrayOut = arrayNew(1) / cfset arrayOut[1] = session.sessionID / cfset arrayOut[2] = nvu / cfreturn arrayOut /cffunction /CFCOMPONENT How can I return this Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322128 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Creating well formed SOAP Response
I can not get MX 8 to return the following: ?xml version=1.0 encoding=UTF-8? SOAP-ENV:Envelope xmlns:SOAP-ENV=http://schemas.xmlsoap.org/soap/envelope/; xmlns:ns1=http://developer.intuit.com/; SOAP-ENV:Body ns1:authenticateResponse ns1:authenticateResult ns1:string15c9ce293bd3f41b761c21635b14fa06/ns1:string ns1:string/ns1:string /ns1:authenticateResult /ns1:authenticateResponse /SOAP-ENV:Body /SOAP-ENV:Envelope I am currently using the following CFC: CFCOMPONENT style=RPC namespace=http://developer.intuit.com/; bindingname=http://developer.intuit.com/; cffunction access=remote name=serverVersion output=no returntype=string cfreturn Testing /cffunction cffunction access=remote name=clientVersion output=no returntype=string cfargument name=strVersion type=string required=yes cfreturn O:2.0.0.135 /cffunction cffunction access=remote name=authenticate output=no returntype=any cfargument name=strUserName type=string required=yes cfargument name=strPassword type=string required=yes cfset var arrayOut = arrayNew(1) / cfset arrayOut[1] = session.sessionID / cfset arrayOut[2] = nvu / cfreturn arrayOut /cffunction /CFCOMPONENT Which results in: ?xml version=1.0 encoding=utf-8?soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; soapenv:Body ns1:authenticateResponse soapenv:encodingStyle=http://schemas.xmlsoap.org/soap/encoding/; xmlns:ns1=http://developer.intuit.com/; authenticateReturn soapenc:arrayType=xsd:anyType[2] xsi:type=soapenc:Array xmlns:soapenc=http://schemas.xmlsoap.org/soap/encoding/; authenticateReturn xsi:type=soapenc:stringOPENBIZSERVICES_1100_fc628b1a724586e2-0388B878-E314-91DC-18B3413A8704776F/authenticateReturn authenticateReturn xsi:type=soapenc:stringnvu/authenticateReturn /authenticateReturn /ns1:authenticateResponse /soapenv:Body /soapenv:Envelope How can I fix this? Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322129 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Simple Webservice error under CF V8
Can anyone help me understand why the following simple code is throwiing an error. I get this error: Detail The fault returned when invoking the web service operation is:br pre'' java.lang.NullPointerException/pre Message Cannot perform web service invocation authenticate. when this routine routine: cfset ws = CreateObject(webservice, http://localhost/opensource/QBWC_Shell.cfc;) / cfset ret = ws.clientVersion(strVersion=2.0.0.135) / cfset soapresp = GetSOAPResponse(ws) h2SOAP Response for clientVersion/h2 cfdump var=#soapresp# cfset ret = ws.authenticate(strUserName=User, strPassword=PW) / cfset soapresp = GetSOAPResponse(ws) h2SOAP Response for authenticate/h2 cfdump var=#soapresp# Calls this WebService: CFCOMPONENT style=RPC namespace=http://developer.intuit.com/; cffunction access=remote name=clientVersion returntype=String cfargument name=strVersion type=string required=yes cfreturn O:2.0.0.135 /cffunction cffunction access=remote name=authenticate returntype=array cfargument name=strUserName type=string required=yes cfargument name=strPassword type=string required=yes cfset var aryReturn = arrayNew(1) / cfset arrayAppend(aryReturn, ) cfset arrayAppend(aryReturn, nvu) cfreturn aryReturn /cffunction /CFCOMPONENT Any help much appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple Webservice error under CF V8
Ok, I've traced the issue down to trying to return an array. How do I do this under V8? I had no issues with 7.5. Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOAP XML Respone Example from CFC
What does the SOAP XML Response document returned from a web services call to a CFC look like? Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Creating Web Service for QuickBooks Web Connector
Have any of you created a Web Service that works with QuickBooks web connector? It looks like I am having an issue with CF SOAP Style and I've checked a couple and gotten the same error: 20090105.04:43:12 UTC : QBWebConnector.SOAPWebService.do_authenticate() : *** Calling authenticate() with following parameters:userName=iqbal1password=MaskedForSecurity 20090105.04:43:12 UTC : QBWebConnector.SOAPWebService.do_authenticate() : QBWC1012: Authentication failed due to following error message. Object reference not set to an instance of an object. More info: StackTrace =at QBWebConnector.WebService.do_authenticate(String ticket, String companyFileName) Source = QBWebConnector 20090105.04:43:12 UTC : QBWebConnector.RegistryManager.setUpdateLock() : HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\UpdateLock has been set to False 20090105.04:43:12 UTC : QBWebConnector.RegistryManager.setUpdateLock() : * Update session unlocked * 20090105.04:43:12 UTC : QBWebConnector.WebServiceManager.DoUpdateSelected() : Update completed with errors. See log (QWClog.txt) for details. By testing CFC: CFCOMPONENT name=wsdlTest displayname=wsdlTest output=no cffunction access=remote name=authenticate output=true returntype=array cfargument name=strUserName type=string required=yes cfargument name=strPassword type=string required=yes cfset var aryReturn = arrayNew(1) !--- The first element is a token for the web connectorâs session with the web service on behalf of the authenticated user. This token will be passed back to your web service in every subsequent call (in the ticket parameter!) until the current data exchange session is finished --- cfset aryReturn[1] = #session.sessionID# !--- The second element contains one of these possible string values: If your web service doesnât grant access to the username and/or password supplied in the authenticate call from the web connector, specify the string nvu which indicates non valid user credentials (bad user name and/or password). If the web service has no data to exchange with the userâs QuickBooks or QuickBooks POS company, specify the string none. To use the currently open company, specify an empty string. To specify a particular company, supply the full pathname of that company. --- cfset aryReturn[2] = none !---The third element (optional) contains the number of seconds to wait before the next update. ⢠The fourth element (optional) contains the number of seconds to be used as the MinimumRunEveryNSeconds time--- cfreturn aryReturn /cffunction cffunction access=remote name=clientVersion output=true returntype=string cfargument name=productVersion type=string required=yes cfreturn /cffunction cffunction access=remote name=closeConnection output=true returntype=string cfargument name=ticket type=string required=yes cfreturn Success /cffunction /cfcomponent I'd appreciate any recommendations or examples or links to reading. This is my first excursion into the land of web services and SOAP. Thanks, Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
DB Design, Engineering Re-Engineering Software
Any recommendations on DB software much less expensive then Erwin? Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207304 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DB Design, Engineering Re-Engineering Software
I've got VISIO, imports, but won't create DDL's in any of the stand-alone versions. -Original Message- From: Michael T. Tangorre Visio -Original Message- From: Andy Ousterhout Any recommendations on DB software much less expensive then Erwin? Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207319 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DB Design, Engineering Re-Engineering Software
Looks like it only works with MySQL and I use MS SQL. -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 4:31 PM To: CF-Talk Subject: RE: DB Design, Engineering Re-Engineering Software I use dbdesigner by fabforce Fabforce.net Open source project ;) Pat -Original Message- From: Dave Merrill [mailto:[EMAIL PROTECTED] Sent: May 20, 2005 16:40 To: CF-Talk Subject: RE: DB Design, Engineering Re-Engineering Software Haven't gotten around to actually trying it, but DDS-Lite looks good: http://www.dds-lite.com/ Interesting bullets from their feature list: --- - Enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, complete with Cascading Referential Integrity Constraints, Indexes, Checks, Defaults and Unique constraints. - Data Structure Diagram that is created automatically from the Enhanced Entity Relationship Diagram shows the complete table structure. - Data Definition Language (DDL) Scripts for creating, dropping and loading the database can be quickly and easily generated for all of the supported database servers. - Cross DBMS Target Compatibility allows you to design once and create for all. No need to concern yourself with vendor specific variations to SQL syntax. All is handled by the application. - Supports All Major Databases including Oracle, DB2, SQL Server, Informix, Sybase (ASA and ASE), MySQL, PostgreSQL, Interbase, Access, SQLBase, Ingres, ANSI and Pervasive SQL. - Template Language to define the Data Definition Language scripts allows you to create the scripts exactly as you want them. - Java Source Code can be created directly from the Enhanced Entity Relationship Diagram to contain the Data Definition Language for any of the supported database targets. Source code can be compiled and executed from within the DDS-Lite environment. --- The $100 version doesn't do views, procedures, triggers, reverse engineering from existing dbs, or splitting big projects into multiple models. The $400 version does. Dave Merrill Any recommendations on DB software much less expensive then Erwin? Andy ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207321 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DB Design, Engineering Re-Engineering Software
I don't see a version that I can buy solo that creates DDL. What am I missing? I own Professional. Andy -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 6:31 PM To: CF-Talk Subject: RE: DB Design, Engineering Re-Engineering Software Yeah, I would say Visio. (I personally use ER/Studio, but it is a bit pricy, too.) M!ke -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 2:49 PM To: CF-Talk Subject: RE: DB Design, Engineering Re-Engineering Software Visio Michael T. Tangorre -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 3:46 PM To: CF-Talk Subject: DB Design, Engineering Re-Engineering Software Any recommendations on DB software much less expensive then Erwin? Andy ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207322 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
JS Question
I would like to be able to display alternate text when a User Mouse Over's a submit button and have the text displayed similar to how Alt Text works with links. Now could I do this? Andy ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206711 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: JS Question
Thanks. -Original Message- From: Ewok Use the title attribute for the tool tip If you are wanting the actual text on the button changed.. use Onmouseover=this.value='Mouse On Danielson'; OnMouseout=this.value='Mouse Off Danielson'; -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 11:27 AM To: CF-Talk Subject: JS Question I would like to be able to display alternate text when a User Mouse Over's a submit button and have the text displayed similar to how Alt Text works with links. Now could I do this? Andy ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206714 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Obscure null errors
I think that means that either your CF code or perhaps a procedure was trying to do something with a null db value. I'd start by checking your queries and stored procs for math operations when one of the values might be null. In these cases, use IsNull(columname, 0). Andy -Original Message- From: Duncan On our cf7 jrun4 server we are coming across these errors in the error.diagnostic variable: null null The error occurred on line -1. There is nothing in the application or exception logs for the cf server in question. Can anyone help me in tracking down the problem? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206515 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sessions and File/New/Window in IE
Thanks Justin Marlon for the explanations. Andy -Original Message- From: Justin D. Scott Subject: RE: Sessions and File/New/Window in IE This is the way it's supposed to work. If you choose File-- New Window, the new window will be an extension of the current session. If you choose Start--Program Files--Internet explorer, you will get a new session with new session variables. I'm not sure of a work around because it's dependent upon how IE acts. This works because when you open a new window from within an open IE session it will share the session cookies with the windows within that copy of IE. If you open a new instance of IE from the Start menu it will not share the session cookies from the other copy of IE that is open. If your session variables are using CF token variables on the URL then you will get the same session no matter where you are. If you're using session cookies then it SHOULD give you a new session. When I say session cookies I'm talking about cookies that expire when the browser closes, not the cookies CF uses to define its session scope. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206165 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Sessions and File/New/Window in IE
When I create new window in IE, MX 7 does not appear to be creating a new session; one window can change the other window's session variables. Is this the way it is supposed to work? If so, any suggestions on how I can make it act like two different sessions? Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206155 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sessions and File/New/Window in IE
Just tried it, same results - no new session. -Original Message- From: Marlon Moyer This is the way it's supposed to work. If you choose File-- New Window, the new window will be an extension of the current session. If you choose Start--Program Files--Internet explorer, you will get a new session with new session variables. I'm not sure of a work around because it's dependent upon how IE acts. On 5/9/05, Andy Ousterhout [EMAIL PROTECTED] wrote: When I create new window in IE, MX 7 does not appear to be creating a new session; one window can change the other window's session variables. Is this the way it is supposed to work? If so, any suggestions on how I can make it act like two different sessions? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206157 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Database Driven Nav
Stan, I'd like a copy as well. Andy ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206015 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Controlling printers
For posterity CFDocument lets me set print size, I can replicate number of copies functionality with a loop, so basically gives me what I need without paying $500 for an ActiveX, which seems to be the current price for this functionality Andy -Original Message- From: Andy Ousterhout Sent: Wednesday, May 04, 2005 9:41 AM To: CF-Talk (E-mail) Subject: Controlling printers I would like to be able to do a number of print operations from my website. Is there an ActiveX or some other control that I can use on local devices to initiate printing. I'd like to be able to control Printer device selection, number of copies and paper size from an HTML page. While free is nice, I am willing to pay for this. Regards, Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205683 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Controlling printers
I would like to be able to do a number of print operations from my website. Is there an ActiveX or some other control that I can use on local devices to initiate printing. I'd like to be able to control Printer device selection, number of copies and paper size from an HTML page. While free is nice, I am willing to pay for this. Regards, Andy ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205513 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Client.LastVisit
Look at application.cfc onSessonEnd() Andy -Original Message- From: Marcus Svensson I don't care about the lastVisit anymore. It does what it's supposed to do. I just want to know if there is a way to do almost the same as lastVisit does, but only updates the parameter when the user has left the webpage. Since the function I'm looking for is used in CFForum and other forums, there must be a way. :-) Maybe if it could be done with sessions. When the user leave the page and the session is closed, maybe the database can save the current time. And the next time the user visits the page, the time is read from the database to a parameter. Though I'm not sure if that's possible to do. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204684 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Database Question
What is the database? SQL 7, Oracle, Access, ? -Original Message- From: Ali Awan I have a question regarding ColdFusion and database requests. I have 2 applications on different servers, Server A and Server B and they both access a database on Server C. The problem is that recently that App1 on Server A and App2 on Server B ended up hitting the database at the same time. They both have identical code to insert a new record and whose ID is created by selecting a max id and incrementing it. They both ended up with the same ID. What is the best way to avoid this? I know that it is not possible to lock queries. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203609 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last ID inserted
Is there any difference then between scope_identity() and @@Identity? Is one faster? -Original Message- From: Robertson-Ravo, Neil (RX) [ Exactamundo Clint, Which is what I do... one insert - one @@identity grab -Original Message- From: Clint Tredway That will work if you only need that first @@Identity... but if you need both of the inserts just returning @@Identity will not work... you will have to set it after each insert... my 2 cents... On 4/18/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Whoah there horsey - both of your last posts were unnecessary. Paul is exactly correct - the BOL does *NOT* say or advise or warn against using any method. As you will have seen from posts over the years he is a very advanced developer who offers educated and informed technological insights (just don't get him started on Unicode) - he asked a question - as did I about where BOL mentioned this oddity, I have used SQL Server for a long time and never once see or had a behaviour where I was not to use @@. Take this case If I am running an SP which does an insert and I have a @@IDENTITY after the insert then it will ALWAYS give me the correct entry for that last run insert in that scope - i.e. the SP, not matter how many people run it at the same time. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:08 To: CF-Talk Subject: Re: Last ID inserted I already spelled it out twice, and with the quote of Michael's (who beat me to the punch there by about 4 minutes) there are the references from the BoL. A lot of people have the wrong idea about what @@IDENTITY does, and as a result are open to risk. If you can't see that in what I wrote, I dont know how you got to where you are in this business. My absolute last on this subject. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 4/19/05, Paul Hastings [EMAIL PROTECTED] wrote: Mike Kear wrote: Ok Paul please yourself I dont care a *^$. Life's too short to argue. who's arguing? i was just asking you to clarify your opinions. which you aren't doing. so i guess that's the end of that. You do whatever the hell you like. well i do *like* facts to be factual. how about you? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What hard drive would you buy?
Thanks to everyone for the clarification. Andy -Original Message- From: Jim Davis? The best SCSI out there now (what Super, ultra, buttload SCSI or something) is still considered by the geek set as the best but it's also still pricey as all hell. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202755 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What hard drive would you buy?
I was told by a few people that SCSI is fairly old technology and that today's IDE is better as is SATA. What are your thoughts? Andy -Original Message- From: Justin D. Scott If you had to chose between two hard drives, which one would you buy? If you're planning on doing any heavy database access, go for the SATA or even SCSI if you can afford it. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202666 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Built a dirty word checker, testing please?
Dirty Dutchman, DIRTY! -Original Message- From: Jochem van Dieten âççéñţ throws it off too and it doesn't understand Dutch. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202082 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Password management Best Practices
I use MD5 hash available on http://www.cflib.org. When someone forgets a password, I email them a temporary password that must be changed immediately upon use. I also email them whenever anything on their profile, including password, is changed. When someone calls in, we do the same thing on their behalf. No one but the User ever sees their password Andy -Original Message- From: Mark Leder Hi all, I've been pondering the problem of password storage in a db and its retrievability, and was wondering what other people have done in the following situations: 1) What method(s) used for password encryption (salt and hash). What tag(s) do you use? 2) When someone forgets their password, how would an encrypted password be de-salted/de-hashed and displayed on a screen? (I would display the password when the userenters their emal AND correctly responds to a challenge question - I never send passwords via email, as I have seen done on many ecommerce sites). Thanks, Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201847 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Password management Best Practices
Probably just ignorance. Can someone more familiar with both explain the difference? -Original Message- From: Kerry just wondering: is there any particular reason why you dont just use CF's built in hash() function? -Original Message- From: Andy Ousterhout I use MD5 hash available on http://www.cflib.org. When someone forgets a password, I email them a temporary password that must be changed immediately upon use. I also email them whenever anything on their profile, including password, is changed. When someone calls in, we do the same thing on their behalf. No one but the User ever sees their password Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201864 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generating BarCodes in CF
Sorry to join in late. I use CF_BarCode: Company : fusionZONE, Inc. Application : barcodeZONE Version : 1.0 Build Date: 03/18/2004 Developer : Kevin Maloy Copyright (c) 2004 fusionZONE, Inc. All Rights Reserved http://www.fusionzone.com DO NOT REMOVE THIS NOTICE Works like a charm. Andy -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:31 AM To: CF-Talk Subject: RE: Generating BarCodes in CF John, Yes, it is available in a font. The font is called PDF417, I believe. This sounds like the direction I may want to go in. Can you elaborate on how I could do that? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201528 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Hosting for SEMI dedicated
What is SEMI dedicated? Is this like almost pregnant? -Original Message- From: Mickael Hi All, I know that hosting has been discussed many times on this list. But I would still like to know who the stars are. I am presently hosting with Hostmysite.com and crystaltech.com but as of late their machines are getting overloaded. I am looking for semi dedicated hosting for CF 6.1 and SQL server. Can anyone recommend a company that they have had a good experience with? The two companies that I am with answer the phone 7/24 which is a big plus as well. Thanks Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What to do - stagnant job
In today's job market, I'd recommend following Sean's advice with one caveat -- find another job before you leave. Otherwise you will have a gap in your resume that will raise questions about why you left. Andy -Original Message- From: Sean Corfield I quit. Then went and looked for a new job. I've always given people the same advice: if you're not happy with your job, quit. Don't bitch about it, don't expect it will get better, just quit. Then go out and look for something better. One caveat: if you think you have a great boss, approach them first and tell them you're bored / unhappy and explain what you'd like to be doing. If the company can offer you that, cool, otherwise quit. Remember that we spend about a third of our lives working (and a third sleeping!) so we'd damn well better enjoy that large part of our lives! :) -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198882 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application.cfc - why? what's it for?
Thanks. I like the methods, just wasn't sure how I would deal with redirection. It sounds like the consensus is that it is very appropriate to do a redirect from the Application.cfc Thanks, Andy -Original Message- From: Jared Rypka-Hauer Andy, If I understand correctly, it's an either/or situation. There was a similar conversation on CFCDev the other day, although it was mostly centered on extending application.cfc, and the concensus was that they should be used as intended, even if there were ways of doing customized versions of them The point with application.cfc is twofold, from my perspective... one is to facilitate the new events-style method triggers (onApplicationStart, onApplicationEnd, onSessionStart, onSessionEnd, onRequest, onRequestStart, and onRequestEnd), and the other is based on the first... facilitate a higher degree of standardized application management. It makes for a cleaner system when the application is managed by a subsystem that's very similar to the rest of the implementation. In this case, rather than storing an independed CFC in the application scope, the application scope itself becomes a CFC... so method calls change when dealing with application-scope CFCs... from application.myCFC.methodCall() to application.methodCall(). It also allows the application-scope CFC to maintain private data in it's variables scope and public data in it's THIS scope... There's also no convenient way to manage the onRequest, onRequestStart and onRequestEnd events... any other way of dealing with them are going to be messy and incomplete at best. And, since there IS no other way to manage the on*End() for session and application, application.cfc represents some functionality that we've simply never been able to accomplish before, in any way. I don't think it's too messy to have an application.redirect(location,addToken) method... since that method is based on getPageContext().forward(), it's just mirroring the underlying Java to accomplish the same thing. I did a site that made heavy use of cfscript to manipulate CFC instances, and I wrote a UDF to provide exactly that call... worked perfectly, too. To answer your question, where you have 2 files with the same stem and different suffixes, the system has always resolved them in alphabetical order... hence application.cfc would fire first. The real question is whether or not they're both automatically utilized when they both exist. Index.cfm will be chosen over index.html where they both exist because cfm is earlier in the alphabet than html... since index.cfm takes over, index.html never gets touched. But I don't know if application.cfc will execute and the normal auto-include will fire for application.cfm after that. Laterz, J On Sun, 13 Mar 2005 13:20:38 -0600, Andy Ousterhout [EMAIL PROTECTED] wrote: Jim, I am just concerned that redirecting out of a CFC might create sloppy code. I would probably want to continue to use Application.cfm for the redirecting or use an include at the top of every page. Can I use both Application.cfm and Application.cfc? If so, what order do they get executed in? Andy -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: E-commerce - Make them register or don't make them register
Entering information because it is needed to complete an order is no burden on the purchaser. Asking them to enter it before they even have decided to order is. My experience is that you turn off potential buyers and if they enter any info at all, it is all junk. My recommendation is not to let marketing get in the way of a buy transaction. -Original Message- From: Will Tomlinson Ok guys, I just read in my Internet Retailer about how teen shoppers do NOT want to register before shopping online. This plays right into my plan on the Volleyball site as teen shoppers *are* my target audience. My client and myself did not want to force them to register. Some argue that they have to enter all that info anyway when actually making the purchase so what's the big deal? Also, that registration info comes in handy in many different ways. What's everyone's opinion on the matter? Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198728 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: E-commerce - Make them register or don't make them register
Correct. I have no problem entering personal info in order to get Market Reports, Consulting reports, etc. Although I did lie for my Yahoo account and others whom ask too much too early. There is a quid pro quo -- value for value. That is not the case on a shopping web-site. -Original Message- From: Jerry Johnson Not all websites are to make sales. Not all websites should or do have shopping carts. Some websites are for building marketing lists. Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 03/14/05 05:01PM To me, the purpose of a web site is not to build a marketing list. Its to make sales. Anything you do to get in the way of transferring product out of your warehouse and money into your pocket is a detriment to that prime focus, and represents a loss of understanding of what the web site is all about. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198745 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: E-commerce - Make them register or don't make them register
And I don't give them an answer, but they still let me buy the product. That's right, the clerk types in either the store Zip or his/her zip if forced to enter something, skewing the date. But an amazing number people just whip out their zip, phone number, etc without a single thought towards privacy, so it May not hurt to ask. Andy -Original Message- From: Connie DeCinko But to this day, Radio Shack, and many others, still ask for at least your zip code before ringing up a sale. And every time I get a haircut, one of the simplest services, I am asked to provide my telephone number so they can track me. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 3:02 PM To: CF-Talk Subject: Re: E-commerce - Make them register or don't make them register The custoemr is holding money out to you. all you have to do is reach out and take it. If you walk into a store, pick out a product and walk to the cash register, can you ever remember a time when the clerk handed you the money back and asked you for your username and password? To me, the purpose of a web site is not to build a marketing list. Its to make sales. Anything you do to get in the way of transferring product out of your warehouse and money into your pocket is a detriment to that prime focus, and represents a loss of understanding of what the web site is all about. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198747 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application.cfc - why? what's it for?
Jim, I am just concerned that redirecting out of a CFC might create sloppy code. I would probably want to continue to use Application.cfm for the redirecting or use an include at the top of every page. Can I use both Application.cfm and Application.cfc? If so, what order do they get executed in? Andy From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Sat 3/12/2005 2:00 PM To: CF-Talk Subject: RE: Application.cfc - why? what's it for? -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Saturday, March 12, 2005 1:37 PM To: CF-Talk Subject: RE: Application.cfc - why? what's it for? How would I re-direct the page to login.cfm from a CFC? Same way you would from anything else, really. You could use a CFLOCATION tag (that's probably easiest) or set some variable that indicates your state and check it someplace common (for most sites my pages are always wrapped in a wrapper tag but many people also have navigation tags or the like). CFCs really aren't anything super special - don't add anything attributes to them that they don't have. It's easiest to think of them as regular CF pages most of the time. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198603 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application.cfc - why? what's it for?
Barney, What are some of the uses of onApplicationEnd? Andy -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Saturday, March 12, 2005 5:01 AM To: CF-Talk Subject: Re: Application.cfc - why? what's it for? A lot of it depends on how you currently use Application.cfm, and how important the features that you can only get from Application.cfc are. If you're just using Application.cfm for your CFAPPLICATION tag and setting global variables, then Application.cfc isn't going to really do anything for you. The only difference will be that you have to type a bunch of extra CFC-related stuff. However, repackaging Application.cfm in a new way isn't the reason for Application.cfc. With the CFC, you can do a lot of new things that are simply impossible with Application.cfm. For instance, you get events for application end, and session end, neither of which you've the ability to access before. The session end event, in particular, can be very useful for certain applications You also get events for application start, session start, request start/end, and errors. Those are places that you've already had access to, though with the the CFC, the access is much more controlled and abstracted. Application start, moreso than the others, is quite nice, because it lets you iniitalize all your application-scope variable without having to worry about single threading access. Very handy for avoiding subtle little bugs when you're starting up under load. Of course, by leveraging the new events, you do lose a little bit of ad hoc-ness. For example, if you're using a pair of CFIF tags and a CFLOCK tag to protect your application initialization in Application.cfm (the usual way of doing it), it's trivial to restart your application on the fly by simply adding a false to those conditionals. With onApplicationStart, however, you can't do that, becuase CF is internally taking care of the nitty-gritty stuff, so you have to change your application name, or restart CF. Bottom line, Application.cfc has some nice features that you may or may not be useful to you. It also lets you package your app framework code in a far more abstracted way than Application.cfm, which may or may not tickle your fancy. However, even if you don't use any of the cool new things Application.cfc brings to the table, you don't really move backwards at all by starting to use it. And more importantly, when you do need some of the things you can only get with the CFC, you'll already be using it, so you won't have to switch things over at that point. As neat as CF7's feature set is, Application.cfc is probably the best new thing in the release. It doesn't get the press that some other features have gotten, because it's 100% devoid of flashiness, but it's definitely a Good Thing. cheers, barneyb On Sat, 12 Mar 2005 15:27:02 +1100, Mike Kear [EMAIL PROTECTED] wrote: I think the full implications of using application.cfc rather than application.cfm has escaped me. Can someone please elaborate on it for me? Is there a significant added usefulness in handling application-level things in the cfc or is it merely a different way of doing things that we were already doing in the application.cfm? -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198541 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Application.cfc - why? what's it for?
How would I re-direct the page to login.cfm from a CFC? -Original Message- From: Jim Davis -Original Message Jim, So lets say I have code at the top of every page in my application that checks for the existence of certain session variables and if it doesn't find them redirects the user to a login page. Exactly - you would probably do this in the request start method (so that at the beginning of every request this is checked). ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198548 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Unsubscribe by Scott Stroz
Well, we are both Lurkers as well as cowards. Many of you have so much experience with this language that I generally don't answer posts because someone else out their beats me to the punch with a much better answer. So fear of posting an incorrect answer may run high. It does with me :-)) Andy -Original Message- From: Ray Champagne Cool, thanks for the info. I am surprised at the community numbers. I thought it would be less than that. Seems like we have about 50 ppl who post on a normal basis. Lurkers, come out of the woodwork! :) Ray At 01:29 PM 3/11/2005, you wrote: 2669 on CF-Talk 565 on CF-Community We also have a LOT of people on the RSS feeds and using the archives (which have been upgraded again). I don't keep records of when someone leaves a list or joins up. Maybe I should, but it's really useless data to me. What's more important is getting the name of House of Fusion out there as a community resource and providing for the ColdFusion community. I've often wondered how many people actually subscribe to each list (talk and comm). Seems like the same handful post all the time, just wondering how many lurkers are out there. :) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198456 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cftransaction... it wasnt safe?
Just wrap an exclusive lock around the transaction. Make it a named lock that will cross all sessions. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 7:46 AM To: CF-Talk Subject: Re: cftransaction... it wasnt safe? :) thank you adam... any idea, how i could restructure it to achieve that? thanks. tony On Tue, 8 Mar 2005 07:27:37 -0500, Adam Haskell [EMAIL PROTECTED] wrote: I think your concept of how cftransaction works is faulty. The way this is set up it is not keeping 2 Select max(acctno) happening prior to inserting a new record. Adam H On Mon, 7 Mar 2005 23:00:02 -0500, Tony Weeg [EMAIL PROTECTED] wrote: hi there... i have this section of code... that is enrobed in a cftransaction block that somehow today, was caught in a race condition... meaning... i have two records with the same acctNo, and there should only be one! my first thought, now that i look over the code... would it be better for me to use the request scope for the setting of the newAcctNo? help... thanks! tony cftransaction cfquery name=getNewAcctNo datasource=webCollect select max(acctNo) as thisAccountNumber from accts /cfquery !--- sets the new acct number, which is simply, highest current one, plus one. --- !--- this is different than the identity id field... so that i can move it to something else someday :) --- cfset newAcctNo = getNewAcctNo.thisAccountNumber + 1 !--- this query adds the new account information. --- cfquery name=addAccount datasource=webCollect insert into accts (acctNo, clientNumber, debtorNumber, dateIncurred, dateAssigned, dateLastPayment, amountLastPayment, attyFee_actual, principal, preJudgementInt, countyId, balance, attyFeeClaimed, csrId) values (#newAcctNo#,#form.clientNumber#,#form.debtorNumber#,'#form.dateIncurred#','# form.dateAssigned#','#form.dateLastPayment#',#form.amountLastPayment#,#reques t.attyFee_actual#,#form.principal#,#form.preJudgementInt#,#countyId#,#form.pr incipal#, #form.attyFeeClaimed#, #form.csrId#) /cfquery !--- i commit it at this point, so that any future requests will not take my new number, and frankly im done with it... another request would be valid at this point, and they could get at it... --- cftransaction action = commit/ !--- i then use this to get the new identity value --- cfquery name=getNewId datasource=webCollect select @@identity as newAcctId from accts /cfquery !--- and finally get the acct number to validate that it was in fact a good transaction --- cfquery name=getNewAccountNumber datasource=webCollect select acctNo from accts where id = #getNewId.newAcctId# /cfquery /cftransaction -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com He who makes a beast of himself saves himself the pain of being a man... --Hunter S. Thompson. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197833 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ValueList ALWAYS in same order as records in query?
Right. But the plan was to use ListFindNoCase(ValueList, value)) to ID the row, then use array notation to retrieve info. Should this be more effieicent then running a query or loop? The code sure looks cleaner, more readible. -Original Message- From: Dave Watts Will the results from ValueList(query.Column) always list the values in the same order as the records in the query? Yes, it will list the column values in the same order. Can I use the results of a ListFind on the ValueList to index into the query? Presumably, but why go through all that hassle? You can use array notation with query columns. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197676 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Returning 2 queries from stored proc
Couldn't be eaiser! Thanks. -Original Message- From: Michael Dinowitz create proc test as select * from table1 select * from table2 This stored procedure will return both to the cfstoredproc tag How do I define the two result sets in the Stored Proc? I am using MS SQL and I can't find anything in their help guide. -Original Message- From: Michael Dinowitz Yes, but you have to use the CFSTOREDPROC and the CFPROCRESULT. Each CFPROCRESULT will have the query name and the order of it's operation from within the stored procedure. CFSTOREDPROC cfprocresult name=query1 resultset=1 cfprocresult name=query2 resultset=2 /CFSTOREDPROC Is it possible to return two different queries from a single stored proc? Andy Ousterhout ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197677 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ms-sql resources
I got Robert Viera Professional SQL Server 2000 Programming. -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Monday, March 07, 2005 11:01 AM To: CF-Talk Subject: ms-sql resources Does anyone know of any? Or even a good book? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197728 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Returning 2 queries from stored proc
Is it possible to return two different queries from a single stored proc? Andy Ousterhout ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197620 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query Problem
use CFQUERYPARAM value=#newMonth# cfsqltype=cf_sql_integer / for both -Original Message- From: Graham Pearson [mailto:[EMAIL PROTECTED] Sent: Sunday, March 06, 2005 4:16 PM To: CF-Talk Subject: Query Problem I am running into a problem which I have not ran into before. Below is my query cfset newMonth = #Month(DateAdd(n, 1, Now()))# cfset newDay = #Day(DateAdd(n, 1, Now()))# cfset newYear = #Year(DateAdd(n, 1, Now()))# cfquery name=GetClosings Datasource=#Application.Speck.Codb# Select status.CorpNumber, status.UserID, status.EffectiveDate, status.ReportedDateTime, status.Closed, sites.name as CorpName From status, sites Where status.corpNumber = sites.id and Month(Status.EffectiveDate) = variables.newMonth and Day(Status.EffectiveDate) = variables.newDay and Year(status.effectiveDate) = variables.newYear and status.closed = 1 Order by CorpName /cfquery When I run the query I get an error message which states: Base table or view not found message from server: Unknown table 'variables' in where clause I have this same query in another place but instead of variables.newMonth I have #Month(Now())#, Day(Now()), and Year(Now()) which gives me the desired results for today. The above query is supposed to give me results for tomorrow when the current time is past 11:59 AM which I am testing via a cfif just above this query in my page. Anyone have suggestions? -- ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197621 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ValueList ALWAYS in same order as records in query?
Will the results from ValueList(query.Column) always list the values in the same order as the records in the query?k Can I use the results of a ListFind on the ValueList to index into the query? Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197625 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Returning 2 queries from stored proc
How do I define the two result sets in the Stored Proc? I am using MS SQL and I can't find anything in their help guide. -Original Message- From: Michael Dinowitz Yes, but you have to use the CFSTOREDPROC and the CFPROCRESULT. Each CFPROCRESULT will have the query name and the order of it's operation from within the stored procedure. CFSTOREDPROC cfprocresult name=query1 resultset=1 cfprocresult name=query2 resultset=2 /CFSTOREDPROC Is it possible to return two different queries from a single stored proc? Andy Ousterhout ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (OO) UI in CFCs
Nick, I am not sure that previous discussions where about CFC's designed specifically for UI, but for CFC's that are instances of objects. -Original Message- From: Nick de Voil I can't see any sense in the assertion that you shouldn't use CFCs for UI. Why on earth not? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197306 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SOT - Ecommerce
Chris, I highly recommend that you find a bank and use the service that they provide. If you start with the 3rd party, you of course are going to have an additional level of fees. Otherwise, your bank should have a workable solution with the service company that they use. They will bundle all of the fees into a single rate that you might be able to shop, depending on how long your merchant has been in business and the average size of their transactions. Andy -Original Message- From: Chris Tilley Bryan or anyone else have any recommendations of a good company to handle all this with minimal cost? I want to do some comparisons. We selected Millenium only because of referral and I really don't know if we are getting a deal (avg fees) or getting taken for a ride? Chris On Fri, 18 Feb 2005 10:58:55 -0800, Bryan Stevenson [EMAIL PROTECTED] wrote: see below... 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 - Original Message - From: Chris Tilley [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, February 18, 2005 9:53 AM Subject: SOT - Ecommerce Hey all, Sorry if this doesn't belong here. I'm new to ecommerce and have helped my customer set it up. We are using the authorizeNet processing. Is there someway to know all the fees associated with ecommerce business? We currently get invoiced by: Millenium Bank Services, AuthorizeNet and Concord Payment Systems. This is a bit confusing. Could someone that is knowledgeable in this area assist me? Why do you have to deal with so many companies to do online ecommerce? The bank takes some (usually a per Tx fee)the cardcompanies take some (usually a percentage of the Tx)...the card processing company takes some (can be flat fee or percentage of Tx). It does get fancier than that (like first x Txs cost x per Tx...then after that..less per Tx). So there ya go...all companies involved in the Tx get a piece of the action...and remember...if you buy something in the storethe store gets charged (by the cc company) a percentage of the Tx for the use of the card, and a fee to deposit the money (these are transparent to the customer). Online the only extra fee is the cc card processing company. HTH Cheers Thanks in advance, -- Chris Tilley ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SOT - Ecommerce
You don't always need all of these players. Right know, I have my credit card account with Northern Trust and they've hired an electronic provider (ADP/Chase) that we use to process transactions. We do not have any additional fees besides the rate we negotiated with our bank. The majority of our transactions are card not present all settled electronically. Andy -Original Message- From: Ben Rogers I'm new to ecommerce and have helped my customer set it up. We are using the authorizeNet processing. Is there someway to know all the fees associated with ecommerce business? You need several components to process a transaction online. They can come from several companies or from just one. The first thing you need is a gateway. That's where Authorize.Net comes in. They interface with the banking system. They deposit the money in what's commonly referred to as an Internet merchant account. Internet merchant accounts are accounts that are used for card-not-present transactions. That includes any transaction you would place over the Internet or by calling, faxing or mailing the credit card number. Internet Merchant Accounts usually take a fee per transaction. This is on top of the fee that the credit card company is taking. Finally, you need a regular old bank account like a business checking account. Usually, the one you have with your local bank will be enough. This is where the money ends up. They, of course, charge their own set of fees. These vary quite a bit from bank to bank and depending on the type of account you have. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195470 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SOT - Ecommerce
That may be in the fine print. But we only have a single account for both transactions. I believe it is more dependent on your bank. Card not present transactions have a higher risk since charges can be rejected for up to 6 or 9 months and the merchant has very limited recourse. So during the internet phase (you remember those good old days) when firms where popping up with no real assets, 3rd parties jumped in to accept the risk when banks would not. Fees of course rose to cover the risk with some profit. For any business with a history and a solid banking relationship, these 3rd parties and their fees can easily be avoided. This is also an excellent reason to find a local bank that has experience working with small companies and develop a relationship with them. We had a receivables line of credit before we established our merchant account. Andy -Original Message- From: Ben Rogers You don't always need all of these players. Right know, I have my credit card account with Northern Trust and they've hired an electronic provider (ADP/Chase) that we use to process transactions. We do not have any additional fees besides the rate we negotiated with our bank. The majority of our transactions are card not present all settled electronically. Some companies provide all three services (payment gateway, Internet merchant accounts and merchant account). I'm no expert, but I believe that, in the United States, you need an Internet merchant account that's separate from your merchant account (business checking account) for card-not-present transactions. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195499 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SOT - Ecommerce
Actually, they do cost less, since the bank negotiates with the processing firm for a significantly larger chunk of the business and also excepts all of the credit risk. This processing is part of being a bank, so they really can't mark it up in an uncompetitive fashion. But, as I mentioned in an earlier email, it is very important that merchants cultivate a relationship with a local bank. Andy -Original Message- From: Ben Rogersce I highly recommend that you find a bank and use the service that they provide. If you start with the 3rd party, you of course are going to have an additional level of fees. By level, you mean that it will be broken down more, not that they will necessarily cost less, correct? Otherwise, your bank should have a workable solution with the service company that they use. I've only worked with a couple of dozen companies in this respect, but it's been my experience that most banks do not offer payment gateways. Those that do generally have very convoluted solutions that are not very friendly in shared hosting environments. I much prefer the https based payment gateways offered by companies like Authorize.Net. They will bundle all of the fees into a single rate that you might be able to shop, depending on how long your merchant has been in business and the average size of their transactions. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195501 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT- Help installing VPN
OK, I took the lists' advice and went out and bought a SonicWall T170 and now am trying to install VPN so that we can run a legacy AP and access the Exchange server from home and when I am traveling. I am trying to use RADIUS and IAS to access MS Server 2003 for Username/PW validation. When I test this, the SonicWall says: Radius Client Authentication Failed. SonicWall Log says: 02/16/2005 13:25:27.704 UDP packet dropped 68.74.188.43, 500, WAN 69.11.220.86, 500, WAN 02/16/2005 13:25:19.432 Web management request allowed 192.168.1.51, 1944, LAN 192.168.1.1, 443, LAN HTTPS MS 2003 Security Log recorded this event: Event Type: Failure Audit Event Source: Security Event Category: Logon/Logoff Event ID: 529 Date: 2/15/2005 Time: 8:29:09 PM User: NT AUTHORITY\SYSTEM Computer: OMGSERVER Description: Logon Failure: Reason: Unknown user name or bad password User Name: cindy Domain: OMYGOODNESS Logon Type: 3 Logon Process: IAS Authentication Package: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0 Workstation Name: Caller User Name: OMGSERVER$ Caller Domain: OMYGOODNESS Caller Logon ID: (0x0,0x3E7) Caller Process ID: 996 Transited Services: - Source Network Address: - Source Port: - I've configured Server 2003 according to MS Article ID 323441 except that I gave a specific user Dial-in access via Server Management/Users since I couldn't figure out any changes I needed to make to their preset Mobile User group. What am I missing besides my brain? Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195058 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Firewall question
Which is more secure: Running your firewall on the NT 2003 Server or running it on a router? Andy ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193864 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Firewall question
Does a regular router like you get at Best Buy work the same or does an appliance have much stronger protection? -Original Message- From: Nurse, Robert If the router isn't a PC/Workstation, I'd say running it on a router. I use a firewall appliance (Sonicwall). Traffic is handled before it reaches hosts behind it. Robert Nurse STG Contractor - Applications Development Enterprise Management Center Computational Information Sciences Directorate -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 11:42 AM To: CF-Talk Subject: OT: Firewall question Which is more secure: Running your firewall on the NT 2003 Server or running it on a router? Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193870 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Firewall question
LOL. So both can be equally secure? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 10:50 AM To: CF-Talk Subject: Re: OT: Firewall question Andy Ousterhout wrote: Which is more secure: Running your firewall on the NT 2003 Server or running it on a router? Both. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193871 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Firewall question
Well, cause I don't need the router if I go directly to the NT machine (I've got a hub too). So the doubling up adds 1 more layer to be broken thru? So you route LAN through router into Server and out of Server to hub? Andy -Original Message- From: Jochem van Dieten Andy Ousterhout wrote: LOL. So both can be equally secure? Yes, they can be equally secure. But why not run one on both? Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193877 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Firewall question
what firewalls to folks recommend? -Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 11:00 AM To: CF-Talk Subject: RE: Firewall question Have a firewall between your router and server. Router -- Firewall -- Windows 2003 Server Use access list on your router, along with a good rule set on firewall, and a hardened web server. -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 8:42 AM To: CF-Talk Subject: OT: Firewall question Which is more secure: Running your firewall on the NT 2003 Server or running it on a router? Andy ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193879 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Firewall question
But I am getting the impression that router does not equal firewall. Routers do some things that a try firewall does, but not all. Is this correct? -Original Message- From: Dawson, Michael I use a Linksys (now Cisco) wireless router at home. When we got broadband (cable) several years ago, my PC was hacked in just a few days. That was all it took for me to convince my wife that we needed a router. After installing it, I have had no problems. Of course, I'm not running a business or anything. M!ke -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 10:53 AM To: CF-Talk Subject: RE: Firewall question Does a regular router like you get at Best Buy work the same or does an appliance have much stronger protection? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193886 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Firewall question
I think the most secure arrangement is to: 1. Replace router with hardware Firewall Solution (adding VPN at same time ::-)) 2. Go from Firewall solution to NTServer running Firewall software 3. Go from NTServer to rest of internal network. Easy enough. Already shopping for firewall/VPN hardware. Thanks everyone for the education. Andy -Original Message- From: Dawson, Michael ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193928 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Firewall question
Jim, What I am try to figure out is what exactly is the safest configuration. What seems to be the last remaining question is whether I want to route all internet traffic through my single server or whether I should not. Config 1 Firewall ---NT Server -- Hub Config 2 Firewall ---Hub --NT Server What do folks out there think? -Original Message- From: Jim McAteeon I think the most secure arrangement is to: 1. Replace router with hardware Firewall Solution (adding VPN at same time ::-)) You might not necessarily be able to replace your router. Depends a bit on the actual connection. For instance if you currently had a T1 and a Cisco router with a T1 CSU/DSU module then you'll still need the router to make T1 connection. Similarly, with DSL, you need a router capable of making the DSL connection. That said, there _are_ combo boxes that can terminate the connection, and act as router, firewall and VPN endpoint. 2. Go from Firewall solution to NTServer running Firewall software If your server is truly behind the firewall on an internal network, you can dispense with running firewall software on the server itself. There probably aren't many shops running firewall software on things like file and print servers on their LAN. Only if the server is Internet-facing might you need to worry about this. But while defense in depth is a good philosophy, it can sometimes be a PITA to manage. For instance if you add a new service on some odd IP port then you need to open a hole through both your outer firewall and any software firewall on the server itself. Personally, if I thought I had a reliable hardware firewall between my Internet-facing servers _and_ I trusted my ability to administer the firewall then I wouldn't run a software firewall on any of those servers. 3. Go from NTServer to rest of internal network. I'm not sure why you'd need to do this unless you need to use the server as a router. You probably should explain the nature of your connection and network a little better. Is it purely a web hosting network? Or a company LAN - with or without Internet-facing servers such as web and email servers? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193990 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Firewall question
No, not theory. Real-life small business with 5 users accessing Internet and receiving Email via Exchange Server running on same box. Web site is hosted elsewhere. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 6:01 PM To: CF-Talk Subject: Re: Firewall question No, I wouldn't route through the Windows server. The only times I'd consider using Windows as a router would be on a network where for some reason it's your only routing option, or if you wanted to run Microsoft's ISA Server as your firewall. I've never used it, but ISA can do some things that most firewalls cannot by integrating security with your NT domain. But this would be in the context of an office network with users behind the firewall, not a web hosting network. http://www.microsoft.com/ISAServer/ You still haven't mentioned the nature of the network - perhaps it's just a theoretical question, but if the NT server is a web or email server and the network also has users and/or private servers, then you'll want to isolate the NT server in a DMZ. -- DMZ: Web email servers / Internet -- router/firewall -- \ -- PRIVATE: LAN users and servers - Original Message - From: Andy Ousterhout [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 09, 2005 4:19 PM Subject: RE: Firewall question Jim, What I am try to figure out is what exactly is the safest configuration. What seems to be the last remaining question is whether I want to route all internet traffic through my single server or whether I should not. Config 1 Firewall ---NT Server -- Hub Config 2 Firewall ---Hub --NT Server What do folks out there think? -Original Message- From: Jim McAteeon I think the most secure arrangement is to: 1. Replace router with hardware Firewall Solution (adding VPN at same time ::-)) You might not necessarily be able to replace your router. Depends a bit on the actual connection. For instance if you currently had a T1 and a Cisco router with a T1 CSU/DSU module then you'll still need the router to make T1 connection. Similarly, with DSL, you need a router capable of making the DSL connection. That said, there _are_ combo boxes that can terminate the connection, and act as router, firewall and VPN endpoint. 2. Go from Firewall solution to NTServer running Firewall software If your server is truly behind the firewall on an internal network, you can dispense with running firewall software on the server itself. There probably aren't many shops running firewall software on things like file and print servers on their LAN. Only if the server is Internet-facing might you need to worry about this. But while defense in depth is a good philosophy, it can sometimes be a PITA to manage. For instance if you add a new service on some odd IP port then you need to open a hole through both your outer firewall and any software firewall on the server itself. Personally, if I thought I had a reliable hardware firewall between my Internet-facing servers _and_ I trusted my ability to administer the firewall then I wouldn't run a software firewall on any of those servers. 3. Go from NTServer to rest of internal network. I'm not sure why you'd need to do this unless you need to use the server as a router. You probably should explain the nature of your connection and network a little better. Is it purely a web hosting network? Or a company LAN - with or without Internet-facing servers such as web and email servers? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194001 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Good Microsoft Server 2003 list
Thanks. Was curious if there was a non-Microsoft list similar to CF-Talk. Andy -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Sunday, February 06, 2005 2:47 PM To: CF-Talk Subject: RE: Good Microsoft Server 2003 list Try the Microsoft newsgroups: http://www.microsoft.com/windowsserver2003/community/newsgroups/default.mspx Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Saturday, February 05, 2005 4:02 PM To: CF-Talk Subject: OT: Good Microsoft Server 2003 list I need to join a Microsoft Server 2003 list. Can anyone point me to a good one? Andy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Good Microsoft Server 2003 list
I need to join a Microsoft Server 2003 list. Can anyone point me to a good one? Andy ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193198 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS SQL 2000 Table Structure Print out
Jared, I can't log in. Does your app require cookies to be enabled? Andy -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 8:21 AM To: CF-Talk Subject: Re: MS SQL 2000 Table Structure Print out Correction, a demo of the application can be viewed here: http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm This is using the SQL Server Northwind sample application. The userID/Password are admin/admin. Have a good one. J On Mon, 31 Jan 2005 08:11:03 -0600, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: I've written a small app that parses the SQL Server metadata stored procedures. It will display all the relevant data for any SQL Server table, view, or sproc, including indexes, columns and datatypes, and sproc CREATE text. It also generates lists of columns names in several formats, CFARGUMENT tags, and CFSTOREDPROC/CFPROCPARAM tags for the relevant DB object type. I can set you up with a demo if you'd like... Let me know, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS SQL 2000 Table Structure Print out
Unfortunately, I don't think that CF/MX actually saves a session cookie, but saves a permanent cookie. Or, perhaps I've got IE set up wrong :-) -Original Message- From: Jared Rypka-Hauer Hmmm... I'm using cflogin with session storage... it shouldn't. I'll post the info again... http://w2ksrv1.neo.servequake.com/dbanalyzer/ userID/pwd is admin/admin That SHOULD get you in, if it doesn't let me know and I'll try something else... Laterz, J ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192346 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS SQL 2000 Table Structure Print out
Thanks. I've got to change my site! -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 11:27 AM To: CF-Talk Subject: RE: MS SQL 2000 Table Structure Print out Unfortunately, I don't think that CF/MX actually saves a session cookie, but saves a permanent cookie. By default, if you're using CF session management, CF will set two persistent cookies, CFID and CFTOKEN. If you're using J2EE session management, CF will set a single session cookie, JSESSIONID. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MS SQL 2000 Table Structure Print out
Nice. Can you email me the code off-line? Andy -Original Message- From: Jared Rypka-Hauer - OK, then... For purposes of demonstration, I have removed the cflogin restriction to the application. Since it's just hitting the Northwind datasource, I'm not terribly concerned. SO, without further ado, please use this URL: http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm NO USERNAME, NO PASSWORD... (sheesh... it must be monday! ;) ) To view the demo version of the application. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Hiding Credit Card Numbers
Why not simply and just do right(cc,4). If you want to add astrix, you can use repeat() to add leading astrix. Andy -Original Message- From: James Watkins When we receive a credit card payment I send an email (using Cfmail) thanking them for the payment and explaining that the charges have been applied to #nameofcard# and #cardnumber# what I would like to do is only display last 4 numbers of credit card and fill first numbers with asterisk as in 6514 So how would I modify following to do that: Card Number: #creditcard.cardnumber# ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192110 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Proc Question
Good point. But you can't use query caching without placing in application or session scope and still use cfqueryparam -Original Message- From: Robertson-Ravo, Neil (RX) In some cases yes but in reality if you are using query caching with cfquery it can be just as fast. For simple selects you will see negligible difference in as far as the parsing is concerned but there is a hell of a lot of other things to consider with using an SP over CFQUERY which will be faster such as use of memory etc. It is not all about how fast you get results back. -Original Message- From: Andy Ousterhout I thought that even with simple queries that Stored Procs where much faster? I tried this on a couple of other SELECTS and got noticable improvement. By the way, I always use CFQUERRPARAM. Andy -Original Message- From: Jochem van Dieten Andy Ousterhout wrote: Here is the proc that I am using. You suggest either 2 separate queries or 2 procs? Why are you using a stored procedure? This appears to be a simple SELECT that would be equally good with cfqueryparam. If there are no urgent pattern / encapsulation reasons I would probably just use 2 queries in the CF code. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191341 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: checkboxes
Remember that the Form.VarName will only be passed if checked, so in your action page you will need to loop through all possible names to check to see if the Fomr.VarName exists. Andy -Original Message- From: Donna French what's the best method for dealing with checkboxes? i want to insert a 1 if checked, a 0 if not. should i set the value in my form, or check the checked status in my insert query and set the value there? i know this should be simple but i've stared at it so long now i've confused myself. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Stored Proc Question
Lets say that I need to look up an invoice by 2 different mechanisms: Internal reference/Key 2 strings Will the execution plan for a stored proc for the Key be different enough from one for the strings to justify creating 2 stored procs? Right now I've got a single stored proc that does both. Andy ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Proc Question
Here is the proc that I am using. You suggest either 2 separate queries or 2 procs? create proc spreadInvoice @InvoiceNumber int, /*Provide either Invoice Number or both */ @PeachTreeInvoice char(21), /* Peachtree Invoice Number and */ @PeachtreeKey char(21) /* Peachtree Key */ as /* Procedure to read Customer information by either CustomerKey or PeachtreeKey */ SELECT FROM tabInvoicedItems LEFT OUTER JOIN tabOrderedItems ON tabInvoicedItems.Line = tabOrderedItems.Line AND tabInvoicedItems.OrderNumber = tabOrderedItems.OrderNumber LEFT OUTER JOIN tabItems ON tabInvoicedItems.Item_FK = tabItems.Item_PK LEFT OUTER JOIN tabItemTypes ON tabItems.ItemType_FK = tabItemTypes.ItemType_PK LEFT OUTER JOIN tabCustomers INNER JOIN tabOrders ON tabCustomers.Customer_PK = tabOrders.Customer_FK ON tabOrderedItems.OrderNumber = tabOrders.OrderNumber RIGHT OUTER JOIN tabPeople tabPeople_1 RIGHT OUTER JOIN tabInvoices LEFT OUTER JOIN tabPeople ON tabInvoices.EnteredBy_FK = tabPeople.Person_PK ON tabPeople_1.Person_PK = tabInvoices.ChangedBy_FK ON tabInvoicedItems.InvoiceNumber = tabInvoices.InvoiceNumber WHERE ((@InvoiceNumber IS NOT NULL) AND (tabInvoices.InvoiceNumber [EMAIL PROTECTED])) OR ((@PeachtreeKEY IS NOT NULL) AND (@PeachtreeInvoice IS NOT NULL) AND (tabInvoices.PeachtreeInvoiceNumber= @PeachtreeInvoice) AND (tabCustomers.Peachtree_FK= @PeachtreeKey)) ORDER BYtabInvoices.InvoiceNumber, tabInvoicedItems.Line; GO -Original Message- From: Jochem van Dieten Andy Ousterhout wrote: Lets say that I need to look up an invoice by 2 different mechanisms: Internal reference/Key 2 strings Will the execution plan for a stored proc for the Key be different enough from one for the strings to justify creating 2 stored procs? Right now I've got a single stored proc that does both. The execution plans will be different enough to justify creating 2 execution plans. This requires 2 queries, but depending on your database you might be able to put multiple queries in one stored procedure. Jochem ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Proc Question
I thought that even with simple queries that Stored Procs where much faster? I tried this on a couple of other SELECTS and got noticable improvement. By the way, I always use CFQUERRPARAM. Andy -Original Message- From: Jochem van Dieten Andy Ousterhout wrote: Here is the proc that I am using. You suggest either 2 separate queries or 2 procs? WHERE ((@InvoiceNumber IS NOT NULL) AND (tabInvoices.InvoiceNumber [EMAIL PROTECTED])) OR ((@PeachtreeKEY IS NOT NULL) AND (@PeachtreeInvoice IS NOT NULL) AND (tabInvoices.PeachtreeInvoiceNumber= @PeachtreeInvoice) AND (tabCustomers.Peachtree_FK= @PeachtreeKey)) Use 2 separate queries (in 1 or 2 procedures). Why are you using a stored procedure? This appears to be a simple SELECT that would be equally good with cfqueryparam. If there are no urgent pattern / encapsulation reasons I would probably just use 2 queries in the CF code. Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Importing a csv file
Victor, This has been covered several times over the years. Search the archives. Andy -Original Message- From: Victor Moore ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191090 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored procedure VS Views
Will, I believe that Stored Procs are more efficient since SQL will create execution plans for them, while for views, they have to be created for each execution. Andy -Original Message- From: Will Tomlinson s With everyone's help I'm pretty much wrapping up the functionality of my clothing app/SQL Server db. I was planning on converting much of my SELECT cfquerys to stored procedures, and started reading some about views. Is a view equal to a stored procedure in performance? Does it matter at all which you use? Is one easier than the other? I'm trying to keep the load off of CF and place it on SQL Server since I'm using shared hosting. ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190912 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: User Documentation - Any suggestions?
Jon, My recommendation is to build it right into your application. Any other form tends not be used or kept current. If your site has content mgmt already included, this can be used for field, screen and task level documentation. Since you will have to add the links to your app anyway, the actual page maintenance doesn't need to be a separate app. My 2 cents. If I deserve change back, so be it. Andy -Original Message- From: Jon Block We're trying to come up with a better way to document how our web application works for our end users. Can anyone suggest a good tool or software I should look at for creating and maintaining end user documentation? Jon ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Fax Program
Has anyone worked with a fax program that I can send the fax number along with the page to be faxed? I need to send out several hundred faxes each month to clients with an order sheet and their purchases for that month from the previous year. I currently use WinFax and have to manually select the fax number from a list for each customer. Regards, Andy Ousterhout O'My Goodness www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL60044 Phone 847.735.9890 Fax 847.735.9910 Yahoo IM: andy_ousterhout AOL IM: aousterhou ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190137 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Fax Program
Because this costs $.10 per page versus $.03-.05 per page and it is my business, therefore my money. If I can find a solution that enables me to use my own Long Distance service, then I'd prefer to to that. -Original Message- From: Ray Champagne Why not just set up a database, then loop over the numbers in it, and send from the many companies on the web that do this? I haven't done it before, but that seems to be a pretty simple solutionmaybe too simple? Ray At 05:42 PM 1/12/2005, you wrote: FaxNow! from RedRock has an API which may help, or potentially you could look at on-line fax providers such as eFax HTH On Wed, 12 Jan 2005 16:35:16 -0600, Andy Ousterhout [EMAIL PROTECTED] wrote: Has anyone worked with a fax program that I can send the fax number along with the page to be faxed? I need to send out several hundred faxes each month to clients with an order sheet and their purchases for that month from the previous year. I currently use WinFax and have to manually select the fax number from a list for each customer. Regards, Andy Ousterhout O'My Goodness www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL60044 Phone 847.735.9890 Fax 847.735.9910 Yahoo IM: andy_ousterhout AOL IM: aousterhou ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190154 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Fax Program
I just found out how to do it using WinFax. For some brain-dead reason, I wasn't looking under mail merge. Based off of the following, it looks like I can send WinFax a single document using the following codes to separate faxes: wfxFaxNum fax number (maximum 47 characters) wfxRecipientrecipient name (maximum 31 characters) wfxTime transmit time (HH:MM:SS time format) wfxDate transmit date (MM/DD/YY date format) wfxCompany company name (maximum 42 characters) wfxSubject subject (maximum 79 characters) wfxKeyword keywords (maximum 33 characters) wfxBillCode billing code (maximum 26 characters) ~| Purchase Captivate from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=52 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190158 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Fax Program
Had my 48th birthday yesterday. More brain cells dying every day! -Original Message- From: Bryan Stevenson ah...so a little RTFM saves the day ;-) 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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190163 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFC super.init
Daniel, What I've done is in each of my CFC's I have an INIT and a clear private function called by the Init. These clear functions have a unique name designed as clear+CFC name. If the cfc extends another, clearCFC1 calls clearCFC2 and so on. Andy -Original Message- From: Daniel Elmore I am fairly confused on how the super scope works. Lets say I have the following: - 2 CFCs, one called Car the other called Honda - Honda extends Car - Car.init sets two 'this' scoped or 'variables' scoped variables (hopefully it doesn't madder in this example) - Honda.init calls super.init() Shouldn't all of Honda's methods have access to the 2 variables set in the Car init() method, either directly or via Car's getter methods? If not, how do you get this functionality and is this a common design pattern? Does this sound like a wrong thing to getting working? Thanks, I can really use the help. Daniel Elmore ~| Purchase RoboHelp from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=59 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190176 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Allows Negative Zero?
Can someone explain the concept of + or - zero? Andy -Original Message- From: Ryan Duckworth [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 05, 2005 2:19 PM To: CF-Talk Subject: RE: CF Allows Negative Zero? This function will solve your problem: JavaCast('float',variableName) Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 05, 2005 11:12 AM To: CF-Talk Subject: Re: CF Allows Negative Zero? Can you owe nothing? how about if I give you nothing is that +0? hmmm.. abstract On Wed, 5 Jan 2005 10:44:40 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: If you enter a negative zero (-0), CF keeps it as is and does not strip the negative sign. I would assume that is because CF may think this is a string, however, it passes the IsNumeric() function. Should I just use the val() in my setter when I expect a numeric value to be passed? Thanks M!ke ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189442 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Resources for learning CFC's ?
Donna, Good question. I would think that something like this would already be in the public domain, somewhere. Andy -Original Message- From: Donna French I'm wondering if it is possible - or if anyone has done this. Build a shopping cart using a single CFC and just call a method for whatever the user wants to do (add item, etc.)? I ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported.
Question is how do you want to treat Null. Since NULL has no value, you will have to use IsNULLL() or your db equivalent to set a value that is either the highest or lowest, depending on how you wish to sort. If you need to keep the value as NULL, then create a sort field that contains the converted value(s). Andy -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 2:54 AM To: CF-Talk Subject: QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported. Hi All. I have a problem with a Query of a Query. The error I'm getting is: Query Of Queries runtime error. Sorting on columns of type java.sql.Types.NULL is not supported. The code is: cfquery name=qry_accommodationData dbtype=query SELECT * FROM qry_accommodationData ORDER BY #orderBy#, AdultPrice /cfquery Most of the time this works fine, but every now and again it gets a dataset that it has this problem with. I have compared the first row of a good dataset with the first row of bad dataset and they appear to be pretty much same, apart from slightly different values. As far as I'm aware CF uses the first row of the dataset to set the data types and in both the good and bad datasets none of the columns in the first have null values. Anyone got any ideas? Andrew. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188637 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Okay, stupid question time...
Try CFSET qryNews=myObject.getNews() / cfoutput query=qryNewsaryNews.headline/cfoutput -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:18 AM To: CF-Talk Subject: Okay, stupid question time... cfobject name=myObject component=mySite.myCFC cfoutputmyObject.getNews().headline/cfoutput Naturally...only one displays, even though the query returns three...totally cool so far... Now, I want to loop over the Query object that getNews() returns... so...um cfoutput query=**Here's Where My Brain Shuts Off**myObject.getNews().headline/cfoutput ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188553 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Updating inventory qty in my DB
Will, I would be careful using URL variables to hold shopping cart information. They have a maximum size of I believe 255 characters which might cause your cart to be truncated, especially if you are holding product descriptions in it. Andy -Original Message- From: Will Tomlinson !---The cart info variable #URL.cart# arrives at my template via HTTP call, and looks like this. description:quantity:price:productcode delimited by ~ product description 1 blah blah:1:24.99:FX25~product description 2 blah blah:3:19.99:MX25~product description 3 blah blah:1:49.99:CX25 --- ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188365 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is OBJECT a reserved word?
Like it. Thanks. -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Sunday, December 19, 2004 12:10 AM To: CF-Talk Subject: Re: Is OBJECT a reserved word? On Sat, 18 Dec 2004 22:55:27 -0600, Andy Ousterhout [EMAIL PROTECTED] wrote: I am building an object that will used to control access to all objects in the application. It will be called with the User's Security Group(s) to validate User's rights to access an object and return the name and location of the appropriate release-version if the User has the appropriate permissions. Sounds like AccessControl might be a good name for it then? -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188193 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Running CF on XP Home?
I don't think XP Home comes with Internet Server, so I think you need Pro. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Sunday, December 19, 2004 12:04 PM To: CF-Talk Subject: Running CF on XP Home? After many, many moons its time to get rid of my home office PC, which is actually my main development unit. Got it on the day Win2k was released, so its more than time to retire it. I've stuck to Win2k on all of my other desktops and servers, but it looks like I will finally have to go with XPee. Is there any problem with running CF MX on XP Home? What does XP Pro give me? I have the standard-issue, fifty-buck Linksys 4-port internet router, and usually interconnect with my laptop via a simple network cable (nothing in between. My hardware guy at the time said he needed to make a custom cable to allow that to happen with just a wire). Sorry for the dummy questions but I have been an o/s Luddite for quite a while. If I didn't have to change I'd still chug along. Porting over the software will be a couple days' work before I get it right, I bet. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188195 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Extracting field lengths types for sql database
How can I get the length and type of a field in an MS SQL table? Andy ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188197 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Extracting field lengths types for sql database
Thanks. Easy enough -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, December 19, 2004 12:32 PM To: CF-Talk Subject: Re: Extracting field lengths types for sql database Andy Ousterhout wrote: How can I get the length and type of a field in an MS SQL table? From the COLUMNS view in the INFORMATION_SCHEMA. Jochem ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188210 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Is OBJECT a reserved word?
I would like to name a CFC OBJECT but need to know if it is a reserved word. Andy ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188171 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is OBJECT a reserved word?
Sean, I am building an object that will used to control access to all objects in the application. It will be called with the User's Security Group(s) to validate User's rights to access an object and return the name and location of the appropriate release-version if the User has the appropriate permissions. Andy -Original Message- From: Sean Corfield I would like to name a CFC OBJECT but need to know if it is a reserved word. Um, it's not reserved but I'd be wary of a CFC called object from a logical model point of view... It sounds like one of those universal base classes which are almost always not a good idea. What are you trying to model? -- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188182 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SOT moving to FireFox
Kevin, Thanks. Very interesting. Andy -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 9:26 AM To: CF-Talk Subject: RE: SOT moving to FireFox The simplest way is to simply declare a proper doctype which switches IE to using the W3C box model. Be aware that the doctypes included in CF Studio/Homesite are not valid. A good article with valid doctypes is available here: http://www.alistapart.com/articles/doctype/ -Kevin -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: Sunday, December 12, 2004 9:04 PM To: CF-Talk Subject: Re: SOT moving to FireFox Interesting. So how are people coding for this? Determine the browser and then have two dimensions? I was wondering if M$ is doing this on purpose or just doesn't care. Thanks Barney Victor On Sun, 12 Dec 2004 18:46:13 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: IE incorrectly implements the CSS box model, while FF (and other browsers) gets it right. Specifically, IE assumes the width you specify is for the actual content area of the elements box, while the CSS spec says that the width you specify is for the entire box (including padding, border, and margin). So if you've got 5px of margin, a 1px border, and 4px of padding, your elements will be 10px wider than they should be. Or, if you're looking at it from the IE side, rather than the standards side, a standards compliant browser will show your boxes 10px smaller than you're used to. cheers, barneyb On Sun, 12 Dec 2004 21:28:48 -0500, Victor Moore [EMAIL PROTECTED] wrote: Thanks Isaac, I have implemented the second part and it's working fine. I am working now on the first one. There is actually one function for all the events: document.onmouseout = ItemOut; document.onmousedown = ItemDown; document.onmouseup = ItemUp; Thanks again. Victor PS One more thing: Is there a difference in rendering between the two browsers? It seems that there is 5 pixel offset. Not a biggie but some items on the form are not aligned properly. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs ASP.NET! GET YOUR FRESH POPCORRRRN!!
Is anyone else getting it other than me??? Isn't this a line from Zoolanders? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187502 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL Question
In MS SQL, why does this work: CASE YEAR(tabInvoices.InvoiceDate) but this throw and error that InvoiceDate is not in group: CASE YEAR(tabInvoices.InvoiceDate) -1 I can't add InvoiceDate to GROUP BY because then the results are wrong Andy ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185697 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Best way to access CFC's?
Why would you do that? -Original Message- From: Sean Corfield. Unless you specify a component *reference* in cfinvoke rather than a component name: cfset t = createObject(component, test) / cfinvoke component=#t# method=testMethod returnvariable=r / -- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Best way to access CFC's?
Why wouldn't I just state: CFSET myAdder.setNumberOne(Number=2) / This seems much more readable. Andy -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Monday, November 29, 2004 1:16 PM To: CF-Talk Subject: Re: Best way to access CFC's? If you're component is stateful, you'll want to invoke methods on the same instance of the component instead of continually creating new instances. !--- Instantiate a component that adds two numbers --- cfset myAdder = createObject(component, addsTwoNumbers) / !--- Set first number --- cfinvoke component=#myAdder# method=setNumberOne cfinvokeargument name=number value=2 /cfinvoke !--- Set second number --- cfinvoke component=#myAdder# method=setNumberTwo cfinvokeargument name=number value=3 /cfinvoke !--- Get sum --- cfinvoke component=#myAdder# method=getSum returnVariable=sum /cfinvoke !--- Displays five --- cfoutput#sum#/cfoutput There's a few different ways to write thisI'd probably use: cfset myAdder = createObject(component, addsTwoNumbers) / cfset myAdder.SetNumberOne(2) / cfset myAdder.SetNumberTwo(3) / cfoutput#myAdder.getSum()#/cfoutput -joe On Mon, 29 Nov 2004 12:59:01 -0600, Andy Ousterhout [EMAIL PROTECTED] wrote: Why would you do that? -Original Message- From: Sean Corfield. Unless you specify a component *reference* in cfinvoke rather than a component name: cfset t = createObject(component, test) / cfinvoke component=#t# method=testMethod returnvariable=r / -- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185575 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Best way to access CFC's?
Do you know that you can name your arguments in the compenent.method(arg2=1, arg1=2)? -Original Message- From: Matthew Drayer We started off writing all our component method calls inline -- ie: component.method(argument1, argument2), but we quickly found that 1. It was sometimes hard to follow what was going on due to the squished up nature of the code. 2. Having to maintain the proper order of argument declaration was a pain in the neck. So, we switched over to using cfinvoke for almost all of our method calls. It lends a little flexibility to the developer, and helps to make the code self-documenting. We do still have some component method calls done the inline way, but they are typically argument-less methods used in cfif tags, etc.: cfif server.hcpro.isCustomerSubscribed() DO STUFF /cfif Matt ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185587 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54