Sloppy Designs
GitHubGitHub (opens in a new tab)DiscordDiscord (opens in a new tab)
  • Tebex
    (opens in a new tab)
  • About

  • Bridge
    • Installation
    • Core
      • Insert
      • Prepare
      • Query
      • Scalar
      • Single
      • Transaction
      • Update
      • Player
      • Client
      • Server
      • Locale
      • Client
      • Server
      • Item
    • Target
      • Options
      • BoxZone
      • PolyZone
      • SphereZone
      • CZone
      • PolyZone
      • BoxZone
      • SphereZone
      • Client
      • Server
      • Shared
  • Unit
  • SD-Notify
    • Types
    • Positions
    • Config
    • Framework
  • SD-Merchants
      • Paths
      • Merchants
      • Config
      • Shop
      • Blips
      • Currency
      • Items
    • SD-Paycheck
      • Index
    • SD-Menu
      • Config
      • Menu
      • Input
    • SD-KeyPad
  • Tebex
    (opens in a new tab)
  • About

  • Bridge
    • Installation
    • Core
      • Insert
      • Prepare
      • Query
      • Scalar
      • Single
      • Transaction
      • Update
      • Player
      • Client
      • Server
      • Locale
      • Client
      • Server
      • Item
    • Target
      • Options
      • BoxZone
      • PolyZone
      • SphereZone
      • CZone
      • PolyZone
      • BoxZone
      • SphereZone
      • Client
      • Server
      • Shared
  • Unit
  • SD-Notify
    • Types
    • Positions
    • Config
    • Framework
  • SD-Merchants
      • Paths
      • Merchants
      • Config
      • Shop
      • Blips
      • Currency
      • Items
    • SD-Paycheck
      • Index
    • SD-Menu
      • Config
      • Menu
      • Input
    • SD-KeyPad
Question? Give us feedback → (opens in a new tab)Edit this page
Bridge
Database
Scalar

Scalar

Returns the first column for a single row

Database.scalar(query, data, cb)
  • query: string
  • data?: table
  • cb?: function(result)

returns: any

local column1 = Database.scalar('SELECT `column1` FROM `table` WHERE `column3` = ? LIMIT 1' , { 'value1' })
 
print(column1)

2024 © Sloppy Designs