Login | Register
My pages Projects Community openCollabNet

Discussions > tsWebEditor > Extra chars inserted into a concatinated var

Project highlights: home | downloads | news | features | screenhots | support

tswebeditor
Discussion topic

Back to topic list

Extra chars inserted into a concatinated var

Author ichbin
Full name IchBin
Date 2006-11-27 12:30:00 PST
Message This problem is only happening under tsWebEditor. I am
running the latest: 2.2.20.80 (20061029)

Given these two vars:

$author_detail_select_by_Letter = "select
id,TITLE,lastname,fi​rstname,middlename,S​UFFIX from
author_detail where upper(SUBSTRING(lastname,1,1)) = '";

$author_detail_orderBy = "' ORDER BY lastname, firstname,
middlename";
    
Building $sqlcmd from the above two vars to issue a SQL
command

$sqlcmd = $author_detail_select_by_Letter .
$_POST['abbr_letter'] . $author_detail_orderBy;
    
I noticed that the SQL statement is be changed incorrectly.
    
$sqlcmd looks like this:
    'select
id,TITLE,lastname,fi​rstname,middlename,S​UFFIX from
author_detail
    where upper(SUBSTRING(lastname,1,1)) = \'A\' ORDER
BY lastname, firstname, middlename'
    
Should look ike this:
    'select
id,TITLE,lastname,fi​rstname,middlename,S​UFFIX from
author_detail
    where upper(SUBSTRING(lastname,1,1)) = 'A' ORDER BY
lastname, firstname, middlename'

« Previous message in topic | 1 of 3 | Next message in topic »

Messages

Show all messages in topic

Extra chars inserted into a concatinated var ichbin IchBin 2006-11-27 12:30:00 PST
     Re: Extra chars inserted into a concatinated var ichbin IchBin 2006-11-30 14:31:37 PST
         Re: Extra chars inserted into a concatinated var thaj Thaler 2006-12-02 04:06:34 PST
Messages per page: