Re: Access Stored Procedure Problem

From: Sylvain Lafontaine ("Sylvain)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 12:00:42 -0500

For SQL-Server, it's "int", not "integer". You should also make a direct
call to the ST_GETSUBCAT stored procedure by using the command object and
its parameters collection instead of using an EXEC call. With the later,
you will have many problems with things like date, currency, string with
embedded single and double quote, GUID, etc.

You can also have a caching problem; as when you are seeing an old result
from an old request to the ASP page. You should print the time somewhere on
the page to make sure that it have been refreshed. Caching problems are
very common with ASP and ASP.NET when the expiration properties for the page
or the repertory are not correctly set on the IIS.

S. L.

"Savas Ates" <savas@indexinteractive.com> wrote in message
news:eo9GK0AHFHA.3440@TK2MSFTNGP10.phx.gbl...
> my stored procedure in access XP (I create it Succesfully)
> It returns me all records.. For example in my db there are records with
> catid=1 but no record with id=2
>
> I try my code both catid=1 and catid=2 it returns same records.. What is
> my
> fault..?
>
> CREATE PROCEDURE ST_GETSUBCAT
> (
> @CatID
>
> Integer
> )
> AS
>
> SELECT * FROM TBLCATSUB WHERE catid=@CatID
>
>
> Ssql="EXEC ST_GETSUBCAT 1"
> set rs=baglantim.execute(Ssql)
> do while not rs.eof
> Response.Write rs("id") & "<br>"
>
> rs.movenext
> loop
>

Relevant Pages

  • Re: Access Stored Procedure Problem
    ... You can also have a caching problem; as when you are seeing an old result ... from an old request to the ASP page. ... or the repertory are not correctly set on the IIS. ... > my stored procedure in access XP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access Stored Procedure Problem
    ... With all these languages, it's ... > You can also have a caching problem; as when you are seeing an old result ... > from an old request to the ASP page. ... >> my stored procedure in access XP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access Stored Procedure Problem
    ... With all these languages, it's ... > You can also have a caching problem; as when you are seeing an old result ... > from an old request to the ASP page. ... >> my stored procedure in access XP ...
    (microsoft.public.access.queries)
  • Re: returning multiple recordsets from VB to ASP
    ... stored procedure and into an intermediate VB DLL: ... more awkward to do in SQL than in VB and the stored procedure is getting ... The ASP page anways puts the data into arrays, ...
    (microsoft.public.data.ado)
  • Re: Issue with retrieving large data over web using Stored Procedu
    ... how do I go about analyzing a stored procedure with selecting ... Is there any tool in the SQL Profiler that analyze each Trace? ... "Active Server Pages error 'ASP 0113' ... This email account is my spam trap ...
    (microsoft.public.inetserver.asp.db)