Dalton,

Try this:

if not isNull(objRS("faxnr")) and objRS("faxnr") <> "" then

Response.write "Your fax number: " & objRS("faxnr")

end if

Jeremy

use an if statement to determine whether the field is not null or not empty:

if !isNull(objRS("faxnr")) or objRS("faxnr") > "" then

Response.write "Your fax number: " & <objRS("faxnr")>

end if

NB Have...

This might give you some ideas:

declare @to_whom varchar(255), @notes varchar(1000)

declare remider_cursor cursor for

select reminder_to_whom, notes

from <table>

where reminder_datetime <= getdate()

and (reminder_sent is null or reminder_sent = 0)

open reminder_cursor

fetch next...

If you don't specify the columns in an insert statement, then the columns you insert much match the columns in the table.

What I suspect you are trying to do is...

Would the isql/osql dos commands do this for you? I have never used them but BOL suggests that you can execute a query file (script file?) from a dos...

You do not have a END at the very end of the proc to complete the ELSE BEGIN.

Jeremy

Is your gender field empty or null?

By the sounds of other posts, it empty rather than null and so you should use a case statement:

select case

when gender...

Do you have any nested transactions?

I ask, because if the outer transaction is rolled back, all the nested transactions are rolled back even if they have been 'committed'.

I...

Do you want this?

id

00001

00002

00003

?

If so,

select right('00000' + convert(varchar,id), 5)

from ..... etc

Jeremy

Try this:

select a.col1

from table1 a

where 1 = (select count(*) from table1 b

where a.col1 = b.col1)

This uses a self join...

Yes you can use @@error.

Zero = no problems.

Non zero = a problem (usually in the range 8900 - 8999).

Jeremy

David,

That's much neater and probably a lot quicker - I'll being using that in future.

Jeremy

I've not done exactly what you are trying to do but I have done something very similar to exec @SPName @P1Begin, @P1End, @InqTotal, @TotalReturn, @CalcReturn.

In my application, the users request...

You can put a constraint on any field - it does not have to be a primary key.

Jeremy

Not entirely sure why you don't get a time for the date field, but I tend to use a function to format the date/time into a standard format:

function WebDate(dtDateValue)

...