why query giving 0 rows
Query1
SELECT SessionInfo.IVRSessionInfoID
FROM SessionInfo
WHERE SessionCallTime BETWEEN UNIX_TIMESTAMP('2013-08-01 00:00:00')
AND UNIX_TIMESTAMP('2013-08-01 23:59:59')
ORDER BY SessionInfo.SessionCallTime DESC;
Query2
SELECT SessionInfo.IVRSessionInfoID
FROM SessionInfo
WHERE (SessionInfo.SessionCallTime BETWEEN '2013-08-01 00:00:00'
AND '2013-08-01 23:59:59')
ORDER BY SessionInfo.SessionCallTime DESC;
what is the diffrence why first query gives 0 rows second query gives records
in this tables 20000 rows betwqeen this two dates
table schema
CREATE TABLE `SessionInfo` (
`IVRSessionInfoID` bigint(8) unsigned NOT NULL AUTO_INCREMENT,
`SessionCallTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`MGServerIP` varchar(15) NOT NULL,
`MGServerPort` smallint(2) unsigned NOT NULL DEFAULT '5060',
`SessionUniqueID` varchar(64) NOT NULL,
`ANI` varchar(20) NOT NULL,
`CountryID` int(4) unsigned DEFAULT NULL,
`CountryStateAreaID` int(4) unsigned DEFAULT NULL,
`AccessNumberProviderLogID` int(4) unsigned DEFAULT NULL,
`AccessNumberLogID` int(4) unsigned DEFAULT NULL,
`AccessRestrictionLogID` int(4) unsigned DEFAULT NULL,
`SubscriberCardID` bigint(8) unsigned DEFAULT NULL,
`SessionDuration` int(4) unsigned NOT NULL,
`SessionRNDDuration` int(4) unsigned NOT NULL,
`TotalCharge` decimal(15,6) unsigned NOT NULL,
`RuleSetLogID` int(4) unsigned DEFAULT NULL,
`RuleSetChargeInfoLogID` int(4) unsigned DEFAULT NULL,
`RuleSetRNDDuration` int(4) unsigned NOT NULL,
`RuleSetTotalCharge` decimal(15,6) unsigned NOT NULL,
PRIMARY KEY (`IVRSessionInfoID`),
UNIQUE KEY `UNIQUE` (`SessionUniqueID`),
KEY `SessionCallTime` (`SessionCallTime`),
KEY `ANI` (`ANI`),
KEY `CountryID` (`CountryID`),
KEY `CountryStateAreaID` (`CountryStateAreaID`),
KEY `AccessNumberProviderLogID` (`AccessNumberProviderLogID`),
KEY `AccessNumberLogID` (`AccessNumberLogID`),
KEY `AccessRestrictionLogID` (`AccessRestrictionLogID`),
KEY `SubscriberCardID` (`SubscriberCardID`),
) ENGINE=InnoDB AUTO_INCREMENT=22199955 DEFAULT CHARSET=latin1
ROW_FORMAT=COMPACT;
Tuesday, 1 October 2013
Why is headhunting uncommon for academic positions=?iso-8859-1?Q?=3F_=96_academia.stackexchange.com?=
Why is headhunting uncommon for academic positions? –
academia.stackexchange.com
In scientific conferences, there are usually many headhunters who come to
offer newly graduated scholars jobs in the industry sector. As a matter of
fact, the recruitment in industry mostly works with …
academia.stackexchange.com
In scientific conferences, there are usually many headhunters who come to
offer newly graduated scholars jobs in the industry sector. As a matter of
fact, the recruitment in industry mostly works with …
Monday, 30 September 2013
Evaluate $ \lim=?iso-8859-1?Q?=5F{x\rightarrow{\frac\pi2_}}_?=(\sec(x) \tan(x))^{\cos(x)}$ without L'Hôpital's rule – math.stackexchange.com
Evaluate $ \lim_{x\rightarrow{\frac\pi2 }} (\sec(x) \tan(x))^{\cos(x)}$
without L'Hôpital's rule – math.stackexchange.com
I have tried changing limit to $\lim_{x\rightarrow0}$ and use some
trigonometry identity ($\sin^2(x)+\cos^2(x) = 1$ and $\sin (x+\pi/2) =
\cos(x)$) but doesn't work I have no idea on how to do this …
without L'Hôpital's rule – math.stackexchange.com
I have tried changing limit to $\lim_{x\rightarrow0}$ and use some
trigonometry identity ($\sin^2(x)+\cos^2(x) = 1$ and $\sin (x+\pi/2) =
\cos(x)$) but doesn't work I have no idea on how to do this …
How to show that $(\delta'f)(e)=\delta(\phi^* f)(e)$?
How to show that $(\delta'f)(e)=\delta(\phi^* f)(e)$?
I am reading linear algebraic groups.
I have a question in line 4 of the third paragraph of Page 66. How to show
that $(\delta'f)(e)=\delta(\phi^* f)(e)$ for all $f\in K[G]$? Here $G$ is
an algebraic group, $K$ is an algebraic closed field, $\delta' =
\operatorname{Ad} x(\delta) = d(\operatorname{Int} x(\delta))$,
$\phi=\operatorname{Int} x$, $\operatorname{Int} x(y) = xyx^{-1}$, $x, y
\in G$. Thank you very much.
I think that $\delta'f = d(\operatorname{Int} x(\delta))f$.
I am reading linear algebraic groups.
I have a question in line 4 of the third paragraph of Page 66. How to show
that $(\delta'f)(e)=\delta(\phi^* f)(e)$ for all $f\in K[G]$? Here $G$ is
an algebraic group, $K$ is an algebraic closed field, $\delta' =
\operatorname{Ad} x(\delta) = d(\operatorname{Int} x(\delta))$,
$\phi=\operatorname{Int} x$, $\operatorname{Int} x(y) = xyx^{-1}$, $x, y
\in G$. Thank you very much.
I think that $\delta'f = d(\operatorname{Int} x(\delta))f$.
Remove x amount of elements with .remove()
Remove x amount of elements with .remove()
I am not seeing any clear documentation on removing a certain amount of
elements without it being in a specific order, of course there are many
ways to remove a list of say 5 items, if they are in that order. What if
there is elements that you don't want removed in between? Let me show you
an example
FIDDLE: Below is just pieces from this fiddle, it would be easier just
taking a look at the fiddle.
HTML
<div class="item empty">Empty</div>
<div class="item empty">Empty</div>
<div class="item editable">Editable</div>
<div class="item empty">Empty</div>
</div>
<button class="demo">Demo</button>
jQuery
$('.demo').click(function() {
var length = $('.item').length,
columns = 12/6,
addColumn = columns - length
//Set this for subtracting elements if addColumn is a negitive
if(addColumn < 0) {
//Want to remove the amount of items which is -2 in this case
$('.item.empty').eq(/*Remove whatever amount of addColumn */ ).remove()
}
//Equals -2
alert(addColumn)
});
So just to be clear, I am trying to remove the amount of .empty items
based on whatever the amount is passed into the addColumn variable in this
case its static set at -2.
So I ask if addColumn < 0 is a negative number then we do subtraction
using .remove() and I need to remove the amount of .empty items equal to
the addColumn variable.
12/6 comes from a 12 column grid and the 6 is a two column layout span6
span6 and so if the layout is set at 4 columns we need to remove 2
columns, which is where the -2 comes from.
I am not seeing any clear documentation on removing a certain amount of
elements without it being in a specific order, of course there are many
ways to remove a list of say 5 items, if they are in that order. What if
there is elements that you don't want removed in between? Let me show you
an example
FIDDLE: Below is just pieces from this fiddle, it would be easier just
taking a look at the fiddle.
HTML
<div class="item empty">Empty</div>
<div class="item empty">Empty</div>
<div class="item editable">Editable</div>
<div class="item empty">Empty</div>
</div>
<button class="demo">Demo</button>
jQuery
$('.demo').click(function() {
var length = $('.item').length,
columns = 12/6,
addColumn = columns - length
//Set this for subtracting elements if addColumn is a negitive
if(addColumn < 0) {
//Want to remove the amount of items which is -2 in this case
$('.item.empty').eq(/*Remove whatever amount of addColumn */ ).remove()
}
//Equals -2
alert(addColumn)
});
So just to be clear, I am trying to remove the amount of .empty items
based on whatever the amount is passed into the addColumn variable in this
case its static set at -2.
So I ask if addColumn < 0 is a negative number then we do subtraction
using .remove() and I need to remove the amount of .empty items equal to
the addColumn variable.
12/6 comes from a 12 column grid and the 6 is a two column layout span6
span6 and so if the layout is set at 4 columns we need to remove 2
columns, which is where the -2 comes from.
Getting div id by GET in Javascript
Getting div id by GET in Javascript
Ciao
I need to create a dynamic form based on user selections.
I.e. in the first form field I select "John Smith", this will populate
(through an external php/mysql file ) the second select field "Artist,
Carpenter, Other", if I choose Artist I populate the third select field
with "Singer, Painter, Sculptor" and so on
Giving my incompetence on javascript, I spent the morning googling for
scripts and I found a cool tutorial here
It works, it's clean, but it updates only the div with id txtResult, which
is statically included in the js file (see lines 19 and 31 of
ajax_req.js). I thought I could pass the id name by GET, but I don't know
how to make the script recognize the variable.
This is the code:
function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("txtResult").innerHTML=
xmlHttp.responseText;
}
}
I had in mind to pass by GET the id name and have something like this:
function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("GET[idName]").innerHTML=
xmlHttp.responseText;
}
}
Can you please help me? I could change script too if you happen to know
something better
Ciao and thank you,
Ed
Ciao
I need to create a dynamic form based on user selections.
I.e. in the first form field I select "John Smith", this will populate
(through an external php/mysql file ) the second select field "Artist,
Carpenter, Other", if I choose Artist I populate the third select field
with "Singer, Painter, Sculptor" and so on
Giving my incompetence on javascript, I spent the morning googling for
scripts and I found a cool tutorial here
It works, it's clean, but it updates only the div with id txtResult, which
is statically included in the js file (see lines 19 and 31 of
ajax_req.js). I thought I could pass the id name by GET, but I don't know
how to make the script recognize the variable.
This is the code:
function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("txtResult").innerHTML=
xmlHttp.responseText;
}
}
I had in mind to pass by GET the id name and have something like this:
function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("GET[idName]").innerHTML=
xmlHttp.responseText;
}
}
Can you please help me? I could change script too if you happen to know
something better
Ciao and thank you,
Ed
Sunday, 29 September 2013
Visited every section of the FAQ (retired)
Visited every section of the FAQ (retired)
The way to earn the 'Analytical' badge is: Visited every section of the
FAQ (retired). What does (retired) mean? Does it mean that it is no longer
available?
The way to earn the 'Analytical' badge is: Visited every section of the
FAQ (retired). What does (retired) mean? Does it mean that it is no longer
available?
Subscribe to:
Posts (Atom)