Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.
Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.
Hello,
I have tried to use mysql fulltext search in my intranet. I wanted to use it to search in multiple tables, and get the independant results depending on tables in the result page.
This is what i did for searching.
$query = "
SELECT *
FROM testtable t1, testtable2 t2, testtable3 t3
WHERE match(t1.firstName,…
I have been working on sql server and front end coding and have usually faced problem formulating queries.
I do understand most of the concepts of sql that are needed in formulating queries but whenever some new functionality comes into the picture that can be dont using sql query, i do usually fails resolving them.
I am very…
Weird error and this is driving me crazy all the day. To me it seems a bug because there are no positional parameters in my query. Here is the method:
public function getAll(User $user, DateTime $start = null, DateTime $end = null)
{
$params = array('user_id' => $user->getId());
$rsm = new…
Hello every one,
I'm using PHP with MYSQL database as both are open source and easy to use.
I'm getting problem when I execute insert and/or update of millions of row one after another
while this operation perform I got the MYSQL error that:
'max_user_connections' active connections
which is the…
Finally! SQL CE 3.5 now supports the ‘TOP’ keyword. However, there is a trick to this: you must surround the number with parenthesis. For example, in regular T-SQL you would write SELECT TOP N [col] FROM [table] However, in SQL CE 3.5 you must write SELECT TOP (N) [col] FROM [table]
I'm using ant 1.6.2... I want to supply parameters to StripLineBreaks (essentially, I want to remove any \r in the text, but not \n.
So, I have tried
Using the above strips out all letter "r" (for example, "jar" becomes "ja")
I have tried "\r", "\\r", and "\\r"
I…
Trying to Interop a functionality from the Outside In API from Oracle.
Have the following function:
SCCERR EXOpenExport {VTHDOC hDoc, VTDWORD dwOutputId, VTDWORD dwSpecType,
VTLPVOID pSpec, VTDWORD dwFlags, VTSYSPARAM dwReserved, VTLPVOID pCallbackFunc,
VTSYSPARAM dwCallbackData, VTLPHEXPORT…
Hi all,
I want to use parameter for query like this :
SELECT * FROM MATABLE
WHERE MT_ID IN (368134, 181956)
so I think about this
SELECT * FROM MATABLE
WHERE MT_ID IN (:MYPARAM)
but it doesn't work...
Is there a way to do this ?
I actually use IBX and Firebird 2.1
I don't know how…
I have a routing setting in my global.asax file:
routes.MapPageRoute("video-browse", "video/{id}/{title}/", "~/routeVideo.aspx");
My routeVideo.aspx page has caching setting:
<%@ OutputCache Duration="10" Location="ServerAndClient" VaryByParam="id" %>
But when I request…
Is there a way to define a function in PHP that lets you define a variable amount of parameters?
in the language I am more familiar with it is like so:
function myFunction(...rest){ /* rest == array of params */ return rest.length; }
myFunction("foo","bar"); // returns 2;
…
In jquery DataTables it is possible to add server parameters through the method fnServerData or fnServerParams :
$("#myTable").dataTable({
"bServerSide": true,
"sAjaxSource": contextApp,
"fnServerParams" : function(aoData){
aoData.push("name":"paramName",…
I have been currently researching Google and their approach to marketing the Android OS. Primarily using an open source technique with the Open Hand Alliance and out souring through third-party developers.
I'm now keen to investigate their approach using various…
Hi everyone,
I have an C# form application that use an access database.
This application works perfectly in debug and release. It works on all version of Windows.
But it crash on one computer with Windows 7.
The message I got is:
…
What do I do, I need to fetch data from 3 tables in mysql, here is my current query. All of the tables contain the IDNO which has 03A45 number. But this query isnt returning any results:
SELECT *
FROM father, mother, parents
…
There is a website that I am assisting with which, when you do a DNS look up on Who.is, returns a Website Status of "inactive". I also noticed the server type is incorrectly reported.
This is not a website I generally use for…
Hi there,
I know that is it possible to create a View with Parameters at MSSQL, does anyone knows if I can achieve something similar with a DB2 database?
I have a more complicated query which includes a user number which I…
RDS uses the same set of parameters for all instance sizes and they don't seem to be that far from defaults (max_packet_size being too small etc.)
Has anyone looked at them and reviewed them for how sensible they are,…
I write a little command-line-application in Java. This application should work with a mix of parameters and commands, similar to svn.
Examples
app url command1
app url command2 --parameter2 -x
app url command1…
How do you setup a navigation rule based on a function with parameters in SEAM ?
For example
<page view-id="/firstPage.xhtml" back="enabled">
<navigation from-action="#{actionBean.fetchItem(int…
I have trouble naming the COUNT() column from SQL queries and will swap between various variants
_Count
[Count] (sql, or "count" or backticks for MySQL etc)
C
Cnt
CountSomething (where "something" is the…
I try to use more of the parameters but could not get it working with
<g:helpBalloon title="foo" content="bla" useEvent="['mouseover']" />
should result in
<script type="text/javascript"> new…