Thanks for your quick response. The "$_SESSION['WADA_Insert_tblVendors']" appears in the detail page of the WDA set, it appears as a session variable but is not able to filter a record-set.
On the detail page I need to use a look-up table which, depending on the date will give a price. The query below should return a result only if the created date is before '2010-03-30 23:56:16! It returns a results for records later than the 30th.
I Also tried to edit the record-set but the filtering on "dateCreated". It did not work, it returned a result even for records with a date later than tblVendors.dateCreated = '2010-03-30 23:56:16'. In SQL this works but not on the page. WADA is doing something else altogether.
"SELECT label.descr_lbl AS electric
, vendorType.descr_lbl AS vend_type
, non_pro.descr_lbl AS Non_Profit
, vendorType.pre30_ven AS Pre30
, label.value_lbl AS Elec_qty
, tblVendors.*
FROM (((tblVendors
LEFT JOIN label AS non_pro ON non_pro.value_lbl=tblVendors.nonProfit)
LEFT JOIN vendorType ON vendorType.value_ven=tblVendors.vendorType)
LEFT JOIN label ON label.value_lbl=tblVendors.electric_ven)
WHERE label.group_lbl=4
AND non_pro.group_lbl=4
AND vendorType.group_ven=1
AND tblVendors.dateCreated = '2010-03-30 23:56:16'
AND tblVendors.ID = %s OR ( -1= %s AND ID= %s)",