worker73
Posts: 3
|
Posted: 07/15/2004, 9:19 AM |
|
Hi all!
Iam a Newbie and, i have a Problem with a History Table....
One Table have much Data and the Filds:
AgentName
User_id
DatumUp
Message
The Second Table has only the Fields:
id <--Primary Key
AgentName
User_id
DatumUp
Message
Okay....
I want to save the a Copy of the Values from the First Table in the Second Table so that i have a History Who has Changed What...
My System is (Newest CodeCHargeStudio from Yesterday ), MySQL and PHP!
I Hope Someone can Help me....Please!
_________________
We create Worlds
http://www.webernig.com/ |
|
|
peterr
Posts: 5971
|
Posted: 07/15/2004, 11:42 AM |
|
Take a look at the example at http://docs.codecharge.com/studio/html/ProgrammingTechn...eCustomSQL.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
worker73
Posts: 3
|
Posted: 07/15/2004, 12:26 PM |
|
Thanks but..... *snief*
Iam a Newbie in SQL, and Codecharge...
Okay, i find where i must insert the Code, but how must them Look Like for my Site ??
My DB Name is: Callcenter
My first Tabelname is: Users
My Second History Tablename is: History
The Fildes that are to insert in the Second "History Table are:
AgentName
User_id
DatumUp
Message
Can Anybody update the Code here Please???????
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
function Tasks_ds_AfterExecuteUpdate() {
$db = new clsDBConnection1();
$SQL = "INSERT INTO report (report_task_id,report_creator) ".
"VALUES (". $db->ToSQL(CCGetFromGet("task_id",0),ccsInteger) .",". $db->ToSQL(CCGetUserID(),ccsInteger) .")";
$db->query($SQL);
$db->close();
}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_________________
We create Worlds
http://www.webernig.com/ |
|
|
Latzi
|
Posted: 07/28/2004, 4:51 AM |
|
Hi,
i need help too,
$db = new clsDBConnection1();
$SQL = "INSERT INTO user_historie (user_id, user_name, user_vname, user_street) ".
"VALUES (". $db->ToSQL(CCGetUserID(),ccsInteger) .",". $db->ToSQL(CCGetFromGet("user_name",0),ccsText) .",".
$db->ToSQL(CCGetFromGet("user_vname",0),ccsText) .",". $db->ToSQL(CCGetFromGet("b_street",0),ccsText) .")";
$db->query($SQL);
$db->close();
How can i get the Information from a text box.
mfg
Latzi
|
|
|
|