Databases
StackOverflow2013
Postsdbo
POColdfusion query weird characters
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POColdfusion query weird characters
    primarykey
    data
    text
    <p><strong>Problem</strong></p> <p>My (windows) server is showing an odd error when I use a query. However locally the query works just fine. The server adds  everywhere in the query.</p> <p><strong>The Error</strong></p> <blockquote> <p>Error Executing Database Query.</p> <p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.product = ao_products.id where ao_ranks.target = '1' order by ao_ranks.rank as' at line 1</p> <pre><code>&lt;cfset start = (page*perpage)-perpage&gt; &lt;cfquery name="get"&gt; select category,ao_products.id,model,name,rank,rating </code></pre> <p>from ao_ranks inner join ao_products on ao_ranks.product = ao_products.id where ao_ranks.target = '#target#' order by ao_ranks.rank asc limit #start#,#perpage# </p> <p>VENDORERRORCODE 1064</p> <p>SQLSTATE 42000</p> <p>SQL select category,ao_products.id,model,name,rank,rating from ao_ranks inner join ao_products on ao_ranks.product = ao_products.id where ao_ranks.target = '1' order by ao_ranks.rank asc limit 0,16</p> </blockquote> <p><strong>The Code (utf-8 encoded file)</strong></p> <pre><code>&lt;cfelse&gt; &lt;cfset start = (page*perpage)-perpage&gt; &lt;cfquery name="get"&gt; select category,ao_products.id,model,name,rank,rating from ao_ranks inner join ao_products on ao_ranks.product = ao_products.id where ao_ranks.target = '#target#' order by ao_ranks.rank asc limit #start#,#perpage# &lt;/cfquery&gt; &lt;/cfif&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJohn Pickup
    1. USThomas Van Nuffel
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POColdfusion query weird characters
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COLinux Server? Windows Server? What file encoding?
      singulars
      1. POColdfusion query weird characters
      1. USda_didi
    2. COWindows Server, UTF-8 encoding.
      singulars
      1. POColdfusion query weird characters
      1. USThomas Van Nuffel
    3. COPlease have a look at this one: http://stackoverflow.com/questions/1127711/coldfusion-xls-export-and-character-encoding
      singulars
      1. POColdfusion query weird characters
      1. USda_didi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload