[Query Preformance]

Here you go:

 

id,select_type,table,type,possible_keys,key,key_len,ref,rows,Extra

1,SIMPLE,xfiles,ALL,,,,,3653,

1,SIMPLE,user_profiles,ALL,,,,,1226,

1,SIMPLE,licenses,eq_ref,PRIMARY,PRIMARY,4,cb_overall.xfiles.license_id,1,

1,SIMPLE,asc_records,eq_ref,PRIMARY,PRIMARY,4,cb_overall.xfiles.asc_id,1,Using where

 

[Query Preformance]

So what could i do to speed this query up?

[Query Preformance]

thanks

[Query Preformance]

i want to pull the same data just quicker that was my question to begin with only asked if it could be done with a union

[Query Preformance]

what i am asking is can this be turned into a union statement that will make it process faster?

[Query Preformance]

Basically this take 15 secs to run no indexes

[Query Preformance]

Anyway I can speed this up possible with a UNION, i tried but seem to be missing something?

 

SELECT 
xfiles.id, xfiles.user_id, xfiles.action, xfiles.other_action, xfiles.document, xfiles.start_date, xfiles.end_date, user_profiles.fname, user_profiles.mname, user_profiles.lname, licenses.number, licenses.state, asc_records.fname, asc_records.mname, asc_records.lname, asc_records.st_abbr, asc_records.lic_number, asc_records.status 
FROM xfiles 
LEFT JOIN user_profiles ON xfiles.user_id = user_profiles.user_id LEFT JOIN licenses ON xfiles.user_id = licenses.user_id AND xfiles.license_id = licenses.id
LEFT JOIN asc_records ON xfiles.asc_id = asc_records.id 
WHERE xfiles.deleted=0 AND licenses.state = 'FL' OR asc_records.st_abbr = 'FL'

[project management]

What is a good open source project management software?

[Parsing XML]

How can I access the id part?

 

<EXM id="1233456"><products>...</products></EXM>

[PHP to fill pdf form]

Any suggestions for using to php to take html form data and fill a pdf form? Anything for cakephp?

 

Thanks

[Avg of date]

I would like to get the avg age based off the dob each user enters which I have stored in the table as mm/dd/yy. I have the above query in place however it returns either 51 or 50.

[Avg of date]

I am trying to get the average age based off the date of birth (mm/dd/yyyy) this is what I have but keep getting 51. Sure this is correct any suggestions?

 

SELECT FLOOR(AVG(TO_DAYS(NOW())-TO_DAYS(CONCAT(SUBSTR(user_profiles.dob, 7,4),'-',SUBSTR(user_profiles.dob, 1, 2),'-',SUBSTR(user_profiles.dob, 4, 2))))/365.242199) FROM user_profiles WHERE user_profiles.dob !=''

[subdomain]

How can I do an ajax call to one subdomain to another like sub1.domain.com to sub2.domain.com?

[SOAP array help]

I need to have have my request look like this:

<filters>

  <FilterCondition>

    <FieldName>Lname</FieldName>

    <Operator>Equals</Operator>

    <Operands>

    <xsd:string>Smith</xsd:string>

    </Operands>

  </FilterCondition>

  <FilterCondition>

    <FieldName>Fname</FieldName>

    <Operator>Equals</Operator>

    <Operands>

    <xsd:string>Robert</xsd:string>

    </Operands>

  </FilterCondition>

  </filters>

 

This is what i have:

 

<filters xsi:type="FilterCondition">

  <BOGUS>

    <FieldName>Lname</FieldName>

    <Operator>Equals</Operator>

    <Operands>

    <xsd:string>Smith</xsd:string>

    </Operands>

  </BOGUS>

  <BOGUS>

    <FieldName>Fname</FieldName>

    <Operator>Equals</Operator>

    <Operands>

    <xsd:string>Robert</xsd:string>

    </Operands>

  </BOGUS>

  </filters>

 

Using this code:

 

class FilterCondition {

    function FilterCondition($s, $i, $f) {
        $this->FieldName = $s;
        $this->Operator = $i;
        $this->Operands[] = $f;
    }

}

$filter1 = new FilterCondition('Lname', 'Equals', 'Smith');
$filter2 = new FilterCondition('Fname', 'Equals', 'Robert');
$test = new SoapVar(array($filter1, $filter2), SOAP_ENC_OBJECT, 'FilterCondition');

new SoapParam($test, "filters")

 

Any ideas?

 

[SOAP Help]

When I run this it works fine, not sure what I am doing that is wrong:

 

$asc = new SoapClient('https://www.asc.gov/wsvc/ASCQuerySvc.asmx?WSDL');
var_dump($asc->GetQueryableFields());

 

This returns the Queryable Fields the RunQuery gives me the error

[SOAP Help]

updated the code and still same error, i am banging my head what am i doing wrong:

 

error_reporting(E_ALL);
ini_set("display_errors", -1);

class FilterCondition {
    public $FieldName;
    public $Operator;
    public $Operands;
}

$oFilter1 = new FilterCondition;
$oFilter1 -> FieldName = 'Lname';
$oFilter1 -> Operator = 'Equals';
$oFilter1 -> Operands = 'Smith';

$oFilter2 = new FilterCondition;
$oFilter2 -> FieldName = 'Fname';
$oFilter2 -> Operator = 'Equals';
$oFilter2 -> Operands = 'Bob';

$asc = new SoapClient('https://www.asc.gov/wsvc/ASCQuerySvc.asmx?WSDL');
$filters = (object)array($oFilter1, $oFilter2);
$fields = array('St_Abbr','Lic_Number','Lname','Fname','Mname','Name_Suffix','Eff_Date','Exp_Date','Lic_Type','Status','Company','Phone','Street','City','State','County_Code','Zip','Edi_Capability','Action_Code','Start_Date','End_Date');

return $asc->RunQuery(null, $fields, $filters, true, 0);

[SOAP Help]

here is my current code and error i am getting:

 

$asc = new SoapClient('https://www.asc.gov/wsvc/ASCQuerySvc.asmx?WSDL');
$fields = array('St_Abbr','Lic_Number','Lname','Fname','Mname','Name_Suffix','Eff_Date','Exp_Date','Lic_Type','Status','Company','Phone','Street','City','State','County_Code','Zip','Edi_Capability','Action_Code','Start_Date','End_Date');

$filters = array(array('FieldName'=>'Lname','Operator'=>'Equals','Operands'=>'Smith'), array('FieldName'=>'Fname','Operator'=>'Equals','Operands'=>'Bob'));

return $asc->RunQuery($fields, $filters, true, 0);

 

Fatal error: Uncaught SoapFault exception: [Client] SOAP-ERROR: Encoding: object hasn't 'showDiscipline' property in /Applications/MAMP/htdocs/asc.php:11 Stack trace: #0 [internal function]: SoapClient->__call('RunQuery', Array) #1 /Applications/MAMP/htdocs/asc.php(11): SoapClient->RunQuery(Array, Array, true, 0) #2 {main} thrown in /Applications/MAMP/htdocs/asc.php on line 11

 

[Ajax Cross domain allow]

How do you allow cross domain ajax?

[SOAP Help]

Any ideas on this?

[SOAP Help]

Fatal error: Uncaught SoapFault exception: [soap:Server] System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object. at ASCv3WS.Utils.AreOutputFieldsValid(DataTable dt, String[] outputFields, Boolean& ShowDiscipline, Boolean isAuthenticated) at ASCv3WS.Utils.ConstructQuery(String[] outputFields, FilterCondition[] filters, Boolean& showDiscipline, Int32 maxResults, Boolean isAuthenticated, Boolean& bIsLicenseNumberSpecified, Boolean& bIsSt_AbbrSpecified, Boolean& bIsLicTypeSpecified) at ASCv3WS.Utils.ExecuteQuery(String[] outputFields, FilterCondition[] filters, Boolean showDiscipline, Int32 maxResults, Boolean isAuthenticated) at ASCv3WS.ASCQuerySvc.RunQuery(String[] outputFields, FilterCondition[] filters, Boolean showDiscipline, Int32 maxResults) --- End of inner exception stack trace --- in /Applications/MAMP/htdocs/asc.php:13 Stack trace: #0 [internal function]: SoapClient->__call('RunQuery', in /Applications/MAMP/htdocs/asc.php on line 13

[SOAP Help]

This doesn't seem to work any suggestions?

$asc = new SoapClient('https://www.asc.gov/wsvc/ASCQuerySvc.asmx?WSDL');
$fields = array('St_Abbr','Lic_Number','Lname','Fname','Mname','Name_Suffix','Eff_Date','Exp_Date','Lic_Type','Status','Company','Phone','Street','City','State','County_Code','Zip','Edi_Capability','Action_Code','Start_Date','End_Date');
$filters = array(array('FieldName'=>'Lname','Operator'=>'Equals','Operands'=>'Smith'));
print_r($asc->RunQuery(null, $fields, $filters, true, 0));

[SOAP Help]

How do i run a query I can't figure this out!

[SOAP Help]

I am trying to connect to ASC web service to do queries, however nothing seems to work. This is was i started with just to test and I am getting nothing also attached are the instructions I was provided:

 

<?php
$asc = new SoapClient('https://www.asc.gov/wsvc/ASCQuerySvc.asmx');
return $asc->GetQueryableFields();
?>

 

Any help would be appreciated.

 

[attachment deleted by admin]

[PDF Searching]

Ok I have a set of PDF files that i need to be searchable. My question how do i go about doing this. Can this be achieved with php or do a need to do something else?

[Model Validate]

Cake php model will not validate when used within another controller. What is going on?