Login | Register
My pages Projects Community openCollabNet

Discussions > tsWebEditor > Re: Extra chars inserted into a concatinated var

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

tswebeditor
Discussion topic

Hide all messages in topic

All messages in topic

Re: Extra chars inserted into a concatinated var

Author thaj
Full name Thaler
Date 2006-12-02 04:06:34 PST
Message >Sorry and glad I did not waste anyones time. I am new to
>PHP. My code is running and the SQL is still built with
>those extra slashes. My problem, I apparently do not know
>what I am doing, right yet. Thanks...
>
well, i think i'm now a long time in this business and
sometimes i have also that problem, that i do not know, what
i'm doing ... (;


...thaler...

Re: Extra chars inserted into a concatinated var

Author ichbin
Full name IchBin
Date 2006-11-30 14:31:37 PST
Message Sorry and glad I did not waste anyones time. I am new to
PHP. My code is running and the SQL is still built with
those extra slashes. My problem, I apparently do not know
what I am doing, right yet. Thanks...

 
>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,lastnam​e,firstname,middlena​me,SUFFIX 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,lastnam​e,firstname,middlena​me,SUFFIX from
>author_detail
> where upper(SUBSTRING(lastname,1,1)) = \'A\' ORDER
>BY lastname, firstname, middlename'
>
>Should look ike this:
> 'select
>id,TITLE,lastnam​e,firstname,middlena​me,SUFFIX from
>author_detail
> where upper(SUBSTRING(lastname,1,1)) = 'A' ORDER BY
>lastname, firstname, middlename'

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'
Messages per page: