Can anyone help...?
I keep getting this error message and am now getting angry. I have checked my syntax hundreds of times and can not seem to find anything wrong with it....I think I need a fresh pair of eyes..please can someone help me.
I have copied the code below:
================================================== =
Expected end of statement
/admin/news_update_pro.asp, line 22
conn.Open "SET DateFormat dmy;update NewsItem set create_date='"&c_date&"', release_date='"&r_date&"', short_headline='"&s_headline&"', headline='"&headline&"', abstract='"&abstract&"', full_text='"&f_text&"' where id='"&id&"'",objConn,3,3
---------------------------------------------------------------------------------------------------------------------------------------------------^
8 3681
i can't seem to spot it in the code sample provided. Can you cut/paste the entire script?
Here is the entire code copied below:
Thanks -
<!--#include file="connection.asp"-->
-
-
<%
-
id=request.Form("id")
-
-
create=request.Form("c_date")
-
create_date=CDate(create)
-
-
release=request.form("r_date")
-
release_date=CDate(release)
-
-
short_headline=request.Form("s_headline")
-
headline=request.Form("headline")
-
abstract=request.Form("abstract")
-
full_text=request.Form("f_text")
-
-
set conn=Server.CreateObject("ADODB.Recordset")
-
-
''conn.Open "update NewsItem set create_date='"&c_date&"', release_date='"&r_date&"', short_headline='"&s_headline&"', headline='"&headline&"', abstract='"&abstract&"', full_text='"&f_text&"' where id='"&id&"'",objConn,3,3
-
-
-
conn.Open "SET DateFormat dmy;update NewsItem set create_date='"&c_date&"', release_date='"&r_date&"', short_headline='"&s_headline&"', headline='"&headline&"', abstract='"&abstract&"', full_text='"&f_text&"' where id='"&id&"'",objConn,3,3
-
-
// conn.Close()
-
set conn=nothing
-
-
Response.Redirect ("news_index.asp")
-
%>
For troubleshooting purposes, dump this "SET dateFormat..." string into a variable, then print it out. When you call the conn.open line you can easily do this: - dim query
-
query = "SET DateFormat dmy" 'etc
-
-
response.write query 'this line can be commented out after everything works
-
-
conn.open query, objConn, 3,3
Let me know if this helps.
Jared
Is your variable id supposed to be a string? You have it wrapped in apostrophes, so I am curious.
That error is normally indicative of a misspelled, or non-existent field in your SQL query. Check to make sure that all the fields in your SQL statement are all correctly spelled and actually a part of the table your updating.
Is your variable id supposed to be a string? You have it wrapped in apostrophes, so I am curious.
Yes it is meant to be a string...It is the id number of the News item am entering into the database.
For troubleshooting purposes, dump this "SET dateFormat..." string into a variable, then print it out. When you call the conn.open line you can easily do this: - dim query
-
query = "SET DateFormat dmy" 'etc
-
-
response.write query 'this line can be commented out after everything works
-
-
conn.open query, objConn, 3,3
Let me know if this helps.
Jared
Hi Jared,
I tried that but it has not worked.
The problem seems to point to "headline" I am unsure why it stimbles here but not on the others.
Hi Jared,
I tried that but it has not worked.
The problem seems to point to "headline" I am unsure why it stimbles here but not on the others.
show the query as it is written out in the response.write line
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Matthew Louden |
last post by:
I have no idea what's wrong with the following ASP statement:
Response.Write "<select name=\"id\">"
MS VBScript Compilation error 800a0401...
|
by: Matt |
last post by:
When the ASP statement end with a _ character, then the next line cannot
have comment ' character. Is that correct? Since I encountered the...
|
by: Adam Short |
last post by:
Can anyone help?
I have all of a sudden started to receive this error on my site!
I have no idea what script it is executing, why it is now...
|
by: Adam Short |
last post by:
Can anyone help?
I have all of a sudden started to receive this error on my site!
I have no idea what script it is executing, why it is now...
|
by: aklsdjfh |
last post by:
I'm no expert in asp and vbscript but not a total beginner. I've got some
VBScript in an asp page which is generating a forumla for use in Lotus...
|
by: JNariss |
last post by:
Hello,
I have created a connection to my Access database with Dreamweaver and
made a simple form with 4 fields.
The code behind this form...
|
by: remya1000 |
last post by:
While running the program, i'm getting this error
Microsoft VBScript compilation error '800a0401'
Expected end of statement
...
|
by: char |
last post by:
I can't figure out why I am getting error: Microsoft VBScript compilation '800a0400'
SET MyRecordSet = SERVER.CREATEOBJECT("ADODB.RECORDSET")...
|
by: kevinr |
last post by:
Hi, I am brand new to VB, and I am trying to deploy Office 2007 on my network here at work. We used part of this script to do another deployment, and...
|
by: better678 |
last post by:
Question:
Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct?
Answer:
Java is an object-oriented...
|
by: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
|
by: CD Tom |
last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was...
|
by: Matthew3360 |
last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function.
Here is my code.
...
|
by: Matthew3360 |
last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
|
by: AndyPSV |
last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
|
by: Arjunsri |
last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
|
by: WisdomUfot |
last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
| |