Search found 69 matches

by trevorm
Sat May 23, 2020 1:06 pm
Forum: General Questions
Topic: Display single MySQL record
Replies: 5
Views: 1732

Display single MySQL record

Hi, I have a need to search a MySQL DB and display a single record in a form style rather than a table. i.e. display fields from a MySQL record where the fields of a single record are placed in a form. Is this possible or this there an extension that enables this? I am not a programmer so I need a, ...
by trevorm
Wed May 13, 2020 2:04 pm
Forum: General Questions
Topic: Bootstrap Table
Replies: 2
Views: 656

Re: Bootstrap Table

Ah OK

I'll find away round it. Thanks
by trevorm
Wed May 13, 2020 10:29 am
Forum: General Questions
Topic: Bootstrap Table
Replies: 2
Views: 656

Bootstrap Table

Hello I have a Bootstrap table in one of my pages which displays testimonials, which is fine. However, the column widths are not as I would like. The Name and Date columns are very narrow and the Testimonial text is very wide resulting an ugly arrangement. I can't see in the Object html where the ta...
by trevorm
Mon May 04, 2020 7:59 am
Forum: Forms
Topic: Printing forms
Replies: 5
Views: 3540

Re: Printing forms

Hello MGD4Me
Thanks for you assistance.
I did follow Pablos link but became quickly overwhelmed I’m afraid, as I’m not a programmer.
I spent several hours yesterday looking into it. I’m amazed there is not an extension - ha ho.

Thanks again
by trevorm
Sun May 03, 2020 11:19 am
Forum: Forms
Topic: Printing forms
Replies: 5
Views: 3540

Re: Printing forms

Do you know of one or where I might find out about it?
by trevorm
Sun May 03, 2020 10:35 am
Forum: Forms
Topic: Printing forms
Replies: 5
Views: 3540

Printing forms

Is there a way to print forms to pdf? I would like to extract data from an MySQL DB using say, the extension "MySQL Connector" but could be any extension you suggest and thenI would like to email the pdf. Ideally this would be done in the one web page. Alternatively, once the data is extra...
by trevorm
Sat May 02, 2020 1:44 pm
Forum: General Questions
Topic: Login Tools - User Role
Replies: 15
Views: 1718

Re: Login Tools - User Role

Hi Pablo

I deleted the DB and remade and use the Make DB script to create the fields. The Admin is now working showing the Role field as well as all of he other fields. Thanks
The login page isn’t working now but hopefully I can sort that out.
Thanks for your help
by trevorm
Sat May 02, 2020 7:27 am
Forum: General Questions
Topic: Login Tools - User Role
Replies: 15
Views: 1718

Re: Login Tools - User Role

Role field etc are there! Will they be different if done in version 8?
by trevorm
Fri May 01, 2020 10:47 pm
Forum: General Questions
Topic: Login Tools - User Role
Replies: 15
Views: 1718

Re: Login Tools - User Role

Ok I have changed version to 14 and this prevents the log in forms displaying beyond the actual login. I have read the help but I see nothing regarding version. I have complied with the other requirements as far as I can see. Having changed version is it necessary to delete the pages from the page m...
by trevorm
Fri May 01, 2020 4:12 pm
Forum: General Questions
Topic: Login Tools - User Role
Replies: 15
Views: 1718

Re: Login Tools - User Role

Just found it it is set to 8
by trevorm
Fri May 01, 2020 4:06 pm
Forum: General Questions
Topic: Login Tools - User Role
Replies: 15
Views: 1718

Re: Login Tools - User Role

Where do I find that out?
by trevorm
Fri May 01, 2020 3:48 pm
Forum: General Questions
Topic: Login Tools - User Role
Replies: 15
Views: 1718

Re: Login Tools - User Role

Yep - 15.4.0 - Mar 27th 2020 (Only just purchased it around that time) It says its the latest in check for updates
by trevorm
Fri May 01, 2020 3:03 pm
Forum: General Questions
Topic: Login Tools - User Role
Replies: 15
Views: 1718

Re: Login Tools - User Role

Sorry Pablo but I can assure you the Role field (nor the browse field) are not present in any of sign up. New User in admin or edit in Admin published pages.
by trevorm
Fri May 01, 2020 1:15 pm
Forum: General Questions
Topic: Login Tools - User Role
Replies: 15
Views: 1718

Re: Login Tools - User Role

Hi Pablo, I did not appreciate that user roles were optional. However as we have various areas of the site that only certain Users can access and which the Users vary from page to page, then user Roles offer that possibility of appropriate control. However, I have look again and I can't see any refe...
by trevorm
Fri May 01, 2020 8:17 am
Forum: General Questions
Topic: Login Tools - User Role
Replies: 15
Views: 1718

Login Tools - User Role

Hi, I cannot find anywhere in the notes or in the various setup dialogues of the LOGIN Tools where or how you assign User Roles to Users. I understand Roles are always needed as part of the system verification process on login. However, in my published site, the User Role field of the Login Admin to...
by trevorm
Thu Apr 30, 2020 5:06 pm
Forum: General Questions
Topic: Login Signup
Replies: 5
Views: 1132

Re: Login Signup

Pablo,

Thanks again for your help - My login is fully working now,

Trevorm
by trevorm
Thu Apr 30, 2020 2:32 pm
Forum: General Questions
Topic: Login Signup
Replies: 5
Views: 1132

Re: Login Signup

Thanks for the clear answers - that explains a lot.

Very impressed with the speed you respond by the way, thank you.
by trevorm
Thu Apr 30, 2020 2:16 pm
Forum: General Questions
Topic: Login Signup
Replies: 5
Views: 1132

Re: Login Signup

Ah OK |Does that mean that when a user logs in that encoded field is decoded to test password? I am having a few issues getting the login to work but I have not gone through your instructions fully yet. But can you just confirm that if no usernames or roles are added in the Protect Page tool that an...
by trevorm
Thu Apr 30, 2020 1:59 pm
Forum: General Questions
Topic: Login Signup
Replies: 5
Views: 1132

Login Signup

Hello, I am embarrassed to be back with another question in under 24 hours from the last one but can anyone explain why, when a user registering through the login signup tool enters a password (twice) yet the MySQL DB shows a completely different password made up of extensive alpha numeric component...
by trevorm
Wed Apr 29, 2020 8:00 pm
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

Re: ID fields in forms

Yes, I revisited the instructions of MySQL Connector - Version 1.2 after my last post and noted the options in the instructions, item 6. I will give this a try.

Could be getting somewhere now.

Thanks everyone.
by trevorm
Wed Apr 29, 2020 7:31 pm
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

Re: ID fields in forms

Hello, Thanks for your input you guys - I really appreciate it. I have had a look at MySQL Connector - Version 1.2. which I already have installed but it would appear from what I have read in the instructions that you cannot create a new record with it, you can only edit existing records. Am I under...
by trevorm
Wed Apr 29, 2020 4:51 pm
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

Re: ID fields in forms

I forgot to say the fields I don't want to use in the existing table do NOT have any data in them
by trevorm
Wed Apr 29, 2020 4:49 pm
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

Re: ID fields in forms

Hi Pablo, The good news is that I have created a new (different) table by setting the table name jn the form as one that does not exist in the database. to test it and that works. I let the system create the table. Therefore as you say is a structure issue. I had missed some fields off the form inte...
by trevorm
Wed Apr 29, 2020 12:39 pm
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

Re: ID fields in forms

Hi Pablo, Unfortunately the table does exist and has data in it, as it is a table that has been and still is in use by another web site which is to be replaced by this new site. Your MySQL CRUD extension works fine and I can edit and add records with no problem with the CRUD. However, I don’t want u...
by trevorm
Wed Apr 29, 2020 11:41 am
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

Re: ID fields in forms

OK Pablo, Not being an experienced coder does create some issue for me, some of which you have already helped me with and for that I am grateful. I am proceeding well with building my web site with WYSIWYG WB and I acknowledge my failure to fully read some of the instructions provided as you pointed...
by trevorm
Tue Apr 28, 2020 4:45 pm
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

Re: ID fields in forms

Thank you
by trevorm
Tue Apr 28, 2020 3:12 pm
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

Re: ID fields in forms

Hi

Thanks for for your reply Pablo.
What is a datestamp field? or is that just a field with that name to receive data from your built-in script?
by trevorm
Tue Apr 28, 2020 2:38 pm
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

Re: ID fields in forms

Further to my inquiry, I am getting the following error "Failed to insert data into table! Unknown column 'DATESTAMP' in 'field list'" displayed when trying to submit the form data to the database. I do not see a way to ensure the form fields save to the correct DB table fields - the form ...
by trevorm
Tue Apr 28, 2020 2:28 pm
Forum: General Questions
Topic: ID fields in forms
Replies: 19
Views: 20507

ID fields in forms

Hi

I am trying to create a form to add data to an existing Database table. The id field in the existing table is an auto incrementing primary key field. How do set this up in the WYSIWYG Web builder form to ensure that each new record has a new (incremented by 1) value?

Thanks
by trevorm
Tue Apr 07, 2020 4:37 pm
Forum: General Questions
Topic: Saving form data to and existing MySQL table
Replies: 2
Views: 736

Re: Saving form data to and existing MySQL table

Thanks - hoped that would be the case

Trevorm
by trevorm
Tue Apr 07, 2020 2:58 pm
Forum: General Questions
Topic: Saving form data to and existing MySQL table
Replies: 2
Views: 736

Saving form data to and existing MySQL table

Hi Please can anyone advise me that if a Mysql table and associated fields already exist, a Web Builder form will save to that existing table and fields without damaging existing data? The help file says it will create the table and fields and goes on to say there is no need to create the table and ...
by trevorm
Sun Apr 05, 2020 12:26 pm
Forum: Forms
Topic: Bootstrap Table
Replies: 15
Views: 5135

Re: Bootstrap Table

Pablo Just to keep the Forum up to date I would like to report you have solved all my issues with regard to presentation of MySQL data on the page by email. Thank you so much for your patience. Final issue with page not displaying although I had set the page to PHP extension before raising this issu...
by trevorm
Sun Apr 05, 2020 11:05 am
Forum: Forms
Topic: Bootstrap Table
Replies: 15
Views: 5135

Re: Bootstrap Table

HI Paplo, We are getting somewhere but a strange occurrence now ! I have republished the page with ID enabled in list view as you said. However, now I am getting file not found if the page is selected from the menu of the web site . The file is definitely there I can see in the server folder. Strang...
by trevorm
Sun Apr 05, 2020 10:05 am
Forum: Forms
Topic: Bootstrap Table
Replies: 15
Views: 5135

Re: Bootstrap Table

Thanks Pablo

I’ll sort that out and check error log if needs be.

Trevorm
by trevorm
Sun Apr 05, 2020 8:20 am
Forum: Forms
Topic: Bootstrap Table
Replies: 15
Views: 5135

Re: Bootstrap Table

Hi again Pablo, I have sent three images showing my settings to you via email at your website "info@" your website address as this is the only other contact I have for you acquired from you kindly supplying info about the software before purchase. I could not see how to send images via an ...
by trevorm
Sat Apr 04, 2020 6:58 pm
Forum: Forms
Topic: Bootstrap Table
Replies: 15
Views: 5135

Re: Bootstrap Table

Pablo, I do not think the extension is at fault - it is me.

WWBMan - No it does not say "No result" it says: " . $cell . "
by trevorm
Sat Apr 04, 2020 3:31 pm
Forum: Forms
Topic: Bootstrap Table
Replies: 15
Views: 5135

Re: Bootstrap Table

Thanks again for your help. I have checked the setting out again, the settings are not wrong. I am at a complete loss as to what I am doing wrong. I have also tried the MySQL Crud (including the ID) and get the same results. Clearly it is something I have or have not done. I am accessing the same da...
by trevorm
Sat Apr 04, 2020 12:10 pm
Forum: Forms
Topic: Bootstrap Table
Replies: 15
Views: 5135

Re: Bootstrap Table

Hi

Thank you very much for your prompt reply.

I can see where ID is called for in MySQL CRUD instructions but I cannot see it in either the instructions or in properties of the Bootstrap Table. Can you tel me where it is please?
by trevorm
Sat Apr 04, 2020 10:44 am
Forum: Forms
Topic: Bootstrap Table
Replies: 15
Views: 5135

Bootstrap Table

I am very new to WYSIWYG Web Builder (15) so please forgive my question if it is obvious to you. I am setting up a page to display a Bootstrap Table. The table page uses a Master Page When publishing online the form is appearing in the correct place with all the Master Page details but without any d...