K
ksujayc
I created a query that works in the MS SQL Server 2000 analyzer, and
when I put it into the DRW in Frontpage 2002, the query verifies but
the page doesn't return any results. I'm fairly new at this and
learning as I go, so is there something I'm missing?
Here's the query:
declare @equip table (eqnum varchar (25), location varchar (50))
declare @cssht table (mobile varchar (10), timestamp datetime)
declare @ckdate varchar (12)
select @ckdate = checkdate FROM CSCHECK
insert @equip select eqnum, location from EQUIP where ud8='CS'
insert @cssht select mobile, timestamp from CSDATA where
@ckdate=CONVERT(varchar (12),timestamp, 101)
select * from @equip LEFT JOIN @cssht ON eqnum like (mobile + '%')
order by location, mobile
when I put it into the DRW in Frontpage 2002, the query verifies but
the page doesn't return any results. I'm fairly new at this and
learning as I go, so is there something I'm missing?
Here's the query:
declare @equip table (eqnum varchar (25), location varchar (50))
declare @cssht table (mobile varchar (10), timestamp datetime)
declare @ckdate varchar (12)
select @ckdate = checkdate FROM CSCHECK
insert @equip select eqnum, location from EQUIP where ud8='CS'
insert @cssht select mobile, timestamp from CSDATA where
@ckdate=CONVERT(varchar (12),timestamp, 101)
select * from @equip LEFT JOIN @cssht ON eqnum like (mobile + '%')
order by location, mobile