-
Syntax error in UPDATE statement
For some reason I am getting this error. I have looked over the SQL code but see nothing wrong. As I am new to this I might be missing something. Can someone help? BTW sorry for so much code!!
< ERROR >
Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
NativeError = -3503
< CODE >
<%
Set Admin=Server.CreateObject("ASPdb.Pro"
Admin.dbmdb="D:Websvolzcpadatavolzcpa.mdb"
Admin.DBColor = "10,auto,lightblue"
Admin.dbGridTableTag = "border=3 cellspacing=3 cellpadding=3"
Admin.dbDebug=True
Admin.DbMode = "Dual"
F = Request("TableID"
If F <> "" then
Admin.dbReset(1)
Session("FR" = F
End If
If F = "games" then
Admin.dbMemoTextSize=0
else
Admin.dbMemoTextSize=40
End If
Admin.dbSQL = "Select * from " & Session("FR" & ""
Admin.dbImageDir="images/"
Admin.dbGridInc=10
Admin.dbNavigation="bottom"
Admin.dbNavigationItem="top, bottom, next, prev, gridrow, color, filter, download, add, update, edit, delete"
Admin.dbNavigationIcon="std"
Admin.dbUnit = 1
Admin.dbEditHideFlds="ID"
Admin.dbFilterHideFlds="ID"
Admin.dbFormHideFlds="ID"
Admin.dbEditParams="TableName=" & Session("FR" & ",BookMarkFlds=0,InputSize=7x70,TableTag=BORDE R=2"
Admin.aspDBPro
%>
< SQL STATEMENT >
Platform
Detected, allowed CPU=4/2
GridInc before QP=10
DBType=ACCESS
Main: Q=..U=..V=..W=..UE=Update Current Record..US=
Querystring, Form=/Cat=EXE&Title=Pennypincher&Link=pennyp25.exe&Desc= Pennypincher+is+a+program+that+helps+you+manage+yo ur+money+by+providing+an+easy+and+convenient+forma t+for+tracking+all+money+earned+and+spent.+Keep+tr ack+of+your+cash+flow+and+categorize+spending+on+g roceries%2C+entertainment%2C+gas%2C+rent%2C+laundr y%2C+bills%2C+donations%2C+and+car+payments.+Penny pincher+also+includes+charts+that+calculate+percen tages+of+money+earned+and+spent+in+different+categ ories.+Best+of+all+Pennypincher+is+completely+free %21&Size=2.4MB&aspDBEditBut_1=Update+Current+Recor d
Connection=driver={Microsoft Access Driver (*.mdb)}; dbq=D:Websvolzcpadatavolzcpa.mdb
Get Connection:Alive, CloseConn, NewSession=True/True/False
Get_Connection: New connection, Tout: driver={Microsoft Access Driver (*.mdb)}; dbq=D:Websvolzcpadatavolzcpa.mdb/30
Edit Action=Update Current Record
Entering edit: Update Current Record
Begin edit - Update Current Record
f1=, Cat = '*CatUPDATE', Title = '*TitleUPDATE', Link = '*LinkUPDATE', Desc = '*DescUPDATE', Size = '*SizeUPDATE',
Update Arg=Cat
Update Field Value=EXE
F1 Replace ELSE = , Cat = 'EXE', Title = '*TitleUPDATE', Link = '*LinkUPDATE', Desc = '*DescUPDATE', Size = '*SizeUPDATE',
Update Arg=Desc
Update Field Value=Pennypincher is a program that helps you manage your money by providing an easy and convenient format for tracking all money earned and spent. Keep track of your cash flow and categorize spending on groceries, entertainment, gas, rent, laundry, bills, donations, and car payments. Pennypincher also includes charts that calculate percentages of money earned and spent in different categories. Best of all Pennypincher is completely free!
F1 Replace ELSE = , Cat = 'EXE', Title = '*TitleUPDATE', Link = '*LinkUPDATE', Desc = 'Pennypincher is a program that helps you manage your money by providing an easy and convenient format for tracking all money earned and spent. Keep track of your cash flow and categorize spending on groceries, entertainment, gas, rent, laundry, bills, donations, and car payments. Pennypincher also includes charts that calculate percentages of money earned and spent in different categories. Best of all Pennypincher is completely free!', Size = '*SizeUPDATE',
Update Arg=aspDBEditBut_1
Update Arg=Title
Update Field Value=Pennypincher
F1 Replace ELSE = , Cat = 'EXE', Title = 'Pennypincher', Link = '*LinkUPDATE', Desc = 'Pennypincher is a program that helps you manage your money by providing an easy and convenient format for tracking all money earned and spent. Keep track of your cash flow and categorize spending on groceries, entertainment, gas, rent, laundry, bills, donations, and car payments. Pennypincher also includes charts that calculate percentages of money earned and spent in different categories. Best of all Pennypincher is completely free!', Size = '*SizeUPDATE',
Update Arg=Link
Update Field Value=pennyp25.exe
F1 Replace ELSE = , Cat = 'EXE', Title = 'Pennypincher', Link = 'pennyp25.exe', Desc = 'Pennypincher is a program that helps you manage your money by providing an easy and convenient format for tracking all money earned and spent. Keep track of your cash flow and categorize spending on groceries, entertainment, gas, rent, laundry, bills, donations, and car payments. Pennypincher also includes charts that calculate percentages of money earned and spent in different categories. Best of all Pennypincher is completely free!', Size = '*SizeUPDATE',
Update Arg=Size
Update Field Value=2.4MB
F1 Replace ELSE = , Cat = 'EXE', Title = 'Pennypincher', Link = 'pennyp25.exe', Desc = 'Pennypincher is a program that helps you manage your money by providing an easy and convenient format for tracking all money earned and spent. Keep track of your cash flow and categorize spending on groceries, entertainment, gas, rent, laundry, bills, donations, and car payments. Pennypincher also includes charts that calculate percentages of money earned and spent in different categories. Best of all Pennypincher is completely free!', Size = '2.4MB',
Edit SQL=UPDATE downloads SET Cat = 'EXE', Title = 'Pennypincher', Link = 'pennyp25.exe', Desc = 'Pennypincher is a program that helps you manage your money by providing an easy and convenient format for tracking all money earned and spent. Keep track of your cash flow and categorize spending on groceries, entertainment, gas, rent, laundry, bills, donations, and car payments. Pennypincher also includes charts that calculate percentages of money earned and spent in different categories. Best of all Pennypincher is completely free!', Size = '2.4MB' WHERE ID = 9
-
Syntax error in UPDATE statement (reply)
Michael, you have a mistake in your code.
The line that says:
If F = "games"
Should say:
If F = Session("FR"
Then try this:
Paste your Update SQL into Access (in a QUERY) and try to let Access run it. Let's see what Access says about it. (I assume you have a table name called [downloads] ? ) AHA!!! DESC is a RESERVED WORD!! You must rename that field. See list of reserved Words at:
http://www.aspdb.com/docs/aspdbman.htm#TOC_IVB
Edit SQL=
UPDATE downloads SET Cat = 'EXE', Title = 'Pennypincher', Link = 'pennyp25.exe', Desc = 'Pennypincher is a program that helps you manage your money by providing an easy and convenient format for tracking all money earned and spent. Keep track of your cash flow and categorize spending on groceries, entertainment, gas, rent, laundry, bills, donations, and car payments. Pennypincher also includes charts that calculate percentages of money earned and spent in different categories. Best of all Pennypincher is completely free!', Size = '2.4MB' WHERE ID = 9
-
Syntax error in UPDATE statement (reply)
Many thanks and praises!
------------
Mark at 9/18/00 3:33:45 PM
Michael, you have a mistake in your code.
The line that says:
If F = "games"
Should say:
If F = Session("FR"
Then try this:
Paste your Update SQL into Access (in a QUERY) and try to let Access run it. Let's see what Access says about it. (I assume you have a table name called [downloads] ? ) AHA!!! DESC is a RESERVED WORD!! You must rename that field. See list of reserved Words at:
http://www.aspdb.com/docs/aspdbman.htm#TOC_IVB
Edit SQL=
UPDATE downloads SET Cat = 'EXE', Title = 'Pennypincher', Link = 'pennyp25.exe', Desc = 'Pennypincher is a program that helps you manage your money by providing an easy and convenient format for tracking all money earned and spent. Keep track of your cash flow and categorize spending on groceries, entertainment, gas, rent, laundry, bills, donations, and car payments. Pennypincher also includes charts that calculate percentages of money earned and spent in different categories. Best of all Pennypincher is completely free!', Size = '2.4MB' WHERE ID = 9
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|