syntax error on replace statements

[kdjonesmtb2]

Microsoft ODBC SQL Server Driver SQL Server incorrect syntax near '1'

Line 101: "conn.Execute(sqlFromHTrio)
dim sqlFromHTrio
For x = 1 to 15
sqlFromHTrio = replace(replace(replace(sqlFromHTrioTemplate, "$ROW$", cstr(x)),"$CD$", cptsearchtxt),"$QTY$",txt_procedure_quantity)



conn.Execute(sqlFromHTrio)
Next

 

[Geates]

what is the result of all the [tt]replace()[/tt]?

For x = 1 to 15
   sqlFromHTrio = replace(replace(replace(sqlFromHTrioTemplate, "$ROW$", cstr(x)),"$CD$", cptsearchtxt),"$QTY$",txt_procedure_quantity)
   msgbox sqlFromHTrio
Next

break it up to see where the error lies

For x = 1 to 15
   str1 = replace(sqlFromHTrioTemplate, "$ROW$", cstr(x))
   str2 = replace(str1,"$CD$", cptsearchtxt)
   str3 = replace(str2,"$QTY$",txt_procedure_quantity)
   msgbox str3
Next

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm