oops, missed the de() round the last bit there! ----- Original Message ----- From: "Tom Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 4:06 PM Subject: Re: [ cf-dev ] Apostrophes in Iif()
> are you trying to do something like: > #Iif(not Len(Trim(Form.Field)), "null", > "#chr(39)##Trim(Form.Field)##chr(39)#")# > > > see if that is what you are looking for.... > ----- Original Message ----- > From: "Aidan Whitehall" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, February 05, 2003 3:52 PM > Subject: [ cf-dev ] Apostrophes in Iif() > > > I want to be able to write an SQL statement using Iif() and my machine > is grinding to a halt whilst trying to get the syntax right (it seems to > occur when there's a particular combination of quotes and apostrophes). > > Does anyone know the correct syntax which allows you to do something > like this (below) in a cfquery block, so that if anything was supplied > in a form field, it returns the string "null", otherwise, it's evaluated > and wrapped in single quotes: > > #Iif(not Len(Trim(Form.Field)), "null", "'" & DE(Trim(Form.Field)) & > "'")# > > (doublequote-apostrophe-doublequote-ampersand etc etc) > > With the code above, if Form.Field is supplied, it's evaluating it but > not adding the apostrophes. > > > Thanks > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Macromedia ColdFusion Developer > Fairbanks Environmental Ltd +44 (0)1695 51775 > > ________________________________________________________________________ > This e-mail has been scanned for all viruses by Star Internet. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ________________________________________________________________________ > > -- > ** 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] > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > > -- > ** 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] __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- ** 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]
