in ado we have 4 locks
adlockreadonly
adlockpessimistic
adlockoptimistic
adlockbatchoptimistic
how can we check this locks work ...means suppose i used adlockpessimistic ..this lock does not allow other user to alter data ...i wanted to check it live.
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...????
I have a very simple database call running on a W2K3 server. I moved it over from a W2K box. However, when it is run on the 2K3 server, it leaves a lock on. It is an ASP page and not and ASPX page. It works perfect on the W2K box.
Anyone else have this probelm or better yet a cure for this problem? I do not have the time to convert it to ASP.NET yet. The ODBC driver is a bit different. One is V 4.00.6205 dated 3/2003 the one on the W2K box is version 4.00.6200 dated 6/2003.
I have an ASP page which uses QueryString data to determine what the user is wanting to do. It has Upload (which provides a form to enter a category, title, overview, and file), Edit (which gives user a form with the before mentioned sections, minus the file, to change the overview, title, or category), Update (which processes the Edit form), and Delete, which allows the user to delete a file.
A user can upload a file just fine, and a file can be deleted just fine. The problem is with Edit/Update. The Edit form loads fine, with all the correct information in the input boxes, and a hidden field storing the "ID" for the record. This form submits to .asp?Action=Update, where the Select statement is based on the hidden ID. When the user clicks the update button on the Edit page, the next page never loads, the confirmation never comes up.
On our Production (Live) server this caused ALL of our sites to go down, we had to restart the server to bring them back up. Now I've been testing in our Development server trying to solve, it causes this site to go down, but all other sites on the development server continue to function (so we have a different result on this server, but still the problem). Reboot is not required here though, if I wait a few minutes, I can access the page again (maybe a timeout is happening here that isnt on the other server?) Code:
I'm using application variables for a web based sales tracking application. I use the variables for stuff like connection string, database name, etc. I store the values in a asp file that is included in a login page. The assignments are in a procedure that I then call on the login page. This is done everytime a user connects to
the login page.
what's happening to the variables? Are they being overwritten everytime a user accesses the page? I'm not checking for the existence of the variables. I just call the routine everytime the page is accessed. I know the values are shared for all users but, I was wondering if I should check for the existence of variables? Will it free up resources? Should I be using locks?
I have got a small problem as follows, i am trying to test my web page on the live site of which it doesn't load to the database. hence it loads on the production server.
View Replies View RelatedCan anyone point me in the right direction for a script that allows user to chat on the web in ASP. However I need a one to one chat room.
I came accross this site and source code ...
I am having trouble with an ASP login that uses sessions to control access
to certain pages. However the sessions are not being carried accross upon
using response.redirect.
I realise that this is the case that DNS names and IP addresses vary upon
whether it works or not, however how can i get around using sessions live on
the internet? and make them work>?
IT also has almost all of the features I want. It uses a microsoft access 2000 database (I use the following code to connect to the database:
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("SOMEPLACE")
sqlstmt = "Select * From TABLENAME"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sqlstmt, DSNtemp, 3, 3
Do until rs.EOF or rs.EOF)
The code works fine, I would just like to add a thing and it would tell what page the user(s) are/is at and then I can request a chat with them and a box would pop up asking them if they would like to chat. My oly problem is how would I keep track of the visitors on my site, and how would I know when they left the site?
I am looking for free live chat support system in asp for download not for rent. Do you know any available on the internet ?
View Replies View Relatedi'm looking and have been for quite a while now for a good live support script for sales consultants to web surfers.
all i need from the script is the content thats being writen by both parties to show in a log window above and a text field below to enter the text and next to it a .jpeg of the sales consultant there talking too, all with a speedy refresh rate and either automatic notification to the consultant via sound or alert of the surfer browsing the site, or an icon for the user to select for live support.
all needs to be in a pop up box on my site not a seperate chat page or forum. i've seen it on many hosting sites but cant seem to find a cheap or free script to use or alter for myself, any sugestions or scripts would be very much appreciated, and if i can be of any assistance to you i would be glad to assist.
I would like know the active (live) users who have logged in to my site. I should have a live connection with each client so as to enable us to send any messages which should pop up in their system.
View Replies View RelatedI was just wondering: is it possible to put something in ASP code that would be able to tell the difference when my site gets visited by a live user or a bot?
My website is setup to email me every time there's a visit, but it notifies me when it is visited by web crawlers as well, which I don't care about, I only want to know about real people. How do I teach my script to tell the difference? Any suggestions?
I have a couple of static HTML pages live, as a sort of family blog. Now I just found out how ASP could work, experimenting with WikiAsp.
What I would like to know is whether it is possible to include some DHTML in my static pages for gathering comments on blog entries, which are saved to a database for example on 1asphost.
Of course it would also be nice to read out the database again to see the comments to each blog entry in the static pages. Can this all be done using ASP?
Someone generates an RTF document, which is stored on the server side. Next
he must be able to edit the document in a WYSIWYG way, and save right back
to the server (without downloading to the user first and uploading again)
What would be the best way to implement this ? Anything goes. ActiveX,
Richtextbox ways, etc...
I am facing a problem that i am unable to connect to Live Communication Server using my own UI. Actually i want to access the API's in LCS through my own UI(which is a messenger UI),which i am using to implement chatting messenger in my project.
The main reson is that i dont know the code to connect to this LCS and what namespace shld i use so that i can access all the functionality of my LCS 2005.
The coding is to be done in c#. I could have used the MS OFFICE Communicator direcltly but i have to use my oen UI and thus i need to connect to this LCS...
I am looking for live streaming audio/video technology to integrate in my ASP .NET web application. My searches led to a couple of open source products but most of them were old or came under the form of a full blown web application - not an SDK.
The project is academic and is ample therefore building my own is not feasible at this time. The end product will have to provide the functionality of a commercial product but will only be used as a proof of concept so no commercial use is intended.
Ideally all I am looking for is a library that can establish live-audio video connection between two computers over the internet and allows the video be embedded within a web page (with no or a minimum set of other controls). Also there has to be possible to transmit high quality video.
I'm working on a "hybrid" application some classic ASP, and some
asp.net. I'm trying to develop a support type page that checks necessary
components, database connections etc.. last item is to check for the .NET
extensions. Is there a way to do that from a classic ASP page?
I am working on a website that requires a login before accessing an appointment book application written in ASP.Basically what I want to do is when the customer first clicks on "appointment_book" link, it takes them to the registration form. After they are registered, It will then redirect them to the actual application.
I also want the same thing to happen when a customer clicks on the login link. I want them to login, then get redirected to the appointment_book.
at the moment the customer click on the registratration link and it shows them the registration form, they are then automatically logged in after registration. However, when I click on the Appointment_book link again, it brings me back to registration form. How can I have the link always point to the appointment book after they are registered or logged in?
let say:
http://www.domain1.com/index.asp?url=http://www.xxx.com/file.asp
can i restrict that only domain1.com can access to http://www.xxx.com/file.asp page?
so when user suft http://www.xxx.com/file.asp, they unable to view the content.both domain is on diff IP.
I have a form with several check boxes.they are all set to default to "unchecked."The db also defaults to unchecked.But,as soon as we hit the "form1.recordset.addnew" all of the cb's change themselves to "checked."?
Does anyone know of any nice ready made asp scripts to check a website's visitors age? I mean the sort of thing you see where you have to choose your day, month and year of birth from drop down lists to comply with US laws Code:
View Replies View RelatedI'm trying to guard against SQL injection, but I have an ID number being embedded into a querystring for MSSQL table selection.
Is it good enough just to check if the querystring value is an int, if so could you quickly remind me how to check that. In PHP we use is_numeric or is_int.
I moved an ASP app to a new Win03 server. The sendmail function using CDO in all ASP appls suddenly stopped working. It worked fine on the previous server (also Win03/IIS6.0). Where should I go to check?
View Replies View RelatedI would like to check if a website is currently down, but don't know how to do this efficiently. I do not have access to the remote server. I have tried using XMLHTTP, and it worked, it just took a long time and I felt it wasn't effecient enough. Is there some other way to check if the website is up or not using ASP?
View Replies View Relatedhow to check any value in asp that it is null or not.
View Replies View RelatedI have a form that has simple vaidation but how do i check to make sure there is and email in the email section.
View Replies View RelatedHow can I check that entered value in a text box is numeric or not in next page?
View Replies View RelatedI have a form that a user submits their clan's website, and roster page.
What I want to do, is check to see if the field submitted contained
"http://" and if not, add it to the field submission.
I know i can make this easier, and put the http:// in the field as a default
value, but i want to know how to do this with a bit of form validation or
something.
I have a signup form.
I would like to be able to check for duplicate entries during the signup.
E.g. Check for duplicate
1. Usernames
2. Phone numbers
How could this be achieved ?
My code basically is two fold.
1. A recordset that checks
if not recordset.bof and not recordset.eof then
'do something. And redirect to say the value exists
end if
2. Run a SP to do an insert and authentication
I've got a page that displays product details. One of the fields in my products table is called Include and is set to Yes/No. I use this to distinguish when I want to add that particular record to a recordset and when I don't. For example, I may have 20 products with the name Ash in them and create a recordset which pulls in all Ash products. However, I only want to pull them in when Include is set to Yes (the others aren't ready yet.)
I'm using Dreamweaver and I've setup my product details page to include that Include field with a checkbox. It checks the box if the Include field is set to True. What I would like to do, though, is be able to then uncheck that box and have it update that field to False, or No. Right now, when I uncheck the box and submit the form I can go back in and it's still showing up in that recordset and the box is still checked when I go to the details page.
i know how to code it in javascript but failed to do it in asp. there are 12 digits of number. exmple like this 871205106599. i want to check every single digit when user clicks Submit button.
View Replies View Relatedwhen i set the checkScore1 to 100 or higher in the table field, the if else condition became FALSE? But it work for 70 to 99 ??
If checkMaxAttempt = "2" AND checkScore1 >= "70" Then
response.redirect "error.asp"
'last attempt check
ElseIf checkMaxAttempt <= "1" AND checkScore2 >= "70" Then
response.redirect "error.asp"
ElseIf checkMaxAttempt <= "0" Then
response.redirect "error.asp"
Else 'do nothing
End If