Thanks Jeff. Even though the field is varchar you may have helped me figure out the problem. I was gathering metadata from the database through ColdFusion to see if I could isolate the issue. It appears that even though MSSQL has the fields set as varchar--CF is seeing it as char. After I saw this, I researched the history of the dev server and it looks like it is using a "non-standard" JDBC driver that was installed for some other application that was being developed on the box at one time. Tomorrow, I'll replace this driver and see if that is what is causing the problem. If it is, I apologize to everyone in advance for bringing the issue up on the Reactor list. Thanks again, Brad
________________________________ From: [EMAIL PROTECTED] on behalf of Jeff Lester Sent: Thu 5/11/2006 11:40 PM To: [email protected] Subject: Re: [Reactor For CF] Extra space being output 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/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
<<winmail.dat>>
