Setting Values to Null

Results 1 to 2 of 2

Thread: Setting Values to Null

  1. #1
    Join Date
    Dec 1969

    Default Setting Values to Null

    Hello All:<BR><BR>I am currenly designing a Web Admin console that connects to a 3rd party application that stores values in a SQL Server 7.0 database<BR><BR>I set the following in my ASP script for the variable to be Null<BR><BR>strOption = Null<BR><BR>( In the SQL Table the value appears as empty, but the app still counts this as a valid field )<BR><BR>When I use CRTL-0 in SQL Enterprise Manager and manually Null the field the app reads the value correctly as Null<BR><BR>How do set a value in ASP to be Null &#060;NULL&#062; ?<BR><BR>Thanks<BR>Stuart Shay

  2. #2
    Join Date
    Dec 1969

    Default RE: Setting Values to Null

    I&#039ve not worked with SQL Server 7. But have inserted a null into a table. SQL is as under:<BR><BR>QRY = "INSERT INTO &#060;table&#062;" & "field1 VALUES (" & (null) & ")"<BR>ObjCon.Execute QRY<BR><BR>This has worked with SQL 6.5<BR><BR>You can try this one

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts