Does anyone have a suggestion how I could debug this
problem:
1. Data is collected from database and displayed in a form.
2. User updates data and submits it.
3. Submitted data is compared with old data.
4. SQL is generated for changes and put into an array.
5. SQL in the array is executed line by line.
I've copied the code which does the update from a working
page that does something similar. And tested it with a
basic update to be sure. But for some reason when I
submit this sql:
update table set currency = 'USD' where currency = 'GBP'
and company = 'LQ' and supplier_id = 'BCX0926' and
invoice_no = '654664432'
IIS hangs and the browser displays a blank white page. At
this point the whole site becomes unusable until I restart
the IIS Admin service.
I've pasted the sql into Toad and tested it there and it
works fine. Could anyone suggest what the problem is, or
how I could go about debugging it. Normally when I get
errors thet are written to the screen. But in this case,
I dont get anything back at all.
I've even tried creating a bare bones page just to submit
that sql (see below), but even this crashes the server.
TIA,
Colin
<%Option Explicit%>
<!-- #INCLUDE FILE="functions .asp" -->
<!-- #INCLUDE FILE="formattin g.asp" -->
<%
beginPage 'Prints out the basic HTML for start of page
Dim cn
Set cn = Server.CreateOb ject("ADODB.Con nection")
cn.open Session("PROVID ER")
cn.BeginTrans
cn.execute "update table set currency = 'USD' where
currency = 'GBP' and company = 'LQ' and supplier_id
= 'BCX0926' and invoice_no = '654664432'"
If err.number + cn.Errors.Count = 0 Then
response.write "GOOD UPDATE"
Else
response.write "GOOD UPDATE"
End If
finishPage 'Prints out end of page HTML
%>
4  1810 
Have you considered using a stored procedure instead of an ad hoc query?
-- http://www.aspfaq.com/
(Reverse address to reply.)
"Colin Steadman" <an*******@disc ussions.microso ft.com> wrote in message
news:2a******** *************** ******@phx.gbl. .. Does anyone have a suggestion how I could debug this
problem:
1. Data is collected from database and displayed in a form.
2. User updates data and submits it.
3. Submitted data is compared with old data.
4. SQL is generated for changes and put into an array.
5. SQL in the array is executed line by line.
I've copied the code which does the update from a working
page that does something similar. And tested it with a
basic update to be sure. But for some reason when I
submit this sql:
update table set currency = 'USD' where currency = 'GBP'
and company = 'LQ' and supplier_id = 'BCX0926' and
invoice_no = '654664432'
IIS hangs and the browser displays a blank white page. At
this point the whole site becomes unusable until I restart
the IIS Admin service.
I've pasted the sql into Toad and tested it there and it
works fine. Could anyone suggest what the problem is, or
how I could go about debugging it. Normally when I get
errors thet are written to the screen. But in this case,
I dont get anything back at all.
I've even tried creating a bare bones page just to submit
that sql (see below), but even this crashes the server.
TIA,
Colin
<%Option Explicit%>
<!-- #INCLUDE FILE="functions .asp" -->
<!-- #INCLUDE FILE="formattin g.asp" -->
<%
beginPage 'Prints out the basic HTML for start of page
Dim cn
Set cn = Server.CreateOb ject("ADODB.Con nection")
cn.open Session("PROVID ER")
cn.BeginTrans
cn.execute "update table set currency = 'USD' where
currency = 'GBP' and company = 'LQ' and supplier_id
= 'BCX0926' and invoice_no = '654664432'"
If err.number + cn.Errors.Count = 0 Then
response.write "GOOD UPDATE"
Else
response.write "GOOD UPDATE"
End If
finishPage 'Prints out end of page HTML
%>
Try losing the begin trans and the error check and see what happens.
Set cn = Server.CreateOb ject("ADODB.Con nection")
cn.open Session("PROVID ER")
cn.execute "update table set currency = 'USD' where currency = 'GBP'
and company = 'LQ' and supplier_id = 'BCX0926' and invoice_no =
'654664432'"
cn.close
--
Mark Schupp
Head of Development
Integrity eLearning www.ielearning.com
"Colin Steadman" <an*******@disc ussions.microso ft.com> wrote in message
news:2a******** *************** ******@phx.gbl. .. Does anyone have a suggestion how I could debug this
problem:
1. Data is collected from database and displayed in a form.
2. User updates data and submits it.
3. Submitted data is compared with old data.
4. SQL is generated for changes and put into an array.
5. SQL in the array is executed line by line.
I've copied the code which does the update from a working
page that does something similar. And tested it with a
basic update to be sure. But for some reason when I
submit this sql:
update table set currency = 'USD' where currency = 'GBP'
and company = 'LQ' and supplier_id = 'BCX0926' and
invoice_no = '654664432'
IIS hangs and the browser displays a blank white page. At
this point the whole site becomes unusable until I restart
the IIS Admin service.
I've pasted the sql into Toad and tested it there and it
works fine. Could anyone suggest what the problem is, or
how I could go about debugging it. Normally when I get
errors thet are written to the screen. But in this case,
I dont get anything back at all.
I've even tried creating a bare bones page just to submit
that sql (see below), but even this crashes the server.
TIA,
Colin
<%Option Explicit%>
<!-- #INCLUDE FILE="functions .asp" -->
<!-- #INCLUDE FILE="formattin g.asp" -->
<%
beginPage 'Prints out the basic HTML for start of page
Dim cn
Set cn = Server.CreateOb ject("ADODB.Con nection")
cn.open Session("PROVID ER")
cn.BeginTrans
cn.execute "update table set currency = 'USD' where
currency = 'GBP' and company = 'LQ' and supplier_id
= 'BCX0926' and invoice_no = '654664432'"
If err.number + cn.Errors.Count = 0 Then
response.write "GOOD UPDATE"
Else
response.write "GOOD UPDATE"
End If
finishPage 'Prints out end of page HTML
%>
"Aaron [SQL Server MVP]" <te*****@dnartr eb.noraa> wrote in message news:<u2******* *******@TK2MSFT NGP09.phx.gbl>. .. Have you considered using a stored procedure instead of an ad hoc query?
No I hadn't. But after reading some of the material on your ASPFAQ
site I'm going to try and find some time to look at this for the
benefits in performance, and to take out some of the complexity in my
pages.
In the meantime, the problem I had so much trouble with on
Thursday/Friday last week appears to have resolved itself. I went in
to demonstrate the problem to a collegue yesterday and found that it
was working!
The person who looks after IIS says he's not changed anything, and
neither has the DBA so I have no idea what changed... I dont know if
I should be relieved or even more concened, but fingers crossed it
will stay fixed.
Colin
"Colin Steadman" <an*******@disc ussions.microso ft.com> wrote in message news:<2a******* *************** *******@phx.gbl >... Does anyone have a suggestion how I could debug this
problem:
1. Data is collected from database and displayed in a form.
2. User updates data and submits it.
3. Submitted data is compared with old data.
4. SQL is generated for changes and put into an array.
5. SQL in the array is executed line by line.
I've copied the code which does the update from a working
page that does something similar. And tested it with a
basic update to be sure. But for some reason when I
submit this sql:
update table set currency = 'USD' where currency = 'GBP'
and company = 'LQ' and supplier_id = 'BCX0926' and
invoice_no = '654664432'
IIS hangs and the browser displays a blank white page. At
this point the whole site becomes unusable until I restart
the IIS Admin service.
I've pasted the sql into Toad and tested it there and it
works fine. Could anyone suggest what the problem is, or
how I could go about debugging it. Normally when I get
errors thet are written to the screen. But in this case,
I dont get anything back at all.
I've even tried creating a bare bones page just to submit
that sql (see below), but even this crashes the server.
TIA,
Colin
<%Option Explicit%>
<!-- #INCLUDE FILE="functions .asp" -->
<!-- #INCLUDE FILE="formattin g.asp" -->
<%
beginPage 'Prints out the basic HTML for start of page
Dim cn
Set cn = Server.CreateOb ject("ADODB.Con nection")
cn.open Session("PROVID ER")
cn.BeginTrans
cn.execute "update table set currency = 'USD' where
currency = 'GBP' and company = 'LQ' and supplier_id
= 'BCX0926' and invoice_no = '654664432'"
If err.number + cn.Errors.Count = 0 Then
response.write "GOOD UPDATE"
Else
response.write "GOOD UPDATE"
End If
finishPage 'Prints out end of page HTML
%>
If anyone is interested this problem appears to occur when Toad from
Quest Software has the I'm updating open. Ie when running this
command:
desc table_name
Closing Toad allows the page to run normally. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jonathan |
last post by:
Hi I'm doing a project for school and wrote an applet that makes a socket
connection to a server (smae host as webserver) that was setup for this
project. In the applet there are 3 buttons and by pressing one of them it
triggers a specific query, like getting the server uptime, date or who (is
online). The problem is that when I press one of the buttons it send the
query to the server, reads from the BufferedReader. This goes all well but...
|
by: Don Miller |
last post by:
I have an ASP script that is called from a PDF form to process form data. On
the last line of the script I have a Response.Redirect "webpage.asp" that
leads to another target page with actual HTML. However when I start this
process (by submitting form data) even when I comment out the processing
code, the address bar shows the desired page, but the page never appears and
the flag keeps spinning indefinitely (and doesn't stop even after 15...
|
by: LarryR |
last post by:
The following XSLT works fine using MSXML 4.0 (e.g I receive a result in
about 20 seconds), but effectively hangs in both .NET 1.0 sp2 with the XML
hot fix and NET 1.1. My source XML file is large at over 46,000
<atl_client> nodes
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<!-- lookup port...
|
by: persillade |
last post by:
I have an ASP.NET website in which if a certain button is clicked, it
will enumerate the scheduled tasks on a certain server. I use psexec to
call "schtasks /query /fo list" on a remote server and this runs fine.
However, when I tack on a /v switch to the end of that, the site hangs
up completely, we start getting HTTP 403.9 errors (with only 1
connection to the site), and I eventually have to do an IISRESET to get
everything going again....
|
by: guoqi zheng |
last post by:
In a regular html form, when user press "enter" key, the form will be
submitted.
However, in ASP.NET web form, a form will only be submitted (post back) when
a special button is clicked. Many user get used to click "enter" key to
submit a form. How can I use "enter" key to submit/postback in ASP.NET.
Thank,
Guoqi Zheng
| | |
by: Bernard Lebel |
last post by:
Hello,
I'm stumbled at a serious problem, and quite frankly getting
desparate. This is a rather long-winded one so I'll try to get
straight to the point.
I have this Python program, that performs MySQL queries to a database.
These queries are performed at regular intervals. Basically it is
looking for fields that match certain criterias. Such fields are not
present at all time. When the program finds such field, it then takes
|
by: grpprod |
last post by:
Hi all,
I am trying to deploy the latest PHP,MySQL and Apache for a new webmail
server (My old IMP 3.1 works fine with PHP 4.2.2). Now I have a serious
problem which seems unsolved so far. Here are the versions:
CentOS 4.4
PHP 5.1.6
Apache 2.2.3
MySQL 5.0.24a
UW-IMAP 2004g
|
by: nonstopkaran |
last post by:
hey i am handling a small application,
it is running well. but very rarely it hangs... (i.e) loggin page itself will take more than 10m and the response will be very very slow.
config:
tomcat 4.1 (10g oracle jar)
oracle 9i
apache 2.0.46
|
by: somacore |
last post by:
I have a winform with a combobox. This combobox's text is set to a value from the database (in this case, a number). In my code I take the number and convert it to the proper text, returning the value as the selecteditem for the combobox. This part works.
However, if I try to UPDATE the value in the combobox at runtime, I am able to select the new value, but after that I cannot do anything. I am unable to select any other element on my form...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
