Michael
|
| Posted: 06/15/2003, 9:59 PM |
|
SQL = "Update Diary set DiaryText = 1 where UserID = 1"
but I want to have text in the DiaryText.
this works as a query in Access:
Update Diary set DiaryText = Not Approved where UserID = 1;
how can you put this as a code to be in the after execution insert taking userid value from CCGetUserID()
MSAccess, ASP, IIS, CCS2.1
|
|
|
 |
RonB
|
| Posted: 06/16/2003, 1:04 AM |
|
SQL="update Diary set DiaryText='Not Aproved' where UserID=" .CCToSQL(CCGetUserID(),"ccsInteger");
That's in PHP
Ron
|
|
|
|
|
