I am useing CDonts to send an e-mail to a customer to inform them that their bid has been received. When I test the page i get this error:
Microsoft VBScript compilation error '800a0400'
Expected statement
/MailPages/MailPages.asp, line 35 "<br><br>Click <a href=http://" & vURL & "/Login.asp?reg=E>HERE</a> to login to HVL Online.<br><br>"& _^ The code for this page is as follows: Code:
I need the end statement to this sql query, but I am doing something wrong, is there site where they show you the different forms of ending sql statments in ASP? Code:
during the creation of an HTML page using asp variable I have this problem:
Microsoft VBScript compilation (0x800A0401) Expected end of statement /asp/pages/connect1_1.asp, line 27, column 35 strtable = strtable & "<tr valign="top">" &
i have a dropdown box with some values, i take that value and query the DB, i need to take that value and query across more than one column i set the up but am i have some problems i'm getting an error "Expected end of statement, Code:
I've walked myself through a Beginning ASP book and taken a class on SQL2000. I'm able to access my database on my server through a DataConn_Open.asp page. The code below is giving me back the error:
I have a link on our ebay auctions that goes to a request form where people can request to have samples of our product sent to them.
I'm trying to use a simple querystring to hold the model number of the product so the actual request form can put the value in a hidden field and get submitted into my database with the rest of the informaiton. Code:
When the ASP statement end with a _ character, then the next line cannot have comment ' character. Is that correct? Since I encountered the following error:
Microsoft VBScript compilation (0x800A0400) Expected statement
I needed to create a quick and simple "lock-in" system where many people in a computer lab can pick an answer (A, B, C, etc.) and then the results be displayed to me. I went looking for a free ASP poll script that would work for my needs. I found one called Poll Manager on AspPlanet.net (http://www.aspplanet.net/viewdl.asp?itemid=6). It gives me the ability to see the results with a bar graph of sorts and easily reset the data. I have everything set-up and working, however, I modified the results page so that it reloads using javascript every 5 seconds. After letting the page reload several times, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
I can reload the page and often the error goes away, but sometimes it takes a few reloads. What could be causing this? The code can be found at aspplanet.net but I can also copy and paste it here if needed. Any ideas?
I am trying to peform a multiple deletion of records from a single table "Stockist"
I i keep getting the following Error and can't see where i am going wrong. Can anyone help?
Microsoft OLE DB Provider for ODBC Driverserror '80040e10' [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. /RetailerStockProductRemove.asp, line 22
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:
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.
Im trying to use a sesson statement within an SQL Statement:
sql = "SELECT * FROM tblNumbers WHERE AllocatedTo=" & Session("Company") & ""
And get the error:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /numberlist.asp, line 31
Anyone got any ideas? Surely this can only be something basic?
I am trying to select all records from a table, however the table name I want to be a variable. I tried to do the following (code below), but it does not work. Any ideas on how to use a variable as part of a table name? tableName = Request.Form("tableName") tableName = REPLACE(tableName,"%20"," ") set objConn=Server.CreateObject("ADODB.Connection") objConn.Provider="Microsoft.Jet.OLEDB.4.0" objConn.Open(Server.Mappath("db2/email.mdb")) SET rs = Server.CreateObject("ADODB.recordset") rs.Open "SELECT * FROM" & tableName, objConn
I am trying to run a simple update statement through asp and for the life of me can't figure out why it isn't working. I was wondering if anyone could look at this and tell me what may be wrong: Code:
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"?