I did this:
ALTER TABLE `db`.`my_table`
ADD CONSTRAINT FOREIGN KEY (`my_second_table_id`)
REFERENCES `my_second_table` (`id`);
I should have done this:
ALTER TABLE `db`.`my_table`
ADD CONSTRAINT FOREIGN KEY (`my_second_table_id`)
REFERENCES `my_second_table` (`id`)
ON DELETE SET NULL;
Is it possible to ALTER this, or do I have to drop the constraint and add again?
Hello, I'm going to be messing with some stuff at the raw HTTP level during the next few days and I'd like to make sure I'm following the standard as close as possible. Are there any tools out there to validate the HTTP responses that my server puts out to make sure they conform to the specification?
Hello, I have created a custom Outlook form in 2007 and I have some receipeints that need to visualize it but do not use Outlook as their email program. Is it possible to make changes to the Form to ensure that they are able to view the form as an email?
Hey
I know that in the google maps API it's possible to replace the existing tiles with my own - and using their tile server - feed my own maps.
i'm interested in doing this using monotouch - is there any way of doing this atm - or does anyone know of a way of achieving this any other way?
w://
Here's what I am looking to accomplish, I have a class that has an enum of some values and I want to subclass that and add more values to the enum. This is a bad example, but:
public class Digits
{
public enum Digit
{
0, 1, 2, 3, 4, 5, 6, 7, 8, 9
}
}
public class HexDigits extends Digits
{
public enum Digit
{
A, B, C, D, E, F
}
}
so that HexDigits.Digit contains all Hex Digits. Is that possible?
I want to return an entire entity, along with some aggregate columns. In SQL I would use an inner select, something like this:
SELECT TOP 10 f.*, inner_query.[average xxx]
FROM (
SELECT f.Id, AVG(fb.xxx) AS [average xxx]
FROM foobar fb
INNER JOIN foo f ON f.FoobarId = fb.Id
) AS inner_query
INNER JOIN foo f ON f.Id = inner_query.Id
Is this possible with CreateCriteria?
Is it possible to get the author of the current commit of a folder with SharpSVN. So doing this without retrieving the log file of the svn server. I tried:
client.TryGetProperty(folder, SvnPropertyNames.SvnAuthor, out AuthorStr);
but the AuthorStr string is null.
Hello
I've seen BalusC's page on passing values to a validator but that is using inputText components. I'm using rich:inplaceInput components and it doesn't seem to work. Can someone tell me if it is possible, and if it is how to do simply?
Thanks
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?
I have a basic doubt that, How can we have both CLR's on a same machine. If this is possible, When I refer few dll's of 4.0 and setting application pool to 2.0 why Cant I run the website(I am getting errors).When we refer the dll's from web.config it means it searches for GAC when that particular 4.0 dll is available in GAC Why dont it load (How come it is not loading).. Please clarify my doubts
Say I have a structure like:
class SomeObject
Public Name as String
Public Created as Date
...
end class
I have a List(of SomeObject), which has multiple entries for each name with different times. I'd like to select the newest (largest Created value) object for each Name.
Given:
Name Created
A 2010-04-16 *
A 2010-04-15
B 2010-04-12
B 2010-04-13 *
C 2010-04-16 *
I'd like to pick the objects with the * beside them.
Is this possible using LINQ?
Just a quick question on NSTextView - I need to get a NSTextView to highlight text, a bit like showFindIndicatorForRange: however permanent and in a different color. I've seen Pages do it, is it possible without any subclasses? Or will I have to create my own?
Question for Flex guys.
How can I use multiple item renderers in mx:Tree depending on item's depth/level in tree?
For example. For the first level items I want to use label with button and for second level items combobox.
Is this somehow possible?
Hello, i'm trying to hide an AnnotationView without touching the pin, is the possible?
Thanks!
for (id currentAnnotation in self.mapView.annotations) {
if ([currentAnnotation isKindOfClass:[MyAnnotation class]]) {
}
}
I'm writing a very simple webpage in html5 for iPhone.
the page is this one
Not Working
Everything works but in the page from the iPhone i see the quicktime logo with a slash on it
and if i tap on it the player shows up the play button and in the background there is the quicktime logo. is it possible to replace the logos with a personal image? thank you in advance.
Is it possible to call a page by using
HtmlPage.Window.Navigate("ShowMedia.aspx", "_blank");
from my silverlight code behind?
The ShowMedia.aspx is located in my
<projectName>.web
If you go to "Control Panel\Hardware and Sound\Devices and Printers" in Windows 7 (and i assume vista) you will see some nice pretty pictures of printers.
See image below
Is it possible to get access to these images through .net?
For example to display them on a windows form?
I have (for example) an object of type A that I want to be able to cast to type B (similar to how you can cast an int to a float)
Data types A and B are my own.
Is it possible to define the rules by which this casting occurs?
Example
int a = 1;
float b = (float)a;
int c = (int)b;
Is it possible to create a mercurial repository inside an existing mercurial repository?
The idea is to handle subdirectories of a repository as different repositories, how do you do that?
I'm not talking about subrepos (at least, if I understood the purpose of subrepos...), but if this is how subrepos do exist for, I got it wrong and I'll try to get it right :)
Thanks
~Aki
I have two classes that work seperate from another, but they extend the same class. Is it possible to have them work the same instance of the extended class. I'm wanting the constructor of the extended class to run only once.
I know this isn't right but something like this:
<?php
$oApp = new app;
class a extends $oApp {}
class b extends $oApp {}
Hi, sorry this is probably a dumb question, but I want to make the background of a normal UIViewController look like the gray, pinstriped background that of a grouped UITableView. Is this possible. Tell me if you need pictures, and I'll post some. Thanks for any help,
I'm currently looking into the JQuery library for CSS Layout Template module
Is it possible to define the height of a placeholder with *?
Meaning it will push content down if it has to, or fill up any remaining space if the complete content is less then the view port.
This would be really nice to make the whole sticky footer thing much easier and robust.