My Stored
*************** *************** *************** ************
CREATE PROCEDURE st_seconddegree
@fromwhom numeric(18), @towhom numeric(18) AS
if not exists (select 1 from crosstable where (fromwhom=@from whom and
towhom=@towhom ) or (fromwhom=@towh om and towhom=@fromwho m))
Begin
create table #pele1
(xuserid numeric(18),xar kid numeric (18)
)
insert into #pele1 SELECT
xuserid = CASE WHEN fromwhom <> @fromwhom then @fromwhom ELSE fromwhom
END,
xarkid = CASE WHEN fromwhom = @fromwhom then towhom ELSE fromwhom END
FROM crosstable
where fromwhom=@fromw hom or towhom=@fromwho m
create table #pele2
(xuserid numeric(18),xar kid numeric (18)
)
insert into #pele2
SELECT
xuserid = CASE WHEN fromwhom <> @towhom then @towhom ELSE fromwhom END,
xarkid = CASE WHEN fromwhom = @towhom then towhom ELSE fromwhom END
FROM crosstable
where fromwhom=@towho m or towhom=@towhom
select #pele1.xarkid as xarkid from #pele1 INNER JOIN #pele2 ON
#pele1.xarkid=# pele2.xarkid;
drop table #pele1
drop table #pele2
End
GO
*************** *************** *************** ************
in asp
set rs=baglantim.ex ecute ("st_seconddegr ee @fromwhom='10', @towhom='7'")
response.write rs("xarkid")
error is
ADODB.Recordset (0x800A0CC1) Item cannot
be found in the collection corresponding to the requested name or ordinal
I TRIED
exec st_seconddegree @fromwhom='10', @towhom='7' in Sql query analyser
it returns me xarkid=2
it works..
but in asp it doesnt works.. i thimk it is about temp table field name or
Drop temp table..
how can it works in asp?
*************** *************** *************** ************
CREATE PROCEDURE st_seconddegree
@fromwhom numeric(18), @towhom numeric(18) AS
if not exists (select 1 from crosstable where (fromwhom=@from whom and
towhom=@towhom ) or (fromwhom=@towh om and towhom=@fromwho m))
Begin
create table #pele1
(xuserid numeric(18),xar kid numeric (18)
)
insert into #pele1 SELECT
xuserid = CASE WHEN fromwhom <> @fromwhom then @fromwhom ELSE fromwhom
END,
xarkid = CASE WHEN fromwhom = @fromwhom then towhom ELSE fromwhom END
FROM crosstable
where fromwhom=@fromw hom or towhom=@fromwho m
create table #pele2
(xuserid numeric(18),xar kid numeric (18)
)
insert into #pele2
SELECT
xuserid = CASE WHEN fromwhom <> @towhom then @towhom ELSE fromwhom END,
xarkid = CASE WHEN fromwhom = @towhom then towhom ELSE fromwhom END
FROM crosstable
where fromwhom=@towho m or towhom=@towhom
select #pele1.xarkid as xarkid from #pele1 INNER JOIN #pele2 ON
#pele1.xarkid=# pele2.xarkid;
drop table #pele1
drop table #pele2
End
GO
*************** *************** *************** ************
in asp
set rs=baglantim.ex ecute ("st_seconddegr ee @fromwhom='10', @towhom='7'")
response.write rs("xarkid")
error is
ADODB.Recordset (0x800A0CC1) Item cannot
be found in the collection corresponding to the requested name or ordinal
I TRIED
exec st_seconddegree @fromwhom='10', @towhom='7' in Sql query analyser
it returns me xarkid=2
it works..
but in asp it doesnt works.. i thimk it is about temp table field name or
Drop temp table..
how can it works in asp?
Comment