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 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...

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...

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...

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...

Hi, I want to build a query that finds current date (system date) and then compare to the dates on the table so that it only capture the next 12 dates including the current date. I have a table called Dates that looks like this: Dates Startdate Enddate ----------------------------- jan...

I want to be able to check for expired dates (any date before current date is considered expired) and then display the next 12 non-expired dates starting w/ the current date. For example: dates ------------ jan, 23 1996 Mar, 05 1996 Apr, 23 1996 jan, 23 2000 Mar, 05 2000 Sep, 20 2000...

Hi everyone, On my Database, I have a table with 3 columns that looks like this: ID FirstName LastName ------------------------- 1 Joe Morgan 2 Juan Martinez 3 Michael Porras 4 Brian Clark 5 Chris Clinton 6 Michelle...

Hi everyone, On my Database, I have a table that looks like this: ID First Name Last Name ------------------------- 1 Joe Morgan 2 Juan Martinez 3 Michael Porras 4 Brian Clark 5 Chris Clinton 6 Michelle Hwa 7 ...

What's the query statement that will always display records from previous 3 months. Will anyone please help me?

I want to dispaly a list of records consisting of &quot;start date&quot;, &quot;end date&quot;, &quot;location&quot;, and &quot;state&quot; as column headers...but, the information I want to display is so long. So, as not to loose vertical space, I want to be able to continue displaying the list...