RE: testing....is this thing on?
Please leave declarations regarding your personal preferences to the CF-Community list ;-) -Original Message- From: Will The Game [mailto:[EMAIL PROTECTED] Sent: Saturday, 2 April 2005 10:45 To: CF-Talk Subject: Re: testingis this thing on? [snip] POOF! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Web Based Mail Merge? (not email!)
Ok guy's, here's something that has been playing on mind now for far too long and I need to try to come up with a definitive answer of either yes it can be done or no it can't. Here's what I have been asked to do; We have a web based product that a number of our clients use to store information specific to them. From time to time they want to be able to use that information to produce letters. The way that this is currently done is that they download the information that they require in a comma seperated file and then use Microsoft Word to perform a mail merge using the CSV as a data source, with me so far? What I need to know is if it is possible, and if so how, to be able to carry out this same type of mail merge on line and then have the choice of printing or downloading the completed word documents as a file, i.e. is it possible to run the same mail nmerge process on the web server? If so can anyone point me to a source of info for this? Alternatively would anyone know of any other way to acheive this whole letter/mail merge process efficiently? Any advice greatly apreciated, ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Mail Merge? (not email!)
Hya I know this isnt a LOT of help, but a while back I did some stuff like this using ASP. Basicaly in ASP you can create a server object (like an instance of MS Word) and then run commands against it. How that translates to CF I dont know. If it cant be done with CF have a look at ASP and CF could trigger an ASP page to do the merge and then pick up the results Mark Drew On Apr 2, 2005 9:02 AM, Andy Mcshane [EMAIL PROTECTED] wrote: Ok guy's, here's something that has been playing on mind now for far too long and I need to try to come up with a definitive answer of either yes it can be done or no it can't. Here's what I have been asked to do; We have a web based product that a number of our clients use to store information specific to them. From time to time they want to be able to use that information to produce letters. The way that this is currently done is that they download the information that they require in a comma seperated file and then use Microsoft Word to perform a mail merge using the CSV as a data source, with me so far? What I need to know is if it is possible, and if so how, to be able to carry out this same type of mail merge on line and then have the choice of printing or downloading the completed word documents as a file, i.e. is it possible to run the same mail nmerge process on the web server? If so can anyone point me to a source of info for this? Alternatively would anyone know of any other way to acheive this whole letter/mail merge process efficiently? Any advice greatly apreciated, ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Mail Merge? (not email!)
A COM object may be able to do the same work directly in CF. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Saturday, 2 April 2005 5:50 To: CF-Talk Subject: Re: Web Based Mail Merge? (not email!) Hya I know this isnt a LOT of help, but a while back I did some stuff like this using ASP. Basicaly in ASP you can create a server object (like an instance of MS Word) and then run commands against it. How that translates to CF I dont know. If it cant be done with CF have a look at ASP and CF could trigger an ASP page to do the merge and then pick up the results ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Mail Merge? (not email!)
Thats what I meant :) Early saturday morning with hangover... cant seem to get words out MD On Apr 2, 2005 11:01 AM, James Holmes [EMAIL PROTECTED] wrote: A COM object may be able to do the same work directly in CF. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Saturday, 2 April 2005 5:50 To: CF-Talk Subject: Re: Web Based Mail Merge? (not email!) Hya I know this isnt a LOT of help, but a while back I did some stuff like this using ASP. Basicaly in ASP you can create a server object (like an instance of MS Word) and then run commands against it. How that translates to CF I dont know. If it cant be done with CF have a look at ASP and CF could trigger an ASP page to do the merge and then pick up the results ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201259 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Mail Merge? (not email!)
See this page how to convert a word document to html (as an example) http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1585.htm Always remember that you have to have Word installed on the server (obvious I know) MD On Apr 2, 2005 11:01 AM, James Holmes [EMAIL PROTECTED] wrote: A COM object may be able to do the same work directly in CF. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Saturday, 2 April 2005 5:50 To: CF-Talk Subject: Re: Web Based Mail Merge? (not email!) Hya I know this isnt a LOT of help, but a while back I did some stuff like this using ASP. Basicaly in ASP you can create a server object (like an instance of MS Word) and then run commands against it. How that translates to CF I dont know. If it cant be done with CF have a look at ASP and CF could trigger an ASP page to do the merge and then pick up the results ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Mail Merge? (not email!)
Thanks, this looks interesting. This would be ideal if all of the word document formatting was converted also, i.e. page breaks, header, footer, etc. I could then run m y mailmerge against the HTML page and print that off! Maybe wishful thinking!. Would you be able to point me any resource that demonstrates how to do a word mail merge using ASP? Is it actually possible to execute an ASP page from Coldfusion? I would simply need to be able to pass a document template and datasource to word, do a mail merge and then save the result to a file that the user could download and print themselves as word documents, this would be ideal. You can tell it is a Saturday, plenty time to come up with these wish lists! See this page how to convert a word document to html (as an example) http://livedocs.macromedia. com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp. htm?context=ColdFusion_Documentationfile=1585.htm Always remember that you have to have Word installed on the server (obvious I know) MD On Apr 2, 2005 11:01 AM, James Holmes [EMAIL PROTECTED] au wrote: A COM object may be able to do the same work directly in CF. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Saturday, 2 April 2005 5:50 To: CF-Talk Subject: Re: Web Based Mail Merge? (not email!) Hya I know this isnt a LOT of help, but a while back I did some stuff like this using ASP. Basicaly in ASP you can create a server object (like an instance of MS Word) and then run commands against it. How that translates to CF I dont know. If it cant be done with CF have a look at ASP and CF could trigger an ASP page to do the merge and then pick up the results ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Mail Merge? (not email!)
Its not quite like that... the example I posted showed creating a new serverside word com object that you can then manipulate. What the process would be (and you have to find the methods, I cant find them at the moment) create a word object, make that object open your mailmerge template, tell the word object to get some data, merge and save the merge as a file on the server, then return that file. MSDN is a good source for these methods I hope that helps a bit! Regards Mark Drew On Apr 2, 2005 11:15 AM, Andy Mcshane [EMAIL PROTECTED] wrote: Thanks, this looks interesting. This would be ideal if all of the word document formatting was converted also, i.e. page breaks, header, footer, etc. I could then run m y mailmerge against the HTML page and print that off! Maybe wishful thinking!. Would you be able to point me any resource that demonstrates how to do a word mail merge using ASP? Is it actually possible to execute an ASP page from Coldfusion? I would simply need to be able to pass a document template and datasource to word, do a mail merge and then save the result to a file that the user could download and print themselves as word documents, this would be ideal. You can tell it is a Saturday, plenty time to come up with these wish lists! See this page how to convert a word document to html (as an example) http://livedocs.macromedia. com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp. htm?context=ColdFusion_Documentationfile=1585.htm Always remember that you have to have Word installed on the server (obvious I know) MD On Apr 2, 2005 11:01 AM, James Holmes [EMAIL PROTECTED] au wrote: A COM object may be able to do the same work directly in CF. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Saturday, 2 April 2005 5:50 To: CF-Talk Subject: Re: Web Based Mail Merge? (not email!) Hya I know this isnt a LOT of help, but a while back I did some stuff like this using ASP. Basicaly in ASP you can create a server object (like an instance of MS Word) and then run commands against it. How that translates to CF I dont know. If it cant be done with CF have a look at ASP and CF could trigger an ASP page to do the merge and then pick up the results ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
Please leave declarations regarding your personal preferences to the CF-Community list ;-) Sorry about that guys. I shouldn't post that late on a friday evening! Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Mail Merge? (not email!)
I do this all of the time with straight HTML.. Use style sheets to format the pages nicely and to display the letterhead part, and just use cold fusion to insert the variables at the right place. Make sure they set the browser to not print a header or footer. I have a button on a page that whn clicked pops up this new window with just the mail merged pages.. you can use javascript to print it then close it, or let them do it manually. (I do this because the mail merged pages don't have your navigation bars) To get a little fancier, you can also use pdf.. search for dynamic pdf. Al At 03:02 AM 4/2/2005, you wrote: Ok guy's, here's something that has been playing on mind now for far too long and I need to try to come up with a definitive answer of either yes it can be done or no it can't. Here's what I have been asked to do; ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dedicated Hosting
I use mySQL. Net cost: $0. In the case of Crystaltech, they give you free SQL Server space of like 1/2 GB per server. So you're back to $0 again. Or you can use MSDE, which is a low-traffic version of SQL Server (it has a connection limit, but here again if you are just starting out its fine). I use SQL Server for the client's data and MSDE on the local box for things like client variable storage. I then use a product called MSDE Manager for an Enterprise Manager http://www.valesoftware.com/products-msde-manager.php I run it on the server itself when doing terminal server connections, so I don't have to be on an Enterprise Manager-Equipped system to manage the db. I also use it to connect to the Crystaltech SQL Server from the same box. Net cost: $79. I would argue that the value is never lost because once you become master of your own domain (literally) your reliability and capability goes thru the roof. Case in point: All of the crap you've referenced in the other thread would have never happened. On Apr 1, 2005 4:57 PM, Connie DeCinko [EMAIL PROTECTED] wrote: What about SQL Server/MySQL? Are you running that on the same box or is that an additional expense? Where I feel the value is lost is when you have to buy a SQL Server license and CF license for less than 10 sites. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 2:42 PM To: CF-Talk Subject: Re: Re[2]: CrystalTech does not like negative comments! On Apr 1, 2005 6:28 AM, Connie DeCinko [EMAIL PROTECTED] wrote: At what point does it become feasible to go dedicated, considering you have to purchase your own software, etc.? Hosting 5 sites? 10? 25? Boy is that ever a can o' worms! There is no straight, always-right answer. You would have to look at what you are charging people for hosting, how much of that you are turning over to CT and THEN work in these factors: 1. How nice would it be if I could do anything I want on MY server? (CFX's etc.) 2. How stable would my server become if only my own programming is on it? 3. How many sites can I stuff onto this thing? 4. Do I know how to run a server? I am responsible for two clients' servers there so I know how CT sets them up. Its a nice setup, actually. For starters you get your own mail and stats servers (Smartertools' SmarterMail and SmarterStats). I'm not fond of SmarterStats, but its free. And I bought SmarterMail for my own servers as a replacement for IMail when that product went belly up. They also give you Serv-U. Its not the secure version though, but its still Serv-U. Plus your operating system is included. Windows comes with it too. That only leaves CF to buy, which ain't cheap. I suppose you could do BlueDragon's free or $899 versions too. Or you can probably rent CF, and if so it will take you well over a year to equal your rental payments. Maybe a good option, especially if you are just starting out and will be adding (paying) clients over time. Nobody can touch CT's prices on servers, I think. US$80 per month for an admittedly basic unit that would run 10 or so small CF sites just fine. Then bump that up with an upgrade down the road (and keep the $80 server for a dedicated mail server). Those dual-Xeon, 2gb units are dirt cheap for what you get. So cheap I almost jumped ship from my server provider when I expanded recently. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Mail Merge? (not email!)
Hi, Al... Would you explain a little more about how you cause the mail merge to execute? I'm still using CF 4.5.2...is what you're doing possible with that? I've created printable forms using CSS and CF variables, but only as single documents, not as multiple printouts from a mail merge... Rick -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED] Sent: Saturday, April 02, 2005 10:19 AM To: CF-Talk Subject: Re: Web Based Mail Merge? (not email!) I do this all of the time with straight HTML.. Use style sheets to format the pages nicely and to display the letterhead part, and just use cold fusion to insert the variables at the right place. Make sure they set the browser to not print a header or footer. I have a button on a page that whn clicked pops up this new window with just the mail merged pages.. you can use javascript to print it then close it, or let them do it manually. (I do this because the mail merged pages don't have your navigation bars) To get a little fancier, you can also use pdf.. search for dynamic pdf. Al At 03:02 AM 4/2/2005, you wrote: Ok guy's, here's something that has been playing on mind now for far too long and I need to try to come up with a definitive answer of either yes it can be done or no it can't. Here's what I have been asked to do; ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is this campsite available
Keep the list of available campsites in an app-scoped array. When someone searches for available campsites, loop over the array and release the locks on all pending but uncompleted transactions over X minutes long. Then output the result. You'll also need a check so that if someone reserves a site after this list has been output to screen but before the current user clicks 'reserve it for me' themselves, the system can handle this. The risk of race conditions with this is here for the reads and db updates. I'd think using a single named lock around both the array reads, writes and db updates would be necessary to ensure integrity. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201267 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF 5 Windows 2003 Web Edition
I'm trying to get CF 5 running under Windows 2003 Web Edition. I found a technote at Macromedia (www.macromedia.com/go/tn_18689) that provides directions on how to get 5.0 can run under Windows 2003, but it doesn't specifically mention Windows 2003 Web Edition. I followed the instructions in the tech note, but when I click on the CF Admin link, it goes to http://127.0.0.1/CFIDE/Administrator/index.cfm and displays The page cannot be found. CF runs if I download version 7. Any suggestions? Seth Seth Jacobs OnRamp113 (707) 678-0267 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFPOP/CFX_POP3
When I download attachments the file is named winmail.dat. I have striped it down for testing and it doesn't make a dif. The value of #attachments# is always winmail.dat cfx_pop3 action=GETALL NAME=Message SERVER=#Server# USERNAME=#Email# PASSWORD=#MyPassWord# attachmentpath=#attachmentPath# CFPOP does the same. Windows 2003 MX7 The mail server is ArgoSoft. The same attachment come through fine in OutLook. Rick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFPOP/CFX_POP3
Hi Rick, AFAIK, the winmail.dat attachment is an undocumented MS proprietary format for attachments when using Exchange. As CFPOP and CFX_POP and most other mail clients only know about the rfc compliant mail formats. The content-type for that attachment should be microsoft/tnef if you search on Google for that you will find lots of people wanting to know how you decode them If I find some components that I can build into CFX_POP3 then I may just add the feature but I've never come across any and I haven't the time to reverse engineer their undocumented format... :( Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFPOP/CFX_POP3
Rick, I just found a free java implementation of a TNEF decoder http://www.freeutils.net/source/jtnef/ Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
flashservices with virtual domain
I know this has to be a common issue, so I'm surprised I have not been able to find anything more recent on it. We have a shared hosting environment with CFMX6.1 and IIS6. Most of the domains are your standard www.ourdomain.com/account/... There are, however 2-3 virtual domains on the server. It's not a particularly tech-adventurous bunch so not too many people are using things like flash cfchart and certainly not flash remoting. I wanted to throw up Pollster on our MMUG site but it is one of the few virtual domains and the flashservices does not appear to know about it. If I put it on www.ourdomain.com/myaccount/index.cfm it will work, but not on www.myvirtualdomain.com/index.cfm. I am pretty sure the server admins will make things nice if I do the legwork for them. The best thing I’ve been able to find so far is: http://www.macromedia.com/support/flashremoting//ts/documents/iis_gateway_connection.htm Is this the lastest word? Thanks, Bob ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201272 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Filter Output Based on List
Working on a page that outputs headlines and copy from several RSS News Feeds. I need to do some filtering though, as the page is target towards kids and the feeds can sometimes contain some iffy stuff. So, I've got a list of words rejectLIST and if the body copy contains any of the words from rejectLIST, then that entry should be skipped. In sorta Coldfusion/English If rss.bodycopy does not contain anything in #rejectLIST# Display this feed entry /cfif Can't seem to get the syntax quite right -- --- Les Mizzell ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201273 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFPOP/CFX_POP3
I downloaded this and put in my class path but it still doing the same thing. Is there something I need to do to the file? And can I do it on the server for all users. Is this something that will allow you to update CFX_POP3? Rick -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: April 2, 2005 1:05 PM To: CF-Talk Subject: RE: CFPOP/CFX_POP3 Rick, I just found a free java implementation of a TNEF decoder http://www.freeutils.net/source/jtnef/ Paul ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFPOP/CFX_POP3
Hi Rick, I'm afraid it isn't something that would allow me to update CFX_POP3 however this ne could actually be used in CFPOP if MM so chose to build it in :) On the other hand, I have found a component that will work with CFX_POP3 however it still requires some work as it has been neglected for about 6 years and is not compatible with CFX_POP3 straight out of the box so to speak... Going back to the jar file you have installed, you will need to look out for the winmail.dat files in the attachments field that CFPOP and CFX_POP3 generate and then instantiate the tnef decoder object using a UDF or CFC to wrap up the funcionality of the jar file that you now have in your classpath. Essentially the UDF/CFC would read the attachment into a filestream and then pass it to the TNEFInputStream class to decode it and let you manipulate the attachments that are held within the .dat file. HTH Paul -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED] Sent: Saturday, 02 April 2005 21:57 To: CF-Talk Subject: RE: CFPOP/CFX_POP3 I downloaded this and put in my class path but it still doing the same thing. Is there something I need to do to the file? And can I do it on the server for all users. Is this something that will allow you to update CFX_POP3? Rick -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: April 2, 2005 1:05 PM To: CF-Talk Subject: RE: CFPOP/CFX_POP3 Rick, I just found a free java implementation of a TNEF decoder http://www.freeutils.net/source/jtnef/ Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Filter Output Based on List
Les Mizzell wrote: Working on a page that outputs headlines and copy from several RSS News Feeds. I need to do some filtering though, as the page is target towards kids and the feeds can sometimes contain some iffy stuff. So, I've got a list of words rejectLIST and if the body copy contains any of the words from rejectLIST, then that entry should be skipped. In sorta Coldfusion/English If rss.bodycopy does not contain anything in #rejectLIST# Display this feed entry /cfif cfset rejectRE = ( ListChangeDelims(rejectList, |) ) cfif NOT REFindNoCase(rejectRegEx, rss.bodycopy) Display this feed entry /cfif Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Filter Output Based on List
If rss.bodycopy does not contain anything in #rejectLIST# Display this feed entry /cfif Assuming rejectLIST is a comma delimited list, run this for each entry to test... cfset variables.show_entry = 1 cfloop list=#rejectLIST# index=i cfif findNoCase(i, rss.bodycopy) cfset variables.show_entry = 0 cfbreak /cfif /cfloop cfif variables.show_entry Display here. /cfif Since you're wanting to find any one of several words within a string, you need to break the list down and search for each work individually. If one is found, set the show bit to false and break out. This code would be contained within your RSS output loop. --- Justin D. Scott Vice President Sceiron Interactive, Inc. www.sceiron.com [EMAIL PROTECTED] 941.378.5341 - office 941.320.2402 - mobile 877.678.6011 - facsimile ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Filter Output Based on List
If rss.bodycopy does not contain anything in #rejectLIST# Display this feed entry /cfif cfset rejectRE = ( ListChangeDelims(rejectList, |) ) cfif NOT REFindNoCase(rejectRegEx, rss.bodycopy) Display this feed entry /cfif I like Jochem's solution better than mine. Less code, more elegant. --- Justin D. Scott Vice President Sceiron Interactive, Inc. www.sceiron.com [EMAIL PROTECTED] 941.378.5341 - office 941.320.2402 - mobile 877.678.6011 - facsimile ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Mail Merge? (not email!)
I am actually using 4.5.2 on my server as well! (It is a small non-profit brain cancer organization - and they can't afford to upgrade:) As I see it, your problem is creating multiple pages. There are a few approaches. The nicest is to use CSS to force a page break after each page, but when I did this, I had to deal with older browsers, so I cheated by just using [br] tag to get to the next page. I have a setup page that you use to determine how many lines are printed on your printer, and save that number in a cookie. Then as I loop through each record I set a line counter to see how many lines are used (for example, if there is no address line 2, I don't leave an empty space).. then after the content, I figure out how many [br] tags are needed to get to the next line. Works remarkably well. The only problems: you have to have the user set the header and footer in their browser to blanks, and it only works for 1 font size.. if they set their browser to a bigger or smaller font, they have to figure out how many lines per page again Al At 10:45 AM 4/2/2005, you wrote: Hi, Al... Would you explain a little more about how you cause the mail merge to execute? I'm still using CF 4.5.2...is what you're doing possible with that? I've created printable forms using CSS and CF variables, but only as single documents, not as multiple printouts from a mail merge... Rick -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED] Sent: Saturday, April 02, 2005 10:19 AM To: CF-Talk Subject: Re: Web Based Mail Merge? (not email!) I do this all of the time with straight HTML.. Use style sheets to format the pages nicely and to display the letterhead part, and just use cold fusion to insert the variables at the right place. Make sure they set the browser to not print a header or footer. I have a button on a page that whn clicked pops up this new window with just the mail merged pages.. you can use javascript to print it then close it, or let them do it manually. (I do this because the mail merged pages don't have your navigation bars) To get a little fancier, you can also use pdf.. search for dynamic pdf. Al At 03:02 AM 4/2/2005, you wrote: Ok guy's, here's something that has been playing on mind now for far too long and I need to try to come up with a definitive answer of either yes it can be done or no it can't. Here's what I have been asked to do; ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Filter Output Based on List
Others have given you your answer on what you were looking for, but I want to give you and others who are working with feeds some ideas to better work with them. 1. Do your processing on a scheduled basis and parse the feed into a database. 2. Do any other processing on the feed before you enter it into the database. 3. Display the data results from the database. I've seen far too many people get/parse/display the feed for every request to their site. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Access query problem in CF
Hi all, This query works great in Access but through CF and datasource, it says too few parameters, any ideas? SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE FORMAT(statistique.date_in,hh) = 11 Thanks Pat ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Mail Merge? (not email!)
you could generate RTF files on the files. add mailmerge fields to a word document - save as RTF and us CF to generate RTF and make available for download. - Original Message - From: Andy Mcshane [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, April 02, 2005 2:02 AM Subject: Web Based Mail Merge? (not email!) Ok guy's, here's something that has been playing on mind now for far too long and I need to try to come up with a definitive answer of either yes it can be done or no it can't. Here's what I have been asked to do; We have a web based product that a number of our clients use to store information specific to them. From time to time they want to be able to use that information to produce letters. The way that this is currently done is that they download the information that they require in a comma seperated file and then use Microsoft Word to perform a mail merge using the CSV as a data source, with me so far? What I need to know is if it is possible, and if so how, to be able to carry out this same type of mail merge on line and then have the choice of printing or downloading the completed word documents as a file, i.e. is it possible to run the same mail nmerge process on the web server? If so can anyone point me to a source of info for this? Alternatively would anyone know of any other way to acheive this whole letter/mail merge process efficiently? Any advice greatly apreciated, ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201282 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Filter Output Based on List
1. Do your processing on a scheduled basis and parse the feed into a database. I hadn't really thought about that before. This isn't a super high traffic site but I'm sure the host would appreciate it since it's on a shared server and all Thanks, -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Access query problem in CF
How about this: SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE datepart(h,statistique.date_in) = 11 Access has a DatePart function like CF does... HTH, Howie --- On Saturday, April 02, 2005 6:04 PM, CFDEV scribed: --- Hi all, This query works great in Access but through CF and datasource, it says too few parameters, any ideas? SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE FORMAT(statistique.date_in,hh) = 11 Thanks Pat ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Mail Merge? (not email!)
Hi, Eric... Can you provide more detail on how CF would generate the RTF? Rick -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED] Sent: Saturday, April 02, 2005 6:57 PM To: CF-Talk Subject: Re: Web Based Mail Merge? (not email!) you could generate RTF files on the files. add mailmerge fields to a word document - save as RTF and us CF to generate RTF and make available for download. - Original Message - From: Andy Mcshane [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, April 02, 2005 2:02 AM Subject: Web Based Mail Merge? (not email!) Ok guy's, here's something that has been playing on mind now for far too long and I need to try to come up with a definitive answer of either yes it can be done or no it can't. Here's what I have been asked to do; We have a web based product that a number of our clients use to store information specific to them. From time to time they want to be able to use that information to produce letters. The way that this is currently done is that they download the information that they require in a comma seperated file and then use Microsoft Word to perform a mail merge using the CSV as a data source, with me so far? What I need to know is if it is possible, and if so how, to be able to carry out this same type of mail merge on line and then have the choice of printing or downloading the completed word documents as a file, i.e. is it possible to run the same mail nmerge process on the web server? If so can anyone point me to a source of info for this? Alternatively would anyone know of any other way to acheive this whole letter/mail merge process efficiently? Any advice greatly apreciated, ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: testing....is this thing on?
If I made a lot of money on advertising, it would be nice. The offer was 100% of what I made in advertising over the last 12 months (not much) plus 1/12 of that per month to keep me on. I've never been in this for the money and my advertising revenue reflects that. :) I gotta ask - was it a nice amount? Enough to put the kiddies through college? :) Ray At 05:59 PM 4/1/2005, you wrote: ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Mail Merge? (not email!)
Hi, Al... Thanks for the explanation. How do you code a page break in CSS? Rick -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED] Sent: Saturday, April 02, 2005 4:53 PM To: CF-Talk Subject: RE: Web Based Mail Merge? (not email!) I am actually using 4.5.2 on my server as well! (It is a small non-profit brain cancer organization - and they can't afford to upgrade:) As I see it, your problem is creating multiple pages. There are a few approaches. The nicest is to use CSS to force a page break after each page, but when I did this, I had to deal with older browsers, so I cheated by just using [br] tag to get to the next page. I have a setup page that you use to determine how many lines are printed on your printer, and save that number in a cookie. Then as I loop through each record I set a line counter to see how many lines are used (for example, if there is no address line 2, I don't leave an empty space).. then after the content, I figure out how many [br] tags are needed to get to the next line. Works remarkably well. The only problems: you have to have the user set the header and footer in their browser to blanks, and it only works for 1 font size.. if they set their browser to a bigger or smaller font, they have to figure out how many lines per page again Al At 10:45 AM 4/2/2005, you wrote: Hi, Al... Would you explain a little more about how you cause the mail merge to execute? I'm still using CF 4.5.2...is what you're doing possible with that? I've created printable forms using CSS and CF variables, but only as single documents, not as multiple printouts from a mail merge... Rick -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED] Sent: Saturday, April 02, 2005 10:19 AM To: CF-Talk Subject: Re: Web Based Mail Merge? (not email!) I do this all of the time with straight HTML.. Use style sheets to format the pages nicely and to display the letterhead part, and just use cold fusion to insert the variables at the right place. Make sure they set the browser to not print a header or footer. I have a button on a page that whn clicked pops up this new window with just the mail merged pages.. you can use javascript to print it then close it, or let them do it manually. (I do this because the mail merged pages don't have your navigation bars) To get a little fancier, you can also use pdf.. search for dynamic pdf. Al At 03:02 AM 4/2/2005, you wrote: Ok guy's, here's something that has been playing on mind now for far too long and I need to try to come up with a definitive answer of either yes it can be done or no it can't. Here's what I have been asked to do; ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201287 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Access query problem in CF
Thanks but it still says too few parameters :( I'm on CFMX 6.1 with a MS Accecss datasource. Pat -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: April 2, 2005 19:41 To: CF-Talk Subject: Re: Access query problem in CF How about this: SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE datepart(h,statistique.date_in) = 11 Access has a DatePart function like CF does... HTH, Howie --- On Saturday, April 02, 2005 6:04 PM, CFDEV scribed: --- Hi all, This query works great in Access but through CF and datasource, it says too few parameters, any ideas? SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE FORMAT(statistique.date_in,hh) = 11 Thanks Pat ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Access query problem in CF
Have you looked at the docs for DatePart() in Access? What does it say about the arguments required? Ade -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: 03 April 2005 03:49 To: CF-Talk Subject: RE: Access query problem in CF Thanks but it still says too few parameters :( I'm on CFMX 6.1 with a MS Accecss datasource. Pat -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: April 2, 2005 19:41 To: CF-Talk Subject: Re: Access query problem in CF How about this: SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE datepart(h,statistique.date_in) = 11 Access has a DatePart function like CF does... HTH, Howie --- On Saturday, April 02, 2005 6:04 PM, CFDEV scribed: --- Hi all, This query works great in Access but through CF and datasource, it says too few parameters, any ideas? SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE FORMAT(statistique.date_in,hh) = 11 Thanks Pat ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201289 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Access query problem in CF
Yes, the documentation is exactly what the query is.. And it works in queries of Access, but when I do it through CF it doesn't :( Pat -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: April 2, 2005 21:54 To: CF-Talk Subject: RE: Access query problem in CF Have you looked at the docs for DatePart() in Access? What does it say about the arguments required? Ade -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: 03 April 2005 03:49 To: CF-Talk Subject: RE: Access query problem in CF Thanks but it still says too few parameters :( I'm on CFMX 6.1 with a MS Accecss datasource. Pat -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: April 2, 2005 19:41 To: CF-Talk Subject: Re: Access query problem in CF How about this: SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE datepart(h,statistique.date_in) = 11 Access has a DatePart function like CF does... HTH, Howie --- On Saturday, April 02, 2005 6:04 PM, CFDEV scribed: --- Hi all, This query works great in Access but through CF and datasource, it says too few parameters, any ideas? SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE FORMAT(statistique.date_in,hh) = 11 Thanks Pat ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
jump menu
anyone got a good dynamic jump menu? thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201291 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Cfchart alternative to be compatible with CF and BD
Hi What are you using to do chart and be compatible with CF MX and BlueDragon? Thanks Pat ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
