Question:

I’m using Microsoft SQL Server 6.5, Active Server Pages (ASP), and ActiveX Data Objects (ADO). When I retrieve a string with a value of “New York” from the table and assign the value to a text box, I get only “New” and nothing after the space. For example:

strcity = recordset("city")

I define the input box as:

VALUE=<% =strcity %>

Also, how can I assign a null value to an integer type column? For example, in Sybase you use the setnull() to set the value of a variable to null when inserting a row in the table.

Answer:

There is a problem in your HTML code. For the text box, instead of using:

VALUE=<%= strcity%>

use:

VALUE="<%= strCity %>"   

The double quotes will make sure the entire contents of the variable strCity becomes the ‘value’ of the text box.

To assign a null value to an integer type column, use the keyword Null. For example:

UPDATE TABLENAME SET FIELDNAME = NULL

or

INSERT INTO TABLENAME (FIELDNAME) VALUES Null