sql

  1. K

    Where is the bottleneck / what are the gotchas when selecting records from a remote (linked) SQL server?

    I'm in a satellite office that needs to pull some data from our main office for display on our intranet. We use MS SQL Server in both locations and we're planning to create a linked server in our satellite office pointing to the main office. The connection between the two is a VPN tunnel I...
  2. P

    KnexJS raw query in migration

    I have a problem with the following migration in KnexJS, working with PostgreSQL: exports.up = (knex) => { knex.raw('CREATE EXTENSION IF NOT EXISTS "uuid-ossp"'); return knex.schema.createTable('car_brands', (table) => {...
  3. J

    NodeJS: Query Database Command with Loop condition

    I want to run a PostgreSQL database query command with condition OR to filter object by an ID Array. var id_arr = [1, 2, 3] Result I want to get: SELECT * FROM auth_user WHERE id = 1 OR id = 2 OR id = 3 I tried but it gets syntax error: var querydb = `SELECT * FROM auth_user WHERE ` + for...
  4. J

    Selecting Data from data base SQL

    I am selecting a data from the database, I can't seem to find the error $check = DB::select("select * from accounts where username = ".$data['username']); ERROR STATED:
  5. T

    I get a empty result in select2 with php “select(sql)”

    I want to search with select 2 in page wordpress and i want to get in result only private page, I get a number of li correct "14 li" and this what i have in my db but li foreach is empty why? $post_id = $wpdb->get_results("SELECT `ID`,`post_title` FROM $wpdb->posts WHERE `post_type` = 'page'...
  6. Y

    Wordpress CheckPassword and Warning: substr()

    I'm still newbie for wordpress, I'm just trying to check password (I'm sure I missed something somewhere but I'm feeling lost and couldn't focus): $user = $_POST['user_name']; $pass = $_POST['user_password']; $wp_hasher = new PasswordHash(8, TRUE); $result=$wpdb->get_results("SELECT * FROM...
Top