Tagged Questions

DO NOT USE THIS TAG! In most cases, you just want the [[sql]] tag instead. See http://meta.stackoverflow.com/questions/183419/kill-the-query-tag.

learn more… | top users | synonyms (3)

0
votes
2answers
23 views

Query is taking too much time

I want to take your ideas regarding the below query: select a.expense_code, a.expense_date, a.expense_supplier_code, b.supplier_name, a.expense_discount, a.expense_payment_method, ...
0
votes
0answers
6 views

Dynamic Query in Stored procedure of mysql call giving error as Truncated Incorrect DOUBLE value

this is Procedure: delimiter $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `SampleSP`(IN uname VARCHAR(50),OUT uid VARCHAR(50)) BEGIN DECLARE sqlcmd VARCHAR(500); set sqlcmd = 'SELECT userid into ...
0
votes
0answers
5 views

GqlQuery returns random results

I'm writing a quite simple web application based on Google's Application Engine. It's the first time I'm working with Python and Google's datastore. The application should display some questions on ...
0
votes
0answers
7 views

JPA using multiple database schemas at runtime dynamically

how can I set schema in run time ? I want run a name query in more than one database and aggregate their answers. for example run this query in db1 and db2 : SELECT CUSTOMER FROM CUSTOMER CUS WHERE ...
-1
votes
1answer
22 views

Joining and Counting from MYSQL Table

So I have 2 tables in my db called users and map. The users has an ID assigned to a user, this ID is captured into the map table as capture_id when they input a marker. How can I tell how many places ...
0
votes
0answers
15 views

The active result for the query contains no fields

I am getting the following error: The active result for the query contains no fields Below is my code <?php session_start(); include 'dbconnect_three.php'; include 'dbconnect.php'; include ...
-1
votes
2answers
15 views

SELECT in mysql using column number instead of name

Is there any way to do something like : SELECT * FROM TABLE WHERE COLUMN_NUMBER = 1; ?
0
votes
2answers
18 views

Codeigniter Active Record / MySQL Join Query - How to Return Results if one of the Table Rows is Not Present

I have the following query: $this->db ->select('SQL_CALC_FOUND_ROWS null as rows ,table1.* ,table2.* ,table3.*', FALSE) ->from('table1') ...
0
votes
1answer
21 views

PHP changing timestamp format

So I tried to convert a time string to "X seconds ago" and stucked with this issue: while($row = mysql_fetch_array($result)) <a href="#Profile"><class="profilep" id="postp" /></a> ...
1
vote
1answer
30 views

Can anyone help me resolve this db query error?

On execution, I get an Error message thus: There was an error parsing the query. [ Token line number = 1,Token line offset = 116, Token in error = No ] Description: An unhandled exception occurred ...
1
vote
2answers
12 views

MySQL Indexes and possible_keys

I ran an EXPLAIN statement on one of my common queries I run, and I am curious why my "possible_keys" only match 2/3 of my indexed fields. Is this because im using a LIKE clause? Here is a link to ...
0
votes
0answers
16 views

Singling Out One Item of Each Type In A MYSQL query

MY APOLOGY I have seen a couple questions very similar to mine, but my brain is struggling applying the answer to my situation. I apologize for making what I am sure to some will seem like a repeat ...
2
votes
1answer
25 views

Media Queries not working properly after Javascript alters element CSS

any idea why in the example below, media queries stops changing the height of the menu bar after it's been changed by js? (make window small and click on the arrow to expand the mini menu). Do I need ...
1
vote
3answers
26 views

mysql returning duplicates on JOIN

i have two tables in a database. The table clients looks like this: ---------------------------- |id | name | age | gender | |--------------------------- |1 | CL1 | 22 | M | |2 | CL2 | 23 ...
0
votes
0answers
6 views

SA:MP Query Api - Fetching playerlist

Hello :) I have problem with my PHP code related to SampQueryAPI.php. I've tryied to fetch playerlist with this code <php> $aPlayers = $query->getDetailedPlayers(); foreach ($aPlayers as ...

1 2 3 4 5 … 2072
15 30 50 per page