If I understand your question right, simply don't use DollarFormat(). DollarFormat is a function that takes a raw integer or floating point value and puts in all the stuff you want to remove.
If I misinterprited your question you can use a regular expressing:
[PHP]<cfset strippedamt=RER eplace(amt,"[^0-9.\-]","","ALL") >[/PHP]...
Shift4SMS
Last Activity: Feb 20 '08, 07:42 PM
Joined: Feb 22 '07
Location: Las Vegas, NV - USA
-
This is off-topic but your example is a perfect demonstration on how to create a sql injection and a cross site scripting vulnerability.
To prevent sql injections you should always use the VAL of a numeric values and escape string values of all URL or FORM variables. If you are not familiar with sql injection, here is an example using your sample code:
templatename.cf m?op=del&sysID= 0%20or%201%3D1
which...Leave a comment:
-
Just in case you need an example of what acoder was saying:
[CODE=cfm]<cfset session.sv = "Id,Name,Addres s,Phone,City,Lo cation">
<cfquery name="qResults" datasource="#ds #" username="#un#" password="#pw#" >
select #session.sv# from details
</cfquery>
<cfoutput>
<table>
<tr>
<cfloop...Leave a comment:
-
For MSSQL YEAR(docdate) should work provided that docdate is a datetime or smalldatetime field:
If this does not help, you may want to repost your question in one of the sql platform forums as this is more a sql question than a coldfusion question.Code:select distinct year(docdate) from filecontent
Leave a comment:
-
There is nothing preventing a mixed code site. The biggest issue is in sharing session scope variables between the two because the the two environments store and track them differently. If you don't need to share information, then no big deal. If you need to share information you will need to pass the information via form fields or url paramters or store the information in a database that both environments have access to.
I don't know...Leave a comment:
-
It can be done but it would NOT be pretty....Leave a comment:
-
You may want to think more "long term." Mixing some ASP into a CF site may (or may not) be the quickest way to solve the current problem, long term this will most likely turn into a nightmare to maintain, code & test.
My suggestion would be to learn CF and make the mods in CF or rewrite the site in ASP and make the mods in ASP. Mixing the two would be like putting Ferrari doors on a VW or visa-versa - it can be done but...Leave a comment:
-
If an item gets added to Mary's legendary list, it would be nice to also have a date filter - 3 days, 7 days, 30, 60, 90, etc... ;-)...Leave a comment:
-
You'll want to check the version of the JDBC that you are using and how it was implimented.
My first experience with JDBC (several years ago) left much to be desired. It was simply a Java layer on top of ODBC and was God Awful slow and many ODBC features were not implimented or had some sort of custom implimentation. Simple things like execute calls could not be done in a standard query statement, they had to use a separate exec entry...Leave a comment:
-
That sounds about right. I do remember some reference to "newsgroup" something-a-rather.
Is there anyway to filter these out?...Leave a comment:
-
Search???
I'm new here and I'm probably just doing something wrong - anyway...
If I go through the "Discussion s" tab and drill down and view a thread, I have a Post Reply option. If I instead use the "Search" feature to find and view a thread, I do not have a Post Reply option. What am I doing wrong? -
After posting my question, I finally crafted the Google phrase that found my answer: db_name()
It was probably included in my original search results but when your search returns back 50,000+ results, it's a little hard to sift through the non-related results.
if db_name() != N'Northwind' begin
RAISERROR 20000 'Database context is incorrect - currently ' + db_name() + ', expecting Northwind'
RETURN(1)...Leave a comment:
-
Current Database Context?
This is probably an easy one but I'm banging my head against the wall trying to sculpture the perfect Google search. Anyway...
Is there a way to determine the current connection's database context? By database context, I mean the current database selected by the last USE or the default database for the user.
This may sound dumb (heck, don't you know the last USE statement you issued?) but I'm trying to debug a multi-threaded...
No activity results to display
Leave a comment: