Invalid use of null

fran7

Hi, I have looked around and this seems to be a common problem when a database field is empty. I have this and none of the solutions I have seen seem to work. I tried ),"'","<") but that didnt solve anything.

Expand|Select|Wrap|Line Numbers

 Response.Write "<tr><td height=""30"" width=""300"" align=""left"" valign=""middle""><font size=""2"">site</font></td>"

Response.Write "<td height=""30"" width=""250"" align=""left"" valign=""middle""><input type=""text"" name=""imageone"" value=""" & Replace(objOptionsAndInfo("imageone"), Chr(34), "&quot;") & """ size=""30"" maxlength=""45""></td></tr>"

If anyone has a solution that would be great.
Thanks
Richard

prabirchoudhury

1. Response.Write("html hoes here"); would be like that

Expand|Select|Wrap|Line Numbers

 
           Response.Write("<table width=500>");

            Response.Write("<tr>");

            Response.Write("<td align=right>");

            Response.Write("<BR>");

            Response.Write(DateTime.Now.ToString());

            Response.Write("</td>");

            Response.Write("</tr>");

            Response.Write("</table>");

have a look on

Carriage Return and Response.Write Output Issue

:)

GazMathias

Personally, I can't stand response.writing out html. If I have to mix content with code I always come out of vbscript and just type out the html:

Expand|Select|Wrap|Line Numbers

 
<table>

  <tr>

    <th>Field One</th>

    <th>Field Two</th>

    <th>Field Three</th>

  </tr>
 
<% Do While Not blah.... %>

  <tr>

    <td><%=rs("fieldone")%></td>

    <td><%=rs("fieldtwo")%></td>

    <td><%=rs("fieldtwo")%></td>

  </tr>

<% rs.movenext

Loop %>

</table>

If you use a decent editor that highlights code well (I recommend Notepad++), there are obvious benefits.

As to your original question, check if the field isn't empty before you use replace:

Expand|Select|Wrap|Line Numbers

 
<% If not objOptionsAndInfo("imageone") = "" then Replace(objOptionsAndInfo("imageone"), Chr(34), "&quot;") %> 
 

Gaz

fran7

Thanks to you guys I have sorted it now.
Thanks
Richard

jhardman

Quote:

Originally Posted by GazMathias

Personally, I can't stand response.writing out html. If I have to mix content with code I always come out of vbscript and just type out the html

Gaz

I agree strongly.

Jared

Nicodemas

Quote:

Originally Posted by GazMathias

Personally, I can't stand response.writing out html. If I have to mix content with code I always come out of vbscript and just type out the html:

I'm not so sure on this one, personally. It's been tested that (extensive) intermingling of dynamic and non-dynamic script causes CPU overhead to increase.

Form a clean code point of view, I just use line continuations when appropriate:

Expand|Select|Wrap|Line Numbers

 
response.write "I've got a lovely bunch " & _

                      "of coconuts! Deedly, dee! " & _

                      "There they are standing in a row." & _

                      "<big>Big ones!</big>" & _

                      "<small>Small ones!</small>"

Clean.

jhardman

Quote:

Originally Posted by Nicodemas

I'm not so sure on this one, personally. It's been tested that intermingling dynamic and non-dynamic script causes CPU overhead to increase.

Form a clean code point of view, I just use line continuations when appropriate:

Clean.

line continuations, fine, I don't have a problem with that. I have just seen too many people trying to response.write complex HTML including escaped quote marks. They always lose count of their quotes and can't decipher the error messages.

Expand|Select|Wrap|Line Numbers

 response.write "<input type=""text"" value="" &      rs("myTextValue") & "" name=""myTextValue"">" & vbNewLine
 

Do you see where the error is? the error would be something like "Command expected".

Or they use non-strict or even non-standard HTML because they are trying to avoid using quotes. The only other solution I've liked, is to assign double quotes to a variable

Expand|Select|Wrap|Line Numbers

 dim q

q = chr(34)

response.write "<input type=" & q & "text" & q & " value=" & q & _

      rs("myTextValue") & q & " name=" & q & "myTextValue" & q & ">" &_

      vbNewLine

but this is much less-clean than this

Expand|Select|Wrap|Line Numbers

 
%>

<input type="text" name="myTextValue" value="<%=rs("myTextValue")%>">

<%

I don't know which executes faster, but I know this last is easier to read, write and troubleshoot.

Jared

Invalid use of null

re: Invalid use of null

re: Invalid use of null

re: Invalid use of null

re: Invalid use of null

re: Invalid use of null

re: Invalid use of null

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about