Initial Capitals (how to insert to db)

[gtbikerider]

Hi

I'm using...

<CFQUERY NAME=&quot;AddRec&quot; DATASOURCE=&quot;#application.DSN#&quot;>
insert into Users (FirstName)
values ('#FORM.firstname#')
</CFQUERY>

...to add a value to a db. How would I force an initial capital letter? eg &quot;john&quot; becomes &quot;John&quot;. I think its InitCap in sql but I can't figure out the precise syntax.

--
John Carratt

http://www.redleaf.co.uk

 

[JHoarty]

RedLeaf:

I could never figure out how to use INITCAP in a CF INSERT operation, either. You could use CF's UCASE function as follows:

<cfset namelen=LEN(form.firstname)>
<cfset fname = '#UCASE(Left(form.firstname, 1))##LCASE(MID(form.firstname, 2, namelen-1))#'>

Then insert fname into your table.

John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com