SQL Server :: Subqueries Are Not Allowed In This Context. Only Scalar Expressions Are Allowed?
Jan 9, 2011
[code]...
I get the Subqueries are not allowed in this context. Only scalar expressions are allowed - i am going to run into this quite alot so I figuredI'd better see what the right way is!
I'm debugging some tricky generic List-based code in VS 2010 - lots of heirarchy-processing etc.. Of course lambda expressions and anonymous methods aren't permitted within the immediates window and I can't be doing with stepping thru the code in the usual way as I'm still trying to get my head around the hierarchies ...Can anyone suggest a workaround or an alternative tool?P.S. An aside - I can't seem to find a visual studio 2010 tag?
i'm parsing a few .net resource files (.resx).In that, i have this piece of data:informaciónThis works in my .net app, but when i try to load this file in my xml document
XDocument xmlDoc = XDocument.Parse(s);
i get this error:Reference to undeclared entity 'oacute'.
Implicit conversion from data type sql_variant to varbinary is not allowed. Use the CONVERT function to run this query.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Implicit conversion from data type sql_variant to varbinary is not allowed. Use the CONVERT function to run this query.
Page1 contains GridView1 which displays info from Table1.GridView1 contains a CommandButton which, when clicked inserts the values of all columns, plus a calculated value which goes into an extra column into Table2 handled in the RowCommand event handler of GridView1.Page2 contains GridView2 which displays info from Table2.GridView2 allows the user to alter the value of one of the columns in Table2 using the standard Edit/Update link.All this worked well until...I added UserId and SessionId fields to Table2 (uniqueidentifier and varchar(MAX) respectively,I added the following code to Page1 Code Behind to insert these values from the RowCommand handler:
[Code]....
All of this works beautifully. But... I then added this code to GridView2's RowUpdating event handler:
My filter Expression was working fine with filtering by Control Parameters.When I added the Phone Parameter it went nuts - with the Phone Parameter the GridView just Comes out blank upon loading the page (without it would show Select * from Individuals)Is it because the phone field is populated with numbers? Don't get it.... In the SQL server the 'phone' field is set to 'varchar(30)' and nulls are allowed.here is my code:
How can allow this page to run on IIS server...It does not work on localhost..... it works when I open it directly... It gives the error "it is not allowed...!
The working Example..! I want this.. ""
the Erorr:
<html> <head> <script src="jquery.js" type="text/javascript" language="javascript"></script> <script src="jquery.xml2json.js" type="text/javascript" language="javascript"></script> <script> function sayHello(msg) { alert(msg); } function dcSetRate(obj,value){ document.getElementById(obj).value = value.toFixed(4); } function dcSet(obj,value){ document.getElementById(obj).value = value; }......
As far i think # is not allowed in valid url but i have to allow this in my application..very first step i have taken in reg expression i allowed # ...but wen user click that inspite of valid url i am getting crash
i am getting the error below while sending email in aps.net 3.5.
Mailbox name not allowed. The server response was: sorry, Authentication failed or timed out. Please do get messages first to authenticate yourself.(#4.4.3) in asp.net while sending mail
Ultimate goal is to provide protection against programming mistakes. I want to make sure that every page in a portion of my web application has a role specified like below. Ideally I would like to programatically check all requests coming in ( think IHttpModule ) and make sure that the page being requested has a role specified.
I can't seem to find how to get programatic access to the allowed roles.
When I re/build my ASP.NET website I do not receive any errors. However when I PUBLISH the site, it gives me a 'Circular file references are not allowed.' error.
I read a little on the web about this, and it provided a batch='false' option, which I tried and does nothing.
The page, has a master page, which may call on the same control twice; however, this control does not refer back to anything
I am taking over the code of another person. This person is allowing double clicks to occur on RadGrids (Telerik Control).. I personally hate the idea of allowing double clicks in a web application. I tihnk it is not natural.
Is there any good argument against double clicks in web apps? Or am I wrong and double clicks in web apps are good for some reason?
OK, I've seen a lot of ambiguous errors, but this was is in the top 20 or so. I have a RenderPartial that looks like this:
[Code]....
When the view loads, I get this error:
The relative virtual path '~Areas/User/Views/Shared/ProjectStats.ascx' is not allowed here. That really helps. Why isn't it allowed there? What's wrong with it? Just above it I have other PartialRender calls that work without a problem. They're created exactly the same way. Here's another:
[Code]....
This works fine. I thought maybe it was due to accessing a view from another Area, but I added a partial view to that Area's folder and it still didn't work.
When I try to depoly my web project then it throws an exception as "Circular References not allowed" Those are two same exceptions for my template.master and Forummaster.master file. When I build my code then very rarely it throws an exception but I can not deploy my web project because for deployment everytime it throws same exceptions at the time of building web project for deployment.
I have a textbox and button in my child page it inherits a master page.the textbox should allow to key in only alphabets,comma,dot,space,single quote. And also consecutive comma dot single quote should not be allowed to key in. first and last character should be alphabets.
I have a javascript but it does not check for consecutive comma,dot,single quote...
I have been spinning my wheels now for awhile trying to figure out how I can possibly unit test the following code. At first I was going to use Moq to mock everything, but it doesn't include the ability to mock sealed classes. I know I need to abstract out the calls to the implementation (Configuration) using an interface? but I can't seem to make it all work right. The code can be altered but I would prefer to keep the methods static, unless you can present a compelling reason not to. You can add interfaces or create whatever seams are needed. Also, GetConnStringByName() can be refactored to return the relevant string instead of a ConnectionStringSettings. Thoughts?
namespace Stackoverflow.Rocks { /// <summary> /// Utility class for progmattically selecting values from the Web.config file. /// </summary> public class WebConfigStrings { //private static Configuration myConfiguration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath); /// <summary> /// Retrieves the desired connection string value based upon the target name. /// </summary> /// <param name="connectionStringName">The target connection string referenced in the Web.Config</param> /// <returns>The value specified in the Web.Config by your connectionStringName</returns> public static ConnectionStringSettings GetConnStringByName(string connectionStringName) { Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath); ConnectionStringSettings connString; connString = rootWebConfig.ConnectionStrings.ConnectionStrings[connectionStringName]; return connString; } /// <summary> /// Retrieves the desired application string value based upon the target name. /// </summary> /// <param name="applicationStringName">The target application string referenced in the Web.Config</param> /// <returns>The value specified in the Web.Config by your applicationStringName</returns> public static string GetAppStringByName(string applicationStringName) { string appString = ""; appString = ConfigurationManager.AppSettings[applicationStringName]; return appString; } } }