in reply to RE: RE: (Ovid) Re: DBI not letting bind varibles in if you use a varible for the statement.
in thread DBI not letting bind varibles in if you use a varible for the statement.

here's the SQL, by popular demand: 
SELECT SC_BASE_APPT.CALL_ID, SC_BASE_APPT.STATUS 
FROM SC_BASE_APPT , SC_BASE_INFO 
WHERE ( (SC_BASE_INFO.TRANS_ID = SC_BASE_APPT.TRANS_ID) )
AND SC_BASE_APPT.SC_ID = ? AND
((to_number(SC_BASE_INFO.AP_START) <= ? AND to_number(SC_BASE_INFO.AP_
+END) >= ?)
OR
(to_number(SC_BASE_INFO.AP_START) <= ? AND to_number(SC_BASE_INFO.AP_E
+ND) >= ?))

[download]
  • Comment on RE: RE: RE: (Ovid) Re: DBI not letting bind varibles in if you use a varible for the statement.
  • Download Code

In Section Seekers of Perl Wisdom