Dataform Sort Function Error??

Dataform Sort Function Error??

Post by Jonathan Bentle » Mon, 08 Jan 2001 02:35:20



Hi

I am using the dataform search function and get this error when i try to use
the sort button.  Any Ideas???

Regards

Jonathan Bentley

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be
displayed.

----------------------------------------------------------------------------
----

Please try the following:

Click the Refresh button, or try again later.

Open the z3 home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

----------------------------------------------------------------------------
----

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ORDER BY clause.
/build/stv/media/IIS_Gen_3.0_Recordset.js, line 392

Browser Type:
Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)

Page:
POST 228 bytes to /build/stv/mplaceresult.asp

POST Data:
List1=Clamp+Force&Recordset4_SortList=Model&Recordset4_Action=&Recordset4_Po
sition=FIL%3A++Make+%3D+%27Arburg%27+AND+%5Bclamp+search%5D+%3D+%27201-300%2
7ORD%3AABS%3AMTYKEY%3APAR%3A%5Bparam%5D%3Dyear&T . . .

 
 
 

1. DataForm's SORT smartelement

Hi,

 Before I was using DataForm generated sort smartelement on my result pages.
But now,
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL
statement.
/3/media/IIS_Gen_3.0_Recordset.js, line 392

I have no idea. The sql just takes all the fields in the table, very simple.
But it is not working.

Any Ideas,
Rgrds.

2. Shared review error

3. dataGrid sort function

4. Flash buttons don't target iframes!!!!!!!?

5. Looking for a Good Java Sort Table Function

6. <cfinclude template="myfile.cfm">

7. MX/Repeat region & sort function

8. Collision Detection in 2d Director?

9. Sort function on columns.

10. Sort function

11. regarding SORT function

12. Direct control of sort() function...

13. Sort won't work in dataform wizard - any help?