Digital Workshop

Ok

So i did the Post Web data tutorial and i am now hooked LOL

( I preseum you figured out i'm new to this )

I have a project in mind........

its a client OR web page that must be able to list atleast 10 to 20 lines of data in a scrollable window and the data will be from 10 to 20 lines with 7 colums and may have as many as 100 to 200 people monitoring its data...


I am NEW to data bases and have a few questions....


Once i enter the data into the DB , is there away to have it timed to auto reset/remove ?

Can the reset/deletion be activated by date/time ?


how to display the 20 lines of 7 colums ?

When i enter NEW data does it automaticly attch itself to the bottom of the list ?


Lets start with those few quesions and get a grip on that LOL



Thanks in Advance

Al

Al,


Some months ago I posted a working sample Pub, "Getting Started with SQLite DB". (did not have SQL_Update working back then, but reading from DB was fine.) That demo pub includes multi-column display of data records in both Lisboxes and in standard Text Object. You will find the script code there adaptable to your purpose.

Usually something like: Pagevar02 = Field1data[i] + "\t" + Field4data[i] + "\t" + Field5data[i] + "\n" ;
So Columns are separated by the Tab escape char, and the Record/Line ends with a line return. Depending on what you want to accomplish... might use TextObj6.ReplaceSelection( Pagevar02 ) constructs.


To the User, things could look 'automatic'... but that's why programmers have jobs behind the scenes. Within Opus you could do a periodic refresh (new read) at certain intervals. Or, you could have Opus read the DB constantly and 'detect' a change in Record count (or some other data change)... then when 'true', execute the refresh.



I have not worked on the server/PHP side... so others will have some solutions for that. The SQL DBs have a 'trigger' feature that I suspect could be mobilized for this kind of thing.

Cheers

If you want the database to delete or update etc every x amount of time, you will need to create a php function to do this and a "cron job" to run that. (google)

Hi Al,

I'm not 100% sure where the data is coming from or how frequently it is being refreshed. You can use cron and most modern databases allow for job scheduling.

I would image if you are looking for frequent updates then the T&Cs of your web-host will probably prevent anything under about 15mins.

Mack

What do you mean T&C's ?

also Mack can you have alook at the post i made in BASIC's about the Post Web Data tutorial........i cant seem to get the data back into my PUB.....is the script flawed...



Al