HI

I have a page that sends out reminders by email, it loops through a recordset and sends a reminder to everyone in that recordset.
Is it possible to put some update code within the loop so that it updates a field to show that a reminder has been sent, so that it doesnt get sent again?
Something like this perhaps?

<b>&lt;%

set Command1 = Server.CreateObject("ADODB.Command"
Command1.ActiveConnection = MM_connmessages2_STRING
Command1.CommandText = "UPDATE accessgroups SET sent 'Yes'"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%&gt;</b>

Thanks

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Edited by - Davecl on 28 May 2003 19:47:43

Hi, me again

Just realised that the above code would set ALL the records to 'Yes', so maybe this would be better.

<b>&lt;%

set Command1 = Server.CreateObject("ADODB.Command"
Command1.ActiveConnection = MM_connmessages2_STRING
Command1.CommandText = "UPDATE accessgroups SET fldsent = 'Yes' WHERE fldusername = username"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%&gt;</b>

would this work?

Thanks
Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

You're taking the right approach! I'd advise:

&lt;%

set Command1 = Server.CreateObject("ADODB.Command"
Command1.ActiveConnection = MM_connmessages2_STRING
Command1.CommandText = "UPDATE accessgroups SET fldsent = 'Yes' WHERE <font color=red>fldid</font id=red> = <font color=red>userid</font id=red>"
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%&gt;

I have come across a lot of problems when starting out with asp when filtering a database based on words, i.e. not getting the correct record back, not returning any records, etc. Since then, I always use the id field to reference an update such as this.

Cheeurs...

_________________________
WinXP : IIS 5.1 : StudioMX : ASP : VBScript
www.dynamic.ie

Thanks Beano

I'll give it a go.

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Hi

I've put the update command in the loop and everything seems ok , the email is sent and there are no errors BUT the field is not updated to show the mail has been sent.
This is the update code, where membid is a variable set like this <b>membid = rsetReminder.Fields.Item("fldMemberID".Value</b>

update code:

<b>set Command1 = Server.CreateObject("ADODB.Command"
Command1.ActiveConnection = MM_connmessages2_STRING
Command1.CommandText = " UPDATE accessgroups SET accessgroups.fldreminded = 'Yes' WHERE accessgroups.fldMemberID= membid "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()</b>

Any ideas?

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Edited by - Davecl on 30 May 2003 22:28:01

Hi

Sorted!!

It was cos membid is a variable, correct code is

<b>set Command1 = Server.CreateObject("ADODB.Command"
Command1.ActiveConnection = MM_connmessages2_STRING
Command1.CommandText = "UPDATE accessgroups SET accessgroups.fldreminded = 'Yes' WHERE accessgroups.fldMemberID =" & membid
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()</b>

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome