You searched for the word(s): userid:422080

More Search Options

RSS Available

• Re: Challenged by a where

  Is this what you are after? -- Result -- Client 1 - 5 payments - 500$ Client 2 - 3 payments - 300$ Client 3 - 0 payments - 0$ Client 4 - 1 payment - 100$ or this ? -- Result -- Client 1 - 5 payments - 300$ Client 2 - 3 payments - 300$ Client 4 - 1 payment - 100$ (Client 3 dosent show up on the list since he made no payments)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by pafo on 5/12/2009

• Re: select one row values into multiple rows

  Well your solutions goes against "First normal form" (1NF), http://en.wikipedia.org/wiki/1NF 4. Every row-and-column intersection contains exactly one value from the applicable domain (and nothing else). Is there a possibility that you can make a second table where you store the NAME's? Then link them together with a join? The first table would look something like: (PK) ID Column - Group_Name and the second table would look something like: (PK) ID Column - (FK) ID Column of table 1

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by pafo on 5/12/2009

• trigger error handling?

  Hello, Ive been trying to figure out how i should handle trigger errors. My aspx page calls a stored procedure (X), X validates a few things and then tries to insert the data into the database. Trigger (Y) is a INSTEAD OF INSERT trigger on the table that X tries to add data. Y makes sure that the business rules are in place, if they are, Y inserts the data into the table. Works great. But if Y detects an error, how can Y then notify X with the error code ? My aspx page awaits a response code from

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by pafo on 5/12/2009

• Re: Simple webservice question

  Thanks, got it working.

  Posted to XML Web Services (Forum) by pafo on 3/8/2009

• Re: Simple webservice question

  Almost there.... then: "Could not find endpoint element with name 'OnyxiaIT_WebserviceSoap' and contract 'OnyxiaIT_Webservice_Reference.OnyxiaIT_WebserviceSoap' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this name could be found in the client element." Was looking around some on the web, but could not pinpoint the reason for this error. Here is the app

  Posted to XML Web Services (Forum) by pafo on 3/8/2009

• Re: Simple webservice question

  Nevermind ;-) , sometimes it help by doing something else for awhile.

  Posted to XML Web Services (Forum) by pafo on 3/7/2009

• Re: Simple webservice question

  Test what? I dont have a web.config and i cant figure out how to remove that part from the calling alternative to tell the program to use System.Configuration to pull the data from the web.config file. I cannot seem to find how to override, public WebserviceSoapClient( string endpointConfigurationName) : base (endpointConfigurationName) { } with just an url.

  Posted to XML Web Services (Forum) by pafo on 3/7/2009

• Simple webservice question

  I cant seem to find how to call my webservice. I have created a webservice and uploaded. Now i have a custom control (.dll) and in this custom control i have added a "Service Reference" to my webservice, visual studio then created a Proxy for me (like the wdsl). But how do i actually call the webservice? myRef. WebserviceSoapClient test = new myRef. WebserviceSoapClient ( "endpointConfigurationName" ); The problem is that my custom control dont have a web.config file to pull the

  Posted to XML Web Services (Forum) by pafo on 3/7/2009

• Re: ViewState between 2 server controls?

  Well its like this. The system is pretty old and consists of several subsystems, each of those are using its own login logic. Now we are adding new content to a new structure (eventually everything will be converted to this new structure) but at the moment its devided into 5 diffrent parts. The user goes to his login page and validates himself, now he runs the old system along with some new pages created in the new structure. The pages in the new structure have new componens (like forums etc), they

  Posted to State Management (Forum) by pafo on 3/5/2009

• Re: ViewState between 2 server controls?

  No the first control dosent have an interface, it just processes data. This data is suppose then to be local on just this page. The first control dosent even have to exists if the site allows non-logged in users to access it.

  Posted to State Management (Forum) by pafo on 3/4/2009