View Single Post
  #2 (permalink)  
Old May 5th, 2008, 07:15 PM
mat41 mat41 is offline
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

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