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>"
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>"
what value range for this code?
set objTools=server.CreateObject("MSWC.Tools")
Response.write objtools.Random()
I executed code several times but couldnt figure out the value range and logic.Reason for asking is we are moving to windows 2003 server and now v need to change above code from our site.
moved an ASP application from a Windows 2000 to a Windows 2003 server I'm using MSWC.Tools to validate the existence of some files I got the next error
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
From where i can download MSWC.Tools and IISSample.PageCounter Components for Windows 2003 Server.
View Replies View RelatedHi people, I currently have a website and the asp pages include the following line:
"Set Tools = Server.CreateObject("MSWC.Tools")"
My site is hosted on Windows 2000 server.
The hosting company has offered me a new deal but on Windows 2003 servers, I took them up on this but found that my asp pages did not function as these servers do not have the Internet Information Server (IIS) Resource Kit installed on them. I found this out by
looking at http://support.microsoft.com/kb/q249290/.
As I am not the original creator of the asp pages and have no knowledge of asp, can anyone help me fix this problem where my asp pages will function correctly on the Windows 2003 server?
Do you have any working examples which show how to send data to an insertion point in the template file ?
e.g. how can I send data to "div" tag ?
Set oTools = Server.CreateObject("MSWC.Tools" )
oTools.processForm "output.asp", "template.asp", "<div>"
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 global.asa for my website where I use a counter from
MSWC.Counters to store the count of sessions. Unfortunately, every
time I look at it the numbers could go down, or up radically. I
tried using Scripting.FileSystemObject to make a text file where I
could store the count, but apparently that doesn't work in
global.asa.
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 Relatedhave 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 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 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 ?
If you care to share, please post what tools you use for ASP development. I've been using basically the same set of tools for a looooong time and was wondering what other like-minded people are using.
Me:
Dreamweaver MX for layout & design
Araneae for ASP
Photoshop 6 (too cheap to upgrade ) for graphics
...And I'm trying to learn VB and am tinkering with Flash
[Added later]
I also use Access & MySQL for DB work (very little Access anymore).
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.
What does eveyone here use to create their ASP apps?
View Replies View RelatedCan anyone give me good references on tools for ASP web programmers? I am
not talking about DreamWeaver or FrontPage for developing ASP pages, but
other tools that ASP web programmers should use, for example, for
performance measurements, etc... I don't know if there are any tools, I just
ask because I am new ASP web programmer.
Has anyone ever set up code samples for using UPS online tools I need it
for international shipping. I've been trying to setup the tools myself. Some
countries work fine, others produce validation errors. Other errors include
no shipping solutions between origin and destination. When I manually check
on the UPS site, they resolve without problems
I have a way to get all the pdf files listed on my server, but now comes the real challenge: finding text within the files without, that's right without opening them in the browser. anyone heard of or know a way that you can have the server look through the pdfs?
View Replies View Related