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 my
> > 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,
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 be
> 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 soft
Keith,
You can pull a random record from Access by using the Rnd() function. So your
query would look like this:
select fld_page_ID, fld_title, fld_body, fld_attach_ID, fld_url,
fld_active_date, fld_inactive_date
from tbl_marketing_pages
where fld_item_type = "n"
and fld_act
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
Archive:
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, w
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 AM,
>*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.
~~~
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 th
I created a random record generator for pulling current news items. I am using
an access database for the back end and would like to know if anyone has a
better solution. This code works, but I think I'm missing something. Thank you
in advance Keith.
Step 1: Pull the current records and get a c
11 matches
Mail list logo