close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Unknown column 'ColumnName' in 'order clause'

Thread began 9/18/2009 12:20 pm by kphillips162496 | Last modified 7/27/2011 12:26 pm by wbrooks199805 | 4550 views | 13 replies |

kphillips162496

Unknown column 'ColumnName' in 'order clause'

I seem to be missing something in creating linked headers for sorting. After following the Sorting by Column Links directions (Started over 4 times with different errors) I have come to adding one column to sort (keeping it as simple as possible to track down the error) and I am at a point where I have Listing Price as a sort link on the header, but am getting the error
Unknown column 'WADALAHomes.MLS' in 'order clause'
When I remove the Sort and Binding and clean up what is left behind when you remove these, it works just fine. So I'm baffled why this won't work, no matter what I try, in the end it is the same error. The MLS column.
Has anyone else run into this, I did check the forums, but haven't found it.
Thank you to anyone that can enlighten me. :)

Sign in to reply to this post

Jason ByrnesWebAssist

The Tutorial for creating the links has you create a query string variable named sort and set the value to the name of the column.

for example, if the recordset has a column named "userName" that you wish to sort by, the link would be:
myPage.asp?sort=userName


from the error massage, you are creating the querystring variable with the value WADALAHomes.MLS which is not a column that exists in your recordset.

Sign in to reply to this post

kphillips162496

Actually all of the fields in this results page are WADALAHomes (the Recordset name) DOT Field name. And MLS is one of the columns. I do have a link created on the MLS field to the details page and took that off to see if it made a difference, but nope, same error.
The only sort that was setup was for List Price though.

Sign in to reply to this post

Jason ByrnesWebAssist

send a copy of your page in a zip file so I can look at the code.

Sign in to reply to this post

kphillips162496

Originally Said By: Jason Byrnes
  send a copy of your page in a zip file so I can look at the code.  



Found it...sorry

Attached Files
LAHomes_Results.zip
Sign in to reply to this post

Jason ByrnesWebAssist

I dont see how the code on this page could generate that error, the sort link you have is correct:
<a href="LAHomes_Results.php?sort=ListPrice">ListPrice</a>


try changing the following code:
$WADALAHomes = mysql_query($query_limit_WADALAHomes, $MLSDatabase) or die(mysql_error());


to:
$WADALAHomes = mysql_query($query_limit_WADALAHomes, $MLSDatabase) or die($query_limit_WADALAHomes);

and post back the SQL

Sign in to reply to this post

kphillips162496

You are brilliant!!

Thank You!! I have been fighting this thing for over a week!! You are brilliant. I will save my next issue for another day. Thank you so very very much.

Sign in to reply to this post

Miguel

im having the exact same issue and did the change to the query and worked fine, just in case im trying out the DataAssist 2.0.7 277 (Beta) before on version 2.0.6 i never had this problem with sort of fields

Sign in to reply to this post

Jason ByrnesWebAssist

can you give some more details please?

You say you edited the query, can you give some details on how you edited the query, what was changed?


can you send a copy of your page?

Sign in to reply to this post

wbrooks199805

having the same issue

I tried this fix but didn't work. I have attached the file.

Attached Files
subscriber_Results.php.zip
Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...