DataSource Controls :: Subqueries Are Not Allowed In This Context - Only Scalar Expressions Are Allowed
Mar 22, 2010
i get the above error when i try to run this sql statement
INSERT INTO PSPS_Posts (Post, Date_Posted, user_ID, Thread_ID) VALUES (@Post, @Date_Posted, @user_ID, (SELECT Thread_ID FROM PSPS_Thread WHERE Thread_ID = (SELECT MAX(Thread_ID) FROM PSPS_Thread
View 5 Replies
Similar Messages:
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!
View 2 Replies
Dec 6, 2010
When i am executing following query:
INSERT INTO Customer (ID, FullName, WebSite, AnnualFee,
View 8 Replies
Dec 10, 2010
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?
View 1 Replies
Mar 8, 2010
I just upgraded from VWD 200t to VWD 2010. I'm now seeing an error message that I never saw before. Error is: 'Text is not allowed between the opening and closing tags for element SqlDataSource'
Here is my HTML:
[Code]....
There is a green squiggly line under SqlDataSource, here:
asp:SqlDataSource ID="SqlDataSource2"
I have a similar problem here:
[Code]....
Like above, there is a green squiggly line under SqlDataSource, here:
asp:SqlDataSource ID="SqlDataSource3"
View 3 Replies
Apr 24, 2010
I am a newbie in ASP.NET. I am facing this problem. I need to insert data into my database, where is primary key uniqueidentifier. I am using FormView and if I insert data there is an error. In asp:Parameter there is no datatype, which is support uniqueidentifier.
View 5 Replies
Jan 11, 2011
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'.
View 2 Replies
Apr 5, 2010
I've got a formview with controls in different template views and I have a query just out of curiosity.
In my edit template I've got for example:
<asp:TextBox ID="IsPrestigeTextBox" runat="server" Text='<%# Bind("IsPrestige") %>' />
<asp:CheckBox ID="IsPrestigeChkbx" runat="server" />
and then the same code exactly in my insert template:
<asp:TextBox ID="IsPrestigeTextBox" runat="server" Text='<%# Bind("IsPrestige") %>' />
<asp:CheckBox ID="IsPrestigeChkbx" runat="server" />
However, the databound items seem to be allowed to have the same ID whereas the non-databound checkboxes arent.
What's going on there?
View 6 Replies
Jan 20, 2011
On my main page I have a repeater that pulls the last 3 entries from the database. I want to be able to add pictures to the database and show those in the repeater, but only if the column is set to true. I can't seem to get past the part about have the image show only if its supposed to.
Here is the code for my page:
[Code]....
Code Behind:
[Code]....
SP:
[Code]....
So my questions are: Is the repeater the correct control to use?
How do I only show the image control if the column "NewsImgShow" is true?
View 3 Replies
Apr 8, 2010
I have a listview, that shows 8 rows until creating another page to navigate to to see the rest. I can't figure out where the limitation of the number of rows is coming from
View 7 Replies
May 18, 2010
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:
[Code]....
View 4 Replies
Oct 14, 2010
I have defined the following control which serves as a wrapper for another control (simplified code):
[code]....
Can anyone provide any insight as to why it is failing in one environment, but not the others? Is this something related to configuration? The user control is hosted within a "SmartPart" style user control loader which is being used on a WSS 3.0 site in the DIT/SIT/UAT environments.
View 1 Replies
Jul 10, 2010
I have made subdirectory [URL]. and user control is loaded at runtime. But there is this error The virtual path '/theme/miragetheme/user-controls/display-userblog.ascx' maps to another application, which is not allowed.
View 1 Replies
Jul 19, 2010
Why in asp.net web page we have only one FORM attribute, but in other language more than one FORM attribute is allowed.
View 3 Replies
Mar 12, 2010
I can open it up in the browser and it works, but a call from client side (using both jquery and asp.net ajax fails)
Service Contract
[OperationContract(Name = "GetTestString")]
[WebInvoke(Method = "GET",
ResponseFormat = WebMessageFormat.Json
)]
string GetTestString();
In Web.config among other bindings, I have a webHttp binding
<endpoint address="ajax" binding="webHttpBinding" contract="TestService" behaviorConfiguration="AjaxBehavior" />
EndPoint Behavior
<endpointBehaviors>
<behavior name="AjaxBehavior">
<enableWebScript/>
</behavior>
</endpointBehaviors>
</behaviors>
Svc file
<%@ ServiceHost Service="TestService" %>
Client
var serviceUrl = "http://127.0.0.1/Test.svc/ajax/";
var proxy = new ServiceProxy(serviceUrl);
View 1 Replies
Sep 15, 2010
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;
}......
View 3 Replies
Mar 30, 2010
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
View 4 Replies
Feb 17, 2011
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
View 9 Replies
Jan 4, 2011
I have a textbox where the user must not be able to enter more than two digits after a decimal.How do I do this without using javascript?
View 3 Replies
Jul 7, 2010
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.
[code]....
View 2 Replies
Mar 15, 2010
Can I call a PageMethod and then call another PageMethod before the first has finished? Are concurrent calls to PageMethods allowed?
View 1 Replies
Feb 12, 2010
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
View 1 Replies
Sep 16, 2010
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?
View 6 Replies
Oct 29, 2010
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.
View 3 Replies
Jun 28, 2010
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.
View 1 Replies