Re: update table with the word Null

Well, then it has nothing to do with your sql statement. You'd better show
us the code you are using to execute the statement.

Better yet, have a look at these posts to see my recommendations for
executing sql statements from vbscript:

http://groups-beta.google.com/group/microsoft.public.inetserver.asp.db/msg/72e36562fee7804e

Personally, I prefer using stored procedures, or saved parameter queries as
they are known in Access:
http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=e6lLVvOcDHA.1204%40TK2MSFTNGP12.phx.gbl

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1&selm=eHYxOyvaDHA.4020%40tk2msftngp13.phx.gbl



Joe T wrote:
Bob,
I used your suggestion and still get type mismatch.
UPDATE projects
SET floorplan = "Null"
WHERE floorplan = ""
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'UPDATE'

Joe T


Use the Access Query Builder to generate sql statements until you are
comfortable writing them yourself

Joe T wrote:

UPDATE Projects (floorplan)
SET floorplan = 'Null'
WHERE floorplan = ''''

I tested and receive:
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'projects'
Any one know why I receive error?

Yes. It's because the syntax is incorrect. Assuming the name of the
table is "Projects", the correct syntax is:

UPDATE Projects
SET floorplan = 'Null'
WHERE floorplan = ''''



--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Loading