Thank you Dean for seeing my issue, and supplying a possible resolution. I
agree access is not the best system out there, But I have applications with
over 500,000 records in a single table that have been working with cold fusion
of many years also. I agree I should migrate but that is not in
Keith McGee wrote:
I am using an access database for the back end
and would like to know if anyone has a better solution.
*snip*
1. Use MySQL.
2. Order by Rand()
3. ???
4. Profit
~|
Adobe® ColdFusion® 8 software 8 is the
*snip*
1. Use MySQL.
2. Order by Rand()
3. ???
4. Profit
this is not the only program or site running off of access database, we do have
oracle and I know I could use where rownum = #randomID#, but I am looking for
an access solution.
MS SQl server lets you order by newid()
ie.
select * from My_Table
order by newid()
I have no clue if this works in Access or not.
Wil Genovese
One man with courage makes a majority.
-Andrew Jackson
A fine is a tax for doing wrong. A tax is a fine for doing well.
On Oct 22, 2008, at 9:17
Well, Access isn't a database.
If you gave several sites, why not just make them in oracle?
I mean, why use access at all?
Keith McGee wrote:
*snip*
1. Use MySQL.
2. Order by Rand()
3. ???
4. Profit
this is not the only program or site running off of access database, we do
have
Thanks for the suggestion, but I tried that and I didn't work.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Keith,
You can pull a random record from Access by using the Rnd() function. So your
query would look like this:
cfquery name=get_news datasource=#dsn#
select fld_page_ID, fld_title, fld_body, fld_attach_ID, fld_url,
fld_active_date, fld_inactive_date
from tbl_marketing_pages
where
ORDER BY Rnd(fld_page_ID)
This command keeps pulling the same order, even if I close the browser. If they
go back to the main page I would like possibility of having a different news
item appear.
~|
Adobe® ColdFusion® 8
I understand you want to stay with access for whatever reason. But
consider how much trouble this is for you.. Are you sure you aren't able
to use a different database (or convince your client that he should move
up)? I mean, access can only handle 1 user at a time anyway.. That alone
should
ORDER BY Rnd(fld_page_ID)
This command keeps pulling the same order, even if I close the browser.
If they go back to the main page I would like possibility of having a
different news item appear.
Keith,
This is a ColdFusion caching issue. If you run the query directly in Access,
you
10 matches
Mail list logo
