Couple of thoughts:
I have found CFGrid to be less than reliable/predictable
You didn't mention which browser/platform... I have found some
browsers, Particularly IE, don't always go to the server (IE 4.5 Mac,
almost never does) but erroneously use the cached page (sure are
fast, tho)
You can refresh the dropdown list with a JavaScript onLoad routine.
Doing so works fine except with some NN versions. it will not display
the dropdown correctly if you change the options and the selected
option... You have to invoke an event after the load (onClick, etc).
You may be better off just regen'ing the entire page/frame with CF.
(I just wasted 2 days trying to do this on NN 4.x Mac)
The SQL Query will return the record set in the correct date order
(if you include the date column in an ORDER BY)... that's its job.
Now, how you chose to format the date when you traverse the ordered
record set makes no difference... it is independent of the order.
At 10:49 AM +0930 7/21/00, Phil Palmer wrote:
>Dear All
>
>I have a CF template where the user has to enter data in various
>fields and then submit. On certain fields there is a button they
>can click on to lookup various tables for control codes. This
>pops up a small browser window using CFGRID to let them update the
>table and exit. I find that if they use this lookup facility a
>few times the data is not refreshed and they have to hit refresh
>on the browser.
>
>Is there a way of forcing the browser to display fresh data and
>not cached data?
>
>Also when they come back from the lookup I want to refresh the
>drop down list that reflects the table they just updated. Can
>you do this from a javascript function?
>
>Any thoughts ???
>
>Another question regarding dates and SQL. I am getting a smalldatetime
>field back from a database and displaying it. It displays the date and
>time(which I do not want displayed). Can I use CF date format functions
>in the CFQUERY or do I have to use SQL functions? If I use string functions
>I end up with a string rather than a date which means that the SQL order
>is based on text sorting rather than date sorting.
>
>Thanks in advance
>
>Phil Palmer
>Engage Technology
>Adelaide, Australia
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
