Hi

I get this error message:

Microsoft VBScript compilation error '800a0414'

Cannot use parentheses when calling a Sub

Response.Write(replace(strCol3), vbcrlf, "<br>"))
------------------------------------------------^

this is my raw code:

<%=replace(strCol3), vbcrlf, "<br>")%>

can anyone tell me how to fix this?

thanks

Adam

The following function will do what you are trying to do and more, i wrap it round text strings when inserting:

  Function tweakText(theText)
    tweakText = ""
    on error resume next
    tweakText = CStr(theText)
    if (len(tweakText) > 0) Then
      tweakText = Replace(tweakText, """", "&quot;", 1, -1, 1)
      tweakText = Replace(tweakText, "'", "''", 1, -1, 1)
      tweakText = Replace(tweakText, vbcrlf, "<br>", 1, -1, 1)
    end if
  End Function

  dim strCol3
  strCol3 = "The All Blacks gratest rugby team in th world's"

  response.write tweakText(strCol3)

NOTE:
;;; <%=replace(strCol3), vbcrlf, "<br>")%>
you have only 1 ( but have two )) - these must match up


Wind is your friend
Matt

thanks Matt

but I get a syntax error on the first line of the function?

Microsoft VBScript compilation error '800a03ea'

Syntax error

Function tweakText(thetext)
^


Also, what do I replace 'thetext' with? my variable - strCol3?

thanks

Adam

Adam H-W

Post your code, if possible indicating which line number. The code I posted runs fine for me, Your problem is probably:

You are not passing a string, it must be a string.

;;;;Also, what do I replace 'thetext' with? my variable - strCol3?

I have set a variable to a 'string':
strCol3 = "The All Blacks gratest rugby team in th world's"

This variable is passed into the function, the function gets called:
tweakText(strCol3)

Then the function initiates:
Function tweakText(theText)
theText holds the string contained in the variable strCol3

Post your code that genrates the error






Wind is your friend
Matt

Adam,
Can you count the number of OPENED and CLOSED paranthesis there, which doesn't tally. You seem to close the REPLACE function just after strCol3, so that results in not interpretting VBCRLF, as you wanted. It should look like... Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

great, thanks guys - all sorted