Re: [OT] Re: VTML Builder

2002-03-07 Thread freddy
I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing, or deleting emails. Besides it seems I get so many more responses to any criticism I make on this list than I do to any of the questions I have needed answered so I thought I'd do

Re: [OT] Re: VTML Builder

2002-03-07 Thread Jerry Johnson
Are they padded to 255 all the time, or does that char field have a length or 255? My understanding is that the char would return a string with the entire length of the field. That is the main difference between a char and a varchar (which would return a string only as long as the data put

Re: [OT] Re: VTML Builder

2002-03-07 Thread Paul Giesenhagen
Take your little disagreement offline. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: freddy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 2:24 PM Subject: Re: [OT] Re: VTML Builder I

RE: [OT] Re: VTML Builder

2002-03-07 Thread Shawn Grover
: Re: [OT] Re: VTML Builder I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing, or deleting emails. Besides it seems I get so many more responses to any criticism I make on this list than I do to any of the questions I have needed answered

Re: [OT] Re: VTML Builder

2002-03-07 Thread freddy
They are padded all the time the char fields in question range in length from char(4) to char(10). Also a single trim() doesn't work. I need to trim(trim()) or the length of the field is still 254. I have no control over how the data will be stored in the database. I have requested they all be

Re: [OT] Re: VTML Builder

2002-03-07 Thread freddy
- Commerce Builder - Original Message - From: freddy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 2:24 PM Subject: Re: [OT] Re: VTML Builder I already get a ton of spam...I don't like it so I delete it. And also I do not mind filling out forms writing

RE: [OT] Re: VTML Builder

2002-03-07 Thread Owens, Howard
-- not that these are perfect work arounds. Even with MSSQL server, output of char fields needs to be trimmed, especially when doing comparisons. H. -Original Message- From: freddy [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 1:07 PM To: CF-Talk Subject: Re: [OT] Re: VTML Builder