When there is no border, why IE returns medium while FF returns 0px on the following query ?
.css("border-left-width")
I checked this in FF 3.6.3 and IE 6/7.
Example here
I want to make this kind of query:
create procedure something
@name varchar(13)
as
begin
select * from WORKER
where NAME LIKE "%@name%"
end
For input @name=ho, I want output every row that contains NAME wich sounds "ho",
for example HOuse, soHO, broHOw...
Hello,
How can I update the value of an xml tag with the value of an xml tag from another related table?
something like this:
UPDATE v2
SET
[xml].modify ('replace value of (//TAG1/text())[1]
with "CAST(v1.[xml].query(''//TAG2'') AS NVARCHAR(MAX))"')
FROM
table2 v2,
table1 v1
WHERE
v2.id = v1.id
Thanks
Is there any interpreter that takes a string or even a custom object as input and execute it on my datasource?
I cannot use linq to object because query always changes and the report i'm working on, has about 6000 queries which i can reduce to 9 if i find some tool doing that for me.
Opensource is very applicable.
thanks in advance.
I need to check the checked property of a checkbox and perform an action based on the checked property using jQuery.
For example, if the age checkbox is checked, then I need to show a textbox to enter age, else hide the textbox.
But the following code returns false by default:
if($('#isAgeSelected').attr('checked')) {
$("#txtAge").show();
} else {
$("#txtAge").hide();
}
How do I successfully query the checked property?
Do all deadlocks indicate a problem with the query or does this kind deadlock indicate a problem with something else like SQL mail or something? The stored proc in question uses SQL mail.
I have a grouped query, and would like to filter it based on count(*)
Can I do this without a subquery?
This is what I have currently:
select *
from (select ID,
count(*) cnt
from name
group by ID)
where cnt > 1;
Hello,
I have simple situation (like on the image link text) and simple SQL query
SELECT M.Name,
A.Name,
B.Name
FROM Master M LEFT JOIN DetailA A
ON M.DescA = A.Id LEFT JOIN DetailB B
ON M.DescB = B.Id
How to achive the same effect in nHibernate using CriteriaAPI ?
Hey guys,
I want to display items in a dropdownlist like 5%, 10%, 15%, 20% until 100.
Is there a way to bind an intelligent LINQ query to the datasource that will do this for me?
I'm create a list item via ASP.Net to be published automatically on Sharepoint. However, I cannot find how to define the content type via the CAML query.
Consider a news portal like cnn. There is 8 categories. Is there 8 query in every page loading? For eg
SELECT title FROM category where cID = 1
SELECT title FROM category where cID = 2
...................
And for sites with high traffic, would be memcache a good solution?
Thanks in advance
When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the unused columns in a table. How can I easily find out which are the unused columns, so I can filter them out of ALL_TAB_COLS?
excuse my English I speak Spanish
I'm trying to display multiple php and mysql registration, after that the show in an iframe
the problem is that apparently in the iframe shows me errors accents and other characters for example: for example (?D?nde cuesta menos y se consume m?s?")
this is what shows (?)
In the original query or first does not show me that, but in the iframe shows me that error
and probe with http-equiv = "content-type" and I worked
What else I can do?
What should I do?
regards
Hello!
To empty database table, I use this SQL Query:
TRUNCATE TABLE `books`
How to I Truncate table using Django models and orm?
I've tried this, but it doesn't work:
Book.objects.truncate()
Part of the code:
...where se.DateFrom >= pDateFrom && se.DateTo <= pDateTo select se...
Does not work. There is no any error but the To and From days do not get returned.
How do I query "more than or equal to" and "less than or equal to"?
Thanks :)
When user opens a form to modify a record, but instead of changing information, he just clicks the Update button. Which causes the update() function to return 0. However, I consider this case a valid update task. How would I test it, so I can assign a success message?
Is update() returns -1 when SQL query failed or also 0?
Method: Zend_Db_Table_Abstract::update()
Any ideas?
Thanks
When I do an XMLHttpRequest, I always get redirected automatically to the URL (presumably by the headers of the response). For example, if I query "http://www.stackoverflow.com" I will be redirected to "http://stackoverflow.com".
How can I get that final URL? (http://stackoverflow.com/ in the example)
I checked in the response headers but I cannot seem to find it. (I just used the GET/POST method not HEAD).
Hi,
I want to be able to store the current time in millis in an oracle number field. How do I do this via a query?
select systimestamp from dual; returns the actual timestamp. Is there anyway that I can convert this into milliseconds the same way java's System.currentTimeMillis() does?
Why do I get a 400 - bad request error using the following URL? It is encoded using Server.UrlEncode. The actual path query parameter is C:\Development\Chase\Exports\ChaseExport-090312073930.zip
http://localhost:50199/Common/Forms/Export_Stream.aspx%3fpath%3dC%3a%5CDevelopment%5CChase%5CExports%5CChaseExport-090312073930.zip
I have the following XML:
<tests>
<test>1</test>
<test>2</test>
<test>3</test>
</tests>
And I am trying the following query:
CREATE PROCEDURE [dbo].[test]
@Tests xml=null
AS
BEGIN
SELECT
doc.col.value('(test)[1]', 'nvarchar(50)')
FROM
@Tests.nodes('//tests') AS doc(col)
END
But it only returns me a value from the first
What am I missing here?
This is my query, how can I use string as orderby parameter?
string sortColumn="Title";
var items = (from ltem in ctxModel.Items
where ltem.ItemID == vId
orderby //something here
select ltem).Skip(PageSize * PageIndex).Take(PageSize);
I'm working on a Facebook app, and I'm trying to get a friends list similar to Farmville 2.
They have a "friends who like games" list. My first thought is, I can get a list of all friends, then for each friend, see if they like any pages with type == "GAMES/TOYS". But ideally, I would like to get the list in one query (not by making one graph API or FQL request per friend).
Is this possible, and if so, how?
I can use something like:
cvs.exe rdiff -D2010-03-23 -D2010-03-24 -s "ProjectName"
to get the changes which occurred on the 23rd.
But I want to get the changes that were checked in on the 23rd on a specified branch - and if I add in a -v branchv1-0-0-0 into that it tells me I can't have more than two dates/revisions in one query.
Any suggestions?
i need write a select query to find the number of rows which have an empty fulltext field but for some reason both:
select count(id) from table where field is null;
and
select count(id) from table where field = "";
don't seem to work!
what else is there?!
I have three date ranges in mysql table as follow
from 2013-09-29 to 2013-10-02
from 2013-10-14 to 2013-10-16
from 2013-10-28 to 2013-11-05
I want to count only days that occur in Month of October, for example from first range (2013-09-29 to 2013-10-02) I should get difference of two days (1st and 2nd October) , and it should ignore days from September month, Finally i want to count total days in a given month from above date ranges.
Can it be done from direct mysql query. or any short PHP logic.