Search results for query: *

Well ok. I screwed that up; i don't know what I was thinking. I actually know SQL but it certainly isn't evident from my two posts here. Laugh away.

Thanks very much Leo; that was a great help Sincerely Nelson

Leo Please write a short example of checking a recordset for BOF and EOF "at the same time". I know what you're saying but I can't visualize the argument. Nelson

Thanks Leo I was being facetious when I said "2% processor resources" - actually I don't want to cycle recordsets anymore than absolutely necessary as you can imagine. I was always getting a -1 return value just like you said. One of the reasons I I was counting recordsets for one...

Well I could never make RowCount work either so I was going to suggest my time-proven: <% i = 0 rs.MoveFirst do while not rs.EOF i = i+1 rs.MoveNext loop Response.Write(&quot;<p># of Records -->&quot; & i) %> It's only 7 lines longer and additional 2% processor resources!! I think I'll try...

Sorry - I said I agree with the single quote idea and I put the quotes there anyway. If nbnews is a number field then I would say: UPDATE nouvelle (date,title,contents) SET ('fdsdf','sdfsd','sdfsdf') WHERE nbnews=57;

How about: UPDATE nouvelle (date,title,contents) SET ('fdsdf','sdfsd','sdfsdf') WHERE nbnews='57'; I agree completely with the single quote idea.

I am writing numerous ASPs in Interdev 6.0 with server side VBScript and some client side Javascript. I want all of my pages to load in a browser where i can remove the menu bar, status bar, etc. I can load the default.asp in a full browser, for example, and fire subsequent links using the...