anyone have a quick example of using insertion point of data with MSWC.Tools ?
e.g. how can I send data to "div" tag ?
Set oTools = Server.CreateObject("MSWC.Tools" )
oTools.processForm "output.asp", "template.asp", "<div>"
anyone have an example of using insertion point of data with MSWC.Tools ?
e.g. how can I send data to a "div" tag ?
Set oTools = Server.CreateObject("MSWC.Tools" )
oTools.processForm "output.asp", "template.asp", "<div>"
I have a asp page which is pretty long. This consitst of various recordsets. My intention is to stop execution of a code at a cetain point and test one value prior to this point. Is there any way to do this?
View Replies View RelatedI 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 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 have a lil text box that I use to insert into a db. It inserts fine, but anytime i post something like
he said "i don't know" how to do this
the only thing that shows up is everything before the quote.
Am I suppose to be doing a replace for quotes also or does it only apply to apostrophes?
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:
trying to use CDO object not working, have tried to set up default mail account which works ok, but CDO not piping through it. any know of any way to point CDO to box's mail account or something like that?! annoying coz CDO works ok on myother box, box not working on running SBS 2003.
View Replies View RelatedI'm wondering something about global.asa. We have a stats package that has been written for us. It tracks sessions by tracking session IDs rather than IP addresses, because this is much more accurate (tracking by IP can only give you an average guess at numbers of sessions).
The problem we have is that static HTML pages do not create a session ID. It remains as "-" in the log. I'm wondering if we can use a global.asa file to force IIS to open a session? The thing is, this will still be useless if global.asa only runs when the ASP file is requested, rather than when the first site file is requested.
So, now you have the background, the question is quite simple:
Does global.asa run when you first hit a site (ie: when default.htm is called) or does it run when you first hit an ASP page (like search.asp)?
Obviously, in the latter case that can mean that it's perfectly feasible for someone to spend half an hour on a site and never actually fire the global.asa or trigger a session, which is a rather fundamental problem.
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:
<%
SQL = "INSERT INTO myTable (postVar1,postVar2,postVar3)"
SQL = SQL & " VALUES ('" & request.form("postVar1") & "','" & request.form("postVar2") & "','" & request.form("postVar3") & "')"
dsnConn.execute(mySQL)
%>
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?
View Replies View RelatedI am just starting to think about adding a db to my Webs. I want to use a db
to change pages within various Webs and subwebs by scheduling these pages
ahead of time so the pages will already be loaded (visible) when a visitor
arrives. Sometimes I will need to replace one exisitng page with one or more
pages for the scheduled time period.
After the time period has passed, I want the Web or subweb changed back to
what is was before the original change took place automatically. None of the
Webs or subwebs will require any ecommerce or tranactional capability.
I have the following code in a script:
' Pecentage Interest on Loan
YearlyInterestPercent = 6.5
' Get Annual Interst Rate from Interest Percentage
YearlyInterestRate = YearlyInterestPercent / 100
' Divide Yearly Interest Rate by 12
' to Get Monthly Interst Rate
MonthlyInterestRate = YearlyInterestRate / 12
These values are supplied by the user using a form but I made them static for this example. For some reason, when dividing the Yearly Interst rate by twelve, MonthlyInterestRate equals 5.41666666666667E-03. The result should be 0.005416667. Does anyone know what I can do to correct this?
ok i have a number lets say its 36 and i want to divid it by 150.... 0.24 returns... i want to change 0.24 and make it a percent to it would be 24% how would i do that...
View Replies View RelatedI need to know how to handle errors if a write to the database fails. Here's the pseudo-code:
View Replies View RelatedCan any1 gives me code tht helps me to export data from ASP-Database to any file format (xls, txt, ....)?For an example..there is a site for the result of our college.. its an asp connected to the result DB.. it takes the student number and returns query "name and grades".
What i need is a code (or helping tutorials) tht gives tht asp page the number of student and exports his data, then the sec number and exports his data and so on.
how one can separate an HTML file from the actual code. For example, if I want to create a printer-friendly version of a page, I don't want to have duplicate data.
So, what is the best way to have an ASP .NET page which just just contains layout and other structural code and have it be fed an HTML file for it to display as the main data.
have a 'money' field in the SQL 2000 table that users enter 200 (for example
which represents �2.00) without the decimal point, what I need is to have a
command or something that adds the decimal point before the last 2 digits,
so user enters 200 and the value stored in the table is 2.00 bearing in mind
that this value could be anything from 1.00 to 50.00.
if a page always have some picture that totally have near 250k does this a main point of affect the loading speed?
View Replies View RelatedHow can change the mouse point to Sandglass?
View Replies View RelatedI have created a web application using ASP with VB.I would like to export some of my web pages (.asp page) to Power Point slides and view it as power point presentation.
will it be possible ?
I am trying to solve the following exception. The exception occurs when my
ASP.NET code behind code attemtps to access a remore site using SSL. Please
note that all certificates are valid and the remote site is trusted. Also, my
web site uses a custom HTTPModule implemented in a DLL named Security.dll.
Unable to find an entry point named EnumerateSecurityPackagesW in DLL
security.dll.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.EntryPointNotFoundException: Unable to find an
entry point named EnumerateSecurityPackagesW in DLL security.dll.
I am curious to know that if given two strings such as
http://www.domain.com & http://www.domain.com/somepage.asp how could I compare those strings to see if they are from the same domain? I am setting up a link exchange that requires a person provide their url and a verification url where my link is located. What I am trying to avoid is having someone do this:
www.theirdomain.com & www.someotherdomain.com/links.html whereas the second domain may have a link to my site but it is not related to the entrants domain.
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'm looking for sample code that will require a use to enter a code from a scued image format.
I'm sure you've seen them before where the image is barely readable by a human and the user has to enter the code correctly to submit the form.
I'm looking for ASP code and NOT ASP.NET code as I am supporting a legacy site.
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
View Replies View RelatedWe are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.
THE RESULTS:
(returns a blank page with only HTML Titles)
THE SCRIPT:
(you may notice this is a modified sample script): Code:
Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be.
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/admin/update.asp, line 111
line 11 is strName.execute
I read it might be forbiden characters in the data base field names or spaces...
but i don't have that. the names are userName, userLevel, ID, Password.
This seems a very complicated task, so I welcome any
input. My boss wants a data grid or matrix of the top 6
orders with ordered items, and products, for a particular
customer and he wants to see it like this:
products down the left side
orders across the top
number of items under the respective order number column
across from the corresponding product.
I hope that makes sense.
I have three tables. Products, Orders, Orderitems. I
don't even know where to start. Many thanks in advance
for any input offered.
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code: