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 have an asp application that allows users to access certain documents based on their ID and security level. This works fine, but I want to be able to log access attempts so that any potential abuser can be given proper warnings, etc. Basically, if I'm Attorney A then I should be able to access info on Case X, but Attorney B should not be able to, and any of his attempts to access Case X should be logged somehow.
I found the following script online that should capture the IP address of the offending machine, but when I test it I only get errors: Code:
If the user had log in with correct user id but wrong password, i
would like to capture the time when the user fail to login for the 1st
time. Within 24 hours, if the user had tried to log in with same user
id but wrong password, the user will be locked, so that the user will
unable to access the system until he contact the administrator.
how do you do this. 2 tables. one called "Bookings" one called "Rooms"
what kinda query would i use to make it LIST the contents of the ROOM column in the BOOKINGS table, then get remove identical matches in the ROOM column in the ROOMS table?
If I have 30 of the same cmpycd in the column, it brings it all up. I think this is one of those IF/THEN things, but not sure how to impliment it in the code.
All I want to do is show one instance of each unique item that exists in the cmpycd column. If it exists 300 times, I just want to show it once. Then also show the compFN that is also in the same row.
I can make it count and show how many are of each, but I cannot seem to get it to display just one of each. Code:
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.
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.
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 RelatedI found one website say that it will auto alternate the position of advertisements for every 5 minute. My question is how can they do that.If we want to change database like this we have to use internet explorer to call asp script in client side.
Does the webmaster of this website always open that asp page and make it runs all the time?Or can we always 24 Hrs. run the asp script on the Server not Client?
Using HTTP_REFERER I cannot capture the URL when the link is made via a
button:
<input type="button" name="Continue" value="Continue Shopping"
onclick="ContinueShopping('http://mysite/supertest.asp');">
I do not control the script above, it is on an e-commerce site that is very
generic, meant for many users - and is generated by their server code. I
want to capture the URL and with an if/then redirect if the last place
visited was the checkout site.
I need an alternate method of URL capture, rather than HTTP_REFERER.
Attached is my code. Its working fine and produces great results but all the rows are in the same color background (unless mouse-overed).
What would be interesting to see if I can get alternative colors working here...
Can anyone dig in the code (maybe re-juggle) and help me with alternate row colors?
First Row to be #FFFFCC
Second Row to be #CCCC99 when not mouseovered
how can I apply transaction, commits and rollbacks to a lot of inserts in one script?
View Replies View RelatedMy code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am putting the results from a database in a table using ASP. How can I get alternate colors in each row. (i.e. first row white, second grey, third white, forth grey, etc.)
View Replies View RelatedI am in need of something like mod_rewrite or an alternate solution.
I have a client, who's website is all HTML files (200+ files) and was previously password protected by javascript only. Anyway, what I need to do is password protect the site using a better solution, which would be a server side scripting obviously.
I am familiar with apache's mod_rewrite and PHP, which would make this problem easy to solve by simply passing the HTML file to a php file, then after neccessary security checks, pass the requested html back to the browser..
The only problem is that its on an ASP server and I have no knowledge of ASP. I am not even 100% positive what kind of server it is, I just know that .asp files work in it and .php does not.
Anyone know of something like mod_rewrite for ASP or an alternate solution that would work in my situation?
In my application I need to read the lines from the text file. I use the following script to do that.It doesn't seem to work because of the Norton Anti virus script blocking. I cannot do anything to Norton so I want to find the alternative way to read the lines from the text file. Quote:
Dim objFSO, objTextFile
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFSO.OpenTextFile(Server.MapPath("ProgrammeDetails"),1,false)
Do While Not objTextFile.AtEndOfStream
Response.Write objTextFile.ReadLine & "<BR>" & vbCrLf
Loop
objTextFile.Close
Set objTextFile = Nothing
Set objFSO = Nothing
how to have table alternate color everytime im using for and next statement..? example:
Code:
<%
for a = 1 to 10
'write td here with alternate color..
next
%>
Example:
Table: FRUIT
column1:
apple
bananas
grapes
column2:
I like apples.
I like bananas.
I like grapes.
I'm trying to have it where the choices from column1 are provided on the form, and based on the what was chosen on the form the corresponding choices from column2 are display on the page.
I 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.
So I have a layer with a repeating table displaying the results of a recordset that are associated with the record being displayed behind the layer in a table. The problem is when there is no record to display it looks weird there. I'm trying to get it so that when that recordset is empty it puts an alternate text in that spot saying no records were found. I tried to get it done by throwing a layer on top of the existing layer whenever the recordset is null. The problem is the code I'm doing it with won't let me have quote marks, which are required for anything more complicated than basic text. Anyone have suggestions? Here is the code I'm using: ...
View Replies View RelatedI have a fullscreen page which needs to incorporate a forward, back, and close button. I have this working fine but after a review, people suggested that the foward and back buttons not be active if they do nothing.
In other words they want them to function exactly like a standard browser's forward and back button. When you open a page in a new window, the back button is grayed out until you move to another page. The forward button is grayed out until you move back a page.
Can this be done?I need to place a grayed out image if there is no back history or forward history. Otherwise, I need an active image with the back and foward action.
I am going to need to offer alternate index pages for each user that visits the site. So, I would have index1.asp and index2.asp. User 1 gets index1, user2 gets index2, user 3 gets index1, user 4 gets index2 and so on. how to do this?
View Replies View RelatedI have a set of web pages on an AD-authenticated web site that are
supposed to allow users to modify their own AD account attributes,
limited of course to things like their email address, URL, etc. I was
hoping to connect to LDAP using secure authentication as described on
a few tech web pages, and the connection works fine but when it's time
to commit the changes with .SetInfo, the script fails with: Code:
Does anyone know of any easy way to have shading on alternative rows in a table that loops through the rows in a recordset?
View Replies View RelatedI am creating a dynamic ASP VBScript page, which gets data from an Access database.
In the database, there is a field which holds a URL to an image. I can get the image to display fine, but where there is no file that matches the URL (i.e. a missing image) I want to display an alternative, default image (e.g. one that says "Awaiting Image"). The field is never blank, but the image file may not exist for all records in the database.
I think what I am trying to get to is the following:
If file exists (using URL from database to get location of image file) then
display image using the url from the database as the image source
else
display default image - hardcoded in program
endif
I have had a go and come up with the attached but I get an error with my if statement...