Syntax error in FROM clause.
/MSFF/CheckLogin.asp, line 14
That is the error that I am getting. It is driving me nuts because I have cut lines out and just printed the SQL statement and it seems to be working just fine. How can it be an error in my "From" clause then? I don't get it Code:
I have an error on a webpage of mine since I added a function to save the data in Proper Case-- but a smarter proper case. The page is not displayed so I don't know where the error is or how to fix it (obviously.) Here is the code:
View Replies View RelatedI have an ASP script that collects information from a form on my site and
sends it as an email. The ASP script is calling CDONTS.DLL which is
registered on a win2k3 server with Exchange server running.
When submitting the form there is an error when it comes to the 'mail.send'
part of the script. I have given all the necessary folders the correct
permissions as per microsoft however I still get the same errors.
I believe it is something to do with permissions because if I disallow
anonymous access to the site and access it through the local network as a
logged in user the script works fine.
i'm making a forum, and previously i was submitting the form to an asp file, which would check for errors -- if there were errors, it would redirect back to the form with error messages to be displayed -- if it was error free, the message would be written to a txt file.
but then i wanted to put in a preview message page, and so error checking and passing values between the three pages is becoming tricky. so i'm at the point where i'm starting to use javascript to error-check, which works fine for making sure the input is good, but i don't know a good way to notify the user that there are errors with javascript. alert messages are unprofessional, and i can't just add text to the page using javascript.
i'd prefer to use only asp, and i'd prefer it if i didn't have to use an extra asp page JUST to error-check. as it is now i have these pages involved in adding a new subject:
post subject (has the form for the subject and message; the user can click either post message, which will directly write the message, or preview message, which will bring them to a page which displays the post as it would appear once written)
preview message (regardless of what the user clicks, it would come here first to do error checking, and depending on what the user clicked it would either redirect to the page which writes the subject, or display the message;
the problem is, if there are errors with the form, i need to point the user back to post subject without losing whatever info they have already entered. the only way i know how to do that is by submitting a form [i can't use a querystring because it won't maintain the message if the user entered multiple lines in the message])
add subject (this does the backend writing of the message, and is only accessed if the fields have made it through the error-checking)
any solutions in mind on how to pass the field values between these three pages?? or is there a better way i can do error checking??
I am trying to provide some simple validation using Javascript on my form. However at times the validation works and at others it doesn't and submits the form without any warnings even though it contains invalid values. And sometimes it displays the warnings and submits the form.
what else I can do (I want to provide the validation server-side) I'd be very greatful of any advice on the subject.
I am using formmail.asp from www.brainjar.com on a webfusion server. I get this on submit: Form could not be processed due to the following errors:
Email send failed: The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available .
have beens searching web for hours and webfusion support is v slow! I have double checked the username/password and mail server variables.
how to create a form that would handle basic error checking within the ASP itself?
View Replies View RelatedI have three pages that I am working on at the mo. A select record page that selects a record to be updated. A form page that allows the selected to be amended, and an update form processing page.
With the form processing page I am getting an error which I can't seem to get around- the error is-
"ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''I think this experiment is about judging other people on the basis of one's first impression. I don't think it's fair to judge ohters based on first impressions. Most of the times first impressions are crucial in finding people's attitudes or personas, but '.
I am 99% sure that the problem is becase I have a text field box and people are typing in commas, apostropies, ect. How do I get around that? Code:
I am trying to insert data from a form into a database and i am getting the following error:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
The code that i used can be seen below: Code:
I have downloaded the script from brainjar but it needs a bit of tweaking because my smtp host requires authentication, I have added what i feel are the relevant lines of code but these are giving me a runtime error
These are the relevant lines of code, the 1st line giving me the error:
objCDOSYSCon.Fields("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 'whether you use a authentication on the server
objCDOSYSCon.Fields("http://schemas.microsoft.com/cdo/configuration/sendusername") = *******
objCDOSYSCon.Fields("http://schemas.microsoft.com/cdo/configuration/sendpassword") = *****
I have the below page which i use to add the information from a form to my MySQL database. It works perfectly fine when I don't add the code at the top for sending an email. Can someone be kind and have a look at my code and let me know where I am going wrong.
When I add the email code at the top the error I get is :
Error Type:
Request object, ASP 0206 (0x80004005)
Cannot call BinaryRead after using Request.Form collection.
/change_management/area/upload.asp, line 92
upload.asp I use for addding an attachment to the form ....
my code:
dim msconn
DIM mail, objMail
Set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.From = "admin@abc.com"
objMail.Subject = "This is a test"
objMail.To = "webmaster@xyz.com"
objMail.Body = "this is a test email from abc.com"
objMail.Send
Set objMail = nothing
This code works perfectly well from any machine apart from the domain controller. On the domain controller, i get the following access denied error message:
Microsoft VBScript runtime error '800a0046'
Permission denied
/Emailer.asp, line 310
I have given full permission to the drop folder in the mail root as guided in other sites. It's still not working.
Can anyone tell me where i'm going wrong? anything else i can try?
I have a form submit that must report back to the same page an error if a pair of radio buttons inside the form block are not checked. But data from the buttons must still be sent to another page.
I tried having the form send data back to the same page, then putting the data in session variables and redirecting to the page they have to go to. But apparently the session variables are having unpredictable effects on the very complex page I'm sending the data too.
I'm thinking about using Onsubmit = somefunction inside of the <form > . I've tried javascript but I haven't found the right code yet, and also I'd rather avoid the popup alert box, it is inconsistent with the rest of the website. Perhaps an ASP subprocedure could do the trick?
I have a form that I want the user to fill out. If they dont fill out the whole thing, I want the form to reload and an error message to be displayed at the top of the page. Here is the jist of my code:
View Replies View RelatedI'm trying to pass a piece of data i get from a query using a different form's passed values. This is how I get the data into the new form and how I try to pass it to the next asp page query.
<td valign=TOP width="168"><form action="HouseDetail.asp" method="post" name="MLS" id="MLS"><input name="MLS" type="hidden" value='<%=oRs("ML_Number")%>'><input name="Submit2" type="submit" value="Get Details"/></form></td>
The value='<%=oRS(ML_Number")%>' generates a real value like '2403943' - and the field I'm trying to use this value in the qry is expecting a number. But even passing the number without the single ' at both ends generates the same error message. Code:
ob_rs.Open "select * from libreta where tipo1 like request.form("tipo")", conn
It tells me an error when says request.form.How can I make a that sintax?
I got an error saying
Microsoft VBScript runtime error- Error '800a000d'
Type mismatch
/briansforums/default.asp, line 923
also another error called Code:
# Error Type:
Server object, ASP 0177 (0x800401F3)
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
i'm getting
Provider error '80004005' Unspecified error
admin/dbconnection.inc, line 4
what this is, it only started happening after i did a recent upload of my database!, i 've tryed uploading it again but the error still appears.
I´m having a problem using ASP Upload with an insert form..
If I use ENCTYPE="multipart/form-data" the all the parametres i might get with request.form don´t appear.. but i can upload the files.. Besides if I take away the ENCTYPE tag, i can´t upload but the INSERT INTO form works propertly
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.
Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".
I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:
I have a form as follows:
<form action="dropboxsubmit.asp" method="post" enctype="multipart/form-data">
<input type="file" name="FILE1" size="30">
<input type="text" name="def" value="0" size="10">
etc.....
and can't get my asp to recognize data in other form input boxes using Request.Form
Any thoughts?
In my prototype asp page (with no javascript and no password validation, I have a registration form with the following action:
<form name="form" method="post" action="RegDetails.asp">
This works fine, the form details are collected by RegDetails.asp
I am attempting to include javascript server side validation for the pasword, which obviously requires password and password2 fields (to be verified). I have used the script available at:
http://javascript.internet.com/forms/val-pass.html
It works fine in a new blank page with the form action:
<form name=myForm onSubmit="return validatePwd()">
The final stage in this javascript demo form displays an alert box:
else {
alert('Nice job.');
return true;
When I change the first line of my original form to:
<form name=myForm onSubmit="return validatePwd()">
how do I get my original action of - action="RegDetails.asp" instead of this alert box?
I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form.
The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: Code:
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:
View Replies View RelatedIm having problems with my form, separately both forms work perfectly, but having problem sending the email once submitted, however the upload fuction is working fine. The message im getting is,
Request object error 'ASP 0207 : 80004005'
Cannot use Request.Form
/forminfo.asp, line 42
Cannot use Request.Form collection after calling BinaryRead.
Heres the script Code:
Would anyone be able to give some guideance in ASP code as to how I would repeat a section of input fields in a form based upon the number of guests that are attending an event?
Basically, what needs to happen is if 3 guests are attending, I need the Name, address, city, state fields to repeat so they can be filled in with information.
Then all of the information from the whole form is submitted which returns an email to the administrator of the event.
<%@Language=VBScript %>
<%option explicit%>
<%
MESSAGE = (Request.Form("type"))
MESSAGE=MESSAGE & vbcrlf & "Name" & (Request.Form("name"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("address"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("handphone"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("phonenumber"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf & (Request.Form("comments"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf
MESSAGE=MESSAGE & "____________________________________________"
Set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.From =Request.Form(email)
objMail.To = "icepricessa@hotmail.com"
objMail.Subject = "Business/Career Enquiries"
objMail.Body = ""&MESSAGE&""
objMail.Send
Set objMail = Nothing
%>
but somehow i'm not able to send the mail....
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.
My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?
Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.
Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?
While I can extract the option value from the following:
<Select name='Keystring' MULTIPLE>
<option value='1' name='status'>Pending</option>
.....
</select>
I cannot seem to extract the corresponding 'display' value when I do a
For...Next Loop:
for each keystring in Request.Form("Keystring")
keystring=request("keystring")
Next
How do I aslo get hold of that 'display' value eg 'Pending'...is it
possible?
I have a simple form to accept two form fields and display the values
entered on pressing the submit button. The following is the form I have
created to accept the two entries and display the form fields on
pressing the submit form. It does not work can somebody please correct
the code or provide a simple equivalent code where I can have the form
and the validation and usage of the form values in the same ASP page.
Code: