Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Active Server Pages (ASP)
Expertise: Beginner
Dec 16, 1999

Access Data From SQL Server in ASP

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
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date