RE: [OT] Re: VTML Builder
Have you thought about running an ALTER TABLE sql statement yourself, instead of waiting for somebody else to do it for you? ... change the char to varchar yourself? Do the fields need to be 254? Could you alter them to, say, char(10), char(100) ... whatnot? Maybe that would require less trimming. If you don't want to muck with the existing table, use CREATE TABLE, setting it up to your preferences, then populate it with the data from the old table, then running your application against your new table. Just some suggestions for getting around unhelpful db admins -- 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 > > 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 converted to > varchar fields but it doesn't happen. If a single > trim would work I would not worry so much but again I am trying to compare > values held in cf variables that are now 255 > to database fields that are 4-10 chars long. A trim wouldn't help me there > unless I have the oracle developers trim all > the values coming out of the database in the stored proc and trim(trim()) > the char field. This has been going on since > version 4 and we are now on version 5 of cf. > Thanks > > Jerry Johnson wrote: > > > 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 into > the > > field.) > > > > 1. change it to a varchar > > or > > 2. trim() it before use. > > > > Jerry Johnson > > > > >>> [EMAIL PROTECTED] 03/07/02 03:24PM >>> > > 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 it again :-) > > I am still waiting for a single response to my question about char > fields > > returned via stored procedures in oracle being > > padded to a length of 255 and whether it is a bug or there is a way > around > > it. > > Thanks in advance... > > > > Gyrus wrote: > > > > > > What difference does it make? If you want it fill out the info... > > > > it is faster than writing an email to complain about it. > > > > > > Maybe I'm being too cynical, but to me *spam* makes the > > > difference. I was just looking for some assurance that the > > > download is actually *free*, and not paid for by allowing > > > the people you give your info to to sell that info on for > > > marketing (I couldn't see any assurance on the site). > > > > > > BTW, it would have been faster for you to not criticise > > > my questioning than to do so (nod to Bill Hicks ;) > > > > > > - Gyrus > > > > > > > > > - [EMAIL PROTECTED] > > > work: http://www.tengai.co.uk > > > play: http://www.norlonto.net > > > - PGP key available > > > > > > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT] Re: VTML Builder
If you had cared to read through the post you would have seen a legitimate question. Again if you don't want to read it delete it. Thank you, Frederic Paul Giesenhagen wrote: > 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 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 it again :-) > > I am still waiting for a single response to my question about char fields > returned via stored procedures in oracle being > > padded to a length of 255 and whether it is a bug or there is a way around > it. > > Thanks in advance... > > > > Gyrus wrote: > > > > > > What difference does it make? If you want it fill out the info... > > > > it is faster than writing an email to complain about it. > > > > > > Maybe I'm being too cynical, but to me *spam* makes the > > > difference. I was just looking for some assurance that the > > > download is actually *free*, and not paid for by allowing > > > the people you give your info to to sell that info on for > > > marketing (I couldn't see any assurance on the site). > > > > > > BTW, it would have been faster for you to not criticise > > > my questioning than to do so (nod to Bill Hicks ;) > > > > > > - Gyrus > > > > > > > > > - [EMAIL PROTECTED] > > > work: http://www.tengai.co.uk > > > play: http://www.norlonto.net > > > - PGP key available > > > > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT] Re: VTML Builder
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 converted to varchar fields but it doesn't happen. If a single trim would work I would not worry so much but again I am trying to compare values held in cf variables that are now 255 to database fields that are 4-10 chars long. A trim wouldn't help me there unless I have the oracle developers trim all the values coming out of the database in the stored proc and trim(trim()) the char field. This has been going on since version 4 and we are now on version 5 of cf. Thanks Jerry Johnson wrote: > 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 into the > field.) > > 1. change it to a varchar > or > 2. trim() it before use. > > Jerry Johnson > > >>> [EMAIL PROTECTED] 03/07/02 03:24PM >>> > 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 it again :-) > I am still waiting for a single response to my question about char fields > returned via stored procedures in oracle being > padded to a length of 255 and whether it is a bug or there is a way around > it. > Thanks in advance... > > Gyrus wrote: > > > > What difference does it make? If you want it fill out the info... > > > it is faster than writing an email to complain about it. > > > > Maybe I'm being too cynical, but to me *spam* makes the > > difference. I was just looking for some assurance that the > > download is actually *free*, and not paid for by allowing > > the people you give your info to to sell that info on for > > marketing (I couldn't see any assurance on the site). > > > > BTW, it would have been faster for you to not criticise > > my questioning than to do so (nod to Bill Hicks ;) > > > > - Gyrus > > > > > > - [EMAIL PROTECTED] > > work: http://www.tengai.co.uk > > play: http://www.norlonto.net > > - PGP key available > > > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [OT] Re: VTML Builder
Oracle does the same thing in VB applications. We have always had to trim our variables to get rid of the excess spaces Doubt that helped ya any Shawn Grover -Original Message- From: freddy [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 1:25 PM To: CF-Talk 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, 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 it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: > > What difference does it make? If you want it fill out the info... > > it is faster than writing an email to complain about it. > > Maybe I'm being too cynical, but to me *spam* makes the > difference. I was just looking for some assurance that the > download is actually *free*, and not paid for by allowing > the people you give your info to to sell that info on for > marketing (I couldn't see any assurance on the site). > > BTW, it would have been faster for you to not criticise > my questioning than to do so (nod to Bill Hicks ;) > > - Gyrus > > > - [EMAIL PROTECTED] > work: http://www.tengai.co.uk > play: http://www.norlonto.net > - PGP key available > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT] Re: VTML Builder
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 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 it again :-) > I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being > padded to a length of 255 and whether it is a bug or there is a way around it. > Thanks in advance... > > Gyrus wrote: > > > > What difference does it make? If you want it fill out the info... > > > it is faster than writing an email to complain about it. > > > > Maybe I'm being too cynical, but to me *spam* makes the > > difference. I was just looking for some assurance that the > > download is actually *free*, and not paid for by allowing > > the people you give your info to to sell that info on for > > marketing (I couldn't see any assurance on the site). > > > > BTW, it would have been faster for you to not criticise > > my questioning than to do so (nod to Bill Hicks ;) > > > > - Gyrus > > > > > > - [EMAIL PROTECTED] > > work: http://www.tengai.co.uk > > play: http://www.norlonto.net > > - PGP key available > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT] Re: VTML Builder
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 into the field.) 1. change it to a varchar or 2. trim() it before use. Jerry Johnson >>> [EMAIL PROTECTED] 03/07/02 03:24PM >>> 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 it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: > > What difference does it make? If you want it fill out the info... > > it is faster than writing an email to complain about it. > > Maybe I'm being too cynical, but to me *spam* makes the > difference. I was just looking for some assurance that the > download is actually *free*, and not paid for by allowing > the people you give your info to to sell that info on for > marketing (I couldn't see any assurance on the site). > > BTW, it would have been faster for you to not criticise > my questioning than to do so (nod to Bill Hicks ;) > > - Gyrus > > > - [EMAIL PROTECTED] > work: http://www.tengai.co.uk > play: http://www.norlonto.net > - PGP key available > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 so I thought I'd do it again :-) I am still waiting for a single response to my question about char fields returned via stored procedures in oracle being padded to a length of 255 and whether it is a bug or there is a way around it. Thanks in advance... Gyrus wrote: > > What difference does it make? If you want it fill out the info... > > it is faster than writing an email to complain about it. > > Maybe I'm being too cynical, but to me *spam* makes the > difference. I was just looking for some assurance that the > download is actually *free*, and not paid for by allowing > the people you give your info to to sell that info on for > marketing (I couldn't see any assurance on the site). > > BTW, it would have been faster for you to not criticise > my questioning than to do so (nod to Bill Hicks ;) > > - Gyrus > > > - [EMAIL PROTECTED] > work: http://www.tengai.co.uk > play: http://www.norlonto.net > - PGP key available > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists