simple SQL Question
what does the *= mean in a query. For example: select a.id, b.name from a inner join b on a.id = b.id where a.id *= b.id Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325598 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: simple SQL Question
*= is actually used at my work place. Thanks for the answer. From: Adrian Lynch cont...@adrianlynch.co.uk To: cf-talk cf-talk@houseoffusion.com Sent: Friday, August 21, 2009 5:59:17 PM Subject: RE: simple SQL Question That is a left outer join. It's mixing new and old styles of joining tables. Not sure if there's a benefit to the mix, but I reckon this is clearer: SELECT a.id, b.name FROM a INNER JOIN b ON a.id = b.id LEFT OUTER JOIN b ON a.id = b.id Is this code actually used or an example for the question? Adrian -Original Message- From: Discover Antartica [mailto:discoverantart...@yahoo.com] Sent: 22 August 2009 00:50 To: cf-talk Subject: simple SQL Question what does the *= mean in a query. For example: select a.id, b.name from a inner join b on a.id = b.id where a.id *= b.id Thank ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pardon me, but I need to know a mailing list for SSIS questions
Hello All, can someone help me with finding a mailing list similar to cf-talk for SQL Server Integration Services questions? If someone can help me with this, I would be thankful! DA ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Losing Mail?
Hi All, If I run the following code, I am getting only 49 emails instead of 50. : cfloop cfoutputfrom=1to=50index=icounter:#i#br/cfoutput[EMAIL PROTECTED][EMAIL PROTECTED]subject=#i##i#/cfmail/cfloop cfabort The counter shows 1 to 50. The email is sent from 2 to 50. Does cfmail always lose the first email from a list? Thanks DA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Are nested loops allowed in fusebox 5?
Hi All, Are nested loops allowed in fusebox 5? If so, can I have the syntax? Thanks DA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Are nested loops allowed in fusebox 5?
Hi, I have tried the following and it worked! loop query=q_somequery loop query=q_someotherquery do action=msca.testfuseaction/ /loop do action=MSCA.testfuseaction2 / /loop Thanks guys! - Original Message From: Nathan Strutz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, September 12, 2008 4:36:17 PM Subject: Re: Are nested loops allowed in fusebox 5? Claude, DA is probably talking about the fusebox XML language, which is, in essence a programming language (a DSL even). In that case, yes, you should be able to nest loops. Maybe posting some code asking why it's not working would be a better idea. In general, it goes like this: loop [tag attributes] loop [tag attributes] do or set or whatever / /loop /loop nathan strutz http://www.dopefly.com/ Manager - AZCFUG http://www.azcfug.org/ On Fri, Sep 12, 2008 at 3:25 PM, Claude Schneegans [EMAIL PROTECTED] wrote: Are nested loops allowed in fusebox 5? I'm not sure I understand your question: Fusebox is not a language, just a framework, and as such has no mean to allow loops or not. Fusebox relies on the ColdFusion language, and yes, CF allows nested loops. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: is it possible to open cfml page from sql server stored procedure?
I am using CF8. Can you send me the syntax for using wget or cURL? I tried the following and it gave me an error: EXEC master..xp_cmdshell 'cURL http://www.mywebsite.com' The error i got was: 'cURL' is not recognized as an internal or external command, operable program or batch file. Thanks - Original Message From: Terry Schmitt [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, January 25, 2008 4:08:29 PM Subject: Re: is it possible to open cfml page from sql server stored procedure? You didn't specify the CF version, but for CF6+ use wget or cURL. In the old days with CF5 (and still for me) you can actually execute the CF executable with the page as a parameter. T Hello All Is there a way to execute a coldfusion file from a microsoft sql server stored procedure? In other words, since cf files don't have a .exe extension, is it possible to open a cfml page from a sql stored procedure? note: i can open sql files and run them by using commands such as the following: EXEC master..xp_cmdshell 'osql -E -i \\mycomputernetworkname\Driveletter\foldername\testing.sql' best regards DA ___ _ Never miss a thing. Make Yahoo your home page. http://www.yahoo. com/r/hs ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: is it possible to open cfml page from sql server stored procedure?
My goal is to run a series of stored procedures. At one point, while I run the stored procedures, I need to run coldfusion code which has a cfquery tag and some complex if and else conditions which are easier done in coldfusion than t-sql. All I need to do is to open up that page in a browser and since the coldfusion code for that page has the queries and other logic which i want to run, it will execute that just by opening the url with that .cfm file in a browser. once that is done, i want to continue on with executing other stored procedures. so, basically, i want to know if i can open a browser window and call a coldfusion page through sql server. I think the code you have in VBScript might be the solution I am looking for. I will try to find out how to call the vbscript through sql. I will try that and will let you know if I have issues. I would like to thank all of you for your responses to help me. DA - Original Message From: Alan Rother [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, January 25, 2008 4:00:32 PM Subject: Re: is it possible to open cfml page from sql server stored procedure? I think to help we may need to know what your goal is. That is to say, do you want to have SQL Server read the contents of the cfm file itself, or perhaps the results of the CFM file? Or do you simply need to fire off some CF process once your SQL Server process has reached a certain point. If the last on is the case, then you should be able to have SQL Server fire off a VB Script the can trigger the CF code. Strangely enough, I had to be a VBscript do just that today. I don't know offhand how to make the SQL call the VB, but I do know it can do that. Here is the VB code I used URL = http://www.SomeWebsite.com; Set WshShell = WScript.CreateObject(WScript.Shell) Set http = CreateObject(Microsoft.XmlHttp) http.open GET, URL, FALSE http.send set WshShell = nothing set http = nothing HTH =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: is it possible to open cfml page from sql server stored procedure?
I tried the following: EXEC master..xp_cmdshell 'wget http://www.example.com/index.cfm' I got this error message: 'wget' is not recognized as an internal or external command, operable program or batch file. - Original Message From: Russ [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, January 25, 2008 3:24:50 PM Subject: RE: is it possible to open cfml page from sql server stored procedure? EXEC master..xp_cmdshell 'wget http://www.example.com/index.cfm' -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Friday, January 25, 2008 4:44 PM To: CF-Talk Subject: Re: is it possible to open cfml page from sql server stored procedure? Yes, you can use a DTS package to run a script that makes an HTTP call. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Discover Antartica wrote: Hello All Is there a way to execute a coldfusion file from a microsoft sql server stored procedure? In other words, since cf files don't have a .exe extension, is it possible to open a cfml page from a sql stored procedure? note: i can open sql files and run them by using commands such as the following: EXEC master..xp_cmdshell 'osql -E -i \\mycomputernetworkname\Driveletter\foldername\testing.sql' best regards DA __ __ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297498 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
is it possible to open cfml page from sql server stored procedure?
Hello All Is there a way to execute a coldfusion file from a microsoft sql server stored procedure? In other words, since cf files don't have a .exe extension, is it possible to open a cfml page from a sql stored procedure? note: i can open sql files and run them by using commands such as the following: EXEC master..xp_cmdshell 'osql -E -i \\mycomputernetworkname\Driveletter\foldername\testing.sql' best regards DA Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SPAM: Re: is it possible to open cfml page from sql server stored procedure?
Would you be able to send me the command your dba uses to open a http page through sql? - Original Message From: Andy Matthews [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, January 25, 2008 3:04:17 PM Subject: RE: SPAM: Re: is it possible to open cfml page from sql server stored procedure? You can certainly run CFM pages via their http path. Our dba does that all the time when he needs to trigger something on the CF side. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, January 25, 2008 3:34 PM To: CF-Talk Subject: SPAM: Re: is it possible to open cfml page from sql server stored procedure? Discover Antartica wrote: Hello All Is there a way to execute a coldfusion file from a microsoft sql server stored procedure? In other words, since cf files don't have a .exe extension, is it possible to open a cfml page from a sql stored procedure? note: i can open sql files and run them by using commands such as the following: EXEC master..xp_cmdshell 'osql -E -i \\mycomputernetworkname\Driveletter\foldername\testing.sql' best regards DA UMMM maybe. You could possible open the browser executable (ie.exe for example) with the url to the CFM template is a parameter. What good this would do for you I can not imagine. In other words you are not likely able to do what you are trying to do. CFML is not meant to be run outside of a web-server/client environment. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297500 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cannot create a datasource from cf admin
Dear All, In the new architecture design, the coldfusion server is located on a server in DMZ in the public domain. The sql server is in the internal netwok. I am unable to create a datasource from coldfusion admin page to the sql server 2005 instance that I am running on the server that is not in the dmz. please note that I have two instances of sql server installed on the server, 2000 default instance and 2005 named instance. i am unable to ping the named instance or create a datasource. i am able to ping and create a datasource to the default instance. please advise on what are the steps to create a datasource from coldfusion (in dmz) to a sql server which is not in the dmz. i get an error saying that either the login info is incorrect or the server does not exist. best regards, DA Note: The CF server is CF 8 - Original Message From: Joel Stobart [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, January 22, 2008 9:52:50 AM Subject: Re: poll - How many MS should it take to load a site's home page? I agree with the 1 to 2 seconds on Broadband. I allow 10 seconds on my phone. Its all to do with how long you think it *should* take. I just though I would share with everyone a really interesting page on the android website. http://code.google.com/android/toolbox/philosophy.html. It talks about fast, efficient, and seamless code. I think its well worth a read. Cheers, Joel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looks like hard to find data modelers in the CF community
Looks like it is hard to find data modelers in the CF community. Anyone know of any mailing list for database designers or data modelers? The CF application that we have created for ETL is going to be shot dead before it is even sold to the first client if the Logical Data Model issue is not resolved. There are already talks about trashing the entire tool. I know this is unrelated, so again, I apologize. - Original Message From: Discover Antartica [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, April 6, 2006 2:16:21 PM Subject: Re: CF interacting with Teradata Server It is a, if you will, a baby copy of Informatica (informatica is the 800 pound guirella in the ETL market). - Original Message From: Munson, Jacob [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, April 6, 2006 2:04:33 PM Subject: RE: CF interacting with Teradata Server There is an application that is built entirely in Coldfusion for doing ETL (Extraction Transformation and Loading) of data from one database into another. I'm off topic from your original post, but what is this CF based ETL? I had no idea such an animal existed...or is that what you are trying to build? --- [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237188 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: Looks like hard to find data modelers in the CF community
Yes. That was the original question and if anyone comes across any off-the-shelf data model, please let me know. Maybe your company database guys may know of any resource, maybe they have done something similar. My company is willing to pay for the model if we think it is going to be beneficial... just for humor, here is a saying when dealing with databases: don't drink and derive. thanks all - Original Message From: Nick de Voil [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, April 7, 2006 12:16:25 PM Subject: Re: Looks like hard to find data modelers in the CF community I don't think anyone mentioned an off-the-shelf data model. That's what the OP was asking for, in fact. The original thread was called CF interacting with Teradata Server: There is an application that is built entirely in Coldfusion for doing ETL (Extraction Transformation and Loading) of data from one database into another. Now, in order to test this tool on a real time project, there is an unrelated issue that is taking time. We need to design the database in Teradata and then use this tool to map data from SQL Server tables into Teradata tables. In order to create the database design, I have been asked to find out the best Logical Data Models there are in the industry. The company is willing to pay money to purchase those models. We are looking for retail LDM samples in general and coupon business related in particular. I do not know how to do the research and find the best commercial LDM out there. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237200 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: Looks like hard to find data modelers in the CF community
I am trying to create a Logical Data Model for Coupon business over the internet. The client is a sort of amazon.com for coupons. We need to build a data warehouse for them. - Original Message From: Deanna Schneider [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, April 7, 2006 12:47:43 PM Subject: Re: Looks like hard to find data modelers in the CF community I think it's a faulty assumption that just because no one knows of an off-the-shelf data model for a project for which we have no parameters that there are no data modelers in the CF community. I love data modeling. In fact, if anything, I probably jump into data modeling too early on in a project, just because I'm so excited about that aspect of it. I went back and reread the original thread, and I guess I'm still not even sure what you're asking for. There are examples of data models out there for various projects. I happen to have 2 sitting on my desk right now for shopping cart products. What are you trying to resolve with this data model? On 4/7/06, Discover Antartica [EMAIL PROTECTED] wrote: Looks like it is hard to find data modelers in the CF community. Anyone know of any mailing list for database designers or data modelers? The CF application that we have created for ETL is going to be shot dead before it is even sold to the first client if the Logical Data Model issue is not resolved. There are already talks about trashing the entire tool. I know this is unrelated, so again, I apologize. - Original Message From: Discover Antartica [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, April 6, 2006 2:16:21 PM Subject: Re: CF interacting with Teradata Server It is a, if you will, a baby copy of Informatica (informatica is the 800 pound guirella in the ETL market). - Original Message From: Munson, Jacob [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, April 6, 2006 2:04:33 PM Subject: RE: CF interacting with Teradata Server There is an application that is built entirely in Coldfusion for doing ETL (Extraction Transformation and Loading) of data from one database into another. I'm off topic from your original post, but what is this CF based ETL? I had no idea such an animal existed...or is that what you are trying to build? --- [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237207 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
CF interacting with Teradata Server
Hello All, this is a question that may fall beyond what is this mailing list is for,so my apologies for doing that. But, I am in a dilemma. There is an application that is built entirely in Coldfusion for doing ETL (Extraction Transformation and Loading) of data from one database into another. Now, in order to test this tool on a real time project, there is an unrelated issue that is taking time. We need to design the database in Teradata and then use this tool to map data from SQL Server tables into Teradata tables. In order to create the database design, I have been asked to find out the best Logical Data Models there are in the industry. The company is willing to pay money to purchase those models. We are looking for retail LDM samples in general and coupon business related in particular. I do not know how to do the research and find the best commercial LDM out there. Can someone guide me on this? Thank You. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237119 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: CF interacting with Teradata Server
It is a, if you will, a baby copy of Informatica (informatica is the 800 pound guirella in the ETL market). - Original Message From: Munson, Jacob [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, April 6, 2006 2:04:33 PM Subject: RE: CF interacting with Teradata Server There is an application that is built entirely in Coldfusion for doing ETL (Extraction Transformation and Loading) of data from one database into another. I'm off topic from your original post, but what is this CF based ETL? I had no idea such an animal existed...or is that what you are trying to build? --- [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237126 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
CF built in web server
I installed CFMX7 on a pc with xp home. I want to make the home page of my site to http://127.0.0.1:8500 but i am unable to accomplish that. I always have to say http://127.0.0.1/mySite. The path of my site is C:\CFUSIONMX7\WWWROOT\MySite Does anyone know how to accomplish this? ~| 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:227677 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
Calendar in the form
Hello, I have to create a form with a link that will pop up a calendar. The user can select a date from that calendar. The textbox field in the form will be filled with the date the user selects. Can someone tell me how to do this? We have decided not to use cfform in our company. thanks. DA - Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. ~| 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:220196 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: CF Test
Unfortunately, I would not be able to disclose the company name. My apologies. Brian Simmons [EMAIL PROTECTED] wrote:Discover Antartica wrote: Here are some questions that a company asked a friend of mine during an interview. I just wanted to see if he answered them correctly. Jochem wrote: So give us the his answers and I will tell you how he did without spoiling the test results of future applicants :) Most (if not all) of these questions were taken verbatim directly from CFMX Exam Buster 7.0 (http://centrasoft.com). So if an applicant wanted to pass this employer's test, that'd be one easy way to pass. If Discover Antartica could let me know what employer was giving this test, I'd be curious to see if they were trying to pass off these questions as their own. If you download the demo of CFMX Exam Buster 7.0 (which allows you to take 1 full test), you'll see: - question #36 is the EXACT question about insert SMITH into the EMP table. - question #60 is the EXACT question about GTE (this poster's #14) And there are more. In fact, I think they're all from the DEMO version. Thanks, Brian -- Brian Simmons [EMAIL PROTECTED] The ultimate ColdFusion MX 7.0 Certification testing tool: Check out CFMX Exam Buster 7.0 at: http://centrasoft.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:216983 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
CF Test
Here are some questions that a company asked a friend of mine during an interview. I just wanted to see if he answered them correctly. Can someone say the answers. Just type like this to save time: 1. a 2. b 3. c etc. Here are the questions: 1) Which path is used in the template attribute in the CFINCLUDE tag? a) physical path b) calling template relative path c) web document root relative path d) any directory under Cfusion\CustomTags 2) If you have the following variable definition in the Application.cfm file, what is the scope of the variable after it is created? CFSET x = foo a) Variables (local) b) Application c) Session d) Request 3) What is missing from the following CFQUERY tag's SELECT statement if you want to return the count? CFQUERY NAME=test DATASOURCE=test SELECT Count(*) FROM TestTable /CFQUERY a) SELECT Count(CountVar) b) SELECT Count(*) AS CountVar c) SELECT Count(*) INTO CountVar d) SELECT Count(*) CFQUERYPARAM NAME=CountVar 4) Which of the following ANSI standard WHERE clauses will return all rows where City begins with the letter S? a) WHERE City LIKE S b) WHERE City = 'S*' c)WHERE City LIKE 'S_' d) WHERE City LIKE 'S%' 5) Which one of the following tags is used for server-side validation? (Choose one.) a) input type =text b) input type=hidden c) input value=hidden d) input value=text 6) What does the following code do? CFSET myArray=Array CFSET Evaluatex= myArray New()) a) Creates a new empty array called myArray b) Creates a new empty array called x c) Creates a new string called x with a value of ArrayNew() d) The code will produce an error 7) The CFSELECT tag must be nested inside which of the following tag blocks? a) CFFORM/CFFORM b) FORM/FORM c) CFQUERY/CFQUERY d) CFINPUT/CFINPUT e) None of the choices, CFSELECT is not required to be nested in a parent tag block 8) Which attribute of the CFAPPLICATIONtag specifies where to store login information? a) COOKIESTORAGE b) SESSIONSTORAGE c) LOGIN d) LOGINSTORAGE e) No such attribute exists 9) Which aggregate function in SQL can return the largest value found in a numeric column in a table? a) Sum b) Count c) Min d) Maximum e) Max 10) Suppose you have a table called Emp, and it has one colulmn called LNAME. Which of the following SQL statement would correctly insert the value SMITH into the EMP table? a) INSERT INTO EMP (LNAME) VALUES (SMITH) b) INSERT INTO EMP (LNAME) VALUES (SMITH) c) INSERT EMP (LNAME) VALUES (SMITH) d) INSERT VALUES EMP (LNAME) INTO (SMITH) e) INSERT INTO EMP (LNAME) VALUE (SMITH) 11) True or False. The ACTION attribute value of a FORM tag cannot have URL query string appended to it. a) True b) False 12) Suppose you have the following CFML code, what would be displayed to the user? CFSET aryTemp = ArrayNew(1) CFSET aryTemp[1] = ArrayNew(1) CFSET aryTemp[1][1] = First CFOUTPUT#aryTemp[1]#/CFOUTPUT a) First b) aryTemp c) Nothing would be displayed to the user d) An error would be displayed to the user 13) If you start the path to a CFINCLUDE template with a forward slash (/), ColdFusion will first search for the template in which of the following? a) The calling pages directory b) Other directories by using relative pathing c) The web roots main directory d) The Directory explicitly mapped in the ColdFusion administrator e) The ColdFusion installation directory 14) Which od the following is the ColdFusion operator for greated than or equal to (=) in a CFIF statement? a) GREATER THAN OR EQUAL TO b) GEQUAL TO c) GE d) GTE e) GREATERTHANEQUAL 15) Assume you have a valid CFQUERY with the name of TEST and the SQL SELECT statement contains a valid column called EMP_ID and the query returns 2 rows. What would the following CFML code display to the user? CFOUTPUT CFLOOP INDEX=i FROM=1 TO=#test.RecordCount##test.emp_id[i]#/CFLOOP /CFOUTPUT a) Nothing would be displayed to the user b) The two emp_id column values would be shown to the user c) The firstemp_id column value would be shown twice to the user d) #test.emp_id[i]##test.emp_id[i]# e) An error would be displayed to the user Regards DA
why do e mails go into the Undelivr folder?
Why do e mails go into the Undelivr folder? Why? What can we do to prevent that or to send emails already in the folder automatically? ~| 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:194797 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: why do e mails go into the Undelivr folder? is there any improvement in MX 7?
Is there any improvement to this in MX 7? or we still have to move the mails manually from the undelivr folder to the spool folder? Jeff Garza [EMAIL PROTECTED] wrote:Any number of reasons actually... I wrote a template that scans the undelivr folder, parses out the CF mail headers and sends it to the IIS SMTP queue for redelivery. Unfortunately, I have to re-write it to deal with CFMX instead of CF5... Would be nice if CF had a setting in the CF Administrator to set a number of retries per message before giving up like a proper SMTP service is supposed to do... Cheers, Jeff Garza - Original Message - From: Discover Antartica To: CF-Talk Sent: Tuesday, February 15, 2005 10:16 AM Subject: why do e mails go into the Undelivr folder? Why do e mails go into the Undelivr folder? Why? What can we do to prevent that or to send emails already in the folder automatically? ~| 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:194805 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
Refreshing the page gives problems
The form in the page is submitting to the same page. If the user refreshes the page, then, the query to insert the record filled out in the form is executed again. So, the number of records in the table keep increasing. is there a way to prevent this? The primary key in the table the data is being inserted is a counter that increments itself. It is not part of the query that is inserting the new records. merci! ~| 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:193899 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
Is there a way to disable the case sensitivity in CFQUERY
Right now cfquery name=somename datasource=somedatasource SELECT EmPloYeE.Name FROM Employee /cfquery is failing in CF. I have to have the table name with exactly the same case as I am referencing it. This also happens in MySQL. Is there a way to disable this case-sensitivity feature in CF and/or MySQL? merci! __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ~| 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:193915 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
how to display data in two select boxes where the second one's display depends on the first one
I want to display the data in two select boxes. For example, I want to display two select boxes. In the first one I want to display the list of the category of employees (like full time, part time, contract, etc) On the second select list i want to display the list of employees in that category. For example, if the user clicks on the part time then the second box should display all part time employees only. Is there a easy way for this? ~| 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:193959 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: how to display data in two select boxes where the second one's display depends on the first one
MX. Just installed MX 7 on another machine though. Will the solution to MX not work on MX 7? Adam Haskell [EMAIL PROTECTED] wrote:if you look on the dev exchange on MMs website there are a few custom tags...are you looking for an MX or MX 7 solution though? That could change the situation greatly :) Adam H On Wed, 9 Feb 2005 13:26:39 -0800 (PST), Discover Antartica wrote: I want to display the data in two select boxes. For example, I want to display two select boxes. In the first one I want to display the list of the category of employees (like full time, part time, contract, etc) On the second select list i want to display the list of employees in that category. For example, if the user clicks on the part time then the second box should display all part time employees only. Is there a easy way for this? ~| 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:193969 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
- Previous Page | Next Page -
if I have 100 records in total and I want to display them 20 on a page with arrows at the bottm saying previous 20 records or next 20 records, how do i do it in Coldfusion? ~| 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:193706 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
How do you change the color of each row?
Hello, I would like to display the output in such a way that the rows display in two colors alternatively. I am doing this to make the output more readable. Is there a way to do it? I think you use IIF function? but I cant remember ~| 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:192429 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: How do you change the color of each row?
is there a way to do this without CSS? Barney Boisvert [EMAIL PROTECTED] wrote: tr.alt1 td { background-color: #fff; } tr.alt0 td { background-color: #ffc; } ... Obviously the CSS belongs in an external stylesheet, rather than inline. cheers, barneyb On Mon, 31 Jan 2005 12:51:10 -0800 (PST), Discover Antartica wrote: Hello, I would like to display the output in such a way that the rows display in two colors alternatively. I am doing this to make the output more readable. Is there a way to do it? I think you use IIF function? but I cant remember -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 6 invites. ~| 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:192435 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
CFQuery Question
Does anyone know how to delete duplicate records from a table and leave only one record in the table using CFQUERY. ~| 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:192100 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
Can you underline current line in Dreamweaver MX?
I am doing CF programming using Dreamweaver MX. I used to use CF Studio previously. In CF Studio, you have the option of highlighting the current line by having a line up and below the line of code that you are currently at. It was one of the options you could select to modify the editor. Is there a way to highlight the current line on which the cursor is while coding in Dreamweaver MX? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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:191821 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
Is there coldfusion based webmail product out there?
Is there coldfusion based webmail product out there? for free or paid, either one. ~| 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:191540 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 there coldfusion based webmail product out there?
Is that from macromedia? is it part of the cf application kit from Macromedia? Jordan Michaels [EMAIL PROTECTED] wrote:-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Discover Antartica wrote: |Is there coldfusion based webmail product out there? for free or paid, either one. Silly footers, always cutting off my responses! Here's what I attempted to write earlier: I believe one of the CF demo applications (which you can install when you install Cold Fusion Server) is an webmail client. Email Taxi or something? It's been a while since I've installed those though... HTH! - -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFB9TWo/G4NWP5tBHcRAvqtAJ9JD7j8NekJWf9plGF3O/stAUfDOgCfT24D 9K1mWyoIzTQc1ERnR8ByEks= =+Jdv -END PGP SIGNATURE- ~| Logware: 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:191547 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
Can we save email attachments directly in the database?
Hello, I am using CFPOP. Currently, it is saving files in a folder on disk. I want to save it directly to the database. Is that possible with coldfusion? ~| Logware: 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:191206 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: Can we save email attachments directly in the database? Got the answer but...
But, I want to avoid CF saving it on a folder on the disk and instead go directly to the database. Is there a way? In the example below, cffile is being used to read the file from a folder. I want to skip this step of file being saved in folder first, then being read by cffile and then being put in the database by cfquery. is there a way to do this? Mark Drew [EMAIL PROTECTED] wrote: The actual contents of the file or the filename? if its the actual content of the file I guess you should do a if the file is a text file else if text or depending on the file if binary And then INSERT INTO blobs (content) if binary VALUES else VALUES On Thu, 20 Jan 2005 08:18:52 -0800 (PST), Discover Antartica wrote: Hello, I am using . Currently, it is saving files in a folder on disk. I want to save it directly to the database. Is that possible with coldfusion? ~| Logware: 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:191230 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: Can we save email attachments directly in the database? Got the answer but...
I am sure there is a way...but I don't know how. Anyone else knows? Bryan Stevenson [EMAIL PROTECTED] wrote:Nope.not that I'm aware of...to drive...then from drive to DB as laid out Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| 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:191238 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
Can we use CFFILE for this?
Does anyone know how to upload a file into a column in a database table using Coldfusion? Can we use CFFILE? - Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. ~| Logware: 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:191071 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
Can we do this with CFPOP?
Ok. Now another problem. I am using the generateUniqueFilenames attribute in CFPOP. Is there a way to find what is the unique filename that is being generated by CFPOP? what is happening is that if I have one two emails with the attachments having the same name, say for example Testing.cfm, then, CFPOP stores the file in the first email as Testing.cfm. But, for the other email it makes it Testing1.cfm. Now I want to save this in the database. I want to make sure that I get the right file in the database and not mix up the names. Is there a way to do this? Thanks Y'all. - Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. ~| Logware: 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:191084 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: display number of pages left
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b20.htm#wp1102474 Dave Watts [EMAIL PROTECTED] wrote: I've not used cfqueryparam before. Can you clarify how I can implement this so that it makes my WHERE more secure? I've never really understood cfqueryparam. You can read all about it here: http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:191087 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
Can we do this with CFPOP?
- Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. ~| Logware: 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:191091 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
a question popped up about cfpop
I am using the generateUniqueFilenames attribute in CFPOP. Is there a way to find what is the unique filename that is being generated by CFPOP? what is happening is that if I have one two emails with the attachments having the same name, say for example Testing.cfm, then, CFPOP stores the file in the first email as Testing.cfm. But, for the other email it makes it Testing1.cfm. Now I want to save this in the database. I want to make sure that I get the right file in the database and not mix up the names. Is there a way to do this? Thanks Y'all. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ~| Logware: 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:191110 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