remove the "*" from your sql string. Only use a "*" on a select statement. It's not
needed when updating or deleting.
Mark
nice guy <[EMAIL PROTECTED]> wrote:
helo. i am unable to upfate data. i am using SQL Server in my project. the page that i
created is to process data from an edit form. the name of the process page is
EditSubmit.asp
Below is the error i get:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near '*'.
/ASFTS/project/EditSubmit.asp, line 24
here is my code for EditSubmit.asp::
<%
App_Name = Request.QueryString("App_Name")
SQLApp = "UPDATE * "
SQLApp = SQLApp & " FROM APPLICATION "
SQLApp = SQLApp & "WHERE App_Name = '" & App_Name & "' "
Dim Connection, SQLApp
Dim rsUpdateEntry
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "Provider=SQLOLEDB; Database=ASFTS; Server=xxxxxxxx; User ID=******;
Password=!!"
Set rsUpdateEntry = Server.CreateObject("ADODB.Recordset")
Set rsUpdateEntry = Connection.Execute(SQLApp)
Set rsUpdateEntry = Nothing
Connection.Close
Set Connection = Nothing
response.redirect "main2.htm"
%>
thanks guys
---------------------------------
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
[Non-text portions of this message have been removed]
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
