Hello list Might be slightly off topic, apologies if thats the case, but I am trying to find a way to sort a table by clicking on the table headers. I have...
Thanks Shawn, Implemented it, it works, but same problem. Numbers sorting like text so in my column of values it sorts 1, 10, 101, 14,15,3,42 etc etc Any way...
Hi James, ... Link? My guess is that your data isn't correctly normalized, making detection of types inaccurate (defaulting to 'as text'), or you neglected to...
Hi Shawn ... Can you tell me what that means? I have implemented about 3 different examples of sorting code, none of which seem to sort the numbers correctly. ...
Just thought I would post a follow up to the table sorting problem. The reason why the numerics were not sorting correctly is because the HTML was of the...
Keep getting this error. I have some pretty basic SQL just selecting some data from an Access database. If I keep the query really simple, it works, add in...
Can you show us the SQL and the code you are using to execute the query against MS Access? Mark Wills, MSc MIAP http://www.markwills.co.uk ... From:...
Might be blaating here, but it seems like a rights issue, make sure you have writing access to the db folder When you start inner joining, access might need to...
Niels Bieze
nrbieze@...
Oct 5, 2006 7:59 am
11843
Hi Niels The 'write' box is ticked in IIS for the database. Is this what you are refering to? Also, if I take out one of the two joins, it works no problem....
This might be a good starting point: http://www.intermedia.net/support/kb/default.asp?id=646 Mark Mark Wills, MSc MIAP http://www.markwills.co.uk ... From:...
Hi Mark I did use that page as a starting point but it didn't shed any light. Thanks for the link. ... Access ... and it ... other ... storage with ... ...
Not xactly, check out: http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html...
Niels Bieze
nrbieze@...
Oct 5, 2006 11:35 am
11847
Is this an exact copy of the SQL statement? There is no . in tblY*. A way to get obscure errors is to try to run the query while you have one of the tables...
No, sorry, that was a typo. It should read tblY.* The reason tblZ is joined and not referenced as the query works without the reference, but get the error when...
Only about 6 fields. What do you mean by 'table in a table'? ... 'table in a table'? ... . in tblY*. ... have one of ... design ... you try ... execute far ......
Thinking about it, I think I had had similar errors when I had fields in my database that were empty (i.e. never had data in them), could this be related? Sure...
Ouch! I didn't know that! Never used CURRENT in a SQL expression before, now i'll have to go and look it up to see what it does ;) Thanks Mark ... From: David...
Hi can anyone tell me ...is it possible to call a client side function from server side code. i am using classic asp.and vbscript for client side. if yes...
Shawn, I interpreted his question as calling a routine hosted on a client machine, from the server, after the page has been rendered, in affect, similar to...
Hi Mark, ... I find that if we read too much into their questions we get lost in the technology behind it, espcially when there is obviously already a language...
Hi James, ... Normalization is causing the data to conform to a consistent pattern. For most tabular (table) data, this includes removing any white space and...
Hi Shawn Yes it is to display stats for a soccer based Fantasy Football competition giving a high level of analysis for how the players are scoring their...
Hi, Maybe I'm just tired, but I'm having some major problems with some code, and I can't understand why... it is part of a class which checks form input. I...
Hi Graeme, ... This is a string. In ASP string comparison uses ascii byte value, not numeric value, in effect comparing numeral 5 to asc("2") (=50). One other...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
