Link to home
Start Free TrialLog in
Avatar of Tony-laptops
Tony-laptops

asked on

Microsoft VBScript runtime error '800a005e' Invalid use of Null: 'replace'

Hi Experts,

Just moved servers from Win2000 to Win2003, using SQL2000 DB.  Am getting this error:

Microsoft VBScript runtime error '800a005e'  Invalid use of Null: 'replace'

Line 385:

<input name="txtother" type="text" class="search-select"tabindex=41 value="<%=replace(others,chr(34),"&quot;")%>" size="30">

Any ideas?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of clockwatcher
clockwatcher
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of qbank
qbank
<%
   if others <>  ""  then
%>
<input name="txtother" type="text" class="search-select" tabindex=41 value="<%=replace(others,chr(34),"&quot;")%>" size="30">

Avatar of Tony-laptops
Tony-laptops

ASKER

Hi,

Thanks for your help, your solution worked, but I found out why this was creating the problem on the SQL side.

forgot to enter default values where Null is allowed
('')

thanks.