watch database

hello all
I created my form connected to its database, how do I do see the database users?
Thank
Max

Hi Max,

I'm not clear what you want to do here?

You can see records saved in the database using the 'Show Data' icon in the Forms Manager toolbar. First you need to click the checkbox by the form name and then select a table from the drop-down in the Tables Connected column.

Bob

I would like to see the data in the table to my site users

Max

Hi Max,

Ah, OK. You can use a form with the DB Multi-Record loader action to create a simple list using the Display Data tab. Or you can use ChronoConnectivity to create a more complex customised list.

Bob

ok Bob
now I feel

Thank
Max

I did it perfect
but I have a little problem
on data display
this is my string
cd_id:numbers,Cognome:Cognome,Nome:Nome,Categoria:Categoria,Gara:Gara

in the numbers column do not see anything
Why?

Hi pennesw,

Should it be cf_id instead of cd_id?

Bob

I felt no change

Hi pennesw,

OK.

Bob

I can not understand where is the error

Hi pennesw,

I can't tell from this info. Please turn the Debugger on (at the bottom of the General | Advanced tab) and see if that gives any more useful information.

Bob

Hi pennesw,

There's no cd_id or cf_id in the SELECT query at the bottom of the image. Does one of these columns exist in the table?

Bob

Hi pennesw,

That has cf_id as the index in the first row. Have you tried cf_id:Numero ???

But it is the Create Table command also so may not be showing the column names from the table that has already been created.

Bob

I have already tried cf_id:Number

I'm sorry I did not understand the rest, my English is bad

Hi pennesw,

By all means email or PM me the site URL and a SuperAdmin login and I'll take a quick look.

Bob

Hi pennesw,

Fixed I think.

cf_id wasn't in the Fields list on the Basic tab and there was a . instead of a , on the Data Displayer list.

Bob

I did not understand where was the mistake, but thank you very very much

Max

why the cf_id of my database are not sequential?

Hi pennesw,

Perhaps you haven't specified an Order?

Bob

where it determines the order?
Thanks
Max

Hi Max,

The Order Fields box decides the order of the display.

Bob

[attachment=1]13-02-2013 10-42-33.png[/attachment]
[attachment=0]13-02-2013 10-42-01.png[/attachment]

The numbers in the first column are not displayed sequentially, how do I view them from number 1 to number 100?
and because the numbering in the first column starts with the number 12?

Hi Max,

The cf_id is the primary key of the table. If it starts at 12 then probably some rows of test data have been deleted. You may be able to reset the count using MySQL, check the MySQL documents to see if that is possible.

Bob

Maybe now I understand, in the testing phase of the site I did some tests on the database which I then deleted

Thanks
Max