Forum Replies Created
Viewing 15 posts - 226 through 240 (of 251 total)
-
RE: Filling in a Form w/data from a XML file
OK, that's better.
Couple of questions:
1) Does the schema ("record" or "field" structure/names) change between calls, or is the schema constant and only the...
-
RE: Filling in a Form w/data from a XML file
Another thing could be happening, just something more to check. Make sure that your XML document is actually loading into the DOM. After execution of this line of code:
docLoaded =...
-
RE: Filling in a Form w/data from a XML file
I based my example on your sample XML, so it's probably not appropriate for the real XML that you're actually using. The problem is that this statement:
xmlDoc.selectSingleNode("//ADDRESS[text() = '1111111111']").text
is...
-
RE: Filling in a Form w/data from a XML file
OK, first off you've got one problem. Your XML is not well-formed. I'm guessing that it should be this:
<?xml version="1.0"?>
<RESULTS>
<NTFD>1111</NTFD>
<PRB>1111</PRB> <!-- this line was bad -->
<NAME>11111</NAME>
June 17, 2005 at 9:14 am
-
RE: .NET Programming
I've got a similar situation here, except that the database I have to hit on is not in compatibility mode, it *is* SQL Server 6.5. ODBC works OK against it...
-
RE: Debate - .Net Dev Vs. DBA Who will win?
Here's another example directly from on-line help, example code that populates a dataset from a data adapter:
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind")
Dim...
-
RE: Debate - .Net Dev Vs. DBA Who will win?
Also, FYI, why don't you run a trace on the server, if you can, to see how all those connections are behaving, while the app is in use? If they...
-
RE: Debate - .Net Dev Vs. DBA Who will win?
From on-line help:
"The Fill method implicitly opens the Connection that the DataAdapter is using if it finds that the connection is not already open. If Fill opened the connection, it...
-
RE: Debate - .Net Dev Vs. DBA Who will win?
I agree with this, it looks to me like the open connections are not being closed. ADO.NET does not automatically close connections, even when the connection goes out of scope....
-
RE: DTS troublshooting
Can you do a "disconnected edit" in your DTS package to determine which item is failing? Open the package in Enterprise Manager, right-click on a blank portion of the package...
-
RE: More efficient way
Since you're just getting the year, would the year() function perform any better? Probably a wash, but maybe worth trying in addition to other suggestions.
-
RE: How can I tell if an "image" data type column contains a value?
What query tool are you using? Query Analyzer shows NULL if there's no data. Can you use the datalength() function to determine if there is any data in the field?
Quick...
-
RE: How to detect slow or frozen dts packages?
We had a problem where a particular job (DTS package) had exactly this problem, where the job failed but SQL Server didn't actually fail the package, it would just keep...
-
RE: Stored Procedures Parameters
Don't know about previous versions, but stored procedures in SQL Server 2000 may have type of "text" or "ntext", which theoretically will let you pass in just about as much...
-
RE: Help on XML display...
OK, here's a "better" version that actually does something.
<html>
<head></head>
<body onload ="init()">
<xml id="xmlDoc">
<definitions>
<def>
<phrase>IANAL</phrase>
<definition>I am not a lawyer</definition>
</def>
<def>
<phrase>IIRC</phrase>
<definition>If I recall correctly</definition>
</def>
<def>
<phrase>IMOP</phrase>
<definition>In my opinion</definition>
</def>
</definitions>
</xml>
<label>Pick a phrase: </label>
<select...
Viewing 15 posts - 226 through 240 (of 251 total)