View Single Post
  #3 (permalink)  
Old May 5th, 2008, 07:21 PM
MarkGT MarkGT is offline
Authorized User
 
Join Date: Apr 2008
Location: , , .
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Excellent. Thank you, you've been a huge help on more than one occasion.

Quote:
quote:Originally posted by mat41
 Yes it is possible EG:

dim r1, r2, r3, r4, r5, xemp_idx
r1 = ""
r2 = ""
r3 = ""
r4 = ""
r5 = ""
xemp_idx = ""

r1=trim(Request.Form("zEmp_idz"))
r2=trim(Request.Form("First_Name"))
r3=trim(Request.Form("xLast_Namex"))
r4=trim(Request.Form("Test1_Date"))
r5=trim(Request.Form("Test2_Date"))

rsql = " UPDATE S6Test SET Emp_ID='"& r1 &"', First_Name='" & r2 & "', Last_Name='" & r3 & "'"
if r4 <> "" then
rsql = rsql & ",Test1_Date= #" & r4 & "#"
end if
if r5 <> "" then
rsql = rsql & ",Test2_Date=#" & r5 & "#"
end if
rsql = rsql & " WHERE Emp_ID='"& xemp_idx &"';"

Wind is your friend
Matt
www.elitemarquees.com.au
Reply With Quote