Re: Easiest way to have a period in a struct key?
Funny thing, I have just had this issue come up while working on code to consume a Web service. The issue is that there are lots of elements in the WSDL file that have a period in the name- e.g. contact.name. The convention comes from the earlier (pre-Web) days of the client-server application I am working with. It is perfectly valid XML notation to use a period in an element name. Since CF uses structs to pass data to web services, the dot notation for keys in structs needs to be supported for CF to be able to process these kinds of web services. Seems like enterprise application integration could in this case drive usage away from Macromedia's accepted best practices and toward a more practical solution. I just tested this with the following code: cfset myStruct = structNew() cfset myStruct[testing.value] = this is a test cfdump var=#variables# / Works fine... I still think that my dad's maxim Just because you can doesn't mean you should applies. I'm not a purist by any means, but putting a dot in a struct key name is pretty drastically off the beaten path of Best Practices. I wouldn't want to do it in an app simply based on principle. Granted, everybody needs to do what must be done to get the app working... don't NOT do it just because of me. Hehe, yeah right... ;) Like anyone would take me that seriously. But, I'd strongly discourage it... there's got to be a Better Way. I generally abide by Macromedia's published coding guidelines... standards will make CF a stronger presence in the enterprise application world, and they're pretty good standards. ~| 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:198628 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: Document Literal WebService with CFMX6.1
Tom, Forgive me if I seem a bit dense here, but I may actually understand what you're saying. ;) I hope you don't mind if I rephrase just to prove to us all that I'm not a True Dolt. A while back, I blew a day trying to create a struct in which an element contained both a string and another struct... all I ended up proving is that it can't be done. At least not by me (and I don't think it's technically possible, so if you can do it, you've got Some Voodoo). The point of this pointless excercise was to match the structure of an XML schema that someone's webservice was expecting... and, in doing so, I am apparently not alone. What I understand from what you're saying above is that CF/Java/Axis takes as an argument a struct which contains the values expected by the schema, but that is not *organized* was the schema expects... and the values are matched to their appropriate locations in the XML schema based on their names. So given a schema like this (this is close to the schema I was fighting with): complex-type attr1=Charlie another-complex-type itemA=name name type=firstJacqueline/name name type=lastSmith/name /another-complex-type some-dataThe second Angel/some-data /complex-type My struct could look like this: k.attr1 = Charlie; k[another-complex-type].itemA = name; k[another-complex-type].name.first = Jacqueline; k[another-complex-type].name.last = Smith; k[some-data] = The second Angel; Although that seems wrong, since first and last should be at the same level in the struct as the elements to which they belong. BUT that would mean having something that looks like this: k.attr1 = Charlie; k[another-complex-type].itemA = name; k[another-complex-type].type = first; k[another-complex-type].name = Jacqueline; k[another-complex-type].type = last; k[another-complex-type].name = Smith; k[some-data] = The second Angel; And that Won't Work because of the conflict between the multiple elements with the same label in the structure... which consequently causes me to wonder if this might work: k.attr1 = Charlie; k[another-complex-type].itemA = name; k[another-complex-type].a.type = first; k[another-complex-type].a.name = Jacqueline; k[another-complex-type].b.type = last; k[another-complex-type].b.name = Smith; k[some-data] = The second Angel; But that doesn't seem like it would work because the Axis stub would create getters and setters for A and B, even though there aren't really A and B values in the XML... so maybe reverse the order of the attributes: k.attr1 = Charlie; k[another-complex-type].itemA = name; k[another-complex-type].type.a = first; k[another-complex-type].name.a = Jacqueline; k[another-complex-type].type.b = last; k[another-complex-type].name.b = Smith; k[some-data] = The second Angel; But, it seems to me that we'd again be creating getters and setters for items A and B, which don't appear in the schema, we just have a pair of complex-type entries that have the same element name but are differentiated by an attribute... and I can't quite get my head around how we can guarantee that, even if we could create a struct that would work, that we can guarantee that the system will get first and Jacqueline in the same element and last and Smith in the same element. The XML schema that I was looking at are somewhere in the CF-Talk archives... I'll see if I can drum it up. It's been weeks, if not months, so I can't recall the details. However, unless there's specific rules in WSDL to keep this scenario from arising, how do we overcome the problem using CF structures? Incidentally, I read the documentation, over and over again, as did others, to little avail. I'm not complaining... I think, honestly, that if the docs don't answer questions it's time to test, try, and start sending emails or just move on... but, I think you should know... the liveDocs pages on this particular issue were of very little value. Maybe now, after reading your description above, they may make more sense... however, without that further explanation they're Not Helpful for this particular situation. Thanks for the input, Tom... it's wonderful that Macromedianiates are so willing to actually provide support on the lists, on a Sunday. :) Laterz, J On Fri, 4 Mar 2005 16:06:55 -0500, Tom Jordahl [EMAIL PROTECTED] wrote: First, see the documentation for more info. snippage -- 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:198629 Archives:
Re: Easiest way to have a period in a struct key?
In Case of Emergency, Put Emphasis Here: Granted, everybody needs to do what must be done to get the app working... don't NOT do it just because of me. Hehe, yeah right... ;) Like anyone would take me that seriously. Laterz, J On Mon, 14 Mar 2005 03:16:48 -0400, Robert Munn [EMAIL PROTECTED] wrote: Funny thing, I have just had this issue come up while working on code to consume a Web service. The issue is that there are lots of elements in the WSDL file that have a period in the name- e.g. contact.name. The convention comes from the earlier (pre-Web) days of the client-server application I am working with. It is perfectly valid XML notation to use a period in an element name. Since CF uses structs to pass data to web services, the dot notation for keys in structs needs to be supported for CF to be able to process these kinds of web services. Seems like enterprise application integration could in this case drive usage away from Macromedia's accepted best practices and toward a more practical solution. -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:198630 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?
Don't worry about redirecting in Application.cfc too much. It is a CFC, but it's a little different than most other CFCs, so the same rules don't apply to the same degree. It's really a very procedural construct, it's just packaged into a CFC, because it makes things a lot cleaner. And you can only use one of Application.cfm and Application.cfc. Application.cfc has priority. If it doesn't exist, then Application.cfm (and the corresponding OnRequestEnd.cfm, if it exists) is looked for and executed. cheers, barneyb 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 -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| 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:198631 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
cfchart and cfchartdata question. Kindly help!
Hello everybody, I really need someone to help me here. I'm new to charting. I'm developing a graphical interface to report the no of jobs logged in a period. The x axis displays the period (days) and the y-axis displays the number of jobs logged in a given day. The data is pulled from the jobs table. The job logged date value is stored in the logdateTime column. I've written a stored procedure to get the count of jobs logged in a given day. Here is the code. cfquery name=qJobsLogged datasource=dbname EXEC countJobsLogged @startdatedate = '2005/02/01', @stopdate = '2005/02/28' /cfquery !-- sp code starts here -- CREATE proc countJobsLogged @startdate datetime, @stopdate datetime as set nocount on declare @x datetime, @count int create table #temp_report( dtlogged varchar(15), jobsCount int ) select @x = @startdate while @x = @stopdate begin select @count = isnull(count(1),0) from call where logdatetime = @x + '00:00:00' and logdatetime = @x + '23:59:59' insert into #temp_report values(convert(varchar(15),@x,106), @count) select @x = dateadd(d, 1, @x) end select * from #temp_report drop table #temp_report set nocount off GO !-- sp code ends here -- The above sp loops from the user selected start date to the user selected end date and returns a resultset showing the no of jobs logged. Ex JOBSCOUNT DTLOGGED 10 01 Feb 2005 20 02 Feb 2005 30 03 Feb 2005 Here is how I'm building the chart cfset scTo=evaluate(ArrayMax(ListToArray(valuelist(qJobsLogged.jobsCount)))+1) cfchart show3d=yes gridlines=#evaluate(scTo+1)# labelformat=number scalefrom=0 scaleto=#scTo# format=jpg xAxisTitle=log date yAxisTitle=jobs logged chartheight=300 chartwidth=450 showxgridlines=yes showygridlines=yes seriesplacement=default cfchartseries type=bar serieslabel=Jobs Logged cfloop query=qJobsLogged cfchartdata item=#qJobsLogged.DTLOGGED# value=#qJobsLogged.jobsCount# /cfloop /cfchartseries /cfchart The above code builds the graph with the data returned by the query. So far, so good. I want each data point in the bar chart to give me a break-down of urgent jobs, critical jobs, normal jobs and jobs fixed on time. I guess what I'm trying to say is take the results returned from the sp above and instead of just displaying a bar chart showing the count of jobs logged in day, I want the chart to show me the urgent, critical, normal jobs for a particular day. I really hope this is making sense. The job priority information is in the jobPriority column in the job table. Job Priorities Urgent - 5 Critical - 4 Normal - 3 Ex: Jobs logged on 01 Feb 2005 - 10. Urgent jobs - 4, Critical jobs - 4, Normal Jobs - 2 Can somebody show me the sql to get this information and the code to build the chart I would really appreciate your help Best regards cfcoder ~| 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:198632 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: Verity DocCount
I ended up doing this - which I believe gives me the correct numbers. cfcollection action=list name=lsCurrentCollections cfset variables.verityDocCount = 0 cfoutput cfloop query=lsCurrentCollections cfif lsCurrentCollections.registered NEQ K2 cfsearch collection=#lsCurrentCollections.name# criteria= language=English name=docCounter #lsCurrentCollections.name# : #docCounter.recordcount# br cfset variables.verityDocCount = variables.verityDocCount + docCounter.recordcount /cfif /cfloop /cfoutput cfdump var=#variables.verityDocCount# -Original Message- From: Tom Jordahl [mailto:[EMAIL PROTECTED] Sent: 11 March 2005 19:59 To: CF-Talk Subject: RE: Verity DocCount The CFMX 7 cfcollection tag will be *much* faster. Also you should try using an empty search instead of the wildcard, as the wildcard search takes time, while the 'empty' search does not. Tom Jordahl Macromedia Server Development -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 12:03 PM To: CF-Talk Subject: RE: Verity DocCount Excellent!! Just what I needed...d'uh can't believe I didn't think of it.. ;-) -Original Message- From: TalkingTree.com [mailto:[EMAIL PROTECTED] Sent: 11 March 2005 15:28 To: CF-Talk Subject: Re: Verity DocCount Do a wildcard ('*') search on each collection. The collectionname.recordcount property on the result set will tell you the number of documents in the collection. -Steven Erat Robertson-Ravo, Neil (RX) wrote: Basically I want to know a running count of all documents in my indexes. There MUST be a way to do this. I have contacted Verity who told me to contact MM ;-) ... Anyone know how to get the current doc count total for all Verity Collections (K2)? Now that the Verity Expressions are deprecated in MX 6.x/7 I am guessing I would have to leverage the VDK? ~| 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:198633 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
UI Problems
Hello All, My developer and I are working on a CMS for various clients. Our clients keep coming up with new requirements as the project grow or change. We are not having any issues meeting these requirement for new functionality on the website. But in my opinion we are not achieving an elegant and easy to use interface. As I review the interfaces I am finding that they are very configurable, very scalable yet I feel that they are written for programmers or people of a technical background which kind of defeats the purpose of creating a CMS in the first place. I am sure that many people on this have faced the same issue. Can any one suggest a good resource for making easy to understand user interfaces, books, sites anything. BTW if anyone feels that they are an expert in this field I am also open to paying for Consulting in this matter. Thanks Mike ~| 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:198634 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: UI Problems
Mickael, This is something you hear often. Mostly this is the result of having to much functionality and showing to much to the user. The end result often is a busy interface. And still for experienced UI designers, it is often a challenge finding a balance between what to show, and what to hide. Key is finding a balance in often used commands. It is very tempting to show all the goodies and functions to the end user, but 9/10 this is the wrong approach. There is more involved, if you are also looking at grammar, usage of buzzwords, etc. If you have some sketches/artwork I might give any comments on your approach. You can also contact me off list, if you are interested in some example approaches. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: maandag 14 maart 2005 13:49 To: CF-Talk Subject: UI Problems Hello All, My developer and I are working on a CMS for various clients. Our clients keep coming up with new requirements as the project grow or change. We are not having any issues meeting these requirement for new functionality on the website. But in my opinion we are not achieving an elegant and easy to use interface. As I review the interfaces I am finding that they are very configurable, very scalable yet I feel that they are written for programmers or people of a technical background which kind of defeats the purpose of creating a CMS in the first place. I am sure that many people on this have faced the same issue. Can any one suggest a good resource for making easy to understand user interfaces, books, sites anything. BTW if anyone feels that they are an expert in this field I am also open to paying for Consulting in this matter. Thanks Mike ~| 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:198635 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: GRRRR Dreamweaver broke my client's web site
The reason is that the library and template functionality actually let you see in Dreamweaver what you are working on while you work on it. But not only that, if it worked correctly (which in this case it didn't), the resulting html only code will run on any server that can serve up html, regardless of application server or SSI functionality. It does have its advantages, but of course has to work correctly to leverage those advantages. As an FYI, all of the library and template functionality is enabled with commands contained html comments on the target pages. - Calvin -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Sunday, March 13, 2005 1:35 PM To: CF-Talk Subject: Re: G Dreamweaver broke my client's web site I'll actually go one further. I'm no DW exeprt by any means, but why anyone would use templates and libraries makes no sense when you could just use SSI's. Not saying anything about Mike's judgement, just making a statement about DW here. Why would I use them when I can use a SSI, change it in one place and just upload *ONE* updated page? There's no scary do you want to update all files blah blah? THAT thing is worse than The Grudge! THEN you have to upload all the changed files? Screw that! My two cents, O--Will--O ~| 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:198636 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: Gmail highlighting
This is good, but I would do the following instead: In the CSS put... ..searchHighlight {background-color: #00} In the HTML... You can span class=searchHighlighthighlight/span text within search results. The reason is that there should only be one instance of an ID in an html document and the name of your CSS class should be semantic instead of specific so that when the client asks you to highlight in green, you can change your class attributes and everything will still make sense! - Calvin -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 1:09 PM To: CF-Talk Subject: Re: Gmail highlighting Wrap the search result word in the span tag shown below in the CSS put... #yellow {background-color: #00} in the HTML... you can SPAN id=yellowhighlight/SPANtext within search results. Brook At 10:00 AM 3/11/2005, you wrote: Those with Gmail will notice the interesting turn on/off highlighting feature after doing a text search of the mail. Has anyone come up with an effective way to highlight a search term in a result set using Cold Fusion? ~| 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:198637 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?
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? Not in an automated way... However, if you wanted to retain your existing application.cfm functionality, I would expect you would be able to cfinclude your Application.cfm in the onRequestStart section of your application.cfc s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.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:198638 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: Image Submit button
Thanks Troy. It does not submit the value just refreshes though. Robert O. -Original Message- From: Troy Murray [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 4:29 PM To: CF-Talk Subject: Re: OT: Image Submit button Try this instead for the button: button type=submit class=formitemsimg src=/images/next10.gif border=0 Next 10/button -t On Fri, 11 Mar 2005 14:19:39 -0500, Robert Orlini [EMAIL PROTECTED] wrote: I have another problem with a submit button. It works well as input type=submit and moves on to the next ten records, but when I change it to an image it seems to just refresh the page but not go to the next records. This works: input type=submit class=formitems value=Next 10 name=submitNext This does not: input type=image class=formitems src=/images/next10.gif value=Next 10 name=submitNext onclick=javascript:this.form.submit(); I added onclick=javascript:this.form.submit(); but to no avail. Am I missing something here? Robert O. HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005 ~| 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:198639 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
cfchart and cfchartdata question. Kindly help!
You should be able to accomplish what you're looking for just by adding 3 data series to the chart you're building. The most straightforward way to do it would probably be to modify your stored procedure to take another input parameter called status so you could view the results for a particular status type. Then drop all 3 sets of results into the chart as their own series. The attribute for CFCHART you'll want to play around with is seriesPlacement which can have values of default, cluster, stacked, percent. That will control how the different data points get displayed. Good luck! -Cliff ~| 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:198640 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
Bracket application
Anyone out there have a NCAA pool app written in coldfusion they'd be interested in sharing? =) - Rick ~| 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:198641 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: Image Submit button
You shouldn't need the javascript, the fact that it's an image should also ensure that it's a submit button. Are you doing some sort of check on your action page to see if it has been submitted? Kola -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: 14 March 2005 14:00 To: CF-Talk Subject: RE: OT: Image Submit button Thanks Troy. It does not submit the value just refreshes though. Robert O. -Original Message- From: Troy Murray [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 4:29 PM To: CF-Talk Subject: Re: OT: Image Submit button Try this instead for the button: button type=submit class=formitemsimg src=/images/next10.gif border=0 Next 10/button -t On Fri, 11 Mar 2005 14:19:39 -0500, Robert Orlini [EMAIL PROTECTED] wrote: I have another problem with a submit button. It works well as input type=submit and moves on to the next ten records, but when I change it to an image it seems to just refresh the page but not go to the next records. This works: input type=submit class=formitems value=Next 10 name=submitNext This does not: input type=image class=formitems src=/images/next10.gif value=Next 10 name=submitNext onclick=javascript:this.form.submit(); I added onclick=javascript:this.form.submit(); but to no avail. Am I missing something here? Robert O. HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005 ~| 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:198642 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: Gmail highlighting
Exactly what I was begining to type :) We're going through a lot of un-needed code revisions to undo that which should not have been done. Everything is an ID in our CSS and it is realy really messed up. Adam H On Mon, 14 Mar 2005 08:38:45 -0500, Calvin Ward [EMAIL PROTECTED] wrote: This is good, but I would do the following instead: In the CSS put... ..searchHighlight {background-color: #00} In the HTML... You can span class=searchHighlighthighlight/span text within search results. The reason is that there should only be one instance of an ID in an html document and the name of your CSS class should be semantic instead of specific so that when the client asks you to highlight in green, you can change your class attributes and everything will still make sense! - Calvin -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 1:09 PM To: CF-Talk Subject: Re: Gmail highlighting Wrap the search result word in the span tag shown below in the CSS put... #yellow {background-color: #00} in the HTML... you can SPAN id=yellowhighlight/SPANtext within search results. Brook At 10:00 AM 3/11/2005, you wrote: Those with Gmail will notice the interesting turn on/off highlighting feature after doing a text search of the mail. Has anyone come up with an effective way to highlight a search term in a result set using Cold Fusion? ~| 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:198643 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: cfchart and cfchartdata question. Kindly help!
thanks Cliff for the reply. That did occur to me and its probably the only way to do it. However, I don't know how to build the select sql query. From what I understand when using the count() function, I can't any other column name in the select. select count(*), jobPriority from call where logdatetime = @x + '00:00:00' and logdatetime = @x + '23:59:59' How do I get the query to return the count of jobs logged in a day and for each job return the jobPriority. Is there a way to do this? Regards, cfcoder ~| 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:198644 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: Gmail highlighting
When taking a semantic approach, I would consider using strong for highlighting. Not span. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - - ~| 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:198645 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: Bracket application
Rick Root wrote: Anyone out there have a NCAA pool app written in coldfusion they'd be interested in sharing? =) A former co-worker of mine wrote one last year. What's interesting is that he allowed you to enter the number of arrests for players and the severity of each crime for each teams for the past 4 years, and it would factor in the likelyhood of a starter being arrested and affecting the teams's seeding and chance at winning. Who knows if it was accurate, but it sure as hell was intersting to play with! -- Alex - Rick ~| 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:198646 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: Problems at CrystalTech have gotten ugly!
Jared Rypka-Hauer wrote: I was under the impression that the error came up when the CF session timed out first, but, logically, that makes no sense. If the CF session timed out, it would just ask Jrun for a new one... so the issue pops up when CF expects Jrun to be holding session information and Jrun can only reply with a session undefined error. So I'd set the Jrun sessions to time out, say, 5 minutes past the CF sessions. That way, if CF kills a session and Jrun creates a new one, you've only got a few minutes of overlap. Conversely, since CF sessions will ALWAYS time out before the Jrun sessions, Jrun will never be expected to remember session information for CF that it has already dropped because it times out first. So c'mon, you guys, what's the big issue here? :P That worked for 6.1. That stopped working in version 7. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| 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:198647 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: Problems at CrystalTech have gotten ugly!
*watches the SmugBug sitting on his desk die, crumble into dust, and blow away in the breeze from the forced-air furnace since it's 9 degrees outside this morning* Yep, it's Monday... ;) I tried! I really, really tried! Laterz, J On Mon, 14 Mar 2005 10:13:21 -0500, Bud [EMAIL PROTECTED] wrote: Jared Rypka-Hauer wrote: I was under the impression that the error came up when the CF session timed out first, but, logically, that makes no sense. If the CF session timed out, it would just ask Jrun for a new one... so the issue pops up when CF expects Jrun to be holding session information and Jrun can only reply with a session undefined error. So I'd set the Jrun sessions to time out, say, 5 minutes past the CF sessions. That way, if CF kills a session and Jrun creates a new one, you've only got a few minutes of overlap. Conversely, since CF sessions will ALWAYS time out before the Jrun sessions, Jrun will never be expected to remember session information for CF that it has already dropped because it times out first. So c'mon, you guys, what's the big issue here? :P That worked for 6.1. That stopped working in version 7. -- Bud Schneehagen - Tropical Web Creations, Inc. -- 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:198648 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 select statement help..
Hello everybody, I really need someone to help me here. I'm developing a graphical interface to report the no of jobs logged in a period. The x axis displays the period (days) and the y-axis displays the number of jobs logged in a given day. The data is pulled from the jobs table. The job logged date value is stored in the logdateTime column. I've written a stored procedure to get the count of jobs logged in a given day. Here is the code. cfquery name=qJobsLogged datasource=dbname EXEC countJobsLogged @startdatedate = '2005/02/01', @stopdate = '2005/02/28' /cfquery !-- sp code starts here -- CREATE proc countJobsLogged @startdate datetime, @stopdate datetime as set nocount on declare @x datetime, @count int create table #temp_report( dtlogged varchar(15), jobsCount int ) select @x = @startdate while @x = @stopdate begin select @count = isnull(count(1),0) from jobs where logdatetime = @x + '00:00:00' and logdatetime = @x + '23:59:59' insert into #temp_report values(convert(varchar(15),@x,106), @count) select @x = dateadd(d, 1, @x) end select * from #temp_report drop table #temp_report set nocount off GO !-- sp code ends here -- The above sp loops from the user selected start date to the user selected end date and returns a recordset showing the no of jobs logged. Ex JOBSCOUNT DTLOGGED 2 01 Feb 2005 3 02 Feb 2005 4 03 Feb 2005 So far so good. I want to modify the select stmt in that I want it to also return the jobPriority and the jobNumber (these are columns in the job table) for jobs that it found logged on a particular day. So for example if say for ex, there are 2 jobs logged on the 01 Feb 2005, I want the final recordset to look something like this JOBSCOUNT DTLOGGEDjobPriority jobNumber 2 01 Feb 2005 3 01JS1003 2 01 Feb 2005 2 01JS1004 3 02 Feb 2005 4 01JS1005 3 02 Feb 2005 4 01JS1006 3 02 Feb 2005 5 01JS1016 4 03 Feb 2005 1 01JS1018 4 03 Feb 2005 2 01JS1020 4 03 Feb 2005 3 01JS1021 4 03 Feb 2005 4 01JS1022 I was hoping someone could show me the sql to achieve this result Best regards cfcoder ~| 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:198649 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: Gmail highlighting
Hmm, would em be more appropriate in that context? - Calvin -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:37 AM To: CF-Talk Subject: RE: Gmail highlighting When taking a semantic approach, I would consider using strong for highlighting. Not span. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - - ~| 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:198650 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 - UI problems
I have to disagree. This is very much on topic in my opinion. Since when is discussing UI design for a CF application not appropriate for cf-talk? I liked the rest of your post, very useful and well written. - Calvin -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Sunday, March 13, 2005 3:59 PM To: CF-Talk Subject: RE: OT - UI problems -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Sunday, March 13, 2005 9:51 AM To: CF-Talk Subject: OT - UI problems Hello All, First off you might consider posting this to cf-community - the discussion there could go much farther than here. ~| 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:198651 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: Gmail highlighting
At first I would say yes, EM would be a good candidate, however I would reserve EM for larger code blocks. Like a note, a warning, etc. This part states you might better use strong for it. But honestly, I wouldn't care while both have their semantics in letting content stand out. Thus, it would be logical to define that em emphasizes the enclosed text with respect to the text in the enclosing element and should be rendered in a manner that reflects this; whereas strong (renamed to e.g. key or highlight, if we give up continuity, as planned for XHTML 2.0) would indicate its content as key word or phrase in the context of the entire document, to appear as highlighted when possible, and to gain special weight in indexing. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: maandag 14 maart 2005 16:26 To: CF-Talk Subject: RE: Gmail highlighting Hmm, would em be more appropriate in that context? - Calvin -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:37 AM To: CF-Talk Subject: RE: Gmail highlighting When taking a semantic approach, I would consider using strong for highlighting. Not span. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - - ~| 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:198652 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: Gmail highlighting
So, say, in terms of a wiki... strong would be viable for terms while em would suffice for meta-information like last-updated-by: Blah blah blah strongwiki term/strong blah blah blah strongthe end of the world/strong blah blah blah strongDouglas Adams/strong emEntry created by Fred Smith, last updated on March 19, 1963, by John Anderson/em In other words, strong would act as a callout and em would be used to provide details for the entire entry. Is that the idea? J On Mon, 14 Mar 2005 16:33:22 +0100, Micha Schopman [EMAIL PROTECTED] wrote: At first I would say yes, EM would be a good candidate, however I would reserve EM for larger code blocks. Like a note, a warning, etc. This part states you might better use strong for it. But honestly, I wouldn't care while both have their semantics in letting content stand out. Thus, it would be logical to define that em emphasizes the enclosed text with respect to the text in the enclosing element and should be rendered in a manner that reflects this; whereas strong (renamed to e.g. key or highlight, if we give up continuity, as planned for XHTML 2.0) would indicate its content as key word or phrase in the context of the entire document, to appear as highlighted when possible, and to gain special weight in indexing. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: maandag 14 maart 2005 16:26 To: CF-Talk Subject: RE: Gmail highlighting Hmm, would em be more appropriate in that context? - Calvin -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:37 AM To: CF-Talk Subject: RE: Gmail highlighting When taking a semantic approach, I would consider using strong for highlighting. Not span. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - - ~| 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:198653 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: Gmail highlighting
So, in that scenario, I would consider the following: In the CSS put... #searchResults strong {background-color: #00} In the HTML... div id=searchResults You can stronghighlight/strong text within search results. /div This results in less code! Of course you can only have one search results div using this solution. - Calvin -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 10:33 AM To: CF-Talk Subject: RE: Gmail highlighting At first I would say yes, EM would be a good candidate, however I would reserve EM for larger code blocks. Like a note, a warning, etc. This part states you might better use strong for it. But honestly, I wouldn't care while both have their semantics in letting content stand out. Thus, it would be logical to define that em emphasizes the enclosed text with respect to the text in the enclosing element and should be rendered in a manner that reflects this; whereas strong (renamed to e.g. key or highlight, if we give up continuity, as planned for XHTML 2.0) would indicate its content as key word or phrase in the context of the entire document, to appear as highlighted when possible, and to gain special weight in indexing. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: maandag 14 maart 2005 16:26 To: CF-Talk Subject: RE: Gmail highlighting Hmm, would em be more appropriate in that context? - Calvin -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:37 AM To: CF-Talk Subject: RE: Gmail highlighting When taking a semantic approach, I would consider using strong for highlighting. Not span. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - - ~| 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:198654 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 - UI problems
Can someone send me Jim's note I did not get it, strange? - Original Message - From: Calvin Ward [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 14, 2005 10:30 AM Subject: RE: OT - UI problems I have to disagree. This is very much on topic in my opinion. Since when is discussing UI design for a CF application not appropriate for cf-talk? I liked the rest of your post, very useful and well written. - Calvin -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Sunday, March 13, 2005 3:59 PM To: CF-Talk Subject: RE: OT - UI problems -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Sunday, March 13, 2005 9:51 AM To: CF-Talk Subject: OT - UI problems Hello All, First off you might consider posting this to cf-community - the discussion there could go much farther than here. ~| 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:198655 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: Gmail highlighting
Yes, that is the idea. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: maandag 14 maart 2005 16:52 To: CF-Talk Subject: Re: Gmail highlighting So, say, in terms of a wiki... strong would be viable for terms while em would suffice for meta-information like last-updated-by: Blah blah blah strongwiki term/strong blah blah blah strongthe end of the world/strong blah blah blah strongDouglas Adams/strong emEntry created by Fred Smith, last updated on March 19, 1963, by John Anderson/em In other words, strong would act as a callout and em would be used to provide details for the entire entry. Is that the idea? J On Mon, 14 Mar 2005 16:33:22 +0100, Micha Schopman [EMAIL PROTECTED] wrote: At first I would say yes, EM would be a good candidate, however I would reserve EM for larger code blocks. Like a note, a warning, etc. This part states you might better use strong for it. But honestly, I wouldn't care while both have their semantics in letting content stand out. Thus, it would be logical to define that em emphasizes the enclosed text with respect to the text in the enclosing element and should be rendered in a manner that reflects this; whereas strong (renamed to e.g. key or highlight, if we give up continuity, as planned for XHTML 2.0) would indicate its content as key word or phrase in the context of the entire document, to appear as highlighted when possible, and to gain special weight in indexing. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: maandag 14 maart 2005 16:26 To: CF-Talk Subject: RE: Gmail highlighting Hmm, would em be more appropriate in that context? - Calvin -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:37 AM To: CF-Talk Subject: RE: Gmail highlighting When taking a semantic approach, I would consider using strong for highlighting. Not span. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - - ~| 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:198656 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: sql select statement help..
Cfcoder, = select count(*) as numofjobs, jobPriority, jobNumber from jobs where logdatetime = #startdate# and logdatetime = #stopdate# group by logdatetime, jobPriority, jobNumber order by logdatetime,jobNumber -- if need orderby = -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 9:23 AM To: CF-Talk Subject: sql select statement help.. Hello everybody, I really need someone to help me here. I'm developing a graphical interface to report the no of jobs logged in a period. The x axis displays the period (days) and the y-axis displays the number of jobs logged in a given day. The data is pulled from the jobs table. The job logged date value is stored in the logdateTime column. I've written a stored procedure to get the count of jobs logged in a given day. Here is the code. cfquery name=qJobsLogged datasource=dbname EXEC countJobsLogged @startdatedate = '2005/02/01', @stopdate = '2005/02/28' /cfquery !-- sp code starts here -- CREATE proc countJobsLogged @startdate datetime, @stopdate datetime as set nocount on declare @x datetime, @count int create table #temp_report( dtlogged varchar(15), jobsCount int ) select @x = @startdate while @x = @stopdate begin select @count = isnull(count(1),0) from jobs where logdatetime = @x + '00:00:00' and logdatetime = @x + '23:59:59' insert into #temp_report values(convert(varchar(15),@x,106), @count) select @x = dateadd(d, 1, @x) end select * from #temp_report drop table #temp_report set nocount off GO !-- sp code ends here -- The above sp loops from the user selected start date to the user selected end date and returns a recordset showing the no of jobs logged. Ex JOBSCOUNT DTLOGGED 2 01 Feb 2005 3 02 Feb 2005 4 03 Feb 2005 So far so good. I want to modify the select stmt in that I want it to also return the jobPriority and the jobNumber (these are columns in the job table) for jobs that it found logged on a particular day. So for example if say for ex, there are 2 jobs logged on the 01 Feb 2005, I want the final recordset to look something like this JOBSCOUNT DTLOGGEDjobPriority jobNumber 2 01 Feb 2005 3 01JS1003 2 01 Feb 2005 2 01JS1004 3 02 Feb 2005 4 01JS1005 3 02 Feb 2005 4 01JS1006 3 02 Feb 2005 5 01JS1016 4 03 Feb 2005 1 01JS1018 4 03 Feb 2005 2 01JS1020 4 03 Feb 2005 3 01JS1021 4 03 Feb 2005 4 01JS1022 I was hoping someone could show me the sql to achieve this result Best regards cfcoder ~| 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:198657 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: sql select statement help..
Which will of course return a job count of 1 for each row, since it is grouped by jobNumber. To get the result set you want, if your DB supports it, you will need a referential subquery something like this: select j.jobPriority, j.jobNumber, (select count(*) as numofjobs from jobs where jobs.logdatetime = j.logdatetime) from jobs j where j.logdatetime = #startdate# and j.logdatetime = #stopdate# This assumes that logdatetime is just a date, not a date and time - you might need to convert to a date part only in the subquery so the equality holds true. -Original Message- From: Hua Wei [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 March 2005 12:14 To: CF-Talk Subject: RE: sql select statement help.. Cfcoder, = select count(*) as numofjobs, jobPriority, jobNumber from jobs where logdatetime = #startdate# and logdatetime = #stopdate# group by logdatetime, jobPriority, jobNumber order by logdatetime,jobNumber -- if need orderby ~| 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:198658 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 ( ms sql ) alter command
I wish to modify an existing table by increasing the varchar limit from 1000 to 2000. Is there a alter table command that can be used after the field has been created? ~| 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:198659 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
WDDX Status?
Does anybody know if the WDDX implementation in CF 7 is actually updated from previous versions? Is there any work on the project? More to the point will the current release (now well over 5 year old) still work in modern Java/JavaScript implementations? Any other tool that's as easy to use for the same thing? I ask because I'm working on a project now and we've just lost our middleware (WebSphere/Struts) guy - we've since found out that his code was pure shite. I'm building a decoupled interface purely in JavaScript/DHTML (as an IE HTA) and right now were passing data using a custom XML DOM dialect of my design - but it lacks a schema/DTD and requires custom programming and such. I'm considering suggesting using something more mature - WDDX would certainly fit the bill, but I've already fought too many battles to get the inteface logic on the client. I don't want to deal with the flak should it turn out that the old WDDX SDK code just isn't going to work. Any suggestions? I've looked at SOAP as well, but as you need to define all the elements anyway it would probably be easier to stick with what we have. Thanks, 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:198660 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: sql select statement help..
As long as jobNumber is not a unique field, the query works. select count(*) as numofjobs, convert(char(10),logdatetime,101) as DTLOGGED, jobPriority, jobNumber from jobs where logdatetime = '02/01/2005' and logdatetime = '02/02/2005' group by convert(char(10),logdatetime,101), jobPriority, jobNumber === Here is a test: create table jobs ( jobid int identity, jobPriority int, jobNumber varchar(30), logdatetime datetime) insert into jobs(jobPriority,jobNumber,logdatetime) values(3,'01JS1003','02/01/2005') insert into jobs(jobPriority,jobNumber,logdatetime) values(3,'01JS1003','02/01/2005') insert into jobs(jobPriority,jobNumber,logdatetime) values(2,'01JS1004','02/01/2005') numofjobs DTLOGGED jobPriority jobNumber --- -- --- -- 1 02/01/2005 2 01JS1004 2 02/01/2005 3 01JS1003 (2 row(s) affected) -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 11:43 AM To: CF-Talk Subject: RE: sql select statement help.. Which will of course return a job count of 1 for each row, since it is grouped by jobNumber. To get the result set you want, if your DB supports it, you will need a referential subquery something like this: select j.jobPriority, j.jobNumber, (select count(*) as numofjobs from jobs where jobs.logdatetime = j.logdatetime) from jobs j where j.logdatetime = #startdate# and j.logdatetime = #stopdate# This assumes that logdatetime is just a date, not a date and time - you might need to convert to a date part only in the subquery so the equality holds true. -Original Message- From: Hua Wei [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 March 2005 12:14 To: CF-Talk Subject: RE: sql select statement help.. Cfcoder, = select count(*) as numofjobs, jobPriority, jobNumber from jobs where logdatetime = #startdate# and logdatetime = #stopdate# group by logdatetime, jobPriority, jobNumber order by logdatetime,jobNumber -- if need orderby ~| 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:198661 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: sql ( ms sql ) alter command
On mssql 2000, alter table [tablename] alter column [columnname] varchar(2000) -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 10:51 AM To: CF-Talk Subject: sql ( ms sql ) alter command I wish to modify an existing table by increasing the varchar limit from 1000 to 2000. Is there a alter table command that can be used after the field has been created? ~| 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:198662 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: WDDX Status?
Sorry folks - I meant that for CF_Community. It's really off-topic for this list. That being said I'd still like to hear what you have to say - but please post to the CF-community thread if possible. Jim Davis ~| 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:198663 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
FCKeditor - Dynamic Browse and Upload Directory
Anyone have a solution for setting the image browse and upload path in FCKeditor (version 2 with the default CF connector)? I'd like to share the editor among several sites. I've searched the FCKeditor forum, as well as this list, but haven't seen a solution. Thanks, Brad ~| 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:198664 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: Document Literal WebService with CFMX6.1
That's great news Larry. Look forward to hearing what Doug has done. I managed to get around what I needed to do by creating the SOAP envelope using CFXML and using CFHTTP to post it to the web service in question, but I would rather use the CFINVOKE/CreateObject path with structures. Thanks, Phil Robert -- You're not alone in facing the problem of how to invoke a web service that requires as input a complex-within-complex XML document. The documentation does not cover this and, in my opinion, does not even provide any hints as to what direction to head in to resolve this sort of a problem. I've been banging my head against this for quite some time, and more recently I involved my developer, Doug James, who quickly came to share my cephalgia. Fortunately, with a couple of helpful pointers from Tom Jordahl (the guy at Macromedia who, it seems, developed the web services piece of CFMX), Doug finally figured out last week how to represent a complex-within-complex XML document in CF structure form. Doug is in the process of touching up his work and will be posting a how to soon on cf-talk and on the support forum, and perhaps the LiveDocs as well. If you can't wait until Doug posts, you're welcome to contact him at [EMAIL PROTECTED], but he may or may not be able to respond depending on how tied up he is at the time. -- Larry Afrin Hollings Cancer Center Medical University of South Carolina [EMAIL PROTECTED] ~| 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:198665 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: WDDX Status?
Does anybody know if the WDDX implementation in CF 7 is actually updated from previous versions? Is there any work on the project? I would be surprised if there have been any recent changes to it, or if there ever will be. What's to change, after all? You can still use WDDX to describe generic datatypes. More to the point will the current release (now well over 5 year old) still work in modern Java/JavaScript implementations? The JavaScript stuff should continue to work fine. It's pretty simple JavaScript. Any suggestions? I've looked at SOAP as well, but as you need to define all the elements anyway it would probably be easier to stick with what we have. SOAP is a transport protocol which is only useful in the context of web services. Why not just write your own schema? It's not that difficult to do this. I don't see much reason to bother with WDDX if you have a more domain-specific way to talk about your data. 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! ~| 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:198666 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
Structuring Shared Resources for Related Web Sites on Same Server
I am planning on rebuilding two web sites that exist on the same server. A few sections of each site will share related information. Given that, are there any suggestions as to how I can structure my site so that shared resources (udfs, cfcs, cust tags, etc) are visible to each site yet not really tied to a particular site? Also, I am using CF Standard, with a slim chance of upgrading to CF Enterprise. This is what I was thinking: D:\Inetpub\App1 D:\Inetpub\App1\Extensions\ D:\Inetpub\App1\Extensions\Components D:\Inetpub\App1\Extensions\CustTags D:\Inetpub\App1\Extensions\Includes D:\Inetpub\App2 D:\Inetpub\App2\Extensions\ D:\Inetpub\App2\Extensions\Components D:\Inetpub\App2\Extensions\CustTags D:\Inetpub\App2\Extensions\Includes D:\Inetpub\Shared D:\Inetpub\Shared\Images D:\Inetpub\Shared\Extensions\ D:\Inetpub\App2\Extensions\Components D:\Inetpub\App2\Extensions\CustTags D:\Inetpub\App2\Extensions\Includes Once I had a structure like this, I would create the appropriate IIS virtuals and CF mappings. Any suggestions for a better way? Thanks M!ke ~| 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:198667 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
Dynamic Linking to Mapquest?
I searched the MM exchange, but the tags that I found don't seem to work anymore due to updates in the mappers sites. Anyone have a tag or link to a function where I can pass the address and get a map? Mapquest or Yahoo maps or google maps, etc... ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198668 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
getting remote data
To date my CF apps have been on a server on our campus network. That makes it simple to get to the data with MS Access. I'm working on a couple of apps that will be hosted on a commercial server so I'll be ftping to it. I've split my data into two databases - one that will not be written to (but read) by users that we can change by putting a new database up on the site. The response data from the users goes into a separate database that will accumulate data over years. Before I come up with a solution somewhere between elegant and klunky to get this data - what do you do? (I've thought of ftping the entire database down but see some problems with that, especially as it ages and gets bigger.) Larry V. Stephens Office of Risk Management 812-855-9758 [EMAIL PROTECTED] ~| 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:198669 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: WDDX Status?
SOAP is a transport protocol which is only useful in the context of web services. Why not just write your own schema? It's not that difficult to do this. I don't see much reason to bother with WDDX if you have a more domain-specific way to talk about your data. Right now it's purely business-BS. We're under some severe time restrictions. The diaclect I've come up with isn't so very insanely different than WDDX, really - it simply describes a header and body where the body may contain one or more recordsets. Record sets are defined generically, not domain specifically. I've built all of the required JavaScript code for this - but we've recently discovered that our off-shore contractor (who's left suddenly) did not create generic java objects for the dialect - instead every instance of its use was essentially one-off, non-portable code. Since he only did a little work on it, and we've got much, much more to go I was considering a change to allow for faster development (I assume having the WDDX java object could speed things up at this stage). 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:198670 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: FCKeditor - Dynamic Browse and Upload Directory
I customized the CF connector to allow this. Basically there are a few variables that are set that get used in the actual read/write calls that are necessary for the function to work. The majority of that connector is just figure out what the path should be based on the current tag location, etc. I took all of that out and just set those variables equal to an application or session variable which was a path I knew existed and that I wanted the files written to. Then you can change the path more easily from within your own application. If people have questions let me know and I can give specifics. Basically, just look at the CFFILE calls and see the variables that will be needed and write it so that you can set those from within your application. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:12 PM To: CF-Talk Subject: FCKeditor - Dynamic Browse and Upload Directory Anyone have a solution for setting the image browse and upload path in FCKeditor (version 2 with the default CF connector)? I'd like to share the editor among several sites. I've searched the FCKeditor forum, as well as this list, but haven't seen a solution. Thanks, Brad ~| 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:198671 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: FCKeditor - Dynamic Browse and Upload Directory
Brad Roberts wrote: Anyone have a solution for setting the image browse and upload path in FCKeditor (version 2 with the default CF connector)? I'd like to share the editor among several sites. I'm actually (right now) in the middle of writing our own connector to cope with the virtual image directories we use for cached on-the-fly scaling and mangling of images, but the following should work fine with the standard connector unhacked. You don't say if you're on a Windows or *ix server, but the basic solution we use here under Linux/Apache is to symlink the connector to somewhere within the vhost's directory tree (the top level image selection directory is a good place). If that's not possible on your platform, you can always actually copy the connector. You'll need, of course, to put the fckeditor files themselves in a shared location and update the js config to reflect the new (symlinked) location of the connector. FCKConfig.ImageBrowserURL = FCKConfig.BasePath + 'filemanager/browser/default/browser.cfm?Type=ImageConnector=/images/connector.cfm'; for example. This is all necessary because of ColdFusion's continuing bizarre failure to let an app know what the vhost's base directory actually is; there's no way to find out from a file that isn't (as far as ColdFusion is concerned) physically in that directory tree. Exposure of CGI.DOCUMENT_ROOT (if available) would make life *much* easier... There are other ways of doing this, of course: say, a database lookup on CGI.SERVER_NAME or just an application variable, but these would require changes to the default connector. -- Pete Jordan Horus Web Engineering Ltd http://www.webhorus.net/ ~| 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:198672 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: FCKeditor - Dynamic Browse and Upload Directory
I think the settings for this are in one of the *.js files. ~| 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:198673 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
LDAP
My boss asked me to hook into our ldap system for password validation and I'm looking for any heads-up or advice that I could get. Do people use cfLDAP for this? If I have an app and I just want a few people to have access to it, do I use a DB to store access groups and names of people and use LDAP to verify the passwords? How would that normally work? thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| 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:198674 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: LDAP
KNOW YOUR LDAP CONFIGURATION. The ldap tag is pretty straight forward to use, if you know how your ldap has been configured. We currently use ours to control access based on NT security groups, stored in our ldap data. We currently do not do password verification with ldap, we do that directly against NT the NT security CFC from one can get from Macromedia's website. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 10:32 AM To: CF-Talk Subject: LDAP My boss asked me to hook into our ldap system for password validation and I'm looking for any heads-up or advice that I could get. Do people use cfLDAP for this? If I have an app and I just want a few people to have access to it, do I use a DB to store access groups and names of people and use LDAP to verify the passwords? How would that normally work? thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198675 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: LDAP
What brand of LDAP server are you planning on using? If it's Windows Active Directory, there are some things to know about. I use IIS/browser authentication for our intranet, but I use CFLDAP to connect to Active Directory to get group membership for each user. I also pull mailbox-related information for Exchange mailbox size reporting. I'm planning on rewriting my intranet so that I can use an html form for username/password to make it a bit more portable on PDAs and other mobile devices. If you have an LDAP server, use it rather than creating a DB to hold security information. You can add people to group, add attributes, etc. LDAP is mainly geared for user-type storage so there is little reason to rebuild if LDAP will support your requirements. If you plan on selling this system, then a DB would be a bit more portable than LDAP. M!ke -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:32 PM To: CF-Talk Subject: LDAP My boss asked me to hook into our ldap system for password validation and I'm looking for any heads-up or advice that I could get. Do people use cfLDAP for this? If I have an app and I just want a few people to have access to it, do I use a DB to store access groups and names of people and use LDAP to verify the passwords? How would that normally work? thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| 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:198676 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
Anyone creating CF7 flashpaper reports outside of report builder?
I don't know why I thought that the coldfusion reports were being stored in an xml and xslt file- apparently I'm nuts. I tested out report builder and the report metadata is stored in the.cfr file which is pretty much encrypted and not easily database-enabled. You want to build a new report? Fire up the client server app. I have a data structure for our reports already spec'd out and I wanted to take that info and export it to flashpaper. Is anyone doing this currently, outside of Report Builder? I think I'm missing something obvious... Thanks, Don ~| 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:198677 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: LDAP
we use LDAP for authentication on our intranet apps. We use a sun ONE IIRC. Its fairly easy to use cfldap tag for this. Googling should get you an example or three. I suggest getting the ldap browser tool from softerra, its free, and it simply rocks. D On Mon, 14 Mar 2005 12:50:42 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: What brand of LDAP server are you planning on using? If it's Windows Active Directory, there are some things to know about. I use IIS/browser authentication for our intranet, but I use CFLDAP to connect to Active Directory to get group membership for each user. I also pull mailbox-related information for Exchange mailbox size reporting. I'm planning on rewriting my intranet so that I can use an html form for username/password to make it a bit more portable on PDAs and other mobile devices. If you have an LDAP server, use it rather than creating a DB to hold security information. You can add people to group, add attributes, etc. LDAP is mainly geared for user-type storage so there is little reason to rebuild if LDAP will support your requirements. If you plan on selling this system, then a DB would be a bit more portable than LDAP. M!ke -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:32 PM To: CF-Talk Subject: LDAP My boss asked me to hook into our ldap system for password validation and I'm looking for any heads-up or advice that I could get. Do people use cfLDAP for this? If I have an app and I just want a few people to have access to it, do I use a DB to store access groups and names of people and use LDAP to verify the passwords? How would that normally work? thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| 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:198678 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: LDAP
What brand of LDAP server are you planning on using? If it's Windows Active Directory, there are some things to know about. I don't know which LDAP server it is because I didn't realize I needed to know, hmmm. Time to ask. But it's the University of Maryland so I guess it's something that scales well. If you have an LDAP server, use it rather than creating a DB to hold security information. You can add people to group, add attributes, etc. LDAP is mainly geared for user-type storage so there is little reason to rebuild if LDAP will support your requirements. I don't know much about LDAPs. Are you saying that I can introduce my own group type and add existing people too it? I only want these two people into the Admin parts of my app, so could I make a group called myApp_admin and add them to it without affecting their current setup? and I'll look into the softerra tool, thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198679 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
URL masking and application.cfc
I've been thinking of a new method of presenting dynamic content, specifically the list archives. At the moment you get to a single post by passing an ID on the url. Even if this is 'hidden' using SES Urls or the like, your still passing something. My idea is to use the application.cfc to 'catch' a specific type of 404 error and in place of an error, run a page. Take for example this url: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:38946 In its place I want to use this url: http://www.houseoffusion.com/cf_lists/messages_4_38946.cfm When the onRequestStart or onRequest action is run, I'd like to change the page requested from messages_4_38946.cfm to messages.cfm and turn the rest of the url into the proper variables. Looks totally do-able and I'll be playing with it tonight. The reason I'm mentioning it is to see if anyone else has done this already, anyone finds this interesting and wants to try it and anyone wants to comment on it. I think it's a nice usage of application.cfc, but if others find it to be flawed, I'd like to hear it early on. ~| 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:198680 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 Join Challenge
I have run across a problem for which I think a SQL solution should exist. I essentially need to do a left-join on two columns. I need to get every row from one table (say lessons) and any rows from another (say students) for which the LessonID columns of each table match AND where the StudentID of the students table matches a given value. I cannot find a way to get this result set and still have one and only one row for each record in the lessons table. I would google for this, but I don't even know what to search for. Anyone have any ideas? Thanks! Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com http://steve.coldfusionjournal.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:198681 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: Anyone creating CF7 flashpaper reports outside of report builder?
Don, The reports are stored in an XML file which was encrypted for your protection:)! Which at times makes debugging a bit more of a challenge. Rick Mason On Mon, 14 Mar 2005 14:00:06 -0500, Don Smith [EMAIL PROTECTED] wrote: I don't know why I thought that the coldfusion reports were being stored in an xml and xslt file- apparently I'm nuts. I tested out report builder and the report metadata is stored in the.cfr file which is pretty much encrypted and not easily database-enabled. You want to build a new report? Fire up the client server app. I have a data structure for our reports already spec'd out and I wanted to take that info and export it to flashpaper. Is anyone doing this currently, outside of Report Builder? I think I'm missing something obvious... Thanks, Don ~| 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:198682 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: URL masking and application.cfc
I did this at a company I worked for in order to catch error pages. What we did was grab the path after the domain and run that through our search tool automatically. Our search tool kept track of common searches and especially ones that returned zero results, so we had a table where we could set up common searches and specify where to direct them to. We ended up using all of that in combination with advertising urls (much like www.dell.com/tv ) but we had hundreds of different ads going out to different magazines and management wanted to track the response for each ad. So, we gave them the ability to create these search urls on their own and when people came to that url, it would run the 404 page which would in turn run the search for that term and jump them to the appropriate page. It was all pretty slick and was transparent to the user. The only thing that sucked was any time you ran a log analyzer you had a ton of 404 errors which looked bad, but that wasn't a problem unless we showed those reports to management and then that was always a red flag to them. Once we explained, that seemed to help though. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:17 PM To: CF-Talk Subject: URL masking and application.cfc I've been thinking of a new method of presenting dynamic content, specifically the list archives. At the moment you get to a single post by passing an ID on the url. Even if this is 'hidden' using SES Urls or the like, your still passing something. My idea is to use the application.cfc to 'catch' a specific type of 404 error and in place of an error, run a page. Take for example this url: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:38 946 In its place I want to use this url: http://www.houseoffusion.com/cf_lists/messages_4_38946.cfm When the onRequestStart or onRequest action is run, I'd like to change the page requested from messages_4_38946.cfm to messages.cfm and turn the rest of the url into the proper variables. Looks totally do-able and I'll be playing with it tonight. The reason I'm mentioning it is to see if anyone else has done this already, anyone finds this interesting and wants to try it and anyone wants to comment on it. I think it's a nice usage of application.cfc, but if others find it to be flawed, I'd like to hear it early on. ~| 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:198683 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Join Challenge
Would this work or am I missing a piece of the puzzle? Select * From lessons Left join lessons on lessons.lessonID = students.lessonID Where students.studentID = #studentID# John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Steve Bryant [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 1:42 PM To: CF-Talk Subject: SQL Join Challenge I have run across a problem for which I think a SQL solution should exist. I essentially need to do a left-join on two columns. I need to get every row from one table (say lessons) and any rows from another (say students) for which the LessonID columns of each table match AND where the StudentID of the students table matches a given value. I cannot find a way to get this result set and still have one and only one row for each record in the lessons table. I would google for this, but I don't even know what to search for. Anyone have any ideas? Thanks! Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com http://steve.coldfusionjournal.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:198684 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: CFMX 7 Cfgrid Flash vs Applet
There isn't a recommended number, There are a lot of variables so publishing a recommendation is a little hard. It's pretty much up to you on what you think is reasonable. With that said, what you are seeing makes sense, we know that the flash components can't handle the amount of data that the applets can. This is one reason we didn't get rid of the applets (some people love to dump a lot of data into the grid). I would try to keep the amount of data as low as possible, especially if you have users with older and slower machines. Hth, ---nimer -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Sunday, March 13, 2005 8:29 PM To: CF-Talk Subject: Re: CFMX 7 Cfgrid Flash vs Applet Mike, just tried this this way: cfquery name=test datasource=iislogs select top 100 * from CFObjectiveLog /cfquery cfform format=Flash width=800 height=600 skin=haloBlue cfformgroup type=Hbox width=600 height=500 cfgrid name=testGrid query=test width=1000 height=#test.recordcount*21# / /cfformgroup /cfform That's COOL... but, doing this this way, if I get to around 500 records, the thing bogs down and dies. Firefox actually asks permission to kill the Flash scripts. Is there a recommended max recordcount for Flash cfgrid counts? Thanks, Jared On Sun, 13 Mar 2005 18:40:30 -0500, Mike Nimer [EMAIL PROTECTED] wrote: Place the grid inside a cfformgroup type=Hbox, and set the height/width of the group to fit your layout, and the height/width of the grid to match the size of the data. Hth, ---nimer -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 9:51 PM To: CF-Talk Subject: CFMX 7 Cfgrid Flash vs Applet I was excited to use the new flash format with the CFGRID tag. And while it looks great for small recordsets with a low column count, it is nowhere near as fast as the applet version and loads very slowly when the columns are greater than 20 or so. Has anyone had any positive experiences with the grid? It looks awesome, just seems a bit sluggish. Also, its sluggish when scrolling large recordsets (large actually just being 300+ records). I'm also looking for way to enable horizontal scrolling with the flash cfgrid. Is this possible? Brook ~| 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:198685 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: LDAP
I don't know much about LDAPs. Are you saying that I can introduce my own group type and add existing people too it? I only want these two people into the Admin parts of my app, so could I make a group called myApp_admin and add them to it without affecting their current setup? Exactly, that's pretty much the whole point of ldap. You can create any kind of branches you like, and add new nodes all over the place. That can be a bit of a problem, but it's in the management of the ldap data. We are finding that our manager(s) liked to create security groups in several different nodes. It has been a bit interesting. I second the softerra browswer, once I had that, it became much easier, then the old trial and error approach I was first using. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 10:30 AM To: CF-Talk Subject: Re: LDAP What brand of LDAP server are you planning on using? If it's Windows Active Directory, there are some things to know about. I don't know which LDAP server it is because I didn't realize I needed to know, hmmm. Time to ask. But it's the University of Maryland so I guess it's something that scales well. If you have an LDAP server, use it rather than creating a DB to hold security information. You can add people to group, add attributes, etc. LDAP is mainly geared for user-type storage so there is little reason to rebuild if LDAP will support your requirements. I don't know much about LDAPs. Are you saying that I can introduce my own group type and add existing people too it? I only want these two people into the Admin parts of my app, so could I make a group called myApp_admin and add them to it without affecting their current setup? and I'll look into the softerra tool, thanks. ~| 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:198686 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: SQL Join Challenge
Nope. That returns only rows from lessons where either no matching row exists in the students table at all or where a matching row exists for that student. In other words, it eliminates any lessons for which there is a match in the students table, but not for the given student. Steve Would this work or am I missing a piece of the puzzle? Select * From lessons Left join lessons on lessons.lessonID = students.lessonID Where students.studentID = #studentID# John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| 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:198687 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: SQL Join Challenge
Steve Bryant wrote: I have run across a problem for which I think a SQL solution should exist. I essentially need to do a left-join on two columns. I need to get every row from one table (say lessons) and any rows from another (say students) for which the LessonID columns of each table match AND where the StudentID of the students table matches a given value. I cannot find a way to get this result set and still have one and only one row for each record in the lessons table. SELECT * FROM lessons LEFT JOIN students ON lessons.lessonID = students.lessonID WHERE students.studentID = #studentID# OR students.studentID IS NULL Jochem ~| 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:198689 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Join Challenge
How about something like this? Not sure if it does the join before or after the where clause... Select * from lessons left join students on lessons.lessonID=students.lessonID where students.studentID=#studentID# or ISNULL students.studentID -Original Message- From: Steve Bryant [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 3:16 PM To: CF-Talk Subject: Re: SQL Join Challenge Nope. That returns only rows from lessons where either no matching row exists in the students table at all or where a matching row exists for that student. In other words, it eliminates any lessons for which there is a match in the students table, but not for the given student. Steve Would this work or am I missing a piece of the puzzle? Select * From lessons Left join lessons on lessons.lessonID = students.lessonID Where students.studentID = #studentID# John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| 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:198690 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: SQL Join Challenge
Steve Bryant wrote: Nope. That returns only rows from lessons where either no matching row exists in the students table at all or where a matching row exists for that student. In other words, it eliminates any lessons for which there is a match in the students table, but not for the given student. Then... LEFT JOIN lessions ON lessions.lessionId = students.lessonID WHERE students.studentId = #studentId# OR students.studentId IS NULL Is that what you mean? K. ~| 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:198691 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
Dealing with bounced email
I am working with an iMail mailing list for a relatively large organization and need to work on a way to deal with bounced mailing list messages. When the messages come back, they are delivered to the mailing list owner's mailbox. What I'd like to do is download the mail messages with CFPOP, figure out the email address that bounced and then mark it off in my database as a bouncing address (The mailing list is automatically synced up with a membership database). The problem I am having is that I am seeing alot of different formats for bounced mail messages. I could just strip out any and all email addresses and mark the ones that it finds in the database, but the trouble is that often one of the addresses is the sender's email address and I haven't figured out a reliable way to exclude that address. Can anyone make any suggestions on how this could be done reliably? Thanks! __ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198692 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
CFCs and paths...I'm having a couple of problems...
Okay, so I've got a site on my localhost. I'm setting it up to use CFCs and I've got my CFC all created, and it's working locally perfectly. The path is C:\Inetpub\wwwroot\MySite I have the CFC in the root of my site, and it's called, let's say, myCFC.cfc. So in my page, I have the code that instantiates the object: cfset variables.myObject= createObject(component, MySite.myCFC) and it works perfectly, like I said. I also have an admin section and it's path is C:\Inetpub\wwwroot\MySite\backend\ and my instantiation code works fine in there: cfset variables.myObject= createObject(component, MySite.myCFC) However, now that I move it over to the live site to test it, it's not working. I fixed it, by changing my instantiation code (in all my root cfm files) to: cfset variables.myObject= createObject(component, myCFC) which now works...*except* for in the admin directory one directory lower. I haven't been able to get it to work any other way than just placing the CFC in that directory too. I know, I know...this is *stupid* and I'm not going to leave it for sure, but I'm trying to figure out how I make it work on the remote, live site just like it's working here, without having to change code whenever I move it. What do I need to do to get it to work right? ~| 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:198693 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: SQL Join Challenge
I'm confused about what exactly you want From your original email I get that you want 1. All the rows from lessons 2. Any rows from students table that matches lessons on the lessonid 3. A where clause to narrow down the students who are listed. However in your comment to John you said that you need all the students who have a s.lessonid=l.lessonid match listed. I'm not sure why you would need the AND statement. According to your reply to John it sounds like you really don't need a where clause because all the students with a matching lessonid will already be listed. ~| 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:198694 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
CFMAIL Group example
Does anyone know of a quick example for using the group attribute of the CFMAIL tag? Nothing fancy, just something that illustrates its use. Thanks, Howie ~| 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:198695 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Join Challenge
I expected that to work as well (in fact, I thought that I had used this approach successfully in the past). I tried it again this time, however, and it didn't work. Some rows from lessons were missing. Would it matter that while lessons has a primary key of LessonID, students has a joint primary key of LessonID and UserID? Or perhaps this is an oddity of SQL Server 2000? Thanks, Steve SELECT * FROM lessons LEFT JOIN students ON lessons.lessonID = students.lessonID WHERE students.studentID = #studentID# OR students.studentID IS NULL Jochem ~| 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:198696 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: Dealing with bounced email
There are actually less than a dozen formats that account for over 90% of the bounced mail you'll get. I've been planning an app to do exactly what your requesting but never got around to it. I'd ask Howie Hamlin about it as he's probably written or heard something that does this for iMS. If not, get a weeks worth of mail and look through it. You'll start seeing patterns that can be written into a fast RegEx library using the return header as a key to which regex to use. I am working with an iMail mailing list for a relatively large organization and need to work on a way to deal with bounced mailing list messages. When the messages come back, they are delivered to the mailing list owner's mailbox. What I'd like to do is download the mail messages with CFPOP, figure out the email address that bounced and then mark it off in my database as a bouncing address (The mailing list is automatically synced up with a membership database). The problem I am having is that I am seeing alot of different formats for bounced mail messages. I could just strip out any and all email addresses and mark the ones that it finds in the database, but the trouble is that often one of the addresses is the sender's email address and I haven't figured out a reliable way to exclude that address. Can anyone make any suggestions on how this could be done reliably? Thanks! __ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs ~| 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:198697 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: CFCs and paths...I'm having a couple of problems...
paths to cfcs have to be absolute wite createObject() A pita for site portability, eh? There are ways around this. You could create a CF mapping called com to C:\Inetpub\wwwroot\com\. Then place your CFCs in there in teh 'Java way' C:\Inetpub\wwwroot\com\domainname\app1\mycfc.cfc Then all your CFC calls would be the same anywhere as com.domainname.app1.mycfc I sometimes set an application scoped var application.rootdir and use something like cfset toolsobj = CreateObject(Component,#Replace(application.config.getAppRoot(),/,.)#.pathtocfcs.inmy.app) / Doug On Mon, 14 Mar 2005 15:36:03 -0500, Jeff Small [EMAIL PROTECTED] wrote: Okay, so I've got a site on my localhost. I'm setting it up to use CFCs and I've got my CFC all created, and it's working locally perfectly. The path is C:\Inetpub\wwwroot\MySite I have the CFC in the root of my site, and it's called, let's say, myCFC.cfc. So in my page, I have the code that instantiates the object: cfset variables.myObject= createObject(component, MySite.myCFC) and it works perfectly, like I said. I also have an admin section and it's path is C:\Inetpub\wwwroot\MySite\backend\ and my instantiation code works fine in there: cfset variables.myObject= createObject(component, MySite.myCFC) However, now that I move it over to the live site to test it, it's not working. I fixed it, by changing my instantiation code (in all my root cfm files) to: cfset variables.myObject= createObject(component, myCFC) which now works...*except* for in the admin directory one directory lower. I haven't been able to get it to work any other way than just placing the CFC in that directory too. I know, I know...this is *stupid* and I'm not going to leave it for sure, but I'm trying to figure out how I make it work on the remote, live site just like it's working here, without having to change code whenever I move it. What do I need to do to get it to work right? ~| 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:198698 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: SQL Join Challenge
Yeah, I'm confused too. A better explanation would help if Jochem's (and others') posts didn't solve it already. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 2:39 PM To: CF-Talk Subject: Re: SQL Join Challenge I'm confused about what exactly you want From your original email I get that you want 1. All the rows from lessons 2. Any rows from students table that matches lessons on the lessonid 3. A where clause to narrow down the students who are listed. However in your comment to John you said that you need all the students who have a s.lessonid=l.lessonid match listed. I'm not sure why you would need the AND statement. According to your reply to John it sounds like you really don't need a where clause because all the students with a matching lessonid will already be listed. ~| 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:198699 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
CFTREEITEM problem
Hello, I'm trying to use the CFTREE to populate another frame with data based on the id of the node selected. Here is my code: cftreeitem value=datefmt,RequestID display=datefmt,timefmt img=folder,document imgopen=folder,document href=,dsp_requestForm.cfm target=main query=inquiries queryasroot=No expand=Yes The tree is basically the date, with inquiries below that with the time as the label. The problem I'm having is I cannot get the child nodes (the actual inquiries) to link to the form. The folders which shouldn't have an ID anyway are linked, but not the children. I know it's probably something simple, can someone tell me what am I doing wrong? John Venable This e-mail, including attachments, is intended for the exclusive use of the person or entity to which it is addressed and may contain confidential or privileged information. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you think that you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Epilepsy Foundation ~| 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:198700 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: CFCs and paths...I'm having a couple of problems...
paths to cfcs have to be absolute wite createObject() A pita for site portability, eh? There are ways around this. You could create a CF mapping called com to C:\Inetpub\wwwroot\com\. Then place your CFCs in there in teh 'Java way' C:\Inetpub\wwwroot\com\domainname\app1\mycfc.cfc Then all your CFC calls would be the same anywhere as com.domainname.app1.mycfc I sometimes set an application scoped var application.rootdir and use something like cfset toolsobj = CreateObject(Component,#Replace(application.config.getAppRoot(),/,.)#.pathtocfcs.inmy.app) / Doug Okay...well...that kinda reeks. I'm still a little confused, but I obviously have more to read, so rather than complain here, I'll quietly go read what I need to get it to work. Jeff, confused ~| 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:198701 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
activepdf and cf
For those of you who use activepdf, a quick question. According to the docs you can put an image into the setformfield tag I tried their code, but no luck. Not only does the image not show up, but if I open the final pdf and click to view the fields- the field doesn't even transfer to it Anyone do this at all? CFSET Lhead=Tlkt.SetFormFieldData(Lrhead,Letterhead2.jpg ,-995) Thanks, 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:198702 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: CFCs and paths...I'm having a couple of problems...
Just create the mapping on both your local and live sites. Use hardcoded fully qualified paths if you can... try to avoid dynamic path names when refering to the names of CFCs. It makes things easier to understand when you look at it later, and if you have to change the names at some point the search and replace should be pretty simple. On Mon, 14 Mar 2005 16:00:44 -0500, Jeff Small [EMAIL PROTECTED] wrote: paths to cfcs have to be absolute wite createObject() A pita for site portability, eh? There are ways around this. You could create a CF mapping called com to C:\Inetpub\wwwroot\com\. Then place your CFCs in there in teh 'Java way' C:\Inetpub\wwwroot\com\domainname\app1\mycfc.cfc Then all your CFC calls would be the same anywhere as com.domainname.app1.mycfc I sometimes set an application scoped var application.rootdir and use something like cfset toolsobj = CreateObject(Component,#Replace(application.config.getAppRoot(),/,.)#.pathtocfcs.inmy.app) / Doug Okay...well...that kinda reeks. I'm still a little confused, but I obviously have more to read, so rather than complain here, I'll quietly go read what I need to get it to work. Jeff, confused ~| 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:198703 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: Dealing with bounced email
Thanks Michael! I'll do that. EC -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 3:47 PM To: CF-Talk Subject: RE: Dealing with bounced email There are actually less than a dozen formats that account for over 90% of the bounced mail you'll get. I've been planning an app to do exactly what your requesting but never got around to it. I'd ask Howie Hamlin about it as he's probably written or heard something that does this for iMS. If not, get a weeks worth of mail and look through it. You'll start seeing patterns that can be written into a fast RegEx library using the return header as a key to which regex to use. I am working with an iMail mailing list for a relatively large organization and need to work on a way to deal with bounced mailing list messages. When the messages come back, they are delivered to the mailing list owner's mailbox. What I'd like to do is download the mail messages with CFPOP, figure out the email address that bounced and then mark it off in my database as a bouncing address (The mailing list is automatically synced up with a membership database). The problem I am having is that I am seeing alot of different formats for bounced mail messages. I could just strip out any and all email addresses and mark the ones that it finds in the database, but the trouble is that often one of the addresses is the sender's email address and I haven't figured out a reliable way to exclude that address. Can anyone make any suggestions on how this could be done reliably? Thanks! __ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198704 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
cfchart and cfchartdata question. Kindly help!
Try this: select count(*), jobPriority from call where logdatetime = @x + '00:00:00' and logdatetime = @x + '23:59:59' group by jobPriority -Cliff Subject: cfchart and cfchartdata question. Kindly help! From: cf coder [EMAIL PROTECTED] Date: Mon, 14 Mar 2005 09:26:39 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=38961forumid=4#198644 thanks Cliff for the reply. That did occur to me and its probably the only way to do it. However, I don't know how to build the select sql query. From what I understand when using the count() function, I can't any other column name in the select. select count(*), jobPriority from call where logdatetime = @x + '00:00:00' and logdatetime = @x + '23:59:59' How do I get the query to return the count of jobs logged in a day and for each job return the jobPriority. Is there a way to do this? Regards, cfcoder ~| 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:198706 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: CFCs and paths...I'm having a couple of problems...
Just create the mapping on both your local and live sites. Use hardcoded fully qualified paths if you can... try to avoid dynamic path names when refering to the names of CFCs. It makes things easier to understand when you look at it later, and if you have to change the names at some point the search and replace should be pretty simple. Yeah, I've got nothing dynamic. So you're saying I should ask my ISP for a mapping? Think they'll do that? Is that a normal thing for ISPs to offer? This is just a little local telco, and it's a little pro bono site, so I'm wondering if asking for a mapping on their end would be a pain, because honestly, at this point, I don't care if it's a pain, I just want it to work. ~| 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:198705 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: CFCs and paths...I'm having a couple of problems...
Define in application.cfm file. You only have to look and change in a single location. If at some point the location changes you don't need to search and replace you know exactly where to look. Also what's up with little local telco's? I think they rule! -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 4:19 PM To: CF-Talk Subject: Re: CFCs and paths...I'm having a couple of problems... Just create the mapping on both your local and live sites. Use hardcoded fully qualified paths if you can... try to avoid dynamic path names when refering to the names of CFCs. It makes things easier to understand when you look at it later, and if you have to change the names at some point the search and replace should be pretty simple. Yeah, I've got nothing dynamic. So you're saying I should ask my ISP for a mapping? Think they'll do that? Is that a normal thing for ISPs to offer? This is just a little local telco, and it's a little pro bono site, so I'm wondering if asking for a mapping on their end would be a pain, because honestly, at this point, I don't care if it's a pain, I just want it to work. ~| 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:198707 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: CFCs and paths...I'm having a couple of problems...
A single mapping should be a one time thing, so it *shouldn't* be a big deal for them. On Mon, 14 Mar 2005 16:19:28 -0500, Jeff Small [EMAIL PROTECTED] wrote: Just create the mapping on both your local and live sites. Use hardcoded fully qualified paths if you can... try to avoid dynamic path names when refering to the names of CFCs. It makes things easier to understand when you look at it later, and if you have to change the names at some point the search and replace should be pretty simple. Yeah, I've got nothing dynamic. So you're saying I should ask my ISP for a mapping? Think they'll do that? Is that a normal thing for ISPs to offer? This is just a little local telco, and it's a little pro bono site, so I'm wondering if asking for a mapping on their end would be a pain, because honestly, at this point, I don't care if it's a pain, I just want it to work. ~| 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:198708 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: CFCs and paths...I'm having a couple of problems...
I don't think they should have a problem with it. It's a simple thing for them to do and if they're offering CF hosting, that's a simple support issue that doesn't open any vulnerabilities on their server so it shouldn't be a problem. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 4:19 PM To: CF-Talk Subject: Re: CFCs and paths...I'm having a couple of problems... Just create the mapping on both your local and live sites. Use hardcoded fully qualified paths if you can... try to avoid dynamic path names when refering to the names of CFCs. It makes things easier to understand when you look at it later, and if you have to change the names at some point the search and replace should be pretty simple. Yeah, I've got nothing dynamic. So you're saying I should ask my ISP for a mapping? Think they'll do that? Is that a normal thing for ISPs to offer? This is just a little local telco, and it's a little pro bono site, so I'm wondering if asking for a mapping on their end would be a pain, because honestly, at this point, I don't care if it's a pain, I just want it to work. ~| 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:198709 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: CFCs and paths...I'm having a couple of problems...
OT And HTC is the largest telephone cooperative in the US. Not just some little local telco. :-) /OT - Matt Small -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 4:25 PM To: CF-Talk Subject: RE: CFCs and paths...I'm having a couple of problems... Define in application.cfm file. You only have to look and change in a single location. If at some point the location changes you don't need to search and replace you know exactly where to look. Also what's up with little local telco's? I think they rule! -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 4:19 PM To: CF-Talk Subject: Re: CFCs and paths...I'm having a couple of problems... Just create the mapping on both your local and live sites. Use hardcoded fully qualified paths if you can... try to avoid dynamic path names when refering to the names of CFCs. It makes things easier to understand when you look at it later, and if you have to change the names at some point the search and replace should be pretty simple. Yeah, I've got nothing dynamic. So you're saying I should ask my ISP for a mapping? Think they'll do that? Is that a normal thing for ISPs to offer? This is just a little local telco, and it's a little pro bono site, so I'm wondering if asking for a mapping on their end would be a pain, because honestly, at this point, I don't care if it's a pain, I just want it to work. ~| 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:198710 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: CFCs and paths...I'm having a couple of problems...
The issue with dynamic paths is that you can't do any type-checking at all in the cffunction, cfargument, and cfproperty tags. For me, this is too important since it saves a lot of time debugging. It also makes the structure of component files clearer since I am always having to use it. It may seem like more work, but it pays you back later. On Mon, 14 Mar 2005 16:24:54 -0500, Bosky, Dave [EMAIL PROTECTED] wrote: Define in application.cfm file. You only have to look and change in a single location. If at some point the location changes you don't need to search and replace you know exactly where to look. Also what's up with little local telco's? I think they rule! -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 4:19 PM To: CF-Talk Subject: Re: CFCs and paths...I'm having a couple of problems... Just create the mapping on both your local and live sites. Use hardcoded fully qualified paths if you can... try to avoid dynamic path names when refering to the names of CFCs. It makes things easier to understand when you look at it later, and if you have to change the names at some point the search and replace should be pretty simple. Yeah, I've got nothing dynamic. So you're saying I should ask my ISP for a mapping? Think they'll do that? Is that a normal thing for ISPs to offer? This is just a little local telco, and it's a little pro bono site, so I'm wondering if asking for a mapping on their end would be a pain, because honestly, at this point, I don't care if it's a pain, I just want it to work. ~| 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:198712 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: LDAP
+1 on the softerra ldap browser tool. -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 1:08 PM To: CF-Talk Subject: Re: LDAP we use LDAP for authentication on our intranet apps. We use a sun ONE IIRC. Its fairly easy to use cfldap tag for this. Googling should get you an example or three. I suggest getting the ldap browser tool from softerra, its free, and it simply rocks. D ~| 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:198712 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: Dealing with bounced email
The way I do it is to use my CFX_POP3 Pro tag rather than the built in CFPOP tag because it's got bayesian filtering capabilities built in so I train them to recognise bounces as opposed to spam and score them appropriately. When I process the mailbox for bounces, I don't have to do half as much work in terms of determining whether or not the mail is a bounce message and processing the e-mail addresses then becomes far easier as to concur with Michael, the formats for bounce messages are pretty limited. Paul ~| 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:198713 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
E-commerce - Make them register or don't make them register
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:198715 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: SQL Join Challenge
I think maybe you want this... Select * From lessons Left join lessons on (lessons.lessonID = students.lessonID AND students.studentID = #studentID#) Putting the AND in the join clause (and not in the WHERE clause) will give different results. Mark -Original Message- From: Steve Bryant [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 2:16 PM To: CF-Talk Subject: Re: SQL Join Challenge Nope. That returns only rows from lessons where either no matching row exists in the students table at all or where a matching row exists for that student. In other words, it eliminates any lessons for which there is a match in the students table, but not for the given student. Steve Would this work or am I missing a piece of the puzzle? Select * From lessons Left join lessons on lessons.lessonID = students.lessonID Where students.studentID = #studentID# John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| 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:198715 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
Make the registration after everything else and optional. Since you already have the info, it's only an extra few keystrokes. - Matt Small -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 3:45 PM To: CF-Talk Subject: E-commerce - Make them register or don't make them register 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:198716 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
Ask for the info, just don't tell them they are registering! -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 1:45 PM To: CF-Talk Subject: E-commerce - Make them register or don't make them register 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 ~| 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:198717 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: CFCs and paths...I'm having a couple of problems...
OT And HTC is the largest telephone cooperative in the US. Not just some little local telco. :-) /OT - Matt Small Well, you-know-who is lurking, so I figured I'd take a couple digs...make sure he's paying attention...heh. - Jeff Small (not related to Matt...seriously) ~| 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:198718 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
Teens (and alot of online shoppers) do not like you to store anything about them (even though common sense dictates they'll have to always repeat the reg info for every purchaseand you could store it without their knowledge anyway). So if you think you'll cheese off your main market...I'd vote to give them the option (as most sites big sites do). IMHO Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| 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:198719 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: LDAP
It *shouldn't* matter what brand you use, but since they may have their own implementations, it's helpful to know. Directories are organized into containers named Organizational Units which are basically sub-directories similar to a file system. The admins can create an OU just for you, give you access and then you can create whatever objects they allow you to create in that OU. I have an OU just for my intranet site's security groups. I do use other domain-related groups for intranet permissions, but if there is a group that doesn't related to a network share or existing domain group, I create my own, specialized intranet security group. Yes, you can create a group and add your web site admins. Then, on each admin page, check to see if the current user is a member of that group. In fact, I store all groups, of which the user is a member, in the session scope. Then, I have a simple function that checks to see if the user is related to that group. This prevents me from needing an LDAP call on each page that is secured. Another nice feature of LDAP is you can add your own attributes to directory objects. You can actually treat the LDAP server as a database of sorts. For example, you can store the last time someone accessed your web site in their LDAP user object attributes. Basically, if it has to do with a user account or group, you can store it right in the LDAP directory and not have to create a database object to store the same information. Feel free to ask any LDAP questions you may have. I wouldn't call myself an expert, but I have a few years of CF - Active Directory experience. M!ke -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:30 PM To: CF-Talk Subject: Re: LDAP What brand of LDAP server are you planning on using? If it's Windows Active Directory, there are some things to know about. I don't know which LDAP server it is because I didn't realize I needed to know, hmmm. Time to ask. But it's the University of Maryland so I guess it's something that scales well. If you have an LDAP server, use it rather than creating a DB to hold security information. You can add people to group, add attributes, etc. LDAP is mainly geared for user-type storage so there is little reason to rebuild if LDAP will support your requirements. I don't know much about LDAPs. Are you saying that I can introduce my own group type and add existing people too it? I only want these two people into the Admin parts of my app, so could I make a group called myApp_admin and add them to it without affecting their current setup? ~| 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:198720 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: SQL Join Challenge
That's it! I didn't even realize that you could use an AND in a join clause like that (embarrased that I didn't even think to try it). Sorry to everyone if my explanation of the desired result was confusing. Thanks to all for the help! Steve Select * From lessons Left join lessons on (lessons.lessonID = students.lessonID AND students.studentID = #studentID#) Putting the AND in the join clause (and not in the WHERE clause) will give different results. 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:198721 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
sot: intranets.com -anyone use them?
Does anyone use/integrate with intranets.com? Looks like a great hosted service, but their apparent lack of APIs means I can't do too much customization (post items from my site, to their task list, etc). Just curious... Any other hosted intranet solutions you'd recommend for low end crm, task mgt, shared calendar, and multi-tiered access? Thanks -Dov NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| 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:198722 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
So does CF 7 Suck, Or Crystaltech?
I've been following the Crystaltech session issue with moderate interest. I say moderate because its not really my problem yet, as I and my clients are running either CF 6.1 or CF 5. But talking to another client today, looks like I'll be setting up a server for him sooner rather than later, so the issue is coming into sharper focus for me. Especially since his dedicated servers are housed by the above-mentioned host. Crystaltech says the problem -- a disastrous one from the sound of it -- is all about Macromedia screwing up CF 7 somehow. Others are saying its not MM, or more accurately others are saying that CF 7 has been working for them just dandy for ages. As far as I can tell MM has kept a fairly low profile on this. Possibly to avoid giving a partner a black eye if it speaks up? I've never seen the problem but if something new has been injected into CF, what is the solution to keeping it stable? As in don't ever do X. Or has the bugfinding and fixing not gotten far enough yet to know? -- --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:198723 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: SQL Join Challenge
You can also use inequality operators in a join as well. I found a very good use for this when I was creating an IP Telephony billing app for our campus. Table1 INNER JOIN Table2 ON (Table1.pk = Table2.fk AND Table1.date = Table2.billingDate) (This is kind of a nonsense query, but you get the gist...) M!ke -Original Message- From: Steve Bryant [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 3:07 PM To: CF-Talk Subject: Re: SQL Join Challenge That's it! I didn't even realize that you could use an AND in a join clause like that (embarrased that I didn't even think to try it). Sorry to everyone if my explanation of the desired result was confusing. Thanks to all for the help! Steve ~| 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:198724 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
You could take a paypal approach and ask after the checkout is complete do you want to save this information so you won't have to enter it again? I know it isn't foolproof but I tend to gravitate to the way amazon.com does ecommerce. They've spent millions doing research on it - it can't be all bad... -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 1:45 PM To: CF-Talk Subject: E-commerce - Make them register or don't make them register 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 ~| 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:198725 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: URL masking and application.cfc
Are you sure Application.cfc will fire for that? Because Application.cfm doesn't. cheers, barneyb On Mon, 14 Mar 2005 12:17:27 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I've been thinking of a new method of presenting dynamic content, specifically the list archives. At the moment you get to a single post by passing an ID on the url. Even if this is 'hidden' using SES Urls or the like, your still passing something. My idea is to use the application.cfc to 'catch' a specific type of 404 error and in place of an error, run a page. Take for example this url: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:38946 In its place I want to use this url: http://www.houseoffusion.com/cf_lists/messages_4_38946.cfm When the onRequestStart or onRequest action is run, I'd like to change the page requested from messages_4_38946.cfm to messages.cfm and turn the rest of the url into the proper variables. Looks totally do-able and I'll be playing with it tonight. The reason I'm mentioning it is to see if anyone else has done this already, anyone finds this interesting and wants to try it and anyone wants to comment on it. I think it's a nice usage of application.cfc, but if others find it to be flawed, I'd like to hear it early on. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| 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:198726 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
On Mon, 14 Mar 2005 14:53:28 -0700, Paul [EMAIL PROTECTED] wrote: You could take a paypal approach and ask after the checkout is complete do you want to save this information so you won't have to enter it again? I do something similar to that. The checkout form is a simple 1-screener with a checkbox at the bottom of the form. It says Remember Me so this form will be filled out next time (except for credit card info). short and sweet and all they have to do is check the box. I use cookies to store their form data if they check this box, and populate the form with the data if it exists on form entry. Of course you could do the same job with a db checking for a match with their cookie.cfid and cookie.cftoken. -- --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:198727 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