Not quite sure how to ask or define this, but can't figure it out.
I have three tables like this:
persons person_id, first_name, last_name
hobbies hobby_id, name
persons_hobbies person_id, hobby_id
I need to make two lists. Persons that have both hobby A and B, and persons that have hobby A but not B. How can I write these two queries? Can't figure out how to do this with joining and all...
Suppose I have a 2 column table (id, flag) and id is sequential.
I expect this table to contain a lot of records.
I want to periodically select the first row not flagged and update it. Some of the records on the way may have already been flagged, so I want to skip them.
Does it make more sense if I store the last id I flagged and use it in my select statement, like
select * from mytable where id > my_last_id order by id asc limit 1
or simply get the first unflagged row, like:
select * from mytable where flagged = 'F' order by id asc limit 1
Thank you!
Im using c# .net windows form application. I have a database with some tables.I have two comboboxes (A & B). I have populated a combo box A with column names of a table using sys.columns. Now when i select an item in combo box A ,combo box B should be populated with the same items except the selected item which was selected in combobox A .
I've been having issues with this for a little while now. I feel like I should know this but I can't for the life of me remember.
How can I map the screen pixels to their respective 'graphical' x,y positions? The co-ordinate systems have been configured to start at the bottom left (0,0) and increase to the top-right.
I want to be able to zoom, so I know that I need to configure the zoom distance into the answer.
Screen
|\ Some Quad
| \--------|\Qx
| \ Z | \
| \ \|Qy
\ |
Sx\ |Sy
\|
I want to know which pixels on my screen will have the quad on it. Obviously as Z decreases, the quad will occupy more of the screen, and as Z increases it will occupy less, but how exactly are these calculated?
Thanks for any help.
Hi,
I would like to create a calendar that displays a year from today(everyday) and allows the user to select the multiple dates.
I tried to use the asp:calendar without any success
I am developing in C# .NET
any suggestion
Hi All,
I have 2 tables, user and userprofile. The userprofile table has a lot of fields similar to the user table. What I need to do is, on click of a button I need to copy all the fields of user table to userprofile table.
UserModel AttData = UserModel[0];
DataServices.Save((UserProfile)AttData.ProfileModel.Instance); UserModel[0] contains all the data in user table. I want to copy this data to AttData.ProfileModel.Instance. How can I do that?
Instead of making a macro for each letter, as in
\def\bA{\mathbf{A}}
...
\def\bZ{\mathbf{Z}}
Is there a way to loop over a character class (like capital letters) and generate macros for each? I'd also like to do the same for Greek letters (using bm instead of mathbf).
how can i copy part of the specific string to the another place
example
(aaa),(ddd),(fff),(fff),#p
copy (ddd) to the side of the p
(aaa),(fff),(fff),#p,(ddd) //before copyin add comma
copy (fff) to side of the (ddd)
(aaa),(fff),#p,(ddd),(fff) //string lenght always same
Hi, i'm not an expert of Nant, so i'll have to ask this redicolus question.
i have a variable called svn.source.root which point to c:\folderA\FolderB\FolderC
how can i make svn.source.root.modified variable to point to 2 folders up? i.e, folderA
Obviously, the following didn't work:
please help.
thanks
I've seen so many misuses of RegExp, I don't really like it :)
I have string (as a result of two str_replaces) that might look something like this:
.?This iš my ".stRiNg."!
|
V
--this-is-my---string---
Is there any way better than
$string = trim(preg_replace('/[-]+/u','-', $string),'-');
to get:
this-is-my-string
?
Let's say I have a C# variable and array:
int variable_1 = 1;
int[3] array_1 = {1,2,3};
How can I check if the value of variable_1 is equal to any of the values in array_1 without looping through array_1?
I'm trying to run a mock webserver within a thread within a class. I've tried passing the class' @server property to the thread block but as soon as I try to do server.accept the thread stops. Is there some way to make this work? I want to basically be able to run a webserver off of this script while still taking user input via stdin.gets. Is this possible?
class Server
def initialize()
@server = TCPServer.new(8080)
end
def run()
@thread = Thread.new(@server) { |server|
while true
newsock = server.accept
puts "some stuff after accept!"
next if !newsock
# some other stuff
end
}
end
end
def processCommand()
# some user commands here
end
test = Server.new
while true do
processCommand(STDIN.gets)
end
In the above sample, the thread dies on server.accept
I have 3 images, all same size, across top of page horizontally. I'd like to use Cycle to fade each instance very slowly, but I'd also like make sure the transitions do not start all at the same time, but are staggered. Is there somewhere this can be specified? If anyone can recommend a very slow fade rate, plus a way to prevent all 3 from fading/regenerating at the same time, I'd be very grateful!
I assume I can run 3 instances of cycle using different classes for each container, and assure that no two photos are the same by "stacking" them in different orders within the divs ... yes?
Thank you!
Is there any way to fit in 1 line using the pipes the following:
output of
sha1sum $(xpi) | grep -Eow '^[^ ]+'
goes instead of 456
sed 's/@version@/456/' input.txt > output.txt
ISNULL(SUM(MyTable.Total), 0) AS Total
how can i modify the above statement to also check if Total is less than 0 (zero), such that if Total is NULL or less than 0 (negative), i assign 0 to Total
Can someone help me fill in the blanks with native JavaScript?
function getHeading(lat1, lon1, lat2, lon2) {
// Do cool things with math here
return heading; // Should be a number between 0 and 360
}
I've been messing around with this for a long time and can't seem to get my code to work right.
Hi,
I can set the edit mode for a while uitableview by calling [tableView setEditing:YES]; But that sets the edit mode for all the rows in a table.
Is there a way to detect what row was swiped an enable the edit mode only for that row?
Thanks
Hi,
Is it possible to mutate an object into an instance of a derived class of the initial's object class?
Something like:
class Base():
def __init__(self):
self.a = 1
def mutate(self):
self = Derived()
class Derived(Base):
def __init__(self):
self.b = 2
But that doesn't work.
>>> obj = Base()
>>> obj.mutate()
>>> obj.a
1
>>> obj.b
AttributeError...
If this isn't possible, how should I do otherwise?
My problem is the following:
My Base class is like a "summary", and the Derived class is the "whole thing". Of course getting the "whole thing" is a bit expensive so working on summaries as long as it is possible is the point of having these two classes. But you should be able to get it if you want, and then there's no point in having the summary anymore, so every reference to the summary should now be (or contain, at least) the whole thing. I guess I would have to create a class that can hold both, right?
class Thing():
def __init__(self):
self.summary = Summary()
self.whole = None
def get_whole_thing(self):
self.whole = Whole()
I have vendors/show view with button "Add new item" button. When i press "Add new item", it leads to items/new view with select which contain all Vendors.
I want to send vendor id value to items/new, that way it will be possible to show correct Vendor on my select.
How it can be done RIGHT?
I am trying to model a sales situation where you can sell to a person or to a business with a contact person. I cannot figure out the proper way to do this.
It seems like 2 tables would be incorrect. But how do I model a Customer table that can be a business or a person? Would I just have a boolean for "business" and an additional "business_name" field that would default to Null. But then I have to do an if/then on the columns and that seems like poor design.
Any advice, direction, or links is appreciated.
Here's the deal :
I have Publication objets in my application.
I also have Vote objet.
I can add votes on publication. A vote is defined like this, forOrAgainst, LinkedPublication, date, author etc etc...
I want to sort Publication list by number of vote.
What is the best way to link them ?
Should i return a hashmap ? a treeset ?
How do i add votes to publication.
It's kinda messy in my brain now...
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?