Search results for query: *

I am trying to have a page with an update and a insert into 2 different tables but i can get the update but not the insert? I have had a dabble in the evil code...and i created another sperate page that with a insert behaviour assigned to the form, i copied and pasted the code onto the other...

YEAH IT WORKS>>>>GREAT WORK GUYS>>>>THIS LINE DID THE BUSINESS! <% IF Datediff("d",Date(),(rs_ealert.Fields.Item("MAGDATE").Value))<=-2 then %> hats off to ye!

No guys I mean I would like to SEND AN EMAIL based on a date in a database. for eg: 05/12/2005......2DAYS after i would like an email sent to someone.. (hardcoded) Shed any light?

Well thats the format it uses?! dd,mm,yy?

right i have this much and it still repeats the all the records in the db and sends out emails. I have emails hardcoded in the db so its doesnt matter (Access) thoughts?? <% IF Datediff("d",Date(),(rs_ealert.Fields.Item("MAGDATE").Value))>=2 then %> STILL NO JOY! (I have ONE record in the db...

Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: 'GetDate' /ealert/email_sending_page.asp, line 96 EEk?

Guys I have this code on a repeat region, and it sends an email as many times as there are records. Basically this does not work: <% Days = "d" Difference = 2 SAARASDATE = (rs_ealert.Fields.Item("MAGDATE").Value) Frankenfurter = DateAdd(Days, Difference, SAARASDATE) Rocky = Date()%> <% IF...

Sheco just once

I need an email to be sent when 2 days have passed the stored date....thoughts?

Right ok, if I want to use an if statement to select: IF (my date in the db) ADD 2 DAYS then send an email how would I do that?! (excluding time machine jokes please!)[neutral]

Leave me alone!!! I know what im talking about!! :)

thanks guys!

I mean if i try and use the -2 bit of the command: <% strToday = dateadd("d", date(), 1) strClose = dateadd("d", date(), -2) strMyDate = (rs_ealert.Fields.Item("MAGDATE").Value) %> Kinda means going back in time?! (88 mph?!)

what do you mean?

Hey guys and girls, i have a page that runs an IF statement to send an email. great, but now I want the if statment to run IF todays MINUS 2 DAYS is equal to a date in a database? i have it working with if todays date ADDED ONE DAY (tomorrow basically) is equal to my db date, but if i go back...

Sorry could you explain more? just i am a dreamweaver wizard man here, my sql knowledge is weak at best :P

I have a page that I want to update a record in one table of a db but in the same db, i want to insert a record to another table, all at the same time and maybe in the same form? is this possible and if not there must be a way-around?

Sounds cool, how can I get it to do that?

Is there any way of being able to use CDONTS to send mail (asp) where you can include ASP code in the html message itself? (as I would like to CSS some bits and grab some fields from a database) I have got some code that allows you to put in some html but you have to have HTML commands on EVERY...

Eek!