146 reputation
113
bio website sqlfiddle.com
location Vancouver, WA
age 33
visits member for 2 years, 10 months
seen Mar 1 at 19:43

Web Developer (strengths in ColdFusion, SQL, jQuery)

twitter - @sqlfiddle

Developer of http://sqlfiddle.com

Don't tell me I can't be a bear!


Jun
19
comment Running total with count?
Aaron - I really need to make this new "Query Terminator" feature I added more obvious as to its function (clearly my "documentation", such as it is, is pathetically lacking). When you change the query terminator to something other than semi-colon for your quirky update, it works fine: sqlfiddle.com/#!6/2464b/4 This is because it runs the whole set of code as a single batch, rather than breaking them up into isolated statements.
Jun
10
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@Phil - if you want to post your comment as an answer, I'll happily mark it as the solution. Thanks again!
Jun
10
revised Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Resolution
Jun
10
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@NickChammas I had thought about that approach, but due to memory concerns I'd prefer not to go that route.
Jun
8
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@NickChammas I need to disable commits so that I can keep the schema (as defined by the left side panel) in a fixed state. There could be any number of people writing queries against the same schema trying to solve the same problem. To prevent them from interfering with each other, I need to be sure to keep the structure and data from changing. This is accomplished via rolled-back transactions, but that doesn't happen if the right-side code is committed.
Jun
8
revised Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Updates
Jun
7
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@Phil ah! Sorry, I was being a bit slow there. Yeah, that is a cool idea. Might be able to use that.
Jun
7
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@Phil the only problem there is that I don't have (and don't really want) control over the definition of each of the tables (those are defined on the left panel). So that DEFERRABLE INITIALLY DEFERRED clause wouldn't be there (unless there is some way to do that automatically for all tables - say via a system trigger that responds to create table statements? Ugh)
Jun
7
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Worth mentioning - I also did a lot of research looking into "pre-commit" triggers. It appears those do not exist, so unfortunately that's not an option either.
Jun
7
asked Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
May
22
comment Complex MySQL Query returning almost all the correct rows
I don't think it's a bug in SQL Fiddle (btw - sql fiddle is my site). The site is structured in such a way that would make such a bug very unlikely.
May
22
comment Complex MySQL Query returning almost all the correct rows
I see that your tblorderitems table only has references to invoiceid=275, but your tblinvoices table (which you are attempting to join) has no reference to that id. This is why you are getting (null) values for your grossprice subselect. I haven't looked at the other subselects too closely, but I suspect a similar issue.
May
22
comment Complex MySQL Query returning almost all the correct rows
What exactly about the calculated columns isn't working in the SQL Fiddle link? The fact that they are showing "(null)"?
May
20
comment Group by minute and two minute intervals
Thanks for the heads up regarding GO <int> - I didn't even know that was an option for GO. I'll add it to the list of enhancements for SQL Fiddle (my site).
Mar
22
comment Oracle build_plan_xml visualizer
Thanks for your answer, phil. Text would suffice if there were no convenient graphical alternatives, but as you can see now I've got the Oracle flash-based execution plan viewer working. I think this format is preferable for my specific case. Your tips would certainly be useful for people looking to solve similar problems, however.
Mar
22
comment Oracle build_plan_xml visualizer
Sigh, gotta love Oracle. It works when you go to bed and breaks by the time you wake up.... Anyhow, it's working now. Hopefully it will continue to do so.
Mar
22
comment Oracle build_plan_xml visualizer
Thanks for your tip! I've updated the site to use the flash viewer behind the "ACTIVE" option (Check out this link to see it in action: sqlfiddle.com/#!4/ee7da/596). Had to do some serious mucking around with Oracle's HTML and JS to get it to work, but finally managed to do so. Thanks!
Mar
21
awarded  Benefactor
Mar
21
accepted Oracle build_plan_xml visualizer
Mar
20
revised Oracle build_plan_xml visualizer
added 294 characters in body