I am getting a Incorrect syntax near the word group in this clause.
from Parser_ocr
Inner Join Parser_ojb on order_no_ocr = order_no_ojb
Inner JOIN RGV_Codes on substring (compl_cde_ojb, 1, 3) = CODE
Inner JOIN csg.hist_sbb_Base on hse_key_ocr = hse_key_sbb
where substring (compl_cde_ojb, 16, 3) = CODE
and ir_tech_ojb between 950 and 999
and compl_dte_ojb BETWEEN '&low' AND '&high'
and prin_ocr = 8600
GROUP BY ir_tech_ojb, substring (compl_cde_ojb, 16, 3),compl_dte_ojb,DES, res_name_sbb, ADDR1_HSE,
job_typ_ojb, job_class_ojb, order_no_ocr, ls_chg_op_id_ocr, CommissionAUT)
group by rollup(TECHN, RESCODE,(COMPLET, DESCRIPTION, NAME, ADDRESS, JOB, TYP, NUMB, OPR))
order by 1, 2,3, 5;
This is the error it gives me for my code and then it calls out line 102. Line 102 is my buildDD(sql, ddlPernames) When I comment out this line the error goes away, but what I don't get is this is the same way I build all of my dropdown boxes and they all work but this one. Could it not like something in my sql select statement. thanksPrivate Sub DDLUIC_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DDLUIC.SelectedIndexChanged Dim taskforceID As Byte = ddlTaskForce.SelectedValueDim uic As String = DDLUIC.SelectedValue sql = "select sidstrNAME_IND from CMS.dbo.tblSIDPERS where sidstrSSN_SM in (Select Case u.strSSN from tblAssignedPersonnel as u " _ & "where u.bitPresent = 1 and u.intUICID in (select intUICID from tblUIC where intTaskForceID = " & taskforceID & " and strUIC = '" & uic & "'))"ddlPerNames.Items.Add(New ListItem("", "0")) buildDD(sql, ddlPerNames)
I keep receiving the following error whenever I try and call this function to update my database.
The code was working before, all I added was an extra field to update.
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WHERE'
Public Sub MasterList_Update(sender As Object, e As DataListCommandEventArgs)
Dim strProjectName, txtProjectDescription, intProjectID, strProjectState as String Dim intEstDuration, dtmCreationDate, strCreatedBy, strProjectLead, dtmEstCompletionDate as String
Dim myConnection As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("connectionstring")) Dim cmdSQL As New SqlCommand(strSQL, myConnection)
What I am trying to create a query to check, If recDT is not value or null, then will use value from SELECT top 1 recDtim FROM Serv. Otherwise, will use the value from recDT. I have tried the below query but it doesn't work. The error says, Incorrect syntax near the keyword 'SELECT'.Incorrect syntax near the keyword 'else'.1 SELECT 2 case when recDT='' then SELECT top 1 recDtim FROM Serv else recDT end 3 FROM abc 4 Anyone can help? Thanks a lot.
I am not sure how to fix this?? Imports System.Data Imports System.Web.UI.WebControls.FormView Imports System.Data.SqlClient Partial Class Assignment Inherits System.Web.UI.Page Protected Sub UpdateButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles UpdateButton.Click Dim empID As Integer Dim nbrID As Integer Dim equid As Integer Dim UpdateQuery Dim empequipid As SqlCommand Dim mySQLConnection As String = System.Configuration.ConfigurationManager.ConnectionStrings("DBConnectionString").ToString Dim myConnection As New SqlConnection(mySQLConnection) myConnection.Open() empID = (Session("UserEmployeeID")) equid = (Session("UserEquipID")) If CType(empID, Integer) = Nothing Then empID = (DropDownList1.SelectedValue) 'Response.Write("Insert: " & empID) 'Response.End() Me.SqlDataSource1.InsertCommand = "INSERT INTO [EMPLOYEES_EQUIP] ([EquipID], [EmployeeID]) VALUES " & equid & " " & empID & "" Me.SqlDataSource1.InsertCommand = SqlDataSourceCommandType.Text Me.SqlDataSource1.Insert() Else empequipid = New SqlCommand("Select EmpEquipID From EMPLOYEES_EQUIP Where EmployeeID = " & empID & " AND EquipID = " & equid & " ", myConnection) empequipid.CommandType = CommandType.Text nbrID = empequipid.ExecuteScalar 'Response.Write("Select EmpEquipID: " & nbrID) 'Response.End() empID = (DropDownList1.SelectedValue) 'Response.Write("<br>Update EmployeeID: " & empID) 'Response.End() Me.SqlDataSource1.UpdateCommand = "UPDATE EMPLOYEES_EQUIP SET EmployeeID = " & empID & " WHERE EmpEquipID = " & nbrID & " " Me.SqlDataSource1.UpdateCommand = SqlDataSourceCommandType.Text Me.SqlDataSource1.Update() <---Right here is displaying "Incorrect syntax near '0'."
'Added to output the Update Query UpdateQuery = "UPDATE EMPLOYEES_EQUIP SET EmployeeID = " & empID & " WHERE EmpEquipID = " & nbrID & " " 'Response.Write(UpdateQuery) 'Response.End() End If 'Updating the session to new EmployeeID Session("UserEployeeID") = (DropDownList1.SelectedValue) 'Response.Write("<br>UserEmployeeID Session: " & Session("UserEmployeeID")) 'Response.End() '-- Turn On Employee Information Table EmpInfo.Visible = True '-- Hides the Employee Name's Drop Down List table. maintable.Visible = False End Sub End Class
Hi,I am trying to test a login form and I get this error message and can't find out why. Istarted out with the Login control, but since I have to try it on the ISP's server, I can't use the SQL Server Managment Studio's integrated authentication. So, I converted the login control to a template and assigned a handler for the login button:protected void LoginButton_Click(object sender, EventArgs e){String usrname = lpLogin.UserName.ToString(); //lpLogin is the <ASP:Login ...>String conString = "Data Source=mylocalserver\SQLEXPRESS;Initial Catalog=LPRU;Integrated Security=True";String selQuery = "SELECT [Password], [FirstName], [LastName] FROM [lpUserInfo] WHERE ([UserID] ='" + usrname + "';";SqlConnection con = new SqlConnection(conString);SqlCommand cmd = new SqlCommand(selQuery, con);con.Open();SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // <--- it says "syntax error near ';' " on this line, I tried it without CommandBehaviorwhile (rdr.Read()){Label1.Text= rdr.GetString(0) + rdr.GetString(1); // for testing purposes, trying to print out first name and last name}rdr.Close();con.Close();}Is there a way of using SQLServer 2000, used by my ISP, and take advantage of .net 2.0's login control, roles, membership, ...? By just using a connection string?
OS: Windows2kPlatform: ASP.Net 2.0.50727DB Server: SQL Server 2000 I'm getting an error that I don't understand, could someone help me please? In the interest of brevity I threw most of the query out (it's a somewhat long join). --- query += "AND TOURNAMENT_ROUNDS.END_TIME BETWEEN ? AND ?"; System.Data.SqlClient.SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.Add("@from",System.Data.SqlDbType.DateTime).Value = from; cmd.Parameters.Add("@to", System.Data.SqlDbType.DateTime).Value = to; SqlDataAdapter da = new SqlDataAdapter(query, connection); da.SelectCommand = cmd; DataSet ds = new DataSet(); int i = 0; try { connection.Open(); da.Fill(ds); --- The da.Fill(ds) is what's throwing. I was under the impression that ADO.Net would handle the syntax so that this shouldn't be a problem. Any idea about what direction I should be looking? If you need me to post more I'll be happy to do that. I've verified that the above is where the exception is throwing by taking out the particular AND clause, and the query worked as expected. Thanks for the help,Michael
Hi Guys,I have moved my asp.net app from access db over to MS SQL 2005 DB.And I have got a slight problem when I go to view any productfor example if I type in the url of http://domain.com/catalog/Details.aspx?AdNum=1I get this errorServer Error in '/catalog' Application.--------------------------------------------------------------------------------Incorrect syntax near '?'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '?'.I have attached the details.aspx.I await for some suggestions.ThanksMatthew
------------------1 <%@ Page MasterPageFile="Classy.master" Explicit="True" Language="VB" Debug="True" %> 2 3 <asp:Content runat="server" ID="HeaderContent" ContentPlaceHolderID="PageHeader"> 4 Ad Detail - <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" /> 5 </asp:Content> 6 7 <asp:Content runat="server" ID="BodyContent" ContentPlaceHolderID="Body" > 8 9 <script runat="server"> 10 Sub Page_Load(ByVal Sender As Object, ByVal E As EventArgs) 11 If Not IsPostBack Then 12 If Request.QueryString("AdNum") = "" Then 13 Response.Redirect("default.aspx") 14 End If 15 EditLink.NavigateUrl = "confirm.aspx?AdNum=" & Request.QueryString("AdNum") 16 End If 17 End Sub 18 19 Protected Sub DetailsView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewPageEventArgs) 20 21 End Sub 22 </script> 23 24 25 <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 26 CellPadding="4" DataKeyNames="AdNum" DataSourceID="SqlDataSource1" ForeColor="#333333" 27 GridLines="None" Height="65px" Width="100%" Font-Names="Arial" Font-Size="8pt" OnPageIndexChanging="DetailsView1_PageIndexChanging"> 28 <RowStyle BackColor="#FFFBD6" ForeColor="#333333" /> 29 <FieldHeaderStyle BackColor="#FFFF99" Font-Bold="True" /> 30 <Fields> 31 <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" /> 32 <asp:BoundField DataField="Category" HeaderText="Category" SortExpression="Category" /> 33 <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" /> 34 <asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" /> 35 <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" /> 36 <asp:TemplateField HeaderText="Email"> 37 <ItemTemplate> 38 <asp:HyperLink ID="HyperLink1" runat="server" Text=Email NavigateUrl='<%# Eval("Email", "mailto:{0}") %>' /> 39 </ItemTemplate> 40 </asp:TemplateField> 41 <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" /> 42 </Fields> 43 </asp:DetailsView> 44 <p><i>To respond to this ad, just click the email address 45 above to send the poster 46 a message.</i></p> 47 If you created this ad, you can 48 <asp:hyperlink id="EditLink" runat="server" >edit or delete it.</asp:hyperlink> <br> 49 <asp:SqlDataSource ID="SqlDataSource1" runat="server" 50 ConnectionString="<%$ ConnectionStrings:classydbConnectionString %>" 51 ProviderName="<%$ ConnectionStrings:classydbConnectionString.ProviderName %>" 52 SelectCommand="SELECT * FROM [Ads] WHERE ([AdNum] = ?)"> 53 <SelectParameters> 54 <asp:QueryStringParameter Name="AdNum" QueryStringField="AdNum" Type="Int32" /> 55 </SelectParameters> 56 </asp:SqlDataSource> 57 58 </asp:content>
Can anyone see why I would get the 'Incorrect Syntax near AS' error in this? USE [SQL2]GO/****** Object: StoredProcedure [dbo].[PlanGroupGrid] Script Date: 06/18/2007 06:07:34 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[PlanGroupGrid]@dp_id intASSELECT tblExpenses.gp_ID, tblExpenses.Amount INTO #tempApExpFROM tblExpensesSELECT tblGroups.dp_id, tblGroups.Group_ID, tblGroups.Group_Type, tblGroups.Group_Purpose, tblGroups.Group_StartDate, tblGroups.Group_EndDate, COALESCE (tblGroups.Group_Goal, 0) AS Goal, SUM(COALESCE(#tempApExp.Amount,0)) AS [Total Expenses], SUM(COALESCE (tblReceipts.AmountPaid, 0)) AS [Total Paid], SUM(COALESCE (tblReceipts.AmountPaid, 0)) - COALESCE (tblGroups.Group_Goal, 0) - SUM(COALESCE(#tempApExp.Amount,0)) AS [Total Expenses], AS VarianceFROM tblGroups LEFT OUTER JOIN tblTracking ON tblGroups.Group_ID = tblTracking.Group_ID LEFT OUTER JOIN tblReceipts ON tblTracking.gp_ID = tblReceipts.gp_ID LEFT OUTER JOIN #tempApExp ON tblTracking.gp_ID = #tempApExp.gp_IDWHERE (tblGroups.dp_id = @dp_id)GROUP BY tblGroups.dp_id, tblGroups.Group_ID, tblGroups.Group_Type, tblGroups.Group_Purpose, tblGroups.Group_StartDate, tblGroups.Group_EndDate, tblGroups.Group_GoalIf Exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tempApExp]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)Drop table #tempApExp
I'm getting a pop up error "Incorrect syntax near the keyword 'ORDER'. Can someone please tell me what is wrong with my code? It worked before I added the underlined part. If FoundChecked = True Then
Dim SQLString As String SQLString = "SELECT ID, Bedrooms, Bathrooms, Location, Rent FROM ListingsTable WHERE " For Each Item In LocationList.Items If Item.Selected Then SQLString &= " Location = '" & Item.Value & "' OR " & "" & " ORDER BY Location" ----------------------This is the problem End If
Hi I'm trying to lookup a sigle value from an MS SQL Express database. However, I get an error - Incorrect Syntax near '' - when executing the code. The line in bold below is what is highlighted on the error I get back. Please Help!! The code is below Thanks Dim oSQLConn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection()oSQLConn.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|SDCentral.mdf;Integrated Security=True;User Instance=True"oSQLConn.Open() Dim ValExtract As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("SELECT * FROM ProjectsQRY", oSQLConn) Dim Get1 As Int32 = CInt(ValExtract.ExecuteScalar()) Me.Active1.Text = Get1 oSQLConn.Close()
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near ')'.Source Error:
Line 42: objAdapter.SelectCommand = New System.Data.SqlClient.SqlCommand(strSQL, objConn)Line 43: ' Fill the dataset.Line 44: objAdapter.Fill(objDataset)Line 45: ' Create a new view.Line 46: Dim oView As New DataView(objDataset.Tables(0))
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim AllorOne As String Dim company As String
AllorOne = Request.QueryString("AllorOne") company = Request.QueryString("company")
' Create a connection and open it. Dim objConn As New System.Data.SqlClient.SqlConnection("User ID=******;Password=******;Initial Catalog=customer_config;Data Source=rqa4-sql01;") objConn.Open()
Dim strSQL As String Dim objDataset As New DataSet() Dim objAdapter As New System.Data.SqlClient.SqlDataAdapter()
' Get all the sql If AllorOne = "All" Then strSQL = "SELECT [Company_Name] as 'Company Name', [Entity_Code] as 'Entity Code', [YTD_Transactions] as 'YTD_Transactions', [Num_Reports_DB] as 'Num_Reports_DB', [Reports_Advanced_Workflow] as 'Reports_Advanced_Workflow', [Has_Customization] as 'Has_Customization',[TA_Trans_All] as 'TA Trans All', [TA_Trans_US] as 'TA Trans US', [Using_VAT] as 'Using VAT', [Total_Users] as 'Total Users',[Non_English_Langages] as 'Non English Langages',[Non_English_Users] as 'Non English Users', [Using_Offline] as 'Using Offline', [Using_Audit_Services] as 'Using Audit Services' from(v_customer_master_list) order by company_name" Else strSQL = "SELECT [Company_Name] as 'Company Name', [Entity_Code] as 'Entity Code', [YTD_Transactions] as 'YTD_Transactions', [Num_Reports_DB] as 'Num_Reports_DB', [Reports_Advanced_Workflow] as 'Reports_Advanced_Workflow', [Has_Customization] as 'Has_Customization',[TA_Trans_All] as 'TA Trans All', [TA_Trans_US] as 'TA Trans US', [Using_VAT] as 'Using VAT', [Total_Users] as 'Total Users',[Non_English_Langages] as 'Non English Langages',[Non_English_Users] as 'Non English Users', [Using_Offline] as 'Using Offline', [Using_Audit_Services] as 'Using Audit Services' from(v_customer_master_list) where lower(company_name) like '%" & company & "%' order by company_name" End If
objAdapter.SelectCommand = New System.Data.SqlClient.SqlCommand(strSQL, objConn) ' Fill the dataset. objAdapter.Fill(objDataset) ' Create a new view. Dim oView As New DataView(objDataset.Tables(0)) ' Set up the data grid and bind the data. SimpleDataGrid.DataSource = oView SimpleDataGrid.DataBind()
End Sub
Can anyone tell me what causes this type of error, what they think is wrong, or what IS wrong if someone wants to take the time to go through the code. Anything helps. Eh, I feel like one of those guys on a street corner with a sign when I say that.
Could someone please tell me what is wrong with the following? Thanks! Dim objcmd As New SqlCommand Dim link As String Dim pocount As Integer objConn.Open()objcmd = New SqlCommand("SELECT COUNT(PONumber) FROM (SELECT PONumber FROM BOL_Dtl GROUP BY PONumber, BOLNumber HAVING BOLNumber = @BOLNumber)", objConn) objcmd.Parameters.Add("@BOLNumber", SqlDbType.Int, 4)objcmd.Parameters("@BOLNumber").Value = Int32.Parse(Request.QueryString("BOLNumber")) pocount = objcmd.ExecuteScalar()
Hi, I have a table 'MemberPayment', into which I would like to pass a derived value, and a value from another table (table 'Vehicle', value 'Registration'). However, I keep getting errors with my syntax... would anybody be able to kindly tell me where I am going wrong? My code is;Declare @Total int Declare @Registration str SELECT (@Registration=(Vehicle.Registration), @Total=((MileageHistory.MileageUrban * Vehicle.EmissionsPerGramUrban) * 0.05) + ((MileageHistory.MileageCountry * Vehicle.EmissionsPerGramUrban) * 0.05) ) FROM [NeuCar].[dbo].[MileageHistory] JOIN [NeuCar].[dbo].[Vehicle] ON MileageHistory.Registration = Vehicle.Registration JOIN [NeuCar].[dbo].[Member] ON Vehicle.UserName = Member.UserName WHERE Member.UserName = 'wenger1' AND (MileageHistory.[Date] >= CURRENT_TIMESTAMP - 30) INSERT INTO MemberPayment (Registration, TotalCharge) VALUES ( @Registration, @Total ) Many thanks for your time, Best regards, Chima
Hi All, When binding my dropdownlist I get this error: Incorrect syntax near '?'. My code behind: 'Set country drop list value c = Request.QueryString("c") ddlCountry.SelectedValue = c 'Begin populating if country has been selected ddlLeaveType.DataBind() My HTML: <asp:DropDownList ID="ddlLeaveType" runat="server" CssClass="AdminLeaveDDL" DataSourceID="SDSLeaveTypes" DataTextField="Description" DataValueField="PTO_Leave_Type_ID"></asp:DropDownList> <asp:SqlDataSource ID="SDSLeaveTypes" runat="server" ConnectionString="<%$ ConnectionStrings:PTOTrackConnectionString %>" ProviderName="<%$ ConnectionStrings:PTOTrackConnectionString.ProviderName %>" SelectCommand="SELECT PTO_Leave_Type_ID, Description FROM PTO_Leave_Type WHERE PTO_Leave_Type_ID NOT IN (SELECT PTO_Leave_Type_ID FROM PTO_Country_Leave_Type WHERE Country_ID = ?) ORDER BY Description"> <SelectParameters> <asp:QueryStringParameter Name="CountryID" QueryStringField="c" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> If I rund the query in sql management studio and replace the ? with a valid id, it runs fine. Thanks, Mark
Could someone please explain why the above error occurs ? Dim connString As String = ConfigurationManager.AppSettings("Fleetcube.ConnectionString") Dim myConnection As New System.Data.SqlClient.SqlConnection(connString)Dim Str As String = "UPDATE [sec_Administrator] SET [EmailAddress] = ?, [Password] = ?, [SecurityQuestion] = ?, [SecurityAnswer] = ? WHERE [id] = " & Session.Item("Admin_id") Dim cmd As New System.Data.SqlClient.SqlCommand(Str, myConnection)Dim ds As New DataSetDim da As New SqlClient.SqlDataAdapter(cmd)
I am getting the error Incorrect syntax near ',' while executing a query. Here is tha code snippet.String querystring="update dbo.cstd_incident_survey set Question1="+q1+",Question2="+q2+",Question3="+q3+",Question4="+q4+ ",survey_date= '" + surveydate.ToString() + "'where incident_id='" + dr3[0]+"'";SqlCommand query4 = new SqlCommand(querystring , newconnection); query4.ExecuteNonQuery(); Please help. Thanks in advance, Sangita
some one can help me about this error..i always get the error like this..but stilll dun know exactly what the error..pls help me.. here the message
Incorrect syntax near the keyword 'user'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'user'.
Source Error:
Line 51: Dim objdr As SqlDataReader Line 52: conn.Open() Line 53: objdr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection) Line 54: List1.DataSource = objdr Line 55: List1.DataValueField = "user_id"
I try to use stored procedure to do a search for Email column. But I always get a error "Incorrect syntax near '.'", when I input keyword like "ash11.tw." And if I put keyword without dot, it works fine. It seems like the dot caused the problem. But I dont know how to fix it. Can someone help me out? Thanks. My where expression is following. @spWhereSearch = 'where cont.Email like "%' + @Email + '%"'
objConn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
objCmd = new SqlCommand("SELECT * FROM catalogue WHERE Title =" + Request.QueryString["detail"], objConn); objConn.Open(); objRdr = objCmd.ExecuteReader(); DataList1.DataSource = objRdr; DataList1.DataBind(); objRdr.Close(); objConn.Close();
I am trying to select records from the database where they match the query string. However when I run it, i get an error at objRdr = objCmd.ExecuteReader();, incorrect Syntax Near, and the name of the query string
I keep getting this error...? Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'c'. Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
I think it talking about my SQL Query...?? If you could help me it would greatly appreciated! Thanks strSQLQuery = "Select c.EmployeeID, c.[FirstName] as UserFirstName, c.[LastName] as UserLastName, eqtype.[Description] as UserEquipType, eq.[SerialNo] as UserSerialNum from EMPLOYEES c LEFT OUTER JOIN EQUIPMENT as eq on eq.EmployeeID = c.EmployeeID LEFT OUTER JOIN EQUIP_TYPE as eqtype on eqtype.EquipTypeID = eq.EquipTypeID"
hi I get this error when i am trying to run the query on profiler : 'SELECT People.People, People.Name, Sum(IIf(IsNull([ProjectStatusReport]![Week]),0,IIf([ProjectStatusReport]![Week]=#8/20/2004#,1,0))) AS Created, Sum(IIf(IsNull([ProjectStatusReport]![Week]),0,IIf([ProjectStatusReport]![Week]=#8/20/2004#,IIf(IsNull([ProjectStatusReport]![Accomplishments]) Or IsNull([ProjectStatusReport]![Plans]),0,1),0))) AS Complete, People.email FROM (((Register INNER JOIN SR_Status ON Register.SR_Status = SR_Status.SR_Status) LEFT JOIN ProjectStatusReport ON Register.Register = ProjectStatusReport.Project) INNER JOIN StakeHolders ON Register.Register = StakeHolders.Register) INNER JOIN People ON StakeHolders.People = People.People WHERE (((SR_Status.Status)='Active') AND ((StakeHolders.Status)=Yes)) GROUP BY People.People, People.Name, People.email HAVING (((Sum(IIf(IsNull([ProjectStatusReport]![Week]),0,IIf([ProjectStatusReport]![Week]=#8/20/2004#,1,0))))>0) AND ((Sum(IIf(IsNull([ProjectStatusReport]![Week]),0,IIf([ProjectStatusReport]![Week]=#8/20/2004#,IIf(IsNull([ProjectStatusReport]![Accomplishments]) Or IsNull([ProjectStatusReport]![Plans]),0,1),0))))>0)) ORDER BY People.People'
I have text 060108 that I want to read 06/01/08. Here is what works. left (oaentdate,2) + '/' + substring (oaentdate,3,2) + '/' + substring (oaendate,5,2) However, I can't place it in the Query Select statement.
I think I have a problem with a table in my database. When I use MSQuery I choose my data source, login to my databse and then I choose the table I want to query. The table I choose to query is "File." I add my columns and, I do not choose any filtering or any criteria. Once I hit finish, I get prompted with this:
Incorrect Syntax near the keyword 'File'. Statment(s) could not be prepared.
This is the only table in the database that this message comes up on, well that I have noticed so far. I can query other tables just fine but I am unable to query this one. It's strange because I log onto the server that is hosting the database and use Enterprise Manager and I am able to query the table this way. Why would it not allow me to query this specific table from my machine?
Hello all,Newbie here.SQL 2000, Windows 2000I'm trying to alter tables in my SQL DB using statements like the following:/* AD_GROUPS */alter table AD_GROUPS alter column AD_GROUP_NAME nvarchar(64)not nullgo/* ARTICLES */alter table ARTICLES add column CONTENTTYPE_REF int nullgoI get error messages like:Server: Msg 156, Level 15, State 1, Line 3Incorrect syntax near the keyword 'column'I got the statements straight out of the Microsoft book "Inside MicrosoftSQL Server 2000"Thanks in advance for helping to train this raw recruit!Jake
