beetlebailey
Programmer
I am using FrontPage 2002 to query data from MSSql server 2000 by inserting database results in my web page.
This query works in both FrontPage and Query Analyzer but returns a value without comma seperators like: 1234567
select count(partno) as records from testers.
This query works in Query Analyzer and returns a value with comma seperators like: 1,234,567 but does not work in FrontPage.
declare @i money
set @i = (select count(partno) from testers)
select left(convert(varchar(20),@i,1),len(convert(varchar(20),@i,1))-3) as records
Any ideas on the problem ? Thank You.
This query works in both FrontPage and Query Analyzer but returns a value without comma seperators like: 1234567
select count(partno) as records from testers.
This query works in Query Analyzer and returns a value with comma seperators like: 1,234,567 but does not work in FrontPage.
declare @i money
set @i = (select count(partno) from testers)
select left(convert(varchar(20),@i,1),len(convert(varchar(20),@i,1))-3) as records
Any ideas on the problem ? Thank You.