hi there, i have the following query ... <cfquery name="getOrders" datasource="#Request.app.dsn#" password="#Request.app.DBpassword#" username="#Request.app.DBusername#"> SELECT orders.order_id, orders.dCreated, orders.billing_fname, orders.billing_lname, orders.billing_country, orders.currency, orders.currency_value, orders.order_status, payment_authority.success, payment_authority.responseText FROM orders LEFT OUTER JOIN payment_authority ON orders.order_id = payment_authority.order_id WHERE order_receipt_sent = <cfqueryparam cfsqltype="cf_sql_bit" value="0"> ORDER BY orders.dCreated DESC </cfquery> i am using an outer join as i wish to display all orders whether they have an associated entry in the payment_authority table or not. with each row of the query i display the #payment_authority.responseText# value. the payment_authority.responseText data is variable. now if the row does not have any associated entries in the payment_authority table, how do i reference the [empty-string] value returned? eg. <cfif NOT len(payment_authority.responseText)> does not seem to recognise the null value.
Kind Regards Mike Little [ Designer ] Graphic Impact Ltd 40 College Hill, Ponsonby, Auckland DDI +64 9 376 7622 Fax +64 9 376 7360 _____ CAUTION: This e-mail message and accompanying data may contain information that is confidential. If you are not the intended recipient you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. All content is to be treated as confidential unless otherwise specified, and is not to be forwarded to third parties without the prior permission of the author. To do so may breach the New Zealand Privacy Act 1993. If you have received this e-mail message in error please delete it and notify me. Thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219513 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
