help with update statement

CodeCharge Studio

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

help with update statement

Author

Message

mhope

Posts: 37

Posted: 01/25/2006, 4:40 AM

Hi all,
I have a problem with this

  
Dim Connection, UserContactID  
	UserContactID = Request.QueryString("UserContactID")  
	Set Connection = New clsDBEinternet    
	Connection.Open   
	Connection.Execute("UPDATE user_contact_email SET IsRead='Yes', DateRead=Now() WHERE UserContactID="&UserContactID&") And UserID="&CCGetUserID  
	Connection.Close    
	Set Connection = Nothing

I'm not too good at update statements, so I was hoping someong could help.

Thanks

mhope

Posts: 37

Posted: 01/26/2006, 8:00 PM

Thanks anyway, i have corrected the issue

Cheers

Walter Kempees

Posted: 01/27/2006, 12:18 AM

Good Job.
It was in the )
"mhope" <mhope@forum.codecharge> schreef in bericht
news:643d99acae534c@news.codecharge.com...
> Thanks anyway, i have corrected the issue
>
> Cheers
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login