Ask a Question related to Coldfusion Database Access, Design and Development.
-
blorg #1
Does MX7 strip SQL comments?
We had a single CF MX 6 server, and recently commissioned a second CF MX 7
server. Both of these query the same SQL Server 2000 database. We are using the
Microsoft SQL Server driver in both cases. What I have noticed is that SQL
comments (-- comment) appear to be stripped from the SQL statements being sent
from the new (MX7) server. Has anyone else noticed this as an issue, and is
there any way to stop it? We use the comments to identify statements in traces
for statistical performance analysis.
blorg Guest
-
Disable Options>Import Comments in Comments Pane
A customer asked me to replace the logic of the Comments>Import Comments menu item. I can easily find and replace this menu item with the name... -
strip out html
is there a function in asp to strip out html characters ? adam -
HELP strip slashes ???
Everyone, I am doing an admin site for a person and their small site. I need to allow them to put in paragraphs of information. I am allowing... -
[PHP] Strip Numbers
You could use two substr()s or an ereg_replace() $result = substr($str, 0, 2) . substr($str, 5); or $result = ereg_replace("()990()", "\\1\\2",... -
Strip Numbers
Hey could someone help me out here.... I need to strip numbers from a passed variable ex. 3899007 all the numbers will have 990 (so that is... -
MikerRoo #2 Re: Does MX7 strip SQL comments?
Why not create an extra SP variable for this purpose instead of comments?
The variable would just be varchar or text containing the relevant note.
That would seem to be a more universal and maintainable approach than using
comments for trace purposes.
(As you have seen, even if it works now, the comment approach could be broken
by the next improvement to CF or even your RDBMS.)
MikerRoo Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
