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

Back to topic list

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'

« Previous message in topic | 2 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: