ajax – How to prevent Coldfusion adding decimals to digit-only varchars?

I\’m using Coldfusion8.

I\’m receiving an Ajax request with an item number (random 35 charchater string), which I need to write/retrieve to the database.

Problem is, when I\’m passing only digits like:

 23456

Coldfusion outputs receiving:

 23456.0

If the string contains any letters like A12345 it works correctly.

Some code (although this does not show what\’s not working:

Javascript:

var btn = $(this).find(\'input\'),
    putOnRack = btn.jqmData(\'index\'),
    form = \"\",
    service = \"../services/handler.cfc\",
    method = \"process\",
    returnformat = \"JSON\",
    targetUrl = \"\",
    formdata = \"form_submitted=store_selection&artikelnummer=\"+putOnRack+\"&method=\"+method+\"&returnformat=\"+returnformat;

    // pass to AJAX
    ajaxFormSubmit( form, service, formdata, targetUrl, successHandler, \"no\", \"\", returnformat, \"\" );

var ajaxFormSubmit = 
    function ( form, service, formdata, targetUrl, successHandler, dataHandler, errorHandler, returnformat, type ){
    $.ajax({
        async: false,
        type: type == \"\" ? \"get\" : type,
        url: service,
        data: formdata,    
        dataType: returnformat,
        success: function( objResponse ){}, 
        error: function (jqXHR, XMLHttpRequest, textStatus, errorThrown) {}

In Coldfusion I\’m passing this through process, which validates and builds the form server side, then I pass to my database handler which gets a

 `LOCAL.form` 

object containing all the passed info, so my item number will be in LOCAL.form.artikelnummer

If I output this:

 cfdump output=\"e:\\dump.txt\" label=\"catch\" var=\"#LOCAL.form.artikelnummer#\">

digit only strings are treated to .0

Question

How can I make sure I end up with varchar and not numbers, when passing a parameter via AJAX to Coldfusion?

Rating: 4 out of 5 based on 3 ratings

Posts Related to ajax - How to prevent Coldfusion adding decimals to digit-only varchars?

• Jul 25th, 2012 Javascript - Format number to always show the original decimal places Wednesday AM 10:25:58


• Jul 07th, 2012 algorithm - What is the fastest implementation of ColdFusion's listFindNoCase function in Javascript? Saturday PM 23:55:51


• Aug 05th, 2012 jquery - ajax call after x characters Sunday AM 10:59:19


• Nov 12th, 2012 How can I prevent a user from middle clicking a link with javascript or jquery Monday AM 11:29:03


• Jul 08th, 2012 javascript - Adding JQuery code to a Rails 3.2 app? Sunday PM 18:32:14


• Nov 12th, 2012 HTML Form Validation via Javascript Monday PM 17:18:36


• Aug 25th, 2012 jquery - simple javascript keystroke count Saturday AM 10:30:56


• Aug 02nd, 2012 javascript - Can I somehow prevent returns in my code from adding spacing between form elements? Thursday AM 02:54:26


• Jul 17th, 2012 How can you include Javascript and css files only in the case that they are not already included? Tuesday PM 13:30:16


• Nov 16th, 2012 How do I add dynamic javascript to the head tag from a string, not a file? Friday PM 19:36:52

The post ajax – How to prevent Coldfusion adding decimals to digit-only varchars? appeared first on Javascript ASK.

via Javascript ASK http://javascriptask.phpfogapp.com/ajax-how-to-prevent-coldfusion-adding-decimals-to-digit-only-varchars.html