Recent content by NEL3644

Whenever I try to use CFMAIL to send messages to yahoo, I get the following error message: "Error","TID=-580399","12/19/00","17:37:03","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\4065.cfmail. SMTP server replied "not local host...

I only have one question, can anyone think of the downside to sending the password in the email?

I can easily add today's date to a week from now because I know that a week has exactly 7 days - just like this example: <cfset ExpirationDate = now() + 7> Now, what if I want to add today's date to a month from now, knowing that a month can have 28 and 29 (if month is Feb.) and 30 or 31 days...

I'm sorry about my limited knowledge about SQL, but if I wanna learn more I have to ask you guys what non-deterministic user defined functions are.....

Yep, it helps Chris! The next error message I get is: &quot;unknown exception condition TagCFMail::sendMessage&quot;---and it indicates that this error comes from the position where the &quot;TO=&quot; is located... Do you have any idea why might cause this error? Do I have to do anything else...

U got AMayer, that problem is now solved! Thankx! The next error message I get is: &quot;unknown exception condition TagCFMail::sendMessage&quot;---and it indicates that this error comes from the position where the &quot;TO=&quot; is located.. Do I have to do anything else so that CFMAIL goes...

I created this code to notify users 1 week prior to expiration date...The query goes to the &quot;Dates&quot; TABLE and get the dates (field name: StartDate) and also goes to the &quot;Program&quot; TABLE to get the e-mail list (field name: EMail) of everybody whose dates are 1week prior to...

I created this code to notify users 1 week prior to expiration date...The query goes to the &quot;Dates&quot; TABLE and get the dates (field name: StartDate) and also goes to the &quot;Program&quot; TABLE to get the e-mail list (field name: EMail) of everybody whose dates are 1week prior to...

What does GETDATE function do?

I have 3 fields in one of the tables in my database that looks like: Table name: Expiration BeginDate EndDate E-mail ========= ======= ======= 20001023 20001024 joe@yahoo.com 20001025 20001027 mike@yahoo.com 20001109 20001116...

As far as the existing records in the database, records with (&quot;) not (&qut) that are existent in the database and not yet modified, I don't think the update query will remove the records from the db...This query will only update or replace (&quot;) w/ (&qut) of existing records...What...

The Data Type is TEXT! The variable is passed to the database just fine including the quotes (&quot;), the problem appears to happen when I get the data out of the database! As I mentioned erlier, the only way the information is displayed w/ no problems on my site is when I go to the database...

Thanks for your help, chi1beast! Now, I have a question regarding the same subject: I have another field where there a lots of text records that the users entered. The field looks like this: Comment2 ============================== I like &quot;this product&quot; a lot... Change the...

The field Comment in my User table the Data looks like the folowing: Comment ================== point 5 &quot;excelent&quot; point 4 &quot;very goood&quot; point 3 &quot;good&quot; point 2 &quot;fair&quot; point 1 &quot;poor&quot; The problem I'm having is that when I go and get these...

With your help I got it to work Ded, Thanx!