Problem solved. Once again, it was a problem with the memo field data not getting pulled with the select statement. I had to remove the memo field from the query and call it explicitly. Sheesh!!
I am trying to build an INSERT statement from a field collection in a SQL query. As you may know, apostrophes are field deliminators in SQL Server, so typically you wrap a field with replace(field, “‘”, “””) to escape the apostrophe. However, if the datasource for the field value is NULL you will get ‘invalid use of NULL’ when running replace.
SO, I try this
for each field in myRS
if len(field) >0 then
field = replace(field, “‘”, “””)
end if
ValueString = ValueString & “‘” & field & “‘, ”
next
and it STILL bombs with invalid use of NULL.
???
And please don’t tell me not to have NULLS in the db — there’s several text boxes in the form and no reason to have a default value for them.
any ideas?
TIA 
