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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by stevemarsh99

  1. stevemarsh99

    Insert and update record

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

    Date command

    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!
  3. stevemarsh99

    Date command

    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?
  4. stevemarsh99

    Date command

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

    Date command

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

    Date command

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

    Date command

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

    Date command

    Sheco just once
  9. stevemarsh99

    Date command

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

    Date command

    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]
  11. stevemarsh99

    Date command

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

    Date command

    thanks guys!
  13. stevemarsh99

    Date command

    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?!)
  14. stevemarsh99

    Date command

    what do you mean?
  15. stevemarsh99

    Date command

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

Part and Inventory Search

Back
Top