Not varchar. But char will be exactly how many characters you specify as a maximum. It fills any unfilled space with spaces. Varchar does not, but Char does. So I don't think that would be your problem. I just mentioned it because I had that problem also at one point and that was my solution. ;)

On 5/12/06, Brad Haas <[EMAIL PROTECTED]> wrote:
I'm using MSSQL and it is a varchar field.  Any reason why this might be a problem?

Thanks,
Brad

________________________________

From: [EMAIL PROTECTED] on behalf of Jeff Lester
Sent: Thu 5/11/2006 9:57 PM
To: [email protected]
Subject: Re: [Reactor For CF] Extra space being output


Are you by chance using a char field in MSSQL?


On 5/12/06, Brad Haas <[EMAIL PROTECTED] > wrote:

        I'm having trouble with extra space being output.  For example, if I
        load up a reactor object and then do a simple output like:

        <cfoutput>
        #User.getPassword()#
        </cfoutput>

        The output will have extra spaces after the password is displayed.  I
        most commonly see this when I forget to set output="false" in a
        cffunction.  I wouldn't think this would be the case with Reactor.
        This even happens if I trim the data before calling save().

        When I view the source in the browser I see this:

        <input type="password" name="Password"
        value="thepassword                                     ">

        I see this in all the input fields on my forms.

        Does anyone know why this is happening?  I searched the mail
        archives, but I haven't noticed anyone mentioning this issue.  I
        wouldn't have noticed it myself, except that I had a password field
        that kept showing asterisks filling the entire field for a password
        that is 6 characters long.

        Thanks,
        Brad








        -- Reactor for ColdFusion Mailing List -- [email protected]
        -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/





-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/




-- Reactor for ColdFusion Mailing List -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/


-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/

Reply via email to