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 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 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'm querying 2 tables in 2 seperate recordsets and comparing set 2 to set 1 using ASP. If booking exists in set 2 that matches item in set 1 then I need to display the length item is booked for. I'm using a table with many cells and shading background to identify booked areas.
I've written a script that allows users to choose their own colors for the style sheet, but when I try to include the style sheet (style.inc), I get this error:
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/theroguehacker/style.inc, line 106
Line 106 is the end of the file... I've messed with it at least two hundred times... Please take a look and see if I'm doing it wrong. (I'm definately a beginner)
Also, I'm going to post the script that processes all the input. I'd like to know if there's an easier way to do it. Code:
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 keep on getting this error. I had an sql statement before and it works. I changed it and i get this error so i know it's within the sql statement. Does anybody know what is wrong?Code:
<% dim mysql set objconn = server.createobject("ADODB.connection") objconn.connectionstring = "dsn=prospect" objconn.open set objrs = server.createobject("ADODB.recordset") 'mysql = "select * from Prospect where asm = '" & Username & "' order by Prospects_Name ASC " mysql = "Select * from Prospect WHERE Status_Report.Prospect_Number = Prospect.Prospect_Number " objrs.open mysql, objconn %>
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:
I am building an application for inserting and updating one field in a database. The database is in SQL Server and I am using Classic ASP.
I have a dropdown listbox that is populated with names, when a name is selected it automatically submits the form and then replaces the dropdown listbox with the name of the resident selected. Now I need to take a field and split it into 2 textboxes. This is where my problems begin. The field is named ProblemO and looks something like this, Code:
Response.ContentType = "application/vnd.ms-excel";after downloading the same when i import it back to my system using Microsoft Excel driver, i got an error.
External table is not in the expected format. Do anyone know how to solve it?
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
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp. /CoxAxis/adminEditPage.asp, line 6
My code:
<% dim self, pid, i, c self = Request.ServerVariables("URL") pid = Request.Querystring("pid") set Session("pageContent") = Server.CreateObject("Scripting.Dictionary") Set custObj = Server.CreateObject("NFIFunctions.ValidateField") Line 6 set psi = Session("pageContent") set errDict = Server.CreateObject("Scripting.Dictionary") i = 1
Let me start by saying I'm fairly new to Asp coding. That said...
My ISP only uses AspSmartMail. I've created an online form that uses fill out, which is then e-mailed to the collector of the information and CC-ed to the person who submitted the information.
The error I'm receiving is this: aspSmartMail.SendMail : Error 28 error '8004001a' 504 Invalid Username or Password
In my script, I've Dimensioned several items, as you'll see below, passing the authenticating username/password to the smtp server, but it's not working. I tried not passing the information by entering in the actual info without it being passed by the diminsioned items. This didn't work either. I of course verified that the username/password I'm usine is correct.
Can someone plase tell me why I can't authenicate? I would really appreciate any help that might be out there.
Relavant Asp code below: ----------------------------------------- Dim smtpserver,youremail,yourpassword,yourusername,rem oteemail