Search results for query: *

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

Does anyone know what restrictions there are on using frames on an Apple Mac.

Does anyone know what restrictions there are on using frames on an Apple Mac.

Does anyone have any info on url resolution. I don't mean parsing or validating the syntax of an url - actually checking programmatically that it exists.

see http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281517

yes thanks simon in fact I'll do: for i = 1 to request.form.count strForm = strForm & request.form.key(i) & request.form.item(i) next which gives me what I want