in
All Tags » Stored Procedures (RSS)

Browse by Tags

  • Stored Procedures - SPs wrapper

    I need to run some Stored Procedures and I've read that SP. storedprocedurename ( params ).getdataset() returns a Dataset. Excellent!!! Now why when I write that line VS tells me that SPs in not defined??? I'm using VB.net 2.0 and at the top of the file I have Imports Subsonic . What am I missing...
    Posted to Installation and Setup (Forum) by NestorLeone on 04-21-2008

  • Maintaining Historical Data

    Is there an easy / eligant interface or method for retaining historical data when a record / object is updated? In the majority or apps I build, most of the tables are updated using a series stored procesures. These procs accomplish the following: Protecting against concurency violations; Storing a copy...
    Posted to Getting Started (Forum) by SkydiverFL on 04-13-2008

  • Re: Reply: InputOutput SP Parameter Direction

    I am having this problem with SS 2.0 and figured it was time to try SS 2.1. It still exists in 2.1 beta 2,. The shop that I am at now, uses SP OUTPUT parameters as bidrectional params and sends data in and sometimes modifies the value as an output. The current generator ignores the value being passed...
    Posted to Installation and Setup (Forum) by jbonnie on 03-27-2008

  • Re: Reply: Stored Procedures in MySql

    Holy Mackeral! Is this documented somewhere else? This was a major player in MY frustration tonight... Was this mentioned somewhere that I previously overlooked? If not, we need to make sure that this is effectively communicated to MySQL users. Stored Procs that require paramaters are flat-out broken...
    Posted to Installation and Setup (Forum) by buxjr on 02-29-2008

  • Return a typed object from a stored procedure

    Howdy, Given I'm trying this quite late on a Friday afternoon and half the office is drinking beer, it may very well be that the answer is staring me in the face. What I'm trying to do is to run a stored procedure to check login credentials and return a profile (user) record cast to an Profile...
    Posted to Code Discussion (Forum) by Nath on 02-08-2008

  • MVC, Stored Procedures and Typed Collection

    Howdy all subsonic lovers! Got a question thats been bugging me and just aren't sure wether i can do what i'm trying to do, or if i should be looking at the 2.1 version. I'm using the MVC templates and have set the stored proc's to be incorporated into each class (eg. Vote, Profile, CMSUser...
    Posted to Code Discussion (Forum) by Nath on 02-06-2008

  • Convert stored procedure heavily used application to distributed and scalable system

    Hi all, I am new-bie to SubSonic.Currently I am working in a team trying to convert a 3 tiers, stored procedure heavily used application to distributed and scalable system. Please commend my plan and advise me if you know better solutions. Current system: 3 tiers: presentation tier (ASP.net 2.0) call...
    Posted to Code Discussion (Forum) by delrinachang on 02-04-2008

  • Re: SPs & ExecuteScalar

    hi dear if you r getting -1 value then it means that you r getting NULL value from SP
    Posted to Installation and Setup (Forum) by snehal_ieng@yahoo.com on 01-06-2008

  • Re: Reply: InputOutput SP Parameter Direction

    [quote user="blankers"]The specific problem is that when I pass in a value for a parameter in my C# code, using the SubSonic-generated SP wrappers, to an SP with the parameter in question declared as an OUTPUT parameter in sql, the value I pass in is lost. The first parameter in my SP is declared...
    Posted to Installation and Setup (Forum) by ranomore on 12-18-2007
Page 1 of 1 (9 items)