Stack Overflow
Stack Overflow

Questions tagged [offset]

The relational position of an entity, when compared to another entity with fixed position. Typically used, for example, to define location within a file or byte buffer from which information should be read.

3019 questions
52
votes
4 answers

Pagination using MySQL LIMIT, OFFSET

I have some code that LIMITs data to display only 4 items per page. The column I'm using has about 20-30 items, so I need to make those spread out across the pages. On the first page, I have: $result = mysqli_query($con,"SELECT * FROM menuitem…
ValleyDigital
  • 1,460
  • 4
  • 21
  • 37
50
votes
6 answers

How do I get the offset().top value of an element without using jQuery?

I'm programming a single-page application using the Angular framework. I'm new to it. I've read this guide to help me understand the fundamental differences between jQuery and Angular and I'd like to follow this guidance as much as possible and NOT…
saikofish
  • 1,744
  • 1
  • 15
  • 12
47
votes
4 answers

Get the offset of a hidden element

How can I get the coordinates of a hidden element? offset() doesn't support the use for hidden elements. Any hints?
Simon
  • 1,463
  • 6
  • 34
  • 46
47
votes
3 answers

PostgreSQL - repeating rows from LIMIT OFFSET

I noticed some repeating rows in a paginated recordset. When I run this query: SELECT "students".* FROM "students" ORDER BY "students"."status" asc LIMIT 3 OFFSET 0 I get: | id | name | status | | 1 | foo | active | | 12 | alice…
keewooi
  • 952
  • 2
  • 9
  • 10
43
votes
2 answers

Missalignment with inline-block (other elements pushed down)

I'm trying to align small boxes in a row. These boxes have something like 2 elements in each. In some cases, the first element is so "much" text, that it splits into 2 lines. If this happens, all other blocks in this special line are shown…
simon
  • 3,378
  • 2
  • 22
  • 32
39
votes
7 answers

How to get data from old offset point in Kafka?

I am using zookeeper to get data from kafka. And here I always get data from last offset point. Is there any way to specify the time of offset to get old data? There is one option autooffset.reset. It accepts smallest or largest. Can someone please…
Sourabh
  • 680
  • 3
  • 8
  • 18
38
votes
4 answers

Internet Explorer box model - what is offset?

I am trying to adapt a site to support IE 7. I have a few elements, however, which are being offset to the right by 69px. I am testing in IE9, set to render the page as if it were IE7. When I turn on developer mode and inspect the element I notice…
zkwsk
  • 1,960
  • 4
  • 26
  • 34
38
votes
2 answers

How to find the element's x center coordinates and related window offset

i would like to retrieve the element offset starting from his own x center coordinates. how can i do it? Actually i can find the window offset of an element but it retrieves the coordinates from the border of the element like this: var _position =…
itsme
  • 48,972
  • 96
  • 224
  • 345
33
votes
2 answers

Kafka consumer offset max value?

I was googling and reading Kafka documentation but I couldn't find out the max value of a consumer offset and whether there is offset wraparound after max value. I understand offset is an Int64 value so max value is 0xFFFFFFFFFFFFFFFF. If there is…
rodolk
  • 5,606
  • 3
  • 28
  • 34
32
votes
1 answer

SQL (ORACLE): ORDER BY and LIMIT

I want do sorting by property ALL data in my db and ONLY AFTER that use LIMIT and OFFSET. Query like this: SELECT select_list FROM table_expression [ ORDER BY ... ] [ LIMIT { number | ALL } ] [ OFFSET number ] I know the sorting ends…
DraggonZ
  • 1,057
  • 1
  • 16
  • 22
32
votes
5 answers

Offset columns in Bootstrap

This is the idea of what I want to do:
…
sumguy
  • 321
  • 1
  • 3
  • 5
31
votes
2 answers

SQLite with skip (offset) only (not limit)

I am trying to query a sql lite database with only an offset and no limit. SELECT [Id], [Name], [IntValue], [IntNulableValue] FROM [Product] OFFSET 10 I can do an offset query when I have a limit however (LIMIT 10 OFFSET 10). Here is the error sql…
Paul Knopf
  • 9,568
  • 23
  • 77
  • 142
30
votes
4 answers

How does kafka consumer auto commit work?

I am reading this one: Automatic Commit The easiest way to commit offsets is to allow the consumer to do it for you. If you configure enable.auto.commit=true, then every five seconds the consumer will commit the largest offset your client…
gstackoverflow
  • 36,709
  • 117
  • 359
  • 710
30
votes
3 answers

How to get Kafka offsets for structured query for manual and reliable offset management?

Spark 2.2 introduced a Kafka's structured streaming source. As I understand, it's relying on HDFS checkpoint directory to store offsets and guarantee an "exactly-once" message delivery. But old docks (like…
dnaumenko
  • 591
  • 1
  • 4
  • 10
30
votes
2 answers

What is prevObject and why is my selector returning that?

I'm trying to obtain the top from an element but I'm getting this error, what does it mean and how do I get rid of it? $(".hover").offset().top >Uncaught TypeError: Cannot read property 'top' of undefined $(".hover") [div.hover, prevObject:…
shuji
  • 7,369
  • 7
  • 34
  • 49
1
2
3
…
99 100