update in value in database from grid...

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

update in value in database from grid...

Author

Message

paul74

Posts: 9

Posted: 05/22/2006, 11:47 AM

hello,

new at codechargestudio (switch from codecharge) i'm trying to change a int value from database from 1 to 0 (or 0 to 1) to set if the datarecord is online or not. how can i make this in a simple way? has anybody an idea? try to do this since 3 hours.... *grmpf*

thanks for your help!

klaus

paul74

Posts: 9

Posted: 05/22/2006, 11:49 AM

Quote paul74:

hello,

new at codechargestudio (switch from codecharge) i'm trying to change a int value with link on the grid in database from 1 to 0 (or 0 to 1) to set if the datarecord is online or not. how can i make this in a simple way? has anybody an idea? try to do this since 3 hours.... *grmpf*

thanks for your help!

klaus

Maybe

Posted: 05/22/2006, 4:26 PM

Not too sure what you’re asking here but if I understand you correct you want to:
Change the database value to 1 from 0 via a link, then you could do the following.
Set the link to send a Query String lets say IsRead=Yes in a before show place this code:

Dim IsRead
IsRead = Request.QueryString("IsRead")
If IsRead = "Yes" Then
Dim Connection
Set Connection = New clsDB_your_database_connection_here
Connection.Open
Connection.Execute("UPDATE users SET is_online='0', date_logout=Now() WHERE UserID="&CCGetUserID)
Connection.Close
Set Connection = Nothing

End If

paul74

Posts: 9

Posted: 05/23/2006, 12:51 AM

@Maybe

thank you very much! it works very fine! (put the update-code into "befor select"!)

is there anywhere a list from variables like CCGetUserID ??

regards klaus

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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home | Search | Members | Register | Login