Any see what is wrong with this query?

2007-06-06 Thread Ian Skinner
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

RE: Any see what is wrong with this query?

2007-06-06 Thread Ian Skinner
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

Re: Any see what is wrong with this query?

2007-06-06 Thread Zaphod Beeblebrox
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

RE: Any see what is wrong with this query?

2007-06-06 Thread Adkins, Randy
: 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

RE: Any see what is wrong with this query?

2007-06-06 Thread Ian Skinner
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

What is wrong with this query?

2006-11-21 Thread Doug Brown
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

Re: What is wrong with this query?

2006-11-21 Thread Charles Sheehan-MIles
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

Re: What is wrong with this query?

2006-11-21 Thread Jim Wright
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

Re: What is wrong with this query?

2006-11-21 Thread Doug Brown
, 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

Re: What is wrong with this query?

2006-11-21 Thread Doug Brown
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