CFMail - multiple FROM addresses
I need to send mail through CFMail from multiple people, but I am running into problems. When I have more than one address, the first address isn't formatted correctly. Instead of [EMAIL PROTECTED], it has galbert%agere.com. Of course, the mail server can't recognize this. The senders also need to come from two different queries. I don't know if that makes a difference or not, but I know that I can't send mail with multiple senders. Does any one have any suggestions? Thanks in advance for your help! Greg Albert Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slightly OT: SQL Mode function?
Does anyone know of a way to get the mode (the most frequently occuring number) for a column? I didn't see any sort of SQL function for this, but it would be a useful function, if someone had an idea of how to do it with CF. Thanks in advance! Greg Albert Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: personal Oracle server?
Is there a "personal oracle server" that you can run on your own machine like there is in SQL Server? I'd like to be able to make/edit tables and connect to them through CF, but I haven't had a whole lot of luck with it. Any luck would be greatly appreciated! Greg Albert Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Find n occurrence
Is there a way to find the third (or "n") occurrence of a particular piece of HTML on a page? For instance, I want to only show the first three news entries and each entry is separated by brbr Is there any way to remove any text after those three entries? I'm not using a SQL Query... This is coming out of a CFHTTP.FileContent so I can't use the maxrows command. Any help that you could give me would be greatly appreciated! - Greg Albert Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
checkboxes in a list
I am designing an administration area and I need to assign a single page to multiple people. Because I don't know how many people will need access and because I'll be adding/deleting people all the time, I need to make all of the values go into the same field (userPermissions) in the database. The "pages" table has the following fields: pageID, pageDescription, userPrivileges. My code looks something like this: cfoutput input type="checkbox" name="userPrivileges" value="#userID#"#userID# /cfoutput I can submit these values without a problem. A comma-delimited list is inserted into the DB. My problem is that when I try to edit the page to change permissions, I can't see who was selected (or checked) before and who wasn't. I know this is a common problem, but I haven't been able to find any articles that really explain the problem I'm running into. I know it's something simple that I'm just not seeing. Can anyone shed some light on my problem? Thanks in advance! Greg Albert -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFRegistry and SQL Server DSN
I am creating a CF Administrator-like application that allows users to add datasources w/o getting into the CF Administrator. The problem that I'm having is encrypting the password correctly. I'm using the CFRegistry tag to create the entries on the server and I can get the datasources to work, unless they need a password. Can anyone help w/ the encryption of a ColdFusion login password? Thanks in advance! Greg Albert -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFOutput Group By
I am trying to group all messages together with the same subject for a forum. When I do that, I have to use CFOUTPUT group="subject" (where "Subject" is the field name). Here's the problem. I need the messages to be sorted by current date/time first and then by subject. Is there a way to use the ORDER BY clause in SQL to order the results by date/time and then also group the results by subject? Everytime I try to order by date, then by time, then by subject, it displays all the messages. Thanks in advance! Greg Albert -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFOutput Group By
Hi Dave-- Thanks for your help. That's what I used, but it's still showing the messages by subject. Shouldn't it though, as we have it ordered by subject, then by date, then by time? I guess I wasn't specific enough... What I need to do is display only one (the most recent) subject and ordered by date/time. Here's what I'd like the forum to look like: Message DateTime -- -- Sample 8/7/00 10:30 Example Msg.8/4/00 9:45 Test Mesg. 8/1/00 13:45 Where "Sample", "Example Msg.", and "Test Mesg." are linked to multiple records... meaning, someone posted a number of messages with the subject "Sample", "Example Msg." and "Test Mesg." and I only want the group of messages to display once, showing the most recent message and subject. Hopefully this helps to clarify. Thanks in advance! Greg Albert -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 11:34 AM To: [EMAIL PROTECTED] Cc: Albert, Gregory Mitchell (Greg) Subject: RE: CFOutput Group By I am trying to group all messages together with the same subject for a forum. When I do that, I have to use CFOUTPUT group="subject" (where "Subject" is the field name). Here's the problem. I need the messages to be sorted by current date/time first and then by subject. Is there a way to use the ORDER BY clause in SQL to order the results by date/time and then also group the results by subject? Everytime I try to order by date, then by time, then by subject, it displays all the messages. Thanks in advance! You'll have to ORDER BY the field with which you want to group your CFOUTPUT data before any other fields. You should be able to ORDER BY subject, date, time. This will let you group all messages with the same subject together, in date/time order. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.