Find Value in colum - if found get value from row
I have a spread sheet where i would like to find a value
This tells me how many i have in the colum if cems. Now what i need to do
is if that row has done in called cems - return the value in cell D. and
work my way down to get them all.
How would i do this?
Thursday, 3 October 2013
Wednesday, 2 October 2013
Alternating Group
Alternating Group
Suppose that $H$ is a subgroup of $S_n$ of odd order. Prove that H is a
subgroup of $A_n$.
How can I solve this problem without using Cayley's Theorem? So far, I
understand that H contains both even and odd permutations but how would
this make a difference? Thanks.
Suppose that $H$ is a subgroup of $S_n$ of odd order. Prove that H is a
subgroup of $A_n$.
How can I solve this problem without using Cayley's Theorem? So far, I
understand that H contains both even and odd permutations but how would
this make a difference? Thanks.
Selecting results from 2 tables based on the variables in 3th table
Selecting results from 2 tables based on the variables in 3th table
I have 2 tabes in my database:
users - userID(primary key), username, password
courses - id(primary key), name, text
subscriptions - id(primary key), curso_id, user_id
right in the subscription table I am writing the users UserID inside ->
user_id with the id of the course for which he is subscribed curso_id so
the results in the subscrption database are like
id user_id curso_id
1 12 1
2 5 1
3 12 2
4 6 7
My question is how to make a sql Query which first select the course by
$row['id'] which indicates the id variable from the courses database, and
after that based on the 3th table subscription to list all the users which
are subscribed to this course number. ?
and second question is how to list number of the subscribed users for a
course selected by
$row['id']
I have 2 tabes in my database:
users - userID(primary key), username, password
courses - id(primary key), name, text
subscriptions - id(primary key), curso_id, user_id
right in the subscription table I am writing the users UserID inside ->
user_id with the id of the course for which he is subscribed curso_id so
the results in the subscrption database are like
id user_id curso_id
1 12 1
2 5 1
3 12 2
4 6 7
My question is how to make a sql Query which first select the course by
$row['id'] which indicates the id variable from the courses database, and
after that based on the 3th table subscription to list all the users which
are subscribed to this course number. ?
and second question is how to list number of the subscribed users for a
course selected by
$row['id']
What does operator mean, sql?
What does operator mean, sql?
I came accross the sql query where the <=> operator is put. What does <=>
operator mean?
SELECT STR_ID, TEX_TEXT AS STR_DES_TEXT, IF( EXISTS( SELECT * FROM
SEARCH_TREE AS SEARCH_TREE2 WHERE SEARCH_TREE2.STR_ID_PARENT <=>
SEARCH_TREE.STR_ID LIMIT 1 ), 1, 0) AS DESCENDANTS FROM SEARCH_TREE
This sql is of MySQL type.
I came accross the sql query where the <=> operator is put. What does <=>
operator mean?
SELECT STR_ID, TEX_TEXT AS STR_DES_TEXT, IF( EXISTS( SELECT * FROM
SEARCH_TREE AS SEARCH_TREE2 WHERE SEARCH_TREE2.STR_ID_PARENT <=>
SEARCH_TREE.STR_ID LIMIT 1 ), 1, 0) AS DESCENDANTS FROM SEARCH_TREE
This sql is of MySQL type.
fputcsv() error with array
fputcsv() error with array
i tried to make a simple csv export with an easy array, but the server
tells me on every loop "fputcsv() expects parameter 2 to be array, string
given in"
Here is my Array:
"array(12) {
["gender"]=>
string(1) "1"
["first_name"]=>
string(6) "Daniel"
["last_name"]=>
string(5) "Weiß"
["street"]=>
string(12) "Langestrasse 1"
["plz"]=>
string(5) "45265"
["city"]=>
string(8) "Munich"
["country"]=>
string(3) "ger"
["tel"]=>
string(10) "0123456789"
["mobile"]=>
string(0) "0987654321"
["fax"]=>
string(0) ""
["email"]=>
string(8) "yo@lo.de"
["invest"]=>
string(1) "3"
}
Here is the very very simple code
// EXPORT
$fp = fopen('export.csv', 'w');
foreach( $form as $fields ) {
echo $fields;
fputcsv($fp, $fields, ';');
}
fclose($fp);
i tried to make a simple csv export with an easy array, but the server
tells me on every loop "fputcsv() expects parameter 2 to be array, string
given in"
Here is my Array:
"array(12) {
["gender"]=>
string(1) "1"
["first_name"]=>
string(6) "Daniel"
["last_name"]=>
string(5) "Weiß"
["street"]=>
string(12) "Langestrasse 1"
["plz"]=>
string(5) "45265"
["city"]=>
string(8) "Munich"
["country"]=>
string(3) "ger"
["tel"]=>
string(10) "0123456789"
["mobile"]=>
string(0) "0987654321"
["fax"]=>
string(0) ""
["email"]=>
string(8) "yo@lo.de"
["invest"]=>
string(1) "3"
}
Here is the very very simple code
// EXPORT
$fp = fopen('export.csv', 'w');
foreach( $form as $fields ) {
echo $fields;
fputcsv($fp, $fields, ';');
}
fclose($fp);
Tuesday, 1 October 2013
Ubuntu starts in terminal mode not GUI after installed zone minder
Ubuntu starts in terminal mode not GUI after installed zone minder
I was trying to install zoneminder on my Ubuntu 12.04 on my laptop
following this link: http://janhellevik.com/?p=1045
After I reboot my computer, I can not start up ubuntu desktop anymore.
Only a maximized terminal can be seen.
I tried startx, lightdm and also checked the default run level, it's set
as 2.
Can anyone help me to fix this? Or at least let me what's the problem of
this. I have no clue at all..
Thank you very much!
I was trying to install zoneminder on my Ubuntu 12.04 on my laptop
following this link: http://janhellevik.com/?p=1045
After I reboot my computer, I can not start up ubuntu desktop anymore.
Only a maximized terminal can be seen.
I tried startx, lightdm and also checked the default run level, it's set
as 2.
Can anyone help me to fix this? Or at least let me what's the problem of
this. I have no clue at all..
Thank you very much!
Show Base64 file as PNG
Show Base64 file as PNG
Images are captured by one part of our system as PNG files and then base64
encoded and stored on Amazon S3. We'd like to display these images in HTML
emails that are sent and the obvious issue is that they are base64
encoded.
Linking directly to the object doesn't work, and it seems that using an
image tag such as the following does not display the image in any email
client I've tried (Gmail, Live/outlook.com, Outlook, Apple Mail):
<img src="data:image/png;charset=utf-8;base64,http://url/filename" />
Any ideas? I don't have control over the fact that the objects are written
as Base64. I could read/download the objects ahead of time but cannot
write to the file system, so any real-time conversion would need to be
done in memory. Hoping for a solution that leverages HTML. This is not a
background image - it will be in the body itself.
Edit: I've also tried just putting the base64 string in place of the URL -
which works in some cases, but some email clients (like Gmail) won't
display it - which is why I'm preferring a URL-based solution.
Images are captured by one part of our system as PNG files and then base64
encoded and stored on Amazon S3. We'd like to display these images in HTML
emails that are sent and the obvious issue is that they are base64
encoded.
Linking directly to the object doesn't work, and it seems that using an
image tag such as the following does not display the image in any email
client I've tried (Gmail, Live/outlook.com, Outlook, Apple Mail):
<img src="data:image/png;charset=utf-8;base64,http://url/filename" />
Any ideas? I don't have control over the fact that the objects are written
as Base64. I could read/download the objects ahead of time but cannot
write to the file system, so any real-time conversion would need to be
done in memory. Hoping for a solution that leverages HTML. This is not a
background image - it will be in the body itself.
Edit: I've also tried just putting the base64 string in place of the URL -
which works in some cases, but some email clients (like Gmail) won't
display it - which is why I'm preferring a URL-based solution.
WmiPrvSe.exe attempts to modify audio codecs and video DLLs
WmiPrvSe.exe attempts to modify audio codecs and video DLLs
I have a non-virtual Windows 2003 Server SP2 with McAfee Solidcore
installed. A few days ago I noticed that for over a few months, once every
constant amount of time, around 24 hours, a bunch of Solidcore application
errors appear in the event viewer. The events read as follows:
"McAfee Solidifier prevented an attempt to modify file
"C:\windows\system32\msyuv.dll" by process
C:\WINDOWS\system32\wbem\wmiprvse.exe (Process ID: 1234, User: NT
AUTHORITY\SYSTEM)
This also happens for the following files, in every batch of errors:
windows\system32\msvidc32.dll windows\system32\msrle32.dll
windows\system32\iyuv_32.dll windows\system32\msh263.drv
windows\system32\tssoft32.acm windows\system32\msgsm23.acm
windows\system32\msg711.acm windows\system32\msadp32.acm
windows\system32\imaadp32.acm
And more.
Google searches and crawling MSDN and other Microsoft knowledge resources
have turned up nothing useful regarding the cause for this behavior.
Unfortunately, I can't reproduce the issue and it has not happened for
several weeks now, so it's not possible to look into it in real time.
This also occurs on several different servers, some on the same LAN and
some on a completely different network. All of them are Windows Server
2003 SP2 and non-virtual.
Any help would be appreciated.
I have a non-virtual Windows 2003 Server SP2 with McAfee Solidcore
installed. A few days ago I noticed that for over a few months, once every
constant amount of time, around 24 hours, a bunch of Solidcore application
errors appear in the event viewer. The events read as follows:
"McAfee Solidifier prevented an attempt to modify file
"C:\windows\system32\msyuv.dll" by process
C:\WINDOWS\system32\wbem\wmiprvse.exe (Process ID: 1234, User: NT
AUTHORITY\SYSTEM)
This also happens for the following files, in every batch of errors:
windows\system32\msvidc32.dll windows\system32\msrle32.dll
windows\system32\iyuv_32.dll windows\system32\msh263.drv
windows\system32\tssoft32.acm windows\system32\msgsm23.acm
windows\system32\msg711.acm windows\system32\msadp32.acm
windows\system32\imaadp32.acm
And more.
Google searches and crawling MSDN and other Microsoft knowledge resources
have turned up nothing useful regarding the cause for this behavior.
Unfortunately, I can't reproduce the issue and it has not happened for
several weeks now, so it's not possible to look into it in real time.
This also occurs on several different servers, some on the same LAN and
some on a completely different network. All of them are Windows Server
2003 SP2 and non-virtual.
Any help would be appreciated.
opensm reports - Invalid requested MGID. What does it mean?
opensm reports - Invalid requested MGID. What does it mean?
I've been working on a virtualized SR-IOV infiniband interface under Xen.
If I run the OpenSM daemon under Dom0 the passed through ports appear in
DomU and work.
However, not if OpenSM is running on a different host.
I'm actually wanting to run OpenSM under Dom0, it's a good place to put
it. But, when I do I get the following error in my log after a while.
Oct 01 01:00:57 645819 [78D97700] 0x01 -> mcmr_rcv_create_new_mgrp: ERR
1B22: Invalid requested MGID
Oct 01 01:00:57 646091 [7EDA3700] 0x01 -> validate_requested_mgid: ERR
1B01: Wrong MGID Prefix 0x8000 must be 0xFF
Oct 01 01:00:57 646141 [7EDA3700] 0x01 -> mcmr_rcv_create_new_mgrp: ERR
1B22: Invalid requested MGID
Oct 01 01:00:57 646438 [7458E700] 0x01 -> validate_requested_mgid: ERR
1B01: Wrong MGID Prefix 0x8000 must be 0xFF
This error keeps repeating so quickly that the log file ends up filling
the drive up within about 30 minutes or so.
What's could be causing it? how do I fix it?
I've been working on a virtualized SR-IOV infiniband interface under Xen.
If I run the OpenSM daemon under Dom0 the passed through ports appear in
DomU and work.
However, not if OpenSM is running on a different host.
I'm actually wanting to run OpenSM under Dom0, it's a good place to put
it. But, when I do I get the following error in my log after a while.
Oct 01 01:00:57 645819 [78D97700] 0x01 -> mcmr_rcv_create_new_mgrp: ERR
1B22: Invalid requested MGID
Oct 01 01:00:57 646091 [7EDA3700] 0x01 -> validate_requested_mgid: ERR
1B01: Wrong MGID Prefix 0x8000 must be 0xFF
Oct 01 01:00:57 646141 [7EDA3700] 0x01 -> mcmr_rcv_create_new_mgrp: ERR
1B22: Invalid requested MGID
Oct 01 01:00:57 646438 [7458E700] 0x01 -> validate_requested_mgid: ERR
1B01: Wrong MGID Prefix 0x8000 must be 0xFF
This error keeps repeating so quickly that the log file ends up filling
the drive up within about 30 minutes or so.
What's could be causing it? how do I fix it?
Subscribe to:
Comments (Atom)