tracker issue : CF-4126468

select a category, or use search below
(searches all categories and all time range)
Title:

Whitespace problem

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Frédéric Peters / Frédéric Peters (External User)

Created: 03/09/2016

Components: General Server

Versions: 2016

Failure Type: Unspecified

Found In Build/Fixed In Build: Beta2_v12 /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Win All

Vote Count: 0

Problem Description: Somewhere in my code I had to do something like this:

1. Query ( name=query1)
2. Output of query 1. Then, inside this output: a second query ( for instance named query2 ) then I call "#query2.city# #query2. postalcode#" with a space between them. 

For some reasons I did not manage this with one single query and joins. I don't remember exactly  why.

Steps to Reproduce:

Actual Result: The values are outputed but the space between the two values disappeared. 

Expected Result: I expected something like "Brussels 1030" but t I received
"Brussels1030" ( without space ) 

Any Workarounds: hardcode a whitespace with   or code with only one query and joins.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4126468

External Customer Info:
External Company:  
External Customer Name: Frédéric Peters
External Customer Email: frederic.peters@outlook.com
External Test Config: Friendly Name: Win2008R2 Apache 2.2.21
Device Type: Server
Manufacturer/Brand: Supermicro
Model: unknown
Memory (ROM): 4
Operating System (if known): Windows 2008 R2 64 bits

Attachments:

Comments:

Adding BUG AUDIT TRAIL ********action: updated fieldName: Closed By newValue: nimsharm oldValue: Blank oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-29 19:22:29.0 action: updated fieldName: Date Closed newValue: 2016-01-29 11:22:29.0 oldValue: Blank oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-29 19:22:29.0 action: updated fieldName: Owner newValue: Blank oldValue: nimsharm oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-29 19:22:29.0 action: updated fieldName: State newValue: Closed oldValue: Open oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-29 19:22:29.0 action: updated fieldName: Reason newValue: Blank oldValue: Fixed oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-29 19:22:29.0 action: updated fieldName: Status newValue: Fixed oldValue: ToTest oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-29 19:22:29.0 action: updated fieldName: Fixed By newValue: himar oldValue: Blank oprid: himar recordName: RQ_DEFECT timpestamp: 2016-01-28 09:06:34.0 action: updated fieldName: Reason newValue: Fixed oldValue: BugVerified oprid: himar recordName: RQ_DEFECT timpestamp: 2016-01-28 09:06:34.0 action: updated fieldName: Status newValue: ToTest oldValue: ToFix oprid: himar recordName: RQ_DEFECT timpestamp: 2016-01-28 09:06:34.0 action: updated fieldName: Date Fixed newValue: 2016-01-28 01:06:34.0 oldValue: Blank oprid: himar recordName: RQ_DEFECT timpestamp: 2016-01-28 09:06:34.0 action: updated fieldName: Changelist newValue: 297819 oldValue: Blank oprid: himar recordName: RQ_DEFECT timpestamp: 2016-01-28 09:06:34.0 action: updated fieldName: Owner newValue: nimsharm oldValue: himar oprid: himar recordName: RQ_DEFECT timpestamp: 2016-01-28 09:06:34.0 action: updated fieldName: Reason newValue: BugVerified oldValue: NewBug oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-28 06:13:45.0 action: updated fieldName: Fix By Product Milestone newValue: Gold Master oldValue: Blank oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-28 06:12:07.0 action: updated fieldName: Owner newValue: himar oldValue: nimsharm oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-28 06:12:07.0 action: updated fieldName: Status newValue: ToFix oldValue: Unverified oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-28 06:12:07.0 action: updated fieldName: Fix By Milestone newValue: Gold Master oldValue: Blank oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-28 06:12:07.0 action: updated fieldName: Reason newValue: NewBug oldValue: Blank oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-28 06:12:07.0 action: updated fieldName: Found in Phase newValue: Beta2 oldValue: Blank oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-01-28 06:12:07.0 action: updated fieldName: QE Assigned newValue: nimsharm oldValue: vmannebo oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2016-01-28 04:32:56.0 action: updated fieldName: Dev Assigned newValue: himar oldValue: rukumar oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2016-01-28 04:32:56.0 action: updated fieldName: Owner newValue: nimsharm oldValue: vmannebo oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2016-01-28 04:32:56.0
Comment by CFwatson U.
4048 | March 09, 2016 02:12:56 AM GMT
Added By: PreRelease User User Name:Frédéric Peters Note Added: <cfquery datasource="#application.datasource#" name="q1"> SELECT itemID FROM products WHERE itemID = "224867" </cfquery> <cfoutput query="q1"> <cfquery datasource="#application.datasource#" name="q2"> SELECT itemID, titre FROM Products WHERE itemID = #itemId# </cfquery> #q2.itemID# #q2.titre#<br /> </cfoutput> I read it is fixed. Sorry for the delay. Date Added :2016-01-28 13:49:47.0 Added By: PreRelease User User Name:Aaron Neff Note Added: Hi Frédéric, Very interesting. I'd like to see a standalone repro for this. Thanks!, -Aaron Date Added :2016-01-12 09:28:45.0 Added By: PreRelease User User Name:Frédéric Peters Note Added: I dont consider myself as a real developper. I may do things that are not good but I "play" with Coldfusion more than 10 years and use it especially because it is easy to code. I hope my bug reports are valuable feedback for you Date Added :2016-01-11 17:44:10.0
Comment by CFwatson U.
4049 | March 09, 2016 02:13:13 AM GMT
Hi Adobe, "Reported By" isn't visible. Please display: "Frédéric Peters". Thanks!, -Aaron
Comment by External U.
4050 | May 28, 2016 01:54:19 PM GMT