What's the easiest way to change a text's color based on a variable?
For example: If $var is between 1-5, green. Between 6-10, Orange. Greater than 11, Red.
Hello,
I am after an SQL command to find units with no categories. Here are the tables:
Unit
id name
UnitCategory
id name
UnitCategoryIndex
id categoryid unitid
Thanks!
Been searching for an answer to this for the better part of an hour without much luck. I have two regional tables laid out with the same column names and I can put out a result list for either table based on the following query (swap Table2 for Table1):
SELECT Table1.YEAR, FORMAT(COUNT(Table1.id),0) AS Total
FROM Table1
WHERE Table1.variable='Y' …
I have a table with the following columns and data
Category Item Price Tax
A I1 1.00 .01
A I2 2.22 .02
B I3 3.33 0.3
I want to group on Category and have the details below such as:
Category/Item Price Tax
A
I1 1.00 .01
I2 2.22 .02
B
I3 3.33 .03
I want the category to have its own row then the detail rows below with the item in the same…
I'm looking for some resources that demonstrate good graphic design for generated (PHP/HTML/CSS) reports.
The website I'm designing is essentially a long test. Everything is finished except the report generation, and this part needs to look good!
I'd appreciate any advice/resources you can point me to! I know this isn't directly…
I have two fields:
string date1 = "04/26/10";
string date2 = "04/25/10";
How can I compare these two fields like so?:
if (date2 <= date1)
{
// perform some code here
}
Can this be done without first converting the fields to a separate date-type variable?
We are developing a web application and the framework under it. I would like to be able to use the framework for other projects and I am even considering making the framework open source.
Right now each developer has 2 separate folders, one for each. I then have a 3rd folder with symlinks to the files in the to git project folders.…
Client is requesting a single track to be heard across the website. Generally I advise against it, but they insist. So, what is the most straightforward way of having a flash player embedded in a site, and when a user goes to another page there isn't a gap/interruption?
I am thinking an iframe is required.. I am using a flash…
i have tried jQuery('#form_id').serialize(). this returns only the form data as a url encoded string. is it possible to get the form data as an object?
I'm new to php and CI, and I'm having some trouble in my controller.
I feel that I'm doing this the wrong way, and it could be easier, I just don't know the syntax:
$data['members'] = $this->home_model->getUser($id);
$credit = $this->home_model->getCredit($id);
if ($credit == '0'){stuff...}
So I'm…
I have an organization that has clients and students, every student begins as a client.
If I have a Client class and a student class that inherits from client. How do I make a client a student?
I have a user account on a cluster( a server), and can only install program like python on the home folder. In case I might accidentally delete the bin, lib, share,include folders coming with the installation of python on the home folder. I change the permissions of the above folder like this
chmod -w folder
but I am…
My Spider Sense warns me that using eval() to parse incoming JSON is a bad idea. I'm just wondering if JSON.parse() - which I assume is a part of JavaScript and not a browser-specific function - is more secure.
For clarification, are you able to use MySQL this way to sort?
ORDER BY CompanyID = XXX DESC
What I am trying to do is use one sql query to sort everything where X = Y, in this case, where CompanyID = XXX. All values where CompanyID is not XXX should come after all the results where CompanyID = XXX.
I don't want to…
All the articles I Googled on this subject are dated back in 2004-2005.
Basically I am structuring precanned searches, and it is based off of categories the client will input.
Example
content/(term name)/index.htm
Does it matter if I used the raw term with a space, which is converted to %20 in the URL, or should I…
An issue that regularly seems to rear its head on my travels is that of headless build servers for SSDT. What does that mean exactly? Let me give you my interpretation of it. A SQL Server Data Tools (SSDT) project incorporates a build process that will basically parse all of the files within the project and spit out…
In this Issue: Roy Dallal, Kevin Dockx, Gill Cleeren, Oren Gal, Colin Eberhardt, Rudi Grobler, Jesse Liberty, Shawn Wildermuth, Kirupa Chinnathambi, Jeremy Likness, Martin Krüger(-2-), …
In this Issue: Joost van Schaik, Manas Patnaik, Kevin Hoffman, Jesse Liberty, Deborah Kurata, Dhananjay Kumar, Dennis Delimarsky, Samuel Jack, Peter Kuhn, WindowsPhoneGeek, and Jfo.
…
In this Issue: Oren Gal, Andrea Boschin(-2-), Kevin Hoffman, Rudi Grobler(-2-, -3-), Michael Crump, Yochay Kiriaty, Peter Kuhn, Loek van den Ouweland, Jeremy Likness, Jesse Liberty, and WindowsPhoneGeek.
Above the Fold:
Silverlight:
"Multiple…
Online Patching is is one of the cornerstone new features in our upcoming Oracle E-Business Suite 12.2 release. This ground-breaking feature is based upon Edition-Based Redefinition, a new 11gR2 Database feature that was built to Oracle Applications division specifications to allow the E-Business Suite's…
In this Issue: Rob Eisenberg(-2-), Gill Cleeren, Colin Eberhardt, Alex van Beek, Ishai Hachlili, Ollie Riches, Kevin Dockx, WindowsPhoneGeek(-2-), Jesse Liberty(-2-), and John Papa.
…
So I have finally dried the tears after watching the Keynote for Build 2012. This wasn’t because it was an emotional presentation, but because for the second year I missed the goodies. Each on site attendee got a Surface RT, a Lumia 920 and a voucher for 100GB of SkyDrive storage. The event…
I just got back (a few hours ago) from Minneapolis, where I was speaking at the Twin Cities Code Camp 8. I’d never been to a Twin Cities Code Camp, and I have always heard such great things, so I submitted and got accepted to speak. The conference (what I got to see) was great. My talk was pretty short…
Hello All,
This is going to be my first post here. I 'm working as an Administrator at SNI.
I have been responsible for managing Celerra and Clariion,but this new environment has 2 VMAX boxes . Since, I don't have prior experience is managing symmetrix ,i am kinda stuck here ( no training as well)
Can…
Oracle today announced that it has completed the acquisition of Art Technology Group (ATG), Inc. In a webcast this morning, Thomas Kurian, Executive Vice President, Oracle Anthony Lye, Senior Vice President, CRM at Oracle and Ken Volpe, Senior Vice President of Products and Technology from ATG,…