Paul, did that work? ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 1:34 PM Subject: Re: [ cf-dev ] a-z
> > should perhaps be > > <cfquery name="select_az" datasource="WebUserDSN"> > SELECT EstablishmentName > FROM School_Details > WHERE LEFT(EstablishmentName,1) = '#attributes.search_string#' > ORDER BY EstablishmentName > </cfquery> > > (quotes around the string) > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: > http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > > [EMAIL PROTECTED] > ham.gov.uk To: [EMAIL PROTECTED] > cc: > 29/09/2003 13:28 Subject: Re: [ cf-dev ] a-z > Please respond to dev > > > > > > > Hmmm. did that and still doesn't work. Should have looked at error message > though.... > Invalid column name 'a' - er I think thats a little wrong then ..... > > I just wanted to look in school_details and find all records starting with > a .... > > Regards - Paul > > > > > **************************************************************************** ********************* > > The information contained within this e-mail (and any attachment) sent by > Birmingham City Council is confidential and may be legally privileged. It > is intended only for the named recipient or entity to whom it is addressed. > If you are not the intended recipient please accept our apologies and > notify the sender immediately, or telephone +(44) 121 303 6666. > Unauthorised access, use, disclosure, storage or copying is not permitted > and may be unlawful. Any e-mail including its content may be monitored and > used by Birmingham City Council for reasons of security and for monitoring > internal compliance with the office policy on staff use. E-mail blocking > software may also be used. Any views or opinions presented are solely those > of the originator and do not necessarily represent those of Birmingham City > Council. We cannot guarantee that this message or any attachment is virus > free or has not been intercepted and amended. > > **************************************************************************** ********************* > > > > -- > ** 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]