Type: Posts; User: sbhmf
Search took 0.05 seconds.
I felt uneasy posting a query that doesn't actually work, so here's an optional query that does work (not the full query, just the method extracting the IDs from the string, the loop that I mentioned...
Yes, I know that this has been discussed already on many boards, but nowhere have I seen anyone post a 'best practice' for it.
SQL Server v. 2012
Here's what I've got for a system that deletes...
Please delete this thread, its premise was incorrect. ty
I like your innovative approach.
Must I? You cannot ensure data integrity any better than by simply not messing with it, so why mess with it? Also, why spend processing power converting a file to send it, especially when the...
In .net 2.0 I have SOAP Web Services communicating across servers, and want to send binary files programmatically as well, yet SOAP is limited to text.
How would I best achieve this?
I've checked it (the grins, above) before posting this thread, and the value is the same. Both file paths are correct.
Initially I thought it was an NTFS permissions issue, until the revised...
Where FileName and FileContent are passed in as parameters...
string FilePath = Server.MapPath("~/Files/");
FileStream fs = new FileStream((FilePath + FileName), FileMode.Create,...
Server response to AJAX call: "location.href = 'Default.aspx?PID=" + tokens + "&SID=" + tokens + "';";
The client processes the response in an eval call, and consequently requests the new...
Resolved. Removed because it did not describe the issue adequately, and noone responded.
The issue: SELECT statement was referencing variables instead of the columns. Extra eyes found it. Mod may...
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
DECLARE @Table table ( id binary (20) )
DECLARE @Id binary(20)
DECLARE @Result bit
SET @Result = 0
IF (SELECT restId FROM tblRest WHERE...
... ==>> 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...
Fyi, in my case I'm assembling an XML fragment with multiple item tags:
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...
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>
...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...