For the life of me, I can't figure out what the problem is with this:
tempData= from a in dx.SomeTable select a;
string searchField="ItemName";
string searchString="BoxPkg";
object[] parameters=new object[]{searchField,searchString};
tempData = tempData.Where("@0 like @1", parameters);
I get this error " {"Expression of type 'Boolean' expected"} "
i am trying to retrieve data from sql database but I get this error: < An expression of non-boolean type specified in a context where a condition is expected, near ')'. > whats this error meaning?
I'm having issues when trying to run my web app. I'm getting an expression expected error at runtime on the portion of my code that is designed to retain the screen position of multiple drag panels.
Code: var target = $this).attr("id");
should return the id of the uniquely named panel so it can be used later in code to identify the _DragPanelExtender.BehaviorID
I haven't been able to verify if the dragPanel's id name is being used, it just errors out here. In the following code, I am attempting to preserve the position of multiple dragPanel's after postback? Code: function pageLoad() {
//get element id name of button clicked var target = $(this).attr("id"); // call the savePanelPosition when the panel is moved $find(target).add_move(savePanelPosition); var elem = $get("<%=HiddenField1.ClientID%>");
I have used the repeater function in an aspx page to create a discussion/fourm style page where user can posts comments, but when I try and write a comment I get this error; Data type mismatch in criteria expression. The user gets to the discussion page from a link in a gridview so that it displays all the posts on the specific film, and the correct posts come up, its just when a user wants to post something themsevles I get the error.This is the code in the discussion.aspx.vb page
I am trying to insert a value in database from a dropdownlistddlvaue = 10.00 - 11.00in db asstarttime=10:00:00endtime=11:00:00using split function
string dropdownvalue = ddlduration.SelectedItem.Text.ToString(); string et = dropdownvalue.Split('-')[1].ToString(); endtime = et.Split(' ')[1].ToString(); starttime = dropdownvalue.Split(' ')[0].ToString(); I am joining date value + time value in the query uisng('" + datevalue + "' + ' ' + '" + starttime + "')
'2014-05-15' + '16.00' --> to get 2014-05-15 16:00:00
it is getting inserted successfullybut while selecting and viewing it from the database I am getting error as,
"Arithmetic overflow error converting expression to data type datetime"
If i mannually enter the date in db it is workingmanuall value=2014-09-30 14:00query value =2014-09-30 14:00
both are same but error is only occuring for query inserted value
I am trying to upload a picture into database using FormView insertItemTemplate. FormView is bounded by objectdatasource.To upload, I placed FileUpload control inside insertItemTemplate.In table the dataType is image.Error:Object of type 'System.Boolean' cannot be converted to type 'System.Byte[]'.
Validate method is supposed to return true/false. The code for Validate method is
<script language="javascript"> function Validate() { var filename = $get('<%= txt_filename.ClientID %>').value; PageMethods.IsValidFile(filename,OnSuccess, OnFailure); // IsValidFile is a Page Method of bool return type } function OnSuccess(result) { if ( !result) { alert('File '+ $get('<%= txt_filename.ClientID %>').value + ' does not exist'); return false; } else { return true; } } function OnFailure(error) { } </script>
My problem is that even after showing the alert 'File somefilename does not exist'. The whole page refreshes (i.e, postback happens)
I have a large existing stored procedure who's interface I cannot change that has several parameters of type boolean. ODP.NET doesn't support a boolean type and I get an error when trying to access this proc via .NET using a different data type.
I am using MySQL 5.5 and i linked it with my ASP.net Application .i added a dataset to link my application within the MySQL stored procedure !!!the problem is when i call any stored procedure which contains BOOLEAN like this one :
I am validating user from Login.xlsx file. It was working fine by validating email and password from that file. For testing i got new file same contents of file but added some more user names. So after that when i validating the user i am getting the following error "Data type mismatch in criteria expression".
But when i replaced the new to old one it is working fine. The contens of both files are the same. So why this kind of error happened.
In my VB.Net code I am using boolean type and it is later stored through a stored procedure to a MS SQL database table. I have so far allways been using "int" as the column type in database table because there is no Boolean type to choose from when designing the columns of a table in the MS SQL Express? Is it correct to use the column type int for storing Boolean values?
What am I missing here?I get the error Declaration Expected @ myPostData=
[Code]....
Dim encoding As New ASCIIEncoding() Dim RateXML As String = "123" 'Format the Data Dim myPostData As Byte() myPostData = encoding.GetBytes(RateXML) ^^^^^^^
I am writing unit tests for fluent Nhibernate, when I run the test in isloation it passes, but when I run multiple tests. or run the test more than once it starts failing with the message below System.ApplicationException : For property 'Id' expected '1' of type 'System.Int32' but got '2' of type 'System.Int32'
I am new to jquery in asp.net mvc2 and was trying to implment a simple jquery function like a show() function on my system but it keeps giving me this error:
One of my sql/ado INSERT commands is not working and I think it might have something to do with the following error I get: "Expected ')' WtrHydInspection.aspx Line:1 Code:0 Char:22" The page runs OK, the error just shows up as a little error icon in the bottom left. I have gone through every page of code that has something to do with the execution, searched for all the parentheses, both left and right, and I can't find a missing one (Regardless if it has something to do with the INSERT not working. I think I should find out what it is and fix it)
Public Class Class1 Dim str As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsMasterMindsMy DocumentsVisual Studio 2008ProjectsWebApplication1WebApplication1indb1.mdb" Dim con As New OleDb.OleDbConnection(str) Public Sub insert(ByVal Nationalty As String, ByVal NationalID As Single, ByVal StNameA As String, ByVal Gender As String, ByVal BirthDate As Date, ByVal Address As String, ByVal TawjehiAvg As Integer, ByVal alfera As String, ByVal Phone As Integer, ByVal Specialization As String, ByVal Period As String) If con.State = ConnectionState.Closed Then con.Open() End If Dim adp As New OleDb.OleDbCommand("insert into stinfo values (" & getmaxid() & ",'" & Nationalty & "'," & NationalID & ",'" & StNameA & "','" & Gender & "','" & BirthDate & "','" & Address & "'," & TawjehiAvg & ",'" & alfera & "'," & Phone & ",'" & Specialization & "','" & Period & "')", con) adp.ExecuteNonQuery() con.Close() End Sub Public Function getmaxid() As Integer Dim z As Integer = 1 If con.State = ConnectionState.Closed Then con.Open() End If Dim adp As New OleDb.OleDbCommand("select max(Stnum) from stinfo", con) Try z = adp.ExecuteScalar Return z + 1 Catch ex As Exception Return z End Try End Function Dim x As New Class1 Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click x.insert(DropDownList5.Text, TextBox1.Text, TextBox2.Text, DropDownList1.Text, TextBox5.Text, TextBox6.Text, TextBox7.Text, TextBox8.Text, TextBox9.Text, DropDownList3.Text, DropDownList4.Text) End Sub