View Single Post
  #6 (permalink)  
Old August 14th, 2003, 09:05 AM
pgtips pgtips is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

You need to separate all fields with a comma. The code you posted has no commas between Street and City, nor between State and ZipCode. Also you don't provide closing ' after RecordId (are you sure you need ' around this, isn't your id numeric?)

If you still get problems, show us the output from this line: SQL statement: <%=SQLstmt%>

hth
Phil
Reply With Quote