TOPIC:

Record ID (2) 1 year 1 month ago #236602

  • Topic Author
  • jchermant
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 38
  • Thanks: 0
Yes, I put :

ALTER TABLE pea6v_facileforms_records AUTO_INCREMENT=20190000;

Regards

Please Log in or Create an account to join the conversation.

Record ID (2) 1 year 1 month ago #236604

  • MarioPuco's Avatar
  • MarioPuco
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 5958
  • Karma: 119
  • Thanks: 554
Hi,

I just tested it and it's working fine for me :
ALTER TABLE pea6v_facileforms_records AUTO_INCREMENT= 20190000



Regards,
Mario
Attachments:

Please Log in or Create an account to join the conversation.

Record ID (2) 1 year 1 month ago #236606

  • Topic Author
  • jchermant
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 38
  • Thanks: 0
Sorry,
I can not, how can I get the value of the ID? This would allow me to display it on the form with an added prefix ...
Thank you

Please Log in or Create an account to join the conversation.

Record ID (2) 1 year 1 month ago #236611

  • MarioPuco's Avatar
  • MarioPuco
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 5958
  • Karma: 119
  • Thanks: 554

Please Log in or Create an account to join the conversation.

Record ID (2) 1 year 1 month ago #236615

  • Topic Author
  • jchermant
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 38
  • Thanks: 0
I complete my message:
I created a hidden item. I placed in the value field this:
<? php $ db = JFactory :: getDBO (); $ db-> setQuery ("Select count (id) From pea6v__facileforms_records Where form = 20190000"); return $ db-> loadResult () + 1;?>
Here is the image of my database:

and here is the error displayed on the test site:

I do not see where there is an error.

Please Log in or Create an account to join the conversation.

Record ID (2) 1 year 1 month ago #236616

  • Topic Author
  • jchermant
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 38
  • Thanks: 0
I complete my message:
I created a hidden item. I placed in the value field this:
<? php $ db = JFactory :: getDBO (); $ db-> setQuery ("Select count (id) From pea6v__facileforms_records Where form = 20190000"); return $ db-> loadResult () + 1;?>
Here is the image of my database:

and here is the error displayed on the test site:

I do not see where there is an error.
Attachments:

Please Log in or Create an account to join the conversation.

Moderators: ForumSupport
Time to create page: 0.116 seconds

Summer Sale!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!