i am developing something , on one of the pages i have a download link. when the user clicks on the link he gets a download box on his screen. i would like to code in such a way that after the download gets completed then his balance stored on the database should be decremented.
View RepliesHas anyone successfully written an ASP page in JScript that implements transactions with a mySQL database?Please let me know - I'm having difficulty doing this.
View Replies View RelatedFor eg:In a asp page i have 2 insert statements & 1 update statements.All these 3 statements I am executing on same asp page by creating a connection object.But I want to make sure that if first 2 insert statements execute successfully, then only 3rd update is executed.
It is possible that after the execution of first 2 insert statements database goes down and 3 rd update statement does not execute at all.In short I want to treat these 3 statements as a single transaction block and ensure that either all the 3 or none of the statements are executed.
How do I control it in asp page?By writing stored procedures in database & executing it as a single transaction block(using begin transaction & abort or commit) it is possible.But is there a way to conrol this using asp?
Using the ASP 3 transaction functionality requires that the transaction flag is set as the very first code row, I understand. I now have a requirement to implement a transaction in one of the pages.
Unfortunately the whole site is based on SSI (server side includes) that are being picked up based on the users preferences. I have an index.asp page that does this selection, which is always loaded first. Is there any way around this, or do you guys have any
other suggestions?
I'm implementing a version control system but i need some help
in setting it up.
I use access as the database.
My routines are setup to allow insert, update, delete on the same form.
I have a ASP application with MS Access. I need to use transaction as there are server insert and delete statement.
oConn.beginTrans
Is it a correct way to use transaction? Would the server hang if there are around 10 (or less) concurrent users. Would the whole database being locked while a user is performing transactioin?
I've got a webpage that calls some stored procedures with input variables.
The procedures return recordsets and also some output variables. We're
trying to get the values of the output variables. I've done this using the
method I found in MSDN, as shown in the code below. The problem is that we
believe doing it this way involves the use of the Microsoft Transaction
Server (IIS transaction server). Is this true? (The SQL Server and IIS
Server are on different machines and, I believe, a firewall separates them.)
I can't see why this method would use MTS. The problem is that in the past,
we have had problems with MTS stopping for no reason, which causes the
websites to not work. So my boss doesn't want to use any ASP code that
relies on MTS. Not using the stored procedure output variables makes things
way more complicated. So does this code really invoke MTS? And if it does,
is there a way to obtain SP output variables without using MTS?
I am running SQL Server 7.0 with the latest service pack and IIS version 4.
We do have an IIS version 5 server we can use if that matters. Code:
I am working with MySQL database.
I am using ASP.I am using transaction safe table type InnoDb to create tables in MySQL.
I am accessing these tables from ASP using OLE DB provider for Mysql Version 3.0.When I issue a command like
conn.begintrans
I get the error "Provider does not support Transactions".
Pl. tell me how can I manage transactions for Mysql using the OLE DB provider.I thought of using MyODBC driver,but this driver always gives the recordcount as -1.
What is the best way to control is a transaction? I've done a little test and both of the examples below seem to do the job, but I was wondering which is the better method, this:
If err.number <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
Or this:
If conn.Errors.Count <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
Can any1 help me or suggest a helpful link for coding for Credit-card transaction.
View Replies View RelatedI want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.
I am trying to download files from one website to another for purposes
of caching. In trying to do this, I created a VB dll component (using
VB6), that used URLDownloadToFile, to allow me to download the file
onto the receiving site. The sending site supports an ASP page that
allows the file to be downloaded.The component works fine when run in debugging mode, placing the file as expected. But when not debugging (but registered), it reports that
the file has been downloaded, but the file is not there.
I am looking for some VB Script tutorials possibly as a pdf file that one can download and take print out of as one single file. I can see a lot of VB Script tutorials on the net but not offered as a single PDF file all in html format and explained on different pages.
View Replies View Relatedwhere I can download PWS Personal Web Server,or IIS from,ideally for as little cost as possible?I have XP Pro, but I've tried typing "inetmgr" in the Run field in Start Menu but it says it can't find inetmgr,and there is no IIS or PWS in my Program menus or submenus on my machine that I can see.
I had heard my XP Pro may have come with IIS but this doesn't seem to be the case with my pc. I have IIS on my server at work which has Windows 2000.Is it possible to copy an .exe install application of somekind which would be used to install IIS on another machine? What would the .exe file be called and where would it be located?
Is there a reference document for ASP (not ASP.NET) which can be downloaded? Perhaps an SDK? Where could I find this?
View Replies View RelatedI have created a script which connects to a SQL DB, runs a query, writes the results out to a file (Using FSO) then presents the user with a link to download the CSV. As the file contains sensitive data, I dont want to leave the file on the server, and I dont want to rely on the user to delete the file after every export.
View Replies View RelatedLooking for download asp script or java script for my zip files but without user know the location of the file/folder and can only log to this page from my authorized page.
View Replies View RelatedDoes any one know if there a ASP editor available that I can download as a trial version or free lisence?
View Replies View RelatedI have this javascript photo album i made. It is all working in tables and such. When you roll over a certain cell it will show that picture above, and turn the cell a different color. I also made the cell "clickable" when they are on it.
Is there anyway i can get it to when someone clicks that cell, that it will download that picture?? I have looked everywhere but i have not see anythign that will allow me to do that.
I'm using ADODB objects to download the images. Is there any way I can disable 'Save' option on a prompt. Also, when display the image (it could be any of the following files: .doc, xls, txt, pdf...), I need to disable 'Save' option or hide the toolbar.
View Replies View RelatedI don't know if this is possible, but does anybody know whether you can determine how long a file took to download. I want to be able to log how long a download took.
View Replies View RelatedMy problem is: i need to write an ASP page which first checks whether
the user has permissions to download a ZIP file, and then streams the
file itself if the user is allowed to see it.
I have succeeded until
this point, but the client browser asks to save the file with the
original filename (and ASP extension). Obviously this would mean
making the downloaded file unusable at client side, unless I tell the
site user to manually rename it, but this is not a solution.
So I ask you: is there any way for an ASP page to stream data to the
browser and have it saved with a default file name and extension which
are different from the page's ones? Code:
I'm having a problem with a script that makes the browser download a PDF instead of opening it.But when the file is downloaded, it downloads nothing.
The code is:
[vbs]
Set FSO = server.createobject("Scripting.FileSystemObject")
FileThere = FSO.FileExists(server.mapPath(request.querystring("f")))
If FileThere then
Response.AddHeader "Content-Disposition", "attachment;filename=" & request.querystring("f")
Response.ContentType = "application/pdf"
else
response.write("Sorry, file could not be found")
end if
Set FSO = nothing
[/vbs]
let me know and I'll pm you the address for it.
I need to show how long a given file size will download.
View Replies View RelatedWe have to provide a facility on the client machines to download the data
visible on a ASP page into an excel sheet. We are using WIN2k clients
connected to WIN2k server with IE6.0 installed.
The way we plan to implement it is that :
a) provide a right click and download to excel button from the ASP page
visible in IE.
b) on click of download make a server call passing the appropriate command
to send back the data in excel format.
My questions are :
Q1) Is there anyway to avoid the server call? I am not looking for OCX
either?
Q2) Are there any issues to do with memory leaks / deadlocks in case we use
such office automation to generate a report in excel? Is there a way around?
I have an example running at the moment that shares some 15,000 MP3 files however to offer these as downloadable i would be breaking the law i think !
I would like to set it up so that i have a method where the user can build a play list by going through the files and selecting them and then they would would be played either through the clients own system applications or through media components i can build into the site.
Maybe i could have some controls on there.
also why does the script not like to display files with the .ISO file extention ?
I want to make a support-page where people can download the latest help-files (these will be in a database) but I don't know how to do this (I only know the basics of ASP).
I don't mean that, for example a pdf, should open in another window. When you click on the filename it should give the standard downoad-box 'Open', 'Save', 'Cancel'.
Does anyone know how to do this? Or maybe there is some code on the net that explains it.
Downloaded the sendMail.htm and sendMail.asp sample files
from technet onto my IIS 4.0 server. The first 2-3 times
I tested all went well. Subsequent tests, with no server
changes, gave/gives me the "File Download" dialogue box
when the sendMail.asp file should be executing. Why does
sendMail.asp give a "File Download" box instead of just
executing?
While my wwwroot is under C:inetput, how can I make URL pointing to the
downloadable files on D:downloadmyfile?
Do I have to use download COM? If yes, which one is recommended for free?
I need to have script that automatic download files (open a "save file
dialog box") based on a variable (value in the URL).
Example:
files.asp?file=1 shall automaticly download file1.mp3 (open a dialogbox for
saving file1.mp3)
files.asp?file=2 shall automaticly download file2.mp3 (open a dialogbox for
saving file2.mp3)
I am in need of allowing permissioned users of a particular web app using ASP to query a table and then allow them to download an excel formatted version of the data they can use offline.
View Replies View RelatedCan ASP resume download/ upload when uploading large files using ASP, like Download programs do? If so, can anybody point me to tutorial or a script I can start with?
View Replies View Relatedhow to download .mdb file from the db folder. I had written .asp file to download that .mdb file. By programming it to copy .mdb file from db folder to httpdocus folder,but say one error that is Permission Denied !
I had tried another way that is converting tables to .xml file and downloading it - Its Working When i tried convert .xml file to table - Here, I need coding for conversion.