Ask a Question related to Macromedia ColdFusion, Design and Development.
-
TimH2O #1
Queries Of Queries Single Quote Problem
When using queries of queries I'm having the following issue. Select
Company_ID From qry_MyQuery Where Company_NM = 'MyString''s' <---- That's
two single quotes In the 'qry_MyQuery' query there is a Company Name =
MyString's This works when I query against SQL Server, but not query of
queries. Has anyone else run into this? Any work arounds? Thanks.
TimH2O Guest
-
Single & Double Quote Problem in Database Insert/Update
Hello, I have a textarea on a form where users are able to enter text wrapped in 'single' and "double" quotes. However, when I insert or update... -
does SQL::Abstract only formulate queries for a single table?
In looking at the docs for SQL::Abstract, one gets the impression that the module can only dynamically generate queries for a single table. Is... -
Single Quote Problem in Excel to Export
Hi, We have to export our data in sql server table to any excel sheet. We have a template to export, using oledb we are inserting rows to this... -
SQL insert/update problem if coldfusion field value has single quote
On the coldfusion form, if the user enter the data with single quote in a field (e.g. Joe's Party), and performs SQL insert or update statements,... -
double single quote problem in cfquery
Hi, i've this problem with ColdFusion MX 6.1 Updater and MX 7 If i try to insert a text containing a single quote (for example TEST') all works...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
