I am getting this error!


Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near the keyword 'FROM'.

/forms/Start2.asp, line 65

Line 65 is:

Set ObjRS = Server.CreateObject("ADODB.Recordset")


strSql = "SELECT Top 7 FROM Escalation_Forms WHERE Escalation_Type = '"& sqlselected & "'" & sqlStatus

line 65 " objRS.Open strSql, objConn, 0, 1"
Response.Write(strSQL)

Hey,

You aren't selecting any fields. You need to provide fields or * to select:

SELECT Top 7 * FROM Escalation_Forms

When ever I finish on thing something else alway come up. I clean up the database and re-submit new data. They all fall under open. Sql statement worked fine with the open work order. When choose one of the jobs then change the status to pending. Next I try to retrieve that pending job it comes up with nothing. Coud be the way I am updating the information within the database? For example I have the following to updat my records: Should I change it to ObjRS.ADDNew
Code:
<%

Dim ObjConn, ObjRS, strSQL, TicketNum


set objConn=Server.CreateObject("ADODB.CONNECTION")

ObjConn.Open "Provider=sqloledb;Data Source=Flmirsql02;Initial Catalog=Source_Forms;User Id=Source_Forms_User;Password=password;"


Set ObjRS = Server.CreateObject("ADODB.Recordset")

strSQL = "UPDATE Escalation_Forms SET Status='"& request.form("Status") &"', Wip_Com='"& request.form("Wip_Com") &"' Where Ticket_Number=" & Session("TicketNum")

ObjRS.open strSQL, ObjConn, 3,3

if err<> 0 then
Response.Write("Something went wrong! Please Contact you Administrator!")

Else
Response.Write("Ticket Number" & TicketNum & " was successfully updated!")

End if

Set ObjRS =Nothing
ObjConn.Close
Set ObjConn = Nothing
%>

Hey,

I personally never used the objrs.AddNew method. Your update statement seems fine, but I would check for an existing Session("TicketNum") before updating.

Are you getting an error statement?

Brian

Do you know how I can get the statement to retrieve only the current data or the on that is listed on left hand?

Here's how it look in the database right for status:

Job Status: Pending , Open
            current old

I hope this makes sense. This not easy but I like the challenge

Calibus,

You are constructing an update statement and trying to open a recordset using that. Why is that so? Now what is that you would do result in the recordset after executing update statement. I am not sure if you would end up seeing some error with this. But this is not right.

When you want to execute your DMLs(Data Manipulation Language), you got to use
Use Recordset Object only when your query returns a resultset which you got to use for later processing.

Hope that helps.

_________________________
- Vijay G
Strive for Perfection

I am not sure what you wanted from that post. Can ou explain more on that?

Cheers!

_________________________
- Vijay G
Strive for Perfection

Do you have a 'date' column?

If you do you can "SELECT TOP 10 the_date, whatever_column, column_3 FROM table_name ORDER BY the_date DESC;"