Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Search function not working
(1 viewing) (1) Guest
Go to bottomPage: 1234
TOPIC: Search function not working
#18222
Re:Search function not working 12 Years, 10 Months ago Karma: 0
Something in the programming is now messing up my dates. They no longer match what is in the table. An example:

1885-05-24 is now displayed on my webpage as 13/12/1901

www.hafdal.dk/index.php/kirkegarde/lysabild-kirkegard
The administrator has disabled public write access.
 
#18223
Re:Search function not working 12 Years, 10 Months ago Karma: 0
it's weird - this only happens with a few dates. Otherwise everything is fine.
The administrator has disabled public write access.
 
#18227
Re:Search function not working 12 Years, 10 Months ago Karma: 748
Just install new version of the module over installed one through standard Joomla! installation page that upgrade the extension.

About incorrect date, we will investigate the problem and report about results soon.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#18236
Re:Search function not working 12 Years, 10 Months ago Karma: 0
thanks!
The administrator has disabled public write access.
 
#18276
Re:Search function not working 12 Years, 10 Months ago Karma: 748
You can format date in SQL query. For example if you want to format values of "created" field from "#__content" table, use the next SQL query:

Code:


SELECT
 DATE_FORMAT(created, '%d/%m/%Y') AS created
FROM
 #__content



Regards,
ARI Soft
The administrator has disabled public write access.
 
#18280
Re:Search function not working 12 Years, 10 Months ago Karma: 0
Great thanks! Where should I put that in my query (sorry for the stupid questions, I'm new to SQL)? Can I put it directly after my first SQL query like this:

Code:
------------------------------
SELECT Kшn, Fornavn, Efternavn, Pigenavn, Fшdselsdato, Fшdested, Dшdsdato, Dшdssted, Bemжrkning, Billede
FROM `tblGravsteder`
WHERE 1
LIMIT 0 , 30


SELECT DATE_FORMAT( created, '%d/%m/%Y' ) AS created
FROM tblGravsteder
LIMIT 0 , 30
------------------------
The administrator has disabled public write access.
 
Go to topPage: 1234