All pastes #804642 Raw Edit

Something

public text v1 · immutable
·published 2007-12-03 17:06 UTC
rendered paste body
select *,TOLLFREENUMBERS.ALIASENGLISH as TFNAE, 
TERMINATINGNUMBERS.ALIASENGLISH as TFTAE 
FROM CPMTABLE,TOLLFREENUMBERS, TERMINATINGNUMBERS 
where ( CPMTABLE.TOLLFREENUMBER='800xxxxxxx' ) 
and CPMTABLE.TOLLFREENUMBER = TOLLFREENUMBERS.TOLLFREENUMBER 
and CPMTABLE.TERMINATINGNUMBER = TERMINATINGNUMBERS.TERMINATINGNUMBER 
and CALLDATETIME >= dbo.DayTime(GETUTCDATE(),11,10,45, 0)

php error (but it works in sql console)
select *,TOLLFREENUMBERS.ALIASENGLISH as TFNAE, TERMINATINGNUMBERS.ALIASENGLISH as TFTAE FROM CPMTABLE,TOLLFREENUMBERS, TERMINATINGNUMBERS where ( CPMTABLE.TOLLFREENUMBER='800xxxxxxx' ) and CPMTABLE.TOLLFREENUMBER = TOLLFREENUMBERS.TOLLFREENUMBER and CPMTABLE.TERMINATINGNUMBER = TERMINATINGNUMBERS.TERMINATINGNUMBER and CALLDATETIME >= dbo.DayTime(GETUTCDATE(),11,10,45, 0)
Warning: mssql_query() [function.mssql-query]: message: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.DayTime", or the name is ambiguous. (severity 16)