Search found 12 matches

by GeraintR
Fri May 16, 2025 12:31 pm
Forum: Off Topic Section
Topic: Placing Javascript within the Page HTML
Replies: 4
Views: 119

Re: Placing Javascript within the Page HTML

Thank you both for your prompt replies. I see on the advice page about code placement says that scripts should not be put within the body tag. The W3schools tutorial that I've been using does just that, putting a function within the body tag, which was what I was originally trying to do. I shall ...
by GeraintR
Thu May 15, 2025 8:44 pm
Forum: Off Topic Section
Topic: Placing Javascript within the Page HTML
Replies: 4
Views: 119

Placing Javascript within the Page HTML

I need to identify the selected row of a datatable or dropdown, and store it as session data to be used in another page. I have been working through a Javascript tutorial to develop my very basic JS skills, and have even failed to get a JS script to change an HTML heading because I cannot place the ...
by GeraintR
Wed May 07, 2025 5:31 pm
Forum: Forms
Topic: Error: Unknown column 'ID' in 'where clause'
Replies: 10
Views: 2470

Re: Error: Unknown column 'ID' in 'where clause'

Thank you; issue resolved. I clearly misunderstood how the key auto generation was programmed :
by GeraintR
Tue May 06, 2025 5:13 pm
Forum: Forms
Topic: Error: Unknown column 'ID' in 'where clause'
Replies: 10
Views: 2470

Re: Error: Unknown column 'ID' in 'where clause'

I forgot to mention that the id value in the success email is always blank, even though the other user input fields are there
by GeraintR
Tue May 06, 2025 5:11 pm
Forum: Forms
Topic: Error: Unknown column 'ID' in 'where clause'
Replies: 10
Views: 2470

Re: Error: Unknown column 'ID' in 'where clause'

The id=0 is posted to the table. I've dumped the first two rows of the new table I created. The id values are 0 and 2.

INSERT INTO `swift_results` (`id`, `Editbox2`, `Editbox3`, `DATESTAMP`, `TIME`, `IP`, `BROWSER`, `FORMID`, `SUBMIT_SWIFT_RESULTS`) VALUES
(0, 0, '', '2025-05-06', '15:56:52', '2a00 ...
by GeraintR
Tue May 06, 2025 3:17 pm
Forum: Forms
Topic: Error: Unknown column 'ID' in 'where clause'
Replies: 10
Views: 2470

Re: Error: Unknown column 'ID' in 'where clause'

Hi,

I've contacted the IONOS helpdesk and they can't shed any light on the issue. I created a new form and a new table, with just three fields on it and I've got the same result. Seemingly, when I submit the first record to the table, the value '0' is posted to the id column, and only the system ...
by GeraintR
Tue May 06, 2025 10:53 am
Forum: Forms
Topic: Error: Unknown column 'ID' in 'where clause'
Replies: 10
Views: 2470

Re: Error: Unknown column 'ID' in 'where clause'

Hi Pablo, thanks for your responses.

I've altered the primary key name to 'id'. I actually created a new column in the database having deleted all the rows. The 'ID' error message has disappeared, but I now get a 'Duplicate entry '0' for Primary Key' error. The TIME/URL data that's created by the ...
by GeraintR
Mon May 05, 2025 8:29 pm
Forum: Forms
Topic: Error: Unknown column 'ID' in 'where clause'
Replies: 10
Views: 2470

Error: Unknown column 'ID' in 'where clause'

I have verified that the object names I've given to the various editboxes on my form exactly match the column names in the database table I've created, but the data from my form input fields is not being posted to the database. Individual records are being created showing the system generated ...
by GeraintR
Tue Mar 25, 2025 11:47 am
Forum: General Questions
Topic: SQLCRUD and login using embedded database
Replies: 6
Views: 1028

Re: SQLCRUD and login using embedded database

Thanks Pablo, works perfectly, and gives me an insight into how I can resolve these php conflict problems in the future

Geraint
by GeraintR
Mon Mar 24, 2025 5:09 pm
Forum: General Questions
Topic: SQLCRUD and login using embedded database
Replies: 6
Views: 1028

Re: SQLCRUD and login using embedded database

Thanks for the suggestions, I went with WWbman and added the code to turn off NOTICES. It didn't work, but I assume that's because the auto-generated code (shown below) that I didn't include in my original post has a line that presumably overrides it by setting error_reporting to E_ALL. I don't ...
by GeraintR
Mon Mar 24, 2025 12:42 pm
Forum: General Questions
Topic: SQLCRUD and login using embedded database
Replies: 6
Views: 1028

SQLCRUD and login using embedded database

Hi,

Am I correct to assume that I cannot use both SQLCRUD and a 'Protect page' extension on the same page without amending the system generated code? I have created a database to be accessed by a small number of members, and I'm using an embedded database to control access. I have a separate login ...
by GeraintR
Sat Mar 15, 2025 6:24 pm
Forum: Forms
Topic: Editing the form wizard associated with the carousel
Replies: 1
Views: 411

Editing the form wizard associated with the carousel

I've spent a loooooong time trying to update a csv file from a form-enabled carousel. In spite of the tip about editing the csv path via the form properties, the Advanced properties path box at the end of the wizard seems uneditable, and only generates a relative path. I seem to need an absolute ...