RE: switch in
This should do what you are looking for: switch (iAnsType){ case 6 : case 7 : sAnswer = Replace(sAnswer, ",", "|", "ALL"); } -Original Message- From: CF Dude [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 12:39 PM To: CF-Talk Subject: switch in Is there a way to do multiple values per case statement when doing a switch inside of a tag? switch (iAnsType){ case 6 : sAnswer = Replace(sAnswer, ",", "|", "ALL"); case 7 : sAnswer = Replace(sAnswer, ",", "|", "ALL"); } EG, I was hoping to do this switch (iAnsType){ case 6, 7 : sAnswer = Replace(sAnswer, ",", "|", "ALL"); } Eric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trusted cache?
Philip, Do you know where I could find more information about this? I have been tasked with determining if we want to turn this on in our production server, but there is concern about having to restart cf if we make a change. Do you (or anyone else) know where there is detailed information about the trusted cache? All I can find are short descriptions with no details. Thanks, Steve -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 10:27 AM To: CF-Talk Subject: RE: Trusted cache? > I think he was using CF5 and AFAIK you no longer have to stop > and start the server, just uncheck the setting in the administrator! This is what I was saying... BUT, if you regularly upload files to multple servers, save time, it's easier to write a procedure to upload and push the file out of Trusted Cache Using a procedure like this, you can automate a lot of the Trusted Cache issues with refreshing the file ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ODBC Error Code = S1001 (Memory allocation error)
Looks to me like you might have run out of disk space. Either on the drive where the access database is at or in the drive where your temp files are created. Just a guess though. -Original Message- From: David K [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 1:16 PM To: CF-Talk Subject: ODBC Error Code = S1001 (Memory allocation error) Never seen this error before... === ODBC Error Code = S1001 (Memory allocation error) [Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk. === Can anyone provide some insight and a possible fix? --David ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: force a download
Just popping in on this conversation, (sorry if someone already said this), but have you tried: or Steve -Original Message- From: Fetter, Brad [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 1:16 PM To: CF-Talk Subject: RE: force a download Hmm still not working...The Cfheader doesn't like the lack of a " in the value field. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 8:59 AM To: CF-Talk Subject: Re: force a download Oops.in the CFHEADER tag don't use the full path...just the name of the file you wanna push Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Fetter, Brad" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 8:43 AM Subject: force a download > Hmmm, I tryed to force a download of a jpg file with the following code and > browser tried to open the cfm page in Coldfusion Studio... Is there another > way to force a download? Maybe through a Metatage or Javascript? > > file="d:\inetpub\wwwroot\portland\medialibrary\Media\4X4JEEP.jpg" > > > > > > -Original Message- > From: Fetter, Brad [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 8:11 AM > To: CF-Talk > Subject: RE: force a download [was: SQL concat] > > > Thanks Jochem I will try that.. > > -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 1:41 AM > To: CF-Talk > Subject: Re: force a download [was: SQL concat] > > > Fetter, Brad wrote: > > > > I have video, and image library on our intranet and we want to have a > > hyperlink that will allow the > > user to download the file to their hard drive without having right click > and > > select file save as. Is there an easy way to do this? > > Use cfcontent with the mime type "application/octet-stream" (due to a > bug in IE, IE requires the mime type "unknown/unknown" (b*tching to > [EMAIL PROTECTED] about this bug is much appreciated)). > > Jochem > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE:
Each logical line inside a cfscript has to be followed by a ; -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 1:56 PM To: CF-Talk Subject: Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFSCRIPT tag occupying document position (23:1) to (23:10). REQUEST.DIR1 = "C:\documents\dir1" REQUEST.DIR2 = "C:\documents\dir2" REQUEST.DIR3 = "C:\documents\dir3" ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any one find a fix for the "null null The error occurred on line x" error?
Could it actually be line 4 of the application.cfm or a cfincluded file. I have had that happen before where MX reported that the error was in one file, but it was actually in an included file. Steve -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 12:44 PM To: CF-Talk Subject: Any one find a fix for the "null null The error occurred on line x" error? I just installed updater 3 hoping this "null null" problem would go away. But, just got three in a row from the same IP address (same user). The error simply says: null null The error occurred on line 4. There is no cf code on that line. only Welcome to urbana.org I get this error on different pages. Not just the index.cfm page. Any thoughts? Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS Outlook and CF
Bryan, Share! I have been watching for this for a long time and my searches usually turn up nothing. Steve -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 4:34 PM To: CF-Talk Subject: RE: MS Outlook and CF nevermind, found it in the houseoffusion archives after a lengthy search :) +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 1:28 PM To: CF-Talk Subject: MS Outlook and CF Anyone know how to access MS Outlook's calendar using CF? I assume there is an object I can tap, but I don't know what it would be... +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Very unsatisfied with Macromedia's support attention ...
Jim, How do you change the order in which things start up? I've had a dev server that has this problem also, we don't reboot it often so we usually just start it manually. If I could change the order and make cfmx last it might clear up my problem. Thanks, Steve -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 3:19 PM To: CF-Talk Subject: RE: Very unsatisfied with Macromedia's support attention ... > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2003 2:04 PM > To: CF-Talk > Subject: Re: Very unsatisfied with Macromedia's support attention ... > > Hey Mike, > > Personally I would be pretty ticked if I had to start my CF services > manually. I'm not sure why they are saying this is a known bug. Can you > shed some light as to why this "bug" is happening on your setup > specifically? or are they saying it has to do with Updater 3? However if running a batch file DOES work then you should look at the order at which things start up - rearranging them should fix the problem. We had a problem with PCAnywhere, for example, it would take a bit longer than it claimed to start up and interfere with later services (in our case Exchange 2000). Once we moved PCAnywhere to start up last the problem went away completely. Since you make very well be using PCAnywhere (sine this is a remote box) I'd try that just for kicks. There's a technote at Symantec.com about this. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Major CF Administrator Problem
Has anyone ever seen the following error? You are using tags whose name begins with CF, but the tag is not registered with Neo. Either the tag is not completed yet, or have you been playing with the configuration? Unknown tag: cfdump. ColdFusion cannot determine how to process the tag cfdump because the tag is unknown and not in any imported tag libraries. The tag name might be misspelled. The error occurred in E:\Inetpub\wwwroot\CFIDE\administrator\settings\jvm.cfm: line 320 It happens when I access the datasources or the java settings pages. Any one have a fix? Steve *COST SAVINGS SUGGESTION* For pages that must be printed, change your print settings to print in "grayscale" instead of color. Steve Durette Mgr-Eng. & Const. Systems Support 100 S. Main Room 314 Mt. Clemens, MI 48043 Ofc: 586.466.7654 Fax: 586.466.1109 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Major CF Administrator Problem
Barney, Thanks, that was it. I copied the file from a backup and everything works now. I just wish I knew why files are disappearing. First, the Application.log file disappears at random (but usually around the time of a cf crash) and now the dump.cfm file. What next. Steve -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 6:48 PM To: CF-Talk Subject: RE: Major CF Administrator Problem check your cfusionMX/wwwroot/WEB-INF/cftags directory and see if there is a 'dump.cfm' file there. That directory is like the custom tags directory, except it's for the built in CF tags that are implemented with native CF. You can even put your own tags there if you hate the cf_ prefix, although that's generally not a good idea. --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -Original Message- > From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 28, 2003 2:51 PM > To: CF-Talk > Subject: Major CF Administrator Problem > > > Has anyone ever seen the following error? > > > You are using tags whose name begins with CF, but the tag is not > registered > with Neo. Either the tag is not completed yet, or have you been > playing with > the configuration? > Unknown tag: cfdump. > ColdFusion cannot determine how to process the tag cfdump because > the tag is > unknown and not in any imported tag libraries. The tag name might be > misspelled. > > The error occurred in > E:\Inetpub\wwwroot\CFIDE\administrator\settings\jvm.cfm: line 320 > > > It happens when I access the datasources or the java settings pages. > > Any one have a fix? > > Steve > > > > > > > *COST SAVINGS SUGGESTION* > For pages that must be printed, change your print settings to print in > "grayscale" instead of color. > > > Steve Durette > Mgr-Eng. & Const. Systems Support > 100 S. Main > Room 314 > Mt. Clemens, MI 48043 > Ofc: 586.466.7654 > Fax: 586.466.1109 > [EMAIL PROTECTED] > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMAIL and spacing.
I usually solve this by having the type="HTML" and then use html code do the layout of the e-mail. -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2003 12:29 PM To: CF-Talk Subject: CFMAIL and spacing. oi CF-Talk,!! is there an easy way to format my email messages so I do not have to left align all my mail content in my code... it's annoying.. ex: shows up in the messages with all the preceding whitespace... ideas? i hate having to do this: --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IF File Exist
In cfmx: do do Of course you have to use the full server path to the file. Steve -Original Message- From: Paige Chandler [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2003 1:10 PM To: CF-Talk Subject: IF File Exist Hello All, How can I determine if a file exist? Sort of like: do Thanks. Have a great day. Regards, Paige ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Array sum question.
All, I am trying to do a strange array sum and it won't work. First let me state that the is a multi-dimension array and to give an idea of what it looks like: mytgtarray[row][col] |COL1|COL2|COL3|COL4|COL5|COL6| row 1| 1 | 2 | 3 | 4 | 5 | 6 | row 2| 2 | 3 | 4 | 5 | 6 | 7 | row 3| 3 | 4 | 5 | 6 | 7 | 8 | I am trying to sum up column 6. (result should be 21) Of course this isn't my real data. I tried myTot = arraySum(mytgtarray[][6]) and got the error invalid cfml construct ] so I tried myTot = arraySum(mytgtarray[*][6] and got the error invalid cfml construct * does anyone have any ideas of how to do this, or can it even be done? Does arraysum only work on single dimension arrays? Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to add shortcuts to snippets in DW MX
Massimo, Since you seem to know a lot about some pretty complicated issues in dreamweaver maybe you can provide an answer. Do you know of any way to add the Ctrl-M feature of CFStudio and Homesite (when in a tag, jump to it's closing tag)? I have to review and maintain a LOT of code created by contractors and this feature is critical. It's the only reason why I haven't moved to dreamweaver mx (it's installed, just not used). I'm using homesite+ instead. Thanks, Steve -Original Message- From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] Sent: Sunday, June 08, 2003 10:37 AM To: CF-Talk Subject: How to add shortcuts to snippets in DW MX I know many people complain about this, so, since I tried to cover the issue in the past, I summarized everything in a single post. I hope it could be help to fellow developers. Please be free to share this everywhere and post it on blogs as you see fit (if possible include the whole post, no editing please) Adding keyboard shortcuts to snippets is possible with DW MX as well, it's just a painful process... Here it is: 1) Go in Design View (in order to enable the History Panel) 2) Insert a Snippet 3) Now inside the History Panel you should have an entry for the snippets insertion 4) Select the entry in the panel and, from the contextual menu, choose "Copy Steps" 5) Open an external text editor (Notepad would be fine) and paste 6) Inside the text editor you should now see the API call to the snippet, something like this: dw.snippetPalette.insertSnippet('MyFolder\\MySnippet.csn'); 7) Quit DW 8) Open the monster menus.xml file inside you local configuration, typically: C:\Documents and Settings\\Application Data\Macromedia\Dreamweaver MX\Configuration\Menus\Menus.xml For more details read: http://www.macromedia.com/support/dreamweaver/ts/documents/multiuser.htm 9) At the very top of the monster menus.xml you can find many entries for keyboard shortcuts, add something along these lines: 10) Restart DW, you are done Final notes: - Be careful editing menus.xml, never open it in DW! - Always back up the menus file, DW does it automatically (see Menus.xbk) - Be careful identifying keyboard combination not already in use - Each id inside menus.xml must be unique, valid JavaScript variable name My considerations: Q: Is it worth? A: It depends, for me it isn't, but I am definitely a mouse user Q: Is it a painstaking process? A: Yes, it is Q: Shouldn't be easier? A: Yes, sure, anything is better than this Q: Shouldn't DW expose this capability from a GUI? A: Sure, I vote for it! Q: What we can do? A: Ask MM, send them hundreds of requests: http://www.macromedia.com/support/email/wishform/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Loop using roman numerals??
There is a RomanFormat function on cflib.org that you could use. Then you could just loop through using decimal, but display the roman numeral. Steve -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 9:22 AM To: CF-Talk Subject: Loop using roman numerals?? I'm wondering if I can do this easily?? I need a numbered loop, but it needs to be roman numerals i, ii, iii, iv, v, vi, etc Is there anyway to do that easily or do I need to do the cfif recordcount blah blah. thanks, j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there SQL equivalent to CF's ListGetAt function??? Please help!
Are you using SQL 2000? If so then you could create a user defined function to do what you want. Let me know, and I'll see if I can quickly throw something together. Steve -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 9:39 AM To: CF-Talk Subject: RE: Is there SQL equivalent to CF's ListGetAt function??? Please help! thanks...I wish there was an easier fix -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 9:27 AM To: CF-Talk Subject: RE: Is there SQL equivalent to CF's ListGetAt function??? Please help! I don't know if this is the best way, but have a look at SubString() and CharIndex(), you might be able to use the two together to get what you need. This is on SQL Server by the way. Ade -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:10 To: CF-Talk Subject: Is there SQL equivalent to CF's ListGetAt function??? Please help! I have a column in a db that stores data with a pipe [|] delimiter. I would like to write a SQL query that filters data based on a segment of data within a pipe delimited variable. Basically, is there SQL code that is equivalent to the psuedo CF code below? A SQL version of ListGetAt if you will??? --> WHERE FinalShipTo = ListGetAt("#getOrderInfo.FinalShipTo#","5","~") <-- I hope this makes sense... TIA - Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: counting to 5-problem
My question would be how do you determine which 5? If you had a list of 10 people, would only the first 5 get the e-mail? Why would you want to prevent the others from getting the e-mail if they signed up for it? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 8:53 AM To: CF-Talk Subject: counting to 5-problem We are having an eMailing-List where quite e few people do have eMail-adresses from the same companies. Now we want to send out eMails only to 5 people of the same company but not more. The sixth eMail-adress should be marked (with a checkbox or s.th. else). The fields are eMail and company. How can I do this ? I don't have an idea yet. Can someone help me ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Server 2000 List Functions
Hi all, The day before yesterday, someone mentioned having problems dealing with lists in SQL. Their final solution ended up using regular expressions, but I figured that I would still need to deal with lists in SQL in the near future, so I went and created some list functions in SQL. Of course, as they are functions they will only work in MS SQL Server 2000 (don't know about future versions, but it should work as these are quite simple). For the most part they work like their CF counter parts with a few quirks. If any anyone is interested, I will post the code to the list and do a little doc write up. The functions I created are: listLen, listGetAt, listDeleteAt, listSetAt, listFirst, listLast, listPrepend, listAppend, listFind, listInsertAt and listToTable Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Drop User in SQL Server
Not positive about this, but... I believe that I read somewhere you can't delete the user if it has objects assigned to it. IE Tables. Make sure that all of the objects that this owner used to have are changed to have dbo (or sa) as the owner. Then you might be able to delete the user. Steve -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 12:40 PM To: CF-Talk Subject: Drop User in SQL Server This may be better posted on a SQL board, but I know there are a lot of SQL Server gurus out there and I need your help! A client's web host just had to reinstall SQL Server 2000, and I am having a hard time getting a former user name to work properly, or setup a new user name. If I setup a new user name, the datasource appears to work fine in CF 5 admin. Then when I try a page I get a message: "ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'grpdes'." When I log into RDS in CF Studio the old user name shows up in the datasource; for example: "BandD.grpdes" ("BandD" is the old user name.) I've tried to delete the user name, but it will not remove itself from the "Public" role. If I try and recreate the user name I get the message: "Error 15023: User or role 'BandD' already exists in the current database." I've tried to detach the database, create the user (temporally attaching the user name to another database), re-attach the database and assign the user name to the database, but I get the "Error 15023 ..." Any ideas would be greatly appreciated! Thank you, Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Tel. 503-244-3440 Fax 503-244-3454 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Forta's WACKs
Shouldn't that be the removal of Basic security? -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 3:06 PM To: CF-Talk Subject: RE: Forta's WACKs I haven't read either one, so I can't say for sure. However, chapter 17 should be fairly similar, except for locking issues, and chapter 18 should be very different, because of the new CFLOGIN tag, and the removal of advanced security. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -Original Message- > From: Candace Cottrell [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 18, 2003 11:51 AM > To: CF-Talk > Subject: Forta's WACKs > > > Is there a whole lot of difference in these 2 chapters in version CF 5 > vs. the MX version? > > 17 - Working with Sessions > 18 - Securing Your Applications > > > > 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] > > 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] > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFSCRIPT syntax
Another point to consider is that sometimes you have no choice but to use the pound signs. This one bit me recently. sets the Form.date variable to "now()". I ended up putting the quotes and the pound signs back in. As for the previous question on doing a cfparam inside of cfscript, I THINK (don't hold me to this) that the only way to do this is: if(not isDefined("FORM.Date")) FORM.Date = Now(); Of course, this uses the example above and would require more code if you wanted to ensure the type of data that was coming in. Steve -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 7:31 AM To: CF-Talk Subject: Re: CFSCRIPT syntax I can add the following snippet to the conversation: Guidelines for using pound signs Follow these guidelines when using pound signs: Use pound signs to distinguish variables or functions from plain text. Surround only a single variable or function in pound signs; for example, #Variables.myVar# or #Left (myString,position)#. However, a function in pound signs can contain nested functions, such as #Left(trim(myString), position)#. Do not enclose complex expressions, such as 1 + 2, with pound signs. Do not use pound signs when using the cfset tag to assign one variable's value to another value. Use pound signs only where necessary, because unneeded pound signs slow processing. ref: http://www.macromedia.com/support/coldfusion/getting_started/using_poundsign s_quotat/using_poundsigns_quotat02.html HTH, Calvin - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 19, 2003 10:23 PM Subject: RE: CFSCRIPT syntax > Hi Mark, > > Just to add to Raymond's comments, > > I think the confusion about hashes and quotes comes about from CF tags, > where you DO need them when you are passing a numeric or a variable as an > attribute, i.e. > > > > In any other situation, you only need quotes around strings, and you only > need hashes when inserting an expression into a string or cfoutputting > it More or less. > > > 4) Can a CFPARAM statement be written in CFSCRIPT? If so, how? > > Take a look at this udf: > http://www.cflib.org/udf.cfm?ID=144 > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Form Submission Hacking.
Wouldn't this be a good place to use request scope variables instead of session? Just asking, never done anything like this before. Steve -Original Message- From: Igor Ilyinsky [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 2:47 PM To: CF-Talk Subject: RE: CFMX Form Submission Hacking. Still not sure how what you're saying works. Let me give you a scenario. User clicks checkout on the e-commerce app. from his shopping cart. --> request gets sent to form page; session.notahacker = 1 <-- The page comes up with a request for his CC info in a form. The same form has a hidden field with the total purchase amount ($35) User Clicks Save, to save the html page to his desktop. User Edits the HTML page to change the amount from $35 to $3 User Opens the page in a browser from his local machine. User clicks submit from this page to my web server --> request gets sent to submit page; session.notahacker is still 1 <-- What was solved? -Igor -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 1:38 PM To: CF-Talk Subject: Re: CFMX Form Submission Hacking. Form Page - set the session variable equal to 1 Processing Page - check to see if the session variable equals 1, and if so, process the form.. THEN set the session variable to 0 and carry on. That should work for you. Mike - Original Message - From: "Igor Ilyinsky" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 23, 2003 2:24 PM Subject: RE: CFMX Form Submission Hacking. > I'm not sure how that would work Mike... If I set the session variable, and the user comes back (within the session timeout timeframe) wouldn't the session variable persist? It's not like the session is tied to the page itself. > > -Igor > > -Original Message- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 12:51 PM > To: CF-Talk > Subject: Re: CFMX Form Submission Hacking. > > > Why not just set some kind of variable on the form page itself, such as > session.isOnMyServer > and then on the processing page, check for the existence of that variable... > > Would that not work for you? > > Mike > > > - Original Message - > From: "Igor Ilyinsky" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, June 23, 2003 1:40 PM > Subject: RE: CFMX Form Submission Hacking. > > > > I realize this... It will not completely prevent hacking... > > but I would like to make sure that if a person is on my form page, they > are not able to save the page, edit some of the hidden form variables, and > then submit the page to my server. I am aware that the referrer can be > simulated, but that is a deeper degree of the issue I am trying to solve. > > > > -Igor > > > > -Original Message- > > From: Dave Watts [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 23, 2003 11:41 AM > > To: CF-Talk > > Subject: RE: CFMX Form Submission Hacking. > > > > > > > Does anyone have a quick snippet of code that does a regex > > > match against the referrer to check if a form was submitted > > > from an internal page (with attention to ports if possible). > > > Too lazy to write it myself, so hoping someone does this to > > > prevent hacking of form submissions. > > > > That wouldn't prevent "hacking of form submissions", as the referer is > > provided by the browser, not the server. Also, I'm not sure what you mean > by > > "attention to ports". > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > voice: (202) 797-5496 > > fax: (202) 797-5444 > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hardware Disable Right-Click
How about take apart the mouse and break the switch under the right button? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:18 PM To: CF-Talk Subject: OT: Hardware Disable Right-Click Sorry for the OT, but I was wondering if it's possible to hardware disable right-click on the mouse. I'm about to set up some kiosks with a mouse and I don't want them to be able to right-click. I know how to do this in javascript, I just think there's got to be an easier way that to put that script into every webpage I've got. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: livedocs.macromedia.com is down...
Worked fine for me. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:32 PM To: CF-Talk Subject: RE: livedocs.macromedia.com is down... More specifically... http://livedocs.macromedia.com/cfmxdocs/dochome.jsp -Original Message- From: Stacy Young Sent: Friday, June 27, 2003 2:31 PM To: '[EMAIL PROTECTED]' Subject: livedocs.macromedia.com is down... -Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: used to use cfml.exe but MX doesn't have it...
Brian, I asked this question before. Short answer... Can't be done. CFMX is now entirely Java. No more cfml.exe. I'm sure that there is probably some way to make it work, but instead I found another way to do what I wanted. Do you have to do it in a batch file or can you find another way to do it? Also, many people suggested using wget to run it. I believe that they said it was a free program. What is does is pretend to be a web browser and hit the page. Steve -Original Message- From: cf talk [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 4:29 PM To: CF-Talk Subject: used to use cfml.exe but MX doesn't have it... I had a bat file that created an HTML page based off of the running of a CFM page. With MX, it doesn't work anymore. Can anyone look at what I was doing and give me some direction? Bat file: REM *** set variable to contain URL variables set QUERY_STRING="PASSEDNAME=a0002" REM *** set variable to call specific CF template set CF_TEMPLATE_PATH=c:\Dir\gmd_hp_jms_critical_path_summ_html.cfm REM *** Run template into a tmp file @for /f "usebackq skip=5 tokens=*" %%i in (`c:\CFusion\BIN\cfml`) do @echo+ %%i>>"c:\Dir\gmd_hp_jms_critical_path_summ.tmp" REM *** Copy from the tmp file into the html file copy "c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.tmp" "c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.html" REM *** Delete the tmp file if it is there if exist "c:\Dir\gmd_hp_jms_critical_path_summ.tmp" del "c:\Dir\gmd_hp_jms_critical_path_summ.tmp" Thanks, Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9668 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Little OT: SQL Query Date Filter
Sounds like you are using SQL Server. This is expected behavior because 6/30/2003 01:01:01.01 is greater than 6/3/2003 00:00:00.03 (think that's right). The second one is what you are creating. I believe that what you really want is : Select * from transactions where bDate >= #variables.EDate# and bDate < #Variables.CDate# but set EDate = today not yesterday. Steve -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 11:56 AM To: CF-Talk Subject: Little OT: SQL Query Date Filter I have been testing this and cannot envision a solution. SQL Server 2000 and CF5. I have a small table that records transactions. The date for each transaction is recorded in createodbcdatetime format. Transactions can occur throughout the day. I am creating a page that shows the days transactions. The user enters a date in mm/dd/ format to query the db. Trouble in that witht he query below when I enter 07/01/2003 I get transactions from 06/30/2003 as well. (this is what the user enters as the desired date for the report) (yesterday's date) (tomorrows date) SELECT * FROM Transactions WHERE bDate > #variables.EDate# AND bDate < #variables.TDate# Thank you in advance for your brainpower - is my method off somehow? Tony Gruen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: export to .xls tag?
One caveat to this... If you use CSS to format and the users have Office 97 it won't display properly. The office 97 programs use an older html (3.2 I think, but don't hold me to it). Steve -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:51 PM To: CF-Talk Subject: RE: export to .xls tag? Thank you very much. That does work great. Chris -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:02 AM To: CF-Talk Subject: RE: export to .xls tag? You can create an HTML table and save the file as an .xls file and it will create an Excel document with data in cells just as in your HTML table. It supports colors, styles, etc. as well if you need formatting. I use this all the time, works great. This also works with Word although the results are somewhat less attractive than they are in Excel if you use tables. If you use CSS for formatting your document it will save beautifully as Word and/or RTF. Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-0801 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:16 AM To: CF-Talk Subject: export to .xls tag? Does anyone know of a tag or technique that would export to a .xls from within a cfoutput. Everything I see exports using a sql query. I need to perform a few tests and calculations on my query to format it properly. Thanks cc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL DATE CONVERSION QUESTION
Without seeing the actual data being converted, my guess would be that substring 11 is the problem. IE: 06/30/2003 = 10 characters not 11. Also, could your data not prepend 0 to months and days? Such as 6/5/2003 or maybe even 6/5/03? Without knowing more about the data being processed, that is about all that I can tell you. Steve -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:06 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION No SQL Gurus out there? -Original Message- From: Eric Creese Sent: Tuesday, July 01, 2003 7:49 AM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Can anyone see what I am doing wrong? If I use the convert statement in the select clause instead of the where clause it works but I need to convert from the where clause against my criteria. -Original Message- From: Eric Creese Sent: Monday, June 30, 2003 5:24 PM To: CF-Talk Subject: SQL DATE CONVERSION QUESTION I am trying to query on a field that is a varchar(255) but has date information. I get the following error: Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. My query: select personid from persondemographic where convert(datetime,substring(demographicvaluedesc,1,11),101)> '06/30/2003' and demographicgroupid =4 and demographicitemid = 4 and demographicvaluedesc is not null ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL DATE CONVERSION QUESTION
Ok, I need a sanity check! Isn't 06/30/2003 only 10 characters? Just wondering because after my initial post I see a lot of replies with the 11 back in there? Steve -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 3:06 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Oh, ok, you've got an error meaning that some of the data that you are converting actually is not date information. Maybe you could do this: Where ... And isdate(substring(demographicvaluedesc,1,11)) is true Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:57 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Yes I tried this, same error. -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 1:46 PM To: CF-Talk Subject: Re: SQL DATE CONVERSION QUESTION Have you tried using Cast instead of Convert, ie My query: select personid from persondemographic where cast(substring(demographicvaluedesc,1,11) as datetime) > '06/30/2003' and demographicgroupid =4 and demographicitemid = 4 and demographicvaluedesc is not null Marlon Eric Creese wrote: >No SQL Gurus out there? > >-Original Message- >From: Eric Creese >Sent: Tuesday, July 01, 2003 7:49 AM >To: CF-Talk >Subject: RE: SQL DATE CONVERSION QUESTION > > >Can anyone see what I am doing wrong? If I use the convert statement in the select clause instead of the where clause it works but I need to convert from the where clause against my criteria. > >-Original Message- >From: Eric Creese >Sent: Monday, June 30, 2003 5:24 PM >To: CF-Talk >Subject: SQL DATE CONVERSION QUESTION > > >I am trying to query on a field that is a varchar(255) but has date information. > >I get the following error: >Server: Msg 241, Level 16, State 1, Line 1 >Syntax error converting datetime from character string. > >My query: >select personid >from persondemographic >where convert(datetime,substring(demographicvaluedesc,1,11),101)> '06/30/2003' >and demographicgroupid =4 >and demographicitemid = 4 >and demographicvaluedesc is not null > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL DATE CONVERSION QUESTION
Ok, That changes things. Are you sure that one of your rows doesn't have improper data? I used to have a database that used strings instead of a datetime and I always had the problem of people putting in things like INC or NR or other stuff where the date needed to go. Steve -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:59 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION the date string in the 255 varchar field is stored as Jul 01 2003 12:00 AM now if I put the " convert(datetime,substring(demographicvaluedesc,1,11),101" in the select clause it will return the data correctly, how ever I need this logic in the where clause. -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 1:38 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Without seeing the actual data being converted, my guess would be that substring 11 is the problem. IE: 06/30/2003 = 10 characters not 11. Also, could your data not prepend 0 to months and days? Such as 6/5/2003 or maybe even 6/5/03? Without knowing more about the data being processed, that is about all that I can tell you. Steve -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:06 PM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION No SQL Gurus out there? -Original Message- From: Eric Creese Sent: Tuesday, July 01, 2003 7:49 AM To: CF-Talk Subject: RE: SQL DATE CONVERSION QUESTION Can anyone see what I am doing wrong? If I use the convert statement in the select clause instead of the where clause it works but I need to convert from the where clause against my criteria. -Original Message- From: Eric Creese Sent: Monday, June 30, 2003 5:24 PM To: CF-Talk Subject: SQL DATE CONVERSION QUESTION I am trying to query on a field that is a varchar(255) but has date information. I get the following error: Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. My query: select personid from persondemographic where convert(datetime,substring(demographicvaluedesc,1,11),101)> '06/30/2003' and demographicgroupid =4 and demographicitemid = 4 and demographicvaluedesc is not null ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT: Correct way to match a record with a list in one field?
Sorry to chime in late. I'm not sure what database you are using, but if it is MS SQL 2000, I released a group of list related functions to anyone on the list who wanted them. Using them you could do: SELECT EmailAddr, RecipientID FROM SupportEmailRecipient WHERE SubjectID IN (SELECT VALUES FROM dbo.listToTable('#FORM.SubjectID#')) If you want the functions, let me know. Steve -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 6:20 AM To: CF-Talk Subject: RE: SOT: Correct way to match a record with a list in one field? > Well, the only problem is that won't match the first and last > elements in that field, nor if it is the element in that > field, so you really need: > > SELECT EmailAddr, RecipientID > FROMSupportEmailRecipient > > WHERE > (SubjectID LIKE '%#FORM.SubjectID#,%' > OR > SubjectID LIKE '%,#FORM.SubjectID#,%' > OR > SubjectID LIKE '%,#FORM.SubjectID#%' > OR > SubjectID = '%#FORM.SubjectID#%') > > > Or did I miss something obvious? Actually, this is slightly better; SELECT EmailAddr, RecipientID FROM SupportEmailRecipient WHERE ','+SubjectID+',' LIKE '%,#FORM.SubjectID#,%' I'm using + as I'm used to SQL Server, but for Access you'd use & ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT: Correct way to match a record with a list in one field?
Yes and No. First, I misunderstood, I thought that the list was being passed, not already in the table. The dbo.listToTable function is one that I created. It returns a 2 column table with the following columns: Position, Value So the corrected version (now that I'm learning to read) should be: SELECT EmailAddr, RecipientID FROM SupportEmailRecipient WHERE '#Form.SubjectID#' in (SELECT VALUE FROM dbo.listToTable(SubjectID)) Steve -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 8:02 AM To: CF-Talk Subject: RE: SOT: Correct way to match a record with a list in one field? > SELECT EmailAddr, RecipientID > FROM SupportEmailRecipient > WHERE SubjectID IN (SELECT VALUES > FROM > dbo.listToTable('#FORM.SubjectID#')) > > If you want the functions, let me know. Shouldn't that be WHERE #form.SubjectID# IN (dbo.listToTable(SubjectID)) As there's one entry in form.SubjectID and SubjectID in the table is a comma separated list ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Changing query value
Try: Even though you are only returning 1 row you still need to tell CF that it is row 1. Steve -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 1:06 PM To: CF-Talk Subject: Changing query value I'm using CF5 and trying to change a value that was pulled from a query. My code looks like this: SELECT MAX(sortOrder) AS sortOrder FROMGallery When I try to set getMaxOrder.sortOrder I get an error that says: Cannot convert to number. Please, check the ColdFusion manual for the allowed conversions between data types Any idea why I'm getting this error? Works like a champ on CFMX, but not on CF5. Any ideas? Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL quickie
Try: declare @myCurrDate datetime declare @myEOM datetime set @myCurrDate = getdate() set @myEOM = dateadd(d, -(day(dateadd(m, 1, @myCurrDate) + 1)), dateadd(m, 1, @myCurrDate)) Steve -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 8:22 AM To: CF-Talk Subject: SQL quickie I want to be able to take a value of getdate() and then from that determine the last day of the month that getdate() is in. I will be doing this in a stored procedure. For instance, today is 7/7/2003 I want to output 7/31/2003 to the next part of the procedure. Eric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unusual SQL error
Bill, This just got me thinking about a problem I had a while back. I had a sql7 query like this: select * from myTable where isDate(myDateField) = 1 and month(myDateField) > 2 Everything worked fine until I moved to SQL 2000. Then it would return an error because myDateField could not be converted to datetime. The myDateField column can have a date, "NR", "INC". (Not my choice, doing this was dictated to us by another group in our company). The explanation I got from another DBA said that SQL server 7 processed each item of the where sequentially, but SQL 2000 processes all of the where items at the same time. If that is true, do you think that setting the maxdop 1 would prevent the error? No rush for an answer, we already changed all of our code, this is more just for my own piece of mind. Steve -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 10:36 AM To: CF-Talk Subject: RE: Unusual SQL error That should fix it. __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 10:34 AM > To: CF-Talk > Subject: RE: Unusual SQL error > > > Thanks, > > I added the option (maxdop 1) to the end of the query to set > the max degree of parallism to 1 > > -Original Message- > From: Bill Grover [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 9:30 AM > To: CF-Talk > Subject: RE: Unusual SQL error > > > Sounds to me like when SQL created it's execution plan it is > running several parts of the query simultaneously. For some > reason when this happens it causes a conflict within your > query. What SQL is asking you to do is give it a hint about > how to process the query to avoid this problem. > > __ > > Bill Grover > Supervisor MIS Phone: 301.424.3300 x3324 > EU Services, Inc. FAX:301.424.3696 > 649 North Horners Lane E-Mail: [EMAIL PROTECTED] > Rockville, MD 20850-1299WWW:http://www.euservices.com > __ > > > > > -Original Message- > > From: Creese, Eric [mailto:[EMAIL PROTECTED] > > Sent: Friday, July 04, 2003 1:17 PM > > To: CF-Talk > > Subject: Unusual SQL error > > > > > > I never have received this error before. > > > > [Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query > > parallelism caused > > your server command (process ID #52) to deadlock. Rerun the > > query without > > intra-query parallelism by using the query hint option (maxdop 1). > > Can anyone give some insite? > > > > > > -- > > > > This e-mail is intended for the use of the addressee(s) only > > and may contain > > privileged, confidential, or proprietary information that is > > exempt from > > disclosure under law. If you have received this message in > > error, please > > inform us promptly by reply e-mail, then delete the e-mail > > and destroy any > > printed copy. Thank you. > > == > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL and Dates
Well, if this is MS SQL, then it should be: WHERE date BETWEEN #createodbcdate(Now())# AND dateadd(d, 6, #createodbcdate(Now())#) or WHERE date BETWEEN #createodbcdate(Now())# AND #dateadd("d", 6, createodbcdate(Now()))# The first one does the add in SQL, the second does the add in CF. The second should work even if it isn't MSSQL. Steve -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 8:17 AM To: CF-Talk Subject: SOT: SQL and Dates What is the proper SQL statement for something like... WHERE Date BETWEEN #createodbcdate(Now())# AND (#createodbcdate(Now())# + 6) I know that's not right (because it doesn't work). Any ideas? Just trying to pull today's date and the rest of this week's dates. Cutter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Array Sum
Ben, First, you should be creating the array outside of the loop. Next, you are always displaying the sum of the current position of the array not a sum of the whole array. I think that this should work better. clicks_per_product.click[i])> #arraySum(prodLinkTotal)# Steve -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 11:51 AM To: CF-Talk Subject: Array Sum Can someone tell me why this won't work correctly. I have the following code #ArraySum(prodLinkTotal[i])# Rightnow the clickcount is at 4 so if I output just prodLinkTotal[i] I get the total number of clicks for each product(303 289 95 89). I now need to add these up and thought ArraySum() would do it but I keep getting this error: Object of type class java.lang.Integer cannot be used as an array Is there a better way to accomplish this? Thanks, Ben _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REPOST: Creating "treeview" structure using
Bushy, I don't think what you are asking is possible. Unless in your cfftp you loop through and get the directories and subdirectories first and then display them in the tree form. Could you post your cfdirectory code and I will see if I can come up with something. Steve -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:31 AM To: CF-Talk Subject: REPOST: Creating "treeview" structure using IS REPLYING??? Hi, Is it possible to create a "treeview" structure using following and by clicking on the directory will drilldown? + dir1 + dir2 + dir3 + dir4 Click on "dir2" + dir2 + subdir1 + subdir2 file1 file1 file1 I've done something similar using how to achive this using Pleasesomeone help George Bush! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFTP list directory problem with space.
Hi all, I'm trying to do a name="myListDir" directory='/usr/"I have spaces"'> And it always fails. When I use the win2k command line I can change into the directory with cd /usr/"I have spaces", so why won't the list work? Anyone have any insights? Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Last Space.
Ian, This code uses more than one line, but it does work. #useList# Steve -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 1:03 PM To: CF-Talk Subject: The Last Space. Anybody know a trick (regex or otherwise) to find the position of the last white space character before an arbitrary limit? In the following example, I want the position of the last white space before the 25th character. "The quick brown fox jumped over a lazy dog." So I would want the position of the white space after 'fox', which is the 20th character. This is the last white space before the 25th character with is the 'e' in 'jumped'. Allowing me to break the string into: "The quick brown fox " "jumped over a lazy dog." I don't think this should be that hard, but for some reason, it has given me lots of trouble. Thanks -- 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: The Last Space.
Ian, See if this does the trick for you. It returns an array. maxLength)> Steve -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 1:32 PM To: CF-Talk Subject: RE: The Last Space. I hadn't thought of this approach, I see merit here, I'll look into it. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 10:13 AM To: CF-Talk Subject: RE: The Last Space. I'm sure there's more than one way to solve this particular issue, my thought would be to turn the string into a list using the space as a delimiter, then add the length of the list element plus one (for the space) until you reach or break your cutoff level. Not very pretty but it'd get the job done. Hatton -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 1:03 PM To: CF-Talk Subject: The Last Space. Anybody know a trick (regex or otherwise) to find the position of the last white space character before an arbitrary limit? In the following example, I want the position of the last white space before the 25th character. "The quick brown fox jumped over a lazy dog." So I would want the position of the white space after 'fox', which is the 20th character. This is the last white space before the 25th character with is the 'e' in 'jumped'. Allowing me to break the string into: "The quick brown fox " "jumped over a lazy dog." I don't think this should be that hard, but for some reason, it has given me lots of trouble. Thanks -- 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. _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm?link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm?link=i:4:145544"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm?link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=2581.2460.4" Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] _ HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=17" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The Last Space.
Ian, Did you try the function I sent? Well if you did, there was an error in it. Here it is (corrected) in cfscript form in case you are not on MX. function seperateToArray(myString, maxLength) { var myArray = arrayNew(1); var spcPos = 0; var myTmpStr = ""; var myTmpAry = false; if(len(myString) GT maxLength) { if(right(left(myString, maxLength), 1) NEQ " ") spcPos = maxLength - len(listLast(left(myString, maxLength), " ")); else spcPos = maxLength; myTmpStr = left(myString, spcPos); myArray = seperateToArray(right(myString, len(myString) - spcPos), maxLength); } else { myTmpStr = myString; } myTmpAry = arrayPrepend(myArray, myTmpStr); return myArray; } Steve -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 2:38 PM To: CF-Talk Subject: RE: The Last Space. Yes, that is very close to what I'm looking for. In fact, it is close enough that I could probably live with it, if I had too. But as you know, we programmer types can spend too much time trying for perfection. The only problem (that, again, I could probably live with) is if there where a pipe "|" character in the string being processed. This would result in an extra record, since the list functions would read one list element as two. In and of itself, not really that big deal. But, there are users who view this data I'm inserting in an old fashioned VT102 applications. They see each record on one line, so the broken up line may look incorrect to them. Now, my gut feeling is that there is probably less then a one percent chance that the type of users who would be entering the string would use a pipe, so this my not be worth exploring. But it would be nice, if this could be put into an array or structure. This is what I have come up with, but I would love to know if this could be simplified. start = 1; LFsubStr = "now is the time for all good men to come to the aid of their country."; while (start LT len(LFsubStr)) { // yes, 2 ofs to make the space the 15th sLastSpace = REFind('.{' & start & ',' & start+13 & '}(\s)', LFsubStr, 1, 1); if (arraylen(sLastSpace.Pos) EQ 2) { subString = mid(LFsubStr,start,sLastSpace.Pos[2]-start); start = sLastSpace.Pos[2]; } else { substring = right(LFsubStr,len(LFsubStr)-start); start = len(LFsubStr); } subStringAry[element] = subString; element = element + 1; } Thanks. -- 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: value "" cannot convert to number
Sam, This usually happens when you are trying to add a number to a variable that isn't set. Your options seem to be: 1) first if this is actually adding numbers or 2) if you are concatinating the strings. Steve -Original Message- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 3:32 PM To: CF-Talk Subject: value "" cannot convert to number Hi Everyone, Can someone tell be why I get a string convert error. I have tried setting up ID to Val(ID) and even IncrementValue(Val(ID)), but all it ever returns is either 0 or 1, respectively. Apparently ID is not getting converted. "I feel like I'm taking crazy pills!" What is wrong with converting a string to a number, especially when the string is just a concatenation of numbers? Many thanks, Sam The value "" cannot be converted to a number 155 : #ID# 156 : _ [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. select count(identityField) as overlap from yourTable where shiftType = value="#formType#"> and ((startDate >= value="#formStartDate#"> and startDate <= value="#formEndDate#">) or (endDate >= value="#formStartDate#"> and endDate <= value="#formEndDate#">) 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 [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
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 [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: 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 < value="#formEndDate#"> AND endDateField > 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 know how it is used. Instead of SELECT x FROM yourtable WHERE startDateField < '#formEndDate#' AND endDateField > #formStartDate#' one would use: SELECT x 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: Date Range Query Issues
Jochem, Running your code on MSSql2K returns: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ';'. Removing the begin; then returns: Server: Msg 2715, Level 16, State 7, Line 1 Column or parameter #1: Cannot find data type DATE. MSSql2K doesn't have the date type, only smalldatetime and datetime both of which include a time in the data stored. I modified the code to run: BEGIN declare @yourTable table( EntryNo int, startDateField datetime, endDateField datetime ) insert into @yourTable(entryNo, startDateField, endDateField) values(1, '11-25-2003', '12-15-2003') insert into @yourTable(entryNo, startDateField, endDateField) values(2, '12-31-2003', '01-15-2004') insert into @yourTable(entryNo, startDateField, endDateField) values(3, '11-25-2003', '12-01-2003') insert into @yourTable(entryNo, startDateField, endDateField) values(4, '1-25-2004', '2-15-2004') insert into @yourTable(entryNo, startDateField, endDateField) values(5, '12-25-2003', '12-30-2003') select * from @yourTable where startDateField < '12-31-2003' and endDateField > '12-01-2003' delete from @yourTable end This worked but missed entries 2 and 3, mine picked them up immediately. Granted just adding = to the > and < in yours would fix this. I will say this though, for Candace's problem your solution with the added = is probably better. When I wrote what I sent out earlier, a co-worker had called me with a similar problem BUT he needed to see overlaps where someone screwed up and had the endDateField before the startDateField. (He was working on a database that someone else had screwed up!) I tried solving both problems at the same time instead of trying to find the best solution for each. So, I stand humbled at your streamlining expertise. Steve -Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 4:22 PM To: CF-Talk Subject: Re: Date Range Query Issues DURETTE, STEVEN J (AIT) wrote: > > The problem with your change is that it won't pick up partial overlays. Just run it. We actually need to test it twice, proving that the negator is the same as the operator is too much work for now: BEGIN; CREATE TABLE yourTable ( startDateField DATE, endDateField DATE); INSERT INTO yourTable VALUES ('2003-11-25', '2003-12-15'); SELECT * FROM yourtable WHERE startDateField < '2003-12-31' AND endDateField > '2003-12-01'; TRUNCATE TABLE yourTable; INSERT INTO yourTable VALUES ('2003-12-01', '2003-12-31'); SELECT * FROM yourtable WHERE startDateField < '2003-12-15' AND endDateField > '2003-11-25'; DROP TABLE yourTable; COMMIT; > 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')) Just run it. One test is enough here :-) BEGIN; CREATE TABLE yourTable ( startDateField TIMESTAMP, endDateField TIMESTAMP); INSERT INTO yourTable VALUES ('2003-11-25 00:00:00', '2004-12-15 23:59:59'); SELECT * FROM yourtable WHERE ((startDateField between '2003-12-01 00:00:00' and '2003-12-31 23:59:59') OR (endDateField between '2003-12-01 00:00:00' and '2003-12-31 23:59:59')); SELECT * FROM yourtable ROLLBACK; > 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") Just test it :-) > If this doesn't work for you, let me know because it works for me. It doesn't work for me. Please run the above queryies through a command line tool and show us the output. 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
To answer your first question, ok, my brain isn't working properly yet. I was including them because I was just automatically thinking that the shift would end at the end of the day not the beginning and therefore if someone chose that day to start there would be an overlap. Using times in the test would have worked with the > and <. I stand corrected again. As for the second question. I really need to get over the flu before I hit reply. You are right. I completely forgot to deal with date ranges that are larger than my select range. Now I am going to go take some Dayquil and admit defeat. Steve -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:08 AM To: CF-Talk Subject: Re: Date Range Query Issues DURETTE, STEVEN J (AIT) wrote: > > BEGIN > > declare @yourTable table( > EntryNo int, > startDateField datetime, > endDateField datetime > ) > > insert into @yourTable(entryNo, startDateField, endDateField) values(1, '11-25-2003', '12-15-2003') > insert into @yourTable(entryNo, startDateField, endDateField) values(2, '12-31-2003', '01-15-2004') > insert into @yourTable(entryNo, startDateField, endDateField) values(3, '11-25-2003', '12-01-2003') > insert into @yourTable(entryNo, startDateField, endDateField) values(4, '1-25-2004', '2-15-2004') > insert into @yourTable(entryNo, startDateField, endDateField) values(5, '12-25-2003', '12-30-2003') > > select * > from @yourTable > where startDateField < '12-31-2003' > and endDateField > '12-01-2003' > > delete from @yourTable > > end > > This worked but missed entries 2 and 3, mine picked them up immediately. It is supposed to miss them. If a persons shift ends at X, why shouldn't the next shift of that person be allowed to start at X either? > I will say this though, for Candace's problem your solution with the added = > is probably better. Even without the added =. Your solution still does not find any that completely envelope other ranges. PostgreSQL shows: jochemd=> BEGIN; jochemd=> CREATE TABLE yourTable ( jochemd(> startDateField TIMESTAMP, jochemd(> endDateField TIMESTAMP); jochemd=> INSERT INTO yourTable jochemd-> VALUES ('2003-11-25 00:00:00', '2004-12-15 23:59:59'); jochemd=> jochemd=> jochemd=> SELECT * jochemd-> FROM yourtable jochemd-> WHERE ((startDateField between '2003-12-01 00:00:00' and '2003-12-31 23:59:59') jochemd(> OR jochemd(> (endDateField between '2003-12-01 00:00:00' and '2003-12-31 23:59:59')); startdatefield | enddatefield +-- (0 rows) jochemd=> jochemd=> ROLLBACK; Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Programatically setting the timeout limit.
So, just to make sure that I get this straight... http://mytestserver.com/longRunningPage.cfm?requestTimeout=5000 will not work, but putting at the top of longRunningPage.cfm will work? Then why didn't the CFML Code Analyzer notify that this could be a problem when we upgraded? We have a lot of links in a Hrefs like that and never got one notice. This does explain why our long running pages are erroring out though. Thanks, Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 7:31 AM To: CF-Talk Subject: Re: Programatically setting the timeout limit. Requesttimeout was depreciated in CFMX and will not work at all. Using the will work. Using this is even better: This will either use the default 60 seconds in the CFPARAM OR use the requesttimeout set on the URL. As for createtimespan(), all it does is return a number that represents the fraction of a day. There's an article on the front of HoF about insane optimization with this and how the function is never really needed. > Aha ! > > I've added this as you suggested. > > Doesn't seem to make any difference, I still get a "The request has > exceeded the allowable timelimit tag: cfquery" message. > > If I set this up in the calling page, do I still need the timeout attribute > in the queries ? > > > -Original Message- > From: John Beynon [mailto:[EMAIL PROTECTED] > Sent: 04 December 2003 10:36 > To: CF-Talk > Subject: RE: Programatically setting the timeout limit. > > > You can use requestimeout= in the URL from the calling page > > Jb. > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 04 December 2003 10:36 > To: CF-Talk > Subject: Programatically setting the timeout limit. > > Hello all, > > I have a sequence of queries running, each of these are quite large but, at > preset do not time out. > However, when I loop over the first query, then run the second and loop > over that for the third I get one of two error messages: > either a "The request has exceeded the allowable timelimit tag: cfquery" or > The request has exceeded the allowable timelimit tag: cfloop". > > I've tried adding :timeout="#CreateTimeSpan(0,0,10,0)#" to the queries > concerned but to no avail. > How do I either programatically alter the administrator settings or even > better set the time out for a cfloop ? > Does anyone have any ideas? > Usually I wouldn't be happy using such large queries but this is for an > internal app that can be run in the background. So timescale is not an > issue. > Cheers, > > Darren > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Another CFML app server...
Jochem, What is the proper signature delimiter? Steve -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 8:12 AM To: CF-Talk Subject: Re: Another CFML app server... Tangorre, Michael wrote: > Interesting considering some people have 22 line signatures. :-) Atleast they use a proper signature delimiter so the signature isn't quoted in the reply :-) Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
How can you overwrite a query that you are in the process of creating? Wouldn't the cfquery tag overwrite an existing query before it got to the actual sql? In which case, wouldn't if have problems reading data from a query that is in "flux"? Don't know why, but building a query like this just seems to look like an infinite loop to me because even if it did work, it would always be selecting data from it's self. Just my .02 Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:34 AM To: CF-Talk Subject: RE: I Hate QoQ I'm not sure it is the problem, wouldn't it just overwrite the query? Ade -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 13:41 To: CF-Talk Subject: RE: I Hate QoQ How can you QofQ a query of the same name as the one you are executing? <--- Name of Query SELECT isPublic FROM involved <--- Name of query you are taking from. Change one, I'll bet your problem goes away. _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? SELECT isPublic FROM involved WHERE isPublic = 1 isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: SELECT isPublic FROM involved WHERE isPublic = '1' Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
Thanks, helps getting my head around how it works. Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:47 AM To: CF-Talk Subject: RE: I Hate QoQ Try it for yourself, it does overwrite it. The assignment must happen as the final process. You're assuming an empty query is created and assigned to the query name, then the query is populated, I doubt this is the case. It's more likely to be that the query is returned in full then assigned to a reference. Ade -Original Message----- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 15:34 To: CF-Talk Subject: RE: I Hate QoQ How can you overwrite a query that you are in the process of creating? Wouldn't the cfquery tag overwrite an existing query before it got to the actual sql? In which case, wouldn't if have problems reading data from a query that is in "flux"? Don't know why, but building a query like this just seems to look like an infinite loop to me because even if it did work, it would always be selecting data from it's self. Just my .02 Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:34 AM To: CF-Talk Subject: RE: I Hate QoQ I'm not sure it is the problem, wouldn't it just overwrite the query? Ade -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 13:41 To: CF-Talk Subject: RE: I Hate QoQ How can you QofQ a query of the same name as the one you are executing? <--- Name of Query SELECT isPublic FROM involved <--- Name of query you are taking from. Change one, I'll bet your problem goes away. _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? SELECT isPublic FROM involved WHERE isPublic = 1 isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runtime error. Unsupported Date type conversion in Query of Queries. I've tried the follow too in case some reason it converted to string, but alas same error: SELECT isPublic FROM involved WHERE isPublic = '1' Any ideas? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division _ _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Another simple question...
Che, What about encrypt(id, someKey) and decrypt(id, someKey) CF Functions. Just as an example someKey = 1234567890. Steve -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 3:56 PM To: CF-Talk Subject: Another simple question... This is for a CF5 webserver. I have the following URL. http://somesite.com/cnt_ask_an_expert_detail.cfm?id=114 Basically, I would like to have some simple encryption on the URL.ID variable. Nothing fancy...just something that the average website user would not try to manipulate. The solution should be the LEAST taxing to the CFAS. Also, this solution should obviously be decryptable. Maybe there is a CF function that I have forgotton or unaware of... Thanks, Che _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: More date stuff!
Candace, I think that Jochem is using postgresql so, timestamp in postgre = datetime in MSSql2K. As for the UI, why don't you give them a calendar on one page with check boxes and have that submit to a second page that shows an entry for start time and end time of each range (consider a single day by itself as a range of it's own)? Steve -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 4:01 PM To: CF-Talk Subject: Re: More date stuff! Responses inline... 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/9/2003 3:40:17 PM >>> Candace Cottrell wrote: > I am building an on-call scheduling app for doctors. In the database, > the dates are broken up like Start_Day, Start_Month, Start_Year, > Start_Time, Start_AMPM and the same for the End info. I would highly recommend combining these fields together in one timestamp field. You could even do so without touching anything in the UI by just adding a Start_Timestamp field and recombining the timestamp in a trigger on the fly. -- What is the advantage of using a timestamp vs. a datetime in this scenario? I am also thinking I should do an insert for every day as opposed to the range. Do you see an advantage in doing this? In addition, I am a bit worried about the secretaries who have to enter so many records in the following scenario: Dr. A 12/12 7am - 12/14 7am Dr. B 12/14 7am - 12/15 7am Dr. A 12/15 7am - 12/17 7am .instead of being able to pick dates from a calendar popup or something. I watched one of them do it and it was time consuming. At the same time, I am afraid to take out the range feature, becuase in some cases one doctor is on-call for 2 months. So it's much easier for them to type 12/1/2003 and 2/3/2003 instead of picking 60 days. -- > 1) So there is a bit of overlapping in some cases, where Dr. A may be > on call from 12/12/2003 - 12/14/2003 at 7am > And Dr. B may be on call from 12/14/2003 at 7am until 12/20/2003 at > 4pm. Does this really overlap? --- I guess for an hour it does... --- > So if Dr. A ENDS her shift at 7am on 12/12 and Dr. B BEGINS his shift > at 7am on 12/12, it's taking Dr.A and extending her to 12/13. So do you want both Dr. A and Dr. B to show on 12/12? Or just Dr. B? --- Actually, they should both be listed. Something like: Dr. A. End: 7am Dr. B Start:7am > 2) I only want the start time to show up if it's the first day in the > shift and I only want the end time to show if it's the LAST day in the > shift. How can I get at this info if I am using a range? I think you need to self-join so you can get start and end timestamps in one field. The and use a case statement to determine if a schedule event is a start or an end and sort on that field. If that doesn't make sense, please provide the full table schema's. - The only way I can see to do this is to have a separate record for each day. Here's what the OnCall_Schedule table looks like: http://www.childrensdayton.org/images/oncallSchema.gif - THANKS DEAR!!! Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Double Quotes in a String
Ian, Change your input to: notice the single quotes for value. Steve -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 11:26 AM To: CF-Talk Subject: Double Quotes in a String How can one output a string that contains double quotes as a input value? For Example: string = 'I just read "ABC Journal", it was great.' This will just display 'I just read ' in the input box, stopping at the first double quote. -- 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: Clip at the last "space" character/Display "More..."
Couldn't you also do a 254), " "), " ")> ? Steve -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 2:18 PM To: CF-Talk Subject: Re: Clip at the last "space" character/Display "More..." string=trim(rereplaceNoCase(left(string,254),"(.*)[[:space:]]+.*$","\1"))> Jerry Johnson >>> [EMAIL PROTECTED] 12/22/03 02:05PM >>> Okay, I know this is an easy one, and I've actually *done* it before, I just can't remember where, or how... On output, I've got a field that I want to clip at the LAST space character before 254 characters are displayed. If it's a memo/text field, and it contains 500 characters, I only want to display UP TO the very last "space" character before the 254 is reached. The field that currently clips a "and a wonderf" would clip at "and a" then I'd put "more..." following that. I'm guessing this is so easy, I'm going to slap myself. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF / JavaScript question
Steve, Why don't you do one select that joins the tables. Then you can use the multiselects related with cf and _javascript_ tutorial I wrote. The tutorial can be found at http://tutorial196.easycfm.com It deals with 3 related selects, but should be easily converted to two selects. Steve -Original Message- From: Steve Logan [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 2:49 PM To: CF-Talk Subject: CF / _javascript_ question I was looking around for a code example of this and haven't been able to find one - it's definitely something that's been on my list of "must learn" - now it's a need to learn item. I have 2 tables in my db - one is partcategory and one is partsubcatetory. I have a CF snippet set to create a form select pulldown off of the first table, but what I want to have happen is when they make a selection from the first pull down (onChange) run a 2nd query to populate the subcategory with the appropriate items. The part category pulldown select code is this: select * from partcategory " & "--Make A Selection--"> value="#selPartCat.pc_id#"'> selected"> " & #selPartCat.pc_category#> "> PartCategorySelect> #PartCategorySelect# This gives me a nice pulldown with the correct values and selection names. Now I'm stuck on the _javascript_ to get the 2nd query / pulldown to be created. Thanks. Steve _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFContent Excel design woes
Hatton, Excel 97 doesn't support css. You have to use font tags, table borders, etc. I believe (though I'm not positive) that all of the Office 97 products only support HTML 3 and earlier, but you will want to check Microsoft's website to verify this. Steve -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: SOT: CFContent Excel design woes Okay, this is only slightly off topic but I don't know where else to look for answers. I built a spreadsheet export that uses CFContent to create an Excel spreadsheet. I'm using CSS in that file to border some of the cells to create a cleaner output look to the sheet. We've been testing it on Excel 2000 and everything works perfectly. Today the client looks at it and asks for lines. Turns out they're running Excel 97, and a screenshot confirmed their comment, there are no lines (cell borders) in the file. Anyone hear anything like this before? Any suggestions to correct the issue? Thanks! Hatton --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFGrid, CFForm and other cf tags that use applets
Hi all, Have any of you heard that Macromedia will be dropping CFGrid and other tags that are applet based (cfslider, cfselect, etc. even CFFORM!) in future versions? This was put out by someone in our company telling us that we need to recode all of our pages to remove these. Just wanted to get info about it before I fired back an e-mail to this person. It would be extremely helpful if people from Macromedia chimed in here. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFGrid, CFForm and other cf tags that use applets
Rick, I tend to agree with you about CFForm and CFSelect, but I included them because the person who notified me included them. Steve -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 8:54 AM To: CF-Talk Subject: Re: CFGrid, CFForm and other cf tags that use applets DURETTE, STEVEN J (AIT) wrote: > > Have any of you heard that Macromedia will be dropping CFGrid and other tags > that are applet based (cfslider, cfselect, etc. even CFFORM!) in future > versions? CFFORM and CFSELECT are most certainly *NOT* based on applets, nor could I fathom them ever going away, as long as CFML is alive. I wouldn't be surprised though to see the actual applet-based ones go away like CFSLIDER< CFGRID, CFTREE, etc... - Rick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFContent Excel design woes
Hatton, I guess that my last e-mail on this didn't go through. Office 97 doesn't use style sheets. It uses HTML 3.? There is info about this in Microsoft's tech website, but I can't remember where. Steve -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 9:09 AM To: CF-Talk Subject: RE: CFContent Excel design woes I still have not been able to figure out the source of the difference. Anyone have any ideas why Office 97 wouldn't read a stylesheet file right? Thanks! Hatton _ From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: SOT: CFContent Excel design woes Okay, this is only slightly off topic but I don't know where else to look for answers. I built a spreadsheet export that uses CFContent to create an Excel spreadsheet. I'm using CSS in that file to border some of the cells to create a cleaner output look to the sheet. We've been testing it on Excel 2000 and everything works perfectly. Today the client looks at it and asks for lines. Turns out they're running Excel 97, and a screenshot confirmed their comment, there are no lines (cell borders) in the file. Anyone hear anything like this before? Any suggestions to correct the issue? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Another CFGrid question.
All, Now I am being told that all of our clients are being upgraded to Sun JRE 1.4.2 (we are on an intranet) and all previous version of the JRE (and Microsoft JVM) will be removed. They are saying that cfgrid will no longer work when that happens. Seems ludicrous to me that upgrading the JRE on the client will break the cfgrid tag. Any comments? Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Another CFGrid question.
CFMX and CFMX6.1 We have people that use all the way back to CF4 and I stated the fact to the group that Versions 4.5 and before will probably have a problem (and possibly 5), but they were saying that ALL versions of ColdFusion are affected. Just FYI, while I was typing this, they recanted the bit about CFMX and CFMX6.1! Steve -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 9:56 AM To: CF-Talk Subject: RE: Another CFGrid question. which version of CF are you using? I beleive that JRE 1.4 doesnt correctly post the form information for a CF5 CFGRID... -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Thursday, January 8, 2004 14:54 To: CF-Talk Subject: Another CFGrid question. All, Now I am being told that all of our clients are being upgraded to Sun JRE 1.4.2 (we are on an intranet) and all previous version of the JRE (and Microsoft JVM) will be removed. They are saying that cfgrid will no longer work when that happens. Seems ludicrous to me that upgrading the JRE on the client will break the cfgrid tag. Any comments? Steve _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
XML style closing for custom tags
Hi all, I know that this was covered on the list not to long ago, but I can't seem to find it in the archive. I have a custom tag that only needs to work, but because of reasons beyond my control, I have to make it work with I know that there is a issue with the custom tag running twice if you do this. Someone posted code to add to the tag to prevent this from happening. Can anyone point me in the direction of that code. Thanks. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: XML style closing for custom tags
Thanks to both of you. :) Steve -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 3:53 PM To: CF-Talk Subject: RE: XML style closing for custom tags Whatever, to each their own. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 3:51 PM To: CF-Talk Subject: RE: XML style closing for custom tags > Inside your CT use the following. > > > your logic > Not to be anal, but this code means you have the entire logic of your tag wrapped in a cfif. I'd suggest the alternative of exiting when execution mode is "end". Ok so I am being anal. Sue me. :) _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Rereplace with regular expression not working as I had hoped.
Hi all, Here is a quick one for you. I have a Variable that I am trying to do a rereplace on and it isn't working as I expected. Here is the code: "All")> I was hoping that it would convert: DOGS/CATS TO: DOGS / CATS but it returns: DOG. / .ATS I also tried it with the replacement string being " / " and got: DOG / ATS Can anyone tell me what I need to do to get it to DOGS / CATS Thanks, Steve -- COST SAVINGS SUGGESTION* For pages that must be printed, change your print settings to print in "grayscale" instead of color. Steve Durette Mgr-Eng. & Const. Systems Support (586)466-7654 [OFFICE] 100 S. Main Room 314 Mt. Clemens, MI 48043 [EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Structures native order
This sounds to me like a good case for a combo array/structure. Try this: myQuery.stateNumber> myQuery.stateName> index="Variables.nextIndex"> State Number: #Variables.myStateInfo[Variables.nextIndex].stateNumber# State Name: #Variables.myStateInfo[Variables.nextIndex].stateName# Steve -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 1:17 PM To: CF-Talk Subject: RE: Structures native order > If I loop over a query, which I have retrieved in the order I > want it in, and add the data to a structure, I am finding it > does not stay in that order. A few records from the query: > > 262 Alabama > 211 Alaska > 212 Arizona > 213 Arkansas > 214 California > > When I loop over the collection and display it, it seems to > sort on the numeric id, instead of the order I inserted the > records into the structure. Consequentially, Alabama ends up > last. I do not recall running into this before. In general, I would recommend that you not use structures to contain ordered data. The behavior of structures with regard to ordering has changed several times since they've been introduced to CF. If you want ordered data, use an array. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
What template is running?
Hi all, Due to problems we were having, we started using cfstat. It tells us how many requests are running, but is there a way to tell which templates are currently running? I tried to see if there was something like this in the archives, but I didn't have any luck. Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: isDefined question
Shouldn't it be: Quotes around the client.pods? Steve -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 10:11 PM To: CF-Talk Subject: isDefined question is giving me this error. Element PODS is undefined in CLIENT. The error occurred in D:\www\clients\albert\admin\Application.cfm: line 71 69 : 70 : 71 : 72 : 73 : well...no duh, I know its not defined...thats why im asking, and that's why im setting it. wtf? tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX61 on JRun4, JVM (multiple sort of related questions)
Hi all, I searched through the history, but can't seem to find what I need. I have a few problems that our IT department just forced on us. First, I have to upgrade our production server to MX 6.1. We have been planning on doing this for a while, but could never get our IT department to turn the server over to us for the upgrade. Now they want to turn it over to us today for a few hours and do the upgrade. Here is where the twist comes in... Problem 2 - We are being forced to allow another group to "share" our cf/web server. We used to share with this group before and their code kept bringing down our server, so now we need to go from standard install to multiple instances to protect ourselves. So, I need to know if anyone knows of easy to understand documentation (we are actually doing a couple of servers with similar setups and some of the people doing the install wouldn't be my first choice!) on how to install the initial cf/jrun4 and how to create a secondary instance. Now for problem 3 - We have to upgrade our JVM to our company standard. I know how to do this with CFMX standalone installation, but have no idea how to do it with the JRun install. Is there something I have to do with JRun? I just love it when IT calls at 6am! :( Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX61 on JRun4, JVM (multiple sort of related questions)
Thanks to all of you! I have one more question. Jeremy Brodie mentioned that JRun is a J2EE server, but doesn't it still require a JVM? That is the third part, I have to upgrade the JVM (and provide proof or an explanation why it isn't needed to our IT group). Thanks again. (love the bpurcell link. He makes it look sooo easy.) Steve -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 10:07 AM To: CF-Talk Subject: RE: CFMX61 on JRun4, JVM (multiple sort of related questions) >I searched through the history, but can't seem to find what I need. > >I have a few problems that our IT department just forced on us. > >First, I have to upgrade our production server to MX 6.1. We have been >planning on doing this for a while, but could never get our IT department >to >turn the server over to us for the upgrade. Now they want to turn it over >to us today for a few hours and do the upgrade. Here is where the twist >comes in... > >Problem 2 - We are being forced to allow another group to "share" our >cf/web >server. We used to share with this group before and their code kept >bringing down our server, so now we need to go from standard install to >multiple instances to protect ourselves. So, I need to know if anyone >knows >of easy to understand documentation (we are actually doing a couple of >servers with similar setups and some of the people doing the install >wouldn't be my first choice!) on how to install the initial cf/jrun4 and >how >to create a secondary instance. > >Now for problem 3 - We have to upgrade our JVM to our company standard. I >know how to do this with CFMX standalone installation, but have no idea how >to do it with the JRun install. Is there something I have to do with JRun? > Steven, Just go to this link, and it has the instructions and links to more information regarding the full setup and installation of multiple instances of CFMX. I've done it a hundred times, and it's really easy. http://www.bpurcell.org/ Regards, Dave. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT - StudioMX2004 w/ Flash Std upgrade to StudioMX2004 w/Flash Pr o.
Hi all, I was just wondering. When we bought StudioMX04, it came with Flash Standard and that was the only option. Now I'm looking to upgrade the Flash to Pro and I can't find an upgrade track for this. Does anyone know what track to use? Steve -- COST SAVINGS SUGGESTION* For pages that must be printed, change your print settings to print in "grayscale" instead of color. Steve Durette Mgr-Eng. & Const. Systems Support (586)466-7654 [OFFICE] 100 S. Main Room 314 Mt. Clemens, MI 48043 [EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dates - ranges overlapping months... rut-roh
Candace, This should be : update oncall_shifts set shift_start = cast((start_month + '/' + start_day + '/' + start_year) as datetime) Steve -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:28 PM To: CF-Talk Subject: Re: Dates - ranges overlapping months... rut-roh Hey Jochem, I am using Transact-SQL and converted everything but: UPDATE TABLE table SET shift_start = to_date( start_year || '-' || start_month || '-' || start_day, "-mm-dd"); I tried to do: UPDATE ONCALL_SHIFTS SET shift_start = CAST(start_month&start_day&start_year AS DATETIME) But it is setting the shift_start to 1/1/1900?? Thanks for all your help!! 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] 1/29/2004 11:22:01 AM >>> Candace Cottrell wrote: > > BETWEEN START_DAY AND END_DAY > AND > BETWEEN START_MONTH AND END_MONTH > AND > BETWEEN START_YEAR AND END_YEAR > > does not work when you have a date range that spans more than one month. > Start_Month = 1 > Start_Day = 18 > Start Year = 2004 > > End_Month = 2 > End_Day = 8 > End_Year = 2004 > > Basically, while looping, if my #page[j][i]# was on the number 3, it would return false, because 3 is not between 18 and 8. How about creating an extra field that stores a date and query that? You do not have to change any UI for that, you just maintain it through a trigger. Pseudocode (PL/SQL has been a while): ALTER TABLE table ADD COLUMN shift_start DATE; UPDATE TABLE table SET shift_start = to_date( start_year || '-' || start_month || '-' || start_day, "-mm-dd"); CREATE TRIGGER ON table AFTER UPDATE, INSERT BEGIN SET NEW:shift_start = to_date( start_year || '-' || start_month || '-' || start_day, "-mm-dd"); END; After this, your shift_start will always contain the start date. Do the same for the end_date and you can do a simple between on the entire date. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dates - ranges overlapping months... rut-roh
Doh. Try this: update oncall_shifts set shift_start = cast((cast(start_month as varchar) + '/' + cast(start_day as varchar) + '/' + cast(start_year as varchar)) as datetime) sorry about that. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:53 PM To: CF-Talk Subject: RE: Dates - ranges overlapping months... rut-roh Hey Steve! I tried that one as well. I kept getting: Syntax error converting the varchar value '/' to a column of data type int. So then I went to: update oncall_shifts set shift_start = cast((start_month + start_day + start_year) as datetime) and got: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). Thoughts? *meanwhile, I'll keep trying* 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] 1/29/2004 1:33:06 PM >>> Candace, This should be : update oncall_shifts set shift_start = cast((start_month + '/' + start_day + '/' + start_year) as datetime) Steve -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:28 PM To: CF-Talk Subject: Re: Dates - ranges overlapping months... rut-roh Hey Jochem, I am using Transact-SQL and converted everything but: UPDATE TABLE table SET shift_start = to_date( start_year || '-' || start_month || '-' || start_day, "-mm-dd"); I tried to do: UPDATE ONCALL_SHIFTS SET shift_start = CAST(start_month&start_day&start_year AS DATETIME) But it is setting the shift_start to 1/1/1900?? Thanks for all your help!! 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] 1/29/2004 11:22:01 AM >>> Candace Cottrell wrote: > > BETWEEN START_DAY AND END_DAY > AND > BETWEEN START_MONTH AND END_MONTH > AND > BETWEEN START_YEAR AND END_YEAR > > does not work when you have a date range that spans more than one month. > Start_Month = 1 > Start_Day = 18 > Start Year = 2004 > > End_Month = 2 > End_Day = 8 > End_Year = 2004 > > Basically, while looping, if my #page[j][i]# was on the number 3, it would return false, because 3 is not between 18 and 8. How about creating an extra field that stores a date and query that? You do not have to change any UI for that, you just maintain it through a trigger. Pseudocode (PL/SQL has been a while): ALTER TABLE table ADD COLUMN shift_start DATE; UPDATE TABLE table SET shift_start = to_date( start_year || '-' || start_month || '-' || start_day, "-mm-dd"); CREATE TRIGGER ON table AFTER UPDATE, INSERT BEGIN SET NEW:shift_start = to_date( start_year || '-' || start_month || '-' || start_day, "-mm-dd"); END; After this, your shift_start will always contain the start date. Do the same for the end_date and you can do a simple between on the entire date. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Getting rid of subquery
Try: select StatusName, count(t.status) from ticketstatus s left outer join tickets as t on s.statusid = t.status and t.owner = 2 group by statusName Steve -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: Friday, January 30, 2004 3:58 PM To: CF-Talk Subject: Getting rid of subquery Can anyone help me with getting rid of this subquery? SELECT Count(t.Status) AS Count, StatusName FROM TicketStatus s LEFT OUTER JOIN (SELECT Status FROM Tickets t WHERE t.Owner = 2) t ON t.Status = s.StatusID GROUP BY StatusName Right now, all of the StatusNames are shown, even if their count is 0. I've tried just about every join I can think of and it always returns the StatusNames that have a count greater than 0. I want ALL the StatusNames, even ones with a count of 0. Anyone? Cedric _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IIS Headaches
David, IIS tends to set integrated authentication on by default. Go into your iis website properties and make sure that only anonymous is checked under authentication. Steve -Original Message- From: David Keevil [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 2:20 PM To: CF-Talk Subject: OT: IIS Headaches Just finished a routine installation of IIS under WINXP-PRO but the results are anything but routine. Any attempt to access anything under http://127.0.0.1/ from the local machine triggers a Windows login prompt for a Username & Password. Any help in resolving this issue would be much appreciated. TIA. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Need regex / rereplace help.
I need some quick help with a regex. I need to replace Ii, Iii, Iiii, etc with II, III, , etc. and it is part of a longer string (these characters are surrounded by spaces). I can find the chars with this regex: [\s][I]i+[\s] (I used the Visual Regular _expression_ Editor), but I don't know how to do the update. Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Need regex / rereplace help.
It didn't work, I still get Iii. I'm on MX6.1 Steve -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 9:13 AM To: CF-Talk Subject: RE: Need regex / rereplace help. On CFMX only: rereplace(origVar, "(\sIi+\s)", "\U\1\E", "All") > -Original Message- > From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] > Sent: woensdag 4 februari 2004 15:05 > To: CF-Talk > Subject: Need regex / rereplace help. > > I need some quick help with a regex. > > I need to replace Ii, Iii, Iiii, etc with II, III, , etc. > and it is part of a longer string (these characters are > surrounded by spaces). > > I can find the chars with this regex: [\s][I]i+[\s] (I used > the Visual Regular _expression_ Editor), > > but I don't know how to do the update. > > > > Thanks, > Steve > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pulling record for this month
You need to do: and month(date) = #month(thismonth)# Steve -Original Message- From: JT [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 1:41 PM To: CF-Talk Subject: Pulling record for this month How can I pull all records where date = this month. this is what I have and it is not working? Which month is it And then I query using this query . select * from tablename where completed = 1 and date = #DatePart("m", thismonth)# order by date,time There are 7 record but it pulls 0 records What am I doing wrong? Thx , JT _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
convert evaluate to [] notation.
Hi all, Alright this one has me stumped (because of lack of sleep I think). I currently have this: evaluate("#Variables.myQueryName#.employee_name")> and I want to get rid of the evaluate. Problem is that the Variables.myQueryName is the scope. Anyone have any ideas. I'm sure that when I see the answer I'm going to bang my head on the desk, because it was staring me in the face. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: convert evaluate to [] notation.
Thanks. Steve -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 11:06 AM To: CF-Talk Subject: Re: convert evaluate to [] notation. DURETTE, STEVEN J (AIT) wrote: > > I currently have this: > > > evaluate("#Variables.myQueryName#.employee_name")> > > and I want to get rid of the evaluate. Problem is that the > Variables.myQueryName is the scope. variables[myQueryName]["employee_name"] Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Windows NT source code
Steven, I think that there might be a slight flaw in that logic. A massive cutover would be disruptive, but as new employees come in converting them would stop the "I've always done it this way" mentality. If large companies always had the same employees (no retirements, firings, etc.) then this might be true, but big business usually has a high turnover rate from what I've seen. Steve D. -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 12:37 PM To: CF-Talk Subject: RE: OT - Windows NT source code ...and from a business point of view where does the majority of the work happen? Not on a server but rather on some desktop where people key in data to systems (Excel, PeopleSoft, Oracle, etc.). So if the desktop becomes unstable the work is unstable and so on and so forth. I'm not knocking the value of Linux and those like it I just don't see it as a viable option for a world raised on MS. Our users have a hard enough time as it is with MS, asking them to change gears in mid stroke seems kind of self-defeating. Now, new companies and up and comers would be able to start differently, I'm referring to the bigger companies here that would have problems. -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 12:25 PM To: CF-Talk Subject: RE: OT - Windows NT source code On Fri, 2004-02-13 at 09:00, Schuster, Steven wrote: > How many companies with over 1,000 employees (and PC's) have you been with > that ran Linux, FreeBSD or something similar on the desktop? Not many on the U.S. desktop, no - but for back end systems open source OSs are used quite a bit - "In 1999, Linux scooted past Novell's Netware to become the No. 2 server operating system behind Microsoft's Windows NT. Over the next four years, IDC said, Linux shipments will grow at a rate of 28 percent, from 1.3 million in 1999 to 4.7 million in 2004." -- CNET news "Linux surged from a 16% share of the server software market in 1998 to a quarter of the market in 1999, when it shipped nearly twice as many copies as during the previous year, according to figures from International Data Corporation (IDC)." -- BBC news And that's just Linux. > The answer is: "Not a whole lot". I am not too sure about that - I think China (and a lot of other countries) uses Linux quite a bit (even on the desktop) -- and there are a few people in china I hear. I couldn't find any stats though > So, if most business runs MS on the desktop they rely on it. There are > enough hacks out there now without the source code causing problems. If > somebody had the source code they could cripple industries that relied on > the platform rather quickly. Well when your right your right. > Our jobs are time consuming enough without the added pressure of 16 year old > kids writing viruses all day aren't they. I agree. > If Linux was the most used OS in the world you better bet it wouldn't take > long for exploit after exploit to hit that platform. With it being open > source that simply makes the job that much easier. Well I think Unix (the catch all) is the OS that has all the hard core data in the world, but I haven't heard of a Unix worm or virus in a while. Your points are valid - I was just trying to make light and poke a bit of fun. All in good fun -- Vale, Rob Luxuria immodica insaniam creat. Sanam formam viatae conservate! http://www.rohanclan.com http://treebeard.sourceforge.net http://ashpool.sourceforge.net _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A tough query... Can CFML help?
MC, What database are you using? This will work for mssql, but I'm not sure about others. select * from table2 where [idfield] not in (select distinct [idfield] from table1) That is if I understand your table layout. If this doesn't work, give us an example of a couple of rows of each table. Steve -Original Message- From: Merritt Chapman [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 4:15 PM To: CF-Talk Subject: A tough query... Can CFML help? I'm wondering if anyone can help me accomplish the following in one SQL query... I have two tables. Table1 contains N fields, each containing an ID number. Table2 contains N fields, each also contain an ID. The trick is that the IDs in Table2 are 'exclusions' from Table1 and should be used to denote which IDs are not to be returned in a query of Table1. For example, if Table1 contains the following IDs: 1|2|3|4|5 And Table2 contains the following exclusions: 2|3 Then a query of the allowed IDs in Table1 should only return: 1|4|5 I'm experimenting with different SQL functions. Is there a CF function that might help out here that anyone can think of? Thanks in advance! Regards, MC _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Scope name of method's local scope?
Actually, I don't think that you even need the scope. just try #i# it should work. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 1:37 PM To: CF-Talk Subject: RE: Scope name of method's local scope? I don't think the 'var' scope has a name. At least I've never heard of one, so I think you have to use evaluate(). Cheers, barneyb > -Original Message- > From: Jamie Jackson [mailto:[EMAIL PROTECTED] > Sent: Monday, February 23, 2004 10:31 AM > To: CF-Talk > Subject: Scope name of method's local scope? > > How do I evaluate the members of this list without evaluate()? I don't > know what scope name the method's local scop uses. A bad example > follows: > > > returntype="Collection"> > > var i = ""; > var myList = "foo,bar,fooBar"; > > > > #variables[i]# > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: stored proc error with MX
John, Try CFSQLTYPE="CF_SQL_TIMESTAMP" Steve -Original Message- From: John mccosker [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 9:57 AM To: CF-Talk Subject: stored proc error with MX hi, is there some reason why I can't add a date object via a stored proc in MX 6.1. example, month(now()), day(now()), hour(now()), minute(now()), 00)> then, CFSQLTYPE="CF_SQL_DATE" TYPE="IN"> I get this error, {Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented I had a look at JavaCast thinking I was'nt passing in a proper date object, even though I am, but javaCast has not data type support for date objects. any ideas, john. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to know when you have the last record?
Try: Steve -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 10:26 AM To: CF-Talk Subject: How to know when you have the last record? Hey, I'm outputting a query as a list. Visually, I'm inserting an image between each record. It looks great until the last record, and I get the image at the very end. What would be the best way to know that I'm at the end of my record set and not show the image? Something like: Is there an easy way to accomplish this? -Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access & Coldfusion MX6.1 problems...sites keep dying
Jochem, I tried looking for the unicode driver in the drop down, but all that is listed is Access. The dropdown you are talking about is on the CFA Datasources page right (Add datasource above a listing of all the current datasources). Steve -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 12:15 PM To: CF-Talk Subject: Re: Access & Coldfusion MX6.1 problems...sites keep dying Josen Ruiseco wrote: > Is the unicode driver just useful for Access or will it stabilize Sql > Server 2000 also? Where can it be found? Access only, and it is just in the dropdown menu. For MS SQL Server, use the JDBC driver from Microsoft. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Hanging Solutions?
Sung, Not an answer to the hang, but you might be able to speed up the page (and possibly prevent the hang) by moving the queries to a stored procedure. The speed increase is dramatic. Steve -Original Message- From: Sung J. Woo [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 8:54 AM To: CF-Talk Subject: CFMX Hanging Solutions? I've been scouring the forums here and on Macromedia regarding CFMX hangs. I have a page on my site that takes more than 1000ms to return (runs about 10 big queries). If I get on this page and hit F5 over and over again, I can see jrun.exe memory size and thread count expand. The memory size never is the issue -- it's the thread count. When it goes over 100, it seems like the machine hangs. Eventually, it does respond, but while it's hanging, the site is cooked. So here's my question: Is it possible for me to wrap a CFLOCK around that entire page, to isolate it to a single thread? It isn't an often-visited page, so I could probably get away with this. Eventually, I'll need break up the query/page...looks like I'll have to do this. Oh, and by the way, whenever I use JDBC drivers, this issue is far worse...so I use ODBC Socket for everything. My setup is Win2K on a dual pentium 5 with 2GB RAM and SQL 7.0. Thanks! - Sung _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ordering a query by a dynamic field
Les, I believe it depends on the database. I have seen queries work this way on some and break on others. I think that the best way to do it would be to change your order by line to: order by (69.1 * (longitude = 104.825814)) Steve -Original Message- From: Les Irvin [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 1:37 PM To: CF-Talk Subject: Ordering a query by a dynamic field Is it possible to order a query by a field produced within that same query? This query fails at the "Order by" statement: SELECT City, State, Username, Longitude, (69.1*(longitude - 104.825814) as distance FROM personal ORDER BY distance The "distance" field is (obviously) not a field in the table being queried. Thanks in advance for the help, Les _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ben's book is out
I already got it 2 days ago. It is great. I'm only to chapter 3 but it is making everything clear to me finally! Also, the appendix with the real world regex's is a great time saver. I recommend it to everyone. Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 12:21 PM To: CF-Talk Subject: Re: Ben's book is out BTW, I was Tech Editor on it. > Ben Forta's new book on Regular Expressions is out. > "Sams Teach Yourself Regular Expressions in 10 Minutes" > It's not too big and goes right to the core of what you need to write some > useful RegEx. Lots of step through examples, which is really needed. Anyone > interested can just click on the banner below. :) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Quick SQL Question...
Che, If you are on MSSql 2K then this is the solution: select count(convert(varchar, creationdate, 101)), convert(varchar, creationdate, 101) from referer group by convert(varchar, creationdate, 101) Steve -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:52 PM To: CF-Talk Subject: RE: Quick SQL Question... mark, i see where you are coming from...alas, i still am having no luck. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:51 PM To: CF-Talk Subject: RE: Quick SQL Question... The 2 are mutually exclusive. One is the "group" of all the stuff on this day, but the other (the actual date) is not merely a date - but a - by nature a very unique item - down to the second. So you are actually getting the grouping you are asking for. If 2 referals occured at the exact instant (say '3/4/2004 5:07:35 PM') ... then you would see "2 3/4/2004 5:07:35 PM" - but since that's unlikey this is more or less like doing a "select * from.". What you need is a label and an order by clause: SELECT COUNT(creationdate) AS TotalRefsPerDay, datepart(month,creationdate) + '-' + datepart(day,creationdate) + '-' + datepart(year,creationdate) AS datelabel group by datepart(dw,creationdate) order by datelabel or something similar. The DateName( ) function would work as well - maybe better. It usally takes some work to get it exactly right. -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 1:28 PM To: CF-Talk Subject: Quick SQL Question... This SQL Code works: SELECT COUNT(creationdate) AS TotalRefsPerDay FROM Referer GROUP BY DATEPART(dw, creationdate) 197 364 350 294 260 243 196 But when I add a column... this does not): SELECT COUNT(creationdate) AS TotalRefsPerDay, creationdate FROM Referer GROUP BY DATEPART(dw, creationdate), creationdate 1 3/4/2004 5:07:35 PM 1 3/4/2004 5:09:27 PM 1 3/4/2004 5:11:19 PM 1 3/4/2004 5:13:14 PM 1 3/4/2004 5:14:31 PM 1 3/4/2004 5:14:53 PM 1 3/4/2004 5:16:19 PM 1 3/4/2004 5:20:37 PM 1 3/4/2004 5:21:10 PM What am I doing wrong? I'd like a simple two column table: creation date and the total number of referers for each day! TIA...Che _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Quick SQL Question...
The numbers in the 3rd position of the convert are qualifiers for how it will convert. In this case 101 = USA = MM/DD/YY. If you look in the SQL Books Online under Cast and Convert it will give you a list of all of the date conversions. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:18 PM To: CF-Talk Subject: RE: Quick SQL Question... WOW! WOW! WOW! Thanks so much. I knew this was possible. what is the significanse of the 101 -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:03 PM To: CF-Talk Subject: RE: Quick SQL Question... Che, If you are on MSSql 2K then this is the solution: select count(convert(varchar, creationdate, 101)), convert(varchar, creationdate, 101) from referer group by convert(varchar, creationdate, 101) Steve -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:52 PM To: CF-Talk Subject: RE: Quick SQL Question... mark, i see where you are coming from...alas, i still am having no luck. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 2:51 PM To: CF-Talk Subject: RE: Quick SQL Question... The 2 are mutually exclusive. One is the "group" of all the stuff on this day, but the other (the actual date) is not merely a date - but a - by nature a very unique item - down to the second. So you are actually getting the grouping you are asking for. If 2 referals occured at the exact instant (say '3/4/2004 5:07:35 PM') ... then you would see "2 3/4/2004 5:07:35 PM" - but since that's unlikey this is more or less like doing a "select * from.". What you need is a label and an order by clause: SELECT COUNT(creationdate) AS TotalRefsPerDay, datepart(month,creationdate) + '-' + datepart(day,creationdate) + '-' + datepart(year,creationdate) AS datelabel group by datepart(dw,creationdate) order by datelabel or something similar. The DateName( ) function would work as well - maybe better. It usally takes some work to get it exactly right. -Mark Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ...what the web can be! -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 1:28 PM To: CF-Talk Subject: Quick SQL Question... This SQL Code works: SELECT COUNT(creationdate) AS TotalRefsPerDay FROM Referer GROUP BY DATEPART(dw, creationdate) 197 364 350 294 260 243 196 But when I add a column... this does not): SELECT COUNT(creationdate) AS TotalRefsPerDay, creationdate FROM Referer GROUP BY DATEPART(dw, creationdate), creationdate 1 3/4/2004 5:07:35 PM 1 3/4/2004 5:09:27 PM 1 3/4/2004 5:11:19 PM 1 3/4/2004 5:13:14 PM 1 3/4/2004 5:14:31 PM 1 3/4/2004 5:14:53 PM 1 3/4/2004 5:16:19 PM 1 3/4/2004 5:20:37 PM 1 3/4/2004 5:21:10 PM What am I doing wrong? I'd like a simple two column table: creation date and the total number of referers for each day! TIA...Che _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Another SQL Question...
Che, Just off the top of my head, I believe it is: select refkeywords, sum(refcount) as trefcount from referer group by refkeywords having sum(refcount) > 5 order by sum(refcount) desc I haven't tested it but give it a try. Steve -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 9:18 AM To: CF-Talk Subject: OT: Another SQL Question... I know I'm a PITA...but a have another SQL question. Take the following query: SELECT RefKeywords, SUM(RefCount) AS TRefCount FROM Referer GROUP BY RefKeywords ORDER BY SUM(RefCount) DESC How would I write the same query with a WHERE clause that had a 'SUM(RefCount) > 5' ??? I get an error with aggregates in a where clause. Thanks, Che _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Emailing Form.FieldNames results via looping?
Bob, Inside your cfmail tags, you only need to use this code: #thisField#: "#evaluate(thisField)#" (just remove the cfoutputs) Steve -Original Message- From: Bob Haroche [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 1:24 PM To: CF-Talk Subject: Emailing Form.FieldNames results via looping? I have a form with a lot of fields. I want to email the submitted results to someone, but instead of coding Form.Field1, Form.Field2, Form.Field3, etc. to do this, I want to loop over the form structure to get the values of the submitted fields. I'm using this to do that: #thisField#: "#Evaluate(thisField)#" That code outputs what I want but I can't use it within a CFMAIL tag because I get this error: "A CFOUTPUT tag is nested inside a CFMAIL tag with no GROUP= or QUERY= attributes . This is not allowed." Do I need to convert Form.FieldNames into a query using QueryNew function, or something else? Using CF 5. Thanks! O n P o i n t S o l u t i o n s P.O. Box 694 Occidental, Ca 95465 tel / 707.874.2710 fax / 707.874.2716 web / www.onpointsolutions.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Emailing Form.FieldNames results via looping?
if I remember correctly, #form[thisField]# won't work in cf5, but I'm not 100% sure of that (It's been so long since I used CF5). Steve -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 1:40 PM To: CF-Talk Subject: RE: Emailing Form.FieldNames results via looping? You don't need CFOUTPUT inside of CFMAIL. Second, skip the evaluate and just use #form[thisField]# Andy -Original Message- From: Bob Haroche [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 12:24 PM To: CF-Talk Subject: Emailing Form.FieldNames results via looping? I have a form with a lot of fields. I want to email the submitted results to someone, but instead of coding Form.Field1, Form.Field2, Form.Field3, etc. to do this, I want to loop over the form structure to get the values of the submitted fields. I'm using this to do that: #thisField#: "#Evaluate(thisField)#" That code outputs what I want but I can't use it within a CFMAIL tag because I get this error: "A CFOUTPUT tag is nested inside a CFMAIL tag with no GROUP= or QUERY= attributes . This is not allowed." Do I need to convert Form.FieldNames into a query using QueryNew function, or something else? Using CF 5. Thanks! O n P o i n t S o l u t i o n s P.O. Box 694 Occidental, Ca 95465 tel / 707.874.2710 fax / 707.874.2716 web / www.onpointsolutions.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
Just remember there are 10 kinds of people. Those who know binary and those who don't. :) Steve -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:57 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? true true its all good ben. we just lack patience. nothing too surprising here. we are geeks. we have no patience. its 1 and 0. nothing in between. have a good weekend all! later tony -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:54 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? Last week I think I said "very shortly", not "very, very shortly". :-) Ugh, this is killing me! :-( _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:49 PM To: CF-Talk Subject: Re: MAX 2004 Conference date? lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > _ > > > > _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Okay, bear with me, I'm not even sure what I'm asking...
Jeff, The easiest way I see to fix this quickly (if you don't have multiple sites each running different image directories) is to make a mapping in the CFAdmin of /images pointing to the images directory. That should clear up the problem. Steve -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 11:55 AM To: CF-Talk Subject: Okay, bear with me, I'm not even sure what I'm asking... Okay, here's the deal. One of our programmers has created an include that would be in the root of a site (call it, "navbar.cfm") and there's one page (index.cfm) that calls it from the root (). Now, in navbar.cfm, there's a path to an image (let's say src="" for instance). He's using absolute paths because he says "slash images should always refer to the root" and doesn't understand why he can't include that same file in a page one directory below (about/index.cfm) and it not work. In other words, when the page below (about/index.cfm) tries to reconcile the path, it's seeing the same path that the root page is seeing ( it's breaking it and not showing the image (so now, when you "view source" on the page, you see http://devserver.ourdomain.com/images/... and you should see http://devserver.ourdomain.com/ThisSite/images/...) . Now, our development server is set up on a smallish PC running IIS and the site (and all others in development) is set up under the webroot of the IIS server, so that when you're testing it, you simply go to http://devserver.ourdomain.com/ThisSite/ and you can see the root of "ThisSite" which is the directory "ThisSite" under webroot (C:\InetPub\wwwroot\ThisSite). Is a virtual directory what he's looking for? Is it a mapping issue? I admit, I'm fairly stupid when it comes to IIS issues and web server administration issues, and will readily admit that I'm no mapping wizard, so I hope I explained it correctly, but I'd love to be able to do this. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX6.1 updater
Hey does anyone have any idea when an updater for CFMX6.1 might be out? I just had to re-image my web server and re-install. Now most of my time is being spent dling and installing HotFixes and Security updates for ColdFusion. An updater would be really helpful about now as I am up to 14 hotfix/security updates with more to go. Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFChart and the Y-Axis
Hi all, Got one for you all. (and yes I did search the list history before asking!) :) I have a cfchart that has a minimum value of 0 (zero) and a maximum of 100. No matter whether I put in only integers or decimals (the data that will be in the final chart) the Y-Axis always shows up in decimals. Example: 100 88.89 77.78 66.67 55.56 44.44 33.33 22.22 11.11 0 but what I need is for all of them to be in integers (the data will still be in decimals). 100 90 80 70 60 50 40 30 20 10 0 Anyone know how to make this happen? Extra information: Line chart with 3 series. CFMX6.1 Enterprise Win2K IIS5 Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]