Search results for query: *

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!

In a field called StartDate in one of my DB tables I have dates entered with the following format: 20000128 (year,month and date respectively)...and I want to compare w/ the system date ( #CreateODBCDate(now())# ) which has the following format: {d '2000-11-02'} I have tried the query below...

Thank you very much for your sugestion...Now, I have one more question regarding comparing the dates...The format w/ which I output my dates look like this: Oct 03,2000 Now, I want to be able to compare w/ the now() from the system which has the following format: {d '2000-10-03'}

If you would show me how you did it that would be great Neo! Thankx

I'm doing exactly what you've suggested me, but for some reason, the query is still capturing the first 12th records not the records starting from &quot;CURRENT DATE&quot; up to the &quot;12th date&quot; which is what I want the query to capture after all... I was thinking that maybe because I'm...

Your help was indeed very valuable, but let me rephrase something here... I want to capture ONLY the dates between &quot;CURRENT DATE&quot; and the &quot;12th RECORD&quot;...When you specify TOP 12 in the query I get the first 12 records not 12 records starting from the &quot;CURRENT...