I think I know what I want to say, but don't know the proper syntax. I want to redirect the user to a new page if the referrer is ANYTHING but one particular page (/index.asp)
Code:
<%
If instr(Request.ServerVariables("HTTP_REFERER"), IS NOT EQUAL TO /= "www.sheridan.edu/index.asp") Then
Response.Redirect("/index.asp")
End If
%> .
I'm using the following Insert statement which is giving me an error.
query="Insert Into "& CurrentSeason() &" (pkDate, Players(Goals)") Values (#31/12/2004#, '"&strOpponent&"')"
cnDB.Execute(query)
I think this is occurring as one of my field names has brackets in it. Can someone please tell me how I can adjust the syntax of my insert statement so it allows me to include brackets? Is it possible as I have played around with the syntax and received syntax errors.
tell me the syntax for using like in an if statement? I am using an access database and asp. I want to look for a single character in a database field. I tried to use similar syntax as in SQL select statement?
<%if l_rstNews("highlighted") like .... then%>
I am getting a syntax error on my SQL statement, not sure if I am doing this
right. i am trying to pass a value from another form.
strsql = "select PrinterModel, PrinterName, IP_Address, Location from
Printers where PrinterName = ' & <% =Request.Form(npName) %> & ')"
Now I know I posted this elsewhere twice but no one seems to even be looking at them. I really am stumped by this problem.
I recieve the error:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/quizmaker/admin/create_teacher.asp, line 20
DIM mySQL
mySQL = "INSERT INTO users(user, password) VALUES('"& uname &"', "& pword &")"
USERS1.open mySQL , objConn <----- Line 20.
Syntax error in INSERT INTO statement.
Please download the attachment and unzip it.
I have 4 files:
Starting with "signup.asp" - fill up the registration form. this will forward you to next form.
"signup_process.asp" - process the filled form
"signup_success.asp" - indicate that register successfully
"Database.mdb" - the database file (MS Access 2000 format)
My problem occurs in "signup_process.asp".
The error message found in IE:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/myweb/signup_process.asp, line 31
I look through my code, but found no mistake.
But why still I cannot add the information in the form into the "Database.mdb"?
I've see this error message when I try to submit my form..
Help with Syntax error in INSERT INTO statement. line 153
Here's the SQL Code:
I'm having trouble with an SQL UPDATE string updating Microsoft Access 2000 with jet engine using ASP classic. I can't see what could be going wrong, as far as I can tell it's fine. I have tried surrounding my field names with brackets [] to no avail.
The error I receive is: Code:
i'm trying to update a row in my Access Database by the AD_ID... i get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/alterantique1.asp, line 35
Here is the code:
My Code is as follows, im basically trying to get the value from a radio button from another page for a vote, take the value thats allready in the table add 1 to the value and then insert it back into the database, then create a voted cookie and redirect back to the same page to view the vote results. Code:
View Replies View RelatedSQL = "UPDATE * FROM IME_request SET instructName = '" &InstructName& "', email = '" &email& "', school = '"&school&"', courseNumber='"&courseNumber&"', dateMonth = '"&dateMonth&"', dateYear = '"&dateYear&"', dateDay = '"&dateDay&"', description = '"&description&"', instructDesign = '"&instructDesign&"', techranger = '"& techranger & "', IP= '"&IP&"', completed = '"&completed&"', feedback = '"&feedback&"' WHERE courseNumber='" &courseNumber&"' "
I have a form that I want to update my database. I am receiving an error that reads:
Syntax error in UPDATE statement.
I'm trying to update my counter in DB (Access) using sql query but the following error appears
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/cms/modules/test.asp, line 14
How could i solve this problem, here is sql query that i'm trying to run
sql = "UPDATE articles SET counter=counter+1 where (((aid) ="&aid&"))" .
I keep getting the same error... Syntax error in INSERT INTO statement. (line 14) Code:
View Replies View RelatedWhat am I doing wrong with my Update statement in with
javascript? Code:
Any idea's what's wrong with this statement?
sql_insert = "insert into Specs (ItemID, Title, Value) values ('" & _
ItemID & "', '" & Title & "', '" & Valuesa & "')"
It returns.
Syntax Error in INSERT INTO statement.
Does this have something to do with using "Value" as the field name?
Usually on our server we see or can view source to see where in the INSERT statement something got messed up. I have debugging on but when I run a test, I get the following error:
Syntax error in INSERT INTO statement.
Line 57
It is a very long INSERT statement but for the life of me, I can not see where it is wrong. What I am wondering, if all I am seeing is "Syntax error in INSERT INTO statement. " does this mean it is at the beginning of the statement since i do no see any of the actual data on the error page?
I'm having a very difficult time with an ASP page that I develpoped in Dreamweaver and the MS Access DB it's supposed to update. When I submit the data the following error appears:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/sessiondata2.asp, line 115
I know this is usually a reserved word issue but I don't think that's the case here because the page updates perfectly when executed on my computer as a testing server.
The rest of the site updates data into the database properly so I know the connection string is working. I can't figure out what would throw an error on a live server when there isn't one on a testing server. Code:
How can I learn where my visitor came from? I mean which site reffered
to my site? (Something called referrer id/ip)
I'd like to limit access to an ASP script by checking that they came through the correct path. I believe that I can do this by checking that the scriptname that they came from was myscript.asp
How do I go about doing this though? Are there any problems with relying on Referrer? I heard something about Norton Firewall screwing it up
is it possible to get the url to the refferer to a page as a asp value (vbscript) ? I know the document.write(document.refferer) but don't how to use it in an asp script.
View Replies View RelatedA week or so ago, I needed to find the HTTP_REFERER environment
variable to check and see if a user is coming from a certain website:
If Request.ServerVariables("HTTP_REFERER")_
= "http://localhost/mydir/page1.aspx" then
response.write "Click on a menu choice"
else
response.write "check back later
end if
I have a page nested in an IFRAME (for example framepage1.aspx or ..asp), and I need to check to see if a user is coming to (not coming from ) a certain page where the framepage1.aspx is (the framepage1.aspx could appear in not only page1.aspx, but page2.aspx , or page3). I'm not sure how to accomplish this given that the HTTP_REFERER checks on address only incoming.
I am running into the same problem. Has a fix been found for this yet? I guess I will just comment out the referrer check until this is addressed. I can't run the risk of turning customers away because the forms don't work.
View Replies View Relatedhow I could store the referrer id in this URL http://www.widget.co.uk?referrer=1234 into a session cookie. I've been given this code by someone else but my knowledge of ASP is virutally non-existent and they need this feature in the site as soon as possible.
<%dim vntRef
if request.querystring("referrer") <> "" then
vntRef = request.querystring("referrer")
session("svRef") = vntRef
end if
if session("svRef") = "" then
session("svRef") = vntRef
end if
%>
where this code goes and how I reference it(if I need to) that would be fantastic. Basically I wasn't told about this until after the site went live and they're now telling me to get it done quick smart so the quicker the better.
I have seen a post on how to just receive the domain name when using HTTP-REFERRER. But, I need just the webpage. I have tried modifying the code I saw, to no avail. Can anyone help please?
View Replies View RelatedI've got several pages with links. When the links are clicked, a value is posted to 'processing.asp' which does a database update then needs to redirect back to the page from which the link was clicked. Is it possible to obtain the full URL of the referring page using asp? I need it potentially to be able to redirect back to something as complex as:
products.asp?Category_Id=3&SubCategory_Id=12
If that was the URL of the page from which it was linked.
I have this insert statement where instruction field in the DB is a memo field.
SQL="INSERT INTO int ([instruction]) VALUES " & _
"('"&Request.Form("myTextarea")&"')"
objConn.Execute(SQL)
Its giving me error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Can I use this syntax
Where NOT IN (".....)
in a situation I don't want to select items in the list.
If not what other ways can do that.
I'm just trying to display a user's FIRST name and the FIRST INITIAL of the last name on my asp web page.
This works to displays their "firstName" and "lastName":
Code:
<%=oUsers("firstName")%> <%=oUsers("lastName")%>
But I get a variety of vbscript or asp syntax errors when I try to trim the "lastName" using something like
Code:
<%=oUsers("firstName")%> <%=oUsers(replace(left("lastName",1))%>
How do get this simple task done?
(If it makes any difference, the whole thing is inside html <td></td> tags as part of a table)
I can't see to find where the syntax is wrong because I can do the query just fine in access but my asp page gets this error
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
Here is what the insert looks like when I print it out in the page
INSERT INTO tblusers (username,password,[Timestamp],email) VALUES('testuser', 'c4ca4238a0b923820dcc509a6f75849b', '10/16/2004', 'me@home.com')
Here is the code:
I am trying to query a database for 2 conditions but I can't get the query to work.
Can anybody see a problem with this line of code?Code:
strQuery="SELECT Count(*) AS intTotal FROM tbl_artists WHERE fld_artist_name = '" & strReqname & "'" "AND fld_user_id ='"& strUsername & "'",objConn,,,adCMDText
objRS.Open strQuery,objConn,,,adCMDText
numRecords = objRS("intTotal")
I have a textarea and have named it category_One.
I have sent the data in this form on using the POST method
contents_category_One = Request.Form("category_One")
I have then used the following sql statement
sql = "INSERT INTO tableName(Category_One) VALUES ('"& contents_category_One &"');"
If someone inserts ' in the text box, this value is causing a syntax error in the sql statement.
The WHERE part of my select needs to pull out where the date column is empty. If there isn't a date, it shows NULL in the database (SQL7)."WHERE eligibility_dt <> NULL" doesn't work. what am i forgetting?
View Replies View RelatedI need help with ASP. when i post data to the database, do the records in my form need to be in the same amount as the database records?
View Replies View Related