According to Access my ADO connection has a value of 16 for the Transaction DDL property. Does anyone know what this equates to? I've found this page -
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adosql/adoprg04_83jt.asp
But it doesn't tell me which constant this relates too, and I haven't been able to find an answer at Google either.
I am trying to find out if Access is capable of utilizing the transaction function of ASP. I have seen differing points of view online and am looking for clarification
I have 2 inserts that run. If the second fails (for whatever the reason), the first should be rolled back.I have to use Access - is this the way to go or is there another option?
I am using 2 stored procedure in my asp application. in my asp page i execute 2 stored .. their works depend on each other. i want to apply a transaction on these. must i apply it in stored procedure or in asp page.. any example or any link. can u help me about transactions.
View Replies View RelatedI'm trying to determine if I can use transactions in my ASP applciation against one of our Oracle 9i databases. My WROX manual says I can do this if the Transaction DDL property of my connection object is equal to 8. I've checked my connection properties with the following script and determined that my Transaction DDL property is 2
'============================================
Set conn = Server.CreateObject("ADODB.Connection"
conn.open Session("PROVIDER")
For Each Item In Conn.Propertie
response.write Item.Name & " = " & Item & "<br>
Nex
'============================================
But what is 2? MSDN (http://msdn.microsoft.com/library/d...oprg04_83jt.asp) says there are a number of possible vaues for Transaction DDL such as
DBPROPVAL_TC_NON
DBPROPVAL_TC_DM
DBPROPVAL_TC_DDL_COMMI
DBPROPVAL_TC_DDL_IGNOR
DBPROPVAL_TC_DDL_LOC
DBPROPVAL_TC_AL
But which one relates to value 2
I have problem i need to carry out a transaction on a ASP page... the page goes like this:
<%
Conn.execute (Sql) ' Where the Sql Gets the Set_Number froom Table1
Conn1.execute(Sql1) ' here the Sql1 inserts the Value (Set_Number + 1 ) 'into the Table2.
%>
This page should be Executed as a transaction or else please help me out how to lock tables so that no other person can execute the same page with same data simultaniously...
I dont use any components in this page..so now how to go about with this...????
In asp.net, there is an object sqltransaction we can use to garantee the
data will be written to database either completely or none will be written
into database.
I am not sure if there is a similar thing I can use in classical asp.
Can you provide some info
I have an access database for a hotel room list which includes how many rooms I have available for each hotel. This list is updated via a form that updates the database, either adding or removing rooms. The database is on the server and is accessible by four employees, each of whom can update the hotel room number as they sell them.
The hotel rooms are in a table and this table is updated and records who updated it last by overwriting the previous update entry. I want to create a log file that records ALL updates each time the form is submitted, so I can track all transactions. I have not found any info on how this is done. Do I need to create a secondary table that only records when the form is submitted and database is updated?
I have builded a web site that performs db queries and insert records, and I'm getting a overwhelmed amount of hits. Which was good but it created a big problem. I ran out of db connection licenses, because the way I did it, it opens/close a new db connection for every db action.
I read something about opening the db connection at the application level but most people think that's a bad idea.So I tried looking into MS Transaction Server but I don't know where to begin. I need to know how I could use it and how I could set the # of db connection allow.
I have a Bill table (tblBill) and there is a running bill number being stored for each transaction (1001,1002,1003...). This running number is not from mssql identities.Currently i am using "SELECT MAX (billnumber) FROM tblBill" and + 1 to get the following running number and store the next transaction.
This method works well if each transaction execute one at a time. Now i am having problem when there is more user executing the transaction concurrently. Sometime i will have 2 different transaction with the same bill number.How do i control so that a transaction will only execute at a time or using my method above is just rubbish? I am hopping this to be solve in ASP rather than in MSSQL.
I looked everywhere, but I can't seem to find an example of a transaction in MySQL using asp. I need an example of the following:
1. Add a record to a table
2. retreive the last inserted id
3.add to a second table
these steps have to be in a transaction. so I would need to check for errors too.
if it is possible to do recurring billing to Authorize.net using ASP Classic. I have no problem doing one time transactions.
View Replies View Relatedhow can I apply transaction, commits and rollbacks to a lot of inserts in one script?
View Replies View RelatedI want to know,
. Operation Behind the Online Money Transaction.
. If Once The client paid the money,
. How is it validated..( Credit Card)
. Also how Can the Admin of the Site will get the Money from the User.
I have a page that uploads an xml file and reads it into a SQL database. The
page is transactional and aborts if there are any anomalies in the xml.
My problem is that the if I repeat an identical import the transaction
succeeds the first time and then fails the next time. This pattern continues
with subsequent repeats. I have removed all of the ObjectContext.setAbort()
calls but still the onTransactionAbort() sub is called.
I am wondering if it is possible to get more information on files then just
name, date, size etc..
Specific, I want to know what dimension (x and y pixels) an images has.
Can this be done by ASP. Do I need a component? Are there free components
out there?
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig
is there anyway of retrieving the word craig so to use it in the page
This is because i could have other addresses that are for example
http://localhost/site/Jon
where i need to retrieve the word jon
How to retrieve "Last modified" & "FileName" from all files in a specific folder (called MyDocs) and display on the ASP page?
eg. (in MyDocs folder)
- MikesWork.doc
- MyResume.xls
- HouseExpenses.xls
Situation
Let's assume that i just modified MyResume.xls file and save it today(10/30/2003) on my computer, then i upload it into the internet. On my asp page, i want to show all files Filename (Last Modified) in MyDocs folder.
eg.
Your Documents
1. MikesWork.doc (last modified 10/24/2003)
2. MyResume.xls (last modified 10/30/2003)
3. HouseExpenses.xls (last modified 9/15/2003)
I know it has to do with fso or something close to it... but totally have no idea (zero) of its logic or how it works. Please help me by giving me with full example.
Can anyone help with the following:
I wrote an ASP script with allows me to select an MS Access database
from a folder, and it shows the tables in this database. If I click a
table, the fields are displayed. And then I have a button to create a
HTML form to suit this table.
My problem is, fields that are essential.I would like to mark
appropriate form fields as 'essential' . Is there any way I can get the
attributes of a field, so I know if it will accept null values?
Is there any way to list all the properties that an object has? For example if I do a CDO.Message object and call it NewMail. Is there anyway I can find the properties of that the object supports. IE NewMail.From, NewMail.To etc
View Replies View RelatedI want to ask are there any other ways to get the file properties such as file name, path, date created... other than using 1. FileSystemObject or 2. file upload with encType="multipart/form-data".
For FileSystemObject, I can get it work in my local computer but not on the server(coz the server are not mapped to the network drive).
And for case 2, although I can use HTTP_CONTENT_TYPE to retrieve form values but I think I cannot use request.form("aa").count or request.form("aa").item(i) to get select option values.
I ve probably a very simple question but i really can't find an answer. I d like to know in an ASP page what is the URL of the page, the full URL invoked by the client to get the page. I looked in the server object but i did not find.
View Replies View RelatedI am in need of knowledge about how to control the properties. By properties, I mean font, hyperlink, and color information. I'd like the spreadsheet to have the same data as the HTML page it's getting the data from, but in a different format.
I have been searching in several places, including the Excel Help files, but cannot find any info on how to do this. I'm not asking anyone to tell me how to do this; just looking for where to find out how to do this.
i am getting this error message when i validate my page and it is
Error: formobj has no properties
Source File: /sellgiftnum.asp?
Line: 55
and line 55 is this one
var obj = formobj.elements[fieldRequired[i]];
Can someone tell me whats wrong with it .....
I've uploaded an image to the server and was wondering if there is any possible way to get the dimensions of the image through ASP.
dim iWidth, iHeight, iType
sub ImgDimension(img)
dim myImg, fs
Set fs= CreateObject("Scripting.FileSystemObject")
if not fs.fileExists(img) then exit sub
set myImg = loadpicture(img)
iWidth = round(myImg.width / 26.4583)
iHeight = round(myImg.height / 26.4583)
but I keep getting problems with the loadpicture.
Is it possible to grab the title of the page and echo it somewhere in your asp document? Does ASP have a premade variable to grab this?
View Replies View RelatedHow can I retrieve the default value and allowzerolength property of all the fields in my table? I'm using ADO.
View Replies View RelatedIs it possible to set a cell property in Excel from an ASP page. We have numerical data that is taken from a database and then displayed in Excel. I would like ideally all the data to be set at 2 decimal places, is there anyway of setting this from the ASP page?
View Replies View RelatedDoes anyone know of a way to access the document properties of an office
document using ASP? I need to be able to read things like the Title,
Author, and Comments fields and pull that information into a web page.
Before there was XML my world was in order, I would once a year write some small ASP script, it would perhaps take me all weekend, but it was doable, now the devil has entered my life, in form of an XML file ... Code:
View Replies View RelatedI want to set the asp session id path property. How can I do that?
I mean, asp session id is stored in a cookie and like any other cookie it should have properties (or attributes), how can I control it?
I want to dislay a query from a database in asp, with the crystal reports viewer.
i can see the report in the CR viewer, but the headings are overlapping each other.
what kind of properties do you have for the report header? Or does somebody know the
sollution? Code:
I am taking my first crack at writing some ASP and have no clue as to what this error is pertaining to. I will be in your perverbial debt for ever!
----------------------------------------------------------------------------
The error I am getting is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/agentlookup.asp, line 8
-----------------------------------------------------------------------------
And here is the code it is referencing: Code:
is there a way, using asp, to find out the width and height of an image file?
View Replies View Related