Recent content by iminore

Does anyone have a simple workaround to get vertical-align working in a table cell in Netscape? I have a select list (size>1) and a note after the list, all in one table cell. Putting vertical-align:top around the note works fine in IE but not netscape. I realise it's a well known bug in...

yeh, sounds likely and if she prints an apostrophe from Notepad it should confirm that it's not a Word problem. thanks for the help

I haven't seen it myself but a friend says that whenever she has an apostrophe in a Word document it prints as a 'g', even though it is displayed correctly. Any ideas anyone ?

I've just realised an original error - I didn't specify the length of the parameter. My original code now works.

which is what I had in the first place - and doesn't work

yes that works, although that way it isn't actually using the parameter replacement in sp_executesql - the replacement has been done before sp_executesql runs. equivalent to: declare @strexec varchar(800), @strsearch varchar(80) set @strsearch = '%lawyer%' execute('SELECT TitleID,title FROM...

I'm getting all records returned with this: declare @strexec nvarchar(800), @strsearch nvarchar(80) set @strsearch = N'%law%' set @strexec = N'SELECT TitleID,title FROM Titles where title like @strsearch$' execute sp_executesql @strexec, N'@strsearch$ nvarchar' , @strsearch$ = @strsearch any...

Check the time on each users' PC. Do they agree with the time on the server.

yeh, forget the coalesce, the truth is I didn't really understand the power of the 'select' statement. I suspect this applies to many experienced programmers. I also suspect this is a bit of a hobbyhorse of yours. Oh go on - what's the best book/website you know on SQL?

yep, it works - wonderful any chance of an explanation?

well, Declare @String varchar(1000) Select @String=coalesce(@String+', ',str(OrderID)) from MyTable where CompanyID=3 returns 4, which is what I'd expect from coalesce I'm after 4,7,9, ????????

I suspect there's a misspelling in there somewhere. colease ?

Suppose I have a table of companyids and orderids: companyid 3 orderid 4 5 6 3 7 3 9 Is there a single SQL statement that will return all the orderids as a delimited string for companyid 3, say, without looping through a...

This may be a simple request - but I'd love to know the answer. Is there a way of changing the defaults on the 'Backup' pane? In particular to change the default to 'overwrite existing media'.

ok point taken many thanks