forcing upper case on insert of record

[D Woods]

I'm having trouble figuring out the code to force a form field to upper case
when it is inserted into the database. This is what I have. What am I doing
wrong? Thanks.

<cfquery name = "insdata" datasource = "#application.dsn#">
insert into accounts
(fname, lname, hsname, hscity, hsstate)
values('#form.fname#','#form.lname#','#UCASE(form. hsname)#','#form.hscity#','#form.hsstate#')
</cfquery>

[Dan Bracuk]

Your code looks like the hsname will be inserted upppercase, and everything else will be inserted as entered. Is that what is happening? Is that what you want?

[D Woods]

Yes...sorry I left that part out of my original post. I just need hsname to
be forced to upper case.

"Dan Bracuk" <webforumsuser@macromedia.com> wrote in message
news:div3vg$qb2$1@forums.macromedia.com...

> Your code looks like the hsname will be inserted upppercase, and
> everything else will be inserted as entered. Is that what is happening?
> Is that what you want?

[redevolve]

Should be fine if hsname is the field that you want to be converted to uppercase.

[Dan Bracuk]

And it's not happening? Your code suggests that it should.

There is always this way:
<cfset uppercasehsname=ucase(form.hsname)>

Then use this new variable in your query instead of form.hsname. But I find
it odd that your code as posted does not accomplish this. Mind you, I don't
think I have ever used the ucase function inside a cfquery tag so I don't know
for sure.

[jjsand28]

Check the formatting of the column in your database. That might be causing it.