I get the following errors: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. If the subquery only return one result,then it works fine,but if the subquery return more than one results, then the error occurred,how can I resolve this error?
View 3 Replies
I know this topic is all over the place, but I am not doing an INSERT, UPDATE, DELETE. My statement is a plain and simple SELECT statement and so far has worked with 116 different items in my database until I got to one.
I have a search engine and am going through every single product in our database to add information to it. This is all done through the website, but when I search for ProductID 331 and click on it, it goes to the error page that says Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
It doesn't make any sense to me that the website would error with only this one product. This is the statement I am using. Does anyone know why 1 product would be causing this error?
WebService:
Public Class ProductSearch
Inherits System.Web.Services.WebService
<WebMethod()> _
[Code]....
[Code]...
I want to use a stored procedure to populate a label on my asp.net page and a dropdownlist @tourname will be populated into a single label while @tourdepartures will be multiple dates, that i want in a dropdownlist however when i run my sp i get this error
[Code]...
Here is my SQL query..
SELECT EqID, MakeID, Model, Description,
(SELECT MAX(EvDateEnd) AS MaxOfDateEnd
FROM tblEvent WHERE (EqID = tblEquip.EqID) AND (Event = 'REG')) AS RegExpire,
[code]....
For example, I want to get the Max EvDateEnd from the Events table for each record in tblEquip, but not all records in tblEquip have the "REG" event, while others have multiple REG events.Some events (like EAE) I leave the tblEvent.EvDateEnd field blank to show the event is open and ongoing, such as issuing a vehicle to an employee(entity). when the vehicle is returned I enter the date in EvDateEnd essentially closing the event.
I've got a subquery that returns the most recent value from a child table. In some cases the subquery returns nothing. The query below fails at runtime because the inferred type of MemberPrice is decimal and is not nullable. [code]...
View 4 RepliesI need to find all records where the status is in the local list of Integer's.
In SQL I would do
Where Status in (select i from my list)
But I can't figure how to make it happen in Linq.
ListData = New IssueTrackerEntities2()
Dim queryString As String = "SELECT VALUE CallList FROM IssueTrackerEntities2.CallList AS CallList"
Dim Status As New List(Of Integer)
[Code]....
here is my Query. What is wrong with this?
rs.Open "SELECT * FROM Installment_w_DueDate where LastDocDate < (SELECT LastDocDate FROM Installment_w_DueDate where AccountNo = '" & txtAccountNo.text & "')", MDIMain.strConnect, adOpenStatic, adLockReadOnly
I wrote some code to update the count of a field in a table, but it is very slow. So I'm trying to do it in a subquery to speed things up, but I'm not very good with subqueries. I'm getting the error "Subquery returned more than 1 value".
[Code]...
I'm trying to query old Access database tables and compare them with SQL Server tables.They often don't have primary keys, or they have extra fields that had some purpose in the nineties, etc., or the new tables have new fields, etc.I need to find records - based on a set of fields specified at runtime - that are in one table but not another.So, I do this kind of query all the time in SQL, when I'm comparing data in different tables:
dim fields_i_care_about as string = "field1, field2, field3"
'This kind of thing gets set by a caller, can be any number of fields, depends on the
'table
dim s as string= ""
[code]....
It tells me it can't convert a Boolean - Is there any way to do this without Linq expressions? They seem far more complex than what I'm trying to do here, and they take a lot of code, and also I can't seem to find examples of Expressions where we're comparing two fields in a subquery.Is there a simpler way? I know I could do the usual EXISTS query using JOIN or IN - in this case I don't need the query to be super fast or anything. And I don't need to use a DataTable or DataSet - I can put the data in some other kind of object.
How can i get the scope identity parameter in my vb code. I have this so far....
[Code]...
How can i retreive this ID, in the DetailsView1_ItemInserted?
what i'm aiming at doing here is returning every file on my drive that hasn't been accessed in 90 days. The first listbox has all the directories and the second works off that to return all the files... [code]
View 3 RepliesHow to give another function's returned value in LINQ.[code]but in above query I should write code to store the return value of GetObjProperty Value(p) and add obj-p and returnValue combination to the dictionary.The last line below code is wrong. but please suggest me how to correct it. My intention is, I want output collection(say dictionary) of each fruitname and its color(returned by other function call) for all the fruits which the GetFruitColor is not nothing(it can be empty or valid string).[code]In above code last line is wrong. So how to put getFruitColor in k, how to correct it to save the k value and give me output as dictionary of fruit and k value.
View 1 RepliesWhy this code doesn't work? It returns an unexpected value actually total = 0.
total = Cscore(TextBox1.Text) * CDbl(TextBox2.Text)
When trying this
total = TextBox1.Text * TextBox2.Text
It returns the expected value but I need to pass textbox1.text to the function to get the desirable value
The function is this
Public Function Cscore(ByVal score As Integer) As Double
Select Case score
Case score = 100
Return 5.0
Case score >= 95
[Code] .....
I have an SQL Query that looks like this [code]I get two results. The first is the correct one which is -0.0060 and the second @return_value which is 0.This is also the case when I call the stored procedure from my code, I get a 0 back instead of the -0.0060 that I want. This is how I am calling the stored procedure from my code:[code]
View 3 RepliesI have many functions that perform mathematical calculations.
Here is one for example:
Public Function internaldiamofcasingpipecalculation(ByVal Externaldiameterofcarrierpipe As Double, ByVal insulationthickness As Double) As Double
[Code]....
i m working on vb.net and wht i want to do is return some value from the popup window to the page from where popup generated.
for example
i have a multilined text box populated with the names of product categories.
now i want to add more categories to that textbox.
for this purpose i have a link button which triggers popup window from where i can add more categories.
now when i clicked on done in popup the newly added categories should be in the textbox of that page.
I need to check the current date and month to see if they are only 1 character long (1 - 9 - January to September) and if so I need to insert a 0 before the value in a string.Now the code I have been using is Len(Now.Month) which for some reason is returning 4 even though the current Month is February (thought this would return 1).I I use Len(Now.Month.ToString) it comes through as 1, which is what I want.
View 1 RepliesI would like to define Sorted to be of type ErrorProviderMessageCollection, which is what unsortedCollection is defined as.
[Code]...
I'm new to VB.NET and want to parameterise the SQL Connection Strings in my VB.NET App. I've added a function to my Main Form to retrieve the App.config File like:
Imports System.Configuration
Imports System.Configuration.ConfigurationSettings
Public Class MainMenu [code]....
In my other forms when i want to reference the Connection String, i get an error saying getConnStr is not declared?
Private Sub UpdDept_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
myconnection = New SqlConnection(getConnStr()) <=============
Dim mycommand As New SqlCommand()
why i get this when i've declared the Function as Public?
I have a model that returns a dataset to a view and builds a list. The crazy thing is that I have tested this code with IE, Safari on Mac and Windows, Chrome and Opera and all return data. However, on the iPad or iPhone, zero rows are returned from the dataset object. It seems that the model is in fact passing the dataset to the view. I am using jquerymobile to render the view for the iOS devices and have taken that out of the mix to test and it still doesn't work.
[Code]...
Im still doing some amatuer programming, but now in .net and Ive come here with a question that I cant seem to find an answer to... Basically, Ive got a program im writing to interface into my companies AD and return some values, which then trigger other events etc..
The problem Ive run into is trying to find and easy way to compare the returned value when against a list of possible combinations (16 possibilities to be exact), and if its one of them then all good continue on but if not then I need to throw an error and exit sub.[code]...
I am confused which data type to define for my variable which stores value returned by LINQ Statement.
Currently I am defining it as some data type but its generating error like: ""Unable to cast object of type 'WhereSelectListIterator2""`
[Code]...
Here i want myBase to hold the data which has UIN = 4
I have a problem with a For Each Loop that doesn't make any sense. The For Each Loop returns values from a list which are Memory Ranges for a given device. When I check the count in the list it returns 3. The For Each only returns 1.
Here's my code:
Private Sub DisplayDeviceResources(ByRef lvwResources As ListView, ByRef intClassIndex As Integer, ByRef intDeviceIndex As Integer)
Dim curDeviceClasses As New DeviceClasses
Dim lvwItem As ListViewItem
EnumerateResources()
[Code] .....
Just finished reading a book on visual basic "Imports System.IO" and "FtpWebRequest". I double checks this code and tripple checked it but I can't seem to find anything wrong with it, bare in mind I did write it from scratch with help from the book so maybe its full of mistakes.[code]
View 2 RepliesI have been playing around with datareader for a little while, and I can't figure out how to get the number of row returned? [code]...
View 7 RepliesWhen the AlertsSettings.xml is not present the Appsettings is assigned to nothing. The variables that follow that definition rely on the existance of that information which will normally be set by the load method. But when there is a problem and either of the variables do not get a value how do I handle that in the code that relies on those values. The Settings class deserializes an xml document and assigned values to properties.
Sub Main()
Dim Appsettings As Settings = Settings.Load("AlertsSettings.xml")
Dim AlertsServer As String
[Code].....
I have an App.conf file which contains:
<?xml version="1.0"?>
<configuration>
<configSections>
[Code].....
As you can see an CrystalReport section is defined in the configSections.
But when I do: config.GetSection("CrystalReport") its returning an DefaultSection object in stead of an SingleTagSectionHandler.
How do I retrieve the Database attribute from the CrystalReport tag using the ConfigurationManager?
I use in my Project the IfExistsTable function; in order to see the existence of a table.
For this purpose I use the Select statement as follows.
MASQLComm = New SqlCommand("SELECT COUNT(*) AS [RecCount] From sys.tables WHERE name Like '%" & tName & "%'", SQLConn)
RecCount = CInt(MASQLComm.ExecuteScalar)
After that I take the number which returned in RecCount. Until now the numbers was 1 and 0
And so I was turn the numbers in True or False.Now suddenly the returned number is 2 which I can't understand what it means.
I am using Enterprise block and not able to figure this out.
I am using oracle procedure for inserting records into the database from my asp.net application in VB.net
Though it is inserting records as it should When I try to access the dataset returned I am not able to see the just inserted record details.
In my Oracle procedure I have Output Cursor which should return several column values from the just inserted record.
I am returning to VB and coding after several years of trying to be out of coding :)
I would like in grabbing data retrieved from a SQL database call into an array of sorts so that I can quickly close the database connection. I am having some trouble remembering how to do this. Most of the posts I've found say to use the dataSet() functionality, but I do not have a table name for the structure to mimic. I am selecting from several tables on a remote server.
