But datalength has to do a search. Okay, I'll accept your 'semantics' argument, just to save space on my hard disk.
:-) Paolo > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 11:35 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] sql help > > > > Because I sent my email before the 'datalength(column)' solution was > > suggested and I did say a last resort. > > ah ok, I got that email quite a bit after the datalength one. > > > I do repeat though that you are searching on a text column. > > I think we're talking semantics. I still say I'm not searching on the > column. I'm selecting it. > > searching it would be > > WHERE datalength(column) > 0 or something. > > in my select statement I'm retrieving the size of the cell > and in the case > statement I select a 1 or a 0 depending on the outcome of the > datalength. > thats not searching. > > > -----Original Message----- > > From: Paolo Piponi [mailto:[EMAIL PROTECTED]] > > Sent: 12 September 2002 11:51 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] sql help > > > > > > Because I sent my email before the 'datalength(column)' solution was > > suggested and I did say a last resort. > > > > I do repeat though that you are searching on a text column. > > Whether you are > > calculating the length or evaluating the value, you are still > > searching on > > the text column. > > > > Paolo > > > > > -----Original Message----- > > > From: Rich Wild [mailto:[EMAIL PROTECTED]] > > > Sent: 12 September 2002 11:25 > > > To: '[EMAIL PROTECTED]' > > > Subject: RE: [ cf-dev ] sql help > > > > > > > > > no, I'm not, I'm retrieving the size of the text contents, > > > not searching on > > > the contents. > > > > > > why would I want to go to the hassle of creating a duplicate > > > of the column > > > and storing it in a new table with triggers etc when > > > datalength(column) > > > works just fine? > > > > > > > -----Original Message----- > > > > From: Paolo Piponi [mailto:[EMAIL PROTECTED]] > > > > Sent: 12 September 2002 11:43 > > > > To: '[EMAIL PROTECTED]' > > > > Subject: RE: [ cf-dev ] sql help > > > > > > > > > > > > > I'm not searching on the text, I'm just checking to see if > > > > > theres text in > > > > > there or not. > > > > > > > > > > > > > Yes, you are searching on text! > > > > > > > > Paolo > > > > > > > > -- > > > > ** Archive: > > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > -- > > > ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
