Search found 11 matches

by gmckay
Mon Dec 21, 2009 2:56 pm
Forum: PHP - Code
Topic: Detecting field containing NULL in mySQL
Replies: 4
Views: 148

Re: Detecting field containing NULL in mySQL

I STILL have rows where mySQL shows that the field contains NULL, however mysql_fetch_assoc() returns an array with the field containing "string: "0".

How can I retrieve the field and detect that it contains NULL?
by gmckay
Sun Dec 20, 2009 12:02 am
Forum: PHP - Code
Topic: Detecting field containing NULL in mySQL
Replies: 4
Views: 148

Re: Detecting field containing NULL in mySQL

When I browse the table using phpMyAdmin is shows the value as NULL.

When I run SQL "WHERE `offer_limit_remaining` is NULL" mySQL returns all the rows.

So I think the field is NULL despite not defaulting to NULL.
by gmckay
Sat Dec 19, 2009 2:13 pm
Forum: PHP - Code
Topic: Detecting field containing NULL in mySQL
Replies: 4
Views: 148

Detecting field containing NULL in mySQL

I have a table with a field defined as "`offer_limit_remaining` INT( 5 ) NULL". I have rows where mySQL shows that the field contains NULL, however mysql_fetch_assoc() returns an array with the field containing "string: "0". Am I doing something wrong? How can I retrieve the...
by gmckay
Mon Oct 19, 2009 4:46 pm
Forum: PHP - Code
Topic: Processing BIT data "\x0\x0\x0\x0\x0\x0\x0\x5"
Replies: 4
Views: 628

Re: Processing BIT data "\x0\x0\x0\x0\x0\x0\x0\x5"

Coding "SELECT *, bin(fieldName) as flags .." worked well. I'll just propagate that wherever needed.
Thanks muchly...
by gmckay
Mon Oct 19, 2009 3:52 pm
Forum: PHP - Code
Topic: Processing BIT data "\x0\x0\x0\x0\x0\x0\x0\x5"
Replies: 4
Views: 628

Re: Processing BIT data "\x0\x0\x0\x0\x0\x0\x0\x5"

Thanks, I'll have a go at that, but as that will require me to change all the SELECT statements from "SELECT *" to "SELECT bin(fieldName), fieldName2, ...." I was really looking for a post-select coding solution.
by gmckay
Mon Oct 19, 2009 5:42 am
Forum: PHP - Code
Topic: Processing BIT data "\x0\x0\x0\x0\x0\x0\x0\x5"
Replies: 4
Views: 628

Processing BIT data "\x0\x0\x0\x0\x0\x0\x0\x5"

I have setup a BIT(64) field in MYSQL. I can populate this field OK converting the flags "0000000000000000000000000000000000000000000000000000000000000101", but when the data is returned in a query it is represented as "\x0\x0\x0\x0\x0\x0\x0\x5" and I can't find any hints online ...
by gmckay
Mon Apr 28, 2008 11:55 pm
Forum: Swift Mailer
Topic: Delivery Receipts
Replies: 8
Views: 2820

Re: Delivery Receipts

Thanks,
I guess I'll have to give up the idea of using Swift-Mailer and revert to finding some php SMTP code to hack for my own purposes.
by gmckay
Mon Apr 28, 2008 7:30 pm
Forum: Swift Mailer
Topic: Delivery Receipts
Replies: 8
Views: 2820

Re: Delivery Receipts

http://www.sendmail.org/~ca/email/dsn.html defines a delivery receipt as; delivery means that the e-mail has been delivered by an MTA to a recipient's mailbox; The php mail() function allows this to be coded as "Return-Receipt-To: aa@aa.com" but the reply-to address ends up being modified ...
by gmckay
Mon Apr 28, 2008 7:17 pm
Forum: Swift Mailer
Topic: Delivery Receipts
Replies: 8
Views: 2820

Re: Delivery Receipts

Ummm....

I'll try to be more specific then.

When I send an email using Outlook I can request both a delivery receipt, and a read receipt. How do I do that with Swift Mailer? Read receipts are covered by the documentation and the forums, but delivery receipt examples are not to be found...
by gmckay
Mon Apr 28, 2008 6:33 pm
Forum: Swift Mailer
Topic: Delivery Receipts
Replies: 8
Views: 2820

Re: Delivery Receipts

Does :?: mean that you need further information, or that you think I'm a nutter.

:?:
by gmckay
Mon Apr 28, 2008 5:17 pm
Forum: Swift Mailer
Topic: Delivery Receipts
Replies: 8
Views: 2820

Delivery Receipts

My customer wants a delivery receipt (not a read receipt).

I am able to code for a read-receipt using;
$message->requestReadReceipt($email);
and I am able to code the return-path;
$message->setReturnPath($email);
but I can find no reference to delivery receipts...

Please advise...