many thanks Michael, excellent :-) >>-----Original Message----- >>From: Michael Traher [mailto:[EMAIL PROTECTED] >>Sent: 13 March 2006 21:52 >>To: CF-Talk >>Subject: Re: Inches >> >> >>Hi Jennifer, You can substitute the "#form.yourfield#" with >>'#form.yourfield#' (i.e. single quotes) but it is also good >>practice to use >>the <cfqueryparam> tag within your sql as follows: >> >><cfquery name="qMyInsert" datasource="#request.datasource#"> >> insert into mytable >> (col1,...... other columns) >> values >> (<cfqueryparam cfsqltype="cf_sql_varchar" value="#form.yourfield#" >>maxlength="5">, >>other values......) >></cfquery> >> >>choose the type and length to match your database column. >> >>Hope that helps. >> >>On 3/13/06, Jennifer Gavin-Wear <[EMAIL PROTECTED]> wrote: >>> >>> for example: >>> >>> into a form text input goes "4"/10cm" what gets stored is 4, >>because the >>> " >>> is taken as end of string. >>> >> >>-- >>Mike T >>Blog http://www.socialpoints.com/ >> >> >>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
