I have a Dynamic product page that displays the items using "DO UNTIL rs.EOF" and I have assigned form input type to be hidden(for some) for information that I would like to retrieve. On the product page I have a "Add to Cart" button which points to my "addCart.asp".
addCart.asp is where I would insert the items into a Table called "cartItems" in the Database when the user clicks on the "Add to Cart" button.
My "addCart.asp" now generates a "Syntax error in INSERT INTO statement." which I think is caused by my inability to filter for the values from the product page and insert it into the "cartItems" table. Code:
I have a shopping cart in which I am trying to use breadcrumb style navgiation. I need to be able to display the categroy heading relating to the section of the site a visitor is using i.e If a user is in the "camera" section I need to display that heading as a link "camera", however in order to do this at the moment I am querying the database and storing the recordset in the application object (see below). Code:
I have a page where a user can edit the meta tags for the page which are then written dynamically at the time of the page being redendered.
I was wondering today whether this actually works or not? ie, if a search engine (google or whatever) is trawling a site, does it only read html pages? What happens when it encounters an .asp? Surely it wouldn't execute it and therefore be able to read the meta data correctly?
Any info on this would be appreciated, if my current way of doing it is not appropriate I will need to invest some time into changing it.
I have a data entry form. If the user submits the form without entering any data, the record should be inserted with null entries for the respective fields. But when i execute the INSERT SQL query with these null values, it gives me an error. This is vat I am doing:
<% ..... address = request.form("address") if request.form("Age")= "" then ageValue="" ..... ..... %> I use these values in SQL query This is the SQL statement when the above is executed " INSERT INTO tblStatistics (Age,address) VALUES (, aaa)" Because of no value for age, the query is not gettin executed. I dont want a 0, I want a nul entry (<null>). Could someone throw some light on how to set the age field to null?
My page is acting as if it is working but it is not depositing the values into the db. Should I be using a update query? My response.write statement is perfect as follows: Code:
I've created a page that has a dropdown listbox with values derived from a recordset. That is working fine. What I want to do is take a value selected from the dropdown listbox and pass it to another page that is pulling a report based on the parameter I'm selecting in the dropdown listbox.
I'm able to do this with a textbox being used to accept the parameter, but I want the client to select from a list of actual values, which will then "filter" their report.
I am trying to generate an email from the webpage using code below, which works fine. However I want to be able to include some dyanmic data how do I go about it ?can anybody point me in the direction of some sample code ?
Dim myMail Dim HTML Set myMail = CreateObject("CDONTS.NewMail")
HTML = "<!DOCTYPE HTML PUBLIC""-//IETF//DTD HTML//EN"">" HTML = HTML & "<html>" HTML = HTML & "<head>" HTML = HTML & "<meta http-equiv=""Content-Type""" HTML = HTML & "content=""text/html; charset=iso-8859-1"">" HTML = HTML & "<meta name=""GENERATOR""" HTML = HTML & " content=""Microsoft Visual Studio 6.0"">" HTML = HTML & "<title>HTMLMail</title>" HTML = HTML & "</head>" HTML = HTML & "<body bgcolor=""FFFFFF"">" HTML = HTML & "<IMG SRC=""http://www.microsoft.com/library/" HTML = HTML & "images/gifs/homepage/microsoft.gif"" BORDER=0 " HTML = HTML & "WIDTH=167 HEIGHT=36 ALT=""Microsoft Corporation"">" HTML = HTML & "<p><font size =""3"" face=""Arial""><strong>" HTML = HTML & "Microsoft Exchange CDONTS Example</strong></p>" HTML = HTML & "<p><font size =""2"" face=""Tahoma"">" HTML = HTML & "CDO for NTS allows an easy way to send mail.<br>" HTML = HTML & "This example shows how the content can be " HTML = HTML & "an HTML page<br>" HTML = HTML & "which allows you to send rich text and" HTML = HTML & "inline graphics.</p>" HTML = HTML & "</body>" HTML = HTML & "</html>"
myMail.From="someone@microsoft.com" myMail.To="someone@microsoft.com" myMail.Subject="Sample CDONTS HTML Message" myMail.BodyFormat=0 myMail.MailFormat=0 myMail.Body=HTML myMail.Send set mymail=nothing Response.Write "Message Sent" %> </HEAD> <BODY> </BODY> </HTML>
Each three digit number in the string represents a unique ID of a file in a database. Following each ID are six digits, all seperated by a "_" . Each file will ALWAYS have six subsequent integers, such as above ID "234" has "_0_8_22_2_0_3_" following it.
What I am trying to figure out is given a string of any length of this specific pattern, how to decarle a multi dimensional array that would hold each ID and its corresponding digits.
To clarify a little further, this is from a shopping cart for a photographer. Each "ID" represents an image, each of the six corresponding numbers for each ID represents a qty for an image print size, ie., 4 4x6's, 5 5x7s, 0 8x10s, 1 16x20, 23 20x30's, 48 wallets. Oh, and the image ID's are not necessarily always going to be 3 digits, they could be of any lenght integer...
Basically I want the text in the iframe to change depending on the pid value. (pageID), I have all this set-up previously in my functions page. Except the only way I can see any action is by running the iframe directly and passing the querystring like iframe/iframe.asp?pid=4 and this works fine, but in my main window index.asp it does not change.
I have an idea that when i type index.asp?pid=3 its trying to get the querystringbased on the index.asp not the iframe.asp, so does anyone know how I connect these two up so that my content will change in the iframe held within the index.asp page.
I am am trying to write some code to perform a INSERT in SQL table using a loop. What would be great is a way of dynamically entering in data in a requaest.form ie the final code should look something like:
if Request.Form("type1") = "1" then
where the 1 in "type1" is dynamic so the code would look something like
Request.Form("type" & Rs.("fld_type_id") & ") = "1" then
But not sure how to form this or whether it would work, anyone have any idea?
i want to have a bubble pop up on hover but in that bubble have data from a database populate it. has anyone else done this , if so how? Also i would like to try to stick to vb/asp/html if possible.
I am looking for a software that can generate a tree of data. For example, I am trying to track real estate relationships like a lessor, tenant, general contractor, and subcontractors. I would like a visual representation of this relationship based on the values in my database showing the hierarchy much like a site map or family tree. Can anyone recommend how I could do this or suggest a software?
I have sent form data through email using .asp before but I have never done it when you are using a form that has createelements involved. I have a form w/ 3 inputs, two text inputs and one select combo box. if i click an add user button it will appear with another row of 2 text boxes and a combo box, and you can repeat up to as many as you need. I am trying to figure out how to mail all of those values to someone. Is there an easy way. Below I will attach the code that I use to name the fields when they are generated maybe it will help....
<SCRIPT language="javascript"> counter = 1
function addRow(id){ var tbody = document.getElementById(id).getElementsByTagName("TBODY")[0]; var row = document.createElement("TR"); row.setAttribute("id","tr"+counter);
var td2 = document.createElement("TD"); var input2 = document.createElement("INPUT"); input2.setAttribute("type","text"); input2.setAttribute("name","pName"+counter); input2.setAttribute("id","name"+counter); td2.appendChild(input2);
var td3 = document.createElement("TD"); var input3 = document.createElement("INPUT"); input3.setAttribute("type","text"); input3.setAttribute("name","userName"+counter); input3.setAttribute("id","prc"+counter); td3.appendChild(input3);
Does anyone know how I can insert daynamic text box data into a SQL Server database? I have text boxes that are being generated dynamically and I want each of those values inserted into the database that hold the results. I'm not sure how to write my loop statement.
A page I'm working on contains a registration form which is supposed to a) update an Access database using ASP and b) email the contents of the submitted form to the camp administrator.
This is my first experience with ASP, and with any kind of database interfacing language, for that matter. Currently I'm struggling with the record insertion. I'll worry about email afterwards.
I'm using Dreamweaver 8, which is generating all the code for me. I have a testing server set up on my local machine (in my working directory, in fact). I've told DW to connect to the databse (located in %siteroot%/database) through the testing server using a DSN (same DSN as on the web server). Code:
I am trying to test a sql statement in Access which gives me the error as stated in the heading.
The sql statement is built as a part of asp login verification, where the userid and password are input in login screen. The password in the database is a number field.
I am writing the dynamic sql statement as follows below. I believe I am going wrong in the password section of the code:
I'm trying to write a page that will accept form POST method variables from another page and save them to an Access database via a DSN connection. I'm using code like this:
I'd like to make sure that I clean up the text that the user inputs before trying to send it to the database. Can someone please give me an example of what ASP code I need use to get rid of quotes, slashes, and anything else a user could enter that might mess up the SQL insert?
I am using ASP Upload to upload an image to a website. I have other form fields in the form that are used to obtain data and are inserted into an access database. This occurs on the same page as the page that upload the image. Everything works fine except it inserts each record twice into the database. Anyone have an idea what causes this or what I can do to make it only insert once. I am useing the progress bar and don't know if that has anything to do with it. Here is my code.
Set rsPhoto = Server.CreateObject("ADODB.RecordSet") Set Upload = Server.CreateObject("Persits.Upload.1") Upload.ProgressID = Request.QueryString("PID") Upload.SetMaxSize 500000, True Upload.Save ....
i have written a stored procedure. depending upon different parameters, query is prepared as string and executed through exec() function. it returns a certain number of rows. stored procedure also contains a temporary table. the question is this how can i insert the rows returned by the query in to temporary table?
I'm using CDO to send mail to the site owner from ASP pages with forms. Recently one of my forms is occasionally sending email with what seems to be an insertion which is replacing the plain text part of the email with something else. Looking at the server sent email source, the hacked emails have the following:
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
i want to print some data in the menu list. first, i have to select (checkbox) several data in the different page and then after complete it, i hit the print button. it's a same like add cart but with no trolly.
I need to build my own simple cart that writes to cookies only. I can write and read cookies, but don't have a clue as to how I can add multiple products, change quantites, etc. All I need is a cart that stores information in cookies and the user prints their order. That's it. Where can I find such information?
i was wondering if anyone could give me a few ideas on how to create a shopping cart using asp or even a good website asi have been searching and have not found any
how should i assign a unique id to a user ? i've used the sessionid in the past but have found that the sessionid is not unique. is there a better solution for assigning a unique id to each visitor ?
secondly, what's the best way to track visitors as they move about my site ? i'll be recording items in the cart in a database but will still need to track the user on each page ... session variables or a cookie ?
what's the best ASP shopping-cart available? I have looked in Aspin and there seems to be a few good one's around. Anybody tried any of them? Ofcourse, it needs to be fully-featured with order-tracking, intranet product management, etc.
I have made the following shopping cart. which displays data fine but when i hit the add to cart it is saying "No value given for one or more required parameters"
so i have not seen my cart working I would like to also add Images to this later but im taking one step at a time Code:
