|
| |
|
|
JeroenDortmans
Posts: 66
From: Eindhoven Netherlands
Status: offline
 |
Update date - 4/9/2002 16:14:15
I have a table with a column “Datestamp”. I have a form where I can edit this table. In this edit form I don’t want to edit the date. But when I send the fields of the edit form to a “Update” page I want the date to be updated. I thought of this script on the “Update” page:
Datestamp = Day(date) & "/" & Month(date) & "/" & Year(date)
fp_sQry="UPDATE Connectoren SET Supplier_number='::Supplier_number::', Color='::Color::', Remarks='::Remarks::', Belongs_to_history='::Belongs_to_history::', Datestamp=Datestamp WHERE Connectoren_ID=::Connectoren_ID::"
This doesn’t work. What is the best way to do this??
|
|
|
|
alveyuk
Posts: 80
Joined: 4/4/2002
From: Lincs United Kingdom
Status: offline
|
RE: Update date - 4/9/2002 18:49:39
Your posting said it was in Netherlands. The first question is where is your web host? The second question is what is the system date format on your web hosts server? Is it American format date of mm/dd/yyyy or Euorpean format of dd/mm/yyyy
Your coding is Euorpean format.
Ken Alvey
| |
|
|
|
JeroenDortmans
Posts: 66
From: Eindhoven Netherlands
Status: offline
|
RE: Update date - 4/10/2002 0:55:26
It is supposed to be European. It is for a Intranet environment.
| |
|
|
|
JeroenDortmans
Posts: 66
From: Eindhoven Netherlands
Status: offline
|
RE: Update date - 4/10/2002 9:16:20
I solved it!
This is the code:
Timestamp = Now
fp_sQry="UPDATE Seal_plugs SET DAF_number_seal_plug='::DAF_number_seal_plug::', Supplier='::Supplier::', Supplier_number='::Supplier_number::', Remarks='::Remarks::', Belongs_to_history='::Belongs_to_history::', Tijdstempel='"&(Datestamp)&"' WHERE Seal_plug_code='::Seal_plug_code::'"
When you need it, use it.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
