ok,
field in the table is called car_park the asp page is slightly more
difficult as the user enters the data via a .swf file. can this be run as a
command somewhere else, below is the code on the asp file (bearing in mind
that there is not actual text field here) some more assistance would be
appreciated.
Dim id, waiting, carPark
Dim driverNo, sId
Dim sql, conn
Dim sResponse
sResponse = ""
id = Request.Form("id")
waiting = Request.Form("waiting")
carPark = Request.Form("carPark")
driverNo = Request.Form("driverNo")
sId = Request.Form("sId")
If (Len(id) = 0 OR NOT IsNumeric(id)) OR Len(waiting) = 0 OR Len(carPark)
= 0 OR Len(driverNo) = 0 OR Len(sId) = 0 Then
Response.Write("end_done=ERROR")
Response.End()
End If
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open g_connectionString
' Updating booking_form...
sql = "UPDATE booking_form SET waiting_in_minutes='" & waiting & "',
car_park='" & carPark & "', time_cleared=GETDATE(), allocated='COMPLETED'
WHERE ID=" & id
conn.Execute(sql)
<script language='jscript' runat='server'>
function addDecPoint(x){
var s = (x<0)?'-':'';
x = Math.abs(x);
x=(x<100)?((x+1000)+'').substr(1):''+x;
return s + x.replace(/(\d\d)$/,'.$1');
};
</script>