Great ! thank you !

Have you “view sourced” the email in your client to see if it is properly formatted HTML?

Lastly, remember that some email clients block image downloads from remote servers on email reads... have you ensured that this isn't the cause of the issue?

It looks like you and folks at qcubed have thought through some stuff as well, I'd love any input (either higher level suggestions or even lower level code contributions, if you have them) that you'd be willing to provide.

I know that you say for some of those items you need some “seed” ideas/input from me -- I think the best way to go about it (as is the best way I seem to be operating at the moment) is, are there specific questions you have about any of those items (e.g. roadmap, QPM vs. GitHub vs. whatever documentation, etc.) that can help you to understand it better... and then you could write or you could delegate someone to structure and write documentation (e.g. up in the wiki) in a format that is clear and makes sense to the average user?

let me know if that makes sense...

Qcodo plays very nicely with ZF, and in fact, there is already a QPM package which allows you to one-line install ZF into your Qcodo application.

See http://www.qcodo.com/qpm/package.php/zend_framework for more info

I am hoping to get this pushed to stable ASAP so please post with any issues.

Resource
IdResource
Name

Keyword
IdKeyword
Name

There is a many-to-many association table connecting the two.

Problem:
The keywords are used as filters. A user can select any number of keywords and it should filter the results such that each resource has ALL of the keywords selected associated (and any others not selected - the important point is that all that are selected are associated).

I can implement in PHP manipulating arrays ... but that's really slow when dealing with thousands of resources.

I essentially want to do:
QQ::In_All(QQN::Resource()->Keyword->Keyword->IdKeyword, $arrSelectedKeywords) ... something like an SQL subquery with the ALL operator such that it will “return TRUE if the comparison is TRUE for ALL of the values in the column that the subquery returns.”

Any ideas? It's probably really simple - I'm just a bit perplexed.

Thanks,
Andrew

or

- Make sure your records all have the same lenght by adding leading zeros. You can run an update query to add leading zeros so that it gets sorted properly.

Does that make sense?

-patrick

My problem for example, how can I get the following order?

35
47
98
102
210

from

102
35
98
210
47

with QQ::OrderBy() because QQ::OrderBy accept only QQNode as parameter, and QueryBuilder generated SQL contains " ORDER BY `t0`.`field` " but what I need is: " ORDER BY `t0`.`field`+0 “

How to tell QQ::OrderBy to add '+0' to field name.

Edit: My filed type is varchar.

Attila

What can I do to remedy this?

Thanks.  Pretty urgent, our application does send out email and notification as essential to the functionality.

You should first start by reading the getting started guide and follow the instruction. Then read the _README.txt file in the “cli” directory to find out how to code genarate. I'll be please to answer any specific question if you get stuck in the process.

-Patrick

Please start with the example sites where you will find an example of the QQ:Orderby clause. Don't forget to look at the source code by clicking “View source” in the top right corner. Let me know if you have any questions after.

-Patrick

You helped me a lot.

You were right was because the control is a QLinkButton.

Case Resolved.

With SQL syntax which worked for me:

SELECT * FROM table ORDER BY table.field+0;

Can anyone help me to implement this with QQ:Orderby()?

Thank you.

For some reason when I send HTML formatted emails via Qcodo's QEmailMessage and QEmailServer, I can't see any images.  However, when I send manually via PHP mail function.  It works just fine.  Do I need to set any additional headers or anything before sending?  Here's my code:

<?php
    include('app/includes/prepend.inc.php');
    // We want to define our email SMTP server (it defaults to "localhost")
    // This would typically be done in prepend.inc, and its value should probably be a constant
    // that is defined in _configuration.inc
    //QEmailServer::$SmtpServer = 'mx.acme.com';

    // Create a new message
    // Note that you can list multiple addresses and that Qcodo supports Bcc and Cc
    $objMessage = new QEmailMessage();
    $objMessage->From = 'ACME Reporting Service <reporting@acme.com>';
    $objMessage->To = 'Mr. Tester <myemail@gmail.com>';
    //$objMessage->Bcc = 'audit-system@acme.com';
    $objMessage->Subject = 'Report for ' . QDateTime::NowToString(QDateTime::FormatDisplayDate);

    // Setup Plaintext Message
    $strBody = "Dear John and Jane Doe,\r\n\r\n";
    $strBody .= "You have new reports to review.  Please go to the ACME Portal at http://portal.acme.com/ to review.\r\n\r\n";
    $strBody .= "Regards,\r\nACME Reporting Service";
    $objMessage->Body = $strBody;

    // Also setup HTML message (optional)
    $strBody = 'Dear John and Jane Doe,<br/><br/>';
    $strBody .= '<img height=131 src="http://www.p1computerparts.com/images/email_order_banner.jpg" width=529 />';    
    $strBody .= '<b>You have new reports to review.</b>  Please go to the <a href="http://portal.acme.com/">ACME Portal</a> to review.<br/><br/>';
    $strBody .= 'Regards,<br/><b>ACME Reporting Service</b><br />';
    $objMessage->HtmlBody = $strBody;

    // Add random/custom email headers
    $objMessage->SetHeader('x-application', 'ACME Reporting Service v1.2a');

    // Send the Message (Commented out for obvious reasons)
    QEmailServer::Send($objMessage);
    
    // THIS WORKS
    //$headers  = 'MIME-Version: 1.0' . "\r\n";
    //$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    //mail('myemail@gmail.com', 'Hello', $strBody, $headers);


    // Note that you can also shortcut the Send command to one line for simple messages (similar to PHP's mail())
    $strBody = "Dear John and Jane Doe,\r\n\r\n";
    $strBody .= "You have new reports to review.  Please go to the ACME Portal at http://portal.acme.com/ to review.\r\n\r\n";
    $strBody .= "Regards,\r\nACME Reporting Service";
//    QEmailServer::Send(new QEmailMessage('reporting@acme.com', 'jdoe@acme.com', 'Alerts Received!', $strBody));
?>
bc.

Probably you need to add QTeminateAction to the control something like this:

$this->btnSubmit->AddAction(new QClickEvent(), new QAjaxAction('btnSubmit_Click'));
$this->btnSubmit->AddAction(new QClickEvent(), new QTerminateAction());

or edit the control to make html it renders doesn't containt the #.

Hope it helps if not please post some code.