Adding Multiple Requests
I have never programmed in ASP in fact I am not a programmer at all. I found this script that sends an email that pulls information from a contact form.
'Sends an email
Dim mail
Set mail = Server.CreateObject("CDO.Message")
mail.To = "youremail@yahoo.com"
mail.From = Request.Form("your_email")
mail.Subject = "Contacts"
mail.TextBody = Request.Form("your_message")
mail.Send()
Response.Write("Thank you for visiting!")
Destroy the mail object!
Set mail = nothing
I got it to work with my flash contact form however on the form I have two other fields. Name and Phone number that I want to tack onto the TextBody but I do not know how to do this.
View Replies
ADVERTISEMENT
When simultaneous requests to open an Access Database occur, the Jet Database engine returns an error stating: Cannot Open file, already in use.
I know this occurs because I'm using a file-based Access database, and it's locked while data access is taking place. However, at this time, its the only platform available on the site.
My question is, can I somehow use an On Error GoTo Blah statement to catch the error, clear it, and then attempt the ADODB.Connection.Open statement again?
View Replies
View Related
how do i add afew items into a database of only a field name?
for example if there is only item_1.. it will add item_1 only. but if there is item_1 & item_2. how do i add them to the database name ("Items No")?
View Replies
View Related
SQL 2000 database with ASP
I've found many things "out there" regarding updating and deleting
multiple records with checkboxes but I can't seem to find anything
about adding them. A user wants to create a price list for their
client and they need to add parts to it in a separate table. I would
like to display the list of parts and the user would select multiple
parts to add to a price list by checking a checkbox and submitting the
form. Code:
View Replies
View Related
i have an instance where I need to add records to 2 different tables. i know how to do it basically, but the problem is, one table is generating a key number and i need this number for the second table records.
how do i put the appropriate records into the first table, grab the id number and insert the records into the second number? the information is coming from a form. i'm developing in an access db but will be moving this to an ms sql db before it goes live.is there a stored procedure that might make this easier? i know nothing about stored procedures.
View Replies
View Related
I am struggling with how to allow users to modify the quantity of items in their cart. Right now they can only add 1 of each item. To add 2 of the same item they have to add it again which then just makes it so there are 2 seperate instances of that item in the cookie/cart. My hope is to show a text box with the value for each ID so they can modify that qty ID that way......
View Replies
View Related
I woudl like to know why querystrings and numbers are used to pass requests ?
E.g. in this forum, sitepoints; to display asp pages, they used forumdisplay.php?f=148
whats wrong in using
forumdisplay.php?f=asp ?
View Replies
View Related
We have two Win2003 webfarms each consisting of 5 servers.Which we call and cluster2. Cluster2 is the bussiest of these two and periodicaly (varies from 2 times per day to two times per week) one of the servers (this is pretty random) starts to build up Requests Executing.
During this 'queueing' it still serves about approx. 75% of the requests.requests that don't come back with an answer are added to the Requests Executing count.This goes on until 100 requests are queued then it starts throwing errors like:"The CreateObject of '(null)' caused exception C0000005"
To me it seems like one of the 4 worker processes is not responding anymore.Is there a way to see why this is happening?SQL server doesn't report any locks.
View Replies
View Related
I seem to have some sort of security issue with my web server and was hoping someone out there might be able to help me. I am attempting to perform an HTTP GET against some .asp pages on my webserver and the request just seems to timeout.
When I perform the GET against any .htm page, all works fine, but any .asp page will timeout, even something just containing one line of html. Since all is fine with .htm pages, I do not believe this is a code issue, but rather some kind of security/permission issue. The web server is WinXP Pro SP1.
View Replies
View Related
I have a form. When I do action="POST" I can see the changes done by looking at ---- for example request("MyBox")
Where MyBox is a dropdown box and by doing request("MyBox") I get the selected value.
Is there a way I can get the number of requests done? (i.e if I had 3 dropdown boxes then I get 3).
Also is there a way to get a list of the names of all the requests (i.e if I had 3 dropdown boxes then I get MyBox1 MyBox2 MyBox3)
View Replies
View Related
On server A I've a web application WA1. Inside WA1 there are a virtual directory VD1 and an ASP page named page1.asp. Inside VD1 there is another ASP page named page2.asp.
page1.asp makes a ServerXMLHTTP requests for page2.asp.
If Debugging Flags on WA1 are enabled the request seems to be blocked,
if those flags are disabled everything seems to be ok.
Is my problem really solved ?
View Replies
View Related
I need some help with making an asp website that will batch user requests for a particular video file, and then once a few requests are made for a video, play that video to the browsers that requested it (after a certain period of time). Physical path links to the video files are stored on an access database and the videos are loaded to be played from that database. (These files will be located in the IIS web server directory).
An example of this is when a request is made wait till you get 4 more requests and then play the video to the 5 browsers requesting the video, or play the video after for exampele 15 minutes, even if only 1 request is made. This is therefore a near video-on-demand "NVOD" system in asp. The problem is, I don't know where to start, and although I have done a lot of searches on the web I am still not getting anywhere with this.
View Replies
View Related
I was asked if it was possible to send Outlook Meeting Requests through ASP. I know how to send mail using Server.CreateObject("CDONTS.NewMail") but I don't know if sending a meeting request (with buttons Accept, Decline, Tentative) is possible.
I have a form which grabs the date, time, and location of the meeting but currently its just sent through regular email.
View Replies
View Related
I have page1.asp with a form on it, then this goes to Page2.asp, the data is processed. I then want to access the same from data on page3.asp. Is there any simple way to transfer all POST requests to page3.asp without having to put them into session or Query-strings?
View Replies
View Related
I'm trying to run the below script on my website and keep getting the ever unhelpful
....
msxml3.dll error '80004005'
Unspecified error
....
on line 11
when i ran this on our intranet server at work it worked fine but on my personal site it wigs out can anyone spot anything wrong in the code?
<%
strLink = request("linkval")
strLinkDescr = request("desc")
If Not Left(strLink,7) = "http://" Then
strLink = "http://"&strLink
End IF
set xmlreq = Server.CreateObject("MSXML2.serverXMLHTTP")
'on error resume next
xmlreq.open "GET",strLink,false
xmlreq.Send ""
PageStatus = xmlreq.status
If err.number<>0 or PageStatus <> 200 then
Select Case PageStatus
case 404 PageResponse = "Page Does not exist (404 error)"
case 401 PageResponse = "Access was denied (401 error)"
case 500 PageResponse = "Internal Server Error encountered on remote site"
case else PageResponse = "Remote Server is: down, not accepting connections or does not exist"
end Select
Else
PageResponse = "Remote server was located and URL is valid."
XMLResponseText = xmlreq.responseText
End If
set xmlreq = nothing
response.Write(PageResponse&"<br />"&XMLResponseText)
%>
View Replies
View Related
I need to have a web page with information sent to another server for
processing (sql query, etc.) but instead of the information going directly
back to the browser, I need it to go to the original server for after
processing. Is this possible and can someone point me in the right
direction. It may be similar to the way credit card transactions are handled
but I'm not sure.
View Replies
View Related
I have 404.asp file that catches non existing pages such as www.site.com/es for spanish version of site. Now I would like to move ahead and have es.site.com instead. I started digging into subdomains in IIS and found out that usually when creating subdomain in IIS it creates a separate sub-directory by the same name as the subdomain created. From some reason the custom error 404.asp file I already have is not called when a call to a non existing sub domain page is made.
Anyone knows why?
How do I configure 404.asp to also handle subdomain page requests?
I know that in Unix/Apache I can use .htaccess file to direct calls to es.site.com to www.site.com/es quite easily, can this be done somehow on IIS?
View Replies
View Related
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
View Replies
View Related
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
View Replies
View Related
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
View Replies
View Related
I have a form on my asp page that sends data to an emailing script. I am working with other peoples code which is causing a lot of hassle. Is there any way of sending a Bcc address command from the form rather than the emailing script?
View Replies
View Related
I wanted to know how I should go about doing this. I have this query:
SQLmax="SELECT Max(OrderNumber) AS intTotal FROM Status"
Which gives the Max(OrderNumber).Say in this case it is giving out put as 37.
Now i want the output to be displayed 38,which can be done by adding 1 to Max(OrderNumber).
Should i get this by doing this way?
var=RS(intTotal)
var=var+1
Response.WRite var
Is this right?
View Replies
View Related
Im using this code to pass a value to a variable:
<a href="Artists.asp?cat=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>"> <%=rsuser( "art_Artist" )%></a>
How do I add another value to this link with the variable name catArt so that I can add:
?catArt=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>
View Replies
View Related
what do you think is the best way to implement an "add new row to table" functionalilty?
am using asp(obviously )im currently using document.createElement with javascript, but im having a hard time retrieving the data.am also thinking if this is really the best way to do this.or if this would work with all other browsers other than IE...
View Replies
View Related
how to add a password to using this connection string
<%
set conn = server.createobject ("ADODB.connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("dat48372.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
rs.Open SQL, conn
showall=true
%>
View Replies
View Related
i have a id1 field which has data like this 002,003,004 and i have to increment it by one when i add a new customer so this is what i do
Set rs1 = Server.CreateObject("ADODB.Recordset")
sql1="Select Max(id1) from table2"
rs1.Open sql1, Conn ,2,2
maxid=rs1(0)
so i get the maxid for example as 003. the next record will be added and it should be 004 and i do it in this way maxid= maxid+1
but when the record is added the id1 field has a value of 4 instead of 004
View Replies
View Related
Say I have to different recordsets that have the fields:
rsA.Fields.Item("A").Value ,rsB.Fields.Item("B").Value
How would I add those to fields? It may be my inexperience but when I
tried something like
rsA.Fields.Item("A").Value + rsB.Fields.Item("B").Value
didnt work because one of the fields was a empty value. I have about
6 fields i need to add together if a value exists in any of them.
Suggestions?
View Replies
View Related
I want to fix this problem, i dont no how. Bassicly there is blank data appearing in my database, for no apparant reason! Code:
View Replies
View Related
How can I add a new user on my server using ASP?
User example: myserver/user1
View Replies
View Related
I'm new to ASP and a few querys
I have created my database in Access with the following fields
StockCode (Text Box, Primary Key)
Item (Memo)
Price (currency)
Picture (memo)
OnOffer (Yes/No)
and I know that access table cannot have a picture in it, only a access
form using OLE, but how do I get my asp page to display a picture for
every record? The picture would be a picture of the product with the
Stockcode as the filename - m001110.jpg?
View Replies
View Related
I have an ASP page with a table that fills with records from a loop. Every
row gets a link to another ASP page with data from the row. The link is
written as <a href=newpage.asp?value1=xx&value2=yy .... and so on.
Now I try to let the user specify a number that should be sent to the other
page. But I do not want to clutter up every row with each an input field,
so I thought instead I would place it above all the data rows. When the user
clicks on the link, I want to include the input field to the querysting. The
problem here is that I cannot figure out how to refer to the name of the
input field.
View Replies
View Related
I have just finished building my first shopping cart in asp and MS Access. Originally the shopping cart was to be built for products with no size and colour, however as usual the goal posts have moved and I now need to incorporate a size and colour option for each product. Could anyone explain to me how I can go about doing this i.e. adding the different sizes and colours in the admin website and then linking them to a specific product when it is displayed on the products page? I know they both need to be in a dynamic drop down box when displayed on the products page within the shopping cart, but I am just wondering how to read the correct values out from the table depending on which product is being displayed. I have a normal products table at the moment with general fields i.e ID, name, description etc.
View Replies
View Related
I have a web page hosted by server1. I need to add a link to a web page hosted by server2. This part is simple. However, I also need to give the linked web page the user id for the user that was validated in server1 (it's in a session variable).
At first, I thought the following would work:
mywebpageonserver1.asp:
Response.AddHeader "MYUSERID", "whatever"
Response.Redirect "http://server2/mywebpageonserver2.asp"
On server2, mywebpageonserver2.asp:
View Replies
View Related
