Hogan

New York, NY

Age: 49

25+ years...
ASM, C, C++, C#, VB, ASP.NET, TSQL +many more


The postings on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.


Programmer, Architect, Team Lead, Director, CTO
MS Comp. Sci @ NYU '95
hoganlong at us.ibm.com // hoganlong at gmail.com

2d
revised Space between List and top of the page
added 65 characters in body
2d
comment Space between List and top of the page
This is horrible if there are more than 4 items it won't work.
2d
comment Space between List and top of the page
This is horrible -- if he has more than 4 items it won't work.
2d
comment Space between List and top of the page
hmm... this way uses two loops -- mine uses the same loop. Not sure which is better.
2d
answered Space between List and top of the page
2d
comment Space between List and top of the page
@BrianD is correct. You need a class in the tab that tells it to "reset" and then the javascript code to read it.
2d
comment Space between List and top of the page
you are loading the code twice -- can't be good
2d
comment Programmatically adding a Panel control adds "body" to its ID
did you look at the ClientID of the object in the debugger. This is what is written to the HTML page.
2d
comment Loop and group by only when some conditions occur
does not matter how flexible your code is if it does not finish.
2d
comment Loop and group by only when some conditions occur
no idea what you mean by that, loop and cursor mean the same thing.
2d
comment How to create a DbCommand that is compatible with SQL Server and SQLite without a large condition?
@user2864740 -- there, I changed MySqlParameter to CustomSqlParameter -- while MySqlParameter is not a name that is include in the C# libraries I can see how you would get confused.
2d
revised How to create a DbCommand that is compatible with SQL Server and SQLite without a large condition?
added 12 characters in body
2d
comment How to create a DbCommand that is compatible with SQL Server and SQLite without a large condition?
@user2864740 - bad name... let me fix that.
2d
comment Loop and group by only when some conditions occur
just a side note on speed, using framing expected is O(n), with recursive CTE O(lg N) and with a cursor O(n^2)
2d
comment Loop and group by only when some conditions occur
ok. I can't do it with a simple query. I still think a complex query would be better than a cursor. You need to use framing (the over clause) or a recursive CTE. Good luck.
2d
answered SQL Select (Value A at max value B) and other computed values (avg/min/max)
2d
comment Loop and group by only when some conditions occur
vkp gives you the code to do it without a cursor in the answers. His answer is good, use it.
2d
comment How to create a DbCommand that is compatible with SQL Server and SQLite without a large condition?
@user2864740 - You have to write it -- you look at the first parameter and return the correct result.
2d
comment Loop and group by only when some conditions occur
Maybe what we really need is a DontUseACursorToDoThisEver tag.
2d
comment Loop and group by only when some conditions occur
This does not need a cursor, should it have the cursor tag?
1 2 3 4 5