William Curry wrote:
$qry1 = "SELECT *,CONVERT(Char(24),CALL_ENTRY_DATE,101) as MYDATE
from PcarsCallComplete
where Location_address = " .$Location2. " order by CALL_NO";
This method usually works well for me for debugging purposes:
immediately prior to query, echo it to see exactly what you
Please include the list when replying.
William Curry wrote:
Thanx for the quick reply, I left out the concats in my sample here is
the exact statement:
$qry1 = "SELECT *,CONVERT(Char(24),CALL_ENTRY_DATE,101) as MYDATE from
PcarsCallComplete
where Location_address = " .$Location2. " order by
William Curry wrote:
I have issues I cant understand passing a sql statement to mssql, most
of which work fine, however in some cases, a statement like
"SELECT * FROM tblX where value like 'variable%' " will return 0
records when I know they are there. No errors, just 0 records.
When I echo th
