Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







INCORRECT SYNTAX NEAR &"STRING&" FOR ALTER SQL


HELP


I am trying to create a new column for every file in a folder
but i keep getting an sql exception  - incorrect syntax near ' whatever the value of the file name is'
it works if i just type in the value directly
my code look like this

 
fsofolder = CreateObject("Scripting.FileSystemObject")

        folder = fsofolder.GetFolder("the path to the Files")

        files = folder.Files

        For Each objfile In files

            sname = objfile.Name

                  

            cmd3.CommandText = "ALTER TABLE NEW ADD " & "' " & sname & " ' " & " nvarchar(MAX)"



            DatabaseConnection.Open()



            Try



                cmd3.Connection = DatabaseConnection

                cmd3.ExecuteNonQuery()

            Catch ex As SqlException

                MsgBox(ex.Message)

            End Try



            DatabaseConnection.Close()


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Line 1: Incorrect Syntax Near :'m' / Unclosed Quotation Mark Before The Character String '.
Hello,
Can anybody help me with this error , System.Data.SqlClient.SqlException. "Line 1: Incorrect Syntax near :'m' ."

I have a textbox named DESCRIPTION and am trying to insert the values entered by user in this textbox.

It works well if a user types " I am unable to " but it throws this error when a user types " I'm unable to "...because of I'm ..
How do i fix this?


My Query:

strSQL = "Insert into ABC(DESCRIPTION) values('" & strDescription & "')"

When i trybelow queryin query analyser , am getting this error ....
Error 1: [Line 1: Incorrect syntax near 'm'.]
Error 2: [ Unclosed quotation mark before the character string '.]

updateABC set DESCRIPTION = 'I'm unable' WHERE ABC_ID = '142'

Thanks to reply.





View Replies !   View Related
Alter Column Results In Incorrect Syntax Near 'column'
I ran this query against the pubs database and it runs successfully

ALTER TABLE publishers ALTER COLUMN state CHAR(25)

I change the table & field names for my db as follows:
ALTER TABLE customquery ALTER COLUMN toclause CHAR(25)

and run against my database and I get the following error - Incorrect syntax near 'COLUMN'.

My column name is correct - I don't know why it would run fine against pubs, but not my db. I do not have quoted identifiers turned on. I have tried using [] around my column name [toclause], but that didn't change anything. Any help would be appreciated.
Thanks.

View Replies !   View Related
Incorrect Syntax Near The Keyword 'from'. Line 1: Incorrect Syntax Near ')'.
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)
 
End Sub

View Replies !   View Related
Incorrect Syntax Near The Keyword CONVERT When The Syntax Is Correct - Why?
Why does the following call to a stored procedure get me this error:


Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'CONVERT'.




Code Snippet

EXECUTE OpenInvoiceItemSP_RAM CONVERT(DATETIME,'01-01-2008'), CONVERT(DATETIME,'04/30/2008') , 1,'81350'




The stored procedure accepts two datetime parameters, followed by an INT and a varchar(10) in that order.

I can't find anything wrong in the syntax for CONVERT or any nearby items.


Help me please. Thank you.

View Replies !   View Related
Incorrect Syntax When There Appears To Be No Syntax Errors.
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

strProjectName = CType(e.Item.FindControl("txtProjectName"), TextBox).Text
txtProjectDescription = CType(e.Item.FindControl("txtProjDesc"), TextBox).Text
strProjectState = CType(e.Item.FindControl("txtStatus"), TextBox).Text
intEstDuration = CType(e.Item.FindControl("txtDuration"), TextBox).Text
dtmCreationDate = CType(e.Item.FindControl("txtCreation"),TextBox).Text
strCreatedBy = CType(e.Item.FindControl("txtCreatedBy"),TextBox).Text
strProjectLead = CType(e.Item.FindControl("txtLead"),TextBox).Text
dtmEstCompletionDate = CType(e.Item.FindControl("txtComDate"),TextBox).Text
intProjectID = CType(e.Item.FindControl("lblProjectID"), Label).Text

Dim strSQL As String
strSQL = "Update tblProject " _
& "Set strProjectName = @strProjectName, " _
& "txtProjectDescription = @txtProjectDescription, " _
& "strProjectState = @strProjectState, " _
& "intEstDuration = @intEstDuration, " _
& "dtmCreationDate = @dtmCreationDate, " _
& "strCreatedBy = @strCreatedBy, " _
& "strProjectLead = @strProjectLead, " _
& "dtmEstCompletionDate = @dtmEstCompletionDate, " _
& "WHERE intProjectID = @intProjectID"

Dim myConnection As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("connectionstring"))
Dim cmdSQL As New SqlCommand(strSQL, myConnection)

cmdSQL.Parameters.Add(new SqlParameter("@strProjectName", SqlDbType.NVarChar, 40))
cmdSQL.Parameters("@strProjectName").Value = strProjectName
cmdSQL.Parameters.Add(new SqlParameter("@txtProjectDescription", SqlDbType.NVarChar, 30))
cmdSQL.Parameters("@txtProjectDescription").Value = txtProjectDescription
cmdSQL.Parameters.Add(new SqlParameter("@strProjectState", SqlDbType.NVarChar, 30))
cmdSQL.Parameters("@strProjectState").Value = strProjectState
cmdSQL.Parameters.Add(new SqlParameter("@intEstDuration", SqlDbType.NVarChar, 60))
cmdSQL.Parameters("@intEstDuration").Value = intEstDuration
cmdSQL.Parameters.Add(new SqlParameter("@dtmCreationDate", SqlDbType.NVarChar, 15))
cmdSQL.Parameters("@dtmCreationDate").Value = dtmCreationDate
cmdSQL.Parameters.Add(new SqlParameter("@strCreatedBy", SqlDbType.NVarChar, 10))
cmdSQL.Parameters("@strCreatedBy").Value = strCreatedBy
cmdSQL.Parameters.Add(new SqlParameter("@strProjectLead", SqlDbType.NVarChar, 15))
cmdSQL.Parameters("@strProjectLead").Value = strProjectLead
cmdSQL.Parameters.Add(new SqlParameter("@dtmEstCompletionDate", SqlDbType.NVarChar, 24))
cmdSQL.Parameters("@dtmEstCompletionDate").Value = dtmEstCompletionDate
cmdSQL.Parameters.Add(new SqlParameter("@intProjectID", SqlDbType.NChar, 5))
cmdSQL.Parameters("@intProjectID").Value = intProjectID

myConnection.Open()
cmdSQL.ExecuteNonQuery
myConnection.Close()

MasterList.EditItemIndex = -1
BindMasterList()


End Sub

Thankyou in advance.

View Replies !   View Related
Incorrect Syntax Near The Keyword 'SELECT'.Incorrect Syntax Near The Keyword 'else'.
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.

View Replies !   View Related
Incorrect Syntax Near ','
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

View Replies !   View Related
Incorrect Syntax Near '?'.
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)
 
cmd.Parameters.Add("EmailAddress", SqlDbType.VarChar).Value = txtadmin_email.Text
cmd.Parameters.Add("Password", SqlDbType.VarChar).Value = txtadmin_pass.Text
cmd.Parameters.Add("SecurityQuestion", SqlDbType.VarChar).Value = txtadmin_SecQues.Text
cmd.Parameters.Add("SecurityAnswer", SqlDbType.VarChar).Value = txtadmin_SecAns.Text
cmd.Connection.Open()
cmd.ExecuteNonQuery()

View Replies !   View Related
Incorrect Syntax Near '?'.
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

View Replies !   View Related
Incorrect Syntax
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

View Replies !   View Related
Incorrect Syntax
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()

View Replies !   View Related
Incorrect Syntax Near '='
Hi there
I'm getting an Incorrect syntax near '='. error when I click update in my gridview.
Any ideas?
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Taskdb %>"            SelectCommand="SELECT [taskid], [taskname], [taskdescription], [taskstatus] FROM [tblTask]"            UpdateCommand="UPDATE [tbltask) set [taskname] = @taskname, [taskdescription] = @taskdescription, [taskstatus] = @taskstatus where [taskid] = @taskid">            <UpdateParameters>                <asp:Parameter Type="String" Name="taskname" />                <asp:Parameter Type="String" Name="taskdescription" />                <asp:Parameter Type="Int16" Name="taskstatus" />                <asp:Parameter Type="Int16" Name="taskid" />            </UpdateParameters>        </asp:SqlDataSource> Thanks in advance.

View Replies !   View Related
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 ')'.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.

View Replies !   View Related
Incorrect Syntax Near ''
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()
 

View Replies !   View Related
Incorrect Syntax
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

View Replies !   View Related
Incorrect Syntax Near AS
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 

View Replies !   View Related
Incorrect Syntax Near '?'.
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 &nbsp;
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>
 

View Replies !   View Related
Incorrect Syntax Near '?'. Help Please
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 

View Replies !   View Related
Incorrect Syntax Near...
Hello all,
here is my code

 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

Anyone have an idea?

Thanks

View Replies !   View Related
Incorrect Syntax Near ';'
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?  

View Replies !   View Related
Incorrect SQL Syntax Near......
Why am I getting this error. 
 
[SqlException (0x80131904): Incorrect syntax near '.123'.]   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857418   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735030   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135   WebApplication10.Edit.dgrdEdit_UpdateCommand(Object source, DataGridCommandEventArgs e) in C:Inventoryedit.aspx.vb:186   System.Web.UI.WebControls.DataGrid.OnUpdateCommand(DataGridCommandEventArgs e) +105   System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +471   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35   System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +117   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35   System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +163   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

View Replies !   View Related
Incorrect Syntax Near '0'. Where Is The 0 At???
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

View Replies !   View Related
Incorrect Syntax Near....??
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:




[SqlException (0x80131904): Line 1: Incorrect syntax near 'c'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +177
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +68
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2305
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +294
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1021
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +314
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +20
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +107
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +10
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1659
System.Web.UI.WebControls.BaseDataList.GetData() +53
System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource) +267
System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +56
System.Web.UI.WebControls.BaseDataList.DataBind() +62
System.Web.UI.WebControls.BaseDataList.EnsureDataBound() +55
System.Web.UI.WebControls.BaseDataList.CreateChildControls() +62
System.Web.UI.Control.EnsureChildControls() +97
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5729

 
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"
 

View Replies !   View Related
Incorrect Syntax Near '.'
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 + '%"'

View Replies !   View Related
Incorrect Syntax
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"


Source File: c:inetpubwwwroot
egisterupdate.aspx.vb Line: 53

Stack Trace:


[SqlException: Incorrect syntax near the keyword 'user'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
register.update.binddata() in c:inetpubwwwroot
egisterupdate.aspx.vb:53
register.update.Page_Load(Object sender, EventArgs e) in c:inetpubwwwroot
egisterupdate.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()




--------------------------------------------------------------------------------

View Replies !   View Related
Incorrect Syntax
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

View Replies !   View Related
Incorrect Syntax Near....
I don't find this syntax error in my T-SQL script - any idea?

declare @sql varchar(1000)
select @sql = 'INSERT DBCleanerTemp (TableName, trxYearMonthStart, nmbrtrx)'
select @sql = @sql + ' Select ''' + @ProcessTable + ''''
select @sql = @sql + ', ''+ CONVERT(varchar(6), ' + @SelectedColumn + ', 112) + ''01'''
select @sql = @sql + ', count(*)'
select @sql = @sql + ' from ' + @ProcessTable
select @sql = @sql + ' group by '' + CONVERT(varchar(6), ' + @SelectedColumn + ', 112) + ''01'''
print @sql
exec (@sql)

Output:

INSERT DBCleanerTemp (TableName, trxYearMonthStart, nmbrtrx) Select 'opms..Transactions', '+ CONVERT(varchar(6), TransactionDateStamp, 112) + '01', count(*) from opms..Transactions group by ' + CONVERT(varchar(6), TransactionDateStamp, 112) + '01'

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '01'.

View Replies !   View Related
Incorrect Syntax Near '='
I am getting the above error on the following code:

substrSql = "SELECT SUBCAT_NAME FROM DL_SUBCATEGORIES where SUBCAT_ID =" & intDLCATEGORY & ""
dim rssubCat
set rssubCat = server.CreateObject("adodb.recordset")
rssubCat.Open substrSql, my_Conn

can anyone tell me why the syntax is incorrect??

View Replies !   View Related
Incorrect Syntax Near '!'
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'

Can anyone suggest the possible reason?

Regards

View Replies !   View Related
Incorrect Syntax Near '='
Can anyone tell me how to correct this error message: Line 9: Incorrect syntax near '='.
Code:

SELECT customerId AS "Customer ID", lastName AS "Last Name", phone AS "Phone", DATENAME(MONTH, saleDate) + ' ' + DATENAME(DAY, saleDate) + ', ' + DATENAME(YEAR, saleDate) AS "Sale Date" FROM Customer, Sale WHERE saleDate BETWEEN (DATENAME(MONTH, saleDate) = 'June' DATENAME(DAY, saleDate) = '1') AND(DATENAME(MONTH, saleDate) = 'June' DATENAME(DAY, saleDate) = '7')

Perhaps I defined my variables wrong?

View Replies !   View Related
Incorrect Syntax
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.

What am I doing wrong?

Lisa Jefferson

View Replies !   View Related
Incorrect Syntax
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?

View Replies !   View Related
Incorrect Syntax Near ';'
I dont have any idea why this code won't work?

create table tblSiteName (
SiteNameID int not null,
SiteName char(100),
Primary Key (SiteNameID));

The error says: Incorrect syntax near ';'.



===============
JSC0624
===============

View Replies !   View Related
Incorrect Syntax
Hello,

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;


What do I need to fix?

Thanks,

Kurt

View Replies !   View Related
Incorrect Syntax Near '?'
Hello. When I run my application (it's used to place
orders) in VB.net I get the following message: "Failed to complete
order! Reason: Incorrect syntax near 'champnr'. Incorrect syntax near
'?'. At System.Data.Sqlclient.Sqlcommand.ExecuteReader(CommandBehaviour
cmdBehaviour, Runbehavior runbehavior, Boolean returnStream)

Here is a part of the code:



Me.NewOrder.CommandText = "INSERT INTO TTOrder (beskrivning, bestallarnr, bestdatum, bolagsnr, champnr, " & _

"costcenter, doknr,
doktypnr, ordernr, projekt, timenr, ttkommentar, volvokomment" & _

"ar) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

Me.NewOrder.Connection = Me.sqlOrderDb


Me.NewOrder.Parameters.Add(New
System.Data.SqlClient.SqlParameter("beskrivning",
System.Data.SqlDbType.NVarChar, 0, "beskrivning"))


Me.NewOrder.Parameters.Add(New
System.Data.SqlClient.SqlParameter("bestallarnr",
System.Data.SqlDbType.Int, 0, "bestallarnr"))


Me.NewOrder.Parameters.Add(New
System.Data.SqlClient.SqlParameter("bestdatum",
System.Data.SqlDbType.DateTime, 0, "bestdatum"))


Me.NewOrder.Parameters.Add(New
System.Data.SqlClient.SqlParameter("bolagsnr",
System.Data.SqlDbType.Int, 0, "bolagsnr"))


Me.NewOrder.Parameters.Add(New
System.Data.SqlClient.SqlParameter("champnr",
System.Data.SqlDbType.NVarChar, 255, "champnr"))



Any ideas? I'm not using any stored procedures. Maybe I should?

View Replies !   View Related
Incorrect Syntax Near ')'
Hello,

I'm getting Incorrect syntax near ')' in my user defined function on my else statement inside of my CASE statement. My code is below and I appreciate your help in advance. Also, I tried removing the parenthesis from my subselect and it still didn't work.




Code Snippet
CREATE FUNCTION [dbo].[fncUseRateOverride]
(
@CMRNum char(3),
@AcctNum char(4),
@DirNum int
)
RETURNS money
AS
BEGIN
DECLARE @DirectoryTotal money
Select
@DirectoryTotal = @DirectoryTotal + Total
From
(SELECT Total =
CASE
WHEN OD.SpecialRate IS NOT NULL THEN OD.SpecialRate
ELSE dbo.fncGetAdUnitRate(OH.DirNum,OD.AdUnitID)) END
FROM OrderHeader OH
INNER JOIN v_CurrentDirsDetail DD
ON OH.DirNum = DD.DirID
AND OH.DirVer = DD.DirVer
INNER JOIN OrderDetail OD
ON OD.Orderheaderid = OH.OrderHeaderid
INNER JOIN v_TranslationTable CMR
ON OH.ClientID = CMR.DatatechClient
AND OH.ProductID = CMR.DatatechProduct
WHERE CMR.CMRNum = @CMRNum
AND CMR.AcctNum = @AcctNum
AND OH.DirNum = @DirNum
AND OD.AdUnitID IS NOT NULL) as STBTable
Return @DirectoryTotal

END




View Replies !   View Related
Incorrect Syntax Near'='


Hi can any please help me in finding the solution for the error...

Incorrect syntax near'='

The SP was working fine till 2 days ago we are about to give live and gving the error...
Any suggestiongs very much appreciated

Thanks In advance

View Replies !   View Related
Incorrect Syntax Near ''
hi! i'm using a linked server and currently executing this query:

"insert intotbl_local (fieldname)" +

"select * from openquery(serverinstance_remote, 'selectfieldname from db_remote.dbo.tbl_remote')";

when i run this on a C# program it gives me the error of 'incorrect syntax near '''. What should i do with this? please help!!

View Replies !   View Related
Incorrect Syntax


Hi there,

I am trying to create a repeater control that display content of the database (very simple one) after a button has been clicked. I hit an obstacle that I cant figure out - maybe because I am novice to the subject
The whole thing is placed inside the asp page.
Connection string, database name etc everything is correct. Just cant get it to work.

anyway here's the code:


Public Class MyTemplate

Implements System.Web.UI.ITemplate

Dim templateType As ListItemType

Sub New(ByVal type As ListItemType)

templateType = type

End Sub

Public Sub InstantiateIn(ByVal container As System.Web.UI.Control) _

Implements System.Web.UI.ITemplate.InstantiateIn

Dim ph As New PlaceHolder()

Dim item1 As New Label()

item1.ID = "item1"

Select Case (templateType)

Case ListItemType.Header

ph.Controls.Add(New LiteralControl("<table border=""1"">" & "<td><b>Guide Name</b></td></tr>"))

Case ListItemType.Item

ph.Controls.Add(New LiteralControl("</td><td>"))

ph.Controls.Add(item1)

ph.Controls.Add(New LiteralControl("</td></tr>"))

AddHandler ph.DataBinding, New EventHandler(AddressOf Item_DataBinding)

Case ListItemType.AlternatingItem

ph.Controls.Add(New LiteralControl("</td><td>"))

ph.Controls.Add(item1)

ph.Controls.Add(New LiteralControl("</td></tr>"))

AddHandler ph.DataBinding, New EventHandler(AddressOf Item_DataBinding)

Case ListItemType.Footer

ph.Controls.Add(New LiteralControl("</table>"))

End Select

container.Controls.Add(ph)

End Sub

End Class

Shared Sub Item_DataBinding(ByVal sender As Object, ByVal e As System.EventArgs)

Dim ph As PlaceHolder = CType(sender, PlaceHolder)

Dim ri As RepeaterItem = CType(ph.NamingContainer, RepeaterItem)

Dim item1Value As String = _

Convert.ToString(DataBinder.Eval(ri.DataItem, "SectionContent"))

CType(ph.FindControl("item1"), Label).Text = item1Value

End Sub

Protected Sub LinkSoftIns_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles LinkSoftIns.Click

Dim conn As New System.Data.SqlClient.SqlConnection( _

ConfigurationManager.ConnectionStrings("ResourceDBMovConnectionString").ConnectionString)

Dim sqlDataAdapter1 As System.Data.SqlClient.SqlDataAdapter

Dim dsCategories1 As System.Data.DataSet

sqlDataAdapter1 = New System.Data.SqlClient.SqlDataAdapter( _

"SELECT [SectionContent] FROM (guideContent) WHERE [Guide_ID] = '5'", conn)

dsCategories1 = New System.Data.DataSet()

Repeater1.HeaderTemplate = New MyTemplate(ListItemType.Header)

Repeater1.ItemTemplate = New MyTemplate(ListItemType.Item)

Repeater1.AlternatingItemTemplate = New MyTemplate(ListItemType.AlternatingItem)

Repeater1.FooterTemplate = New MyTemplate(ListItemType.Footer)

sqlDataAdapter1.Fill(dsCategories1, "guideContent") 'here i get the incorrect syntax near ")" error.

Repeater1.DataSource = dsCategories1.Tables("guideContent")

Repeater1.DataBind()

End Sub


After that goes the repeater code:

<asp:Repeater id="Repeater1" runat="server"></asp:Repeater>



Thx,
Marek

View Replies !   View Related
Incorrect Syntax


hey guys
i am running a query, but i have a error message that smething happend close to as, i did many changes, but i ca not find the error.


((4 * dbo.Drillability.WEIGHTONBIT)/ (POWER(PD_Data.dbo.db_drill_hole_base.loaded_diameter, 2) * PI())

+ ((8 * dbo.Drillability.RPM * dbo.Drillability.TORQUE*12) / (POWER(PD_Data.dbo.db_drill_hole_base.loaded_diameter, 2) * (CASE WHEN dbo.Drillability.ROP<1 THEN dbo.Drillability.ROP*60*12 ELSE dbo.Drillability.ROP/60*12 END) * 0.006894757 as SPEC_ENERGY_MPa


for me looks good
cheers
edwin


View Replies !   View Related
Incorrect Syntax Near The Keyword 'AS'.
Hi,I was just wondering if some kind soul on here could help me.   I created a table in a database with called 'EuropeBroadcastList', with the following columns: Name, First Name, First, Last Name, Last, Title, Company, Photo.I have created a query whereby I want to create a new table with only specific columns called 'EuropeBroadcastSorted' and sort the names in 'EuropeBroadcastList' by the 'Last' column.  The query is: CREATE TABLE europebroadcastsorted    AS (SELECT [name], title, company, photo, [Last]    FROM EuropeBroadcastList    ORDER BY Last ASC); When I execute it I get the following syntax errors: Msg 156, Level 15, State 1, Line 2Incorrect syntax near the keyword 'AS'.Msg 156, Level 15, State 1, Line 4Incorrect syntax near the keyword 'ORDER'.Can any kind person help me resolve this?Thanks Rob 

View Replies !   View Related
Incorrect Sql Syntax Word
Here is a selected change index I wrote but does not like when I try to build the mydatatable.  Te sql works fine in sql query. So it has to be some way I am building the tables.  The error I get is
Line 1: Incorrect syntax near 'BENJAMIN'.
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: Line 1: Incorrect syntax near 'BENJAMIN'
 
Benjamin would be the middle name of said subject in the name field which comes from the dropdown list (Pername).  Any help is appreciated.
Private Sub ddlPerNames_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlPerNames.SelectedIndexChangedDim Pername As String = ddlPerNames.SelectedValue
sql = "select sidstrSSN_SM, sidstrGR_ABBR_CODE + '/' + sidstrPAY_GR, case when sidstrTECH_SVC_CODE in ('M', 'R', 'S', 'T', 'U', 'Z') then " _
& "case when sidstrACT_STAT_PROG in ('5', 'A', 'E', 'F', 'N', 'R', 'S', 'T') then 'AGR' else 'TECH' end else 'M-day' end, " _
& "sidstrST_ADDR + ',' + sidstrADDR_CITY + ',' + sidstrSTATES_US + ',' + sidstrZIP_CODE from cms.dbo.tblSIDPERS where " _
& "sidstrNAME_Ind like " & Pername
'lblName.Text = ddlPerNames.SelectedValue
'ddlPerNames.Visible = FalsemyDataTable = New DataTable
myDataTable = getData(sql)
lblSSN.Text = myDataTable.Rows(0)(0)
lblRank.Text = myDataTable.Rows(0)(1)
lblStatus.Text = myDataTable.Rows(0)(2)
lblHOR.Text = myDataTable.Rows(0)(3)
End Sub
 

View Replies !   View Related
Incorrect Syntax Near The Keyword 'AS'.
HiI am getting the following error on my Select statement: Incorrect syntax near the keyword 'AS'. SELECT [A], [B], [C], [D], [E], [F], [G], [H], [I], [J], [K], RowFROM(SELECT  ROW_NUMBER() OVER (ORDER BY [J] DESC)AS Row, [A], [B], [C], [D], [E], [F], [G], [H], [I], [J], [K]FROM [TABLE]WHERE (([A] LIKE '%' + @A+ '%') OR ([K] LIKE '%' + @K+ '%')) AS LogWithRowNumbersWHERE (Row >=91  AND Row <= 100)  I used the following select statement as a template (which works fine): SELECT [A], [B],
[C], [D], [E], [F],
[G], [H], [I], [J],
[K], [L], Row

FROM (SELECT ROW_NUMBER() OVER (ORDER
BY [H] DESC)
AS Row, [A], [B],
[C], [D], [E], [F],
[G], [H], [I], [J],
[K], [L] FROM [TABLE]

WHERE (([J] = @J) AND
([E] >= @E)) AND
(([K] < [L]) OR (([K] = 0) AND
([L] = 0)))) AS LogWithRowNumbers
WHERE (Row >= 82 AND Row <= 90) What is the difference that would make one work and the other not work?Thanks if you can help,Jon 
 

View Replies !   View Related
Error Incorrect Syntax Near ')'
Hi,
   When i exceute my report i get the following .. An error occured during local report processing. Query exceuteion failed for dataset 'orders' Incorrect syntax near ')'
If i give NULL i get the above error... But if give one or 2 values it works. but If I run the query in my Sql server mgt studio it works fine too and i run in the BIDS or VS2005 it works fine.. but something happens when i generate the reports... ALTER Procedure [dbo].[usp_GetOrdersByOrderDate]
@ClientId nvarchar(max)= NULL,
@StartDate datetime,
@EndDate datetime
AS
Declare @SQLTEXT nvarchar(max)
If @ClientId IS NULL
Begin
Select
o.OrderId,
o.OrderDate,
o.CreatedByUserId,
c.LoginId,
o.Quantity,
o.RequiredDeliveryDate,
cp.PlanId,
cp.ClientPlanId
FROM
[Order] o
Inner Join ClientPlan cp on o.PlanId = cp.PlanId
Inner Join ClientUser c on o.CreatedByUserId = c.UserId
WHERE
--cp.ClientId = @ClientId
--AND
o.OrderDate BETWEEN @StartDate AND @EndDate
ORDER BY
o.OrderId DESC
END
ELSE
BEGIN
SELECT @SQLTEXT = 'Select
o.OrderId,
o.OrderDate,
o.CreatedByUserId,
c.LoginId,
o.Quantity,
o.RequiredDeliveryDate,
cp.PlanId,
cp.ClientPlanId
FROM
[Order] o
Inner Join ClientPlan cp on o.PlanId = cp.PlanId
Inner Join ClientUser c on o.CreatedByUserId = c.UserId
WHERE
cp.ClientId in (' + @ClientId + ')
AND
o.OrderDate BETWEEN ' + Convert(varchar,@StartDate) + ' AND ' + convert(varchar, @EndDate) + '
ORDER BY
o.OrderId DESC'
execute (@SQLTEXT)

END
any help will be appreciated.

Regards

Karen
 

View Replies !   View Related
Incorrect Syntax Near ','. Sql Statement
 SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString2"].ToString());        SqlCommand myCommand = new SqlCommand("SELECT (Deadline, Description, Headline, AddressField, OrganizationField, NameField, FileField, EmailField, CommentField) FROM RegistrationFormDB_Info WHERE (UserName = @UserName AND TournamentName = @TournamentName)", myConnection);        SqlParameter myParam = new SqlParameter();        myParam.ParameterName = "@UserName";        myParam.Value = User.Identity.Name;        myCommand.Parameters.Add(myParam);        myParam = new SqlParameter();        myParam.ParameterName = "@TournamentName";        myParam.Value = Request.QueryString["TournamentName"];        myCommand.Parameters.Add(myParam);        myConnection.Open();        SqlDataReader myReader = myCommand.ExecuteReader();   <======================  I continue to get this error and I can't figure out the problem!  Anything helps.  Thank you very much. 

View Replies !   View Related
Incorrect Syntax Near Items
Hi,I am getting a mysterious error message, and it doesnt say which line it referres to, just gives me a stack trace.Could somone decipher it for me?:System.Data.SqlClient.SqlException: Incorrect syntax near 'items'.  [SqlException (0x80131904): Incorrect syntax near 'items'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +180 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +68 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2411 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +190 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +380 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +115 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +395 System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary values) +405 System.Web.UI.WebControls.SqlDataSource.Insert() +13 detailproview.Button2_Command(Object sender, CommandEventArgs e) +41 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +75 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4886 My page code is:private bool ExecuteUpdate(int quantity){ SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"; con.Open(); SqlCommand command = new SqlCommand(); command.Connection = con; TextBox TextBox1 = (TextBox)FormView1.FindControl("TextBox1"); Label labname = (Label)FormView1.FindControl("Label3"); Label labid = (Label)FormView1.FindControl("Label13"); command.CommandText = "UPDATE Items SET Quantityavailable = @qty WHERE productID=@productID"; command.Parameters.Add("@qty", TextBox1.Text); command.Parameters.Add("@productID", labid.Text); command.ExecuteNonQuery(); con.Close(); return true;} private bool ExecuteInsert(String quantity) { SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"; con.Open(); SqlCommand command = new SqlCommand(); command.Connection = con; TextBox TextBox1 = (TextBox)FormView1.FindControl("TextBox1"); Label labname = (Label)FormView1.FindControl("Label3"); Label labid = (Label)FormView1.FindControl("Label13"); command.CommandText = "INSERT INTO Transactions (Usersname)VALUES (@User)"+ "INSERT INTO Transactions (Itemid)VALUES (@productID)"+ "INSERT INTO Transactions (itemname)VALUES (@Itemsname)"+ "INSERT INTO Transactions (Date)VALUES (+DateTime.Now.ToString() +)"+ "INSERT INTO Transactions (Qty)VALUES (@qty)"+ command.Parameters.Add("@User", System.Web.HttpContext.Current.User.Identity.Name); command.Parameters.Add("@Itemsname", labname.Text); command.Parameters.Add("@productID", labid.Text); command.Parameters.Add("@qty", TextBox1.Text); command.ExecuteNonQuery(); con.Close(); return true; }protected void Button2_Click(object sender, EventArgs e){ TextBox TextBox1 = FormView1.FindControl("TextBox1") as TextBox; ExecuteUpdate(Int32.Parse(TextBox1.Text) );}protected void Button2_Command(object sender, CommandEventArgs e) { if (e.CommandName == "Update") { SqlDataSource1.Insert(); } }}.  Thanks!Jon  

View Replies !   View Related
Incorrect Syntax Question
i have a table of data that the user can enter into, the data type is set to "text" and has worked in some test so far, but when i type data in '' marks such as : 'text here' it gives me an incorrect syntax error, is there a way around this? or is the '' charectors invalid? thanks John 

View Replies !   View Related
Incorrect Syntax Error
I am getting an error saying, "Incorrect syntax near keyword 'ON'" Could someone please help? Here is my code: 
str = "SELECT FAC_REQUEST.*, StateFAC.*, STATUS.sStatus, FAC_TYPE.Facility_Type FROM FAC_TYPE INNER JOIN ((FAC_REQUEST INNER JOIN STATUS ON FAC_REQUEST.iStatusID = STATUS.iStatusID) ON StateFAC.DVN = FAC_REQUEST.DVN) ON FAC_TYPE.Faciltiy_Type = FAC.FacilityType WHERE iRequestID=" & iRequestID
Thanks

View Replies !   View Related
Incorrect Syntax Near 'Waltz' !!!!
Hello to everyone,I am developing a web site connected to an sql server 2000.I recently stepped onto this error message.I googled it but didn't find anything.I do not have any variables,tables or fields named this way. Have you guys met this error message before???thanks in advanceLine 1: Incorrect syntax near 'Waltz'. 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: Line 1: Incorrect syntax near
'Waltz'.Source Error:



Line 289:Line 290: UpdateFilename.Connection.Open()Line 291: UpdateFilename.ExecuteNonQuery()Line 292: UpdateFilename.Connection.Close()Line 293:Source File:
c:inetpubwwwrootagrolasithiAdminAdvertInfo.aspx.vb    Line: 291
Stack Trace:



[SqlException: Line 1: Incorrect syntax near 'Waltz'.] System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +182 agrolasithiAdmin.AdvertInfo.SubmitBtn_Click(Object sender, EventArgs e) in c:inetpubwwwrootagrolasithiAdminAdvertInfo.aspx.vb:291 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277  

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved