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:235287 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
