Cant get double SQL statment working!!!

[nath01]

im trying to get the following statment working but not haveing much luck:

UPDATE Results
SET follow_up='::follow_up::',fixed='::fixed::',Assigned_To='::Assigned_To::',SVR_No='::SVR_No::',Target_Date='::Target_Date::'
where ID=::ID::

UPDATE Results
Set Completed_Date='::Completed_Date::'
Where Completed_Date='::null::'
and fixed=::Close::



both work on there own but not with both at once i tryed mearging them in to one with no luck. this is for a form that updates data in a database.

anyone know what i am doing wrong?

also what is the null command in FP SQL? is it Where Completed_Date='null'???

Thanks for any help

 

[noellees1]

What language are you using here i assume ASP (annoying server pains)
are the ' ' surrounding all your fields shouldnt they be only arround the non-numeric fields

UPDATE Results
Set Completed_Date='::Completed_Date::'
and fixed=::Close::

perhaps that would work i cant claim to being an expert im now coding in CFML (which to me seems tidier)
Removing the null may make it work

http://www.spano.co.uk

The way web design should be