Re: How do I get rid of single quote duplication in sql?
preserveSingleQuotes() ? On 3/7/06, Oleg Gunkin [EMAIL PROTECTED] wrote: I have the following problem with sql generation: Example cfset sqlPart = 'name: ' + name cfquery select #sqlPart# as name from user /cfquery The outcome of this code is select ''name: '' + name as name from user How do I get rid of single quote duplication? -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234497 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
RE: How do I get rid of single quote duplication in sql?
PreserveSingleQuotes() -Original Message- From: Oleg Gunkin [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 07, 2006 2:26 PM To: CF-Talk Subject: How do I get rid of single quote duplication in sql? I have the following problem with sql generation: Example cfset sqlPart = 'name: ' + name cfquery select #sqlPart# as name from user /cfquery The outcome of this code is select ''name: '' + name as name from user How do I get rid of single quote duplication? -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234498 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do I get rid of single quote duplication in sql?
try using preserveSingleQuotes() DK On 3/7/06, Oleg Gunkin [EMAIL PROTECTED] wrote: I have the following problem with sql generation: Example cfset sqlPart = 'name: ' + name cfquery select #sqlPart# as name from user /cfquery The outcome of this code is select ''name: '' + name as name from user How do I get rid of single quote duplication? -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234500 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How do I get rid of single quote duplication in sql?
Use the function PreserveSingleQuotes() cfset sqlPart = 'name: ' + name cfset sqlPart = #PreserveSingleQuotes(sqlPart)# -Brandon -Original Message- From: Oleg Gunkin [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 07, 2006 11:26 AM To: CF-Talk Subject: How do I get rid of single quote duplication in sql? I have the following problem with sql generation: Example cfset sqlPart = 'name: ' + name cfquery select #sqlPart# as name from user /cfquery The outcome of this code is select ''name: '' + name as name from user How do I get rid of single quote duplication? -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234499 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
Re: How do I get rid of single quote duplication in sql?
PreserveSingleQuotes() On 3/7/06, Oleg Gunkin [EMAIL PROTECTED] wrote: I have the following problem with sql generation: Example cfset sqlPart = 'name: ' + name cfquery select #sqlPart# as name from user /cfquery The outcome of this code is select ''name: '' + name as name from user How do I get rid of single quote duplication? -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234501 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54