RE: Weird problem with Next X records
Very hard to answer without code. For your second problem: your next-n is working on individual records, not groups, so it works as intended. Show first three (3 ben), then next three (1 ben, 2 john). You will have to find an alternative to make the next-n work on accounts. You could make 2 queries instead of one. A query to get accounts (use that for your next-n interface) and one to get customers. Pascal -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 3:35 To: CF-Talk Subject: Weird problem with Next X records I have an application that I am using Next and Previous records links to sort through data. The I'm using the group attribute in the cfoutput tag to group by the customerID. My page will look like: Ben's Accounts CustomerID1 CustomerID2 CustomerID3 CustomerID4 Johns Accounts CustomerID1 CustomerID2 This will output a maximum of 3 accounts per page but with any number of customerID's. The odd thing is if there are say 4 accounts, when I click the next link to diaplay the 4th record it duplicated the first 3 records to me and if I click next again I then get the 4th record. One other strange thing is say in my example Ben's Accounts is the first record displayed and it has 4 customerIDs, when I click the next link and it show's me the duplicate of Ben's accounts on the next page it only has the 4th customerID. Has anyone run into something like this before? I'm thinking the group attribute might be causing this but I'm not sure. Thanks, Ben ** ** This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this e-mail in error please notify the system manager. This e-mail message has been swept for the presence of computer viruses. WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review by someone other than the recipient. ** ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: date search
You need to drop the time from the date-time in your where clause. Otherwise it has to match to the exact second. On Oracle: WHERE TRUNC(event_date) = TO_DATE(cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Dateformat(show_event_date,'-mm-dd')#,'-MM-DD') On MSSQL you can do WHERE DAY(event_date) = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#Day(show_event_date)# AND MONTH(event_date) = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#Month(show_event_date)# AND YEAR(event_date) = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#Year(show_event_date)# OR (assuming that the time for show_event_date is 00:00:00) WHERE event_date = cfqueryparam value=#show_event_date# cfsqltype=CF_SQL_TIMESTAMP AND event_date cfqueryparam value=#DateAdd('d',1,show_event_date)# cfsqltype=CF_SQL_TIMESTAMP If you don't need date and time combined, you could store them separatly in the db. It takes up a little more space, but it would make your life easier. Pascal PS It has been a very long time since I used dates on another db than oracle, so you may want to check the syntax and the cfsqltype for MSSQL PPS If you are asking questions like this, it is always a good idea to mention the db you're using. -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: dinsdag 25 mei 2004 21:24 To: CF-Talk Subject: date search I am having a bit of trouble doing a date search on form entered data. Originally, I created a date with CreateDate and submitted it, then searched on it with a date created the same way (usingWHERE event_date = #show_event_date#) and all was great. Then I was told to also collect the time.Who knew that events would need start times too?So, instead of createDate, I went to createDateTime.Since then, I've not been able to search on these items with my query that uses CreateDate.It doesn't seem right to have to include the time for searching, especially since I just want items on a particular date or series of date. I'm not sure how to go about forming a query on this, really. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
LDAP server is unwilling to perform
Hi, We have been using a simple LDAP authentication method, which basically queries the LDAP server for the user's own record using their own username and password. This in general works fine, however for a very small number of accounts (about 1 in 50ish), instead of returning the user's record, or a message saying inappripriate authentication the LDAP server just returns a message of LDAP server is unwilling to perform.The details used are correct, but the LDAP server just won't authenticatethese few accounts.The problem is un-related to the format of the username or password, since we can re-create the account and it will work fine. We have a number of other non-CF systems using the same LDAP server, but none of these have the same problems. I'd welcome any suggestions, since I can't see why this would work for some accounts and not for a tiny proportion of others. Thanks. Tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: LDAP server is unwilling to perform
message of LDAP server is unwilling to perform How busy is the traffic to the LDAP?Ours refuses connections after a certain limit over a defined period of time, presumably to stop hack attempts. Might be a similar issue. -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
page has expired Message
Hi All, Has anyone found a solution concerning the message (warning: page has expired), when one clicks the back button or go(-1). I've tried the following with no success.: cfcache action="" timeout = #DateAdd(h, -1, Now() )# or CFHEADER NAME=Expires Value=Sun, 06 Nov 1994 08:49:37 GMT CFHEADER NAME=Cache-Control VALUE=max-age=7200 TIA, Patrick Whittingham United Space Alliance _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: page has expired Message
Whittingham, P wrote: Has anyone found a solution concerning the message (warning: page has expired), when one clicks the back button or go(-1). Was the page originally sent as the result of a GET or a POST request? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: page has expired Message
You will always get this message if you are moving back to page which in itself was a form post (as the data to form this page does not techincally exists in the back request). There is no solution as far as I knowits by design. _ From: Whittingham, P [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 12:01 To: CF-Talk Subject: page has expired Message Hi All, Has anyone found a solution concerning the message (warning: page has expired), when one clicks the back button or go(-1). I've tried the following with no success.: cfcache action="" timeout = #DateAdd(h, -1, Now() )# or CFHEADER NAME=Expires Value=Sun, 06 Nov 1994 08:49:37 GMT CFHEADER NAME=Cache-Control VALUE=max-age=7200 TIA, Patrick Whittingham United Space Alliance _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: page has expired Message
post method. some of the form data is sensitive or more that 4k in length (lots of form elements). I been trying all the different method via google. Pat -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 7:05 AM To: CF-Talk Subject: Re: page has expired Message Whittingham, P wrote: Has anyone found a solution concerning the message (warning: page has expired), when one clicks the back button or go(-1). Was the page originally sent as the result of a GET or a POST request? Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: page has expired Message
Whittingham, P wrote: post method. Responses to POST requests are only cacheable in special circumstances. The recommended workaround is not to send the response directly, but forward the user to another page that can be cached. See the HTTP 303 statuscode in RFC 2616. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: page has expired Message
i am using w2k servers,ie 6 and http1.1... -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 7:32 AM To: CF-Talk Subject: Re: page has expired Message Whittingham, P wrote: post method. Responses to POST requests are only cacheable in special circumstances. The recommended workaround is not to send the response directly, but forward the user to another page that can be cached. See the HTTP 303 statuscode in RFC 2616. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Mailling list script
What form of mailing list?Like read only newsletters or open discussion forums like this? I'm actually working on a mailing list for news letters currently.So far my progress is as follows. Users can subscribe / unsubscribe (adding and removing them from the database) and they are sent a notice with cfmail to let them know if it was a success.It only does basic email validation (checks for @ and . in the address and removes any spaces). I still need to start the admin side where you can post your messages and manage users. Not sure how well the whole thing will work for large lists, I would think it would put a bit of a load on a busy server (when posting). -mike -Original Message- From: CFDEV [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tue, 25 May 2004 16:12:52 -0400 Subject: Mailling list script Anyone knows a good free mailing list script in CF to administer mailing lists? Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Simultaneous Requests / new JVM
Hi, What has everyone running MX on production set their simultaneous requests to? I see its 5 out of the box (or is it 8)obviously for higher traffic sites this is not very good.I was gonna set it at around 20-30? That good or bad? Also, its suggested to upgrade the Java to 1.4.2 from the the vanilla install JVM...but when I install the JRE it seems to be missing a folder named server in the bin folder of the newly inserted Java install? Anybody? Sorry for x-post but other lists seem to be a tad sparse on the old admin answers! N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MS Access as a backend database
It will work, but from what I've read isn't really suggested. If more than a handfull of users will be accessing access (no pun intended) things have the potential to slow down. If you don't want to spend the $$ for sql, go with MySQL which is free and for me has worked flawlessly with Coldfusion. -Mike -Original Message- From: David Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tue, 25 May 2004 14:59:14 -0400 Subject: MS Access as a backend database Is this good idea?If not; is there an article I can referance for my managment? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Need Help with SQL inside CFQUERY
If it works when it's all on one line, why not just set the script (nicely formatted) to a cf variable, then run replace on the line breaks, then use the variable? - Original Message - From: Semrau Steven Ctr SAF/IE The problem, in a nutshell, is that we (dba and me) have very limited access to the Oracle server and ZERO access to the CF5 server box and my DBA is going nutz waiting around for someone else to run his PL/SQL script every time he makes a change on the development side. I know I've seen threads, articles and the like with examples of PL/SQL between CFQUERY tags, but when I try to do the same thing - I get the error described earlier. Truly, the PL/SQL my DBA would like me to try and run with CFQUERY is 100+ lines and I figured if I can't get a simpler statement (like my example earlier) to run there is no sense in putting a 100+ line SQL out in the forum. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF running from CD, CF Anywhere, and somesuch (long)
It has long been a desire of mine to run CF apps on the desktop and/or from CD.There have been many threads on this list, about this topic, but no resolution I recently posted a question on the BlueDragon list, asking if it were possible to run BD from a CD. I got several responses, indicating that it had been done, and some general pointers (no specific examples) These were very helpful, so I started digging and probing. As I write this, I have BlueDragon j2ee 6.1 beta,my CF apps, a web server and Servlet Container -- all running from a CD. The only thing that resides on local hard disk are the dbs -- and I think that that can be resolved. I tried to do this with CFMX, also, but no success, yet. How? A key player is Jetty -- an open source Java web server and servlet container.This is a really cool little package -- you can create/configure/deploy your web server, servelet container, and web app with a simple XML file. Then you just run it. The Jetty stuff takes about 10 Meg RAM and BDj2ee takes another 10 Meg RAM, This is no scaled-down system, rather a very robust web server and full BDj2ee. How does it perform? - Quite nicely, thank you :) Actually, Jetty is lean and fast,and BD has template caching similar to CFMX -- it seems to perform about equal to localhost/apache development environment. One nice feature/attribute of BD is the way it handle logging disk writes -- If you run from CD you need to kill these writes or map them to the local file system.In BD you don;t need to do anything -- it (the BD system) will run in a read-only environment.If it tries to log, but can't, it just backs off continues. In your Jetty server xmlfile,you can just not include anything, like logging, that requires disk writes. Why CF on the Desktop/CD? - A few reasons -- just for starters. -- You, as a developer, want to publish Trial versions of one or more Apps, including CF, DBs, etc. on a CD (or DVD) and distribute it to potential customers.This CD/DVD would be completely gun-and-run -- no installation. configuration, etc. to get between you and your audience -- insert the CD/DVD on any platform and it runs. -- You are developing self-contained applications for Kiosks.The Kiosks are reprogrammed by installing a new CD. -- You have a combo application that runs as a desktop app that periodically connects to a server (and becomes a web or network app). One good example of this is a Lands End, Victoria's Secret, Figi's Cheese, Martha Stewart(or whatever) catalog -- that is bulk mailed to the customer.The customer browses the catalog offline, and constructs an order.When ready, the customer clicks a button and goes online; adds any online specials places the order.The CD/DVD could have much better quality andmore images, etc. than would be practical to view online. -- ad hoc queries and reporting and graphing against local databases -- i.e. ms-access plus for the rest of us -- broad, mass-appeal apps such as personal photo/movie/song albums -- where the user adds his own data Now, I admit that some of these can (almost) be done with present CF offerings.The biggest challenge would be to make CF (and the apps) run from the CD/DVD. The gun-and-run startup would need to recognize the platform and map any CF output files/directories to the local file system as it would not be able to updatethe CD/DVD. What are the advantages of CF apps on the Desktop/CD? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: date search
dan. I do this: select * from yourTable where date between '05/01/2004 00:00:00.000' and '05/01/2004 23:59:59.999' if I want the events of a day. and of course you can do some slick stuff to create those datetime combos does that get what your looking for? tw -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 3:42 AM To: CF-Talk Subject: RE: date search You need to drop the time from the date-time in your where clause. Otherwise it has to match to the exact second. On Oracle: WHERE TRUNC(event_date) = TO_DATE(cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Dateformat(show_event_date,'-mm-dd')#,'-MM-DD') On MSSQL you can do WHERE DAY(event_date) = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#Day(show_event_date)# AND MONTH(event_date) = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#Month(show_event_date)# AND YEAR(event_date) = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#Year(show_event_date)# OR (assuming that the time for show_event_date is 00:00:00) WHERE event_date = cfqueryparam value=#show_event_date# cfsqltype=CF_SQL_TIMESTAMP AND event_date cfqueryparam value=#DateAdd('d',1,show_event_date)# cfsqltype=CF_SQL_TIMESTAMP If you don't need date and time combined, you could store them separatly in the db. It takes up a little more space, but it would make your life easier. Pascal PS It has been a very long time since I used dates on another db than oracle, so you may want to check the syntax and the cfsqltype for MSSQL PPS If you are asking questions like this, it is always a good idea to mention the db you're using. -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: dinsdag 25 mei 2004 21:24 To: CF-Talk Subject: date search I am having a bit of trouble doing a date search on form entered data. Originally, I created a date with CreateDate and submitted it, then searched on it with a date created the same way (usingWHERE event_date = #show_event_date#) and all was great. Then I was told to also collect the time.Who knew that events would need start times too?So, instead of createDate, I went to createDateTime.Since then, I've not been able to search on these items with my query that uses CreateDate.It doesn't seem right to have to include the time for searching, especially since I just want items on a particular date or series of date. I'm not sure how to go about forming a query on this, really. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
activePDF
Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Simultaneous Requests / new JVM
They way I have understood this setting in the past is as so: 5 Sim Requests = 20% of the resources 10 sim requests = 10% of resources Thus the more you have the less resources and thus the slower the request I think its very a bit of a black art. Hope this helps _ Mr Kev McCabe Senior ETV Developer, British Sky Broadcasting First Floor North East, West Cross House Grant Way Isleworth Middlesex TW7 5QD [EMAIL PROTECTED] http://www.sky.com http://www.sky.com/ tel: +44 (0) 20 7941 5329 fax: +44 (0) 20 7941 5243 _ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 13:29 To: CF-Talk Subject: Simultaneous Requests / new JVM Hi, What has everyone running MX on production set their simultaneous requests to? I see its 5 out of the box (or is it 8)obviously for higher traffic sites this is not very good.I was gonna set it at around 20-30? That good or bad? Also, its suggested to upgrade the Java to 1.4.2 from the the vanilla install JVM...but when I install the JRE it seems to be missing a folder named server in the bin folder of the newly inserted Java install? Anybody? Sorry for x-post but other lists seem to be a tad sparse on the old admin answers! N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Preventing a REFRESH
I know this was touched on before and I re-read the thread but did not find my answer. I need a way to prevent the browser's refresh from re-submitting info. Is there a way via CF or _javascript_? anyone have something already please? Thanks. Robert HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Preventing a REFRESH
I know this was touched on before and I re-read the thread but did not find my answer. I need a way to prevent the browser's refresh from re-submitting info. Is there a way via CF or _javascript_? anyone have something already please? Set a variable: session.ranAlready = false Check to make sure session.ranAlready NEQ true Run code Set variable: session.ranAlready = true Just remember to find a point to clear out the session var... HTH, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Preventing a REFRESH
Robert Orlini wrote: I know this was touched on before and I re-read the thread but did not find my answer. I need a way to prevent the browser's refresh from re-submitting info. Is there a way via CF or _javascript_? anyone have something already please? Use POST instead of GET as the request method. See the section about idempotent requests in RFC 2616. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MS Access as a backend database
Original Message: From: Dave Watts That's only true if Maintain Connection Across Client Requests is checked. That's correct, but the default setting is to enable this option, I think. That was true in CF5 (and presumably earlier versions), but not in CFMX. In general, maintaining database connections can provide significantly better performance. Again, I've never noticed huge performance problems with my sites that use Access.If performance is your big issue, then, yes, Access may not be the way to go.But, if simplicity and lower costs are more important, than Access may be the way to go.(Most hosts I've seen will charge more for SQL Server accounts than for Access accounts) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
Yes I did one year and a half in my previous company J-M -Message d'origine- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Envoy : mercredi 26 mai 2004 14:41 : CF-Talk Objet : activePDF Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: date search
From: Pascal Peters On Oracle: WHERE TRUNC(event_date) = TO_DATE(cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Dateformat(show_event_date,'-mm-dd')#,'-MM-DD') Why wouldn't you use CF_SQL_DATE as the cfsqltype? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
whats you take on it? good / bad? _ From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:17 To: CF-Talk Subject: RE: activePDF Yes I did one year and a half in my previous company J-M -Message d'origine- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Envoy : mercredi 26 mai 2004 14:41 : CF-Talk Objet : activePDF Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MS Access as a backend database
(Most hosts I've seen will charge more for SQL Server accounts than for Access accounts) That's mainly because the SQL (either MySQL or MS SQL) run on a seperate server. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
Honestly, fifty fifty! If you need to generate a lot of pdf files it could be ok, however you will have to create a css for it. The good point is that it will generate a report on several pages. You need to use the server (activePDF) in combination with web grabber. I have been dissapointed by the quality of their services and technical team. If you only need to create some very simple pdf , use a custom tag or go for some java. J-M -Message d'origine- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Envoy : mercredi 26 mai 2004 15:14 : CF-Talk Objet : RE: activePDF whats you take on it? good / bad? _ From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:17 To: CF-Talk Subject: RE: activePDF Yes I did one year and a half in my previous company J-M -Message d'origine- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Envoy : mercredi 26 mai 2004 14:41 : CF-Talk Objet : activePDF Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MS Access as a backend database
Original Message: From: Dan Phillips That's mainly because the SQL (either MySQL or MS SQL) run on a seperate server. True (and a SQL Server license is more expensive than Access).But to the customer, it's just an additional cost. (Of course, I think CrystalTech doesn't charge extra for MySQL accounts, so it may be more the license costs than the fact that they're on different boxes) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: date search
- Original Message - From: Philip Arnold From: Pascal Peters On Oracle: WHERE TRUNC(event_date) = TO_DATE(cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Dateformat(show_event_date,'-mm-dd')#,'-MM-DD') Why wouldn't you use CF_SQL_DATE as the cfsqltype? Oracle's dateformat doesn't seem to correspond with the cf_sql_date format very well, particularly if your Oracle environment has set up a non-standard date format (not uncommon). It also might be that the cf_sql_date format, when used with Oracle, automatically passes a timestamp as well. There's no separate data type for date with time/date without time in Oracle. I'm not sure on that, but I think it makes sense. I use varchar, as well, and just send the matching date format string. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
From: Robertson-Ravo, Neil (RX) Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. Take a look at CFXPDF as well - it has specific CF instructions and will probably do what you need [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
Thanks Phil...I will take a look and compare these. _ From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:48 To: CF-Talk Subject: RE: activePDF From: Robertson-Ravo, Neil (RX) Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. Take a look at CFXPDF as well - it has specific CF instructions and will probably do what you need _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: date search
I am having a bit of trouble doing a date search on form entered data. WOW - I had no idea that there would be so many approaches.I thought on the way into work today to just put zeros in the time and do a 'greater than', but Tony pointed out that it'd be between instead.Hey tony, the date you used is my birthday (not year though ahem). I never would've thought of truncating the date and there seem to be several ways to do that.Interesting that Oracle provides a method for it.Pascal, that third approach, with the dateAdd will work on Oracle? And yeah, I should've mentioned that it was Oracle. Thanks Tony, Pascal and Deanna (again). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
neil, what are you looking to with these pdfs? have you/anyone worked out a way to hit a page, generate a pdf, and have that sent to a print spool, to print with dynamic stuff, through a fdf, inserted into the pdf? thanks. tony -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 9:45 AM To: CF-Talk Subject: RE: activePDF Thanks Phil...I will take a look and compare these. _ From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:48 To: CF-Talk Subject: RE: activePDF From: Robertson-Ravo, Neil (RX) Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. Take a look at CFXPDF as well - it has specific CF instructions and will probably do what you need _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
checkout iText too http://www.lowagie.com/iText/ Java based... Doug -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 9:48 AM To: CF-Talk Subject: RE: activePDF From: Robertson-Ravo, Neil (RX) Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. Take a look at CFXPDF as well - it has specific CF instructions and will probably do what you need _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: date search
I am having a bit of trouble doing a date search on form entered data. WOW - I had no idea that there would be so many approaches.I thought on the way into work today to just put zeros in the time and do a 'greater than', but Tony pointed out that it'd be between instead.Hey tony, the date you used is my birthday (not year though ahem). I never would've thought of truncating the date and there seem to be several ways to do that.Interesting that Oracle provides a method for it.Pascal, that third approach, with the dateAdd will work on Oracle? And yeah, I should've mentioned that it was Oracle. Thanks Tony, Pascal and Deanna (again). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFILE
I have a CFFILE question: I have a form which allows a user to upload three different images at the same time I have three different cffile action="" tags on the processing page. The problem is it only uploads the very first image... Any suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
It will upload one file at a time and not two or three together -Original Message- From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:03 AM To: CF-Talk Subject: CFFILE I have a CFFILE question: I have a form which allows a user to upload three different images at the same time I have three different cffile action="" tags on the processing page. The problem is it only uploads the very first image... Any suggestions? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFFILE
On May 26, 2004, at 10:06 AM, Monique Boea wrote: It will upload one file at a time and not two or three together Try doing a cfloop or cfoutput with cffile as the query name.I haven't tried it yet but it might work. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
Combing the three into one cffile with a loop? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:12 AM To: CF-Talk Subject: Re: CFFILE On May 26, 2004, at 10:06 AM, Monique Boea wrote: It will upload one file at a time and not two or three together Try doing a cfloop or cfoutput with cffile as the query name.I haven't tried it yet but it might work. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
self varible..
Its the coldfusion noob again here.. Is there a self varible in coldfusion?much like $PHP_SELF if your familier with that.. So, if the varible were used in blah.cfm, the content of it would be just blah.cfm. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
Can you post the code for the submission form? George At 10:20 AM 5/26/2004, Monique Boea wrote: Combing the three into one cffile with a loop? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:12 AM To: CF-Talk Subject: Re: CFFILE On May 26, 2004, at 10:06 AM, Monique Boea wrote: It will upload one file at a time and not two or three together Try doing a cfloop or cfoutput with cffile as the query name.I haven't tried it yet but it might work. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: date search
If you are using oracle, go with trunc() -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 15:52 To: CF-Talk Subject: Re: date search I am having a bit of trouble doing a date search on form entered data. WOW - I had no idea that there would be so many approaches. I thought on the way into work today to just put zeros in the time and do a 'greater than', but Tony pointed out that it'd be between instead.Hey tony, the date you used is my birthday (not year though ahem). I never would've thought of truncating the date and there seem to be several ways to do that.Interesting that Oracle provides a method for it.Pascal, that third approach, with the dateAdd will work on Oracle? And yeah, I should've mentioned that it was Oracle. Thanks Tony, Pascal and Deanna (again). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
Is there a self varible in coldfusion?much like $PHP_SELF if your functions... getBaseTemplatePath() getTemplatePath() -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: activePDF
- Original Message - From: Philip Arnold From: Robertson-Ravo, Neil (RX) Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. Take a look at CFXPDF as well - it has specific CF instructions and will probably do what you need I'm working with CFX_PDF right now and I'm finding it rather rudimentary. It was easy to set up and it worked right away, so I'll give it that. It has its own, limited, set of tags for formatting. Some of them are nice to see, like the PDF encryption/security support, but the layout tools are pretty thin. It might get the job done, but I'm not going to be creating anything sophisticated with it. Not without a lot of work. It looks most useful for simple print documents without much layout. One of the things it doesn't do that ActivePDF does is take an existing file and convert it to PDF. ActivePDF in that sense just acts as a server-side PDF print driver. CFX_PDF is a set of tags for generating a new PDF from scratch. So if you need to allow people to upload a .doc and have your homebuilt CMS convert that to PDF, then CFX_PDF isn't for you. On the flip side, CFX_PDF is easy to use and it's a .jar and works on Windows, Linux, and Solaris while ActivePDF is a set of COM objects and only runs on Windows. There is also an article in this month's CFDJ talking about FOP (Formatting Objects Processor) which is a free alternative using XSL-FO. http://www.sys-con.com/story/?storyid=44771DE=1 http://xml.apache.org/fop/ -Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
#GetFileFromPath(GetCurrentTemplatePath())# -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 16:23 To: CF-Talk Subject: self varible.. Its the coldfusion noob again here.. Is there a self varible in coldfusion?much like $PHP_SELF if your familier with that.. So, if the varible were used in blah.cfm, the content of it would be just blah.cfm. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
cftry !--- upload new file --- cffile action="" filefield=form.tLogoFilename destination=#variables.home_dir#media\images\clientlogos\#variables.tLogoFi lename# nameconflict=overwrite cfcatch SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_ alert(Error uploading Logo file.Please try again.); history.go(-1); /SCRIPT cfexit /cfcatch /cftry There is one for each image (3) -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:25 AM To: CF-Talk Subject: RE: CFFILE Can you post the code for the submission form? George At 10:20 AM 5/26/2004, Monique Boea wrote: Combing the three into one cffile with a loop? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:12 AM To: CF-Talk Subject: Re: CFFILE On May 26, 2004, at 10:06 AM, Monique Boea wrote: It will upload one file at a time and not two or three together Try doing a cfloop or cfoutput with cffile as the query name.I haven't tried it yet but it might work. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: self varible..
Take at all of the CGI variables. Some really good and useful stuff there. I use #cgi.SCRIPT_NAME# frequently. Sounds like this would output what you are wanting. Greg - Original Message - From: techmike To: CF-Talk Sent: Wednesday, May 26, 2004 9:23 AM Subject: self varible.. Its the coldfusion noob again here.. Is there a self varible in coldfusion?much like $PHP_SELF if your familier with that.. So, if the varible were used in blah.cfm, the content of it would be just blah.cfm. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
Do you mean the current file name? If so, you can use getCurrentTemplatePath(), which returns the full path, and if you want just the file, use getFileFromPath... cfoutput #getFileFromPath(getCurrentTemplatePath())# /cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFFILE
On May 26, 2004, at 10:20 AM, Monique Boea wrote: Combing the three into one cffile with a loop? That's what I'm thinking.. eg cffile cfoutput query=cffile #cffile.clientFileName#br / /cfoutput -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
also you may want to try cfdump var=#cgi# just to see what other variables are out there. and while your at it... cfdump var=#session# cfdump var=#server# cfdump var=#application# cfdump var=#form# cfdump var=#url# cfdump var=#client# just to see what else is there and available. I have those all cfdumped in my onRequestEnd.cfm file if the website visitor is my ip address, for most of my sites, so I can always see what vars are there and working. tw -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:32 AM To: CF-Talk Subject: RE: self varible.. Is there a self varible in coldfusion?much like $PHP_SELF if your functions... getBaseTemplatePath() getTemplatePath() -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
Ah sorry, I meant the code for the form page, not the action page. So the page just before this one. George At 10:26 AM 5/26/2004, Monique Boea wrote: cftry !--- upload new file --- cffile action="" filefield=form.tLogoFilename destination=#variables.home_dir#media\images\clientlogos\#variables.tLogoFi lename# nameconflict=overwrite cfcatch SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_ alert(Error uploading Logo file.Please try again.); history.go(-1); /SCRIPT cfexit /cfcatch /cftry There is one for each image (3) -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:25 AM To: CF-Talk Subject: RE: CFFILE Can you post the code for the submission form? George At 10:20 AM 5/26/2004, Monique Boea wrote: Combing the three into one cffile with a loop? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:12 AM To: CF-Talk Subject: Re: CFFILE On May 26, 2004, at 10:06 AM, Monique Boea wrote: It will upload one file at a time and not two or three together Try doing a cfloop or cfoutput with cffile as the query name.I haven't tried it yet but it might work. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
sorry, it's long form action="" method=post enctype=multipart/form-data validateform(); table width=600 cellpadding=0 cellspacing=0 border=0 tr td width=100 align=leftnbsp;/td td width=500 align=rightnbsp;/td /tr tr tdbLabel:/b/td tdcfoutputinput type=text name=tScreenLabel maxlength=100 size=50 value=#htmlEditFormat(variables.tScreenLabel)#/cfoutput/td /tr tr tdbLogo:/b /td tdcfoutputinput type=file name=tLogoFilename maxlength=50 size=50/cfoutput/td /tr tr td height=5 colspan=2nbsp;/td /tr trtd/td tdb class=mepImage size must be 187 X 62 (W x H) pixels /b /td /tr tr td height=10 colspan=2nbsp;/td /tr cfif variables.tLogoFilename is not '' tr td a href="" - /a /td td align=leftcfoutputimg src=""> /tr /cfif tr td colspan=2nbsp;/td /tr tr tdbHeader Background Image:br /b/td tdcfoutputinput type=file name=tHeaderBGFilename maxlength=50 size=50/cfoutput/td /tr trtd/td tdb class=mepImage size must be 36 pixels high (MAX) /b /td /tr tr td height=10 colspan=2nbsp;/td /tr cfif variables.tHeaderBGFilename is not '' tr td a href="" - /a /td td align=center height=36 cfoutput table border=0 cellpadding=0 cellspacing=0 width=300 tr td width=5img src=""> td width=20 valign=middle align=center = /td td width=* background=""> /tr /table /cfoutput /td /tr /cfif tr td height=20 colspan=2nbsp;/td /tr tr td colspan=2bHeader Color Code (EX: #12250P):/b cfoutput input type=text name=tHeaderBGColor value=#variables.tHeaderBGColor# maxlength=50 size=10/cfoutput /td /tr tr td colspan=3a href="" here to open color chooser./a/td /tr tr td height=20 colspan=2nbsp;/td /tr cfif variables.tHeaderBGColor is not '' tr td colspan=2 cfoutputbgcolor=#variables.tHeaderBGColor#/cfoutput width=10nbsp;/td /tr /cfif tr td colspan=2nbsp;/td /tr tr tdbHeader Foreground Image:/b/td tdcfoutputinput type=file name=tHeaderFGFilename maxlength=50 size=50/cfoutput/td /tr trtd/td tdb class=mepImage size must be 36 pixels high (MAX) /b /td /tr tr td height=10 colspan=2nbsp;/td /tr cfif variables.tHeaderFGFilename is not '' tr td a href="" - /a /td td align=centercfoutputimg src=""> /tr /cfif tr td colspan=2nbsp;/td /tr tr tdLink 1 Label:/td tdcfoutputinput type=text name=tURL1label maxlength=100 size=50 value=#htmlEditFormat(variables.tURL1Label)#/cfoutput/td /tr tr tdLink 1:/td tdcfoutputinput type=text name=tURL1 maxlength=200 size=30 value=#htmlEditFormat(variables.tURL1)#/cfoutput http://www.balser.com /td /tr tr td colspan=2nbsp;/td /tr tr tdLink 2 Label:/td tdcfoutputinput type=text name=tURL2label maxlength=100 size=50 value=#htmlEditFormat(variables.tURL2Label)#/cfoutput/td /tr tr tdLink 2:/td tdcfoutputinput type=text name=tURL2 maxlength=200 size=30 value=#htmlEditFormat(variables.tURL2)#/cfoutput http://www.balser.com /td /tr tr td colspan=2nbsp;/td /tr tr tdLink 3 Label:/td tdcfoutputinput type=text name=tURL3Label maxlength=100 size=50 value=#htmlEditFormat(variables.tURL3Label)#/cfoutput/td /tr tr tdLink:/td tdcfoutputinput type=text name=tURL3 maxlength=200 size=30 value=#htmlEditFormat(variables.tURL3)#/cfoutput http://www.balser.com td /tr tr td colspan=2nbsp;/td /tr tr td colspan=2 align=center brbrinput type=submit value=Submitnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; input type=button value=Cancel > cfoutput input type=hidden name=action value=add_edit input type=hiddenname=editflag value=#variables.editflag# input type=hidden name=textension value= input type=hidden name=tBGextension value= input type=hidden name=tFGextension value= /cfoutput /td /tr /table /form [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
just got the CFX working as noted below...seems pretty basic but it does look goodlike Kevin, I am gonna be generating fairly simple PDF's for now... _ From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 15:29 To: CF-Talk Subject: Re: activePDF - Original Message - From: Philip Arnold From: Robertson-Ravo, Neil (RX) Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. Take a look at CFXPDF as well - it has specific CF instructions and will probably do what you need I'm working with CFX_PDF right now and I'm finding it rather rudimentary. It was easy to set up and it worked right away, so I'll give it that. It has its own, limited, set of tags for formatting. Some of them are nice to see, like the PDF encryption/security support, but the layout tools are pretty thin. It might get the job done, but I'm not going to be creating anything sophisticated with it. Not without a lot of work. It looks most useful for simple print documents without much layout. One of the things it doesn't do that ActivePDF does is take an existing file and convert it to PDF. ActivePDF in that sense just acts as a server-side PDF print driver. CFX_PDF is a set of tags for generating a new PDF from scratch. So if you need to allow people to upload a .doc and have your homebuilt CMS convert that to PDF, then CFX_PDF isn't for you. On the flip side, CFX_PDF is easy to use and it's a .jar and works on Windows, Linux, and Solaris while ActivePDF is a set of COM objects and only runs on Windows. There is also an article in this month's CFDJ talking about FOP (Formatting Objects Processor) which is a free alternative using XSL-FO. http://www.sys-con.com/story/?storyid=44771DE=1 http://xml.apache.org/fop/ -Kevin _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PDF Forms
Has anyone worked with an editable PDF which post to a database on submission? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
For the filefield attribute, you need the name of the input type=file. The destination attribute has to be a directory (not a file!). You can find out the name of the uploaded file with #cffile.serverFile#. cffile action="" filefield=tLogoFilename destination=#variables.home_dir#media\images\clientlogos\ nameconflict=overwrite -Original Message- From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 16:27 To: CF-Talk Subject: RE: CFFILE cftry !--- upload new file --- cffile action="" filefield=form.tLogoFilename destination=#variables.home_dir#media\images\clientlogos\#var iables.tLogoFi lename# nameconflict=overwrite cfcatch SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_ alert(Error uploading Logo file.Please try again.); history.go(-1); /SCRIPT cfexit /cfcatch /cftry There is one for each image (3) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
From: Monique Boea I have a CFFILE question: I have a form which allows a user to upload three different images at the same time I have three different cffile action="" tags on the processing page. The problem is it only uploads the very first image... I've run upto 10 on the same page without problems (apart from users clicking Submit more than once :P), so I know the functionality will work cffile action="" filefield=form.tLogoFilename Remove the form. from the filefield, it's not needed or wanted Try this: Name the 3 fields as FileUpload_1, FileUpload_2 and FileUpload_3 Then run your code with a cfloop around them Also, your JS will only report one error before exiting the template (your cfexit) I'd also suggest displaying the message on the page, and then offering a link back - it will give the opportunity to show more than one message at the same time, rather than one popup Not forgetting that your popup doesn't say which image failed HTH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Setting up an automated Email Newsletter system...need advice for DB
Hi, all... As the subject lines states, I'm setting up a system whereby a user can subscribed to various newsletters that are sent out automatically at varying intervals. The advice I'm seeking, before I get into development is in the best way to setup the db tables... The main tables (among less important ones) I'm considering (MySQL) are: - categories (Category_ID, Category_Name, Category_Description) - subjects (Subject_ID, Category_ID, Subject_Name, Subject_Text) - recipients (Recipient_ID, Recipient_Password, Recipient_EmailAddress, Recipient_EmailType) - registrations (Registration_ID, Recipient_ID, Category_ID, Subject_ID, Registration_Date) The idea would be to allow users (recipients) to sign up for one or more newsletters. My approach so far is to let users sign up and create a user account. Then they can sign up for one or more newsletters. The main question is how to handle the form info for the newsletters for which they sign up. - use check boxes with the same name for the newsletter and loop through the values, creating a new record in the registrations table for each newsletter registration? i.e., there would be one record in the registrations table for each signup by a recipient per newsletter(This would be important because there would be a series of ordered newsletters per category (topic) which would need to be sent, then have the Subject_ID field, which represent each newsletter in a series, containing the ID of the last newsletter sent, which would be updated when each new newsletter in the series is sent. This way, a recipient would be receiving the correct newsletter in the order regardless of when they sign up. I'll stop here without getting any deeper and making this longer... Advice anyone?Anyone done this kind of thing? I've been setting up email newsletter systems for websites for a few years, but nothing quite this complex... Thanks for the advice... Rick Rick Faircloth WhiteStoneMedia.com -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.245 / Virus Database: 262.10.4 - Release Date: 5/22/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
Exactally what I needed.. Thanks for the quick replies.. Was trying to figure out how to post a form to itself.. form action="" method=post Seems to work, but is there a better or more correct way? -Mike -Original Message- From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 26 May 2004 16:26:49 +0200 Subject: RE: self varible.. #GetFileFromPath(GetCurrentTemplatePath())# -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 16:23 To: CF-Talk Subject: self varible.. Its the coldfusion noob again here.. Is there a self varible in coldfusion?much like $PHP_SELF if your familier with that.. So, if the varible were used in blah.cfm, the content of it would be just blah.cfm. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
form action=""> The code below will not work inside a cfinclude, Custom tag, ... -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 17:15 To: CF-Talk Subject: RE: self varible.. Exactally what I needed.. Thanks for the quick replies.. Was trying to figure out how to post a form to itself.. form action="" method=post Seems to work, but is there a better or more correct way? -Mike -Original Message- From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 26 May 2004 16:26:49 +0200 Subject: RE: self varible.. #GetFileFromPath(GetCurrentTemplatePath())# -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 16:23 To: CF-Talk Subject: self varible.. Its the coldfusion noob again here.. Is there a self varible in coldfusion?much like $PHP_SELF if your familier with that.. So, if the varible were used in blah.cfm, the content of it would be just blah.cfm. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
there is form action="" method=post /form look @ my last reply. there are myriad things to output, if you know what to output and what you cant see, may be visible through those cfdumps. tw -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 11:15 AM To: CF-Talk Subject: RE: self varible.. Exactally what I needed.. Thanks for the quick replies.. Was trying to figure out how to post a form to itself.. form action="" method=post Seems to work, but is there a better or more correct way? -Mike -Original Message- From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 26 May 2004 16:26:49 +0200 Subject: RE: self varible.. #GetFileFromPath(GetCurrentTemplatePath())# -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 16:23 To: CF-Talk Subject: self varible.. Its the coldfusion noob again here.. Is there a self varible in coldfusion?much like $PHP_SELF if your familier with that.. So, if the varible were used in blah.cfm, the content of it would be just blah.cfm. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfhttp and stripping out text
I am using cfhttp to pull a page from one of our servers to another. The page that I am pulling contains a table.What I would like to do is strip everything out of the file except for the table.The problem is that the page is coming from a content management system.So I can't be sure that the surrounding html will always be the same. How would I even begin (and can it even be done) to strip out the HTML that I don't want? --Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfhttp and stripping out text
What version of cf? Can you identify the table in a unique way (does it contain something that doesn't change and is unique)? Are there other tables nested in the table? Pascal -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 17:27 To: CF-Talk Subject: cfhttp and stripping out text I am using cfhttp to pull a page from one of our servers to another. The page that I am pulling contains a table.What I would like to do is strip everything out of the file except for the table.The problem is that the page is coming from a content management system.So I can't be sure that the surrounding html will always be the same. How would I even begin (and can it even be done) to strip out the HTML that I don't want? --Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfhttp and stripping out text
On May 26, 2004, at 11:26 AM, Jeff Langevin wrote: How would I even begin (and can it even be done) to strip out the HTML that I don't want? cfset CleanData = Mid( UncleanData, find(table id=findthisone, UncleanData) -1, find(/table!--findthisone--, UncleanData) + 8) This is based on using the function Mid to pluck out a piece of a string.It takes three arguments: the string to search, the start position and the end position.To find the start position you should search for the relevant code, e.g. table id=findthisone (the double-doublequotes are so we can have doublequotes within the string itself), and then I do something similar to get the end position (I add 8 to this one to get past the actual /table tag). Give it a shot. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Macr. Exchange Archives ?
Thanks, that explains it.I thought my account was current but I guess not.FWIW, I'm happy that SQLWizard wasn't available for the last 15 months cause it didn't work properly with MX [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfhttp and stripping out text
I am pulling from CFMX 6.1 to CF5. I could put comments before and after the table to delineate it. However, I could not guarantee that a user in the CMS would never remove or alter them. At this point, there are no nested tables in the table, but again, I can't that won't change in the future. --Jeff Pascal Peters wrote: What version of cf? Can you identify the table in a unique way (does it contain something that doesn't change and is unique)? Are there other tables nested in the table? Pascal -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 17:27 To: CF-Talk Subject: cfhttp and stripping out text I am using cfhttp to pull a page from one of our servers to another. The page that I am pulling contains a table.What I would like to do is strip everything out of the file except for the table.The problem is that the page is coming from a content management system.So I can't be sure that the surrounding html will always be the same. How would I even begin (and can it even be done) to strip out the HTML that I don't want? --Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfhttp and stripping out text
table id = thisTable ... /table can you guarantee the id= will stay there, if you set it up that way in the first place? tw -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 11:42 AM To: CF-Talk Subject: Re: cfhttp and stripping out text I am pulling from CFMX 6.1 to CF5. I could put comments before and after the table to delineate it. However, I could not guarantee that a user in the CMS would never remove or alter them. At this point, there are no nested tables in the table, but again, I can't that won't change in the future. --Jeff Pascal Peters wrote: What version of cf? Can you identify the table in a unique way (does it contain something that doesn't change and is unique)? Are there other tables nested in the table? Pascal -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 17:27 To: CF-Talk Subject: cfhttp and stripping out text I am using cfhttp to pull a page from one of our servers to another. The page that I am pulling contains a table.What I would like to do is strip everything out of the file except for the table.The problem is that the page is coming from a content management system.So I can't be sure that the surrounding html will always be the same. How would I even begin (and can it even be done) to strip out the HTML that I don't want? --Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
My biggest request is the ability to create a PDF which is in itself an editable PDFI am not sure if this is possible with any of the tools out there? _ From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 15:29 To: CF-Talk Subject: Re: activePDF - Original Message - From: Philip Arnold From: Robertson-Ravo, Neil (RX) Anyone worked recently with activePDF? I just downloaded the eval and the actual CF docs on the subject are pretty thin. Take a look at CFXPDF as well - it has specific CF instructions and will probably do what you need I'm working with CFX_PDF right now and I'm finding it rather rudimentary. It was easy to set up and it worked right away, so I'll give it that. It has its own, limited, set of tags for formatting. Some of them are nice to see, like the PDF encryption/security support, but the layout tools are pretty thin. It might get the job done, but I'm not going to be creating anything sophisticated with it. Not without a lot of work. It looks most useful for simple print documents without much layout. One of the things it doesn't do that ActivePDF does is take an existing file and convert it to PDF. ActivePDF in that sense just acts as a server-side PDF print driver. CFX_PDF is a set of tags for generating a new PDF from scratch. So if you need to allow people to upload a .doc and have your homebuilt CMS convert that to PDF, then CFX_PDF isn't for you. On the flip side, CFX_PDF is easy to use and it's a .jar and works on Windows, Linux, and Solaris while ActivePDF is a set of COM objects and only runs on Windows. There is also an article in this month's CFDJ talking about FOP (Formatting Objects Processor) which is a free alternative using XSL-FO. http://www.sys-con.com/story/?storyid=44771DE=1 http://xml.apache.org/fop/ -Kevin _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Troubles with cfexecute
[CF5/Win2k] I'm trying to run Verity Spider (vspider.exe) commands using cfexecute. Some of the commands stop mid-way through, and the process dies. I am using batch files to keep the cfexecute as uncomplicated as possible, and I'm also using long timeouts, as well as output files. The same batch files work like a champ from the command line itself, but as I stated, they hang early in the process, and then the process dies. I've tried the commands using cfx_exec and cfx_execute with the same results, which led me to believe it was somehow a permissions issue. We then changed the CF Application service's account to use local admin, and that's having the same problems. It just seems that no matter how I try to get CF to execute this batch file, it just dies under the influence of CF itself. So... Any idea why this is happening? Also, does anyone know a good way to execute a batch file in some other creative way from a browser, or some other way to insulate the execution of the command from whatever's causing it to fail? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
form action=""> method=post Seems to work, but is there a better or more correct way? Yes That will only work if your file is in the root directory of your website. Try this instead - form action="" method=post Cheers, Alistair Davidson Senior Technical Developer Headshift.com Smarter, Simpler, Social [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfhttp and stripping out text
The problem is that the page is coming from a content management system.So I can't be sure that the surrounding html will always be the same. Yes or no, the chances are bigger the content management system will always generate content the same way. How would I even begin (and can it even be done) to strip out the HTML that I don't want? The best tool for this is CF_REExtract. Have a look here: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm?p=hf -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PL/SQL stumper
I have a table like the following.With just CFML (v5) and plain Oracle PL/SQL--ie, no temp tables or stored procedures--is there a way to get, say, the 7 most recent distinct providers?I've tried every which way, even using QofQ with MAXROWS=7, but that only returned the first 7 distinct providers alphabetically.I need to get the first 7 distinct providers in date order with newest first.Can it be done without getting fancy? Thanks, Chris PROVIDER DATESTAMP Eckerd Drugs 25-MAY-04 Walmart 25-MAY-04 Walgreens 23-MAY-04 Publix 23-MAY-04 Hush Puppy Shoes 23-MAY-04 Publix 22-MAY-04 Walgreen's 20-MAY-04 Timmons Drugs 20-MAY-04 Publix Pharmacy 19-MAY-04 Walmart 16-MAY-04 Publix Pharmacy 16-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Setting up DSN's without using CFAdmin.
Hmm I definately had RDS installedbut,I dont think I pointed to the correct place for the JRE in the Administrator settings I'm getting a sequelink error now,apparantly it couldn't start and now I cant get CF Server to start. If your machine doesn't acknowledge the JRE, you might need to reboot, or at least log off and log on to cycle explorer.Furthermore, the browser applets only work if you have RDS installed on the server.They'll load, and then tell you they can't connect if you don't have RDS access. You can easily copy and paste the path to your Access file into the CF admin.Just find the it with windows explorer, copy the location, and paste it into the CF admin.That's all the browser button is doing, just lets you do it remotely, which shouldn't be an issue if you're sitting in front of the server. Cheers, barneyb [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfhttp and stripping out text
Since the table is part of a larger block of content, I can't guarantee that the id would never be removed. With a little tweaking, Damien's idea did work for me.But, now its a question of whether a user will much things up or not.In general, no I would not expect them to be altering the html.But with end users...;-) If anyone has any other ideas, I wouldn't mind hearing them.In the mean time, I will ping the powers that be to see if they'd be satisfied with this solution.Thanks for all your suggestions and any more to come. --Jeff Tony Weeg wrote: table id = thisTable ... /table can you guarantee the id= will stay there, if you set it up that way in the first place? tw -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 11:42 AM To: CF-Talk Subject: Re: cfhttp and stripping out text I am pulling from CFMX 6.1 to CF5. I could put comments before and after the table to delineate it. However, I could not guarantee that a user in the CMS would never remove or alter them. At this point, there are no nested tables in the table, but again, I can't that won't change in the future. --Jeff Pascal Peters wrote: What version of cf? Can you identify the table in a unique way (does it contain something that doesn't change and is unique)? Are there other tables nested in the table? Pascal -Original Message- From: Jeff Langevin [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 17:27 To: CF-Talk Subject: cfhttp and stripping out text I am using cfhttp to pull a page from one of our servers to another. The page that I am pulling contains a table.What I would like to do is strip everything out of the file except for the table.The problem is that the page is coming from a content management system.So I can't be sure that the surrounding html will always be the same. How would I even begin (and can it even be done) to strip out the HTML that I don't want? --Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PL/SQL stumper
a Top-N styled SQL...something like SELECT * FROM (SELECT * FROM tablename OREDER BY datestamp ) WHERE rownum 8 Doug -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 12:09 PM To: CF-Talk Subject: PL/SQL stumper I have a table like the following.With just CFML (v5) and plain Oracle PL/SQL--ie, no temp tables or stored procedures--is there a way to get, say, the 7 most recent distinct providers?I've tried every which way, even using QofQ with MAXROWS=7, but that only returned the first 7 distinct providers alphabetically.I need to get the first 7 distinct providers in date order with newest first.Can it be done without getting fancy? Thanks, Chris PROVIDER DATESTAMP Eckerd Drugs 25-MAY-04 Walmart 25-MAY-04 Walgreens 23-MAY-04 Publix 23-MAY-04 Hush Puppy Shoes 23-MAY-04 Publix 22-MAY-04 Walgreen's 20-MAY-04 Timmons Drugs 20-MAY-04 Publix Pharmacy 19-MAY-04 Walmart 16-MAY-04 Publix Pharmacy 16-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
What do you mean by editable?AFAIK, Illustrator is the only app that offers any significant editing of PDFs.Do you mean forms that can be filled in buy the user in Adobe Acrobat Reader? Cary Gordon The Cherry Hill Company At 04:50 PM 5/26/2004 +0100, you wrote: My biggest request is the ability to create a PDF which is in itself an editable PDFI am not sure if this is possible with any of the tools out there? _ From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 15:29 To: CF-Talk Subject: Re: activePDF [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PL/SQL stumper
I have a table like the following.With just CFML (v5) and plain Oracle PL/SQL--ie, no temp tables or stored procedures--is there a way to get, say, the 7 most recent distinct providers?I've tried every which way, even using QofQ with MAXROWS=7, but that only returned the first 7 distinct providers alphabetically.I need to get the first 7 distinct providers in date order with newest first.Can it be done without getting fancy? Thanks, Chris PROVIDER DATESTAMP Eckerd Drugs 25-MAY-04 Walmart 25-MAY-04 Walgreens 23-MAY-04 Publix 23-MAY-04 Hush Puppy Shoes 23-MAY-04 Publix 22-MAY-04 Walgreen's 20-MAY-04 Timmons Drugs 20-MAY-04 Publix Pharmacy 19-MAY-04 Walmart 16-MAY-04 Publix Pharmacy 16-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 Off the top of my head, but does this work?: SELECT provider FROM ( SELECT DISTINCT provider FROM provider_table ORDER BY datestamp DESC ) WHERE rownum = 7 Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PL/SQL stumper
Lofback, Chris wrote: I need to get the first 7 distinct providers in date order with newest first.Can it be done without getting fancy? PROVIDER DATESTAMP Eckerd Drugs 25-MAY-04 Walmart 25-MAY-04 Walgreens 23-MAY-04 Publix 23-MAY-04 Hush Puppy Shoes 23-MAY-04 Publix 22-MAY-04 Walgreen's 20-MAY-04 Timmons Drugs 20-MAY-04 Publix Pharmacy 19-MAY-04 Walmart 16-MAY-04 Publix Pharmacy 16-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 SELECT * FROM ( SELECT provider, MAX(datestamp) AS lastDate FROM table ORDER BY MAX(datestamp) DESC ) a WHERE rownum 8 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PL/SQL stumper
oops...left out the distinct provider part SELECT * FROM (SELECT provider,Max(datestamp) FROM tablename ORDER BY Max(datestamp) ) WHERE rownum 8 Doug -Original Message- From: Knudsen, Douglas Sent: Wednesday, May 26, 2004 12:16 PM To: CF-Talk Subject: RE: PL/SQL stumper a Top-N styled SQL...something like SELECT * FROM (SELECT * FROM tablename OREDER BY datestamp ) WHERE rownum 8 Doug -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 12:09 PM To: CF-Talk Subject: PL/SQL stumper I have a table like the following.With just CFML (v5) and plain Oracle PL/SQL--ie, no temp tables or stored procedures--is there a way to get, say, the 7 most recent distinct providers?I've tried every which way, even using QofQ with MAXROWS=7, but that only returned the first 7 distinct providers alphabetically.I need to get the first 7 distinct providers in date order with newest first.Can it be done without getting fancy? Thanks, Chris PROVIDER DATESTAMP Eckerd Drugs 25-MAY-04 Walmart 25-MAY-04 Walgreens 23-MAY-04 Publix 23-MAY-04 Hush Puppy Shoes 23-MAY-04 Publix 22-MAY-04 Walgreen's 20-MAY-04 Timmons Drugs 20-MAY-04 Publix Pharmacy 19-MAY-04 Walmart 16-MAY-04 Publix Pharmacy 16-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
Yes, they are easily created in distiller etc...but needed to know if activePDF could create these forms itself... _ From: Cary Gordon [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 17:24 To: CF-Talk Subject: RE: activePDF What do you mean by editable?AFAIK, Illustrator is the only app that offers any significant editing of PDFs.Do you mean forms that can be filled in buy the user in Adobe Acrobat Reader? Cary Gordon The Cherry Hill Company At 04:50 PM 5/26/2004 +0100, you wrote: My biggest request is the ability to create a PDF which is in itself an editable PDFI am not sure if this is possible with any of the tools out there? _ From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 15:29 To: CF-Talk Subject: Re: activePDF _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Troubles with cfexecute
On Wed, 26 May 2004 11:56:36 -0400, in cf-talk you wrote: [CF5/Win2k] I'm trying to run Verity Spider (vspider.exe) commands using cfexecute. Some of the commands stop mid-way through, and the process dies. I am using batch files to keep the cfexecute as uncomplicated as possible, and I'm also using long timeouts, as well as output files. edited for clarity The same batch files work like a champ from the command line itself, but as I stated, cfexecute commands hang early in the process, and then the process dies. /edited for clarity I've tried the commands using cfx_exec and cfx_execute with the same results, which led me to believe it was somehow a permissions issue. We then changed the CF Application service's account to use local admin, and that's having the same problems. It just seems that no matter how I try to get CF to execute this batch file, it just dies under the influence of CF itself. So... Any idea why this is happening? Also, does anyone know a good way to execute a batch file in some other creative way from a browser, or some other way to insulate the execution of the command from whatever's causing it to fail? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
Is this actually the best way to post a form to itself?What I'm running into now is it works, however it appends to the end of the url whatever the action is. Example. blah.com/test.cfm#CGI.SCRIPT_NAME# -mike -Original Message- From: Alistair Davidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 26 May 2004 17:10:39 +0100 Subject: RE: self varible.. form action=""> method=post Seems to work, but is there a better or more correct way? Yes That will only work if your file is in the root directory of your website. Try this instead - form action="" method=post Cheers, Alistair Davidson Senior Technical Developer Headshift.com Smarter, Simpler, Social [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Memory Limits
On a 2Gb Windows 2k3 server running CFMX, what would be the optimal memory limits to impose on the JVM for CFMX? Is there a maximum limit to the amount of memory the jrun service can consume running CFMX? For instance, for the sake of argument, say I had 8Gb of memory installed, if I set the max memory heap to 4Gb can jrun access 4Gb or will it only access 3Gb or 2Gb or whatever?? Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
not sure what you mean? is the page not parsing #cgi.script_name# ? do you have cfoutput/cfoutput around it somewhere? tw -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 12:31 PM To: CF-Talk Subject: RE: self varible.. Is this actually the best way to post a form to itself?What I'm running into now is it works, however it appends to the end of the url whatever the action is. Example. blah.com/test.cfm#CGI.SCRIPT_NAME# -mike -Original Message- From: Alistair Davidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 26 May 2004 17:10:39 +0100 Subject: RE: self varible.. form action=""> method=post Seems to work, but is there a better or more correct way? Yes That will only work if your file is in the root directory of your website. Try this instead - form action="" method=post Cheers, Alistair Davidson Senior Technical Developer Headshift.com Smarter, Simpler, Social [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Different cfquery results - local vs. hosted
Sorry, this is long but here's some more detail.Thanks, Tony, for the suggestion but the data, when it is returned, is good.I re-ftped the database over, thinking maybe some fields got corrupted, but no go.I even re-ftped the database from the host back to my local drive and ran the searches against it locally again... and they worked. Here's a little of my code.Could this be due to differences in SQL versions between my machine and the server, causing the results to be interpreted differently?Or am I misusing my form variables somehow and they're getting cached differentlyI'm stumped. My search form has: -search keywords (this works fine), -a drop-down list returning type_select (I get 0 records returned if I choose anything; default is to show all and that works fine but then it's not generating any selection criteria in that case) -radio buttons returning archived status (it works when archived = 0 but not when archived = 1) Again this all works with good results when I run it locally, but not on the remote server. cfquery name=jobs datasource=EAC SELECT * FROM Jobs WHERE cfif #Form.type_select# eq 1 Job_Type_Health = 1 AND /cfif cfif #Form.type_select# eq 2 Job_Type_Cust_Service = 1 AND /cfif cfif #Form.keywords# is not (Job_Title LIKE '%#Form.keywords#%' OR Job_Description LIKE '%#Form.keywords#%') AND /cfif cfif #Form.rad_archived# eq 0 Archived = 0 AND cfelseif #Form.rad_archived# eq 1 Archived = 1 AND /cfif 0=0 ORDER BY Archived ASC, Entry_Date DESC /cfquery Thanks- -Amy Wilder if you are getting good records sometimes, this wont make sense.if the records make no sense... shot in the dark have you tried to rename it, something very off the wall, just to make sure its not the same name as another access db on the same server? /shot in the dark tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message- From: Amy Wilder [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 11:48 PM To: CF-Talk Subject: Different cfquery results - local vs. hosted Hi, I'm fairly new to CF and I'm developing my first CF site that uses a web hosting package for the database/datasource.When I developed my site and tested it locally using my copy of the Access database, it worked fine.But when I ftp the Access database and my pages to the host and go through the app remotely, I get different results for my queries. Help m Some searches work fine so I know it's connecting to the datasource. But some searches come up with zero records when I know the records are out there... could it be a timeout issue?(unlikely given the small number of records and the quick response times I'm getting).Any other ideas of where to even begin?I don't know that my host would/could turn on debugging, though I might pursue that in the morning.But if the SQL query is okay but the results are not, where to begin??? Any and all help is greatly appreciated. -Amy Wilder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
bangs head off desk What a stupid oversight on my part..Thanks! -Mike -Original Message- From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 26 May 2004 12:33:26 -0400 Subject: RE: self varible.. not sure what you mean? is the page not parsing #cgi.script_name# ? do you have cfoutput/cfoutput around it somewhere? tw -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 12:31 PM To: CF-Talk Subject: RE: self varible.. Is this actually the best way to post a form to itself?What I'm running into now is it works, however it appends to the end of the url whatever the action is. Example. blah.com/test.cfm#CGI.SCRIPT_NAME# -mike -Original Message- From: Alistair Davidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 26 May 2004 17:10:39 +0100 Subject: RE: self varible.. form action=""> method=post Seems to work, but is there a better or more correct way? Yes That will only work if your file is in the root directory of your website. Try this instead - form action="" method=post Cheers, Alistair Davidson Senior Technical Developer Headshift.com Smarter, Simpler, Social [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFFILE
The destination attribute has to be a directory (not a file!). You can find out the name of the uploaded file with #cffile.serverFile#. ??? From the CFML reference: Absolute pathname of directory or file on web server. I know in the past I've used a filename here. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
Get rid of the cftry and cfcatch for now so you can see why the cffile operation isn't working. The CF error should tell you what's wrong. Greg -Original Message- From: Monique Boea [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:27 AM To: CF-Talk Subject: RE: CFFILE cftry !--- upload new file --- cffile action="" filefield=form.tLogoFilename destination=#variables.home_dir#media\images\clientlogos\#variables.tLogoFi lename# nameconflict=overwrite cfcatch SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_ alert(Error uploading Logo file.Please try again.); history.go(-1); /SCRIPT cfexit /cfcatch /cftry There is one for each image (3) -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:25 AM To: CF-Talk Subject: RE: CFFILE Can you post the code for the submission form? George At 10:20 AM 5/26/2004, Monique Boea wrote: Combing the three into one cffile with a loop? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 10:12 AM To: CF-Talk Subject: Re: CFFILE On May 26, 2004, at 10:06 AM, Monique Boea wrote: It will upload one file at a time and not two or three together Try doing a cfloop or cfoutput with cffile as the query name.I haven't tried it yet but it might work. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: activePDF
If I might chime in, if he DIDN'T mean that, does someone out there know how to have editable forms in pdf?I have a job that will require that coming up Thanks, Ray At 12:23 PM 5/26/2004, Cary Gordon wrote: What do you mean by editable?AFAIK, Illustrator is the only app that offers any significant editing of PDFs.Do you mean forms that can be filled in buy the user in Adobe Acrobat Reader? Cary Gordon The Cherry Hill Company At 04:50 PM 5/26/2004 +0100, you wrote: My biggest request is the ability to create a PDF which is in itself an editable PDFI am not sure if this is possible with any of the tools out there? _ From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 15:29 To: CF-Talk Subject: Re: activePDF [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: date search
ok, thanks I will. If you are using oracle, go with trunc() [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PL/SQL stumper
I thought the same thing at first, but you cannot sort on a field that is not selected when using DISTINCT.And adding the field throws off the records selected because DISTINCT looks at the entire row, not just the one column... Thanks, Chris -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 12:20 PM To: CF-Talk Subject: RE: PL/SQL stumper I have a table like the following.With just CFML (v5) and plain Oracle PL/SQL--ie, no temp tables or stored procedures--is there a way to get, say, the 7 most recent distinct providers?I've tried every which way, even using QofQ with MAXROWS=7, but that only returned the first 7 distinct providers alphabetically.I need to get the first 7 distinct providers in date order with newest first.Can it be done without getting fancy? Thanks, Chris PROVIDER DATESTAMP Eckerd Drugs 25-MAY-04 Walmart 25-MAY-04 Walgreens 23-MAY-04 Publix 23-MAY-04 Hush Puppy Shoes 23-MAY-04 Publix 22-MAY-04 Walgreen's 20-MAY-04 Timmons Drugs 20-MAY-04 Publix Pharmacy 19-MAY-04 Walmart 16-MAY-04 Publix Pharmacy 16-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 Off the top of my head, but does this work?: SELECT provider FROM ( SELECT DISTINCT provider FROM provider_table ORDER BY datestamp DESC ) WHERE rownum = 7 Regards, Dave. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: self varible..
As far as I've seen just leaving the Action blank will always self-submit - correct? Jim Davis Exactally what I needed.. Thanks for the quick replies.. Was trying to figure out how to post a form to itself.. form action="" method=post Seems to work, but is there a better or more correct way? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PL/SQL stumper
This throws an error: ORA-00937: not a single-group group function But it gives me some ideas to work with. Thanks, Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 12:20 PM To: CF-Talk Subject: Re: PL/SQL stumper Lofback, Chris wrote: I need to get the first 7 distinct providers in date order with newest first.Can it be done without getting fancy? PROVIDER DATESTAMP Eckerd Drugs 25-MAY-04 Walmart 25-MAY-04 Walgreens 23-MAY-04 Publix 23-MAY-04 Hush Puppy Shoes 23-MAY-04 Publix 22-MAY-04 Walgreen's 20-MAY-04 Timmons Drugs 20-MAY-04 Publix Pharmacy 19-MAY-04 Walmart 16-MAY-04 Publix Pharmacy 16-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 Publix 14-MAY-04 Walmart 14-MAY-04 SELECT * FROM ( SELECT provider, MAX(datestamp) AS lastDate FROM table ORDER BY MAX(datestamp) DESC ) a WHERE rownum 8 Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: PL/SQL stumper
Lofback, Chris wrote: This throws an error: ORA-00937: not a single-group group function Forgot the GROUP BY: SELECT * FROM ( SELECT provider, MAX(datestamp) AS lastDate FROM table GROUP BY provider ORDER BY MAX(datestamp) DESC ) a WHERE rownum 8 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL Syntax help
What is the syntax for the updatetext() function in SQL 7. What I need to do is replace all occurrences of a word with another word inside a long text field. I have two SQL books and neither explain this fully. Google hasn't been of much help either. On that note, is there any way in enterprise manager or SQL analyzer to edit data in the long text field?? Thanks! Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: page has expired Message
Try passing the values back to the same page, and provide a message asking the user not to use the browser back button, but use the button provided as shown below: form action="" page] method=post cfoutput cfloop collection=#form# item=fieldName input type=hidden name=#fieldName# value=#form[fieldName]# /cfloop /cfoutput input type=Submit name=goback value=Go Back /form Has anyone found a solution concerning the message (warning: page has expired), when one clicks the back button or go(-1). I've tried the following with no success.: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
Get rid of the cftry and cfcatch for now so you can see why the cffile operation isn't working. The CF error should tell you what's wrong. Greg Or, cfcatch cfdump var=#cfcatch# cfabort cfcatch [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Real Log Homes
Quick question, Does anyone know who did the website for Real Log Homes? http://www.realloghomes.com/ If so, could you contact me off-list please? [EMAIL PROTECTED] Ryan Hagan ph: 540-731-3588 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Mach-II
Last summer, there was a lot of optimism on this list surrounding the release of Mach-II and it's object oriented approach to ColdFusion. Having tried it on a few projects and decided Fusebox was better suited for what I was doing, I am now considering it for a larger project my team is about to commence (approx. 9,500 man hours over a 7 month period). One of my main concerns is having to train people to work within this framework, I remain one of three or four people in my organization who have actually heard of Mach-II. There is some resistance based on people's unfamiliarity with it and the perception other frameworks are more widely used. This got me to wondering about how much Mach-II is actually being used, so I am conducting one of those unscientific polls about technology usage: - Does your organization use Mach-II? - Care to comment on how your organization has benefited from using it? M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
The current status of Embedded Form Validation
I'm curious about the current status of this feature?I was a bit surprised when I could not find any mention of it in the current documentation?Does that mean it is deprecated, it's not going to be supported into the future?It still seems to work in the current version. I don't think I ever used this for a finished production project. I do rather like using this feature when developing prototypes, demos, proof of concepts, just plain experimenting.You know, when I don't want to have step down and flesh out a fully featured validation functionality just now, but do want to show how it would basically work. I will be kind of sad, if this is on the way out? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE
In my reference (cfmx): Pathname of directory in which to upload the file. If not an absolute path (starting a with a drive letter and a colon, or a forward or backward slash), it is relative to the ColdFusion temporary directory, which is returned by the GetTempDirectory function. I have never actually tried to specify the filename too. -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 18:45 To: CF-Talk Subject: Re: CFFILE The destination attribute has to be a directory (not a file!). You can find out the name of the uploaded file with #cffile.serverFile#. ??? From the CFML reference: Absolute pathname of directory or file on web server. I know in the past I've used a filename here. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]