Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CFMAIL error message!
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... -
Downside to sending the password in the email!
I only have one question, can anyone think of the downside to sending the password in the email?- NEL3644
- Thread
- Replies: 1
- Forum: General e-Business discussion
-
Add today's date to a month from now!
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... -
Create Query
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.....- NEL3644
- Post #11
- Forum: Microsoft SQL Server: Programming
-
HELP W/ QUERY!
Yep, it helps Chris! The next error message I get is: "unknown exception condition TagCFMail::sendMessage"---and it indicates that this error comes from the position where the "TO=" is located... Do you have any idea why might cause this error? Do I have to do anything else... -
I created this code to notify users
U got AMayer, that problem is now solved! Thankx! The next error message I get is: "unknown exception condition TagCFMail::sendMessage"---and it indicates that this error comes from the position where the "TO=" is located.. Do I have to do anything else so that CFMAIL goes... -
HELP W/ QUERY!
I created this code to notify users 1 week prior to expiration date...The query goes to the "Dates" TABLE and get the dates (field name: StartDate) and also goes to the "Program" 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
I created this code to notify users 1 week prior to expiration date...The query goes to the "Dates" TABLE and get the dates (field name: StartDate) and also goes to the "Program" TABLE to get the e-mail list (field name: EMail) of everybody whose dates are 1week prior to... -
Create Query
What does GETDATE function do?- NEL3644
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Create Query
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...- NEL3644
- Thread
- Replies: 11
- Forum: Microsoft SQL Server: Programming
-
Help w/ Data base!
As far as the existing records in the database, records with (") 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 (") w/ (&qut) of existing records...What... -
Help w/ Data base!
The Data Type is TEXT! The variable is passed to the database just fine including the quotes ("), 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... -
Help w/ Data base!
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 "this product" a lot... Change the... -
Help w/ Data base!
The field Comment in my User table the Data looks like the folowing: Comment ================== point 5 "excelent" point 4 "very goood" point 3 "good" point 2 "fair" point 1 "poor" The problem I'm having is that when I go and get these... -
Display only upcoming dates! (urgent)
With your help I got it to work Ded, Thanx! -
Display only upcoming dates! (urgent)
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... -
Do not display expired dates!
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'} -
Displaying records in multiple vertical html tables...
If you would show me how you did it that would be great Neo! Thankx -
Compare date (urgent)
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 "CURRENT DATE" up to the "12th date" which is what I want the query to capture after all... I was thinking that maybe because I'm...- NEL3644
- Post #8
- Forum: Microsoft SQL Server: Programming
-
Compare date (urgent)
Your help was indeed very valuable, but let me rephrase something here... I want to capture ONLY the dates between "CURRENT DATE" and the "12th RECORD"...When you specify TOP 12 in the query I get the first 12 records not 12 records starting from the "CURRENT...- NEL3644
- Post #5
- Forum: Microsoft SQL Server: Programming
