How can I get this line to work? I am trying to get the results entered in a form to be part of my query. I am able to get the form results but I get a error stating Syntax error (missing operator) in query expression 'Assignee = Tom Jones'.Below is the line where the error occurs
Session("dbWhere") = "Assignee = " & Request.Form("assignsearch")
I'm stuck on trying to display a single row from a query I'm executing.. it was fairly easy in PHP and I'm sure it is in ASP too, I'm just not sure what to code.. I couldn't find anything on the web that was simple.
If anybody has some suggestions on how to display just the one row that is returned from the query that would be great for now. I'm looking to eventually add 'LIKE' to the query to allow for similar names/passwords to be displayed.. but for now this should do. Here's the code:
I want to write all the query results onto a file so that it is all ready to give to the client.
I am currently writing a query to pull out certain orders in a day and i want to write these results directly to a text file.Also this text file will be obviously placed on the server..is there any way of creating this file on the computer you are accessing this web page on?
I need to create asp page witch has a form at top of the page. This is the search form. Then I need to present the search results from database query on the bottom of the page as a table. That table has about dozen columns. Some column values can be modified and saved to the database and some column values has to be modified and saved from another page.
Search table is no problem but I have problems getting the results table to work right... Query results are in recordset.
I need some advice on how to do the results table on the best way!
So far I am thinking on creating a form on every row of results and posting the changes of values to save.asp page where I would save the modifications to database.
For the values witch have to be modified on another page I would add a link something like this... Code:
I'm trying to get results from a number of areas via one command string.for example ?location=devon retrieves everything in devon but I've only got a link for the whole south west so I need to send ?location=devon or cornwall or dorset etc. altogether.Is there a way I can do this without changing the asp page or do I have to only search one field at a time.
View Replies View RelatedI am working on a classic ASP application. This application needs to run an SQL query and take the result set and stream it into an XCEL spreadsheet for processsing by the users. Is there an ASP method of third party product to do this?
View Replies View RelatedI am trying to design a page that displays data from a query in groups of a field in the where clause and then displays a 'total' per each group. Code:
View Replies View RelatedHas anyone experience with rendering CrossTab Query results with ASP?
For example, using this SQL:
TRANSFORM Count(threads.threadid) AS CountOfthreadid
SELECT threads.threadSeverity, Count(threads.threadid) AS [Total Of threadid]
FROM threads
GROUP BY threads.threadSeverity
PIVOT threads.threadStatus;
This returns the following in Access:
[threads_Crosstab] [threadSeverity] [Total Of threadid] [Analyzing] [Closed] [Coding] [Open] [Re-Testing]
[Medium ] [1] [1]
[Not Set] [160] [1] [122] [1] [35] [1]
I want to create a HTML table to display the results in my webpage. However, I don't belive the output from a "Transform" is a true recordset. When I request the names of the fields in the recordset, I am getting data from the "rows".
Is there standard way to display these types of queries? How does one access the data in a crosstab query? Are there ojbect classes to handle this?
I'm attempting to limit a query which is being ordered by a date field to 10 records. The date field contains duplicate values, which are sorted from most recent, back.
However their suggestion of sorting by a secondary field is not providing acceptable results (it returns all the rows in the database). Does anyone have any suggestions of another way around this?
I have an asp page that needs to display the string that is returned from a
cgi file.
As an example, if you enter http://mydomain.com/mycgi.cgi?98127398 in to a
browser, it will display YES or NO
I need to have my asp code query this url, get the resulting string, then
act upon it (basically use the answer to display a nice big tick or a big
cross). Code:
After commands like:
tmpDBconn.Execute("DELETE * FROM mytable WHERE rc_id = 10" )
How do I check for errors?
Is there a way to check the results?
OR:
Set rsCatCount = tmpDBconn.Execute("SELECT COUNT(*) FROM cat WHERE key_id = 10 AND cat_id = 6")
How do I get the count? Do I use rsCatCount(0)?
here's what i want to do. from an asp page, perform a search on a
table in access. i have used sql code in the asp page itself, but i'd
rather execute a query in access. i have success in running any query
(basic SELECT, SELECT with conditions _other_ than LIKE, etc..) for
some reason, when i execute the query below from the asp page, i get
no results.
the search.asp page just has a text box in a form that submits the
srchBOX field to the results.asp page.
here's the asp code from the results.asp page: Code:
I am trying to search through an access database for tickets createded with in a certin date. I am using the below code.
strdate = DateAdd("d", -2, Now())
sqlstr="SELECT * FROM Incidents WHERE TicketDate BETWEEN #"& Now() &"# AND #"& strdate &"# ;"
I verify the query with response.write and get the following.
SELECT * FROM Incidents WHERE TicketDate BETWEEN #15/07/04 19:19:32# AND #13/07/04 19:19:32# ;
I know there are 100% tickets within this date. Yet my query returns nuthing. Please help i've searched this forum for other peoples code looking for examples but end up with the same result.
I have programmed several online forms(typically using cgi).A client of mine does not like how the results are formated (the long column of text)Is there anything I can do to program the results of this online form to get put into another format that would be e-mailed to the receipient?
View Replies View RelatedIs there a way to grab all the results from the querystring which are sent via a form submit? In PHP, you can just do something like $var = _GET; which will grab all the fields on the querystring.
View Replies View RelatedI created an html form in which the results will be emailed. Right now the results are able to be emailed in text format. however, i need to somehow parse the information in to html format.
this is so that the person that will be the one receiving the results will be able to process the forms without having to reinput any information into the actual form for filing purposes.
The first page you come to in my Web application is default.asp. This gives
the user the ability to click on a drop down menu and choose a prior date
( to update or add info) or they may simply choose to add a new date and
info. They click on submit and it sends the info to the database and opens
up another page called updateproduction.asp. This page shows the results
from default.asp plus other calculations. I have a button on
updateproduction.asp that says "Send Email". When I click on that I want
the user to be able to send a copy of the updateproduction.asp page to
several email accounts. I currently have tried using CDONTS and can click
on the "Send Email" button to send a test email with html (Simply "You have
sent a successful email" in the body) with success.
If I can't send the asp page, is there a way to save the asp page to an htm
page in the code? This would allow me to send a link out to everyone
instead of the actual page.
I have an asp form. The results of the form both populate a database (thus generating a unique id #) and also get emailed. I now need to send the unique id in the email. How do I do this if the id is being created concurrently with the email? Code:
View Replies View RelatedI was wondering, is it possible to send the results of a web form through email instead of storing it in a database ?
would it be done it such a way
Code:
<form ACTION="mailto:aymenz@company.com" METHOD="POST" ENCRYPE="text/html">
also can i use both: store in the database and email the results of this webform to 2 reciptients, the buyer and the seller
I have a form with two textfields. When the user hits the submit buttom I want the server to email me the results from the textfieds. Can anyone help me with this?
View Replies View RelatedI am trying to post the results of one form to another target .asp page - I do not know how to write the code. I have ran through tutorials etc., and my ISS 5 documentation - basically this is what I am coming up with. Please confirm if this is correct code used on the target page - the page that rcieves the form results.
<form action="CSSI-CMS2.asp" method="GET" enctype="multipart/form-data" name="e-design">
<%
Response.Write(objItem & " = " & Request.Form(objItem) & "<br>")
Next
%>
</form>
Can someone please tell me if its possible to create an instance of CDOSYS (to send an emails) on one host and have the email sent from another host.. or are there obvious gaps in my understanding of what takes place when one tries to send an email using CDOSYS or CDONTS?
View Replies View RelatedI have 2 part question: I have an html form: https://ws13.ipowerweb.com/eoscorg/pre-op_form.htm I created that has to have SSL on it. The form also includes a confirmation page to the user after the submit button is hit. However, I have been informed because I used Front Page to create the form, the SSL doesn't work with Front Page's form handler. So I want to know if I can use ASP.NET to create the form and without any conflicts with SSL? Also, I want to find out if all the form objects (form fields, text box fields) have to be coded as ASP.NET objects or can I keep the html form objects and just use ASP.NET code to send the form to an email address and to then send the confirmation page to the user? In other words do I have use ASP.NET code for the whole form?
View Replies View RelatedCan I send a form to the DB and email it at the same time? How do I do that?
View Replies View RelatedCode:
Mail.Subject = "Website - Account"
strEmailText = strEmailText & "Company Name: " & Request.Form("compname") & vbCrLf
strEmailText = strEmailText & "Company Address: " & Request.Form("compadd") & vbCrLf
strEmailText = strEmailText & "Business Nature: " & Request.Form("businessnature") & vbCrLf
i would just like to know how i can add bold/underline and line breaks in this email because at the moment it just displays the email like this..
this: this thing
this: this thing... etc
I have created a form in HTML with no problems, but I can't find any tutorials on how to (or whether I even can) have the results of what the user inputted into the form directly to me. I would also like to be able to have the results stored in an Excel Spreadsheet as well. I've found tutorials on how to send to addresses inputted into the form, kind of like a 'Thanks for Participating' sort of thing and I've tried to modify it to get it to work for sending me messages, but I just can't get it to work.
View Replies View RelatedI am trying to build a page in ASP/MSsql with the aid of dreamweaver, the page contains total of 6 Questions, each question has 3 choices, of which one of the choice contains the right answer with a hidden value = to 1 and the wrong choice hidden value = to 0.
What i am trying to achieve is to collect the values and insert it to a database and at the same time display the results on the confirmation page.
Collecting data’s and inserting to the database is not a problem which i am able to do it. The area that i am stuck is the possibility to collect the values, adds the number of right answers (e.g. 1+1+0+0+1+0 = 3) and displays it on the confirmation page.
I was thinking if it was possible to use cookies for this, like storing the values Q1 = 1 when it is correct and Q1 = 0 when it is wrong while submitting the form and the confirmation page retrieves the values from the cookies, addition the number of right answers ( Q1+Q2+….Q6) and display it on the page.
E.g. the confirmation page displays: Your score is 2 out of 6.
I have an asp page that gives results for a search from a previous page from streetguide.streets in MySql. The page displays the UserName of the person logged in.
I have the results of this query displayed inside a form with hidden variables. When the user clicks "save to my folder" I want it to create a table in the mysql db with the same name as the user name, and then write to this table.
I have it working if I created the table beforehand, but I want the table to be created dynamically upon form submission with the table name to match the persons user name.
I have a webpage with ASP that is a form. I have the form setup to send the results to an email address (using the Frontpage feature). We have published the page to the web, but it will not send email. It simply does nothing. This is the code:
<form name="Datasheet" method="POST" action="DataSheet.asp" webbot-action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults" S-Email-Format="TEXT/PRE"
S-Email-Address="ray.clark@721-file.com" B-Email-Label-Fields="TRUE" S-Builtin-Fields startspan -->
I have purchased a form processing script, which basically saves the data into a database, emails certain people's email addresses with the form results, and also sends an email to the user that filled in the form with a thank you email.
However, all the emails are being sent in plain text format. I would like to change this to HTML so I can make the results look nicer and also make the thank you email look nicer.
I have emailed the script developers, but have yet had a response from them, so i thought id put a post on here!
I have found the part of the coding that sends the Thank You email out to the user once they have filled in the form:
'/// Send Autoresponse
if replyto<>"" and (autoresponse<>"" or sendcopy<>"") then
if sendcopy<>"" then autoresponse=autoresponse & vbcrlf & vbcrlf & message
call sendmail(replyto,mailadmin,formname,autoresponse)
end if
end if .......
I need to select the data where the data ID is equal to the variable supplied in the submitted form. Below is the line of code I used for the radio select and the code to do the SQL search on it. I get the following error using this code:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/MyWeb/CheckIn.asp, line 93
The items are listed by ID 1-X.
<input type=""radio"" name=""CheckIn"" value=x.value>Check In<br>
Dim junk
junk=request.form("CheckIn")
'If Session("UserType") = "User" Or Session("UserType") = "Admin" Then
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
Set rs=Server.CreateObject("ADODB.recordset")
'in below, WHERE id = Request.Form("CheckIn")
SQL = "SELECT * FROM CompsIn WHERE ID = junk"
rs.OPEN SQL, Conn, 3, 3
rs.OPEN SQL, Conn, 3, 3 = Line 93
I have 2 databases, one i write two when i submit the form, that works fine. The other holds contact info. I need for when the Company Initials are typed in(form CSN) that the Pace Administrator info fills automatically(PAName and PAPhone). Code:
View Replies View RelatedI am trying to use form input (like text from a texbox) in a SQL query. So that way a person can enter a value in a textbox and hit a button to check for that value in a database. I have the connection to the database working fine its just passing that form value into the SQL string. I wish the SQL query would work like this:
SQLCommand = "SELECT * FROM dahliaSchedule WHERE scheduleDate= " & txtDateValue
where scheduleDate = (a value from the textbox from the form.)