RE: Making sure pages reload...
You can't make sure of that, it is 100% up to the browser (and any proxies inbetween). You can, though, set meta tags and and html headers (cfheader) to tell the browser that the document should not be cached. /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Dan Farmer [mailto:[EMAIL PROTECTED] | Sent: Tuesday, December 02, 2003 07:19 | To: CF-Talk | Subject: Making sure pages reload... | | Having some problems with session variables... I want to make | sure that the page reloads every time the user hits it. ( | because in order for my app to work I have some code that | kills the session variable ). How can I make sure that the | page gets reloaded every time ( even when the user presses | the back button ? ) | | | | _ __ | Daniel Farmer | Web Developer Consultant | P: 613.284.1684 | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: load testing tools/services?
Hi Kelly, I have used www.opensta.org in the past. It's open source, fast, easy to use and very stable. Make sure you read the getting started guide though. Adam. -Original Message- From: Kelly Tetterton [mailto:[EMAIL PROTECTED] Sent: 01 December 2003 21:47 To: CF-Talk Subject: OT: load testing tools/services? What do people use for load testing? Ideally, we'd like to find a service that we could point to a pre-production version of a website, create several scripted scenarios, and test under various conditions. All for a low, low price, of course. Any recommendations? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL to Access
Your best bet (I think) would be to use the SQL server Data Transformation Service. This will allow you to export tables/views etc to access quite easily. Just go into SQL Ent Manager and export the required tables to Access, and if you need to regularly dump the data out, you can save the export process as a package, then set up a scheduled job to run the package. HTH Alex -Original Message- From: Danielle Romain [mailto:[EMAIL PROTECTED] Sent: 02 December 2003 02:42 To: CF-Talk Subject: SQL to Access The project that I am working on requires dumping data from SQL Server into a table in Microsoft Access.I am currently using a stored proc to fetch the needed information from SQL then looping through each row in the returned query in order to populate the Access data table. I'm concerned that this solution will be too slow for use in production. Any ideas??? You're help would be appreciated. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [Stats] CF-Talk: November 2003
On Monday 01 Dec 2003 23:16 pm, Bill Doerrfeld wrote: Top 20 Contributors by Number of Posts Eek - where have I gone :-) Guess it shows I'm doing a lot of Delphi and PL/SQL these days... -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Webservices and ENUM types
Dave, thanks for your answer to my last web services query. It would appear that potentially the issue I'm having is with enumerated types. This is the definition in the wsdl : s:simpleType name=TriValue s:restriction base=s:string s:enumeration value=True / s:enumeration value=False / s:enumeration value=Either / /s:restriction /s:simpleType and this is the parameter in the method I'm trying to access : s:element minOccurs=1 maxOccurs=1 name=hasRatings type=s0:TriValue / In my cfinvoke I have this argument : cfinvokeargument name=hasRatings value=Either/ I was pointed at this thread from the UK Dev list from back in August: http://www.mail-archive.com/[EMAIL PROTECTED]/msg08530.html Douglas tells me that he, from an idea given to him by Sean Corfield, had to download the wdsl, edit it and then access the web service through this instead.Unfortunately, this isn't an option for me. We've had a few months go past since then and the web services header hotfix (http://www.macromedia.com/support/coldfusion/ts/documents/webservices_header.htm) at the beginning of November, so I was wondering if any one has a solution to this or any ideas that I can try?? TIA Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL to Access
Danielle, As previously stated, DTS should work for you. I actually just did this yesterday so if you need assistance, feel free to contact me off list and I would be glad to help. I did not run into any issues and we are no longer taxing our CF server with fetching the records from the SQL box and looping over to pump them into 3 different access DBs. Mike -Original Message- From: Danielle Romain [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 9:42 PM To: CF-Talk Subject: SQL to Access The project that I am working on requires dumping data from SQL Server into a table in Microsoft Access.I am currently using a stored proc to fetch the needed information from SQL then looping through each row in the returned query in order to populate the Access data table.I'm concerned that this solution will be too slow for use in production. Any ideas??? You're help would be appreciated. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: Query of a query - sort order not correct?
Hi, I'm doing a query on a query but it won't sort properly. With the upper it gives an error saying lower(IsDirectory) is not a column that can be sorted on. Why? If I remove the upper to just ORDER BY IsDirectory DESC, Name the code will run but the sorting order is not correct. CFQUERY NAME=DirListing DBTYPE=query SELECT IsDirectory,Name FROM RootFiles ORDER BY upper(IsDirectory) DESC, Name /CFQUERY [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query of a query - sort order not correct?
Try this... CFQUERY NAME=DirListing DBTYPE=query SELECT UPPER(IsDirectory) AS dirName, Name FROM RootFiles ORDER BY dirName DESC, Name /CFQUERY -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 7:38 AM To: CF-Talk Subject: re: Query of a query - sort order not correct? Hi, I'm doing a query on a query but it won't sort properly. With the upper it gives an error saying lower(IsDirectory) is not a column that can be sorted on. Why? If I remove the upper to just ORDER BY IsDirectory DESC, Name the code will run but the sorting order is not correct. CFQUERY NAME=DirListing DBTYPE=query SELECT IsDirectory,Name FROM RootFiles ORDER BY upper(IsDirectory) DESC, Name /CFQUERY _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query of a query - sort order not correct?
If find that whatever your ordering on or grouping by or filtering on always need to be present in the SELECT clause as well when using QoQ (which aint the case when dealing with a database version of SQL -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 02 December 2003 12:47 To: CF-Talk Subject: RE: Query of a query - sort order not correct? Try this... CFQUERY NAME=DirListing DBTYPE=query SELECT UPPER(IsDirectory) AS dirName, Name FROM RootFiles ORDER BY dirName DESC, Name /CFQUERY -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 7:38 AM To: CF-Talk Subject: re: Query of a query - sort order not correct? Hi, I'm doing a query on a query but it won't sort properly. With the upper it gives an error saying lower(IsDirectory) is not a column that can be sorted on. Why? If I remove the upper to just ORDER BY IsDirectory DESC, Name the code will run but the sorting order is not correct. CFQUERY NAME=DirListing DBTYPE=query SELECT IsDirectory,Name FROM RootFiles ORDER BY upper(IsDirectory) DESC, Name /CFQUERY _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
reseting querys values in a loop
Hello, I am running a loop and in it I have eight querys the are conditional and I was wondering if there is a way to reset them to null after each loop.What is happening is that I pick the first record it runs fine then I pick the second record and if one of the querys is not processed because the conditions are not met it keeps those values in play.and I get record one's information in the record two's loop. Ie Record IDRoommate1.First Name -- 1 Jon 2 Jon (Should be blank) 3 Jackie 4 Jackie(Should be blank) Thank you for your time Jim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT-SES and Fusebox on 6.1
Hello All, I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1.Is there anyone that has this working with their ISP or work for an ISP that can do it.I am looking to move my customers to an ISP that can provide this service. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: reseting querys values in a loop
Jim, What does your loop look like? Also, what do the where clauses in your 8 queries look like? Could you post some code? Mike -Original Message- From: Jim Louis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:45 AM To: CF-Talk Subject: reseting querys values in a loop Hello, I am running a loop and in it I have eight querys the are conditional and I was wondering if there is a way to reset them to null after each loop.What is happening is that I pick the first record it runs fine then I pick the second record and if one of the querys is not processed because the conditions are not met it keeps those values in play.and I get record one's information in the record two's loop. Ie Record IDRoommate1.First Name -- 1 Jon 2 Jon (Should be blank) 3 Jackie 4 Jackie(Should be blank) Thank you for your time Jim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT-SES and Fusebox on 6.1
Explain how your ISP can be having trouble running apps?All they are required to do is to provide the environment, with the responsibility of the app being on the programmer.The server set up should be in accordance with existing best practices. I would think, in general terms, that if your provider provides the environment, software, uptime and connectivity, they are doing the job..Of course it is incumbent on them to timely apply security patches and updates as they become available.I doubt one could expect a custom set up on a shared service and still provide some security to the other sites hosted on that particular server. On the other hand, perhaps I misunderstand your needs. == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux Enterprise, CFMX 6.1, ASP and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mickael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 7:43 AM Subject: OT-SES and Fusebox on 6.1 | Hello All, | | I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1.Is there anyone that has this working with their ISP or work for an ISP that can do it.I am looking to move my customers to an ISP that can provide this service. | | Mike | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT-SES and Fusebox on 6.1
Doug, It is quite simple, an ISP in a shared environment has access to the admin and IIS settings, to get SES to work their is a minor tweak that needs to be done if there are troubles getting this to run.The app runs fine on my machine with is an out of the box install, and no special configuration.My machine is not however a large shared server. My ISP had this environment set up properly for CF5 yet they have difficulties getting it to work again on 6.1.I know that you are an ISP but I disagree slightly with the your statement that says one could expect custom setups.This is what attracted me to Crystaltech in the first place, for a shared server priceI got customized service. - Original Message - From: Doug White To: CF-Talk Sent: Tuesday, December 02, 2003 9:10 AM Subject: Re: OT-SES and Fusebox on 6.1 Explain how your ISP can be having trouble running apps?All they are required to do is to provide the environment, with the responsibility of the app being on the programmer.The server set up should be in accordance with existing best practices. I would think, in general terms, that if your provider provides the environment, software, uptime and connectivity, they are doing the job..Of course it is incumbent on them to timely apply security patches and updates as they become available.I doubt one could expect a custom set up on a shared service and still provide some security to the other sites hosted on that particular server. On the other hand, perhaps I misunderstand your needs. == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux Enterprise, CFMX 6.1, ASP and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mickael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 7:43 AM Subject: OT-SES and Fusebox on 6.1 | Hello All, | | I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1.Is there anyone that has this working with their ISP or work for an ISP that can do it.I am looking to move my customers to an ISP that can provide this service. | | Mike | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
About CFChart..
Hi all: I'm trying to make a simple chart just to test cfchart tag. But i had many problems with that. Now when i take out the name in cfchart apear in the browser an symbol as a missing image. When i look at the HTML code i have this: . . . Normal html hearder . . some map with the name Images_100012_JPG_map . . . And this img tag IMG SRC=""> id=Images_100012_JPG name=Images_100012_JPG usemap="" border=0 . . When i search in CFIDE dir for GraphData.cfm file...the file is missing. Help please Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: reseting querys values in a loop
Code cfloop index=recordid From = 46 To = 1811 step =1 cfoutput #recordID#br /cfoutput cfset rmtotal=1 cfset EBRMTOTAL=1 cfquery Name=NameInfo datasource=lifew05 select * From tblNam where Nam_ID=#recordid# /cfquery CFIF NameInfo.Nam_HOTROOMMATEFNAME1 IS NOT '' CFQUERY DATASOURCE=DB NAME=GetRoommate1 SELECT * FROM tblNam WHERE Nam_BadgeName = '#NameInfo.Nam_HOTROOMMATEFNAME1#' and Nam_Lname = '#NameInfo.Nam_HOTROOMMATELNAME1#' and Nam_EmployeeCode = '#NameInfo.Nam_HOTROOMMATETCODE1#' /CFQUERY CFIF GETROOMMATE1.RECORDCOUNT IS 0 CFELSE CFQUERY DATASOURCE=lifew05 NAME=GetRoommate1a SELECT * FROM tblHotel WHERE HotUser_ID = #Getroommate1.Nam_ID# /CFQUERY CFSET RMTOTAL= #RMTOTAL# + #GETROOMMATE1.RECORDCOUNT# /CFIF /CFIF The other seven are similar to theone above. -- Jim Louis Best Meetings, Inc. Phone: 952-858-8875 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Webservices and ENUM types
It would appear that potentially the issue I'm having is with enumerated
types.
OKIt turns out I may have inadvertently lied
~hides face in shame~
It turns out that a complex data type with two dates in it didn't like
being replaced with null and required appropriately formatted dates
(-MM-DDT00:00:00Z) in order for it to work correctly.
A slightly simpler question...
I'm getting an error back from the service now saying that it can't find
the web service operation with parameters
{dateRange={{TO={2003-12-12T00:00:00Z},FROM={2003-11-22T00:00:00Z},}},
hasRatings={Either},
permission={},
postCodeArea={},
rtb={},
productType={},}
I noticed that there is an extra comma at the end there after
productType={}.I'm just wondering, is this an error in CFs display of
the error or is this reason why I'm getting this error, given that there
is only one method and no overloading.
Any help is greatly appreciated.
Regards
Stephen
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: reseting querys values in a loop
Since the condition in your queries is not always the same (ie coming from the index of the loop) it might be safest to create some variables that you can set and clear on each iteration of the loop, then before you use them in your output, check the length... cfparam a bunch of variables to use to capture output start loop run queries setting appropraite values for cfparams defined above check vars if len not 0 output, then reset loop again... Might that work? Mike -Original Message- From: Jim Louis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 9:24 AM To: CF-Talk Subject: RE: reseting querys values in a loop Code cfloop index=recordid From = 46 To = 1811 step =1 cfoutput #recordID#br /cfoutput cfset rmtotal=1 cfset EBRMTOTAL=1 cfquery Name=NameInfo datasource=lifew05 select * From tblNam where Nam_ID=#recordid# /cfquery CFIF NameInfo.Nam_HOTROOMMATEFNAME1 IS NOT '' CFQUERY DATASOURCE=DB NAME=GetRoommate1 SELECT * FROM tblNam WHERE Nam_BadgeName = '#NameInfo.Nam_HOTROOMMATEFNAME1#' and Nam_Lname = '#NameInfo.Nam_HOTROOMMATELNAME1#' and Nam_EmployeeCode = '#NameInfo.Nam_HOTROOMMATETCODE1#' /CFQUERY CFIF GETROOMMATE1.RECORDCOUNT IS 0 CFELSE CFQUERY DATASOURCE=lifew05 NAME=GetRoommate1a SELECT * FROM tblHotel WHERE HotUser_ID = #Getroommate1.Nam_ID# /CFQUERY CFSET RMTOTAL= #RMTOTAL# + #GETROOMMATE1.RECORDCOUNT# /CFIF /CFIF The other seven are similar to theone above. -- Jim Louis Best Meetings, Inc. Phone: 952-858-8875 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Create date problem
I'm trying to convert this date/time info from the filed #datetime#: 20031201 03:38 PM into something CF can display correctly. I'm using CreateDate for 20031201. How do I also get the time 03:38 PM separated? In other words I would like to have the #DateFormat((Datetime), mmm-dd-)# display both the date and time formatted. This is what I have so far, but of course it gives me an error because of the 03:38 PM. CFSET Datetime = (CreateDate(left(datetime, 4), Mid(datetime, 5, 2), Right(datetime, 2))) #DateFormat((Datetime), mmm-dd-)# Thanks. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT-SES and Fusebox on 6.1
This was sent to me by a person on the list that cannot post at this time Hi Mike There is a known issue with CFMX6.1 on J2EE configuration which means you need to manually edit the web.xml. Issue number is 52942: http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_known_problems.html#generalserver I can't post to the list at the moment, so if you want to forward this it might help anyone else who has come across this issue. Cheers Bert - Original Message - From: Mickael To: CF-Talk Sent: Tuesday, December 02, 2003 8:43 AM Subject: OT-SES and Fusebox on 6.1 Hello All, I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1.Is there anyone that has this working with their ISP or work for an ISP that can do it.I am looking to move my customers to an ISP that can provide this service. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Create date problem
TimeFormat(YourDate, hh:mm:ss) in hh:mm:ss u can use more masks. regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 08:32 AM To: CF-Talk Subject: Create date problem I'm trying to convert this date/time info from the filed #datetime#: 20031201 03:38 PM into something CF can display correctly. I'm using CreateDate for 20031201. How do I also get the time 03:38 PM separated? In other words I would like to have the #DateFormat((Datetime), mmm-dd-)# display both the date and time formatted. This is what I have so far, but of course it gives me an error because of the 03:38 PM. CFSET Datetime = (CreateDate(left(datetime, 4), Mid(datetime, 5, 2), Right(datetime, 2))) #DateFormat((Datetime), mmm-dd-)# Thanks. Robert O. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [cftalk] About CFChart..
You need to make a GraphData.cfm file in the cfide directory. Just make it an empty file with that EXACT name Allan - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:15 PM Subject: [cftalk] About CFChart.. Hi all: I'm trying to make a simple chart just to test cfchart tag. But i had many problems with that. Now when i take out the name in cfchart apear in the browser an symbol as a missing image. When i look at the HTML code i have this: . . . Normal html hearder . . some map with the name Images_100012_JPG_map . . . And this img tag IMG SRC=""> id=Images_100012_JPG name=Images_100012_JPG usemap="" border=0 . . When i search in CFIDE dir for GraphData.cfm file...the file is missing. Help please Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [cftalk] About CFChart..
Sorry not empy put a comment in there !-- hello -- - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:15 PM Subject: [cftalk] About CFChart.. Hi all: I'm trying to make a simple chart just to test cfchart tag. But i had many problems with that. Now when i take out the name in cfchart apear in the browser an symbol as a missing image. When i look at the HTML code i have this: . . . Normal html hearder . . some map with the name Images_100012_JPG_map . . . And this img tag IMG SRC=""> id=Images_100012_JPG name=Images_100012_JPG usemap="" border=0 . . When i search in CFIDE dir for GraphData.cfm file...the file is missing. Help please Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Update Verity Collections Execution Time
Performance issues?? In a context that vague any solution on earth could be deemed to have performance issues. But for a free text search over a 10,000 record collection for the average CF app you'd be hard pushed to make Verity break sweat. Your the one who made the assumption that someone's implementation is wrong because Verity wasn't performing well for them. I simply pointing out that the person isn't alone in their findings, which isn't vague at all. In fact, I have never seen an Apache project Lucene solution on a single server that outperformed that of the Verity solution. Truth be known I've never had the chance to compare them in that way. But that's my point -- what a silly response. I can't really help that you don't do your homework and learn about all of the available tools to determine their strengths and weaknesses. I'm sure your clients would appreciate knowing that. But silly me for suggesting that their may be another way to solve a problem then what is directly available in ColdFusion. You've always been a master sophist, Matt. Verity is a solution that has worked hand in hand with CF since the beginning of time. It's hardly non-sensical to suggest that it's more likely the Verity implementation is not optimal than Verity itself is broken. Verity's history with CF has no bering on how well it performs compared to other solutions that can be used with CF. Using that logic all CF applications would be built using Pointbase since it ships with CF as opposed to Oracle or some other enterprise database. Matt Liotta President CEO Montara Software, Inc. http://www.MontaraSoftware.com (888) 408-0900 x901 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT-SES and Fusebox on 6.1
Hello Michael; OK I understand.As for me, I don't have problems with setting tweaks as you call them, provided they do not compromise security or runtimes for other shared clients.In fact, I have even given a very trusted client direct access to CF Administrator to make limited changes (mostly along the lines of mapping, though)but this is the exception to the rule. That said, I am sure you realize that running CF 6.1 in a shared server environment proved to be a larger challenge than Macromedia anticipated, however, they did finally address most of the issues in the latest updater.I even placed a server at their disposal during the Red Sky beta program in order to fix them. There were few issues in running single instances, such as on a development box, but a variety of issues arose in the hosting area.I can understand your experience with the CF 5.0 environment, as that has been just about bullet-proof in our experience.For this reason, we still support that platform as well. Now, I am not defending your provider, but I personally feel most of the issues were resolved in my own set of circumstances, and we currently have 6.1 running successfully on bothWindows 2003 and on Linux. cflearning_mode I am curious as to the tweaks you would require and how they would affect the shared environment. Perhaps there is something in the administration I have missed. /cflearning_mode == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mickael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:20 AM Subject: Re: OT-SES and Fusebox on 6.1 | Doug, | | It is quite simple, an ISP in a shared environment has access to the admin and IIS settings, to get SES to work their is a minor tweak that needs to be done if there are troubles getting this to run.The app runs fine on my machine with is an out of the box install, and no special configuration.My machine is not however a large shared server. | | My ISP had this environment set up properly for CF5 yet they have difficulties getting it to work again on 6.1.I know that you are an ISP but I disagree slightly with the your statement that says one could expect custom setups.This is what attracted me to Crystaltech in the first place, for a shared server priceI got customized service. | | |- Original Message - |From: Doug White |To: CF-Talk |Sent: Tuesday, December 02, 2003 9:10 AM |Subject: Re: OT-SES and Fusebox on 6.1 | | |Explain how your ISP can be having trouble running apps?All they are required |to do is to provide the environment, with the responsibility of the app being on |the programmer.The server set up should be in accordance with existing best |practices. | |I would think, in general terms, that if your provider provides the environment, |software, uptime and connectivity, they are doing the job..Of course it is |incumbent on them to timely apply security patches and updates as they become |available.I doubt one could expect a custom set up on a shared service and |still provide some security to the other sites hosted on that particular server. | |On the other hand, perhaps I misunderstand your needs. | |== |Stop spam on your domain, use our gateway! |http://www.clickdoug.com/mailfilter.cfm |For hosting solutions http://www.clickdoug.com |Featuring Win2003 Enterprise, RedHat Linux Enterprise, CFMX 6.1, ASP and PHP |== |If you are not satisfied with my service, my job isn't done! | |- Original Message - |From: Mickael [EMAIL PROTECTED] |To: CF-Talk [EMAIL PROTECTED] |Sent: Tuesday, December 02, 2003 7:43 AM |Subject: OT-SES and Fusebox on 6.1 | || Hello All, || || I am presently hosting many site with CrystalTech in a shared hosting |environment, and they are having a lot of troubles getting SES with fusebox apps |to work on 6.1.Is there anyone that has this working with their ISP or work |for an ISP that can do it.I am looking to move my customers to an ISP that can |provide this service. || || Mike || || || | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Date Range Query Issues
Hello list ;) I have a db table in which I store Start and End Dates called ONCALL_SHIFTS. These are ranges. For example Start_Month 12 Start_Day 1 Start_Year 2003 Start_Time 8 End_Month 12 End_Day 15 End_Year 2003 End_Time 8 There are also two shift types: Backup and Primary So I have a form where the schedulers can add new shifts. It basically asks them for the start and end info, the doctor's name, and what the shift type is. Now, what I want to check for is that there are no overlaps in the shifts, but only if the shift_types are the same; meaning, it's ok to have 2 doctors scheduled for 12/1/2003-12/15/2003 as long as the shift_types are different (backup and primary). It's also ok if one doctor is scheduled for both shift types (ex. Dr. X is both backup and primary on this date range). I know I need to pull a query that brings back the records that would be overlapped. And if that recordset is empty, proceed with the insert. Otherwise, give the user a message that there is an overlap and take them back to the form. The problems are: 1) I can't figure out what should be in the WHERE clause. 2) Have I screwed myself by chopping up the dates? Here's the idea: cfset formDate = form.Start_Month/form.Start_Day/form.Start_Year cfset formTime = form.Start_Hour cfquery name=qrycheckForDupes datasource=#request.DSN# SELECT Shift_ID Start_Day, Start_Month, Start_Hour, Start_Year FROM ONCALL_SHIFTS WHERE ? /cfquery cfif qrycheckForDupes.recorset NEQ 0 cfquery name=InsertSHIFT datasource=#request.DSN# INSERT INTO ONCALL_SHIFTS (Start_Day, Start_Month, Start_Hour, Start_Year, Start_AMPM, Schedule_Type_ID, End_Day, End_Month, End_Hour, End_Year, End_AMPM, Doctor_ID, Division_ID ) VALUES ( #Form.Start_Day#, #Form.Start_Month#, #Form.Start_Hour#, #Form.Start_Year#, '#Form.Start_AMPM#', #Form.Schedule_Type_ID#, #Form.End_Day#, #Form.End_Month#, #Form.End_Hour#, #Form.End_Year#, '#Form.End_AMPM#', #Form.Doctor_ID#, #URL.DIVISIONID# ) /cfquery cfelse _javascript_... go back.. blah blah /cfif For those of who who have encountered such a problem, what were your experiences?? Any help would be greatly appreciated :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Create date problem
Try this: cfset datetime = 20031201 03:38 PM cfset myDate = CreateDate( left(datetime, 4), Mid(datetime, 5, 2), Mid(datetime, 7, 2) ) cfset myTime = ParseDateTime( right(datetime,8) ) cfoutput #DateFormat( myDate, mm/dd/ )# #TimeFormat( myTime, hh:mm:ss tt )#br /cfoutput Take a look at the docs for ParseDateTime().It's a pretty useful function. http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt250.h tm#1110355 http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt250. htm#1110355 I'm using CFMX 6.1 and am not sure about the availability of this function in previous versions of CF. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 9:32 AM To: CF-Talk Subject: Create date problem I'm trying to convert this date/time info from the filed #datetime#: 20031201 03:38 PM into something CF can display correctly. I'm using CreateDate for 20031201. How do I also get the time 03:38 PM separated? In other words I would like to have the #DateFormat((Datetime), mmm-dd-)# display both the date and time formatted. This is what I have so far, but of course it gives me an error because of the 03:38 PM. CFSET Datetime = (CreateDate(left(datetime, 4), Mid(datetime, 5, 2), Right(datetime, 2))) #DateFormat((Datetime), mmm-dd-)# Thanks. Robert O. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Last Space Revisited.
Thanks to the great help from our host, Michael, I've got a working function
to parse a long string into an array of sub strings of an arbitrary length.
I'm posting my solution here both to wrap up the thread incase anybody else
ever needs to do something like this, as well as for further review on how
this code may still be optimized.
Thank You
--- Code ---
cffunction name=stringParse output=false returntype=array
hint=Process a long string into an array of substrings of an arbitary
length.
cfargument name=string required=true type=string displayname=String
hint=String to be processed into the array.
cfargument name=chrLimit required=true type=numeric
displayname=Character Limit hint=Arbitary length of the substrings.
!--- Initialize Variables. ---
cfset var pointer = 1
cfset var element = 1
cfset var subStringAry = arrayNew(1)
cfscript
while (pointer LTE len(string))
{
// Find the next line feed [chr(10)LF] in the string.
LFpos = Find(chr(10),string,pointer);
// If no line feed found, set LFpos to the end of the string.
if (NOT LFpos)
{
LFpos = len(string);
}
// Set LFsubStr to the mid of the string from pointer to LFpos and
increment pointer.
LFsubStr = mid(string,pointer,LFpos - (pointer - 1));
pointer = LFpos + 1;
if (Len(LFsubStr) LTE chrlimit)
{
// substring is less then character limit then, Set the next
subString element to the LFsubStr and increment element.
subStringAry[element] = LFsubStr;
element = element + 1;
}
else
{
// Process substring over character limit into further
substrings broken at white space characters.
start = 1;
while (start LT len(LFsubStr))
{
// Find last white space character before charlimit.
sLastSpace = REFind('.{' start ',' start +
chrlimit - 2 '}(\s)', LFsubStr, 1, 1);
if (arraylen(sLastSpace.Pos) EQ 2 AND len(LFsubStr)
- start GT chrlimit)
{
// If white space is found create sub string.
subString =
mid(LFsubStr,start,sLastSpace.Pos[2]-start+1);
}
else
{
// else create new substring from rest of original
substring.
substring =
right(LFsubStr,len(LFsubStr)-start+1);
}
if (len(subString) LTE chrlimit)
{
// If new substring is less then or equal chrlimit
place into array.
subStringAry[element] = subString;
element = element + 1;
start = start + len(subString);
}
else
{
//else divide new substring into a chrlimit piece
and place into array.
subStringAry[element] =
left(subString,chrlimit);
element = element + 1;
start = start + chrlimit;
}
}
}
}
/cfscript
cfreturn subStringAry
/cffunction
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Create date problem
Robert, On 12/2/2003 at 09:32, you wrote: RO I'm trying to convert this date/time info from the filed RO #datetime#: 20031201 03:38 PM into something CF can display RO correctly. I'm using CreateDate for 20031201. How do I also get RO the time 03:38 PM separated? In other words I would like to have RO the #DateFormat((Datetime), mmm-dd-)# display both the date RO and time formatted. RO This is what I have so far, but of course it gives me an error RO because of the 03:38 PM. CFSET Datetime = RO (CreateDate(left(datetime, 4), Mid(datetime, 5, 2), RO Right(datetime, 2))) #DateFormat((Datetime), mmm-dd-)# cfscript // raw date/time string strdatatime=20031201 03:38 pm; // assumes 4-digit year, 2-digit month, and 2-digit day strdate=left(strdatatime,8); // assumes a space between date and time strtime=listrest(strdatatime, ); // make a valid date and format it thisdate=dateformat(createdate(left(strdate,4),mid(strdate,5,2),right(strdate,2)),mmm-dd-); // format time, if necessary thistime=timeformat(strtime,h:mm tt); writeoutput(thisdate thistime); /cfscript ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [cftalk] About CFChart..
Where is GraphData.cfm file? I don't have it. GraphData .cfm is a CF built in file? I used CF 5.0 and i never had problems with that. thanks __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 08:47 AM To: CF-Talk Subject: Re: [cftalk] About CFChart.. You need to make a GraphData.cfm file in the cfide directory. Just make it an empty file with that EXACT name Allan - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:15 PM Subject: [cftalk] About CFChart.. Hi all: I'm trying to make a simple chart just to test cfchart tag. But i had many problems with that. Now when i take out the name in cfchart apear in the browser an symbol as a missing image. When i look at the HTML code i have this: . . . Normal html hearder . . some map with the name Images_100012_JPG_map . . . And this img tag IMG SRC=""> id=Images_100012_JPG name=Images_100012_JPG usemap="" border=0 . . When i search in CFIDE dir for GraphData.cfm file...the file is missing. Help please Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [cftalk] About CFChart..
I created it..the same problem!! __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 08:47 AM To: CF-Talk Subject: Re: [cftalk] About CFChart.. You need to make a GraphData.cfm file in the cfide directory. Just make it an empty file with that EXACT name Allan - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:15 PM Subject: [cftalk] About CFChart.. Hi all: I'm trying to make a simple chart just to test cfchart tag. But i had many problems with that. Now when i take out the name in cfchart apear in the browser an symbol as a missing image. When i look at the HTML code i have this: . . . Normal html hearder . . some map with the name Images_100012_JPG_map . . . And this img tag IMG SRC=""> id=Images_100012_JPG name=Images_100012_JPG usemap="" border=0 . . When i search in CFIDE dir for GraphData.cfm file...the file is missing. Help please Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Date Range Query Issues
Candace Cottrell said: Start_Month 12 Start_Day 1 Start_Year 2003 Start_Time 8 End_Month 12 End_Day 15 End_Year 2003 End_Time 8 I know I need to pull a query that brings back the records that would be overlapped. And if that recordset is empty, proceed with the insert. Otherwise, give the user a message that there is an overlap and take them back to the form. The problems are: 1) I can't figure out what should be in the WHERE clause. Does your database support OVERLAPS? 2) Have I screwed myself by chopping up the dates? Screwed is not a nice word, but you did make things difficult for yourself. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT-SES and Fusebox on 6.1
Hi Doug, Here is what I just posted from a another list member There is a known issue with CFMX6.1 on J2EE configuration which means you need to manually edit the web.xml. Issue number is 52942: http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_known_problems.html#generalserver I can't post to the list at the moment, so if you want to forward this it might help anyone else who has come across this issue. - Original Message - From: Doug White To: CF-Talk Sent: Tuesday, December 02, 2003 9:46 AM Subject: Re: OT-SES and Fusebox on 6.1 Hello Michael; OK I understand.As for me, I don't have problems with setting tweaks as you call them, provided they do not compromise security or runtimes for other shared clients.In fact, I have even given a very trusted client direct access to CF Administrator to make limited changes (mostly along the lines of mapping, though)but this is the exception to the rule. That said, I am sure you realize that running CF 6.1 in a shared server environment proved to be a larger challenge than Macromedia anticipated, however, they did finally address most of the issues in the latest updater.I even placed a server at their disposal during the Red Sky beta program in order to fix them. There were few issues in running single instances, such as on a development box, but a variety of issues arose in the hosting area.I can understand your experience with the CF 5.0 environment, as that has been just about bullet-proof in our experience.For this reason, we still support that platform as well. Now, I am not defending your provider, but I personally feel most of the issues were resolved in my own set of circumstances, and we currently have 6.1 running successfully on bothWindows 2003 and on Linux. cflearning_mode I am curious as to the tweaks you would require and how they would affect the shared environment. Perhaps there is something in the administration I have missed. /cflearning_mode == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mickael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:20 AM Subject: Re: OT-SES and Fusebox on 6.1 | Doug, | | It is quite simple, an ISP in a shared environment has access to the admin and IIS settings, to get SES to work their is a minor tweak that needs to be done if there are troubles getting this to run.The app runs fine on my machine with is an out of the box install, and no special configuration.My machine is not however a large shared server. | | My ISP had this environment set up properly for CF5 yet they have difficulties getting it to work again on 6.1.I know that you are an ISP but I disagree slightly with the your statement that says one could expect custom setups.This is what attracted me to Crystaltech in the first place, for a shared server priceI got customized service. | | |- Original Message - |From: Doug White |To: CF-Talk |Sent: Tuesday, December 02, 2003 9:10 AM |Subject: Re: OT-SES and Fusebox on 6.1 | | |Explain how your ISP can be having trouble running apps?All they are required |to do is to provide the environment, with the responsibility of the app being on |the programmer.The server set up should be in accordance with existing best |practices. | |I would think, in general terms, that if your provider provides the environment, |software, uptime and connectivity, they are doing the job..Of course it is |incumbent on them to timely apply security patches and updates as they become |available.I doubt one could expect a custom set up on a shared service and |still provide some security to the other sites hosted on that particular server. | |On the other hand, perhaps I misunderstand your needs. | |== |Stop spam on your domain, use our gateway! |http://www.clickdoug.com/mailfilter.cfm |For hosting solutions http://www.clickdoug.com |Featuring Win2003 Enterprise, RedHat Linux Enterprise, CFMX 6.1, ASP and PHP |== |If you are not satisfied with my service, my job isn't done! | |- Original Message - |From: Mickael [EMAIL PROTECTED] |To: CF-Talk [EMAIL PROTECTED] |Sent: Tuesday, December 02, 2003 7:43 AM |Subject: OT-SES and Fusebox on 6.1 | || Hello All, || || I am presently hosting many site with CrystalTech in a shared hosting |environment, and they are having a lot of troubles getting SES with fusebox apps |to work on 6.1.Is there anyone that has this working with their ISP or work |for an ISP that can do it.I am looking to move my customers to an ISP that can |provide this service. || || Mike || || || | | [Todays Threads] [This Message] [Subscription] [Fast
RE: Create date problem
Ryan, Worked like a charm. Thanks and thanks to the others for the input as well. Robert O. -Original Message- From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 9:51 AM To: CF-Talk Subject: RE: Create date problem Try this: cfset datetime = 20031201 03:38 PM cfset myDate = CreateDate( left(datetime, 4), Mid(datetime, 5, 2), Mid(datetime, 7, 2) ) cfset myTime = ParseDateTime( right(datetime,8) ) cfoutput #DateFormat( myDate, mm/dd/ )# #TimeFormat( myTime, hh:mm:ss tt )#br /cfoutput Take a look at the docs for ParseDateTime().It's a pretty useful function. http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt250.h tm#1110355 http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt250. htm#1110355 I'm using CFMX 6.1 and am not sure about the availability of this function in previous versions of CF. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 9:32 AM To: CF-Talk Subject: Create date problem I'm trying to convert this date/time info from the filed #datetime#: 20031201 03:38 PM into something CF can display correctly. I'm using CreateDate for 20031201. How do I also get the time 03:38 PM separated? In other words I would like to have the #DateFormat((Datetime), mmm-dd-)# display both the date and time formatted. This is what I have so far, but of course it gives me an error because of the 03:38 PM. CFSET Datetime = (CreateDate(left(datetime, 4), Mid(datetime, 5, 2), Right(datetime, 2))) #DateFormat((Datetime), mmm-dd-)# Thanks. Robert O. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [cftalk] About CFChart..
C:\Inetpub\wwwroot\CFIDE\GraphData.cfm Then restart cfmx service then try. Allan - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:51 PM Subject: RE: [cftalk] About CFChart.. I created it..the same problem!! __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 08:47 AM To: CF-Talk Subject: Re: [cftalk] About CFChart.. You need to make a GraphData.cfm file in the cfide directory. Just make it an empty file with that EXACT name Allan - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:15 PM Subject: [cftalk] About CFChart.. Hi all: I'm trying to make a simple chart just to test cfchart tag. But i had many problems with that. Now when i take out the name in cfchart apear in the browser an symbol as a missing image. When i look at the HTML code i have this: . . . Normal html hearder . . some map with the name Images_100012_JPG_map . . . And this img tag IMG SRC=""> id=Images_100012_JPG name=Images_100012_JPG usemap="" border=0 . . When i search in CFIDE dir for GraphData.cfm file...the file is missing. Help please Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Verity collection
Anyone out there have CF code that updates a Verity collection. I would like to run it manually occasionally and have it update all my collections. When I go through the Admin it takes too long and it seems that it I have to delete the collection and then re-instate it in order for it to display the updated pages I added to our web server. Thanks. Roberto HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Date Range Query Issues
Hey Jochem :) 1 - Do you mean natively or the way I have the db set up? If it's the latter, I don't have any constraints for overlaps in the db design. Each shift or date range is its own record. The id is an identity field. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 12/2/2003 9:57:43 AM The problems are: 1) I can't figure out what should be in the WHERE clause. Does your database support OVERLAPS? 2) Have I screwed myself by chopping up the dates? Screwed is not a nice word, but you did make things difficult for yourself. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT-SES and Fusebox on 6.1
Hmmm, I made that modification a long time ago. :-) == Stop spam on your domain, use our gateway! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: Mickael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:57 AM Subject: Re: OT-SES and Fusebox on 6.1 | Hi Doug, | | Here is what I just posted from a another list member | | There is a known issue with CFMX6.1 on J2EE configuration which means you need to manually edit the web.xml. | Issue number is 52942: | http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_known_problems.html#generalserver | I can't post to the list at the moment, so if you want to forward this it might help anyone else who has come across this issue. | |- Original Message - |From: Doug White |To: CF-Talk |Sent: Tuesday, December 02, 2003 9:46 AM |Subject: Re: OT-SES and Fusebox on 6.1 | | |Hello Michael; | |OK I understand.As for me, I don't have problems with setting tweaks as you |call them, provided they do not compromise security or runtimes for other shared |clients.In fact, I have even given a very trusted client direct access to CF |Administrator to make limited changes (mostly along the lines of mapping, |though)but this is the exception to the rule. | |That said, I am sure you realize that running CF 6.1 in a shared server |environment proved to be a larger challenge than Macromedia anticipated, |however, they did finally address most of the issues in the latest updater. I |even placed a server at their disposal during the Red Sky beta program in order |to fix them. There were few issues in running single instances, such as on a |development box, but a variety of issues arose in the hosting area.I can |understand your experience with the CF 5.0 environment, as that has been just |about bullet-proof in our experience.For this reason, we still support that |platform as well. | |Now, I am not defending your provider, but I personally feel most of the issues |were resolved in my own set of circumstances, and we currently have 6.1 running |successfully on bothWindows 2003 and on Linux. | |cflearning_mode |I am curious as to the tweaks you would require and how they would affect the |shared environment. Perhaps there is something in the administration I have |missed. |/cflearning_mode | |== |Stop spam on your domain, use our gateway! |http://www.clickdoug.com/mailfilter.cfm |For hosting solutions http://www.clickdoug.com |Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP |== |If you are not satisfied with my service, my job isn't done! | |- Original Message - |From: Mickael [EMAIL PROTECTED] |To: CF-Talk [EMAIL PROTECTED] |Sent: Tuesday, December 02, 2003 8:20 AM |Subject: Re: OT-SES and Fusebox on 6.1 | || Doug, || || It is quite simple, an ISP in a shared environment has access to the admin and |IIS settings, to get SES to work their is a minor tweak that needs to be done if |there are troubles getting this to run.The app runs fine on my machine with is |an out of the box install, and no special configuration.My machine is not |however a large shared server. || || My ISP had this environment set up properly for CF5 yet they have difficulties |getting it to work again on 6.1.I know that you are an ISP but I disagree |slightly with the your statement that says one could expect custom setups. This |is what attracted me to Crystaltech in the first place, for a shared server |priceI got customized service. || || ||- Original Message - ||From: Doug White ||To: CF-Talk ||Sent: Tuesday, December 02, 2003 9:10 AM ||Subject: Re: OT-SES and Fusebox on 6.1 || || ||Explain how your ISP can be having trouble running apps?All they are |required ||to do is to provide the environment, with the responsibility of the app |being on ||the programmer.The server set up should be in accordance with existing |best ||practices. || ||I would think, in general terms, that if your provider provides the |environment, ||software, uptime and connectivity, they are doing the job..Of course it is ||incumbent on them to timely apply security patches and updates as they |become ||available.I doubt one could expect a custom set up on a shared service and ||still provide some security to the other sites hosted on that particular |server. || ||On the other hand, perhaps I misunderstand your needs. || ||== ||Stop spam on your domain, use our gateway! ||http://www.clickdoug.com/mailfilter.cfm ||For hosting solutions http://www.clickdoug.com ||Featuring Win2003 Enterprise, RedHat Linux Enterprise, CFMX 6.1, ASP and PHP ||== ||If
RE: reseting querys values in a loop
Ok This is what I did cfif Getroommate1.Nam_BadgeName eq NameInfo.Nam_HOTROOMMATEFNAME1 and Getroommate1.Nam_Lname eq NameInfo.Nam_HOTROOMMATELNAME1 and GetRoommate1.Nam_EmployeeCode eq NameInfo.Nam_HOTROOMMATETCODE1 cfset RM1BN = GetRoommate1.Nam_BadgeName cfset RM1LN = GetRoommate1.Nam_LName cfset RM1TC = GetRoommate1.Nam_EmployeeCode cfset RM1AD = GetRoommate1.Nam_HOTArrivalDate cfset RM1DD = GetRoommate1.NAM_HOTDEPARTUREDATE cfset RM1ID = GetRoommate1.Nam_ID cfset RM1HOTDAY1=#GETROOMMATE1a.HOT_DAY1# cfset RM1HOTDAY2=#GETROOMMATE1a.HOT_DAY2# cfset RM1HOTDAY3=#GETROOMMATE1a.HOT_DAY3# cfset RM1HOTDAY4=#GETROOMMATE1a.HOT_DAY4# cfset RM1HOTDAY5=#GETROOMMATE1a.HOT_DAY5# cfset RM1HOTDAY6=#GETROOMMATE1a.HOT_DAY6# cfset RM1HOTDAY7=#GETROOMMATE1a.HOT_DAY7# cfset RM1HOTDAY8=#GETROOMMATE1a.HOT_DAY8# cfset RM1HOTDAY9=#GETROOMMATE1a.HOT_DAY9# cfset RM1HOTDAY10=#GETROOMMATE1a.HOT_DAY10# cfset RM1HOTDAY11=#GETROOMMATE1a.HOT_DAY11# cfset RM1HOTDAY12=#GETROOMMATE1a.HOT_DAY12# cfset RM1HOTDAY13=#GETROOMMATE1a.HOT_DAY13# cfset RM1HOTDAY14=#GETROOMMATE1a.HOT_DAY14# cfset RM1HOTDAY15=#GETROOMMATE1a.HOT_DAY15# cfset RM1HOTDAY16=#GETROOMMATE1a.HOT_DAY16# cfset RM1HOTDAY17=#GETROOMMATE1a.HOT_DAY17# cfset RM1HOTDAY18=#GETROOMMATE1a.HOT_DAY18# cfset RM1HOTDAY19=#GETROOMMATE1a.HOT_DAY19# cfset RM1HOTDAY20=#GETROOMMATE1a.HOT_DAY20# cfelse cfset RM1BN = '' cfset RM1LN = '' cfset RM1TC = '' cfset RM1AD = '' cfset RM1DD = '' cfset RM1ID = '' cfset RM1HOTDAY1='0' cfset RM1HOTDAY2='0' cfset RM1HOTDAY3='0' cfset RM1HOTDAY4='0' cfset RM1HOTDAY5='0' cfset RM1HOTDAY6='0' cfset RM1HOTDAY7='0' cfset RM1HOTDAY8='0' cfset RM1HOTDAY9='0' cfset RM1HOTDAY10='0' cfset RM1HOTDAY11='0' cfset RM1HOTDAY12='0' cfset RM1HOTDAY13='0' cfset RM1HOTDAY14='0' cfset RM1HOTDAY15='0' cfset RM1HOTDAY16='0' cfset RM1HOTDAY17='0' cfset RM1HOTDAY18='0' cfset RM1HOTDAY19='0' cfset RM1HOTDAY20='0' /cfif Will that work or should I change it to the len thing. -- Jim Louis Best Meetings, Inc. Phone: 952-858-8875 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Date Range Query Issues
Candace Cottrell said:
1 - Do you mean natively or the way I have the db set up?
Natively, OVERLAPS is a SQL predicate:
('2003-12-01', '2003-12-31') OVERLAPS ('2003-12-16', '2004-01-15')
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: reseting querys values in a loop
I'm not really sure Jim... Id have to see the code in its entirety. What I was hinting towards was the fact that you can just use some temp variables that get set and reset on each iteration of the loop... Also... in your cfsets, you only need #s when you have . Email me off list, ill be able to help you better. Mike -Original Message- From: Jim Louis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 10:10 AM To: CF-Talk Subject: RE: reseting querys values in a loop Ok This is what I did cfif Getroommate1.Nam_BadgeName eq NameInfo.Nam_HOTROOMMATEFNAME1 and Getroommate1.Nam_Lname eq NameInfo.Nam_HOTROOMMATELNAME1 and GetRoommate1.Nam_EmployeeCode eq NameInfo.Nam_HOTROOMMATETCODE1 cfset RM1BN = GetRoommate1.Nam_BadgeName cfset RM1LN = GetRoommate1.Nam_LName cfset RM1TC = GetRoommate1.Nam_EmployeeCode cfset RM1AD = GetRoommate1.Nam_HOTArrivalDate cfset RM1DD = GetRoommate1.NAM_HOTDEPARTUREDATE cfset RM1ID = GetRoommate1.Nam_ID cfset RM1HOTDAY1=#GETROOMMATE1a.HOT_DAY1# cfset RM1HOTDAY2=#GETROOMMATE1a.HOT_DAY2# cfset RM1HOTDAY3=#GETROOMMATE1a.HOT_DAY3# cfset RM1HOTDAY4=#GETROOMMATE1a.HOT_DAY4# cfset RM1HOTDAY5=#GETROOMMATE1a.HOT_DAY5# cfset RM1HOTDAY6=#GETROOMMATE1a.HOT_DAY6# cfset RM1HOTDAY7=#GETROOMMATE1a.HOT_DAY7# cfset RM1HOTDAY8=#GETROOMMATE1a.HOT_DAY8# cfset RM1HOTDAY9=#GETROOMMATE1a.HOT_DAY9# cfset RM1HOTDAY10=#GETROOMMATE1a.HOT_DAY10# cfset RM1HOTDAY11=#GETROOMMATE1a.HOT_DAY11# cfset RM1HOTDAY12=#GETROOMMATE1a.HOT_DAY12# cfset RM1HOTDAY13=#GETROOMMATE1a.HOT_DAY13# cfset RM1HOTDAY14=#GETROOMMATE1a.HOT_DAY14# cfset RM1HOTDAY15=#GETROOMMATE1a.HOT_DAY15# cfset RM1HOTDAY16=#GETROOMMATE1a.HOT_DAY16# cfset RM1HOTDAY17=#GETROOMMATE1a.HOT_DAY17# cfset RM1HOTDAY18=#GETROOMMATE1a.HOT_DAY18# cfset RM1HOTDAY19=#GETROOMMATE1a.HOT_DAY19# cfset RM1HOTDAY20=#GETROOMMATE1a.HOT_DAY20# cfelse cfset RM1BN = '' cfset RM1LN = '' cfset RM1TC = '' cfset RM1AD = '' cfset RM1DD = '' cfset RM1ID = '' cfset RM1HOTDAY1='0' cfset RM1HOTDAY2='0' cfset RM1HOTDAY3='0' cfset RM1HOTDAY4='0' cfset RM1HOTDAY5='0' cfset RM1HOTDAY6='0' cfset RM1HOTDAY7='0' cfset RM1HOTDAY8='0' cfset RM1HOTDAY9='0' cfset RM1HOTDAY10='0' cfset RM1HOTDAY11='0' cfset RM1HOTDAY12='0' cfset RM1HOTDAY13='0' cfset RM1HOTDAY14='0' cfset RM1HOTDAY15='0' cfset RM1HOTDAY16='0' cfset RM1HOTDAY17='0' cfset RM1HOTDAY18='0' cfset RM1HOTDAY19='0' cfset RM1HOTDAY20='0' /cfif Will that work or should I change it to the len thing. -- Jim Louis Best Meetings, Inc. Phone: 952-858-8875 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: OT-SES and Fusebox on 6.1
Original Message: From: Mickael [EMAIL PROTECTED] I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1.Is there anyone that has this working with their ISP or work for an ISP that can do it.I am looking to move my customers to an ISP that can provide this service. I have 2 sites with CrystalTech that both use SES URLs (and Fusebox 3).Strangely, one of those sites wouldn't work with SES URLs after the upgrade to 6.1, but the other one does.My guess is that at the time, some of their servers had the XML file fix and others didn't.Because I needed to get the site that wasn't working fixed in a hurry and CT didn't seem to know what the issue was at the time, I just stripped out the SES stuff in that site.(about 15-30 minutes worth of work).Not an ideal solution, and I may try going back to SES on that site in the future. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date Range Query Issues
Candace, If I were you, I would store your dates and times in the db as a datetime field.Then it will become much easier to do the where statement. If you just want to find out if there is an overlap then you could use. cfquery name=qGetCount dataSource=yourDS select count(identityField) as overlap from yourTable where shiftType = cfqueryparam cfsqltype=cf_sql_varchar value=#formType# and ((startDate = cfqueryparam cfsqltype=cf_sql_date value=#formStartDate# and startDate = cfqueryparam cfsqltype=cf_sql_date value=#formEndDate#) or (endDate = cfqueryparam cfsqltype=cf_sql_date value=#formStartDate# and endDate = cfqueryparam cfsqltype=cf_sql_date value=#formEndDate#) /cfquery cfif not qGetCount.overlap !--- Database Insert code here --- cfelse !--- Return to or display form here --- /cfif Of course you will have to make sure that your form dates and times conform to your database.You wouldn't want the user to select 5 (meaning 5pm) and have come in as 5 am. Let me know if you need more clarification. Steve -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 10:03 AM To: CF-Talk Subject: Re: Date Range Query Issues Hey Jochem :) 1 - Do you mean natively or the way I have the db set up? If it's the latter, I don't have any constraints for overlaps in the db design. Each shift or date range is its own record. The id is an identity field. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 12/2/2003 9:57:43 AM The problems are: 1) I can't figure out what should be in the WHERE clause. Does your database support OVERLAPS? 2) Have I screwed myself by chopping up the dates? Screwed is not a nice word, but you did make things difficult for yourself. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Date Range Query Issues
Oh wow... I didnt know about that... I'm using MSSQL 2000...
I'll try it out when I get back from my meeting. :)
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
[EMAIL PROTECTED] 12/2/2003 10:12:16 AM
Candace Cottrell said:
1 - Do you mean natively or the way I have the db set up?
Natively, OVERLAPS is a SQL predicate:
('2003-12-01', '2003-12-31') OVERLAPS ('2003-12-16', '2004-01-15')
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: [cftalk] About CFChart..
Allan: D:\WEB_Datais my root dir for web sites...then i have GraphData.cfm in D:\WEB_Data\CFIDE\GraphData.cfm It's correct? Allan:If I put this code in my cf page cfchart format=jpg chartheight=500 chartwidth=650 showxgridlines=no showygridlines=no showborder=yes fontbold=no fontitalic=no show3d=yes rotated=no sortxaxis=no showlegend=no showmarkers=no cfchartseries type=bar query=RsInfo itemcolumn=pub_name valuecolumn=pub_id /cfchart I get as output this.. IMG SRC=""> id=Images_12_JPG name=Images_12_JPG usemap="" border=0 with the map above.. My question how can i control this output ? Because i know SRC="" show anything in the browser..because Images/12.jpg is not created inside images dir where is running my cf page cold u run some example of a single chart and send me the html code output? Thanks __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 09:03 AM To: CF-Talk Subject: Re: [cftalk] About CFChart.. C:\Inetpub\wwwroot\CFIDE\GraphData.cfm Then restart cfmx service then try. Allan - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:51 PM Subject: RE: [cftalk] About CFChart.. I created it..the same problem!! __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 08:47 AM To: CF-Talk Subject: Re: [cftalk] About CFChart.. You need to make a GraphData.cfm file in the cfide directory. Just make it an empty file with that EXACT name Allan - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:15 PM Subject: [cftalk] About CFChart.. Hi all: I'm trying to make a simple chart just to test cfchart tag. But i had many problems with that. Now when i take out the name in cfchart apear in the browser an symbol as a missing image. When i look at the HTML code i have this: . . . Normal html hearder . . some map with the name Images_100012_JPG_map . . . And this img tag IMG SRC=""> id=Images_100012_JPG name=Images_100012_JPG usemap="" border=0 . . When i search in CFIDE dir for GraphData.cfm file...the file is missing. Help please Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfldap and active directory
Hello everybody, I need some help with the cfldap tag. I am quering the Active Directory, I have a user and I want to check if this user is a member of a group. Here is my code cfldap action=""> name=adQuery server=ldapServer start=cn=Media Support,ou=Miscellaneous,ou=task groups,ou=groups,ou=support,ou=media resources uk,dc=international,dc=core,dc=newmedia,dc=co,dc=uk filter=(CN=cfcoder) username=InterNational\news_media password=testpassword attributes=cn scope=subtree port=389 This returns nothing. However I know the user (cfcoder) is part of this group. I changed the start value to this and got back the results. start=ou=media resources uk,dc=international,dc=core,dc=newmedia,dc=co,dc=uk I don't know how to check for this user in my actual start group. Can somebody please advise how to go about solving this? Best Regards cfcoder __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [cftalk] About CFChart..
Did it work? - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:51 PM Subject: RE: [cftalk] About CFChart.. I created it..the same problem!! __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 08:47 AM To: CF-Talk Subject: Re: [cftalk] About CFChart.. You need to make a GraphData.cfm file in the cfide directory. Just make it an empty file with that EXACT name Allan - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, December 02, 2003 4:15 PM Subject: [cftalk] About CFChart.. Hi all: I'm trying to make a simple chart just to test cfchart tag. But i had many problems with that. Now when i take out the name in cfchart apear in the browser an symbol as a missing image. When i look at the HTML code i have this: . . . Normal html hearder . . some map with the name Images_100012_JPG_map . . . And this img tag IMG SRC=""> id=Images_100012_JPG name=Images_100012_JPG usemap="" border=0 . . When i search in CFIDE dir for GraphData.cfm file...the file is missing. Help please Regards, __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Verity on Red Hat 9
As far as we know here at Macromedia, Verity (specifically the file filters, see the Verity log files in the collection) does not work on any Red Hat release higher than 7.2.Behaviors include successful indexing with nothing in the index or strange crashes when doing a search. We do recommend the Lindex pure Java solution that you can get from the Developers Resource Kit (DRK) #3 I believe. Be aware than this Lucene based solution does not support many of the features (particularly file formats) that Verity does, but may do the job for you. -- Tom Jordahl Macromedia Server Development -Original Message- From: Terry Ford [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 7:40 PM To: CF-Talk Subject: Re: Verity on Red Hat 9 Has anyone here got Verity running on RH 9? I'm using the most recent compat libraries, so I'm not entirely sure what the next step is for trying to get Verity to work. Terry - Original Message - From: Thomas Chiverton To: CF-Talk Sent: Monday, December 01, 2003 11:55 AM Subject: Re: Verity on Red Hat 9 On Monday 01 Dec 2003 13:46 pm, Yves Arsenault wrote: I thought there were issues posted on the MM site about Verity and RedHat 7.3 +. To quote the site: Verity does not support RedHat Linux 7.3, 8.0, and 9. Does not support is not the same as Can't be made to run as many people will testify :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Verity collection
cfindex action="" collection=name key=key type=custom title=Titlee query=qryActive body=What do you want to search on custom1=Whatever else you what to return custom2=One more return variable -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:57 AM To: CF-Talk Subject: CF Verity collection Anyone out there have CF code that updates a Verity collection. I would like to run it manually occasionally and have it update all my collections. When I go through the Admin it takes too long and it seems that it I have to delete the collection and then re-instate it in order for it to display the updated pages I added to our web server. Thanks. Roberto HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date Range Query Issues
not going to work in sql server 2000, not from what I can see in the
docs
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 10:22 AM
To: CF-Talk
Subject: Re: Date Range Query Issues
Oh wow... I didnt know about that... I'm using MSSQL 2000...
I'll try it out when I get back from my meeting. :)
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
[EMAIL PROTECTED] 12/2/2003 10:12:16 AM
Candace Cottrell said:
1 - Do you mean natively or the way I have the db set up?
Natively, OVERLAPS is a SQL predicate:
('2003-12-01', '2003-12-31') OVERLAPS ('2003-12-16', '2004-01-15')
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: OT-SES and Fusebox on 6.1
Hi Scott, Would you mind sending me the domain name offlist of the site that is working with SES and 6.1 that may help me get a resolution to the problem, I can have them copy the config.If that is ok Mike - Original Message - From: Scott Brady To: CF-Talk Sent: Tuesday, December 02, 2003 10:19 AM Subject: re: OT-SES and Fusebox on 6.1 Original Message: From: Mickael [EMAIL PROTECTED] I am presently hosting many site with CrystalTech in a shared hosting environment, and they are having a lot of troubles getting SES with fusebox apps to work on 6.1.Is there anyone that has this working with their ISP or work for an ISP that can do it.I am looking to move my customers to an ISP that can provide this service. I have 2 sites with CrystalTech that both use SES URLs (and Fusebox 3).Strangely, one of those sites wouldn't work with SES URLs after the upgrade to 6.1, but the other one does.My guess is that at the time, some of their servers had the XML file fix and others didn't.Because I needed to get the site that wasn't working fixed in a hurry and CT didn't seem to know what the issue was at the time, I just stripped out the SES stuff in that site.(about 15-30 minutes worth of work).Not an ideal solution, and I may try going back to SES on that site in the future. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Outputting to local Excel file
I know how to output data to an excel spreadsheet but how to make it save the excel file to their local machine? C:\... saves it server side as well.. Any help would be appreciated, thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Unsubscribing
Sorry to leave... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Outputting to local Excel file
the same way you would take over their machine and log in and delete all the files on their machine :) no can do...but you can force their browser to download it, well force to the point that they have to click on save/open, but that's about all. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 11:16 AM To: CF-Talk Subject: Outputting to local Excel file I know how to output data to an excel spreadsheet but how to make it save the excel file to their local machine? C:\... saves it server side as well.. Any help would be appreciated, thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Update Verity Collections Execution Time
I didn't say anything about read speed.I agree, verity is quite fast for that.The updates, however, are slow like a dog.I don't think anyone can argue that one.If you've got a collection using verity that doesn't change a whole lot, then verity is great (and free, if the collection is small enough).But if the collection is highly dynamic, then verity quicky gets crushed under it's own weight. So yes, my statements don't always apply, but the initial question was about updates, not reads. Cheers, barneyb -Original Message- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 8:13 PM To: CF-Talk Subject: Re: Update Verity Collections Execution Time Folks, Generally statements like this are non-sensical.There are hundreds of Verity based applications out there performing very nicely thankyou. You can't just write-off an application like Verity on account of having a slow solution -- more than likely it is your solution implementation that is buggered, and not the Verity engine. That's not to say Verity is the be all and end-all but the solution does work and it is read-optimised to be very fast. -- geoff http://www.daemon.com.au/ Andy Ousterhout wrote: Yikes.Guess I'll need to go back to the SQL search I had designed.Wasn't as pretty, but a whole lot faster. Thanks. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 8:09 PM To: CF-Talk Subject: RE: Update Verity Collections Execution Time Yeah.Verity is slow.We had a collection (designed by a developer before my time, I might add) with about 10,000 items in it. Inserting a new row took upwards of 45 seconds on a reasonably beefy machine (dual P-III 666). As you might imagine, that quickly got scrapped in favor of the very speedy FULLTEXT search from MySQL. Cheers, barneyb -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 6:02 PM To: CF-Talk Subject: Update Verity Collections Execution Time Does it sound correct that adding a single record to a verity collection thru action = ''My Goodness Cookies www.omygoodness.com http://www.houseoffusion.com/banners/view.cfm?bannerid=17 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:SQL to Access
Is there a way, though, to have the user push a button on a page which you initiate the DTS transaction?The project's end users want to be able to initiate a data dump at any time, rather than at a regular interval. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date Range Query Issues
No, I just tried it and I couldn't get it to work.
But you can use between
select count(idField)
from yourtable
where type = 'checktype'
and (startDateField between 'startdate' and 'enddate'
OR endDateField between 'startdate and 'enddate')
Of course change all of the 'variables' to either cfqueryparams in cf or
@variables in TSQL.
Steve
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 12:05 PM
To: CF-Talk
Subject: RE: Date Range Query Issues
not going to work in sql server 2000, not from what I can see in the
docs
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 10:22 AM
To: CF-Talk
Subject: Re: Date Range Query Issues
Oh wow... I didnt know about that... I'm using MSSQL 2000...
I'll try it out when I get back from my meeting. :)
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org http://www.childrensdayton.org
[EMAIL PROTECTED]
[EMAIL PROTECTED] 12/2/2003 10:12:16 AM
Candace Cottrell said:
1 - Do you mean natively or the way I have the db set up?
Natively, OVERLAPS is a SQL predicate:
('2003-12-01', '2003-12-31') OVERLAPS ('2003-12-16', '2004-01-15')
Jochem
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Update Verity Collections Execution Time
On Tuesday 02 Dec 2003 02:08 am, Barney Boisvert wrote: took upwards of 45 seconds on a reasonably beefy machine (dual P-III 666). I wouldn't call that 'reasonably beefy' these days. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IsDate( ) behaviour
If I have this string: '1231/04' And I pass it to IsDate( ) It returns True. IsDate(var) = TRUE If I pass it to DateFromat( ) it returns: 01-Apr-31 Can someone explain to me if this is expected behavior or if it's unusual? -Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Outputting to local Excel file
You can use the CFCONTENT tag to push the file to the browser. Depending on the MIME type you set in the tag and the users file mappings they will either get a save as dialog box or the file will openup inside excel. -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:16 AM To: CF-Talk Subject: Outputting to local Excel file I know how to output data to an excel spreadsheet but how to make it save the excel file to their local machine? C:\... saves it server side as well.. Any help would be appreciated, thanks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: IsDate( ) behaviour
Because IsDate is for evaluation and DateFormat is for output formatting. -Kevin - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:04 PM Subject: IsDate( ) behaviour If I have this string: '1231/04' And I pass it to IsDate( ) It returns True. IsDate(var) = TRUE If I pass it to DateFromat( ) it returns: 01-Apr-31 Can someone explain to me if this is expected behavior or if it's unusual? -Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IsDate( ) behaviour
I'm guessing it saw it as the year 1231, month 4, and with no day, it uses day 1. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Outputting to local Excel file
Thanks.. I'll look into CFCONTENT.. I was using CFFILE and hitting nothing but road blocks.. -Original Message- From: Peter Amiri [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:04 PM To: CF-Talk Subject: RE: Outputting to local Excel file You can use the CFCONTENT tag to push the file to the browser. Depending on the MIME type you set in the tag and the users file mappings they will either get a save as dialog box or the file will openup inside excel. -Peter Amiri [EMAIL PROTECTED] MySpace.com -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:16 AM To: CF-Talk Subject: Outputting to local Excel file I know how to output data to an excel spreadsheet but how to make it save the excel file to their local machine? C:\... saves it server side as well.. Any help would be appreciated, thanks. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: IsDate( ) behaviour
Hrm. Just looked closer at the string you're passing to DateFormat and I'm not sure why you're getting that result. Which is probably what you were asking about. -Kevin - Original Message - From: Kevin Graeme [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:02 PM Subject: Re: IsDate( ) behaviour Because IsDate is for evaluation and DateFormat is for output formatting. -Kevin - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:04 PM Subject: IsDate( ) behaviour If I have this string: '1231/04' And I pass it to IsDate( ) It returns True. IsDate(var) = TRUE If I pass it to DateFromat( ) it returns: 01-Apr-31 Can someone explain to me if this is expected behavior or if it's unusual? -Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: IsDate( ) behaviour
Yeah, I have run into problems like that with using the isDate().The 1/1/1, .23334, and 2/3, all return true if you used isDate to test for dates.The way I get around this is in addition to using IsDate(), I use a regular _expression_ to test for the date string format. cfif isDate(dateString) and RegExp here Nick Han [EMAIL PROTECTED] 12/02/03 10:04AM If I have this string: '1231/04' And I pass it to IsDate( ) It returns True. IsDate(var) = TRUE If I pass it to DateFromat( ) it returns: 01-Apr-31 Can someone explain to me if this is expected behavior or if it's unusual? -Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: IsDate( ) behaviour
Nick,
On 12/2/2003 at 13:09, you wrote:
NH Yeah, I have run into problems like that with using the
NH isDate().The 1/1/1, .23334, and 2/3, all
NH return true if you used isDate to test for dates.The way I
NH get around this is in addition to using
NH IsDate(), I use a regular _expression_ to test for the date string format.
NH cfif isDate(dateString) and RegExp here
This has worked well for me:
cfscript
function isvaliddate(string) {
if (refindnocase(^[0-9]{1,2}/[0-9]{1,2}/([0-9]{2}|[0-9]{4})$,arguments[1]) and isdate(arguments[1])){
return true;
} else {
return false;
}
}
/cfscript
~ Ubqtous ~
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
CFDIRECTORY: List Directories
Hey guys, I am using 5.0.How do I get CFDIRECTORY to only retrieve the names of folders? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IsDate( ) behaviour
Nick, Yeah - I can do that I guess, but it seems like a pain.It was my guess that the inline evaluation feature was the culprit.In CFMX you an do variable arithmetic short hand as in: x = 1 y = 2 #x+y# ... outputs 3. I was guessing that the evaulater some how converts my sting into 1231 divided by 4, and the resultant decimal is evaluated as a date - which I might expect. In either case, it makes the function somewhat less useful than it might be. -Mark -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:10 PM To: CF-Talk Subject: Re: IsDate( ) behaviour Yeah, I have run into problems like that with using the isDate().The 1/1/1, .23334, and 2/3, all return true if you used isDate to test for dates.The way I get around this is in addition to using IsDate(), I use a regular _expression_ to test for the date string format. cfif isDate(dateString) and RegExp here Nick Han [EMAIL PROTECTED] 12/02/03 10:04AM If I have this string: '1231/04' And I pass it to IsDate( ) It returns True. IsDate(var) = TRUE If I pass it to DateFromat( ) it returns: 01-Apr-31 Can someone explain to me if this is expected behavior or if it's unusual? -Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: IsDate( ) behaviour
I think he meant unusual in the fact that '1231/04' is not a valid date (?), yet isDate() evalutes to true, and dateFormat() accepts it as an argument. as far as whether or not it's expected behaviour or unusual...I vote for unusual. charlie - Original Message - From: Kevin Graeme To: CF-Talk Sent: Tuesday, December 02, 2003 11:02 AM Subject: Re: IsDate( ) behaviour Because IsDate is for evaluation and DateFormat is for output formatting. -Kevin - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:04 PM Subject: IsDate( ) behaviour If I have this string: '1231/04' And I pass it to IsDate( ) It returns True. IsDate(var) = TRUE If I pass it to DateFromat( ) it returns: 01-Apr-31 Can someone explain to me if this is expected behavior or if it's unusual? -Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Embarassing printing problem
Hi all, I'm doing a query report for a list of personnel with single and/or multiple permits. The report page offers the option of sending the data to a printable page. My report print worked fine when it was listing every permit, but I have been asked to output the report so that permits are grouped under their owner's name, with the name only displaying once per set of owned permits. I have succeeded in getting the query to output in the requested format, but here's where this gets embarassing: In order to make the printable report display correctly, i.e., with the same-size page margins, and grouped results not rolling over to the next page (I can't use CSS) I used code for loops that I found in a Macromedia forum. Code that I, um (cough, cough) don't really understand. My goal is to have as many complete groups of permits display on a page as possible, with the next set going onto the next page, but I think that some groups are printing out incompletely. Plus the header is printing out halfway down the page, and so on. Here's the code for the page. I am hoping that someone can explain to me just what, specifically, the Loop through the query section of this code does, and if it will accomplish what I want. Right now it seems like that code is being ignored, because when I changed the MaxRows value in that section, nothing happened. But when I changed the MaxRows value in the cfoutput query statement -- cfoutput query = PermitSearch group=SSN startrow=#i# MaxRows = 6 -- which is not in the Loop through the query section, the output changed. Do I need another loop statement since I'm grouping results? Hope this post is understandable . . . Thanks, Laura == Laura Schlee DML Associates cell703-622-0363 ofc202-685-1360 !--- Get list of permits from database--- cfquery name=PermitSearch datasource=CMISPersonnel Select Personnel.SSN, Personnel.FirstName, Personnel.MiddleInitial, Personnel.LastName, Personnel.Zip, Personnel.SpaceNumber, Vehicles.TagNumber, Vehicles.DODDecalNumber, Vehicles.PermitNumber from Personnel, Vehicles where Personnel.PersonnelKey = Vehicles.PersonnelKey !--- Search by last name --- cfif Session.ParkingSearch.LastName is not and LastName like '%#Session.ParkingSearch.LastName#%' /cfif !--- Search by zip code --- cfif Session.ParkingSearch.Zip is not and Zip = '#Session.ParkingSearch.Zip#' /cfif !--- Search by permit number --- cfif Session.ParkingSearch.PermitNumber is not and PermitNumber = '#Session.ParkingSearch.PermitNumber#' /cfif !--- Search byassignedparking space number --- cfif Session.ParkingSearch.SpaceNumber is not and SpaceNumber = '#Session.ParkingSearch.SpaceNumber#' /cfif !--- Search by car licenseplate --- cfif Session.ParkingSearch.TagNumber is not and TagNumber = '#Session.ParkingSearch.TagNumber#' /cfif !--- Search by DOD decal number --- cfif Session.ParkingSearch.DODDecalNumber is not and DODDecalNumber = '#Session.ParkingSearch.DODDecalNumber#' /cfif order by LastName, FirstName, MiddleInitial, SSN /cfquery !-- Loop through the query results -- cfsetRowsPerPage = 6 cfparam name=this.startRow default=1 type=numeric cfset endRow = min(this.startRow + RowsPerPage - 1, PermitSearch.RecordCount) cfset startRowNext = endRow + 1 cfset startRowBack = this.startRow - rowsPerPage cfset MaxRows = 6 cfparam name = start default = 1 cfloop from=#start# to=#PermitSearch.RecordCount# step=#RowsPerPage# index=i !-- Display the results of the loop -- center table width=75% border=0 tr td colspan=3div align=center pnbsp;/p pfont color=##68 size=2 face=VerdanabPermit Search Results: cfoutput#PermitSearch.RecordCount#/cfoutput permits foundbr Use the print button on your browser to print this reportbr a href="" to permit search page/a/b/font/p /div pnbsp;/p /td /tr cfoutput query=PermitSearch group=SSN startrow=#i# MaxRows = 6 tr td width=36%font color=##68 size=2 face=VerdanabName:/b/font font color=##68 size=2 face=Verdana #FirstName# #MiddleInitial#br #LastName#/font /td td width=31%brfont color=##68 size=2 face=VerdanabSSN: /b/font#SSN#/td td width=33%brfont color=##68 size=2 face=VerdanabZip Code:/b/font font color=##68 size=2 face=Verdana #Zip#/font /td /tr tr td colspan=3 table width=100% cfoutput tr td width=36%nbsp;br/td td width=31%font color=##68 size=2 face=VerdanabPermit Number:br/b/fontfont color=##68 size=2 face=Verdana #PermitNumber# /font/td td width=33%font color=##68 size=2 face=VerdanabSpace Number:br/b/fontfont color=##68 size=2 face=Verdana #SpaceNumber#/font/td /tr tr td width=36%nbsp;br/td td width=31%font color=##68 size=2 face=VerdanabTag Number:br/b/fontfont color=##68 size=2 face=Verdana #TagNumber# /font/td td width=33%font color=##68 size=2 face=VerdanabDecal Number:br/b/fontfont color=##68 size=2
Re: IsDate( ) behaviour
Yeah, I got it. Late. Just a little slow here. -Kevin - Original Message - From: Charlie Griefer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:22 PM Subject: Re: IsDate( ) behaviour I think he meant unusual in the fact that '1231/04' is not a valid date (?), yet isDate() evalutes to true, and dateFormat() accepts it as an argument. as far as whether or not it's expected behaviour or unusual...I vote for unusual. charlie - Original Message - From: Kevin Graeme To: CF-Talk Sent: Tuesday, December 02, 2003 11:02 AM Subject: Re: IsDate( ) behaviour Because IsDate is for evaluation and DateFormat is for output formatting. -Kevin - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:04 PM Subject: IsDate( ) behaviour If I have this string: '1231/04' And I pass it to IsDate( ) It returns True. IsDate(var) = TRUE If I pass it to DateFromat( ) it returns: 01-Apr-31 Can someone explain to me if this is expected behavior or if it's unusual? -Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IsDate( ) behaviour
Thanks for this - saves me 15 minutes of futzing with re...
-mk
-Original Message-
From: Ubqtous [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 12:18 PM
To: CF-Talk
Subject: Re: IsDate( ) behaviour
Nick,
On 12/2/2003 at 13:09, you wrote:
NH Yeah, I have run into problems like that with using the
NH isDate().The 1/1/1, .23334, and 2/3, all
NH return true if you used isDate to test for dates.The way I
NH get around this is in addition to using
NH IsDate(), I use a regular _expression_ to test for the date string format.
NH cfif isDate(dateString) and RegExp here
This has worked well for me:
cfscript
function isvaliddate(string) {
if (refindnocase(^[0-9]{1,2}/[0-9]{1,2}/([0-9]{2}|[0-9]{4})$,arguments[1]) and
isdate(arguments[1])){
return true;
} else {
return false;
}
}
/cfscript
~ Ubqtous ~
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CFDIRECTORY: List Directories
Filter = *. [EMAIL PROTECTED] 12/02/03 01:19PM Hey guys, I am using 5.0.How do I get CFDIRECTORY to only retrieve the names of folders? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFDIRECTORY: List Directories
I use: cfdirectory action="" directory=c:\inetpub\wwwroot\ name=dirs cfquery name=dirs dbtype=query SELECT name FROM dirs WHERE type = 'Dir' /cfquery -nathan strutz -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 11:19 AM To: CF-Talk Subject: CFDIRECTORY: List Directories Hey guys, I am using 5.0.How do I get CFDIRECTORY to only retrieve the names of folders? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Date Range Query Issues
Hi Jochem,
Could you show me a statement where that is used, it sounds interesting just don't knowhow it is used.
Thanks
Mike
- Original Message -
From: Jochem van Dieten
To: CF-Talk
Sent: Tuesday, December 02, 2003 10:12 AM
Subject: Re: Date Range Query Issues
Candace Cottrell said:
1 - Do you mean natively or the way I have the db set up?
Natively, OVERLAPS is a SQL predicate:
('2003-12-01', '2003-12-31') OVERLAPS ('2003-12-16', '2004-01-15')
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Iteration variables
hello I'm writing a recursive function, and I need to hold variables relative to each iteration of the function... Which may have been changed further on down/up the line by another calling of the function So I need to hold values for each iteration How do you do this?! TIA, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date Range Query Issues
Thanks guys ;) Now I just have to figure out how screwed (or unscrewed) I am for breaking up the dates.
I've got a bit of work ahead of me and I'll let you know how it turns out.
Thanks again!
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
[EMAIL PROTECTED] 12/2/2003 12:49:01 PM
No, I just tried it and I couldn't get it to work.
But you can use between
select count(idField)
from yourtable
where type = 'checktype'
and (startDateField between 'startdate' and 'enddate'
OR endDateField between 'startdate and 'enddate')
Of course change all of the 'variables' to either cfqueryparams in cf or
@variables in TSQL.
Steve
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 12:05 PM
To: CF-Talk
Subject: RE: Date Range Query Issues
not going to work in sql server 2000, not from what I can see in the
docs
..tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 10:22 AM
To: CF-Talk
Subject: Re: Date Range Query Issues
Oh wow... I didnt know about that... I'm using MSSQL 2000...
I'll try it out when I get back from my meeting. :)
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org http://www.childrensdayton.org
[EMAIL PROTECTED]
[EMAIL PROTECTED] 12/2/2003 10:12:16 AM
Candace Cottrell said:
1 - Do you mean natively or the way I have the db set up?
Natively, OVERLAPS is a SQL predicate:
('2003-12-01', '2003-12-31') OVERLAPS ('2003-12-16', '2004-01-15')
Jochem
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
suggestion for anyone with questions
A lot of times, the questions people ask can be solved with a simple dump of the object they're working with.I know this may be elementary to some, but for anyone new, or anyone who hasn't thought about this, try using cfdump and dump the object you're working with.For instance, if you're working with a query named getRecords, try cfdump var=#getRecords#.Or, if you do CFDIRECTORY and have the results returned in a variable named getDirectoryList, try cfdump var=#getDirectoryList#.There's lots of other things you can dump if you figure out the objects or scope.That's helped me a ton just by figuring out exactly what data CF has stored in that object or variable.Then, I can filter or manipulate as needed. I hope that helps someone out there.Anyone who can add to what I've mentioned, feel free, I'd love to hear other useful tips. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Outputting to local Excel file
you can do two things...first thing is this... cflocation url="" or and im not 100% on this way, but its something like this... cfheader cfcontent with some attributes set in both, the list can help with that. but also, one more thing I would definitely recommend doing is to write the cfloop inside of a cfsavecontent tag, then take that variable that cfsavecontent creates and write that once to the xls file. cfquery /cfquery cfsavecontent variable=dataToWriteToFile cfsetting enablecfoutputonly = yes cfloop !--- process stuff here --- /cfloop cfsetting enablecfoutputonly = no /cfsavecontent cffile output=#dataToWriteToFile# now there is a lot missing but you should get the gist of the idea. make sense? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:56 PM To: [EMAIL PROTECTED] Subject: RE: Outputting to local Excel file Okay, how can I do that? This is what I have... !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN cfset ds = application.datasource / cfquery name=daily datasource=#ds# SELECTbu_center.location, status.status, main.id, main.emplid, workgroup.workgroup, getnamefromemplid(main.emplid) as emplname, getnamefromemplid(main.submitby) as submitname, requesttype.requesttype, phonetype.PHONETYPE, main.bu, getnamefromemplid(main.actionuser) as workedby, getnamefromemplid(main.approver) as approvedby FROM main, bu_center, workgroup, status, requesttype, phonetype WHERE ( (main.bu = bu_center.bu) AND (main.statusid = status.statusid) AND (bu_center.workgroupid = workgroup.workgroupid) AND (main.requesttypeid = requesttype.requesttypeid) AND (main.phonetypeid = phonetype.phonetypeid) ) ORDER BY workgroup.workgroup ASC, bu_center.location ASC /cfquery cfset f_dir = D:\inetpub\wwwroot\customerservice\touchpoint\reports\ cflock scope=session timeout=30 cffile action="" file=#f_dir##f_name# nameconflict=OVERWRITE output=THE ID,WORK GROUP,LOCATION,PHONE TYPE,EMPLOYEE ID,EMPLOYEE NAME,BU NUMBER,SUBMITTED BY,STATUS addnewline=Yes cfloop query=daily cffile action="" file=#f_dir##f_name# output=#daily.id#,#daily.workgroup#,#daily.location#,#daily.phonetype#,#dai ly.emplid#,#Replace(daily.emplname,,, )#,#daily.bu#,#Replace(daily.submitname, ,, )#,#daily.status# addnewline=Yes /cfloop /cflock html head titleOutput Excel File/title /head body cfoutputa href=""> /body /html This creates a link to file:///D:/inetpub/wwwroot/customerservice/touchpoint/reports/120203-1252.xl s but when you right click and choose save target as all you get is a windows error sound. If you open in new window, a blank window opens with nothing in it. But the file is there, or so it looks. I'm stumped.. can you help me? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 11:26 AM To: CF-Talk Subject: RE: Outputting to local Excel file the same way you would take over their machine and log in and delete all the files on their machine :) no can do...but you can force their browser to download it, well force to the point that they have to click on save/open, but that's about all. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 11:16 AM To: CF-Talk Subject: Outputting to local Excel file I know how to output data to an excel spreadsheet but how to make it save the excel file to their local machine? C:\... saves it server side as well.. Any help would be appreciated, thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Iteration variables
Probably a list or array would be easiest. (If I understand correctly)Just look for the value in the nth place in the list/array. John Burns -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:59 PM To: CF-Talk Subject: Iteration variables hello I'm writing a recursive function, and I need to hold variables relative to each iteration of the function... Which may have been changed further on down/up the line by another calling of the function So I need to hold values for each iteration How do you do this?! TIA, Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Iteration variables
Just make sure it's a 'var' variable, and it'll be local to that specific function invocation.That's one of the big reasons recusion is so elegant. You can't easily get that type of controlled variable scoping with iterative solutions. Cheers, barneyb -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 9:59 AM To: CF-Talk Subject: Iteration variables hello I'm writing a recursive function, and I need to hold variables relative to each iteration of the function... Which may have been changed further on down/up the line by another calling of the function So I need to hold values for each iteration How do you do this?! TIA, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX is writing to application.log BUT not to windows eventLog
I have a problem where I can trap an error in CFMX's application log but not in the w2k Eventlog even though the documentation states that I can. Here is my code: cftry cfexecute name=xyz arguments=x variable=xyz timeout=1/cfexecute cfcatch cflog type=Error log=APPLICATION text=hello_I_am_error date=yes time=YES /cfcatch Here is an excerpt from the documentation: Under Logging Settings Page, there is a setting to Use Operating System Logging Facilities and it's description is Log messages using your operating system logging facility (EventLog in Windows; syslog on Solaris, Linux, and HP-UX). ColdFusion log messages are also written to the standard ColdFusion MX log files. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
help gurus!
OK, I have a good one for all the gurus out there... I am trying to load test a fairly complex flash/CF App. I was able to record the flash AMF traffic using loadrunner, but I am not entirely certain where to go from here. I want to parameterize the AMF calls so I can simulate several users (and several methods) without haveing to record each one and replay them. Any help is greatly appreciated! LoadRunner successfully records the AMF into a hexadecimal string like so: web_custom_request(gateway, URL=""> Method=POST, Resource=1, RecContentType=application/x-amf, Referer=, EncType=application/x-amf, BodyBinary= \\x00\\x00\\x00\\x01\\x00\\x10 amf_server_debug \\x01\\x00\\x00\\x00 ` \\x03\\x00 \n coldfusion \\x01\\x01\\x00 \n amfheaders \\x01\\x00\\x00\\x03 amf \\x01\\x00\\x00\\x0B httpheaders \\x01\\x00\\x00 \trecordset \\x01\\x01\\x00\\x05 error \\x01\\x01\\x00\\x05 trace \\x01\\x01\\x00\\x07 m_debug \\x01\\x01\\x00\\x00 \t \\x00\\x01\\x00 #estars.core.system.getFlashGateways \\x00\\x02 /1 \\x00\\x00\\x00\\x05 \n \\x00\\x00\\x00\\x00 , LAST); This mail sent through exciteworks: http://exciteworks.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
XmlSearch() returning Attribute Values
It seems as if XML Search only returns element nodes, and that's it. Poor, poor, poor planning, IMHO. Has anyone created a work around, for example, for doing the following: --- XMLSearch(xmlDoc, '/document/node/@attributeVal') --- to return the string value of the attribute attributeVal for element node? -- Alex Sherwood PHS Collection Agency THE COLLECTORS T:301.215.4200 F:301.664.6834 W: www.phs-net.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:SQL to Access
You can create a batch file that will run at DTS. Look into the command dtsrun on Books Online. At 12:50 PM 12/2/2003 -0400, you wrote: Is there a way, though, to have the user push a button on a page which you initiate the DTS transaction?The project's end users want to be able to initiate a data dump at any time, rather than at a regular interval. -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:SQL to Access
If the sql server is on a remote server then you may also run a DTS via a stored procedure. The stored procedure has more limitations then the command line utility dtsrun. At 12:50 PM 12/2/2003 -0400, you wrote: Is there a way, though, to have the user push a button on a page which you initiate the DTS transaction?The project's end users want to be able to initiate a data dump at any time, rather than at a regular interval. -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looking Up Issues on MM Site
Howdy Jochem, Monday, December 1, 2003, 3:30:14 PM, Jochem van Dieten wrote: You don't. You know the number if you filed the bug. So if you want to review past issue/bug reports to see if anyone has already filed one before you want to file one, then you're out of luck? Must lead to lots of dupe reports, no? -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: XmlSearch() returning Attribute Values
The xmlSearch() returns an array of XML object nodes using regular XPath _expression_ like e.g.. myBook =xmlSearch(xmlBooks, Books/[EMAIL PROTECTED]'ColdFusion']); Then you can plough through the array returned to do whatever Joe Eugene - Original Message - From: Alexander Sherwood To: CF-Talk Sent: Tuesday, December 02, 2003 2:33 PM Subject: XmlSearch() returning Attribute Values It seems as if XML Search only returns element nodes, and that's it. Poor, poor, poor planning, IMHO. Has anyone created a work around, for example, for doing the following: --- XMLSearch(xmlDoc, '/document/node/@attributeVal') --- to return the string value of the attribute attributeVal for element node? -- Alex Sherwood PHS Collection Agency THE COLLECTORS T:301.215.4200 F:301.664.6834 W: www.phs-net.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: XmlSearch() returning Attribute Values
It seems as if XML Search only returns element nodes, and that's it. Poor, poor, poor planning, IMHO. Yes, it only return Node Lists, I posted on LiveDocs about it. Mine is the first comment: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca126.htm#wp427963 6 Has anyone created a work around, for example, for doing the following: XMLSearch(xmlDoc, '/document/node/@attributeVal') to return the string value of the attribute attributeVal for element node? If you really care, you can use the XPath classes from Xalan. But I am not sure it's worth the efforts... Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Weather Feed
Does anyone have a CF tag for retriving weather by zip? Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue/Wed) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P.315-386-4504 x 164 F.315-386-3395 Heuvelton (Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P.315-344-2414 x 3651 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Date Range Query Issues
DURETTE, STEVEN J (AIT) wrote:
But you can use between
select count(idField)
from yourtable
where type = 'checktype'
and (startDateField between 'startdate' and 'enddate'
OR endDateField between 'startdate and 'enddate')
That won't work, it won't detect the following overlap:
('2003-12-01', '2003-12-31') ('2003-12-02', '2003-12-30')
You need a statement that is actually even simpler:
SELECT COUNT(idField)
FROM yourtable
WHERE type = 'checktype'
AND startDateField cfqueryparam cfsqltype=cf_sql_date
value=#formEndDate#
AND endDateField cfqueryparam cfsqltype=cf_sql_date
value=#formStartDate#
Just make sure you verify that the user submitted startdate is
less than the user submitted enddate.
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Date Range Query Issues
Mickael wrote:
Could you show me a statement where that is used, it sounds interesting just don't knowhow it is used.
Instead of
SELECTx
FROM yourtable
WHEREstartDateField '#formEndDate#'
AND endDateField #formStartDate#'
one would use:
SELECTx
FROM type = 'checktype'
AND (startDateField, endDateField) OVERLAPS
('#formEndDate#', #formStartDate#')
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Weather Feed
don't have the code handy, but i use http://www.ejse.com/services/xml_web_services.htm for a weather feed.It's free (for now, at least...i've heard rumors that they were going to start charging). if you're on MX, should be easy enough to use MX's built in XML functions to parse the feed.otherwise I can post some code when I get home (won't be for a few hours tho) :| charlie - Original Message - From: Scott Wilhelm To: CF-Talk Sent: Tuesday, December 02, 2003 1:29 PM Subject: Weather Feed Does anyone have a CF tag for retriving weather by zip? Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue/Wed) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P.315-386-4504 x 164 F.315-386-3395 Heuvelton (Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P.315-344-2414 x 3651 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
store dB - question re items
Up to now when creating a store I've been selling items such as CDs which would have band, title, check to see the amount still in stock, etc... Now I'm creating a store front for a sweater manufacturer. There are a variety of different sweaters. No problem :-) There are a variety of different color. Again, no problem :-) Sweater A comes in colors red and white. Sweater B comes in colors white and blue. Problem: how to set up the db to handle this. TABLE ITEMS (table of all the items to be displayed/sold) itemID (PK) TABLE COLORS (table of all the potential colors - used to populate itemColors) colorsID (PK) color TABLE ITEMCOLORS (table listing all colors for a particular item) itemColorsID (PK) itemID colorsID To get the colors for Sweater A do a SELECT * FROM itemColors WHERE itemID = whatever That was the first idea. What about a field in ITEMS called itemColors so that the record for Sweater A would look like itemID | 1001 itemName | Sweater A itemColor | red, white thx Gibert Midonnet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looking Up Issues on MM Site
Chris Montgomery wrote: Monday, December 1, 2003, 3:30:14 PM, Jochem van Dieten wrote: You don't. You know the number if you filed the bug. So if you want to review past issue/bug reports to see if anyone has already filed one before you want to file one, then you're out of luck? Yes. Must lead to lots of dupe reports, no? Apparently not that many, otherwise Macromedia would have implemented a public bugbase. But if you, like me, would like to see a public repository for bugs and enhancement requests you could always file a bug/enhancement request :-) http://www.macromedia.com/go/wish/ Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date Range Query Issues
Jochem,
The problem with your change is that it won't pick up partial overlays.
Mine works if you consider a few things.
1) the startdate and enddate have to be fully qualified datetimes.
2) there was one error an extra set of () needed to be included.
So this works:
select count(idField)
from yourTable
where type = 'yourtype'
and ((startDateField between '12/01/2003 00:00:00' and '12/31/2003
23:59:59')
OR
(endDateField between '12/01/2003 00:00:00' and '12/31/2003
23:59:59'))
The modified version that you had below had an and in it between the 2 date
tests which would mean that it wouldn't pick up overlays like (11-25-2003,
12-15-2003) (12-01-2003, 12-31-2003)
If this doesn't work for you, let me know because it works for me.
Steve
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 3:31 PM
To: CF-Talk
Subject: Re: Date Range Query Issues
DURETTE, STEVEN J (AIT) wrote:
But you can use between
select count(idField)
from yourtable
where type = 'checktype'
and (startDateField between 'startdate' and 'enddate'
OR endDateField between 'startdate and 'enddate')
That won't work, it won't detect the following overlap:
('2003-12-01', '2003-12-31') ('2003-12-02', '2003-12-30')
You need a statement that is actually even simpler:
SELECT COUNT(idField)
FROM yourtable
WHERE type = 'checktype'
AND startDateField cfqueryparam cfsqltype=cf_sql_date
value=#formEndDate#
AND endDateField cfqueryparam cfsqltype=cf_sql_date
value=#formStartDate#
Just make sure you verify that the user submitted startdate is
less than the user submitted enddate.
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Date Range Query Issues
Jochem,
OVERLAPS isn't a valid MSSql2K TSQL command.I looked it up in the MSSQL
Books online.
Steve
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 3:38 PM
To: CF-Talk
Subject: Re: Date Range Query Issues
Mickael wrote:
Could you show me a statement where that is used, it sounds interesting
just don't knowhow it is used.
Instead of
SELECTx
FROM yourtable
WHEREstartDateField '#formEndDate#'
AND endDateField #formStartDate#'
one would use:
SELECTx
FROM type = 'checktype'
AND (startDateField, endDateField) OVERLAPS
('#formEndDate#', #formStartDate#')
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: store dB - question re items
I think that's a matter of how you feel like looking up the data, string sorted is ok, but then what if that changes, you have to change the string, inside the table, but if its columnar and theres an row for each item/color pair I think it would be easier to have a join table that links an item to its color choices... ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 3:43 PM To: CF-Talk Subject: store dB - question re items Up to now when creating a store I've been selling items such as CDs which would have band, title, check to see the amount still in stock, etc... Now I'm creating a store front for a sweater manufacturer. There are a variety of different sweaters. No problem :-) There are a variety of different color. Again, no problem :-) Sweater A comes in colors red and white. Sweater B comes in colors white and blue. Problem: how to set up the db to handle this. TABLE ITEMS (table of all the items to be displayed/sold) itemID (PK) TABLE COLORS (table of all the potential colors - used to populate itemColors) colorsID (PK) color TABLE ITEMCOLORS (table listing all colors for a particular item) itemColorsID (PK) itemID colorsID To get the colors for Sweater A do a SELECT * FROM itemColors WHERE itemID = whatever That was the first idea. What about a field in ITEMS called itemColors so that the record for Sweater A would look like itemID | 1001 itemName | Sweater A itemColor | red, white thx Gibert Midonnet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
diagrams for cfc's
I was wondering what people are using to diagram CFC's.Are you using UML diagrams or some other type of diagram?Do you recommend software (preferably shareware) to diagram CFC's Any suggestions? Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: diagrams for cfc's
there is a web based thing for creating uml designs, not sure of the url, but ive seen it here before someone will most certainly chime in with it, im sure! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Michael Hodgdon [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 3:52 PM To: CF-Talk Subject: diagrams for cfc's I was wondering what people are using to diagram CFC's.Are you using UML diagrams or some other type of diagram?Do you recommend software (preferably shareware) to diagram CFC's Any suggestions? Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
