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?
Search found 11 matches
- Mon Dec 21, 2009 2:56 pm
- Forum: PHP - Code
- Topic: Detecting field containing NULL in mySQL
- Replies: 4
- Views: 149
- Sun Dec 20, 2009 12:02 am
- Forum: PHP - Code
- Topic: Detecting field containing NULL in mySQL
- Replies: 4
- Views: 149
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.
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.
- Sat Dec 19, 2009 2:13 pm
- Forum: PHP - Code
- Topic: Detecting field containing NULL in mySQL
- Replies: 4
- Views: 149
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...
- 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: 629
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...
Thanks muchly...
- 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: 629
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.
- 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: 629
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 ...
- Mon Apr 28, 2008 11:55 pm
- Forum: Swift Mailer
- Topic: Delivery Receipts
- Replies: 8
- Views: 2822
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.
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.
- Mon Apr 28, 2008 7:30 pm
- Forum: Swift Mailer
- Topic: Delivery Receipts
- Replies: 8
- Views: 2822
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 ...
- Mon Apr 28, 2008 7:17 pm
- Forum: Swift Mailer
- Topic: Delivery Receipts
- Replies: 8
- Views: 2822
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...
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...
- Mon Apr 28, 2008 6:33 pm
- Forum: Swift Mailer
- Topic: Delivery Receipts
- Replies: 8
- Views: 2822
Re: Delivery Receipts
Does
mean that you need further information, or that you think I'm a nutter.

- Mon Apr 28, 2008 5:17 pm
- Forum: Swift Mailer
- Topic: Delivery Receipts
- Replies: 8
- Views: 2822
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...
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...