Search:

Thank you.

I'm pushing out a system under tight deadlines whose requirements need to be met without exception. It will eventually go to a DBA for review and performance enhancements, and I cannot...

CREATE PROCEDURE D_Tigers
@RestId binary(20)
AS
DECLARE @Table table ( id binary (20) )
DECLARE @Id binary(20)
DECLARE @Result bit
SET @Result = 0

IF (SELECT restId FROM tblRest WHERE...

Thanks, Bill.

... ==>> http://www.codingforums.com/showthread.php?t=285499

SEEKING: comments from anyone with something valuable to contribute.

ISSUE: escape() and unescape() are deprecated, HTMLEncode() is strictly a server-side implementation, and I am considering...

You are correct in assuming that the tags are included.

Btw, your recommendation that I employ a cursor is brilliant... I never even saw that one coming! As a rule I avoid even thinking about...

Thx again.

Cool. Thanks!

Fyi, in my case I'm assembling an XML fragment with multiple item tags:
<block>
<item>varchar(7000)</item>
<item...
</block>

Maximizing system performance, I generally prefer to employ all possible processing on db instead of web server.

The C# code employs a 10-case switch to discern which sproc to call, and am...

Thanks Bill.

While on the subject, I am informed by a former Microsoft employee who worked on SQL Server's XML DML that it does not perform as efficiently as regular DML. Therefore I've decided to...

Msg 156, Level 15, State 1, Procedure R_Block, Line 7
Incorrect syntax near the keyword 'EXEC'.

The sproc assembles an XML ['<block prop1="" prop2="" propN="">'] tag (stored in first normal-form)...

I was hoping that someone may have already dealt with a similar issue.

The exception is baffling:
1. The page compiles, evidence that the ASPEmail libraries are included in the newly-compiled...

Many notes exist online about this issue, yet I have not seen any that speak to my problem.

My dev system has multiple websites, and all of them integrate aspemail and work flawlessly, except for...

So here's the skinny:

When passing the link's href value as a relative path, the browser modifies it to the full path in memory, as is evident from IE's updated page source in F12.

When I load...

The 'div' wherein the file will be rendered:
<div id="selectTemplate_template" class="selectTemplate_contentSection"> </div>

JavaScript code that places the file content into the div:

note:...

...yet works on Chrome, FF, Opera and Safari.

In a div on my page I load an HTML file from the local domain via AJAX. The file has its own DTD, html root node, body, etc, as well as its own link...

Thank you for responding, Bill.

Actually, your response describes almost precisely that which the system currently does. Following each request authentication, the Web Services Master Class...

Hi all,

I'm working on an AJAX app that will be accessed exclusively over secure http, and am informed that I should integrate non-linear nonces for additional security.

I have found little...

Kept trying and for some reason it seems to finally be working. I have no idea why it wasn't working earlier, but it's all good now...

Hi all,

My data ( Name, Email...) are stored as varchar types. When I access them from the table each datum maintains its own length. However, I later move the data to a second table via sproc,...

Merry Xmas

I created independent projects for data access and exception handling, and placed their dlls in the bin folder.They work well on the dev box but not on the staging box.

How might I...

I've searched for an article that will walk me through it, and could not find an adequate one to walk me through the entire process.

I've downloaded and installed the ODBC driver from MySql.com...

Code creates a hash value: Convert.FromBase64String(DateTime.Now.ToString());

Later, the system creates a Base64 string from the hash: Convert.ToBase64String(hashValue), and sends it to a client...

Wow, what was I thinking!?! Thank you so very much.

Unknown returned object may support Dispose(), and exception suggests that the object must be cast into its type before Dispose() can be called.

The object's wrapper has a field that contains the...

even after reading these posts - nad many more - i'm not confident that this can be easily done. Most of my web research suggests that it cannot be done, so I might have better luck trying to find a...