If I use CFINSERT there's no way to trim the values, isn't it?
Manuel Tapiola
Buenos Aires, Argentina
-----Mensaje original-----
De: Snazzo Boy [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 10 de Abril de 2000 05:51 p.m.
Para: [EMAIL PROTECTED]
Asunto: RE: Trim??
If you have a form field with a size of 50 and someone enters
only 10 characters worth of space, you don't want all of the
whitespace passed to your form action page. Kinda like this:
<CFQUERY DATASOURCE="DSN" NAME="QueryName">
INSERT INTO DSN (UserID, Password)
VALUES ('#Trim(Form.UserID)#', '#Trim(Form.Password)#')
</CFQUERY>
Any time you want to pass a form field and cut out the
white space it's #Trim(Form.Fieldname)#. :P
Scott Wolf
Webmaster / Network Administrator
Road Warrior Trading.com
http://www.roadwarriortrading.com
-----Original Message-----
From: Computer Simplistics Support [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 4:40 PM
To: [EMAIL PROTECTED]
Subject: Trim??
I am assuming that I use the trim function to make sure that no whitespace
is on either side of a form field entry? Can someone give a quick example of
this?
Thanks!
Scott Berry
--
Computer Simplistics Support
"Simple Solutions for a Complex World"
http://www.c-s.net
661-296-4315
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
