Re: Improve HAVING BY performance Programming Databases by Biiim … cause I import 10 million rows of 6 columns every week in less than 10 minutes and that is slow as… the query immensely `AND tbl.create_time > NOW() - INTERVAL 2 WEEK` (with an index on create_time) You've inspired me to… Re: This is me venting Community Center Meta DaniWeb by Dani …-for-the-earliest-possible-agi-deployment-scenario) an interview last week, and [Usman just published](https://www.daniweb.com/programming/computer… Re: Learning about AI Community Center by Dani … on Tuesday. I actually spent the first half of this week at an SEO conference where they made the announcement. Google… Re: Improve HAVING BY performance Programming Databases by Dani … here in the forums. Especially after you *just* posted [a week ago](https://www.daniweb.com/community-center/threads/541593/learning… Re: 88 Business-Growing Strategies Digital Media Digital Marketing by henrymorgan9522 A growth strategy is an organization's plan for overcoming current and future challenges to realize its goals for expansion. Examples of growth strategy goals include increasing market share and revenue, acquiring assets, and improving the organization's products or services. Re: How to disable the automatic swipe effect on the product page? Programming Web Development by Read a Book Anyone can help on this problem? Re: How to disable the automatic swipe effect on the product page? Programming Web Development by kimnancy I recommend checking the lightgallery documentation or reaching out to their support forum for assistance with disabling the automatic swipe effect on your product page. It might provide you with specific guidance on the code modification you're looking for. Re: How to disable the automatic swipe effect on the product page? Programming Web Development by Read a Book @kimnancy I tried contacting them for over 2 weeks... Their customer support is non existent P.S i still have the same problem... i still cannot disable the auto swiping effect... Tried to learn the lightgallery docs. but cant find relevant info Re: How to disable the automatic swipe effect on the product page? Programming Web Development by rproffitt This is not an offer of edits or support. slideDelay at https://www.lightgalleryjs.com/docs/settings/ looks like something I'd look to add or change. Sometimes website owners don't code so they end up a little frustrated. Re: How to disable the automatic swipe effect on the product page? Programming Web Development by Read a Book I saw that the `slideDelay` is already set to 0. I uploaded the full code from the file `lightgallery.min.js` here is the pastebin link to it https://pastebin.com/v4qKbwVd `https://www.kupisi.mk/vendor/lightgallery/lightgallery.min.js` There are three files in the lightgallery folder `lightgallery.min.js` `lightgallery.umd.js` `… Re: How to disable the automatic swipe effect on the product page? Programming Web Development by Read a Book @rproffitt I tried it with various higher numbers than 0 and it did no helped... How can this be so big problem i don't understand :/ The products with videos in them are hurting my SEO... ![Screenshot_2024-03-21_093154.png](https://static.daniweb.com/attachments/4/b8ebec361fed813b05ae54827e38e9c6.png) Re: How to disable the automatic swipe effect on the product page? Programming Web Development by Dani Hello, Google Search Console is showing that vidceo is not the main content of the page, because I don't see any video on [this page](https://www.kupisi.mk/product/index.php?mainCategory=%D0%B7%D0%B0-%D0%B4%D0%BE%D0%BC%D0%B0&productName=%D1%83%D0%BD%D0%B8%D0%B2%D0%B5%D1%80%D0%B7%D0%B0%D0%BB%D0%BD%D0%BE-%D0%BF%D0%B0%D0%BC%D0%B5%D1%82%D0%BD%D0… Re: How to disable the automatic swipe effect on the product page? Programming Web Development by Read a Book WOW finally solved! Thank you so much DANI !! Removing the autoplay from the `// Product Gallery Swiper1 ==` solved the problem! Thank you so much! Here is a product page with a video https://www.kupisi.mk/product/за-дома/глава-за-туш-со-филтер-за-прочистување-вода/41 Re: How to disable the automatic swipe effect on the product page? Programming Web Development by Dani Glad you were able to get it working. I am seeing the product page with a video you're referring to. The video does not autoplay. Are you wanting the video to autoplay? (I don't think it should. It's a bad user experience.) Is Google not considering these pages as having video content? Re: Week Number Programming Databases by JukesK so.. SELECT WEEK(Date,0) As 'Week Number)', WEEK('2012-04-02',0) as 'april', sum(WEEK(Date,0) - WEEK('2012-04-02',0))… As 'Fiscal' FROM qc_data Returns Week Number||april||Fiscal 43… this weeks calander week is 43 but the financial week according to the company would be week 30!! Cheers Pritaeas… Week function help Programming Databases by BenK … weeknumbers according to ISO. This means 1-1-2006 is week 53. Now I created a function: [MS SQL] CREATE FUNCTION… dbo.WOY ( @Date DATETIME ) RETURNS SMALLINT AS BEGIN DECLARE @WEEK SMALLINT IF DATEPART(dw, CAST('1-1-' + CAST(DATEPART(YYYY… Week Number Programming Databases by JukesK …, 0) but that shows 1-1-2012 as week 0 Eg; qc_data.date holds the date a qc inspection … place. if i want to show that the first full week in April this year (2 april 2012 - 8 april 2012…) as week 1 ie Week||Date Range||Equipment ID||Result 1||2 april 2012… Re: Week Number Programming Databases by JukesK Thanks for the quick response and please forgive me for being a noob. I dont understand how the mode works... as i understand it, mode returns a week number and allows you to start the week with monday or sunday, but how can i offset it to start at the first full week in april this year? Re: Week Number Programming Databases by pritaeas `mode` only specifies how the week number is calculated. It says so in the first paragraph. Subtract from a date's WEEK value the WEEK value for April 2nd and add one. Re: Week Number Programming Databases by pritaeas [Here](http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_week) is what mode does. Why don't you calculate the week for your april date, and use it to shift the values returned by `WEEK()`. Re: Week function help Programming Databases by extofer I tried your function: PRINT dbo.WOY(01/01/2006) I got = 1 What do you mean set the datefirst to 1. Are you implying that 1-1-2006 = week 1?? week from given year Programming Software Development by sharma_vivek82 …quot;" will return all the week from selected year """ import datetime WEEK = {'MONDAY':0,'TUESDAY':1,'…':11,'DECEMBER':12} year=int(year) month= MONTH['JANUARY'] day=WEEK['MONDAY'] dt = datetime.date(year,month,1) dow_lst = []… Week Scheduler in C#.. Programming Software Development by bharathi_n_r Hi all, I am fed up of doing this week scheduler for my project...i am trying and trying but … can schedule movies for a particular day and for that week....The problem i am facing is that i want to… display the Date and Day of that week in Seven labels..If the user clicks on label Friday… Re: Week Scheduler in C#.. Programming Software Development by bharathi_n_r ….in[/COLOR].You will see the movies scheduled for the week..I want it in that way dude....any solution.... week in year....calculation Programming Web Development by nemo … in real life by looking up a calender that shows week of the year....how do we do it programming. we… Re: Retrieving data from the current week Programming Web Development by diafol week >= ... Re: Week's Activity in Rankings Community Center Meta DaniWeb by Dani … it worthwhile. Therefore, I had to replace all-time with week-long to make the MySQL table scan a bit more… Re: Week's Activity in Rankings Community Center Meta DaniWeb by diafol … one. :) Still, I don't see the point of the week list AND the daily list - what about getting rid of… Re: increment date by week Programming Web Development by Walkere … $all_weeks[53] is the last partial week of the year $all_weeks = array(); for ($week = 0; $week <= 52; $week += $increment) { $week_data = array…(); $week_data['start'] = strtotime("+$week weeks", $startdate); $… increment date by week Programming Web Development by assgar …to determine the start and end dates and the week number of the year. If you can suggest another… $start_date = "2008-02-01"; $nw = ($week number * $week cycle) + 1;//+ 1 to be in the next range $next_start… = date("Y-m-d",strtotime("+$nw week", $start_date)); $next_end = date('Y-m-d',strtotime(&…