onTap Framework 3.0 - p.s. I'm not dead
I've had several people contact me in the last couple months to inquire about the framework, which had been on something of a hiatus due to various circumstances on my end. So -- yes I'm still maintaining it, no I'm not dead. :) I just reset my subscription to the cf-talk list to receive emails signed up on RIAForge this week and set up a project there so Ray can host my SVN repository, etc. because I couldn't afford to maintain my dedicated server last year and had to let it go. There's more info about the latest version and about what's been going on with me on the riaforge blog: http://ontap.riaforge.org/blog/index.cfm/2007/12/18 p.s. thanks for the emails -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294984 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Exclusive locks still producing duplicate values
Can we see your locking code? Adrian -Original Message- From: Dave Sent: 17 December 2007 22:03 To: CF-Talk Subject: Exclusive locks still producing duplicate values We have have an issue here that I thought I had solved via locking and transactions, but it appears that the issue still exists. Basically, our clients go through an order entry process that produces a numbered requisition. The number is based upon a value that is stored in the database for each client. Multiple users of the same client can obviously place orders simultaneously all drawing their base number from the same location. The section of code that actually creates the req number and stores the data is run within a serialized transaction that sits within an exclusive named lock. If I'm understanding locking correctly, the exclusive named lock should prevent any other execution of that same code within the same application. The serialized transaction should restrict access to the tables required to that single transaction, again if I'm understanding it correctly. The requisition number is actually created in a function invoked within this lock/transaction block so it should be restricted from use until the lock is released. The problem is that we still seem to be getting duplicate requisition numbers generated through this process. There are several ways to reach the point of creating the order, but the final order build is all processed through this code. There must be something that I am missing, but I can't for the life of me see what it is. Any help is appreciated. TYIA David Phelan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFHTTP and Caching
Hi Paul Thanks I have tried the following where it should cache the feed in the application.cfm page every 20 minutes but I am getting the error Error Occurred While Processing Request Element TIMESTAMP is undefined in APPLICATION. Any ideas on where I am going wrong ? --- In my application.cfm CFIF (APPLICATION.TimeStamp EQ ) OR (DateDiff(n, APPLICATION.TimeStamp, TimeFormat(NOW(), hh:mm:s)) GT 20) CFSET APPLICATION.TimeStamp = CreateTime(TimeFormat(NOW(), hh), TimeFormat(NOW(), mm), TimeFormat(NOW(), s)) CFSET APPLICATION.weather_xml =XMLParse(cfhttp.FileContent) cfhttp url=http://feeds.bbc.co.uk/weather/feeds/rss/5day/world/0008.xml; method=GET resolveurl=No/cfhttp /CFIF In my display page I have the following code cfoutput img src=#application.weather_xml.rss.channel.image.url.xmlText# alt=#application.weather_xml.rss.channel.item.DESCRIPTION.xmlText# cfloop index=x from=1 to=#ArrayLen(application.weather_xml.rss.channel.item)# br #replace(application.weather_xml.rss.channel.item[x].title.xmlText, ',', 'br', 'ALL')# br /cfloop /cfoutput -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: 13 December 2007 15:07 To: CF-Talk Subject: RE: CFHTTP and Caching However what can I use in Coldfusion to cache this CFHTTP request (every 2 hours)so that it does not request the RSS feed every time a user loads our webpage? Any ideas if this is possible ? We do this all the time, here are a couple of possibilities... Save the RSS feed to the DB or the application scope or somewhere reasonably persistent with a date of last retrieval associated with it. Then when x hours have elapsed get the data again. For the most part, you'll be using the DB or application scope to access the RSS feed... Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading NMEA-183 Messages off Com Port w CF?
Just find anything that can read data off a COM port. Then modify it into a a gateway following the directory watcher code. Adam Haskell On Dec 14, 2007 7:21 PM, Matthew Reinbold [EMAIL PROTECTED] wrote: Hello All, I've currently got a client that wants a web based application running locally on the machine (pull forms up and enter data using good old 127.0.0.1). The only rub is that I need to read GPS data off a com port. The information is standardized (National Maritime Electronics Association has speced out a standard, also known as NMEA-183) for GPS devices. It includes asynchronous data, checksums, etc. I was hoping there would be a Java library out there that I could invoke with a CFC and grab information out but, unfortunately, Google is failing at the moment. I did find a 0.1 Java NMEA 0183 Parser library ( http://www.teilo.net/software/NMEA0183Parser/) but, unfortunately, there is no source code and the license forbids commercial use. I did find Log NMEA which has basic Java source code to read data on a com port and dump it to a text file - primitive for what I want to do but its a start. Are there any other resources out there that I would be able to use in conjunction with ColdFusion? Is there a Java library that can be redistributed with a commercial app? Matthew Reinbold Creative Principal, Vox Pop Design, http://voxpopdesign.com SLCFUG Manager, Salt Lake ColdFusion User Group, http://slcfug.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP and Caching
On Tuesday 18 Dec 2007, Ian Vaughan wrote: Any ideas on where I am going wrong ? structKeyExists() or similar -- Tom Chiverton Helping to conveniently synthesize enterprise niches on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Exclusive locks still producing duplicate values
Dave, We have have an issue here that I thought I had solved via locking and transactions, but it appears that the issue still exists. Basically, our clients go through an order entry process that produces a numbered requisition. The number is based upon a value that is stored in the database for each client. Multiple users of the same client can obviously place orders simultaneously all drawing their base number from the same location. The section of code that actually creates the req number and stores the data is run within a serialized transaction that sits within an exclusive named lock. If I'm understanding locking correctly, the exclusive named lock should prevent any other execution of that same code within the same application. The serialized transaction should restrict access to the tables required to that single transaction, again if I'm understanding it correctly. Also, if you're generating this Request number on a page before you actually submit to database, then a user clicking the submit multiple times would generate duplicate records with the same request number. Example: on Page A you generate the request number so you can display it to the user. Page A allows the user to confirm the creation process. When the user clicks the submit button, it goes to Page B which actually inserts the data into the database. If the user clicks the submit button multiple times it can create multiple requests. Are you ever storing this request number in any scope (Session, Form, Url, etc?) Also, are you absolutely positive your code is returning unique numbers? You're locking may be working, but if there's an error in the logic you could still produce duplicate request numbers. For example, let's say you were creating a number based upon the current date time stamp: cfset dtNow = dateFormat(now(), mmdd) timeFormat(now(), HHmmss) / cflock !--// insert unique number //-- /cflock By creating the dtNow number outside of the lock, I'm opening myself up to duplicate values. This is just an example... -Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: memory issues
Jonathon, Robi Sen has some excellent information on memory issues like you're experiencing: http://www.robisen.com/index.cfm?mode=entryentry=FD4BE2FC-55DC-F2B1-FED0717 CC1C7E0AF Are you using the default JRE? If so, you might consider upgrading to JRE SDK 1.4.2_13--which I believe is the most recent version that CF officially supports. Also, prior to CF8 the cffile / implementation for reading files was notoriously problematic when reading large files (although it should be ok on files from the 200K to 5MB range.) Java is just not really good with large strings--it's always been a weakness of the language. You might want to consider going straight to Java to read a file line-by-line (instead of the entire file.) Here's a UDF from CFlib that shows reading a file by line: http://www.cflib.org/udf.cfm?id=417enable=1 This might help you reduce the memory needed for each request. Lastly, make sure you're caching whatever results you can. If you're constantly parsing the same files over and over, just cache the results once you've generated them. There's no reason to keep doing expensive CPU operations if it's unnecessary. -Dan -Original Message- From: Jonathon Stierman [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 10:58 PM To: CF-Talk Subject: memory issues An application of mine has recently been acting up -- memory has been shooting up at a fairly rapid pace this past week, and I'm at my wits end! Can't seem to find any way to fix it. Here's the symptoms: After rebooting the CF service, memory starts out at about 60mb for the jrun.exe process. After that all hell breaks loose ;) It continues to consume about 4 megs a minute until it plateau's at about 590mb. At that point, the server starts delivering 500 null errors, and my application/exception.log files fill up with java.lang.OutOfMemoryError messages. The site gets a couple hits a second, and those hits are fairly heavy in processing. Most involve file-reading and then parsing that file for the relevant data. I have downloaded a trial version of FusionReactor and got that set up on the system. If I'm reading it right, it looks like every request coming in is consuming large amounts of memory. I can understand why they'd take up lots of memory -- each one has to read a text file that is between 200k and 5 megs, and that seems to correlate with the memory jumps -- but why wouldn't that memory be released after the request is complete? It just keeps piling up. Is this to be expected from high volumes of file-reading/parsing requests? What advice can you give for getting some of that memory free and available? Server monitoring and tweaking is definitely not my forte -- any help and knowledge will be much appreciated! TIA! Oh -- incase the box info helps. It's a Windows Server 2003 dedicated server, running CFMX7 Standard. Jonathon ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: QofQ insert
Thanks for the replies. Yes, I was just tring not to do a possible 1k db calls. Just tring to cut down on the network traffic. I will do a few test runs and see if there is enough of a performance improvement to not do the loop. Thanks Rodney -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 4:38 PM To: CF-Talk Subject: RE: QofQ insert I do not believe what you are looking for is possible. Depending on your DBMS you have a couple different options. Instead of creating a query object, perhaps you could re-factor your code to insert into a table variable in a cfquery tag and then to the insert from there. Another solution would be to serialize the query object into XML, and pass it into a proc or SQL statement where the XML could be parsed on the SQL server into a result set and do your insert from their. That would be pretty dependant on SQL Server 2000, or 2005 though. Why are you opposed to looping over the result set? If you are trying to avoid a performance problem, the methods above wouldn't be much better since they all involve looping at some level. You could at least try to minimalize locks open on the table by doing the insert all at once as opposed to one at a time. You could move the cfloop inside the cfquery and produce sql like such: Insert into table (col1, col2) (select 'foo1', 'bar1' Union all select 'foo2', 'bar2' Union all select 'foo3', 'bar3' Union all select 'foo'4, 'bar4') ~Brad -Original Message- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Whitepaper, article, blog on cf8 UI tags and Presentation tags
Hi, I'm looking for some whitepaper-like writing on the intricacy of cf8's UI tags such as cflayout, cfwindow, cfpod, then, for the presentation part, cfpresentation etc. Adobe's devnet has some basic thing going... googling results unsatisfactory, any thoughts/points would be much appreciated. Oh, with business use case would be much much more desirable... Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF forums
Bryan Stevenson wrote: I of course know nothing else will be in our custom methodology/frameworkI just don't want Fusebox. Save your fingers and don't waste everyone's time stating the obvious. I don't mean to be harsh, but come on guys!! ;-) Hey you started it. :) -Cameron ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using Mac Mini as web server
I'm going to be using a Mac Mini running Leopard as a local development and web server. I'm still in the process of getting it set up, and getting files transferred over to it. Last night I went to put some files from my PC over to the Mini and it said that it couldn't connect. It didn't even give me a login screen. So I clicked over to the Mini on my KVM switch and the Mini was asleep. I woke it up, and all of a sudden I could connect to it from the PC. So my question is, will this happen everytime the Mac goes to sleep? How can I prevent this from happening? I need for the Mini to be always on as my wife and I will both be using the file server for access. I don't ever want to have to manually wake up the Mini, and I would prefer to have my login stored for as long as the Mini is running. If it gets restarted, then that's one thing, but I don't want to have to login each time I try to connect to it. Can anyone shed some light on this? Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF forums
FuseTalk is *not* written with Fusebox This is con*fuse*ing ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294995 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What is happening to my request variables?
Todd wrote: Why are you using: cfargument name = request required=true/? This turned out to be the problem. Apparently I got hold of some old|incorrect documentation. Digging further I see that this should be 'requestName'? Anyway changing this resolved my issue. P.S. I posted several replies yesterday, but they all disappeared into void. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Exclusive locks still producing duplicate values
SorryKnew I was forgetting something. cflock name=#session.st#ProcessLock timeout=20 type=exclusive CFTRANSACTION isolation=serializable action=begin cfif IsDefined(session.Order.ReqNumber) cfset RequisitionNumber=session.Order.ReqNumber cfelse cfinvoke component=ReqNumbering method=GetNumber clientBasedPID=#ClientBasedPID# returnvariable=RequisitionNumber cfif RequisitionNumber is 0 cftransaction action=rollback/ cfset TransactionFailure=1 cfexit method=exittag /cfif /cfif cfstoredproc procedure=LTCalls_LoadTable datasource=#session.datasource# returncode=true cfprocparam cfsqltype=CF_SQL_VARCHAR type=in value=reqs!--- Table To Update --- cfprocparam cfsqltype=CF_SQL_LONGVARCHAR type=in value=#FieldValuePairs#!--- List of Field/Value Pairs --- cfprocparam cfsqltype=CF_SQL_CHAR type=in value=!--- ID of Row to Update --- cfprocparam cfsqltype=CF_SQL_CHAR type=in value=|^|!--- Field/Value Pair Delimiter --- cfprocparam cfsqltype=CF_SQL_CHAR type=in value=|=|!--- Field/Value Delimiter --- /cfstoredproc cfif cfstoredproc.statusCode eq 0 !---retrieves the req number--- cftransaction action=commit/ cfelse cftransaction action=rollback/ cfset TransactionFailure=1 /cfif /cftransaction /cflock -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 5:34 AM To: CF-Talk Subject: RE: Exclusive locks still producing duplicate values Can we see your locking code? Adrian -Original Message- From: Dave Sent: 17 December 2007 22:03 To: CF-Talk Subject: Exclusive locks still producing duplicate values We have have an issue here that I thought I had solved via locking and transactions, but it appears that the issue still exists. Basically, our clients go through an order entry process that produces a numbered requisition. The number is based upon a value that is stored in the database for each client. Multiple users of the same client can obviously place orders simultaneously all drawing their base number from the same location. The section of code that actually creates the req number and stores the data is run within a serialized transaction that sits within an exclusive named lock. If I'm understanding locking correctly, the exclusive named lock should prevent any other execution of that same code within the same application. The serialized transaction should restrict access to the tables required to that single transaction, again if I'm understanding it correctly. The requisition number is actually created in a function invoked within this lock/transaction block so it should be restricted from use until the lock is released. The problem is that we still seem to be getting duplicate requisition numbers generated through this process. There are several ways to reach the point of creating the order, but the final order build is all processed through this code. There must be something that I am missing, but I can't for the life of me see what it is. Any help is appreciated. TYIA David Phelan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: memory issues
Thanks Dale, Dustin and Andrew! I'll try clearing out the variables manually and see if that helps. Jonathon -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 10:48 PM To: CF-Talk Subject: RE: memory issues I will second that, the one thing (and yes I will include me on this one) is that even though the Garbage collection does a good job. Under heavy load it is not smart enough to know what we want when we want it. And it is a trap that most do not think about. So in the old days of allocating memory in C/C++, it is also a good idea to destroy a variable as soon as it is no longer needed. I am not saying all, but at least in cases like this. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Exclusive locks still producing duplicate values
cflock name=#session.st#ProcessLock timeout=20 type=exclusive I'm taking a bit of a guess here, but I think your name may be the problem. I'm assuming that by having a session variable in the name, each user will have a different name for the lock. Named locks are only locked from blocks with the same name. If each user is getting a unique name, then the block will not be locked between users. That is my understanding of locks at least. If this is the case, you want a single, discreet name for the lock so that all users use the same named lock and thus can only use the block of code one at a time, which I believe is your requirement. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFDOCUMENT creating a PDF - ARGH!
I'm trying to use CFDOCUMENT (CF 7 with updates) to create PDF files for a client. If I remove the CFDOCUMENT tags surrounding my code, the page renders fine. Put the CFDOCUMENT back in and the page falls apart - CSS is ignored. So, I've got something wrong somewhere. Is the basic format for creating a PDF page below correct? Is the problem the way the CSS file is referenced? How else should I try to do that? --- START OF TEMPLATE - QUERIES HERE- cfdocument format=PDF mimetype=text/html html xmlns=http://www.w3.org/1999/xhtml; head link rel=stylesheet type=text/css href=css/makePDF.css / /head body - OUTPUT BLOCK - STANDARD CFOUTPUT AND STUFF - /body /html /cfdocument -- END OF TEMPLATE - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295000 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Exclusive locks still producing duplicate values
cflock name=#session.st#ProcessLock Here is your problem: if your using any session value in the lock name, you're having one lock per user. You're actually protecting your code from multiple use by the same user, not by all users. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFDOCUMENT creating a PDF - ARGH!
Are you using overflow: auto in your CSS anywhere? Rupesh Kumar found some bugs in cfdocument when overflow was set to auto: http://coldfused.blogspot.com/search/label/cfdocument http://coldfused.blogspot.com/2007/12/missing-text-in-pdf-created-by.html http://coldfused.blogspot.com/2007/12/images-and-cfdocument-performance.html -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 9:39 AM To: CF-Talk Subject: CFDOCUMENT creating a PDF - ARGH! I'm trying to use CFDOCUMENT (CF 7 with updates) to create PDF files for a client. If I remove the CFDOCUMENT tags surrounding my code, the page renders fine. Put the CFDOCUMENT back in and the page falls apart - CSS is ignored. So, I've got something wrong somewhere. Is the basic format for creating a PDF page below correct? Is the problem the way the CSS file is referenced? How else should I try to do that? --- START OF TEMPLATE - QUERIES HERE- cfdocument format=PDF mimetype=text/html html xmlns=http://www.w3.org/1999/xhtml; head link rel=stylesheet type=text/css href=css/makePDF.css / /head body - OUTPUT BLOCK - STANDARD CFOUTPUT AND STUFF - /body /html /cfdocument -- END OF TEMPLATE - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
Put the actual css within style/style tags on the actual page. On Dec 18, 2007 10:39 AM, Les Mizzell [EMAIL PROTECTED] wrote: I'm trying to use CFDOCUMENT (CF 7 with updates) to create PDF files for a client. If I remove the CFDOCUMENT tags surrounding my code, the page renders fine. Put the CFDOCUMENT back in and the page falls apart - CSS is ignored. So, I've got something wrong somewhere. Is the basic format for creating a PDF page below correct? Is the problem the way the CSS file is referenced? How else should I try to do that? --- START OF TEMPLATE - QUERIES HERE- cfdocument format=PDF mimetype=text/html html xmlns=http://www.w3.org/1999/xhtml; head link rel=stylesheet type=text/css href=css/makePDF.css / /head body - OUTPUT BLOCK - STANDARD CFOUTPUT AND STUFF - /body /html /cfdocument ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
Les, Put the CSS include inside of the CFDOCUMENT tags, and then it will reference the CSS. Rob On Dec 18, 2007 10:39 AM, Les Mizzell [EMAIL PROTECTED] wrote: I'm trying to use CFDOCUMENT (CF 7 with updates) to create PDF files for a client. If I remove the CFDOCUMENT tags surrounding my code, the page renders fine. Put the CFDOCUMENT back in and the page falls apart - CSS is ignored. So, I've got something wrong somewhere. Is the basic format for creating a PDF page below correct? Is the problem the way the CSS file is referenced? How else should I try to do that? --- START OF TEMPLATE - QUERIES HERE- cfdocument format=PDF mimetype=text/html html xmlns=http://www.w3.org/1999/xhtml; head link rel=stylesheet type=text/css href=css/makePDF.css / /head body - OUTPUT BLOCK - STANDARD CFOUTPUT AND STUFF - /body /html /cfdocument -- END OF TEMPLATE - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: memory issues
but why wouldn't that memory be released after the request is complete? Where is this data being stored? Is there code to clear the data? I.E. If the application makes use of session variables for the data, it is not going to be cleared until after the session times out. That is twenty minutes by default but is often defined to be longer. If one is getting two hits a second averaging 2 megs a hit that is ~4,800 megs or 4.8 gigs of accumulated memory in even twenty minutes before the first request start timing out to be cleared. At this point, I think an investigation of the application and how it uses and releases memory is in order. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: memory issues
Using 1.4.2_12-b03. Not sure if that's the default JRE or not. I'll look into Robi's blog post. A line-by-line file reader could definitely help -- The idea being I'd only save into memory one line at a time and only keep the lines I want to display to the user. I hadn't thought of that solution! As far as caching -- after I left the office last night, I had the idea that might be part of the problem rather than the solution. I didn't remember the caching part until last night, but here's the jist of how it works: 1. User logs in and requests a file. 2. Application reads file, and builds a Query object out of it. Every line of the file is saved to the Query. 3. A SELECT statement is performed on the Query to only get the relevant data for that user (cached for 30 minutes) 4. Results of SELECT shown to user The caching was added to speed up the processing on that page, but I'm wondering if it's causing my memory issues. Assuming the Query object is probably about the same size as the file the user reads, then I'd be caching the 200kb-5mb for every user. Sounds great for CPU/speed performance, but not so good for memory conservation. Am I off my rocker, or could this be the culprit? Jonathon ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT creating a PDF - ARGH!
I found I got better results with CSS by cfinluding the file into a style block, instead of doing what you did. HTH. --Ben Doom Les Mizzell wrote: I'm trying to use CFDOCUMENT (CF 7 with updates) to create PDF files for a client. If I remove the CFDOCUMENT tags surrounding my code, the page renders fine. Put the CFDOCUMENT back in and the page falls apart - CSS is ignored. So, I've got something wrong somewhere. Is the basic format for creating a PDF page below correct? Is the problem the way the CSS file is referenced? How else should I try to do that? --- START OF TEMPLATE - QUERIES HERE- cfdocument format=PDF mimetype=text/html html xmlns=http://www.w3.org/1999/xhtml; head link rel=stylesheet type=text/css href=css/makePDF.css / /head body - OUTPUT BLOCK - STANDARD CFOUTPUT AND STUFF - /body /html /cfdocument -- END OF TEMPLATE - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Exclusive locks still producing duplicate values
Dan, We only create the requisition number prior or to the actual order placement in very specific circumstances and store it in a structure in the session scope, but those numbers are not being duplicated due to the very nature of the hows and whys. Only the numbers generated at the time of the order are having this issue. I see what you are saying about the multiple submits, but the exclusive named lock should be preventing the code that is generating the number from running more than once in the application at any given time. This should end up creating duplicate orders, but not duplicate request numbers. The generation of the number is where we are getting our duplicate values, but the logic around the generation of the number is fairly simple: Query the database for the next value Add a prefix or suffix and formatting depending on customer preference Increment and update the value in the database There are two clients that are generating part of the number in a Julian date format where we have done some manipulation to handle duplicate numbers. This is, however, happening across multiple higher volume clients. The simple read, increment, update clients are producing duplicate numbers from within a named exclusive lock inside a serialized transaction. I replied to an earlier request to include the lock/transaction block. All of this takes place within that block. Dave -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 8:20 AM To: CF-Talk Subject: RE: Exclusive locks still producing duplicate values Dave, Also, if you're generating this Request number on a page before you actually submit to database, then a user clicking the submit multiple times would generate duplicate records with the same request number. Example: on Page A you generate the request number so you can display it to the user. Page A allows the user to confirm the creation process. When the user clicks the submit button, it goes to Page B which actually inserts the data into the database. If the user clicks the submit button multiple times it can create multiple requests. Are you ever storing this request number in any scope (Session, Form, Url, etc?) Also, are you absolutely positive your code is returning unique numbers? You're locking may be working, but if there's an error in the logic you could still produce duplicate request numbers. For example, let's say you were creating a number based upon the current date time stamp: cfset dtNow = dateFormat(now(), mmdd) timeFormat(now(), HHmmss) / cflock !--// insert unique number //-- /cflock By creating the dtNow number outside of the lock, I'm opening myself up to duplicate values. This is just an example... -Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
head link rel=stylesheet type=text/css href=css/makePDF.css / /head Try an absolute path to your css file. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Exclusive locks still producing duplicate values
No..that particular value is the same across all users for a particular client and each client draws from its own seed value. Dave -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 10:44 AM To: CF-Talk Subject: Re: Exclusive locks still producing duplicate values cflock name=#session.st#ProcessLock Here is your problem: if your using any session value in the lock name, you're having one lock per user. You're actually protecting your code from multiple use by the same user, not by all users. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLOCATION, but with a form
Hello folks, As I understand it, cflocation sends a redirect to the browser, navigating it to a new page, potentially including url parameters. Is there any way to do a similar thing, but emulating a form, so passed parameters can be kept out of the url? Only thing I can think of is to render an actual html form, along with javascript to submit it. Is there an alternative? Thanks, Dave Merrill ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: memory issues
Am I off my rocker, or could this be the culprit? If you are storing .2 to 5mb of data per user for an unknown period of time, yes you are using a lot of memory. You have entered the relm of serious design where trade offs between file reads versus memory versus cpu time have to be weighed and considered. For a lot of sites there is more computing power in a modern server then the application will ever need. But when you are dealing with one as larger as yours this is not true and you the developer now have to consider the ramifications of code design. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 shopping cart tutorial
On Monday 17 Dec 2007, Ali Majdzadeh wrote: Hi everybody: I want to make a shopping cart with CF8 and MS ACCESS. No, you don't. Use a real database. -- Tom Chiverton Helping to assertively target front-end appliances on: http://thefalken.livejournal.com Halliwells wishes all of its clients and suppliers the Very Best for Christmas the New Year This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFDOCUMENT creating a PDF - ARGH!
I will 2nd that one, never had luck with paths to css files, I just style, works perfect. Chris -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 10:51 AM To: CF-Talk Subject: Re: CFDOCUMENT creating a PDF - ARGH! I found I got better results with CSS by cfinluding the file into a style block, instead of doing what you did. HTH. --Ben Doom Les Mizzell wrote: I'm trying to use CFDOCUMENT (CF 7 with updates) to create PDF files for a client. If I remove the CFDOCUMENT tags surrounding my code, the page renders fine. Put the CFDOCUMENT back in and the page falls apart - CSS is ignored. So, I've got something wrong somewhere. Is the basic format for creating a PDF page below correct? Is the problem the way the CSS file is referenced? How else should I try to do that? --- START OF TEMPLATE - QUERIES HERE- cfdocument format=PDF mimetype=text/html html xmlns=http://www.w3.org/1999/xhtml; head link rel=stylesheet type=text/css href=css/makePDF.css / /head body - OUTPUT BLOCK - STANDARD CFOUTPUT AND STUFF - /body /html /cfdocument -- END OF TEMPLATE - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295015 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
Jim Wright wrote: head link rel=stylesheet type=text/css href=css/makePDF.css / /head OK, so I'm trying it like this now: If I remove the CFDOCUMENT tag, the file renders exactly the way I want. Put it back in, I get a page of gibberish. cfquery name=makePDF datasource=#datasource# username=#username# password=#password# Select * FROM tmbCOLLECTIONS WHERE collection_id = '#url.pdfID#' /cfquery cfdocument format=pdf !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleUntitled Document/title style type=text/css !-- body { font-family: Verdana, Arial, Helvetica, sans-serif; text-align: center; } #PDFpage { width: 544px; margin: 0; text-align: left;} #PDFCARD { width: 136px; height: 170px; margin: 0; float: left; font-size: 9px; background: url(img/pdfCARD.gif) left top no-repeat; } #pdfCARDCONTAINER { width: 116px; margin: 0 12px 0 2px; padding: 0 0 0 4px; float: left; text-align: center; } #PDFCARD #cardTOP { width: 100%; height: 17px; padding: 1px 0 0 0; margin: 0; color: #FF; font-size: 10px; text-align: center; } #PDFCARD #prvNAME { width: 100%; height: 41px; padding: 9px 0 0 0; } #pdfCARD #prvAMNT { width: 100%; height: 15px; padding: 0; } #PDFCARD #prvTYPE { width: 100%; height: 25px; padding: 0; } #PDFCARD #prvINDUS { width: 100%; height: 31px; padding: 0; } #pdfCARD #prvDATE { width: 100%; height: 15px; text-align: center; padding: 0 8px; } -- /style /head body div id=PDFpage img src=http://www.MYSITE.com/imgPDF/pdfHEADER.gif; width=544 height=200 / cfoutput query=makePDF div id=PDFCARD div id=pdfCARDCONTAINER div id=cardTOPcfif makePDF.pending EQ pendingPending/cfif/div div id=prvNAME#makePDF.dsp_name#/div div id=prvAMNT#makePDF.dsp_amount# #makePDF.dsp_millthou#/div div id=prvTYPE#makePDF.deal_type#/div div id=prvINDUS#makePDF.dsp_industry#/div div id=prvDATE cfif (makePDF.showDAY EQ n or makePDF.showDAY EQ y) and makePDF.showMONTH EQ n#dateformat(makePDF.dsp_closedate, '')#/cfif cfif makePDF.showDAY EQ n and makePDF.showMONTH EQ y#dateformat(makePDF.dsp_closedate, ' ')#/cfif cfif makePDF.showDAY EQ y and makePDF.showMONTH EQ y#dateformat(makePDF.dsp_closedate, ' dd, ')#/cfif /div /div /div /cfoutput/div /body /html /cfdocument ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOCATION, but with a form
On Tuesday 18 Dec 2007, Dave Merrill wrote: As I understand it, cflocation sends a redirect to the browser, navigating it to a new page, potentially including url parameters. Is there any way to do a similar thing, but emulating a form, so passed parameters can be kept out of the url? Store them in the session, or as cookies. -- Tom Chiverton Helping to simultaneously coordinate user-centric communities on: http://thefalken.livejournal.com Halliwells wishes all of its clients and suppliers the Very Best for Christmas the New Year This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT creating a PDF - ARGH!
Les, You need a filename, otherwise it outputs to the page. Rob On Dec 18, 2007 11:13 AM, Les Mizzell [EMAIL PROTECTED] wrote: Jim Wright wrote: head link rel=stylesheet type=text/css href=css/makePDF.css / /head OK, so I'm trying it like this now: If I remove the CFDOCUMENT tag, the file renders exactly the way I want. Put it back in, I get a page of gibberish. cfquery name=makePDF datasource=#datasource# username=#username# password=#password# Select * FROM tmbCOLLECTIONS WHERE collection_id = '#url.pdfID#' /cfquery cfdocument format=pdf !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleUntitled Document/title style type=text/css !-- body { font-family: Verdana, Arial, Helvetica, sans-serif; text-align: center; } #PDFpage { width: 544px; margin: 0; text-align: left;} #PDFCARD { width: 136px; height: 170px; margin: 0; float: left; font-size: 9px; background: url(img/pdfCARD.gif) left top no-repeat; } #pdfCARDCONTAINER { width: 116px; margin: 0 12px 0 2px; padding: 0 0 0 4px; float: left; text-align: center; } #PDFCARD #cardTOP { width: 100%; height: 17px; padding: 1px 0 0 0; margin: 0; color: #FF; font-size: 10px; text-align: center; } #PDFCARD #prvNAME { width: 100%; height: 41px; padding: 9px 0 0 0; } #pdfCARD #prvAMNT { width: 100%; height: 15px; padding: 0; } #PDFCARD #prvTYPE { width: 100%; height: 25px; padding: 0; } #PDFCARD #prvINDUS { width: 100%; height: 31px; padding: 0; } #pdfCARD #prvDATE { width: 100%; height: 15px; text-align: center; padding: 0 8px; } -- /style /head body div id=PDFpage img src=http://www.MYSITE.com/imgPDF/pdfHEADER.gifhttp://www.mysite.com/imgPDF/pdfHEADER.gif width=544 height=200 / cfoutput query=makePDF div id=PDFCARD div id=pdfCARDCONTAINER div id=cardTOPcfif makePDF.pending EQ pendingPending/cfif/div div id=prvNAME#makePDF.dsp_name#/div div id=prvAMNT#makePDF.dsp_amount# #makePDF.dsp_millthou#/div div id=prvTYPE#makePDF.deal_type#/div div id=prvINDUS#makePDF.dsp_industry#/div div id=prvDATE cfif (makePDF.showDAY EQ n or makePDF.showDAY EQ y) and makePDF.showMONTH EQ n#dateformat(makePDF.dsp_closedate, '')#/cfif cfif makePDF.showDAY EQ n and makePDF.showMONTH EQ y#dateformat(makePDF.dsp_closedate, ' ')#/cfif cfif makePDF.showDAY EQ y and makePDF.showMONTH EQ y#dateformat(makePDF.dsp_closedate, ' dd, ')#/cfif /div /div /div /cfoutput/div /body /html /cfdocument ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
OK, so I'm trying it like this now: If I remove the CFDOCUMENT tag, the file renders exactly the way I want. Put it back in, I get a page of gibberish. -- START TEMPLATE - - - - QUERIES HERE - - - cfdocument format=pdf !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleUntitled Document/title style type=text/css !-- CSS HERE -- /style /head body div id=PDFpage img src=http://www.MYSITE.com/imgPDF/pdfHEADER.gif; width=544 height=200 / cfoutput query=makePDF MY OUTPUT STUFF HERE... /cfoutput /div /body /html /cfdocument ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295021 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Exclusive locks still producing duplicate values
cflock name=#session.st#ProcessLock timeout=20 type=exclusive I'm taking a bit of a guess here, but I think your name may be the problem. I'm assuming that by having a session variable in the name, each user will have a different name for the lock. Named locks are only locked from blocks with the same name. If each user is getting a unique name, then the block will not be locked between users. That is my understanding of locks at least. If this is the case, you want a single, discreet name for the lock so that all users use the same named lock and thus can only use the block of code one at a time, which I believe is your requirement. The fact that the lock is given a name based upon a session variable is definitely a problem--that only guarantees that the locked code won't run for sessions where the variable session.st is identical. I'm guessing that variable is unique per session. Also, just because you lock code calling the ReqNumbering.cfc component, the code in that component is not necessarily locked. That means if RegNumbering.cfc is called from other places outside of this locked code, it would run unlocked. -Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
On Tuesday 18 Dec 2007, Les Mizzell wrote: If I remove the CFDOCUMENT tag, the file renders exactly the way I want. Put it back in, I get a page of gibberish. I suggest setting the correct content-type before sending it then. -- Tom Chiverton Helping to ambassadorially reinvent prospective CEOs on: http://thefalken.livejournal.com Halliwells wishes all of its clients and suppliers the Very Best for Christmas the New Year This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Changing JRE to 1.5
Hi, This is a double post -- sorry -- but while I'd like to get it out on CF-Talk, this issue has been discussed more specifically on the Transfer list. So I'm sending to both, knowing that many of you will get duplications. I apologize. There's been a lot of discussion lately, including blog entries by Sean Corfield and Mark Mandel, regarding the class loading problem in Java 1.6, installed by default in Windows versions of CF8. The suggestion has been to switch to Java 1.5, editing CF's jvm.config file. I'm trying to do just that, but without success. And I'd appreciate any advice. I downloaded Java 1.5.0_14 to my server and allowed the installer to place it in its default location, within the C:\Program Files\Java directory. I then changed jvm.config as follows: I changed this line: java.home=C:/ColdFusion8/runtime/jre to this: java.home=C:/Program Files/Java/jre1.5.0_14 After doing so, the CF service would not restart. The bin directory seems to be in the correct place. Files seem okay. The one difference I noted is that in C:/ColdFusion8/runtime/jre/bin, there is a server directory, with its own jvm.dll. This directory does not seem to exist either within the 1.5.9_14/bin directory OR within the Java/jre1.6.0_03/bin directory. The latter is not the version used by the default CF installation (the one there seems to be 1.6.0_01), but one might think it would have the same structure. Does anyone see what I'm doing wrong here? Thanks in advance for any suggestions. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: memory issues
1. User logs in and requests a file. 2. Application reads file, and builds a Query object out of it. Every line of the file is saved to the Query. 3. A SELECT statement is performed on the Query to only get the relevant data for that user (cached for 30 minutes) 4. Results of SELECT shown to user The caching was added to speed up the processing on that page, but I'm wondering if it's causing my memory issues. Assuming the Query object is probably about the same size as the file the user reads, then I'd be caching the 200kb-5mb for every user. Sounds great for CPU/speed performance, but not so good for memory conservation. Am I off my rocker, or could this be the culprit? A query object of a text file I'm sure would use more memory than just the text file stored as a string. It also depends on how much of the cached queries contents you're keeping around (you indicated that your doing a QoQ and caching those results.) That caching could definitely be the cause of the problem. I'd recommend poking around your application and session scopes to see just how much data you're actually caching. Check out this post by Steve Brownlee: http://www.fusioncube.net/?p=66 The section labeled All ColdFusion Sessions shows you how can get to all the sessions on the server. I believe one of the associated SessionTracker classes has a method that will actually allow you to determine the memory being used by a session (but that may only be in CF8.) -Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295022 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFDOCUMENT creating a PDF - ARGH!
Change to: cfdocument format=pdf filename=c:\test.pdf Then try to open it. Also, ensure you have the PDF reader installed as a plugin, or you will get gibberish as well =) Chris -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 11:34 AM To: CF-Talk Subject: Re: CFDOCUMENT creating a PDF - ARGH! OK, so I'm trying it like this now: If I remove the CFDOCUMENT tag, the file renders exactly the way I want. Put it back in, I get a page of gibberish. -- START TEMPLATE - - - - QUERIES HERE - - - cfdocument format=pdf !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleUntitled Document/title style type=text/css !-- CSS HERE -- /style /head body div id=PDFpage img src=http://www.MYSITE.com/imgPDF/pdfHEADER.gif; width=544 height=200 / cfoutput query=makePDF MY OUTPUT STUFF HERE... /cfoutput /div /body /html /cfdocument ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFDOCUMENT creating a PDF - ARGH!
Sorry, I haven't been keeping up with this entire thread, but I noticed your post below. Beware that IE (at least) will cache the mime type on successive refreshes of a page. If it gets a pdf one time, it expects it the next time as well etc... ~Brad -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 10:34 AM To: CF-Talk Subject: Re: CFDOCUMENT creating a PDF - ARGH! OK, so I'm trying it like this now: If I remove the CFDOCUMENT tag, the file renders exactly the way I want. Put it back in, I get a page of gibberish. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
If I change the tag to: cfdocument format=pdf mimetype=text/html name=myFILE I get a blank page with nothing... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT creating a PDF - ARGH!
I have a site where i'm using CFDOCUMENT To create PDFs too. I find i get gibberish if i refresh teh page to see what the PDF looks like after i've tinkered with the code a bit. But if i refresh a second time it renders ok. Any user seeing hte page sees it fine because they're not refreshing the page with some changes. I'm not sure it's anything you can eiher control or need to worry about. I fretted about it a lot on my site before i realised that it doesnt really happen in a real world situation. Not sure if that helps you. does it? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 12/19/07, Les Mizzell [EMAIL PROTECTED] wrote: If I change the tag to: cfdocument format=pdf mimetype=text/html name=myFILE I get a blank page with nothing... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: memory issues
Thanks again Dan Ian for keeping with me here! Much love for that Steve Brownlee link -- I've been wanting a way to see all Sessions stored on an application by application basis, and it looks like that's the object I was looking for (createObject(java,coldfusion.runtime.SessionTracker))! Ian -- Definitely agree with you on the trade-offs. What I've been pondering recently is whether I ought to just sidestep the problem caused by heavy file-reading. Convert those text files into database records on upload, and then rely on SQL to do the heavy lifting for me. Sure, it'll take a little longer for the upload to process, but after that it would be relatively smooth sailing. The files come in to the application, and never need to be modified or passed out to an external application, so I've got pretty much free reign on what I do with them. I think an intial SQL import on upload, and then SQL SELECTS will make my life (and hopefully the servers') much easier. Jonathon ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Scraping Websites, Touchy Subject??? Please tell me where to go.
Hi all, I am beginning to realize that talking on a public forum can be a 'touchy' subject when it comes to scraping content from websites. First off, I want to assure you that I am not doing anything illegal. I am within my 'terms'. I am hoping that someone here can direct me to where to go to get the help that I need. I have a problem with a login system that I have not come across before and need someone who has extensive experience with scraping information from a 'logged in' area of a website. I am looking for a contact or for a private web forum where I can speak freely about this. Can anyone tell me where to go? Please feel free to contact me on 'back channel'. william (at) seiter (dot) com Thank you in advance for your help, William ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF forums
Hey you started it. :) -Cameron No...actually I didn'tmy first post even asked for only CONSTRUCTIVE comments ;-) and apparently the info I was given about FuseTalk being written in Fusebox was wrong anyways. Oh wellsaw the CFMBB demo last nightdoes the trick for our needs Thanks all Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Scraping Websites, Touchy Subject??? Please tell me where to go.
If you are doing this legitimately as you say you are then the best place to get information would be from the site owner. Smells kinda fishy to me though. -Cameron William Seiter wrote: Hi all, I am beginning to realize that talking on a public forum can be a 'touchy' subject when it comes to scraping content from websites. First off, I want to assure you that I am not doing anything illegal. I am within my 'terms'. I am hoping that someone here can direct me to where to go to get the help that I need. I have a problem with a login system that I have not come across before and need someone who has extensive experience with scraping information from a 'logged in' area of a website. I am looking for a contact or for a private web forum where I can speak freely about this. Can anyone tell me where to go? Please feel free to contact me on 'back channel'. william (at) seiter (dot) com Thank you in advance for your help, William ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Exclusive locks still producing duplicate values
that particular value is the same across all users for a particular client and each client draws from its own seed value. Well, then I would look for some breach in the process of setting this session value. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Exclusive locks still producing duplicate values
There isn't one. That variable is always what it's supposed to be. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 12:38 PM To: CF-Talk Subject: Re: Exclusive locks still producing duplicate values that particular value is the same across all users for a particular client and each client draws from its own seed value. Well, then I would look for some breach in the process of setting this session value. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Exclusive locks still producing duplicate values
The session variable is the same for all users for a particular client, so the lock name will be the same for all users for that client, which is what we want. I don't want to go into why these things are what they are because it would require a book and its an excellent example of bad design. With regard to the CFC, I was thinking about that too, but all orders are created through this code block. There is no where else that calls that CFC (I've accomplished that much at least). -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 11:28 AM To: CF-Talk Subject: RE: Exclusive locks still producing duplicate values cflock name=#session.st#ProcessLock timeout=20 type=exclusive I'm taking a bit of a guess here, but I think your name may be the problem. I'm assuming that by having a session variable in the name, each user will have a different name for the lock. Named locks are only locked from blocks with the same name. If each user is getting a unique name, then the block will not be locked between users. That is my understanding of locks at least. If this is the case, you want a single, discreet name for the lock so that all users use the same named lock and thus can only use the block of code one at a time, which I believe is your requirement. The fact that the lock is given a name based upon a session variable is definitely a problem--that only guarantees that the locked code won't run for sessions where the variable session.st is identical. I'm guessing that variable is unique per session. Also, just because you lock code calling the ReqNumbering.cfc component, the code in that component is not necessarily locked. That means if RegNumbering.cfc is called from other places outside of this locked code, it would run unlocked. -Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: memory issues
What I've been pondering recently is whether I ought to just sidestep the problem caused by heavy file-reading. Convert those text files into database records on upload, and then rely on SQL to do the heavy lifting for me. That is something I would definitely consider. Database designers have spent a great deal of time and money over the past several decades making a tool that is very efficient at handling data. A lot more effort then you or I are ever going to have. Good database management systems have the capability to directly import structured text files. ColdFusion would not even need to involved in this aspect of the application other then to upload the file into a place accessible to the database and maybe trigger a process in the database to start the conversion process. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: memory issues
I've been pondering recently is whether I ought to just sidestep the problem caused by heavy file-reading. I would strongly recommend using your database to do this sort of thing directly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295035 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Changing JRE to 1.5
The one difference I noted is that in C:/ColdFusion8/runtime/jre/bin, there is a server directory, with its own jvm.dll. This directory does not seem to exist either within the 1.5.9_14/bin directory OR within the Java/jre1.6.0_03/bin directory. The latter is not the version used by the default CF installation (the one there seems to be 1.6.0_01), but one might think it would have the same structure. You must download and install the full JDK, not the JRE. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
data not outputting correctly
Good morning/afternoon/evening all, I am outputting some data for our bus schedules and I am having a problem getting it to display in the right order. When I run my stored procedure in SQL Server Management Studio the information outputs correctly (the order by clause is working). When I display it in my CF code or dump the query, it displays in what appears to be random order. You can see what I am talking about at http://www.snowline.k12.ca.us/busschedule.cfm?School_ID=10. It should be listing by route name starting with route 6 and working it's way up to 27. Here is the code below: p class=bold cfoutput#getSchoolBusRoutesRet.School_Name#/cfoutput /P P cfoutput query=getSchoolBusRoutesRet group=Route_Name cfif getModifiedBusSchedulesRet.RecordCount GT 0 table align=center cellpadding=2 cellspacing=2 border=0 width=80% tr th colspan=4 #School_Name#nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; #Route_Name# (Modified) /th /tr cfoutput tr class=contacts_cell td width=52% #StreetName# /td td width=4% (#Side#) /td td width=22% #Pick_Up# /td td width=22% #Drop_Off# /td /tr /cfoutput /table cfelse table align=center cellpadding=2 cellspacing=2 border=0 width=80% tr th colspan=4 #School_Name#nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; #Route_Name# /th /tr cfoutput tr class=contacts_cell td width=52% #StreetName# /td td width=4% (#Side#) /td td width=22% #Pick_Up# /td td width=22% #Drop_Off# /td /tr /cfoutput /table /cfif /cfoutput /P Any help would be appreciated. Thanks, Bruce ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Need a Javascript Wizard...
I've got a form with 12-24 dynamic checkboxes and varying values. When a checkbox is checked, its value needs to be passed to a hidden form field (it will become a comma seperated list). When it is unchecked, it needs to be removed from the list. Any ideas how to do something like this? My JS skills are lacking. :( Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Need a Javascript Wizard...
why not just name the checkboxes the same? then the action page will contain a comma-delimited list of the checked values. On Dec 18, 2007 10:52 AM, Che Vilnonis [EMAIL PROTECTED] wrote: I've got a form with 12-24 dynamic checkboxes and varying values. When a checkbox is checked, its value needs to be passed to a hidden form field (it will become a comma seperated list). When it is unchecked, it needs to be removed from the list. Any ideas how to do something like this? My JS skills are lacking. :( Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: memory issues
I will second that, the one thing (and yes I will include me on this one) is that even though the Garbage collection does a good job. Under heavy load it is not smart enough to know what we want when we want it. And it is a trap that most do not think about. So in the old days of allocating memory in C/C++, it is also a good idea to destroy a variable as soon as it is no longer needed. I am not saying all, but at least in cases like this. I'm not exactly sure what you're recommending here, but deleting variables in CF doesn't cause the value to be removed from memory. It simply removes the reference to the value from the stack, making the value available for garbage collection. I'm not sure whether deleting a variable within a page will allow it to be garbage collected before the page has finished, or not, but in any event it's relatively unlikely that garbage collection will run frequently enough to make a difference. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Need a Javascript Wizard...
When a checkbox is checked, its value needs to be passed to a hidden form field (it will become a comma seperated list). When it is unchecked, it needs to be removed from the list. Well, you don't actually need any Javascript to do that. Just give the same name to all your checkboxes, and the value passed to CF unde that name will be the list of all values for those which are checked. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need a Javascript Wizard...
I've got a form with 12-24 dynamic checkboxes and varying values. When a checkbox is checked, its value needs to be passed to a hidden form field (it will become a comma seperated list). When it is unchecked, it needs to be removed from the list. Any ideas how to do something like this? My JS skills are lacking. :( Rather than tax your JS skills, why not just give your checkboxes the same name? When your form is submitted, CF will give you a single form variable with a comma-delimited list of checked values. Alternatively, you could store your checked values within a JS array, which is easier to work with. When you submit the form, you could then convert it to a list using the join method built into the Array object type. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Need a Javascript Wizard...
Claude/Charlie... The reason this won't work is because I am passing this hidden form field value to a cfwindow tag and I need the values w/o actually submitting a form. Does that make sense? Something like below... cfwindow x=210 y=100 width=800 height=600 name=showForumURLs minWidth=700 minHeight=550 title=Create Links initshow=false source=window.cfm?text={theForm:cbValues} center=true modal=true resizable=true / -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 1:58 PM To: CF-Talk Subject: Re: OT: Need a Javascript Wizard... why not just name the checkboxes the same? then the action page will contain a comma-delimited list of the checked values. On Dec 18, 2007 10:52 AM, Che Vilnonis [EMAIL PROTECTED] wrote: I've got a form with 12-24 dynamic checkboxes and varying values. When a checkbox is checked, its value needs to be passed to a hidden form field (it will become a comma seperated list). When it is unchecked, it needs to be removed from the list. Any ideas how to do something like this? My JS skills are lacking. :( ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need a Javascript Wizard...
Dave, see my last reply... -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 2:09 PM To: CF-Talk Subject: RE: Need a Javascript Wizard... I've got a form with 12-24 dynamic checkboxes and varying values. When a checkbox is checked, its value needs to be passed to a hidden form field (it will become a comma seperated list). When it is unchecked, it needs to be removed from the list. Any ideas how to do something like this? My JS skills are lacking. :( Rather than tax your JS skills, why not just give your checkboxes the same name? When your form is submitted, CF will give you a single form variable with a comma-delimited list of checked values. Alternatively, you could store your checked values within a JS array, which is easier to work with. When you submit the form, you could then convert it to a list using the join method built into the Array object type. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Need a Javascript Wizard...
i've not yet used cfwindow, but the point remains... as far as i can tell... there's no difference between you referencing your hidden text field via {theForm:cbValues} (i assume cbValues is your hidden input) and just replacing cbValues with the name of the checkboxes (again, assuming they're all named the same) On Dec 18, 2007 11:10 AM, Che Vilnonis [EMAIL PROTECTED] wrote: Claude/Charlie... The reason this won't work is because I am passing this hidden form field value to a cfwindow tag and I need the values w/o actually submitting a form. Does that make sense? Something like below... cfwindow x=210 y=100 width=800 height=600 name=showForumURLs minWidth=700 minHeight=550 title=Create Links initshow=false source=window.cfm?text={theForm:cbValues} center=true modal=true resizable=true / -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 1:58 PM To: CF-Talk Subject: Re: OT: Need a Javascript Wizard... why not just name the checkboxes the same? then the action page will contain a comma-delimited list of the checked values. On Dec 18, 2007 10:52 AM, Che Vilnonis [EMAIL PROTECTED] wrote: I've got a form with 12-24 dynamic checkboxes and varying values. When a checkbox is checked, its value needs to be passed to a hidden form field (it will become a comma seperated list). When it is unchecked, it needs to be removed from the list. Any ideas how to do something like this? My JS skills are lacking. :( ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
FTP via CF?
Can CF upload/download a file or files via FTP? I was looking at cfhttp or cffile. Sorry if this seems like a basic question; it's that I have not tried this before. Thanks. RO HWW ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: FTP via CF?
cfftp Who would have guessed, huh? :) -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 1:19 PM To: CF-Talk Subject: FTP via CF? Can CF upload/download a file or files via FTP? I was looking at cfhttp or cffile. Sorry if this seems like a basic question; it's that I have not tried this before. Thanks. RO HWW ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Need a Javascript Wizard...
Charlie, you are correct. That worked. Thanks so much. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 2:20 PM To: CF-Talk Subject: Re: OT: Need a Javascript Wizard... i've not yet used cfwindow, but the point remains... as far as i can tell... there's no difference between you referencing your hidden text field via {theForm:cbValues} (i assume cbValues is your hidden input) and just replacing cbValues with the name of the checkboxes (again, assuming they're all named the same) On Dec 18, 2007 11:10 AM, Che Vilnonis [EMAIL PROTECTED] wrote: Claude/Charlie... The reason this won't work is because I am passing this hidden form field value to a cfwindow tag and I need the values w/o actually submitting a form. Does that make sense? Something like below... cfwindow x=210 y=100 width=800 height=600 name=showForumURLs minWidth=700 minHeight=550 title=Create Links initshow=false source=window.cfm?text={theForm:cbValues} center=true modal=true resizable=true / -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 1:58 PM To: CF-Talk Subject: Re: OT: Need a Javascript Wizard... why not just name the checkboxes the same? then the action page will contain a comma-delimited list of the checked values. On Dec 18, 2007 10:52 AM, Che Vilnonis [EMAIL PROTECTED] wrote: I've got a form with 12-24 dynamic checkboxes and varying values. When a checkbox is checked, its value needs to be passed to a hidden form field (it will become a comma seperated list). When it is unchecked, it needs to be removed from the list. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLOCATION, but with a form
Well yes, you could use those other mechanisms to hand off the data, or push it into a db table, but that's not really what I'm trying to think about. Is there a form equivalent to the http mechanism used by cflocation, where the server side generates info that gets passed to a new page? Semi-relevant: cfhttp can submit a form with specified data to a specified url, but the whole thing happens on the server, without the browser relocating anywhere. What I'm looking for is just like that, but navigating the browser to that submitted pg. Dave Merrill -Original Message- From: Tom Chiverton Sent: Tuesday, December 18, 2007 11:17 AM To: CF-Talk Subject: Re: CFLOCATION, but with a form On Tuesday 18 Dec 2007, Dave Merrill wrote: As I understand it, cflocation sends a redirect to the browser, navigating it to a new page, potentially including url parameters. Is there any way to do a similar thing, but emulating a form, so passed parameters can be kept out of the url? Store them in the session, or as cookies. -- Tom Chiverton Helping to simultaneously coordinate user-centric communities on: http://thefalken.livejournal.com Halliwells wishes all of its clients and suppliers the Very Best for Christmas the New Year This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOCATION, but with a form
Without javascript involved or using GetPageContext().Forward() ( read: http://www.bennadel.com/blog/382-Is-ColdFusion-s-GetPageContext-Forward-Method-Worth-Using-.htm), then I don't think you're going to find what you're looking for. On Dec 18, 2007 2:48 PM, Dave Merrill [EMAIL PROTECTED] wrote: Well yes, you could use those other mechanisms to hand off the data, or push it into a db table, but that's not really what I'm trying to think about. Is there a form equivalent to the http mechanism used by cflocation, where the server side generates info that gets passed to a new page? Semi-relevant: cfhttp can submit a form with specified data to a specified url, but the whole thing happens on the server, without the browser relocating anywhere. What I'm looking for is just like that, but navigating the browser to that submitted pg. Dave Merrill ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLOCATION, but with a form
Is there a form equivalent to the http mechanism used by cflocation, where the server side generates info that gets passed to a new page? No, there isn't. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOCATION, but with a form
Semi-relevant: cfhttp can submit a form with specified data to a specified url, but the whole thing happens on the server, without the browser relocating anywhere. What I'm looking for is just like that, but navigating the browser to that submitted pg. Dave Merrill I am not seeing how this mechanism would work. You want the server to build a request for the client so that the client ends up somewhere else by submitting a form post? This sounds like a mixing of the server/client - request/response schema. cflocation... generates a response to the client request. This is a response (HTTP status 301 IIRC) that the client recognizes. Most browsers then handle this response by sending a new request to the suggested location. But of course they do not have to do this. There are no responses that I know of that suggests the browser to make a new form post request. I have done something like this in the ancient past (10 years ago) by building an HTML form with a JavaScript auto-submit that is sent to the browser. Of course this may not be looked on too friendly in todays environment and would be easily defeated. Bottom line: NO I know of no way to do this and it does not make sense to me from a client/server perspective. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Need a Javascript Wizard...
Che, I sent you some sample script that should help. It just simply loops through the checkboxes, collects the value of only those that are checked and assigns it to a text field. That should give you something to run with. Rey... Che Vilnonis wrote: I've got a form with 12-24 dynamic checkboxes and varying values. When a checkbox is checked, its value needs to be passed to a hidden form field (it will become a comma seperated list). When it is unchecked, it needs to be removed from the list. Any ideas how to do something like this? My JS skills are lacking. :( Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: memory issues
It'd definitely be nice to get everything database-driven. That would save me some headaches. But keeping with the same train of thought here. I reduced the caching timeout from 30 minutes down to 1 minute -- I hoped to see my memory start clearing up fairly quickly: cfquery name=#queryName# dbtype=query cachedwithin=#createTimeSpan(0,0,1,0)# SQL /cfquery Most users on the site don't stick around for longer than 1 minute, so I'm not worried about users having to do another lookup. And while it definitely seems to slow down the memory consumption rate, it still doesn't appear to be freeing up any RAM. I did some test runs, loading some of the larger files. I saw the corresponding RAM increase, but never seeing that memory released. I plan on converting it all to being database-driven, but I'm still confused as to why this memory isn't being released. Are the Queries being eliminated, but not removed from memory just yet? Is there a way to force garbage collection while CF is running so that I could test this theory? Jonathon ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfwindow JavaScript error
I'm new to some of the new CF8 features. I am building an app with onclick cfwindows appearing. I got through a few and no errors using the ?cfdebug. I got to a new cfwindow and I'm getting ... error:http: Error processing JavaScript in markup for element posdept_edit2_body: but right after... info:http: Replaced markup for element: posdept_edit2_body. So it processes it fine after erroring. Without cfdebug, I get popup message. Everything is working fine but this error won't go away. Any ideas?? Thanks, Chad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: memory issues
SeeFusion or Fusion-Reactor will allow you to force garbage collection. ~Brad I plan on converting it all to being database-driven, but I'm still confused as to why this memory isn't being released. Are the Queries being eliminated, but not removed from memory just yet? Is there a way to force garbage collection while CF is running so that I could test this theory? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: memory issues
Anyone know the exact place to do start a garbage collection in FusionReactor? Looked at the help docs, and all the options I could find in the application -- no dice... Jonathon ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: onTap Framework 3.0 - p.s. I'm not dead
On Dec 18, 2007 1:02 AM, s. isaac dealey [EMAIL PROTECTED] wrote: I'm not dead. :) I just reset my subscription to the cf-talk list to receive emails signed up on RIAForge this week and set up a project Welcome back Isaac! We've missed you! -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using Mac Mini as web server
System Preferences Energy Saver - you can set the machine to Never sleep. On Dec 18, 2007 7:01 AM, Andy Matthews [EMAIL PROTECTED] wrote: So my question is, will this happen everytime the Mac goes to sleep? How can I prevent this from happening? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using Mac Mini as web server
Excellent...I actually found about that earlier from Aaron West. Thank you for confirming it though. He actually suggested the wake on ethernet option. Would that work though if the Mini is running via wireless? -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 4:02 PM To: CF-Talk Subject: Re: Using Mac Mini as web server System Preferences Energy Saver - you can set the machine to Never sleep. On Dec 18, 2007 7:01 AM, Andy Matthews [EMAIL PROTECTED] wrote: So my question is, will this happen everytime the Mac goes to sleep? How can I prevent this from happening? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: memory issues
Jonathon, And while it definitely seems to slow down the memory consumption rate, it still doesn't appear to be freeing up any RAM. I did some test runs, loading some of the larger files. I saw the corresponding RAM increase, but never seeing that memory released. I plan on converting it all to being database-driven, but I'm still confused as to why this memory isn't being released. Are the Queries being eliminated, but not removed from memory just yet? Is there a way to force garbage collection while CF is running so that I could test this theory? Just because you're not using the memory, it doesn't mean that Java will free it up immediately. Since Garbage Collection is an expensive CPU operation, it tries to do the GC as infrequently as possible by default. You can think of Java and its Garbage Collection sort of like the Windows Recycling Bin. Just because you delete a file and put it in the Recycling Bin, it doesn't actually free up disk space right away. The file is in the Recycling Bin and still takes up disk space. Windows will eventually remove the files and reclaim the disk space when it needs to based upon your Recycling Bin settings. -Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using Mac Mini as web server
On Dec 18, 2007 2:14 PM, Andy Matthews [EMAIL PROTECTED] wrote: Excellent...I actually found about that earlier from Aaron West. Thank you for confirming it though. He actually suggested the wake on ethernet option. Would that work though if the Mini is running via wireless? No idea. Never used it. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
'The selected method functionName was not found.' error.
So I've recently become a temporary maintainer of some ColdFusion CMS software at work, which I'm definitely not ready for, so forgive my idiocy. Anyway, I'm having a problem with a 'The selected method functionName was not found.' error. The extended error info is: 'Either there are no methods with the specified method name and argument types, or the method getRootIDofChildPage is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity.' I'm calling a function of an object in a ColdFusion file. Example: cfset x = page.functionName(page.id)/ . This file is pulled by another CF file that uses Java to spit out generated HTML. I know that the function exists. It can be used by files that are cfinclude into the main file. I also know that page and page.id exist from a cfdump. I'm not overloading it - I've used the exact same code in those cfinclude pages. It's something with the fact that this page is feeded into Java. I didn't think I had to Javacast it because it's all ColdFusion there. Any help, please? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 'The selected method functionName was not found.' error.
Could you show us how page is created? Is page an instance of a CFC? If so, what cfarguments does cffunction name=getRootIDofChildPage have in the CFC? ~Brad -Original Message- From: h k [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 4:38 PM To: CF-Talk Subject: 'The selected method functionName was not found.' error. So I've recently become a temporary maintainer of some ColdFusion CMS software at work, which I'm definitely not ready for, so forgive my idiocy. Anyway, I'm having a problem with a 'The selected method functionName was not found.' error. The extended error info is: 'Either there are no methods with the specified method name and argument types, or the method getRootIDofChildPage is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity.' I'm calling a function of an object in a ColdFusion file. Example: cfset x = page.functionName(page.id)/ . This file is pulled by another CF file that uses Java to spit out generated HTML. I know that the function exists. It can be used by files that are cfinclude into the main file. I also know that page and page.id exist from a cfdump. I'm not overloading it - I've used the exact same code in those cfinclude pages. It's something with the fact that this page is feeded into Java. I didn't think I had to Javacast it because it's all ColdFusion there. Any help, please? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 'The selected method functionName was not found.' error.
I think you can also get this error if the method is set to access='private' but it is not being called from within the component. -- Josh - Original Message - From: h k [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 18, 2007 2:37 PM Subject: 'The selected method functionName was not found.' error. So I've recently become a temporary maintainer of some ColdFusion CMS software at work, which I'm definitely not ready for, so forgive my idiocy. Anyway, I'm having a problem with a 'The selected method functionName was not found.' error. The extended error info is: 'Either there are no methods with the specified method name and argument types, or the method getRootIDofChildPage is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity.' I'm calling a function of an object in a ColdFusion file. Example: cfset x = page.functionName(page.id)/ . This file is pulled by another CF file that uses Java to spit out generated HTML. I know that the function exists. It can be used by files that are cfinclude into the main file. I also know that page and page.id exist from a cfdump. I'm not overloading it - I've used the exact same code in those cfinclude pages. It's something with the fact that this page is feeded into Java. I didn't think I had to Javacast it because it's all ColdFusion there. Any help, please? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Mac Mini as web server
He actually suggested the wake on ethernet option. Would that work though if the Mini is running via wireless? I don't know about the Mini in particular, but I know that doesn't work for other systems, and I really doubt it'll work for you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: memory issues
That makes sense. Now if only it was smart enough to clean itself out BEFORE issuing 500 null and OutOfMemory responses ;) Then I'd really be happy! Jonathon -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 4:10 PM To: CF-Talk Subject: RE: memory issues Jonathon, And while it definitely seems to slow down the memory consumption rate, it still doesn't appear to be freeing up any RAM. I did some test runs, loading some of the larger files. I saw the corresponding RAM increase, but never seeing that memory released. I plan on converting it all to being database-driven, but I'm still confused as to why this memory isn't being released. Are the Queries being eliminated, but not removed from memory just yet? Is there a way to force garbage collection while CF is running so that I could test this theory? Just because you're not using the memory, it doesn't mean that Java will free it up immediately. Since Garbage Collection is an expensive CPU operation, it tries to do the GC as infrequently as possible by default. You can think of Java and its Garbage Collection sort of like the Windows Recycling Bin. Just because you delete a file and put it in the Recycling Bin, it doesn't actually free up disk space right away. The file is in the Recycling Bin and still takes up disk space. Windows will eventually remove the files and reclaim the disk space when it needs to based upon your Recycling Bin settings. -Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLOCATION, but with a form
Ian, that's exactly what I was looking for, a server response that asks the browser to submit a form, the form analog of what cflocation does. It doesn't surprise me that no such thing exists. Dave Merrill -Original Message- From: Ian Skinner Sent: Tuesday, December 18, 2007 3:09 PM To: CF-Talk Subject: Re: CFLOCATION, but with a form Semi-relevant: cfhttp can submit a form with specified data to a specified url, but the whole thing happens on the server, without the browser relocating anywhere. What I'm looking for is just like that, but navigating the browser to that submitted pg. Dave Merrill I am not seeing how this mechanism would work. You want the server to build a request for the client so that the client ends up somewhere else by submitting a form post? This sounds like a mixing of the server/client - request/response schema. cflocation... generates a response to the client request. This is a response (HTTP status 301 IIRC) that the client recognizes. Most browsers then handle this response by sending a new request to the suggested location. But of course they do not have to do this. There are no responses that I know of that suggests the browser to make a new form post request. I have done something like this in the ancient past (10 years ago) by building an HTML form with a JavaScript auto-submit that is sent to the browser. Of course this may not be looked on too friendly in todays environment and would be easily defeated. Bottom line: NO I know of no way to do this and it does not make sense to me from a client/server perspective. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT creating a PDF - ARGH!
Peterson, Chris wrote: Change to: cfdocument format=pdf filename=c:\test.pdf cfdocument name=test.pdf filename=c:\test.pdf format=PDF mimetype=text/xml backgroundvisible=yes overwrite=yes fontembed=yes Generates a blank page... Remove the cfdoc tag surrounding everything - perfect. I've got maybe two or three hairs left. Anybody want to have a go at them??? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
submitting a cfform to a cfpod
Hello, I have a page with a cfform, and I want to submit the form to a cfpod that is also on that page. I want to pod to refresh on form submit, and display results. I know this can be done with a grid, so I assume it can be done with a pod too, but I'm having some difficulties figuring out how. Any ideas? Thanks Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multple CFWINDOWS - cannot identify
Hello, I am trying to move our Intranet app to use CFWINDOWs. One of the things I would like to do is migrate over time. This being the case, I want to make a routine that saves the X and Y coordinates of a window to a cookie, so that on the next page load the CFWINDOW is created in the same position it was at. This gives the impression to the user that the Windows are persistant. I have this successfully working with ONE window. I run into problems with more than one window because there seems to be no way to check for the existence of a certain window by name, or to extract the name of whatever window passed the move event. I am running into is that I need to get the name of the Window (or some other identifying characteristic) so that I know which cookie to write to. Unfortunately NAME does not seem to be exposed. Here is my JavaScript code (called via AJAXOnLoad): moveListener = function() { if (ColdFusion.Window != null) { var w = ColdFusion.Window.getWindowObject('todayAtWindow'); w.on('move',setCoordsTODAYAT,w); w.on('hide',closeWindowTODAYAT,w); } setCoordsTODAYAT = function(ob,x,y) { Set_Cookie('TODAYATWINDOW_X', x, 10, '/', '', ''); Set_Cookie('TODAYATWINDOW_Y', y, 10, '/', '', ''); } closeWindowTODAYAT = function(ob) { Set_Cookie('TODAYATWINDOW_SHOW', false, 10, '/', '', ''); } Any help would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFCHART in CFLAYOUT (tabs) Image Expired in Firefox
I am combining multiple Flash CFCHARTS inside a CFLAYOUT tab control. Works great in IE, in Firefox the first tab displays fine but switching to alternate tabs causes Image Expired Refresh the Page to View the Image (which is odd because I am using flash format) in all the tabs. Any ideas? Thanks in advance. -Dustin Snell ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFCHART in CFLAYOUT (tabs) Image Expired in Firefox
You need to adjust the timeout in the webcharts3d.xml file. See this link for more details: http://www.prayank.net/blog/?p=29 Cheers Will -Original Message- From: Dustin M. Snell [mailto:[EMAIL PROTECTED] Sent: 19 December 2007 00:51 To: CF-Talk Subject: CFCHART in CFLAYOUT (tabs) Image Expired in Firefox I am combining multiple Flash CFCHARTS inside a CFLAYOUT tab control. Works great in IE, in Firefox the first tab displays fine but switching to alternate tabs causes Image Expired Refresh the Page to View the Image (which is odd because I am using flash format) in all the tabs. Any ideas? Thanks in advance. -Dustin Snell ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: data not outputting correctly
Don't know if your doing any grouping in the query, but you are in the output. Is it possible that this grouping is somehow reordering the query? I would look at the query again only because I am seeing data duplication on route 11 and time values out of order on several routes (i.e. 8, 18 and 13). -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 1:27 PM To: CF-Talk Subject: data not outputting correctly Good morning/afternoon/evening all, I am outputting some data for our bus schedules and I am having a problem getting it to display in the right order. When I run my stored procedure in SQL Server Management Studio the information outputs correctly (the order by clause is working). When I display it in my CF code or dump the query, it displays in what appears to be random order. You can see what I am talking about at http://www.snowline.k12.ca.us/busschedule.cfm?School_ID=10. It should be listing by route name starting with route 6 and working it's way up to 27. Here is the code below: p class=bold cfoutput#getSchoolBusRoutesRet.School_Name#/cfoutput /P P cfoutput query=getSchoolBusRoutesRet group=Route_Name cfif getModifiedBusSchedulesRet.RecordCount GT 0 table align=center cellpadding=2 cellspacing=2 border=0 width=80% tr th colspan=4 #School_Name#nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; #Route_Name# (Modified) /th /tr cfoutput tr class=contacts_cell td width=52% #StreetName# /td td width=4% (#Side#) /td td width=22% #Pick_Up# /td td width=22% #Drop_Off# /td /tr /cfoutput /table cfelse table align=center cellpadding=2 cellspacing=2 border=0 width=80% tr th colspan=4 #School_Name#nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; #Route_Name# /th /tr cfoutput tr class=contacts_cell td width=52% #StreetName# /td td width=4% (#Side#) /td td width=22% #Pick_Up# /td td width=22% #Drop_Off# /td /tr /cfoutput /table /cfif /cfoutput /P Any help would be appreciated. Thanks, Bruce ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 shopping cart tutorial
On Monday 17 Dec 2007, Ali Majdzadeh wrote: Hi everybody: I want to make a shopping cart with CF8 and MS ACCESS. No, you don't. Use a real database. I'm coming into this on the tail end, so I didn't see the original message. I wouldn't recommend Access for anything that will be used in production, particularly now that SQL Sever Express (2005 lite) is available. Back when it wasn't available I designed my SQL Abstraction library to work with Access (along with MySQL, SQL Server Oracle). So if for some reason you had problems installing one of the other 3, if you were using the onTap framework (or something like it) that abstracts the database access and were pretty monogamous about not using ad-hoc queries, then you could use an MS Access database locally for minimal development and testing to create a proof of concept and all your code would then still work for the other databases. But I agree that you really wouldn't want to use an Access database beyond the larval stages. I personally prefer using SQL 2005 on my notebook. The new SQL Server Management Studio that replaced Enterprise Manager + Query Analyzer is imo in some ways a step back from the older tools in spite of some minor improvements to the interface. Still, at least for my purposes it seems easier to manage than MySQL. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: data not outputting correctly
Yeah, I am thinking that I need to redo the table. On the query I am not doing any groupings as there are way too many fields and I am joining another SQL Server to get the street names and route names/ID's. All I am doing on the query is an order by Route_Name, and like I said, when I run the query in Studio Manager, the data comes out right. The dupes were already there and have been deleted. User entered the same information twice. Regarding the time issues, that is something else I need to work out. Thanks, Bruce -Original Message- From: Dave [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 5:41 PM To: CF-Talk Subject: RE: data not outputting correctly Don't know if your doing any grouping in the query, but you are in the output. Is it possible that this grouping is somehow reordering the query? I would look at the query again only because I am seeing data duplication on route 11 and time values out of order on several routes (i.e. 8, 18 and 13). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: data not outputting correctly
I am outputting some data for our bus schedules and I am having a problem getting it to display in the right order. When I run my stored procedure in SQL Server Management Studio the information outputs correctly (the order by clause is working). When I display it in my CF code or dump the query, it displays in what appears to be random order. You can see what I am talking about at http://www.snowline.k12. ca.us/busschedule.cfm?School_ID=10. It should be listing by route name starting with route 6 and working it's way up to 27. Here is the code below: Hey Bruce, not sure if you've had any responses on this... The code you posted looks fine, but it doesn't look like the place where your problem is going to be located. By the time you get to the cfoutput tag, the sorting's pretty well done with (and your grouping looks fine, although I usually group on the primary key column -- I'm not sure if route_name is your primary key). Could you post the TSQL for your stored procedure and/or the cfstoredproc tags your using to fetch that query? ike -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: onTap Framework 3.0 - p.s. I'm not dead
Welcome back Isaac! We've missed you! Thanks Sean. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
Les, I am getting the same results with your Divs. Works fine with no cfdocument, and then nothing with... I would look at those divs and work them in one by one to find the one that is causing the problem.. Hopefully someone will see this and add it as a bug to cfdocument. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: data not outputting correctly
I'll do that tomorrow when I get to work. Cannot access the SQL Server from home. Oh, and it is good to see you back Issac. -Original Message- From: s. isaac dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 6:21 PM To: CF-Talk Subject: Re: data not outputting correctly Hey Bruce, not sure if you've had any responses on this... The code you posted looks fine, but it doesn't look like the place where your problem is going to be located. By the time you get to the cfoutput tag, the sorting's pretty well done with (and your grouping looks fine, although I usually group on the primary key column -- I'm not sure if route_name is your primary key). Could you post the TSQL for your stored procedure and/or the cfstoredproc tags your using to fetch that query? ike -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
Rob Parkhill wrote: Les, I am getting the same results with your Divs. Works fine with no cfdocument, and then nothing with... I would look at those divs and work them in one by one to find the one that is causing the problem.. Hopefully someone will see this and add it as a bug to cfdocument. I can delete *everything* except the image and it still is giving a blank page. Oh boy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: data not outputting correctly
I'll do that tomorrow when I get to work. Cannot access the SQL Server from home. Oh, and it is good to see you back Issac. Thanks Bruce. I always figure when I'm replying after 6pm that there's a good chance there'll be that 12hr delay. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT creating a PDF - Getting Somewhere..
OK, this is *sorta* working... Let's look at real files for a second: Here's a .cfm page. Ignore the low resolution header graphic. This is also probably IE 7 only compatable at this point too (it's the only browser the suits use...) Watch the wrap : http://www.nelsonmullins.com/TOMBSTONES/index.cfm?action=cmf.makeMAPDFpdfID=EFAA15B9-B6FE-F54D-A4446D9E2853DBCE OK, the cards stack left to right and then wrap to the next row. After X number of cards, there would be a page break and a small header that would show up on any subsequent pages on the PDF. According to the docs, I can program the damn cfdocument tag to do this. Yea, right. Let's take the *same* file as above, and simply add cfdocument format=pdf and nothing else: http://www.nelsonmullins.com/TOMBSTONES/index.cfm?action=cmf.makeMAPDFTESTpdfID=EFAA15B9-B6FE-F54D-A4446D9E2853DBCE Hmmm - background images for each card have covered the text? Interesting. It's a start though. This seems to be *way* more buggy and picky than the docs indicate, huh? Anybody got ideas about background images here? The project manager for this is *really* picky about the layouts. If I'm one freaking pixel off somewhere, I get yelled at. I'm beginning to have my doubts about the PDF stuff at this point. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4