Hi guys i hope you can help.

I'm using this string in my asp page

SELECT SUM(Yr1FTE) as YR1FteTotal, sum(Yr2FTE) as YR2FteTotal, sum(Yr3FTE) as YR3FteTotal, sum(Yr4FTE) as YR4FteTotal, sum(Yr5FTE) as YR5FteTotal FROM tblStaffCostings Where costingId="&costingID

CostingId can change depending on what the user does.

The string works as it should it returns the totals if it finds any and nulls if it doesnt.

The nulls are my problem because this sql will return something i cant use the recordset.eof to see if it is blank. because a record of all nulls is still a recordset

I've tried using code such as

if (yr1ftetotal = "") then
yr1ftetotal = 1
end if

but it doesnt recognise that yr1total is ""

so my question is, Is there anyway in my string that i can convert the nulls to say a 0 or a 1 or if not what is the code for checking if a recordset isnull?

Ok people i've fixed the problem, again dont kow if its the best way of doing it

but i'm using

if isnull(yr1fte) then
yr1fte =1
end if




note* what is this sites problem with using the tab key *

what database server are you using?


no problem with the tab key as far as I can tell. It behaves as the tab key should in HTML pages, moves the focus on to the next active control.

what are you trying to do with it?

off topic, but every time i press the tab key, to try and indent the text i'm typing in the messsage area it posts what i've written so far

yep that's what the tab key does on every HTML form in existence.

Here the textarea is immediately before the submit button in the form element order and if you press enter after the tab key it will submit the form 'cos the submit button has focus.