Record ID (2)

  • jchermant
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

jchermant replied the topic: Record ID (2)

Yes, I put :

ALTER TABLE pea6v_facileforms_records AUTO_INCREMENT=20190000;

Regards
#236602
  • Posts: 5737
  • Karma: 118
  • Thank you received: 530

MarioPuco replied the topic: Record ID (2)

Hi,

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



Regards,
Mario

Satisfied with our Support ?
PayPal Tip
===============================================
Need to renew Pro Support?
Buy Here!
===============================================
Satisfied?
Consider a membership!
===============================================
Like us on Facebook
===============================================
#236604
Attachments:
  • jchermant
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

jchermant replied the topic: Record ID (2)

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
#236606
  • Posts: 5737
  • Karma: 118
  • Thank you received: 530

MarioPuco replied the topic: Record ID (2)

Hi,

Are you reffering to this maybe ? crosstec.org/en/forums/15-usage/94994-re....html?start=6#236569

Regards,
Mario

Satisfied with our Support ?
PayPal Tip
===============================================
Need to renew Pro Support?
Buy Here!
===============================================
Satisfied?
Consider a membership!
===============================================
Like us on Facebook
===============================================
#236611
  • jchermant
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

jchermant replied the topic: Record ID (2)

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.
#236615
  • jchermant
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 37
  • Thank you received: 0

jchermant replied the topic: Record ID (2)

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.
#236616
Attachments:
Moderators: ForumSupporttomeperica
Time to create page: 0.439 seconds

Summer Sale!

50% discount on all of our extension subscription plans & templates!

Get Your Subscription Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99 for just 49! (Summer Sale)

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

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!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here