How To Persist Title Of 'modal Dialog' During Postback

Oct 18, 2007

Hi,

Please give me some idea to persist or set title of modal dialog during postback.

The title of modal dialog is going lost whenever postback happen on modal dialog.

document.title is not working after postback.


Thanks,
Sandeep, India

View 1 Replies


ADVERTISEMENT

Modal Dialog Is Active Error

Mar 5, 2008

has anyone encountered the "microsoft visual studio cannot shut down because a modal dialog is active. close the active dialog and try again." error when shutting down.

i have been getting that every once and awhile, and do not see any open dialog windows that need to be closed, and i end up having to end-task on my visual studio session.

does anyone know what is causing this error and how to avoid it?

thanks a bunch!

-dk

View 5 Replies View Related

Q936971 / Modal Dialog Bug / Where To Download Fix?

Oct 18, 2007

I can't download this fix due to a block on FTM downloads and it is driving me round the bend.

Does anyone know where it is possible to get hold of the fix?

Was this included in SP1 (vs.net)?

View 1 Replies View Related

Microsoft Visual Studio Cannot Shut Down Because A Modal Dialog Is Active

Nov 17, 2006

if i get this message one more time I am going to put my fist through my monitor

View 114 Replies View Related

Microsoft Visual Studio Cannot Shut Down Because A Modal Dialog Is Active - Any Updates?

Jan 22, 2008

I installed the hotfix available at support.microsoft.com/kb/936971 and even rebooted the server, but I am still getting the error. I am working on a Windows 2003 server with SQL Server 2005 (and reporting services). I am not trying to publish any reports using SSRS. I'm just working on designs and saving them. Any help for this at this point?
Leigh

View 1 Replies View Related

SQL Modal Problem

Aug 19, 2004

Hi,
I have a form that just displays some data regarding web logs. My SQL is not too hot so i hope somebody can point me in the right direction. I have a DB table that amongst others has a server name and an execution times column. There are thousands of records each for every second within a particular week. I basically want to be able to select for each distinct server name the most popular execution time. For example if for server 'A' there are 5 records with an execution time of 0.5secs and 4 records with an execution time of 0.35secs then i want to return a record with the execution time of 0.5secs. However i want to be able to do this for every different occurrence of server name in my table. So i want to return records for server name 'B' and server name 'C' etc.

Here is the SQL i have at the moment but it only returns the most popular or most occurring execution time in the table not the most popular execution time for EVERY server name in my table. For example

Server_Name | Execution_Time
-------------------------------------
A | 0.5


<code>
SELECT DISTINCT instance, exec_time AS modal
FROM Llserverlogs
GROUP BY instance, exec_time
HAVING (COUNT(*) >= ALL
(SELECT COUNT(*)
FROM llserverlogs
GROUP BY instance, exec_time))
</code>

Hope somebody can help and thanks in davance for the help.

View 14 Replies View Related

Modal Window Is Active Cannot Shut VS

Nov 26, 2007

Hello,


While tryign to edit the XML for the rdl , i am stuck it will not allow me to edit and i have to kill the devenv process and open vs again.

I looked through some of the threads and tried apply KB 936971 Hot Fix and I am running into the following error.

The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch."


Did any one come across this. Any assistance would be greatly appreciated

Thanks,
SqlNew

View 1 Replies View Related

Persist ConnectionString

Apr 3, 2007

Hello All,



I have changed connection string property of connectionmanger at runtime and saved package.But my new connectionstring is not persisting, i am getting my old connection string after reload package .



ConnectionManager cm = package.Connections[test.ConnectionManagerID];



cm.ConnectionString = @"C:Test.csv";



app.SaveToDtsServer(package, null,

@"File SystemDupaco Load Next Best.dtsx", "CIRCLE");



How can I save new connection string?.



Please help me.





Thanks



Subin

View 1 Replies View Related

Persist Progress Tab?

Mar 24, 2006

is there a way to capture what gets written to the progress tab to a table, or is it overwritten on each execution as xml somewhere so it can be saved kind of like an odometer? the mission is to be able to audit the results of a load, or even if it doesnt turn out to be a load, then document the run.

similarly, is there a way to watch what executes to see what actually runs during a merge join transform, iow, something that exposes ssis to trace? how do i find it?

thanks

drew

View 2 Replies View Related

Errors Persist In New Database(s)

Apr 19, 2008

I am getting this error condition on two different machines, so I think it is something I am leaving out. The database is being created with a script (pasted at end of this post) executed within SQL Management Express 2005. The database shows up in the database tree but is not expandable, i.e. no plus sign. If I try to get Properties, the following sequence:Database cannot be opened due to inaccessible files or insufficient memory or disk space Error 945 TITLE: Microsoft SQL Server Management Studio Express------------------------------Cannot show requested dialog.------------------------------ADDITIONAL INFORMATION:Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------Database 'Cart1' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476==============================================I had been using "Cart" as the name, saw a reference that said not to use the same name in a new database. The new name is "Cart1"; no help.In the application,  I initially get the "cannot find the physical file, but if I Refresh the page, I get: "Cannot open database "Cart1" requested by the login. The login failed. Login failed for user 'GW20Bob'Please assist in this. I will test or answer any questions I haven't supplied.This and associated files are from Build Your Own ASP.NET 2.0 Web Site Using CSharp And VB by Doug Lowe if anyone is familiar without.Script======USE masterGOCREATE DATABASE Cart1ON (NAME=Cart,    FILENAME = 'C:APPApp_DataCart1.mdf',    SIZE=10 )GOUSE Cart1CREATE TABLE Categories (  catid VARCHAR(10)  NOT NULL,  name  VARCHAR(50)  NOT NULL,  [desc]  VARCHAR(MAX) NOT NULL,  PRIMARY KEY(catid) )  GOCREATE TABLE Products (  productid VARCHAR(10)  NOT NULL,  catid     VARCHAR(10)  NOT NULL,  name      VARCHAR(50)  NOT NULL,  shorttext VARCHAR(MAX) NOT NULL,  longtext  VARCHAR(MAX) NOT NULL,  price     MONEY        NOT NULL,  thumbnail VARCHAR(40)  NOT NULL,  image     VARCHAR(40)  NOT NULL,  PRIMARY KEY(productid),   FOREIGN KEY(catid) REFERENCES Categories(catid) )  GOCREATE TABLE FeaturedProducts (  productid   VARCHAR(10)  NOT NULL,  featuretext VARCHAR(MAX) NOT NULL,  saleprice   MONEY        NOT NULL,  PRIMARY KEY(productid),  FOREIGN KEY(productid) REFERENCES Products(productid) )  GO    CREATE TABLE Customers (  email     VARCHAR(50)  NOT NULL,  lastname  VARCHAR(50)  NOT NULL,  firstname VARCHAR(50)  NOT NULL,  address   VARCHAR(50)  NOT NULL,  city      VARCHAR(50)  NOT NULL,  state     VARCHAR(2)   NOT NULL,  zipcode   VARCHAR(9)   NOT NULL,  phone     VARCHAR(20)  NOT NULL,  PRIMARY KEY(email) )  GO    CREATE TABLE Orders (  ordernum  INT           IDENTITY,  orderdate SMALLDATETIME NOT NULL,  custemail VARCHAR(50)   NOT NULL,  subtotal  MONEY         NOT NULL,  salestax  MONEY         NOT NULL,  shipping  MONEY         NOT NULL,  total     AS (subtotal + salestax + shipping),  PRIMARY KEY(ordernum),   FOREIGN KEY(custemail) REFERENCES Customers(email) )  GO    CREATE TABLE OrderItems (  ordernum  INT          NOT NULL,  productid VARCHAR(10)  NOT NULL,  name      VARCHAR(50)  NOT NULL,  price     MONEY        NOT NULL,  quantity  SMALLINT     NOT NULL,  total     AS (price * quantity),  PRIMARY KEY(ordernum, productid),   FOREIGN KEY(ordernum) REFERENCES Orders(ordernum),  FOREIGN KEY(productid) REFERENCES Products(productid) )  GO

View 2 Replies View Related

How To Persist Cookie Through HttpWebRequest In CLR? Thanks

Mar 20, 2007

I put HttpWebRequest in a CLR so I can call website in my SQL. In same calls, I need pass cookies from the previous call to the next call. So I am thinking I can do this in two ways:

1, store the cookiecontainer somewhere , but not sure if CLR allow me to do that ,

2, return the cookiecontainer, and send it to the next call from SQL, this way I need use cookie string, is there a function to serialize a cookiecontainer?



thanks

View 2 Replies View Related

Problem With A Postback

May 3, 2008



I want that a textbox do a postback after I change the text : I change autompostback to true , It's do a postback after
I press on the enter button , how can I do automatic postback after the text change without press on the enter button?

View 1 Replies View Related

Do Pass Thru Query Connections Persist?

Oct 18, 2006

I have an Access 2003 front end with a SQL Server 2005 Express backend. I was thinking of using pass thru queries as row sources for some combo boxes such as states/countries for addresses. My question is do pass thru queries, when used as a row source, keep a connection to the DB server? Or do they get the data, disconnect and populate the control?

I realize I could populate the controls with code, but this seems less hassle and will overcome the ValueList size limit if needed.

View 9 Replies View Related

Can SQL Service Broker Persist Requests?

May 17, 2007

I have a scenario where we want something like a message bus. We can have multiple clients sending in events and would like a way to

i) persist those events

ii) Send out the notifications to the subcribers (this would be some C# services)



What is the best way to do this? I know that we can build something from scratch using WCF Publish-Subscribe. But i was interested in knowing if I can leverage SQL Service Broker to do the work.



View 8 Replies View Related

Sql Insert And Postback Problem

Mar 20, 2008

Hi.
We have a problem. The sql insert don't work together with postback on the insert button. The following solution has been sugested:Partial Class Login
Inherits System.Web.UI.Page

Protected WithEvents loginButton As Button

Protected Sub loginButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles loginButton.Click
Response.Redirect("Tunnel1.aspx")
End Sub

End Class
 But it doesn't work (the data is saved in the databse but the page isn't redirected to "Tunnel1.aspx"), why?
Here is the code for the page:<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Login.aspx.vb" Inherits="Login" title="Untitled Page" %>

<asp:Content ID="Main" ContentPlaceHolderID="Main" Runat="Server">
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>"

InsertCommand="INSERT INTO konsult(användarnamn, lösenord) VALUES (@användarnamn, @lösenord)">
</asp:SqlDataSource>

<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" DefaultMode="Insert">
<InsertItemTemplate>

<table cellpadding="0" cellspacing="0" width="100%" border="0">
<!-- Menyrad -->
<tr>
<td colspan="2">
<table align="right" cellpadding="0" width="100%" bgcolor="#EEEEEE">
<tr>
<td align="left">
<script type="text/javascript" language="JavaScript">showMenus(1,'Horizontal')</script>
</td>
<td width="100%" align="right">
</td>
</tr>
</table>
</td>
</tr>
<!-- Sidan -->
<tr>
<!-- Topp skuggor -->
<td width="500" height="15" style="background-image: url('Images/toppskugga_Liten.jpg'); background-repeat: no-repeat; background-position: center bottom">
<table cellpadding="0" cellspacing="0">
<tr>
<td width="20"></td>
<td width="460"></td>
<td width="20"></td>
</tr>
</table>
</td>
</tr>
<tr>
<!-- Mellan skuggor -->
<td width="500" style="background-image: url('Images/mellanskugga_Liten.jpg'); background-repeat: repeat-y; background-position: center bottom">
<table cellpadding="0" cellspacing="0">
<tr>
<td width="20"></td>
<td width="460">
<table width="100%">
<tr>
<td width="150">Användarnamn:*</td>
<td width="250"><asp:TextBox Width="150" ID="användarnamnTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("användarnamn") %>' /></td>
</tr>
<tr>
<td width="150">Lösenord:*</td>
<td width="250"><asp:TextBox Width="150" textMode="Password" ID="lösenordTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("lösenord") %>' /></td>
</tr>
<tr>
<td width="150">Upprepa lösenord:*</td>
<td width="250"><asp:TextBox Width="150" textMode="Password" ID="upprepalösenTextBox" runat="server" Font-Size="X-Small" Text="" /></td>
</tr>
</table>
</td>
<td width="20"></td>
</tr>
</table>
</td>
<td rowspan="3" width="240" valign="top">
<table cellpadding="0" cellspacing="0">
<tr>
<td width="240" align="right">
 
<asp:Button ID="loginButton" CommandName="Insert" CausesValidation="True" runat="server" Text="Spara" />
 
</td>
</tr>
<tr>
<td width="240" style="background-image: url('Images/toppskugga_Mini.jpg'); background-repeat: repeat-y; background-position: center bottom"> </td>
</tr>
<tr>
<td width="240" style="background-image: url('Images/mellanskugga_Mini.jpg'); background-repeat: repeat-y; background-position: center bottom">
<table>
<tr>
<td width="20"></td>
<td width="200" valign="top">
<asp:CheckBox ID="CheckBox1" runat="server" Text="Jag godkänner att mina personuppgifter registreras enligt PUL." />
</td>
<td width="20"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="240" style="background-image: url('Images/bottenskugga_Mini.jpg'); background-repeat: repeat-y; background-position: center bottom"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<!-- Botten skuggor -->
<td width="500" height="20" style="background-image: url('Images/bottenskugga_Liten.jpg'); background-repeat: no-repeat; background-position: center bottom">
<table cellpadding="0" cellspacing="0">
<tr>
<td width="20"></td>
<td width="460"></td>
<td width="20"></td>
</tr>
</table>
</td>
</tr>
</table>

</InsertItemTemplate>
</asp:FormView>
</asp:Content>

 

View 2 Replies View Related

Sqldatasource Weirdness On Postback

Jan 7, 2006

If I alter the SqlDataSource select command in code and then bind to a gridview, I run into problems. When I do a sort, next page (basically any postback), the datasource goes back to the original state. It is like the SqlDataSource is not maintained in the  state. I end up having to re-alter the SqlDataSource select command on every page_load. Is this by design or is this a bug?
Is the SqlDataSource any "smarter" than doing it the old fashion way by populating a Dataset on (!IsPostBack) ? For example, if I have a bunch of data in a paged gridview, is the SqlDataSource smart enough not to bother filling the entire dataset if I don't need it for that page's display?  I know the SqlDataSource provides for update/insert/delete, but I am not doing that in this application, it is just a query/report page.
Thanks in advance

View 4 Replies View Related

PostBack While Selecting A Parameter

Mar 21, 2007

Hi,

I'm working on a report having 2 date parameters(which uses calendar control) and a dropdownlist. But on selecting each of these parameters, the page refreshes. For eg On selecting a date from the calendar control results in a postback. The same is the case with the dropdownlist. Could you please help to resolve this issue? We need the postback to happen only on clicking the 'View Report' button.

Also, is there any way to customize the 'View Report' button. It always appears in the right hand side. Can we set the position of this button so that it appears just below the paging button?

Thanks in advance,

Sonu.







View 1 Replies View Related

FTP Authentication Information Does Not Persist When Deploying Packages

Jan 18, 2006

I am trying to deploy a SSIS package which includes a FTP task. It works fine on the machine it was developed . When deploying the package on a production server, all other config changes work, but the FTP task is failing, with authentication error.



any help on how to persist the data would be appreciated

thanks

View 1 Replies View Related

Postback Causing Database Transactions To Replay

Dec 7, 2006

Hey,
 I hope someone can quickly tell me what I am obviously missing for this weird problem. 
To give a general picture, I have an ASP.net webpage that allows users to select values from several dropdown menus and click an add button which formats and concatenates the items together into a listbox. After the listbox has been populated the users have the option to save the items via a save button.
The save button parses each item in the listbox to basically de-code the concantenated values and subsequently inserts them into a table residing on a backend MSSQL 2005 database.
PROBLEM:
In the process of testing the application, I noted this strange behavior. If I use the webpage to insert the values, go to the table where the values are stored and delete the rows; Upon a refresh of the web page the same actions seem to be getting replayed and the items are again inserted into the table.
Naturally, what I'd really like would be for the page to refresh and show that the items aren't any longer there and not the other way around. 
If the code that performed the insert was residing in a component that was set for postback I'd expect this type of behavior but its in the Save buttons on_click event. I have tried practically everything in effort of targeting the problem but not having much luck with it.
Is this behavior practical and expected in ASP.net or has anyone ever heard of anything similar? I have never encountered this type of problem before and was hoping someone could provide some clues for resolving it. If more information is required I'd be happy to supply it. Hopefully, there's a simple explanation that I am simply unaware since I haven't experienced anything like this before.
Anybody got any ideas???
Thanks.

View 6 Replies View Related

Changing Default Parameters Cause Postback Efresh

Jul 26, 2006

I think it has been discussed previously that having default parameter values based on expressions, e.g. a default parameter value of =Split("Bug",",") in multiple parameters will cause a postbacl whenever a user selects different values from the list.

Is this by design? Its a bit of an annoying thing. The refreshpostback doesnt happen if you have basic defaults like ="All" but only when an expression of some sort is used in more than 1 parameter. Does RS think they are linked or something, why does it need to psotback
efresh?

View 23 Replies View Related

Prevent Date Parameter Button From Postback

Jan 21, 2008

Hi Everyone-

i have a report that include a parameter of type date and it is visible to the user in order to choose the date and submit view report button to rendering the report.



i don€™t know if it is a bug in SSRS or not

but the problem is that if the user try to click on the date button of the parameter and choose a date

And then try to click again on the date button and choose a date another date .....after repeat the previous step more than one time the page is post back and reset the report and this not desirable by our client



Note:


Again the date button I am mention is the date button that auto generated by the SSRS as there is a parameter of type date

This Case happen only if the report run through a browser





Thanx

Maylo

View 1 Replies View Related

Display The Evaluated Expression Automatically Before PostBack

Apr 28, 2008


I have a report which includes two fields of type date pFromDate and pEndDate.
My pFromDate Available values is 'No-queried', and Default values is 'Null'.
My pEndDate values is 'No-queried', and Default values is the
expression '=DateValue(Today)'.
After I upload my report to the report server and run it pEndDate is disabled until I choose value to pFromDate and a postBack occurs.
I want pEndDate display the evaluated expression automatically when I run the report.
How can I do it? Thanks in advance.

View 1 Replies View Related

Advanced Editor Randomly Fails To Persist New Column Width

Sep 4, 2007

This one has set me back many, many hours on this project; it's about got me ready to dump SSIS & just roll a custom .NET solution in C#.

I need to create import packages for quite a few very wide flat files (130 - 180+ columns, not my design). Many of these columns have data > 50 characters long.

I change column widths on the data flow source using the Advanced Editor, via Input and Output Properties ==> Flat File Source Output ==> External Columns.

About 50% of the time, the changes vanish after clicking OK to dismiss the Advanced Editor. There is no warning message or output announcing that the editor failed to persist its changes, or that it set some columns' properties back to the defaults, or why. The column's widths just silently revert back to 50.

If the cause and resolution aren't known, does anyone know of a way to accomplish any of the following workarounds?


Create a data source connection by importing an external text schema defining the flat file's column names, data types and sizes, or
Change a property on multiple source columns en-masse, or...

Get at a text version of the file containing the Data Flow Component's definition, so we can edit wide import schemas without racking up thousands of mouse-clicks?Thanks! A virtual cheeseburger to anyone with answers.

View 7 Replies View Related

Sqldatsource:SelectParameters:FormParameter Not Effective Till Postback?

Nov 14, 2007

I have a simple gridview that loads on page load. It uses an on page sqldatasource declaration in which there's a parameter in which value is already available in cookies. I added an asp:HiddenField and set that value on PageLoad() to the value of the cookies. I then set a FormParameter in the sqldatasource mapped to that hidden field. However that appears to have no effect at all. I'm guessing the sqldatasource will only use the form field after postback.

View 2 Replies View Related

Postback Issue While Selecting Parameters In SQL Reporting Service

Sep 5, 2007

Hi,

I am working on a report (in 2005 version) having 6 date parameters ( which uses calendar control). When on selecting the date parameter(except the last data paramenter), the page refreshes. For eg On selecting a data from the calendar control results in a postback. but if I select the last data paramenter, the page is not refreshed.

I did another test on a report that only has 2 data paramters (use the calendar control), it is the same. you select the second the data parameter, no postback happened, but if you select the first data parameter, the postback happened.


Dose anybody know what is the issues? We need the postback to happen only on clicking the 'View Report' button.


Thanks in advance,
TH

View 3 Replies View Related

Sqldatasource Setting Reset After Page Postback, Could Anyone Give Me A Hand On This

Nov 25, 2005

Hi, I have created a search page which needs to perform different
search function in same page. I have setuped a sqldatasource then
manual
setup the connection string and command inside the codefile. So the
select command can be various depends on the event. The problem is
all of those setting will be reset after I click on the pageindex in
the girdview control to go to next pages. Since this gridview is linked

with this sqldatasource control, I need to restore the connection
string/command when user choose decide to view next page of data inisde
the
gridview.

I think I must have done something wrong in here becuase it will end up
retrieving  the total amount of data when everytime user choose to
view next
or perivous page.

Can someone give me a hand on this ? Thanks

View 1 Replies View Related

Searching In Title And Description

Apr 29, 2007

hey guys, so i have my website, everything is ok, until i have to put in a title field, along side my description. so far i have this code which searches in the description, how can i make it so i can search in the title as well
SelectCommand="SELECT [Stock_ID], [cat_id], [description], [size],
[selling_price], [qty], [picture1] FROM [tbl_stock]
WHERE ([description] LIKE '%' + @description + '%')">
 Any help would be great
 Cheers
Jez

View 2 Replies View Related

If @Title IS NULL Not Working

Jul 3, 2006

I'm building a stored procedure to edit a row in my database but first I'm wanting to check for null values in the parameters and set them to their respective value in the row I'm attempting to edit.

Here's my code:

Code:

CREATE PROCEDURE dbo.spModifyProject
(
@ProjectID int,
@Title nvarchar(50),
@Description nvarchar(50),
@DueDate smalldatetime,
@ProjectLead nvarchar(50),
@Completed bit
)

AS

IF @Title IS Null Then
SET @Title = (SELECT Title FROM Projects WHERE [ID] = @ProjectID)
END IF



I get syntax errors in two places. The first is near Null and the second is near END. Any help you can give is appreciated.

View 2 Replies View Related

Select Column Value As Title

Feb 13, 2005

I have a table that is a very general layout so I can expand upon values later in the future easily. Basically it looks like this:

Code:

ID PlayerID Ability Score
1 1 STR 18
2 1 DEX 17
3 1 CON 16



What I'm trying to do is create a stored procedure where I pass in a PlayerID and it will return a result set of

Code:

STR DEX CON
18 17 16



It doesn't appear that there's a way in SQL Server 2000 to SELECT a column AS a variable. I suppose I could go about creating a temporary table, but seems like an odd work around to get it to work. Any suggestions? Or am I just missing something obvious?

View 3 Replies View Related

Need To Add Parameter To Report Title

Nov 16, 2006

Hello,

I am asking this question here, because it appears that I don't get as fast a response in reporting services as I do on this forum.

I am trying to add an extra parameter in a report title called SummaryBy.Value

Here is my current code:

="BY " & UCase(Parameters!SummaryBy.Value & IIF(Parameters!SummaryBy2.Value<>"", " / " & Parameters!SummaryBy3.Value,""))


If I add the extra parameter I get an error because of the IIf. How do I get around this to display all three parameters?

Please let me leave this post here also. I need to get an answer asap.

TIA and have a great day!



Kurt

View 6 Replies View Related

If @Title IS NULL Not Working

Jul 3, 2006

I'm building a stored procedure to edit a row in
my database but first I'm wanting to check for null values in the
parameters and set them to their respective value in the row I'm
attempting to edit.



Here's my code:

Code: CREATE PROCEDURE dbo.spModifyProject
(
@ProjectID int,
@Title nvarchar(50),
@Description nvarchar(50),
@DueDate smalldatetime,
@ProjectLead nvarchar(50),
@Completed bit
)

AS

IF @Title IS Null Then
SET @Title = (SELECT Title FROM Projects WHERE [ID] = @ProjectID)
END IF



I get syntax errors in two places. The first is near Null and the second is near END. Any help you can give is appreciated.

View 3 Replies View Related

Dynamic RDL Group Title

Jan 10, 2007

I'm new to these forums. If this is not the right place to post this question, please let me know where I should ask. :)

Anyway, I have a report that is grouped something like this:



Team
Location
Score

TEAM 1
#Loc#
#Total#


Home
10


Away
14


Away
8


NULL
0


NULL
0


Home
14

TEAM 2
#Loc#
#Total#


Home
10


Away
14


Home
19


NULL
0


Home
14

TEAM 3
#Loc#
#Total#


Away
7


Away
12

For each team grouping, the header columns needs to perform an action on the grouped records to determine the text.

The #Total# header is easy -- here I want a total of the points ( =Sum(Fields!Points.Value) ). No problem.

The #Loc# header is the problem. What I want to do is to count the number of "Home" values in the group (so Team 1 location reads "Home (2 of 6)", and Team 2 location reads "Home (3 of 5)"). If there are no "Home" values, I want to use the "Away" value (so Team 3 location reads "Away (2 of 2)").

Can someone tell me how I can create a custom code function that will allow me to iterate through the values of the grouped records from the group header textbox? I assume I need to be able to create a custom aggregate function of some kind, but I don't quite know where to begin.

Thanks for your help.

Joe

View 1 Replies View Related

A Query Where Title Includes 'Keyword'

Apr 30, 2008

i am having a problem querying a field in a database to show all records where the title has a keyword within the title.
 Select * FROM tblCourse
WHERE title =@Search
But not the full title just a keyword within the field?
 Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved