RE: DNS Error
Maybe a reach, but try checking her hosts.txt file just in case something was changed there. -Original Message- From: Suyer, Ed . [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 5:28 PM To: CF-Talk Subject: DNS Error Hi folks, I have a very interesting problem that has to do with DNS. When one of our users logs into our Intranet and clicks a particular links, she gets a DNS error. However, when I log in to her machine and click on the same page, no error. And by the same token, when she logs into my machine and clicks on the link no error. For this reason I believe that this error has something to do with her local settings (that are not carried w/ her profile). I've tried: 1. Deleting all her cookies and other temporary internet files 2. Flushing her local DNS 3. Turning of the DNS client Nothing. Does anybody have any ideas? The page that runs takes about 2 minutes to process. That's the only thing that I can think of that is unique about this page (v the other pages on our Intranet). Any help, things to read, places to look is much appreciated! TIA! Ed _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Detecting SQL Update success
Exactly, To be accurate its best to use a storedproc, but if you don't want to use it like this update table set column = x where column = y select @@rowcount as RecordsUpdated just be sure to wrap in a transaction. The only bad thing about it is if the table you are updating has a trigger that does something then you are going to get the value from the trigger's execution. @@rowcount returns the number of rows affected by the very last executed statement. Hope it helps, Nate Nelson -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 4:58 PM To: CF-Talk Subject: Re: Detecting SQL Update success > Is there a way to detect if a SQL update statement in resulted in a record being updated? I guess I would want to know the number of rows updated. depends on your db, for sql server examine the @@ROWCOUNT var immediately after your update. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: grabbing data from another website
> ok i have never done this heres what i need to do grab the info from either you could "scrape" their screens like i do for quake data from the usgs but you'll be at their mercy if they change anything (url will probably wrap): http://www.macromedia.com/cfusion/exchange/index.cfm?view=sn130#loc=en_us&view=sn131&viewName=ColdFusion%20Extension&extID=1002505 you'd be better served asking them for RSS/XML feeds or maybe webservices. the usgs also seems to have a healthy supply of java-based stuff to access their data as well. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Safari Navigation Bug and general speed issues
We just had a major problem with some versions of Safari (not all). The issue, it seems was that Safari was a little aggressive with caching. Our log in page submits to itself: showing error or success information. Safari only showed the original page from its cache even tho' the page had been updated. We "fixed" this by adding a URL variable to the page - all I did was "?tick=#getTickCount()#" It's kludgy as hell, but it changes the URL enough to force Safari to display the actual page. You might try the same thing for your issue. Jim Davis _ From: Alan Rafael Bleiweiss [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 6:07 PM To: CF-Talk Subject: Safari Navigation Bug and general speed issues Two questions. I've got a site with over 1000 products. In that site, when bringing up any category my code (see below) shows 10 products per page with a Next / Previous function. On IE and Netscape on the PC this works (though very slowly for large categories). On Macs IE and Safari, clicking the NEXT button shows seven of the previous page's ten and only three new products, all of which are at the bottom of the list. 1. WHAT in my code is causing this to fail on Macs? 2. How can I re-code this to be much more efficient regardless of visitor platform? I'm running CF MX 6.1 on a Windows 2000 server. HERE'S THE CODE: _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MS Access password
I've got a new client with an existing site using MS Access. The problem is the original developer put a password lock on the database - the guy is no longer reachable - doesn't return calls, email or written letters. I need to either know how to get passed the password or a CF snippet to learn the data table names, column names and data types. Or can I just do an import from within SQL server 2000 without that password? Any help would be greatly appreciated - otherwise I need to charge the client a lot of money to build this from scratch. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: grabbing data from another website
Hmmm. WDDX (web distributed data exchange), a web service, a seperate DSN to pull the data in, XML perhaps. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] \¯\/¯/ |¯|)¯) /¯/\¯\ \¯\/¯/ /_/\_\ |_|)_) \_\/_/ /_/\_\ RULES -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 January 2004 3:16 PM To: CF-Talk Subject: grabbing data from another website ok i have never done this heres what i need to do grab the info from either http://co.waterdata.usgs.gov/nwis/current?type=flow or http://www.frontrangeanglers.com/Fishing%20Rpts/coloradostreamflows.htm and pull it into a site but i want to be able to format it how i want it any pointers to get me started? ty [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
grabbing data from another website
ok i have never done this heres what i need to do grab the info from either http://co.waterdata.usgs.gov/nwis/current?type=flow or http://www.frontrangeanglers.com/Fishing%20Rpts/coloradostreamflows.htm and pull it into a site but i want to be able to format it how i want it any pointers to get me started? ty [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DNS Error
Hi folks, I have a very interesting problem that has to do with DNS. When one of our users logs into our Intranet and clicks a particular links, she gets a DNS error. However, when I log in to her machine and click on the same page, no error. And by the same token, when she logs into my machine and clicks on the link no error. For this reason I believe that this error has something to do with her local settings (that are not carried w/ her profile). I've tried: 1. Deleting all her cookies and other temporary internet files 2. Flushing her local DNS 3. Turning of the DNS client Nothing. Does anybody have any ideas? The page that runs takes about 2 minutes to process. That's the only thing that I can think of that is unique about this page (v the other pages on our Intranet). Any help, things to read, places to look is much appreciated! TIA! Ed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Detecting SQL Update success
> Is there a way to detect if a SQL update statement in resulted in a record being updated? I guess I would want to know the number of rows updated. depends on your db, for sql server examine the @@ROWCOUNT var immediately after your update. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: BD6.1b2 and mySQL
Cutter, I've tried sending this response to you privately a few times, but keep getting an "unknown user" error. Maybe you'll get this one... You've found a bug in the way BlueDragon handles "unsigned" column types for MySQL. We've reproduced and are working on a fix now. I'll send you a patch as soon as it's ready. Thanks for reporting this. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Saturday, January 10, 2004 3:33 PM To: CF-Talk Subject: SOT: BD6.1b2 and mySQL So, I downloaded and installed the free version of BlueDragon 6.1 beta 2. This took care of issues I had with gettings the mySQL JConnect JDBC driver working. I can now make a connection with my mySQL server:) But...I took a low end CF5 App that I have had running on my CF 6.1 developer box and copied it to this new BD server. It's a simple app, just a minor backend editor for viewing/adding/updating/deleting records in various tables. I see that the mySQL driver is working because I get query results on some queries. But then...I attempt to load some pages with some simple SQL select statements and they error out for no apparent reason. Same pages, same code, same queries, even the same database, but erroring pages that worked fine on my CF dev server. Before posting some of my SQL code, or discussing the errors that are appearing, I was wondering if anyone else has yet had a similar experience? I know this beta only came out yesterday, but I thought it pertinent to ask. Any insight is appreciated and welcome. Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ide.cfm/CFFILE
Hey All, I'm running a CFMX 6.1 Standard on RedHat 9 and I'm getting this error in the application log whenever I try and upload a file via CFFILE (please note this did work when the Enterprise edition was installed). I have tried dumping cffile.serverfile after the upload and that variable does exist and has the value it should (but the file does not show in the directory it was uploaded or any other directory for that matter)!! "Error","jrpp-0","01/12/04","15:00:00",,"File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: /var/www/html/CFIDE/main/ide.cfm " I'm pretty sure the main/ide.cfm directory/file is missing because I did not install RDS?? My question is how/why/does RDS effect CFFILE?? BTW the directory I am trying to upload to is NOT web accessible...it is above the webroot (so none of the files are web browsable). This one has me really stumpedany help no matter how dumb it may sound would be greatly appreciated. Cheers 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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFX_PDFtext (extract text from PDFs)
Since people seemed interested, I released today on my blog (http://devilm.com) a custom tag I wrote for extracting text from a PDF. Enjoy! -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Temp files question
yes, they can be deleted == Stop spam on your domain, Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == Aspire to Inspire before you Retire or Expire! - Original Message - From: "John Stanley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 12, 2004 4:45 PM Subject: Temp files question : Does anyone know what the following directories and files sre used for? The : only thing I see is that they are taking up a bunch of hard drive space: : : c:\documents and settings\computer\local settings\temp\tmp15e6 : tmp0017e0 : c:\documents and settings\computer\local settings\temp\tmp22b6 : tmp0017e1 : : Some of these are over 300 megs in size. : Can they be safely deleted? : Running XP Pro : : Thanks, : John : : : : : [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Temp files question
Does anyone know what the following directories and files sre used for? The only thing I see is that they are taking up a bunch of hard drive space: c:\documents and settings\computer\local settings\temp\tmp15e6 tmp0017e0 c:\documents and settings\computer\local settings\temp\tmp22b6 tmp0017e1 Some of these are over 300 megs in size. Can they be safely deleted? Running XP Pro Thanks, John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Safari Navigation Bug and general speed issues
It should only ever be counting up and down by 3s. That is what your code is telling it to do: Where does the jump by 10s come in? Jerry Johnson >>> [EMAIL PROTECTED] 01/12/04 06:20PM >>> For some reason my code didn't get included in the first email. Here's a link to the code in question... http://www.brionanet.com/nextprevcodechunk.txt At 05:06 PM 1/12/04, you wrote: >Two questions. > >I've got a site with over 1000 products. > >In that site, when bringing up any category my code (see below) shows 10 >products per page with a Next / Previous function. On IE and Netscape on >the PC this works (though very slowly for large categories). On Macs IE >and Safari, >clicking the NEXT button shows seven of the previous page's ten and only >three new products, all of which are at the bottom of the list. > >1. WHAT in my code is causing this to fail on Macs? >2. How can I re-code this to be much more efficient regardless of visitor >platform? > >I'm running CF MX 6.1 on a Windows 2000 server. > >HERE'S THE CODE: > > > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Safari Navigation Bug and general speed issues
The line you included as a separator was parsed as the end of the message by HOF == Stop spam on your domain, Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == Aspire to Inspire before you Retire or Expire! - Original Message - From: "Alan Rafael Bleiweiss" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 12, 2004 5:16 PM Subject: Re: Safari Navigation Bug and general speed issues : Uh, how come my pasted code didn't get included in this post? : : : : At 05:06 PM 1/12/04, you wrote: : >Two questions. : > : >I've got a site with over 1000 products. : > : >In that site, when bringing up any category my code (see below) shows 10 : >products per page with a Next / Previous function. On IE and Netscape on : >the PC this works (though very slowly for large categories). On Macs IE : >and Safari, : >clicking the NEXT button shows seven of the previous page's ten and only : >three new products, all of which are at the bottom of the list. : > : >1. WHAT in my code is causing this to fail on Macs? : >2. How can I re-code this to be much more efficient regardless of visitor : >platform? : > : >I'm running CF MX 6.1 on a Windows 2000 server. : > : >HERE'S THE CODE: : > : > : > : >-- : >[ : [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Safari Navigation Bug and general speed issues
For some reason my code didn't get included in the first email. Here's a link to the code in question... http://www.brionanet.com/nextprevcodechunk.txt At 05:06 PM 1/12/04, you wrote: >Two questions. > >I've got a site with over 1000 products. > >In that site, when bringing up any category my code (see below) shows 10 >products per page with a Next / Previous function. On IE and Netscape on >the PC this works (though very slowly for large categories). On Macs IE >and Safari, >clicking the NEXT button shows seven of the previous page's ten and only >three new products, all of which are at the bottom of the list. > >1. WHAT in my code is causing this to fail on Macs? >2. How can I re-code this to be much more efficient regardless of visitor >platform? > >I'm running CF MX 6.1 on a Windows 2000 server. > >HERE'S THE CODE: > > > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Safari Navigation Bug and general speed issues
Uh, how come my pasted code didn't get included in this post? At 05:06 PM 1/12/04, you wrote: >Two questions. > >I've got a site with over 1000 products. > >In that site, when bringing up any category my code (see below) shows 10 >products per page with a Next / Previous function. On IE and Netscape on >the PC this works (though very slowly for large categories). On Macs IE >and Safari, >clicking the NEXT button shows seven of the previous page's ten and only >three new products, all of which are at the bottom of the list. > >1. WHAT in my code is causing this to fail on Macs? >2. How can I re-code this to be much more efficient regardless of visitor >platform? > >I'm running CF MX 6.1 on a Windows 2000 server. > >HERE'S THE CODE: > > > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash Remoting with Blue Dragon
> http://www.flashorb.com/articles/soap_vs_flash_remoting_benchmark.shtml > > Unfortunately, it seems like they forgot to consider HTTP compression > They didn't forget... the purposely excluded it. Otherwise their argument would fall on its face. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash Remoting with Blue Dragon
> Why are binary formats so fast? Data size or parsing efficiency > on the recipient? Has anybody ever benchmarked Flash Remoting > against both normal and gzip'ed webservices? > Binary formats are generally less verbose than human readable formats. Obviously, there can thus be space savings, which mean less data to transmit across the wire and possibly less data to parse through. However, the really question is how much space savings you get and is it worth the tradeoff of not using a standard, mature protocol. I personally have looked into the differences between AMF and compressed SOAP. The advantages in terms of space is insignificant, while there is some difference in performance, but that is pretty minor. Most folks that are pushing Flash Remoting over standard SOAP are comparing AMF to uncompressed SOAP and thus are seeing benefits that aren't really applicable. In my mind, Macromedia killed any reason to use Flash Remoting with Flash 7 by supporting SOAP. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash Remoting with Blue Dragon
> Has anybody ever benchmarked Flash Remoting > against both normal and gzip'ed webservices? I am not into Flash but maybe this may be a start point: http://www.flashorb.com/articles/soap_vs_flash_remoting_benchmark.shtml Unfortunately, it seems like they forgot to consider HTTP compression Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Safari Navigation Bug and general speed issues
Two questions. I've got a site with over 1000 products. In that site, when bringing up any category my code (see below) shows 10 products per page with a Next / Previous function. On IE and Netscape on the PC this works (though very slowly for large categories). On Macs IE and Safari, clicking the NEXT button shows seven of the previous page's ten and only three new products, all of which are at the bottom of the list. 1. WHAT in my code is causing this to fail on Macs? 2. How can I re-code this to be much more efficient regardless of visitor platform? I'm running CF MX 6.1 on a Windows 2000 server. HERE'S THE CODE: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash Remoting with Blue Dragon
John Dowdell wrote: > At 11:34 AM 1/7/4, Matt Liotta wrote: > >> there is no reason to use Flash Remoting anymore since Flash 7 >> supports web services. > > Sorry I'm late, but binary formats are fast. They complement SOAP and > services: universality vs efficiency. (No idea on a Blue Dragon gateway, > sorry.) Why are binary formats so fast? Data size or parsing efficiency on the recipient? Has anybody ever benchmarked Flash Remoting against both normal and gzip'ed webservices? 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:CF Datasource
Have you tried a work-around (lazy man's soltion:) such as just reName the existing csv or xls file that points to the defined dsn? >Well, >Thank you. >However, what is happening is that when I try to register a new csv or >xls dsn with cfadmin it will fail and not verify. > >-Drew > >On Monday, Jan 12, 2004, at 12:14 US/Central, Chunshen (Don) Li wrote: > >> Drew, >> >> Check this out, >> http://www.cfcomet.com/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3- >> B3E9004033E03EF9 >> >> A query may be like: >> >> >> SELECT * >> FROM "Sheet1$" >> -- or the ACTUAL sheet name >> >> >> HIH >> >> Don Li > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash Remoting with Blue Dragon
At 11:34 AM 1/7/4, Matt Liotta wrote: > there is no reason to use Flash Remoting anymore since Flash 7 > supports web services. Sorry I'm late, but binary formats are fast. They complement SOAP and services: universality vs efficiency. (No idea on a Blue Dragon gateway, sorry.) jd John Dowdell, Macromedia Developer Support, San Francisco (Best to reply on-list, to avoid my mighty spam filters!) Technotes: http://www.macromedia.com/support/search/ Column: http://www.macromedia.com/desdev/jd_forum/ Technical daily diary: http://www.macromedia.com/go/blog_jd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Datasource
Well, Thank you. However, what is happening is that when I try to register a new csv or xls dsn with cfadmin it will fail and not verify. -Drew On Monday, Jan 12, 2004, at 12:14 US/Central, Chunshen (Don) Li wrote: > Drew, > > Check this out, > http://www.cfcomet.com/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3- > B3E9004033E03EF9 > > A query may be like: > > > SELECT * > FROM "Sheet1$" > -- or the ACTUAL sheet name > > > HIH > > Don Li [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Rereplace with regular expression not working as I had hoped.
You need to 'remember' the character grabbed by the dot in a backreference: rereplace(string, "(.)/(.)", "\1 / \2", "all"); That should take care of you. If you have any more questions, we might want to move to CF-Regex (available via the HoF archives if you don't want to subscribe). --Ben Doom DURETTE, STEVEN J (AIT) wrote: > 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]
CFChart customization
Hello, I am having a problem with cfchart that I was hoping one of you has run into. I need a horizontal bar graph that displays girdlines from -2.5 to 2.5. Unless I have values that go to both the min and max, the graph doesn't display the min and max. Even if I use the gridlines attribute the graph only displayes all the gridlines if I have values that meet the min and max. It seems that CFChart has a problem when using decimals for the scaleto and scalefrom attributes. If I set them to a whole number then it displays all the gridlines correctly, but the problem is the client specifically wants -2.5 to 2.5. Has anyone run into this problem? Was it fixed in CFMX 6.1? Thanks, Nate Nelson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Concatanating fields with special characters.
Hmm, htmleditformat() seemed to have done the trick in conjunction with . I wrapped the header and footer sections of code with htmleditformat. Then I used before a cffile statement to output the new 'page' to the file: #form.topheadercontent##form.editedcontent# #form.bottomfootercontent# FILE="f:\sites\synapse2\editsample2.cfm" OUTPUT="#pagerebuild#"> I still don't know if this is the best way to do this, but its the only way I've gotten to work so far. If anyone else has any ideas let me know :) -Gel --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.559 / Virus Database: 351 - Release Date: 1/7/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cferror oddness
Hey All, So, I've just discovered something strange. When using a cferror tag that calls an error template, it would appear that you are affectively "cfincluding" that error template, as opposed to "cflocating" to that error template. (Even though the includes within the error template itself function as though the you were cflocating to that template.) In other words, if you have a subdirectory Application.cfm that has an error tag that calls a template in an above Application.cfm, any variables you might have in the above level Application.cfm are not defined if the error comes from below. I had always understood it to be that you were effectively boucing out of your existing application to the application within which the error template resides. But, I was, apparently, wrong. This is with CF 5.0, by the way. Not sure how it works with MX. Thought I'd share in case this was biting anyone else in the butt. -d -- Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Concatanating fields with special characters.
Hey all, truncates the variable the same way as CFSET does. I can't think why. I suppose the next step is to write code that will replace all " and / with "" and // ? I can't believe there's not a quick, built in way to do this. Anyone have any other suggestions? -Gel -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Gel, Couldn't you use cfsavecontent instead of cfset? -d --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.559 / Virus Database: 351 - Release Date: 1/7/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Structures native order
> That's a thought. I am caching the query and was storing the > structure in the application scope. Never make things more complicated than they need to be. 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]
Re:CF Datasource
Drew, Check this out, http://www.cfcomet.com/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9004033E03EF9 A query may be like: SELECT * FROM "Sheet1$" -- or the ACTUAL sheet name HIH Don Li a Must-have for MS SQL Server database http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=14&threadid=751833 >I am trying to set up a DSN in CF5 running on a Windows 2003 server to >either an excel spreadsheet, or csv file and have had no luck. >If you have had a similar experience of frustration and might know of >something I could be doing wrong, please let me know. > >Thank you, >Drew Harris >CEO: Quantum Delta >me: http://QuantumDelta.com/files/DrewHarris.vcf >my company: http://QuantumDelta.com > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ID key in SQL table
We all learn, thanks. >I was wrong, it's not just INT that Identity can be on (so it's not >assumed) > >You can also put Identity on bigint, decimal, numeric, smallint and >tinyint > >It's an attribute of the field, not of the type > >> -Original Message- >> From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] >> Sent: Monday, January 12, 2004 11:20 AM >> To: CF-Talk >> Subject: Re:ID key in SQL table >> >> >> I believe with MS SQL Server, Identity is an attribute to INT >> data type, hence, the following works >> >> -- DDL >> -- col of INT type without identity attribute >> create table #tbl (col int primary key); >> >> -- DDL >> -- col of INT type with identity, default to 1,1 even without >> say Identity(1,1) create table #tbl2 (col int identity primary key); >> >> But this one won't >> create table #tbl3 (col identity primary key); >> >> >> Philip, I don't mean to be rude. By the definition of >> Primary Key, >> >> the [ID] can not be NULL, hence, [ID] int identity Primary >> Key would >> >> do >> > >> >Actually, by definition an Indentity is an Int >> > >> >So "[ID] identity primary key" would do >> > >> >But if you want to get to the proper specifics, it should be >> > >> >[ID] int not null identity(1,1) primary key >> > >> > >> > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 Updater
Thanks, I had not heard of one, but found a mention on Macromedia's web site while trying to figure out the CFPOP issue I am running into (CFFile Move Error message). Further searching did not turn up anything though. Thanks again. -- Jeff -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 12:55 PM To: CF-Talk Subject: RE: CFMX 6.1 Updater > Anybody know where I can find the updater that was released > for CFMX 6.1? I have searched Macromedia and cannot find it. There is no updater for CFMX 6.1. You can download 6.1 in its entirety, and upgrade your 6.0 or earlier servers. There are hotfixes for 6.1: http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm 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]
Domain Cookie expiration?
All-- We have a load-balanced CF5 app using client variables on a pair of Win2K/Apache 1.3.x web servers. We need the session to expire when the user closes their browser and are manually resetting the CFID/CFTOKEN session cookies. But when we enable the SETDOMAINCOOKIE option in the CFAPPLICATION tag, the domain cookie seems to be forcing its expiration date onto the session cookies. Is there a way to bypass this behavior or to make the domain cookie expire when the browser closes? Can I rewrite the domain cookie (CFMagic, I think?) in the same way as the session cookies? Thanks, Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Structures native order
That's a thought. I am caching the query and was storing the structure in the application scope. Dan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 1:44 PM To: CF-Talk Subject: RE: Structures native order > This sounds to me like a good case for a combo array/structure. Why not just access the query object when you need the values? 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]
RE: CFMX 6.1 Updater
> Anybody know where I can find the updater that was released > for CFMX 6.1? I have searched Macromedia and cannot find it. There is no updater for CFMX 6.1. You can download 6.1 in its entirety, and upgrade your 6.0 or earlier servers. There are hotfixes for 6.1: http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm 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]
unspecified error
I get an "unspecified error" when I try to open a table in SQL. It was created by this script in a CF file: Create table trial (ID int not NULL PRIMARY KEY IDENTITY, Orderdate Char (50) not null, Institution Char (50) not null, Customer Char (50) not null, address Char (50) not null, city Char (10) not null, state Char (10) not null, zip Char (5) not null, phone Char (8) not null, login Char (10) not null, email1 Char (50) not null) Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1 Updater
Anybody know where I can find the updater that was released for CFMX 6.1? I have searched Macromedia and cannot find it. Thanks, -- Jeff [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. Why not just access the query object when you need the values? 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]
curiousity: CF IM
What would you recommend if I wanted to implement cfsession-based IM? (presence and messaging) I'm experimenting with several things, and I'm wondering what everyone thinks on the matter My biggest goals are minimizing server performance and not using unpublished macromedia API's to play around with sessions. I'm looking for your typical functionality: Buddy list, presence, and messaging. Any nice lightweight CFC's out there, or advice? I'm strongly leaning towards a jabber server, with CF implementation to connect client (or component) connections to it. The main plus with that is that I can use it with a standalone client as well. All advice/comments are welcome. Thanks -Dov NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Nested Tree SQL Sorting
You can do this with a single mySQL (or any other platform) query, but it will need some help from CF. There are two options. CFX_fMakeTree will order the query the fastest. Its better than cfx_maketree in that it will preserve your query sort order. Our fearless list admin wrote a slick little cf tag that will do the job quite neatly and almost as fast. Its cf_MakeTree and its on the houseoffusion.com site somewhere, I think. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Structures native order
I'll try that. Thank you very much, Dan -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 1:24 PM To: CF-Talk Subject: 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]
RE: Two Destinations for POST form?
#cfhttp.filecontent# after -Dov _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 1:15 PM To: CF-Talk Subject: RE: Two Destinations for POST form? Mike, Thanks, I'm making progress now with CFHTTP and CFHTTPPARAM. One problem remains: I'd prefer for the user to see the results of the SMS send, rather than the results of the DB update which is all I can seem to get returned to the user - is there anyway to set CFHTTP to make sure all that is returned from the user is the result of the remote form post? Here is what I've got: VALUE="#Form.gw_pin#"> VALUE="#Form.mesg_to_send#"> VALUE="#Form.mesg_to_send#"> VALUE="html/sendresult.html"> datasource="#request.app.dsn#"> UPDATE RAS.TABLE_CALL_LOG SET X_CALL_LOG_NOTES = CFSQLType="CF_SQL_CHAR"> WHERE X_CALL_LOG_ID = CFSQLType="CF_SQL_NUMERIC">; -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: 12 January 2004 12:51 pm To: CF-Talk Subject: RE: Two Destinations for POST form? Do an initial post to a local page, then insert these details. Then you can do a CFHTTP post to the SMS provider HTH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 12:47 To: CF-Talk Subject: Two Destinations for POST form? Afternoon all, I trust you had a good weekend? I've got a form that sends a textarea message to an SMS service. This is simple enough, but I want to record the very same message (and who sent it) on the local site's database, meaning the form would have to POST to two destinations. Is this possible? Any ideas? Cheers, Rob _ _ [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]
RE: Two Destinations for POST form?
> Thanks, I'm making progress now with CFHTTP and CFHTTPPARAM. > One problem remains: I'd prefer for the user to see the > results of the SMS send, rather than the results of the DB > update which is all I can seem to get returned to the user - > is there anyway to set CFHTTP to make sure all that is > returned from the user is the result of the remote form post? Yes, you can display the variable CFHTTP.FileContent if you want the user to see it. You'd probably want to just parse out the things you want to show, though, instead of showing the whole returned page. > Here is what I've got: > > > > > > VALUE="#Form.gw_pin#"> > > NAME="mesg_to_send" VALUE="#Form.mesg_to_send#"> > > VALUE="#Form.mesg_to_send#"> > > VALUE="html/sendresult.html"> > > > datasource="#request.app.dsn#"> > UPDATE RAS.TABLE_CALL_LOG > SET X_CALL_LOG_NOTES = > value="#Form.mesg_to_send#" CFSQLType="CF_SQL_CHAR"> > WHERE X_CALL_LOG_ID = > CFSQLType="CF_SQL_NUMERIC">; > > > > > > > > > > > I would strongly recommend that you don't place your CFHTTP within your CFTRANSACTION tags. CFHTTP doesn't interact with your database, and there's no need to keep your database waiting around while it runs. In addition, you don't need a CFTRANSACTION at all in this case, since there's only one query. Try something like this: Sorry, it didn't work. #CFHTTP.FileContent# 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]
Re:Structures native order
I agree that my original choice of structure over array may not have been correct, but I might have been using the structure elsewhere in the app to seek a value based on the key. That's good to know though that you cannot count on the order and i will avoid it in the future. Thansk, Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Two Destinations for POST form?
Mike, Thanks, I'm making progress now with CFHTTP and CFHTTPPARAM. One problem remains: I'd prefer for the user to see the results of the SMS send, rather than the results of the DB update which is all I can seem to get returned to the user - is there anyway to set CFHTTP to make sure all that is returned from the user is the result of the remote form post? Here is what I've got: UPDATE RAS.TABLE_CALL_LOG SET X_CALL_LOG_NOTES = WHERE X_CALL_LOG_ID = ; -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: 12 January 2004 12:51 pm To: CF-Talk Subject: RE: Two Destinations for POST form? Do an initial post to a local page, then insert these details. Then you can do a CFHTTP post to the SMS provider HTH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 12:47 To: CF-Talk Subject: Two Destinations for POST form? Afternoon all, I trust you had a good weekend? I've got a form that sends a textarea message to an SMS service. This is simple enough, but I want to record the very same message (and who sent it) on the local site's database, meaning the form would have to POST to two destinations. Is this possible? Any ideas? Cheers, Rob _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Detecting SQL Update success
Is there a way to detect if a SQL update statement in resulted in a record being updated? I guess I would want to know the number of rows updated. Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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]
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. Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT:Test (Please ignore)
Test [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Datasource
I am trying to set up a DSN in CF5 running on a Windows 2003 server to either an excel spreadsheet, or csv file and have had no luck. If you have had a similar experience of frustration and might know of something I could be doing wrong, please let me know. Thank you, Drew Harris CEO: Quantum Delta me: http://QuantumDelta.com/files/DrewHarris.vcf my company: http://QuantumDelta.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: What are ColdFusion developers doing with Web Services?
On Monday, January 12, 2004, at 12:15 PM, Daniel O'Keefe wrote: > What would be an example of the type of functionality you would use a > web service for in this case? I sometimes like to provide a Flash front-end alternative to CF/HTML apps. I think some functionality is better expressed in Flash and some better in CF/HTML. I like to try to get the best of both worlds. Web services are a great way for Flash to hook into the CF back-end. In terms of pure CF applications: 1. I added web services to MXNA (http://www.markme.com/mxna) so that people could write their own presentation layers. (We haven't made the API public yet). 2. Community Vision (http://www.markme.com/vision) is exposed through web services which Mike Chambers leveraged for a Central application. 3. I wrote an application for internal use called Community Resource Directory which has 100% of its functionality exposed through web services. This allows the CF front end to be hosted on different servers throughout the company while I maintain the bulk of the application on an internal community server. In general, allowing communities to write their own code on top of a set of core services has a lot of interesting potential. In the case of eBay, it has translated directly into serious revenue. I don't know about Amazon and Google, but I'm guessing it will eventually bring in money if it hasn't already. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Insert/Display special characters
Hi Guys,
I need to insert special characters like double quotes (") Copyright symbol
in the database, when these characters are copied from MS Word.
Copying from MS Word and Pasting in a textarea box results in some wierd
characters, but I want to retain all the original characters for inserting
in the database.
HTMLEditFormat is not working in this case.
Thanks a ton,
Milan
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: ID key in SQL table
I was wrong, it's not just INT that Identity can be on (so it's not assumed) You can also put Identity on bigint, decimal, numeric, smallint and tinyint It's an attribute of the field, not of the type > -Original Message- > From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] > Sent: Monday, January 12, 2004 11:20 AM > To: CF-Talk > Subject: Re:ID key in SQL table > > > I believe with MS SQL Server, Identity is an attribute to INT > data type, hence, the following works > > -- DDL > -- col of INT type without identity attribute > create table #tbl (col int primary key); > > -- DDL > -- col of INT type with identity, default to 1,1 even without > say Identity(1,1) create table #tbl2 (col int identity primary key); > > But this one won't > create table #tbl3 (col identity primary key); > > >> Philip, I don't mean to be rude. By the definition of > Primary Key, > >> the [ID] can not be NULL, hence, [ID] int identity Primary > Key would > >> do > > > >Actually, by definition an Indentity is an Int > > > >So "[ID] identity primary key" would do > > > >But if you want to get to the proper specifics, it should be > > > >[ID] int not null identity(1,1) primary key > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Padding zeros in SQL Server
I have had issues in the past with Excel-SQL DTS where it will still drop the leading zero, even into a varchar. In those cases I exported to Tab delimited text file first as in interim step. You might want to try that from Access, and then you can open the text file and ensure they are in there. Then use DTS to transfer from the text file to SQL. Dan Dave, When I import the table form access I can not get the zeros to remain in tact in the zipcode field no matter if I use char or varchar. Do you know a solution I could look into? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What are ColdFusion developers doing with Web Services?
Darn, Mikes line stripping truncated what I was responding to. I was responding to Christian's email and here it is: Dan > But even with 100% CF apps, there > is usually some kind of functionality I want to expose through a web > service. I think of it as just another application interface. -Original Message- From: Daniel O'Keefe [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 12:15 PM To: CF-Talk Subject: RE: What are ColdFusion developers doing with Web Services? What would be an example of the type of functionality you would use a web service for in this case? Dan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ID key in SQL table
I believe with MS SQL Server, Identity is an attribute to INT data type, hence, the following works -- DDL -- col of INT type without identity attribute create table #tbl (col int primary key); -- DDL -- col of INT type with identity, default to 1,1 even without say Identity(1,1) create table #tbl2 (col int identity primary key); But this one won't create table #tbl3 (col identity primary key); >> Philip, I don't mean to be rude. By the definition of >> Primary Key, the [ID] can not be NULL, hence, >> [ID] int identity Primary Key would do > >Actually, by definition an Indentity is an Int > >So "[ID] identity primary key" would do > >But if you want to get to the proper specifics, it should be > >[ID] int not null identity(1,1) primary key > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What are ColdFusion developers doing with Web Services?
What would be an example of the type of functionality you would use a web service for in this case? Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: amp%; within outlook 2000
Tim, What ver of Outlook are you using? Outlook 2003 defaults to Unicode, especially if you created a new personal folder in the 2003 format. Thanks, Mark _ From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 11:37 AM To: CF-Talk Subject: amp%; within outlook 2000 I'm running into issues with an html email that I send out that contains a url. I noticed that on outlook 2000 that the & is replaced with & and the variable isn't passed. The link works when opened with outlook 2002. Has anybody run into this before? Thanks, Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calendar Code
Thanks Christain for the info. I appreciate you accepting my emails off list. Mike - Original Message - From: Christian Cantrell To: CF-Talk Sent: Monday, January 12, 2004 11:26 AM Subject: Re: Calendar Code On Monday, January 12, 2004, at 11:19 AM, Mickael wrote: > What is DRK 3 sorry I have never heard about it? DRK = DevNet Resource Kit. It's a quarterly CD of components, custom tags, sample applications, etc. for several different products (ColdFusion, Flash and Dreamweaver, primarily). You can get information on DRK 3 here: http://www.macromedia.com/go/drk3 (For fear of doing too much promoting on this list, if you have any more questions, I would be happy to answer them off-list.) Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
amp%; within outlook 2000
I'm running into issues with an html email that I send out that contains a url. I noticed that on outlook 2000 that the & is replaced with & and the variable isn't passed. The link works when opened with outlook 2002. Has anybody run into this before? Thanks, Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: What are ColdFusion developers doing with Web Services?
On Sunday, January 11, 2004, at 05:34 PM, Ralph Ogden wrote: > I'd especially like to know if > anyone in the ColdFusion development community is even > doing much with Web Services. Just about everything I write these days exposes web services for one reason or another. I've been doing a lot of RIA development, which web services are obviously perfect for. But even with 100% CF apps, there is usually some kind of functionality I want to expose through a web service. I think of it as just another application interface. Big players like Amazon, eBay and Google have all seen the benefits (both technically and from a financial perspective) of exposing web services (or at least XML APIs). I think they are here to stay, and I personally can't imagine developing applications without them, at this point. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calendar Code
Development Resource Kits produced by Macromedia containing components based on their product line, you can get more information here: http://www.macromedia.com/software/drk/ I'm a DevNet Professional Subscriber, which gets these and a ton more and love it. - Calvin - Original Message - From: Mickael To: CF-Talk Sent: Monday, January 12, 2004 11:19 AM Subject: Re: Calendar Code Hi Christian, What is DRK 3 sorry I have never heard about it? - Original Message - From: Christian Cantrell To: CF-Talk Sent: Monday, January 12, 2004 11:06 AM Subject: Re: Calendar Code On Sunday, January 11, 2004, at 04:44 AM, Mickael wrote: > Hopefully someone can help me out. I am looking for some CF code for > a Calendar of Events. What I am looking for is the type of calendar > where the admin of the site can add HTML content via a form (with > something like HTMLedit) and enter items to a calendar for a specific > date. If you decide you want to roll your own, there is a calendar component on DRK 3. I used it to build a system similar to the one you are describing (it was actually a weblog, but it had similar functionality), and the calendar component gave me a big head start. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calendar Code
On Monday, January 12, 2004, at 11:19 AM, Mickael wrote: > What is DRK 3 sorry I have never heard about it? DRK = DevNet Resource Kit. It's a quarterly CD of components, custom tags, sample applications, etc. for several different products (ColdFusion, Flash and Dreamweaver, primarily). You can get information on DRK 3 here: http://www.macromedia.com/go/drk3 (For fear of doing too much promoting on this list, if you have any more questions, I would be happy to answer them off-list.) Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calendar Code
Hi Christian, What is DRK 3 sorry I have never heard about it? - Original Message - From: Christian Cantrell To: CF-Talk Sent: Monday, January 12, 2004 11:06 AM Subject: Re: Calendar Code On Sunday, January 11, 2004, at 04:44 AM, Mickael wrote: > Hopefully someone can help me out. I am looking for some CF code for > a Calendar of Events. What I am looking for is the type of calendar > where the admin of the site can add HTML content via a form (with > something like HTMLedit) and enter items to a calendar for a specific > date. If you decide you want to roll your own, there is a calendar component on DRK 3. I used it to build a system similar to the one you are describing (it was actually a weblog, but it had similar functionality), and the calendar component gave me a big head start. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Calendar Code
On Sunday, January 11, 2004, at 04:44 AM, Mickael wrote: > Hopefully someone can help me out. I am looking for some CF code for > a Calendar of Events. What I am looking for is the type of calendar > where the admin of the site can add HTML content via a form (with > something like HTMLedit) and enter items to a calendar for a specific > date. If you decide you want to roll your own, there is a calendar component on DRK 3. I used it to build a system similar to the one you are describing (it was actually a weblog, but it had similar functionality), and the calendar component gave me a big head start. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ID key in SQL table
> Philip, I don't mean to be rude. By the definition of > Primary Key, the [ID] can not be NULL, hence, > [ID] int identity Primary Key would do Actually, by definition an Indentity is an Int So "[ID] identity primary key" would do But if you want to get to the proper specifics, it should be [ID] int not null identity(1,1) primary key [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ColdfusionMX 6.1 where to download for a free version for development?
>Original Message: >> From: John Ho <[EMAIL PROTECTED]> > >> I currently run 6.0 for my web product. And I like to >> see what the difference in 6.1. Can someone show me >> where to download for a free version for development >> of ColdfusionMX 6.1. > >Have you tried: > Thank you all >http://www.macromedia.com/ > >? > >Scott > >--- >Scott Brady >http://www.scottbrady.net/ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: X separated values.
> Or (in MX) you could use the underlying Java base of CF and use the > split() function which returns an array: > > > > > > > BTW I wrote a CFC that is basically a wrapper fort a bunch of Java string functionalities: http://www.cfczone.org/cfcs/downloads/tmt_java_string.zip Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFile Move Error
I am working with a script that interacts with a mail server, reading messages from a specific POP account and processing them. The problem I am running into is dealing with the message attachments. In the store all attachments in a central folder with unique file names. Then during the processing, I am attempting to move them to different folders and rename them back to their original file names. I am getting the following error though on the to move and rename the files: 'Attribute validation error for tag CFFILE. The value of the attribute source which is currently "D:\attachments\fd4.dtd", is invalid.' However, if I copy this file path and paste it into the run window on the server (start -> run), the server returns the file - i.e. the path is valid. What am I missing here? -- index="attachmentIndex"> listGetAt(archiveMessages.attachmentFiles, attachmentIndex, ' ')> attachmentIndex, ' ')> destination="#variables.baseFilePath#\#friendlyUID#\#origAttachmentFileName# "> *** The list functions are parsing the attachment list using the TAB string as deliminators - that is just not appearing in the HTML message. -- Thanks, -- Jeff _ Jeff Chastain Web Applications Developer, Consultant Certified Macromedia ColdFusion Developer FBXSolutions http://www.fbxsolutions.com email: [EMAIL PROTECTED] phone: 469.964.2047 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: X separated values.
> No, there isn't. However, you could easily write your own > code to loop as long as "customwhatever" is found in the > string. Or (in MX) you could use the underlying Java base of CF and use the split() function which returns an array: Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1753 626 654 Switchboard : 0800 294 2424 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: X separated values.
> Just an fyi, if yo uknow the name of a UDF, you can quickly find it by using > this syntax: > > www.cflib.org/udf.cfm/NAME > > The above link could have been this as well: www.cflib.org/udf.cfm/split > > This way you don't have to do a search. > Thanks for the tip. This time I took the url directely from my RSS reader, since the UDF was still quite recent :-) Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_image help?
I'm not wild about the look of the thumbnail either, but it does everything else I want it to do (reduce if >100px, won't enlarge if it's <100px) easily... Philip Arnold wrote: > > I'm using cfx_image on a project I'm working on (CF5/Win2K). It does > > what I need it to, more or less, but documentation is pretty spotty. > > One thing I want to change is thumbnail generation; is there > > any way to > > make the auto-generated thumbnails NOT have the beveled edge > > effect, and > > also is there a way to define the background color to use (I > > want white)? > > > > Has anyone written an in-depth guide to cfx_image that would provide > > info on any other features not covered in the documentation included > > with cfx_image? > > I don't use the built-in thumbnail generation, instead I just run the > CFX_Image tag once to generate the thumbnail, then I do whatever else I > was doing (either move the file or resize it) > > I dislike their thumbnail design, so avoided it > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: ColdfusionMX 6.1 where to download for a free version for development?
Original Message: > From: John Ho <[EMAIL PROTECTED]> > I currently run 6.0 for my web product. And I like to > see what the difference in 6.1. Can someone show me > where to download for a free version for development > of ColdfusionMX 6.1. Have you tried: http://www.macromedia.com/ ? Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdfusionMX 6.1 where to download for a free version for development?
I wouldn't worry too much about it, really. you could development server it, but its fairly bulletproof, and doesn't really need to be tested. my .02 cents -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 10:15 AM To: CF-Talk Subject: ColdfusionMX 6.1 where to download for a free version for development? I currently run 6.0 for my web product. And I like to see what the difference in 6.1. Can someone show me where to download for a free version for development of ColdfusionMX 6.1. thanks __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdfusionMX 6.1 where to download for a free version for development?
Just download the regular ColdFusion MX 6.1 Enterprise, during install time you'll be able to specify that you want it to be the Developer Edition. --- Ben -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 10:15 AM To: CF-Talk Subject: ColdfusionMX 6.1 where to download for a free version for development? I currently run 6.0 for my web product. And I like to see what the difference in 6.1. Can someone show me where to download for a free version for development of ColdfusionMX 6.1. thanks __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ID key in SQL table
Philip, I don't mean to be rude. By the definition of Primary Key, the [ID] can not be NULL, hence, [ID] int identity Primary Key would do >> ID COUNTER not NULL PRIMARY KEY IDENTITY, > >Oops > >ID int not NULL PRIMARY KEY IDENTITY, > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdfusionMX 6.1 where to download for a free version for development?
I currently run 6.0 for my web product. And I like to see what the difference in 6.1. Can someone show me where to download for a free version for development of ColdfusionMX 6.1. thanks __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: X separated values.
Cheers Guys ! -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 January 2004 15:01 To: CF-Talk Subject: RE: X separated values. > > Is there an quick easy why to specify that the cfloop > should match the > > entire value not each character individually ? > > http://www.cflib.org/udf.cfm?ID=695 > Just an fyi, if yo uknow the name of a UDF, you can quickly find it by using this syntax: www.cflib.org/udf.cfm/NAME The above link could have been this as well: www.cflib.org/udf.cfm/split This way you don't have to do a search. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: X separated values.
> > Is there an quick easy why to specify that the cfloop > should match the > > entire value not each character individually ? > > http://www.cflib.org/udf.cfm?ID=695 > Just an fyi, if yo uknow the name of a UDF, you can quickly find it by using this syntax: www.cflib.org/udf.cfm/NAME The above link could have been this as well: www.cflib.org/udf.cfm/split This way you don't have to do a search. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: X separated values.
Yep, here is a UDF for it: http://www.cflib.org/udf.cfm/split [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: X separated values.
No, there isn't. However, you could easily write your own code to loop as long as "customwhatever" is found in the string. In fact, it is probably safe to say there is a UDF for this at cflib.org. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: X separated values.
> I'm looping over a list and specifying a custom delimiter, I want to be > able to allow the user to specify a delimiter of >1 characters however CF > seems to take each of these characters as a separate delimiter. e.g. > delimiters="ab" looks separates the list at an "a" or a "b" and not "ab". > > Is there an quick easy why to specify that the cfloop should match the > entire value not each character individually ? http://www.cflib.org/udf.cfm?ID=695 Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
X separated values.
Just a quicky, I'm looping over a list and specifying a custom delimiter, I want to be able to allow the user to specify a delimiter of >1 characters however CF seems to take each of these characters as a separate delimiter. e.g. delimiters="ab" looks separates the list at an "a" or a "b" and not "ab". Is there an quick easy why to specify that the cfloop should match the entire value not each character individually ? Cheers, Darren [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfx_image help?
> I'm using cfx_image on a project I'm working on (CF5/Win2K). It does > what I need it to, more or less, but documentation is pretty spotty. > One thing I want to change is thumbnail generation; is there > any way to > make the auto-generated thumbnails NOT have the beveled edge > effect, and > also is there a way to define the background color to use (I > want white)? > > Has anyone written an in-depth guide to cfx_image that would provide > info on any other features not covered in the documentation included > with cfx_image? I don't use the built-in thumbnail generation, instead I just run the CFX_Image tag once to generate the thumbnail, then I do whatever else I was doing (either move the file or resize it) I dislike their thumbnail design, so avoided it [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfx_image help?
I'm using cfx_image on a project I'm working on (CF5/Win2K). It does what I need it to, more or less, but documentation is pretty spotty. One thing I want to change is thumbnail generation; is there any way to make the auto-generated thumbnails NOT have the beveled edge effect, and also is there a way to define the background color to use (I want white)? Has anyone written an in-depth guide to cfx_image that would provide info on any other features not covered in the documentation included with cfx_image? Thanks, Pete [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ID key in SQL table
That did it! Thanks everyone for the reliable and quick help as usual. Robert O. -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 9:26 AM To: CF-Talk Subject: RE: ID key in SQL table > ID COUNTER not NULL PRIMARY KEY IDENTITY, Oops ID int not NULL PRIMARY KEY IDENTITY, _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ID key in SQL table
> ID COUNTER not NULL PRIMARY KEY IDENTITY, Oops ID int not NULL PRIMARY KEY IDENTITY, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ID key in SQL table
> datatype for SQL-server is identity (not counter) Actually, the datatype is Int, it just has an Identity property [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ID key in SQL table
ID COUNTER not NULL PRIMARY KEY IDENTITY, > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: Monday, January 12, 2004 9:05 AM > To: CF-Talk > Subject: ID key in SQL table > > > How do I create an SQL table and assign an Identity key in the syntax? > > What I have so far worked well with Access but will not work for SQL: > > Create table MTM > (ID COUNTER not NULL PRIMARY KEY, > Orderdate Char (50) not null, > Institution Char (50) not null, > Customer Char (50) not null) > > THX. > > Robert O. > HWW > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ID key in SQL table
datatype for SQL-server is identity (not counter) -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: maandag 12 januari 2004 15:05 To: CF-Talk Subject: ID key in SQL table How do I create an SQL table and assign an Identity key in the syntax? What I have so far worked well with Access but will not work for SQL: Create table MTM (ID COUNTER not NULL PRIMARY KEY, Orderdate Char (50) not null, Institution Char (50) not null, Customer Char (50) not null) THX. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ID key in SQL table
How do I create an SQL table and assign an Identity key in the syntax? What I have so far worked well with Access but will not work for SQL: Create table MTM (ID COUNTER not NULL PRIMARY KEY, Orderdate Char (50) not null, Institution Char (50) not null, Customer Char (50) not null) THX. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Nested Tree SQL Sorting
AFAIK MySQL can't do that -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED] Sent: maandag 12 januari 2004 13:09 To: CF-Talk Subject: RE: Nested Tree SQL Sorting Sorry forgot to add I am using MySQL. -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 12 January 2004 11:58 To: CF-Talk Subject: RE: Nested Tree SQL Sorting What DB? -Original Message- From: Mike Connolly [mailto:[EMAIL PROTECTED] Sent: maandag 12 januari 2004 12:38 To: CF-Talk Subject: Nested Tree SQL Sorting I have a simple table with the following kind of structure: TYPES + TypeID + ParentID + Title This table stores a nested tree of types. I would like to know if it is possible from a single SQL query to return my types in the following order: TYPE 1 -- sub-type 1 -- sub-type 2 TYPE 2 -- sub-type 3 -- sub-sub-type 1 -- sub-sub-type 2 -- sub-sub-sub-type 1 -- sub-type 3 -- sub-type 4 -- sub-sub-type 3 ...etc Regards Mike _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Webservice & Flash MX
On Saturday 15 Nov 2003 21:23 pm, Taco Fleur wrote: > Is it possible to for example have a Flash client talk to a CF Webservice > (yes) and have the CF Webservice talk back to multiple Flash MX clients (?) Web services are client-push, so no, not unless the client polls the server every so often too see if there is anything pending. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: What are ColdFusion developers doing with Web Services?
Ralph Ogden wrote: > > In addition to seeking recommendations for training in > Web Service protocols, I'd especially like to know if > anyone in the ColdFusion development community is even > doing much with Web Services. Ralph, We only recently started using web services here in my department at Duke - and primarily only because we're doing Flash development now (post-MAX). The average web site doesn't really have a whole lot of need for web services, if you ask me... at least not for serving them... If I was still maintaining awarestore.com I might build a web service to allow them to syndicate content and production information to their affiliates I've got some neighborhood web sites where I might consume a weather-oriented web service but haven't gotten around to it yet. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Two Destinations for POST form?
Do an initial post to a local page, then insert these details. Then you can do a CFHTTP post to the SMS provider HTH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 12:47 To: CF-Talk Subject: Two Destinations for POST form? Afternoon all, I trust you had a good weekend? I've got a form that sends a textarea message to an SMS service. This is simple enough, but I want to record the very same message (and who sent it) on the local site's database, meaning the form would have to POST to two destinations. Is this possible? Any ideas? Cheers, Rob _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Two Destinations for POST form?
Afternoon all, I trust you had a good weekend? I've got a form that sends a textarea message to an SMS service. This is simple enough, but I want to record the very same message (and who sent it) on the local site's database, meaning the form would have to POST to two destinations. Is this possible? Any ideas? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
