Logs Record Set - query - Top 4 of 4 Rows
ATTRIBUTES DATELASTMODIFIED DIRECTORY MODE NAME SIZE TYPE
1 [empty string] 06/06/2007 10:59:17 AM G:\Tracker\wwwRoot\Data
[empty string] ChargedOut_06Jun2007_ILS_105634322.txt 828 File
2 [empty string] 06/06/2007 10:57:00 AM
Thanks anyway, I finally saw the errant white space character.
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is
is name a char type vs a varchar, if so, you'll have to pad with
spaces on the right.
On 6/6/07, Ian Skinner [EMAIL PROTECTED] wrote:
Logs Record Set - query - Top 4 of 4 Rows
ATTRIBUTES DATELASTMODIFIED DIRECTORY MODE NAME SIZE TYPE
1 [empty string] 06/06/2007 10:59:17 AM
: Wednesday, June 06, 2007 3:35 PM
To: CF-Talk
Subject: Any see what is wrong with this query?
Logs Record Set - query - Top 4 of 4 Rows
ATTRIBUTES DATELASTMODIFIED DIRECTORY MODE NAME SIZE TYPE
1 [empty string] 06/06/2007 10:59:17 AM G:\Tracker\wwwRoot\Data [empty
string
Not sure if this is a typo BUT:
Nope, that was the issue. Just took me awhile to see that white space
character.
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any
I have a sort function on a search results page that is giving me an Ambiguous
column name error, and for the life of me I do not know why. I can sort by
price, SKUName and photo just fine but cannot sort by city or state. I have a
city and state column in the table I am joining with, but
I think so. When you do the order by, should it be something like this
(assuming you are ordering by the ...adversements.city column)?
ORDER BY #APPLICATION.DBPRE#Advertisements.#ARGUMENTS.SORTYBY#
#ARGUMENTS.SORTDIRECTION#
O
On 11/21/06 9:37 PM, Doug Brown [EMAIL PROTECTED] wrote:
I have a
Doug Brown wrote:
I have a sort function on a search results page that is giving me an
Ambiguous column name error, and for the life of me I do not know
why. I can sort by price, SKUName and photo just fine but cannot sort
by city or state. I have a city and state column in the table I am
, November 21, 2006 7:45 PM
Subject: Re: What is wrong with this query?
I think so. When you do the order by, should it be something like this
(assuming you are ordering by the ...adversements.city column)?
ORDER BY #APPLICATION.DBPRE#Advertisements.#ARGUMENTS.SORTYBY#
#ARGUMENTS.SORTDIRECTION
That worked. Dont know what the hell I am doing sometimes.
Doug B.
- Original Message -
From: Charles Sheehan-MIles [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, November 21, 2006 7:45 PM
Subject: Re: What is wrong with this query?
I think so. When you
10 matches
Mail list logo