This there a way to change the color of spelling errors in Eclipse (Galileo)? The default red underlining is indistinguishable from the normal error underlining.
http://www.codinghorror.com/blog/2008/04/setting-up-subversion-on-windows.html
I am following this as a guide to install subversion. The tutorial at the time dealt with version 1.4.6
but the latest version is different. Is this tutorial valid still?
also there is no mention about installing the apache server.
I have a mysql database with 60 tables most of the tables have primary keys (expect pivot tables) all these primary keys had the attribute AUTO INCREMENT
Then over night some how all the primary keys had that attribute removed, and the default value set to 0.
I have no idea how this may have been caused. Any suggestions?
I downloaded and install the latest version of Google App Engine Plugin into my Eclipse and created a project with it using both GAE SDK and GWT SDK.
The funny thing is, randomly, my project become subjective to error, like the class RemoteServiceServlet cannot be resolved.
The errors will be removed if I go to the configure tab of the project and change the GWT SDK from Default to Specific version (or vice versa).
Has anyone ever encountered the same error? What the heck is it?
Problem
72 child tables, each having a year index and a station index, are defined as follows:
CREATE TABLE climate.measurement_12_013
(
-- Inherited from table climate.measurement_12_013: id bigint NOT NULL DEFAULT nextval('climate.measurement_id_seq'::regclass),
-- Inherited from table climate.measurement_12_013: station_id integer NOT NULL,
-- Inherited from table climate.measurement_12_013: taken date NOT NULL,
-- Inherited from table climate.measurement_12_013: amount numeric(8,2) NOT NULL,
-- Inherited from table climate.measurement_12_013: category_id smallint NOT NULL,
-- Inherited from table climate.measurement_12_013: flag character varying(1) NOT NULL DEFAULT ' '::character varying,
CONSTRAINT measurement_12_013_category_id_check CHECK (category_id = 7),
CONSTRAINT measurement_12_013_taken_check CHECK (date_part('month'::text, taken)::integer = 12)
)
INHERITS (climate.measurement)
CREATE INDEX measurement_12_013_s_idx
ON climate.measurement_12_013
USING btree
(station_id);
CREATE INDEX measurement_12_013_y_idx
ON climate.measurement_12_013
USING btree
(date_part('year'::text, taken));
(Foreign key constraints to be added later.)
The following query runs abysmally slow due to a full table scan:
SELECT
count(1) AS measurements,
avg(m.amount) AS amount
FROM
climate.measurement m
WHERE
m.station_id IN (
SELECT
s.id
FROM
climate.station s,
climate.city c
WHERE
-- For one city ...
--
c.id = 5182 AND
-- Where stations are within an elevation range ...
--
s.elevation BETWEEN 0 AND 3000 AND
6371.009 * SQRT(
POW(RADIANS(c.latitude_decimal - s.latitude_decimal), 2) +
(COS(RADIANS(c.latitude_decimal + s.latitude_decimal) / 2) *
POW(RADIANS(c.longitude_decimal - s.longitude_decimal), 2))
) <= 50
) AND
--
-- Begin extracting the data from the database.
--
-- The data before 1900 is shaky; insufficient after 2009.
--
extract( YEAR FROM m.taken ) BETWEEN 1900 AND 2009 AND
-- Whittled down by category ...
--
m.category_id = 1 AND
m.taken BETWEEN
-- Start date.
(extract( YEAR FROM m.taken )||'-01-01')::date AND
-- End date. Calculated by checking to see if the end date wraps
-- into the next year. If it does, then add 1 to the current year.
--
(cast(extract( YEAR FROM m.taken ) + greatest( -1 *
sign(
(extract( YEAR FROM m.taken )||'-12-31')::date -
(extract( YEAR FROM m.taken )||'-01-01')::date ), 0
) AS text)||'-12-31')::date
GROUP BY
extract( YEAR FROM m.taken )
The sluggishness comes from this part of the query:
m.taken BETWEEN
/* Start date. */
(extract( YEAR FROM m.taken )||'-01-01')::date AND
/* End date. Calculated by checking to see if the end date wraps
into the next year. If it does, then add 1 to the current year.
*/
(cast(extract( YEAR FROM m.taken ) + greatest( -1 *
sign(
(extract( YEAR FROM m.taken )||'-12-31')::date -
(extract( YEAR FROM m.taken )||'-01-01')::date ), 0
) AS text)||'-12-31')::date
The HashAggregate from the plan shows a cost of 10006220141.11, which is, I suspect, on the astronomically huge side.
There is a full table scan on the measurement table (itself having neither data nor indexes) being performed. The table aggregates 237 million rows from its child tables.
Question
What is the proper way to index the dates to avoid full table scans?
Options I have considered:
GIN
GiST
Rewrite the WHERE clause
Separate year_taken, month_taken, and day_taken columns to the tables
What are your thoughts?
Thank you!
What is the rewrite rule for following URL
mysite.com/001234-some-keywords.html
I want to capture the 6 digit reference number something like ([0-9]{6})
my indexed file is
templates/default/index.php?ref=001234
One day I do a crashcourse regex.. I promise.
Hi,
I am doing this:
@person.attributes = params[:person]
Can anyone give me a clue as to why doing an attributes= would cause a bunch of SQL to show in my logs?
I see a couple of SELECT and even an UPDATE.
I swear I am not doing a "save" -- so I have no idea why setting attributes would trigger queries.
Is there a before_ of after_ filter I am missing?
Thanks.
I am using firePHP(Zend profiler) on on FF 3.6.3(firephp addon installed) and it returns queries, when I do a normal page load. Ajax requests, however, are not returning the proper queries. I am using Prototype 1.6.0.2 for ajax requests. Is there something I am missing? Most of the write-ups seem to imply that this should work by default.
Currently I am using Subsonic 2.1 and .NET 2.1 and I have an issue where I am attempting to filter a pre-loaded collection with 300+ items. I am using the following to attempt to preform the filter:
orders = MasterOrders.Where("account", mbrAccount).Load();
The end results is setting orders equal to the entire MasterOrders collection and not the filtered results. Any suggestions?
Hello. I have interface in ATL project which must contains member with parameter of Scripting::IDictionary** but in MIDL file with description of my interface it's not possible because Scripting library is not presented in default library. I always have scrrun.tlb and trying to use it in MIDL but it's not work
Code is here: midl-code
I've seen a few, and tried out Contact Form 7, which is pretty good but by default looks quite ugly.
I've also had a quick dig, and it looks hard to add some hooks for CSS. It also doesn't use the label element.
What is the best standards compliant easy skinnable contact Wordpress plugin in your experience?
How can I link to resources such as css and javascript files? My default project is using links like ../../Content/styles.css. How can I do something like ~/content/styles.css?
I'd like two websites to have read/write access to the same user profile database (named "aspnetdb" by default). Presumably this is possible by configuring the websites appropriately in the web.config. Are there any issues I should be wary of?
As I understand it, C# passes parameters into methods by reference. In vb.net, you can specify this with ByVal and ByRef. The default is ByVal.
Is this for compatibility with vb6, or is it just random? Also, how can I specify what to use in C#? I kind of like the idea of passing parameters by value.
Since most widgets have a standard method of setting a listener, setOnXXXListener(), just wondering why there is no setDateChangedListener() method for DatePicker?
I know init(int, int, int, OnDateChangedListener) can be used for the same purpose, but surely there must be some reason why Google decided not to use the standard method here. I went through the API docs and couldn't find the reason.
Would one of the gurus here know the answer to this?
Hello
I used the command "net user" to add a new admin user to windows like that:
net user myuser11 myuser11 /add net
localgroup Administrators myuser11 /add
the problem that after restart windows I only see the icon of the "myuser" and the default windows "Administrator" login icon disappeared !!
the "Administrator" files still exists and I can login as "Administrator" after ctrl+alt+del but I need of course to display the "Administrator" icon in welcome screen
how I fix that ?
I use windows xp sp3
thanks
With memcache, when you exceed the available ram, it automatically drops the oldest records off the end of the stack.. Is there a way to do this with redis? I'm trying to find ways to avoid running in to a write error (when there's no more available ram), other than setting a timeout. The only reason the timeout isn't useful, it because it doesn't guaranty the ability to write.
How to get Controller-Level error handling:
This is my map-route:
routes.MapRoute(
"Default", // Route name
"{controller}/{action}/{id}", // URL with parameters
new { controller = "Home", action = "Index", id = "" } // Parameter defaults
);
And I have 2 controllers - HomeController and AwayController
I want both both controllers to handle their own errors
For example, a call to
/Home/InvalidAction would be handled by one method
and
/Away/InvalidAction would be handled by another method
Where InvalidAction currently results in a 404 as there's no Action method with that name
For Testing x509 certificate.I expanded the Default Website node in IIS 7.5.When i right click there is no properties option in popup menu.How to include it?
Hi.
I'm implementing a RESTful web service in python and would like to add some QOS logging functionality by intercepting function calls and logging their execution time and so on.
Basically i thought of a class from which all other services can inherit, that automatically overrides the default method implementations and wraps them in a logger function. What's the best way to achieve this?
I am using godaddy hosting account with windows hosting. Using PHP I am sending email to customers, how do I use my own email address instead of [email protected]
I would like to use [email protected] for all my out going mails and reply to as well. I did by setting a from header in the PHP headers, but its not working.
Any help is appreciated...
Thanks
Vasu
In
Environment - Standard User, Win7x64, IE8 on opening
Unprotected URL, IE 8 will first start a tab with low integrity and the swap out this tab with another tab of medium integrity.
This is done behind the scene and the original IWebBrowser2 pointer is lost.
I want to catch the 'NewProcess' Event which will get generated during this swap out, please help me how to go about this.
Sample code can help me, me using C++
Ref - http://blogs.msdn.com/b/ieinternals/archive/2011/08/03/internet-explorer-automation-protected-mode-lcie-default-integrity-level-medium.aspx
Thank You
Although I'm specifying
<meta http-equiv="X-UA-Compatible" content="IE=8" />
But due to IE's "Display intranet sites in Compatibility View" setting, my app isn't being viewed in IE8, but in compatibility mode.
Anyone know if there is a way round this???
My issue is simple.
I have already implemented a tab system, and I'd probably spend more time implementing another one with the solution I need, than giving a shot at adapting the code I have, and learn something while asking :)
My problem is that the tabs can't be linked to, I need to be able to link to a tab from another website or page, and have that tab get selected upon page load.
ie: I have three tabs showing different products, by default tab 1 is active/selected when the page loads. From the home page I want to link to tab 2 but I can't link to tab 2 because it doesn't get selected. Not sure if that makes sense.
Tabs:
<ul>
<li><a href="products.php">Product 1</a></li>
<li><a href="products.php">Product 2</a></li>
<li><a href="products.php">Product 3</a></li>
</ul>
<div class="tab_container">
<div id="tab1" class="tab_content">Product 1 info...</div>
<div id="tab2" class="tab_content">Product 2 info...</div>
<div id="tab3" class="tab_content">Product 3 info...</div>
</div>
my jQuery:
$(document).ready(function() {
//Default Action
$(".tab_content").hide();
$("ul.tabs li:first").addClass("active").show();
$(".tab_content:first").show();
//On Click Event
$("ul.tabs li").click(function() {
$("ul.tabs li").removeClass("active");
$(this).addClass("active");
$(".tab_content").hide();
var activeTab = $(this).find("a").attr("href");
$(activeTab).fadeIn();
return false;
});
});
Is there a way this code can be adapted to be able to link to any tab from anywhere and have that tab get selected when the page loads?
Thanks in advance.
Edit - Original Title: Is there an alternative way to achieve border-collapse:collapse in CSS (in order to have a collapsed, rounded corner table)?
Since it turns out that simply getting the table's borders to collapse does not solve the root problem, I have updated the title to better reflect the discussion.
I am trying to make a table with rounded corners using the CSS3 border-radius property. The table styles I'm using look something like this:
table {
-moz-border-radius:10px;
-webkit-border-radius:10px;
border-radius:10px}
Here's the problem. I also want to set the border-collapse:collapse property, and when that is set border-radius no longer works (at least in Firefox)(edit- I thought this might just be a difference in mozilla's implementation, but it turns out this is the way it's supposed to work according to the w3c). Is there a CSS-based way I can get the same effect as border-collapse:collapse without actually using it?
Edits:
I've made a simple page to demonstrate the problem here (Firefox/Safari only).
It seems that a large part of the problem is that setting the table to have rounded corners does not affect the corners of the corner td elements. If the table was all one color, this wouldn't be a problem since I could just make the top and bottom td corners rounded for the first and last row respectively. However, I am using different background colors for the table to differentiate the headings and for striping, so the inner td elements would show their rounded corners as well.
Summary of proposed solutions:
Surrounding the table with another element with round corners doesn't work because the table's square corners "bleed through."
Specifying border width to 0 doesn't collapse the table.
Bottom td corners still square after setting cellspacing to zero.
Using javascript instead- works by avoiding the problem.
Possible solutions:
The tables are generated in php, so I could just apply a different class to each of the outer th/tds and style each corner separately. I'd rather not do this, since it's not very elegant and a bit of a pain to apply to multiple tables, so please keep suggestions coming.
Possible solution 2 is to use javascript (jQuery, specifically) to style the corners. This solution also works, but still not quite what I'm looking for (I know I'm picky). I have two reservations: 1) this is a very lightweight site, and I'd like to keep javascript to the barest minimum 2) part of the appeal that using border-radius has for me is graceful degradation and progressive enhancement. By using border-radius for all rounded corners, I hope to have a consistently rounded site in CSS3-capable browsers and a consistently square site in others (I'm looking at you, IE).
I know that trying to do this with CSS3 today may seem needless, but I have my reasons. I would also like to point out that this problem is a result of the w3c speficication, not poor CSS3 support, so any solution will still be relevant and useful when CSS3 has more widespread support.