Re: update table with the word Null

Here's the code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/stellco.asp" -->
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_stellco_STRING
Recordset1_cmd.CommandText = "SELECT * FROM projects" Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<%
UPDATE projects
SET floorplan = "Null"
WHERE floorplan = ""
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>

Thanks,
Joe T


.