Check uR Update Query
"Update TableName set cloumnName='text' where Condition
David Smart <[EMAIL PROTECTED]> wrote:
The five lines following the third "SQLApp =" line are not part of any statement.
Dave S
----- Original Message -----
From: nice guy
To: [EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 12:23 PM
Subject: [ASP] Unable to Update data in SQL SERVER
hi, i am problem editing my data in database. i search for the record, then click
edit, which goes to a form that displays the records, after editing, i press
update,(which goes to EditSubmit.asp) to update....the error is in this page.
Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/ASFTS/project/EditSubmit.asp, line 13
below 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 & "' "
"App_Name=" & request.form("App_Name")&"'," &_
"App_Owner=" & request.form("App_Owner")&"'," &_
"Sect=" & request.form("Sect")&"'," &_
"Sect_Man=" & request.form("Sect_Man")&"'," &_
"Ext_Spd_Dial=" & request.form("Ext_Spd_Dial")&"'," &_
Dim Connection, RS, SQLApp
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "Provider=SQLOLEDB; Database=ASFTS; Server=mkzsa018.ap.infineon.com;
User ID=*****; Password=******"
Set RS = Connection.Execute(SQLApp)
%>
THanks guys
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/04
[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.
Yahoo! India Careers: Over 65,000 jobsonline.
[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/
