Question: I have video, and image library on our intranet and we want to have a hyperlink that will allow the user to download the file to their hard drive without having right click and select file save as. Is there an easy way to do this?
Thanks, Brad Fetter [EMAIL PROTECTED] -----Original Message----- From: Tony Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 4:35 PM To: CF-Talk Subject: RE: SQL concat You might need to use #preserveSingleQuotes(form.txtFormField1)# ��� Tony -----Original Message----- From: CF Dude [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 10:21 AM To: CF-Talk Subject: Re: SQL concat That should work assuming your datatypes work together. HEre's another example 'The price is ' + CAST(price AS varchar(12)) You may need to break out CONVERT() instead of CAST() E ----- Original Message ----- From: "Cantrell, Adam" <[EMAIL PROTECTED]> What's the operator for string concatenation in SQL server - I'm trying: SET txtColumnName1 = txtColumnName1 + '#form.txtFormField1#' And that's throwing me an "Invalid operator for data type" error. Anyone help me out right quick? Adam. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

