"replace" problem

[MikeT]

I want to remove all the apostrophes from a string.
I use replace(string,"'"," &quot
but I get a
"Cannot use parentheses when calling a Sub" error.

Any Ideas?

 

[link9]

hmmm... I can't reproduce that problem...

Try changing the name of your string to something like myString -- maybe it is getting confused since string is a subtype of variant????

if that doesn't fix it, post the actual code snippet that's causing problems...

 

[MikeT]

Response.Write&quot;<script language=javascript>&quot;&vbcr
Response.Write&quot;aryProj = new Array();&quot;&vbcr
do while not rs.eof
strtemp=rs(&quot;field1&quot
replace (strtemp, &quot;'&quot;, &quot; &quot
Response.write&quot;aryProj[aryProj.length]='&quot;&rs(&quot;field2&quot&&quot;,&quot;&rs(&quot;field3&quot&&quot;,&quot;&temp&&quot;';&quot;&vbcr
rs.MoveNext
loop
rs.Close
response.write&quot;</script>&quot;&vbcr


The recordset is instantiated earlier. As you can see, I'm creating a js array using serverside vb. This should have nothing to do with the replace error.

 

[Swany]

When calling a SUB using () you need to use the call keyword..

call replace(string1,&quot;'&quot;,&quot; &quot

if you don't want to use call, then drop the parenthesis
replace string1, &quot;'&quot;, &quot; &quot;

 

[link9]

strtemp = replace (strtemp, &quot;'&quot;, &quot; &quot

You have to assign the return value to something -- it's a query, not a command.

 

[MikeT]

LOL- I knew it was something stupid!
Thanks for your patience.