Search found 12 matches
- 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 ...
- 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 ...
- 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 :
- 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
- 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 ...
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 ...
- 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 ...
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 ...
- 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 ...
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 ...
- 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 ...
- 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
Geraint
- 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 ...
- 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 ...
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 ...
- 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 ...