select

Custom Column on my select statement

Hi Guys, I'm still new to SQL (Oracle).. Basically on a table I'm selecting from, there is a time stamp, and some are valid stamps and some are not (stored on a time stamp table).. I have a function I can use in 'where' clauses to return only the valid or invalid ones. But sometimes I need to see all the records with an additional colu...

Find is a business is open: MySQL hours calculation.

I have a list of business stored in a locations table, and stored in that table are hours the business opens and closes: location `mon_1_open` `mon_1_closed` `tue_1_open` `tue_1_closed` `wed_1_open` `wed_1_closed` ect... I store the times in full hours and minutes, so say a business is open from 9:00AM to 5:30PM on monday.. mon_1_ope...

Mysql - Simple select query returns dublicate values?

The title says it all. This is how the query looks like: (simplified) SELECT * FROM posts WHERE user='37' ORDER BY date DESC I currently only ave one row in that table, but still for some reason it returns two rows that are exactly the same. At first i thought i messed up with the loop, but i tried printing the returned array out with...

How do I return true or false if multiple columns equal a certain value in MySQL query?

I have a single DB table (MySQL) which I am running a simple SELECT on. In this table I have 3 fields which contain 3 possible values each. In each case the values are identical ('none','online','physical'). I want to return in my result a true or false value for an alias if any one of these fields are not set to 'none'. I can easily ev...

Add a select box on the right admin filter in django - how to do ?

Hi, I want to used select box on my admin filter on django. FOr now django used list_filter on the admin model, and add a list of all data list_filter = ('data') and show : filter data - data1 - data2 - ... but if i v thousand data, i see a big list drop down my admin page... Is it possible to show a select box with the lis...

Update Table with a "Select query" with a where clause

I want to Achieve the following: Current State of table (my_table) id totalX totalY totalZ --------- -------------- -------------- -------------- 9 34 334 0 10 6 56 ...

Limit Initial width of select list

I have a select list, where some clients have entered insanely long options for them, which breaks the design. I'm wondering if there is a way to set a fixed width on the select widget, but still have the drop down menu it produces still be wide enough to display all of the option. ...

How to set up a proper select form..

I am trying to draw the end result being that @gallery = whatever i choose in my select - form_for :gallery do |f| .grid_6.hr_dots.clear .exist_gal .grid_5 %label 2. Or add to an existing Gallery .clear .grid_4 = select @gallery, :gallery, options_for_select(@galleries.collect { |g...

how to pass a value of table to a variable of c++ using select in mysql++

How to select a value from a table and store in a variable in my sql++ e.g select name from employee; write this query in c++ and then store the name in variable e_name ...

Problem using mysql++ library

I've read the tutorial at, and I generally get how that works: http://tangentsoft.net/mysql++/doc/html/userman/tutorial.html#simple I am trying to build this mysql++ code, and I'm getting an error: std::ostringstream query3; query3<<"select pipe_id from pipe where version_id='"<<id<<"'"; std::storeQueryResult ares=query3.store(); for(...

I was trying to select rows using mysql++

Here is my code int main(int argc,char *argv[]) { mysql_init(&mysql); connection = mysql_real_connect(&mysql,.............,"3306",0); if (connection == NULL) { cout << mysql_error(&mysql); return 1; } else { int id=1; mysqlpp::Query query=connection.query("select * from pipe"); //query3<<"select pipe_id from pipe w...

cfselect problem

Hi, I theory seems to be the answer to the pre populated selectbox issue. <cfselect name = "regions" query = "getRegions" selected="10" value="id" display="name" ></cfselect> this is what it outouts <option value="8">Dumfries & Galloway</option> <option value="9">Dundee City</option> <option value="10" selected="selected">East Ayr...

Entity Framework select from link table with list

Using the following database table structure: Order Table: OrderId OrderName OrderItem Table: OrderId ItemId Item Table: ItemId ItemName I have an 'Order' entity that has an 'Items' collection. What I need to do is return all orders that contain certain items. Example: All orders with items with id: 1, 4 and 5 (I don't care if it ha...

MySQL Select by random.

I have a list of items for businesses in a database: listings `id` `location` `item` `status` So in the database I might have something like: 19 Loc A Green Beans for $12 active 20 Loc B Two Gatoraids for $3 deactive 21 Loc A Ham for $2 per lb active 22 Loc A Pepsi 2 for $2 active 23 Loc C House pla...

select box styling - css/jquery

I've been hunting around to see if I can find a simple CSS or jQuery solution to achieve the following styling for a select box: There are various items on SO such as the one here, but these come close but the issue seems to be more with styling the "arrow" section of the select box. Many of the samples I've found style the whole of ...

How do I set the width of dijit.form.Select?

I have a programmatically generated dijit.form.Select. Unlike most other widgets, the Selects do not offer a resize method like dijit.resize({w: width, h: height}); I have not found a standardized way of setting the width of a select. This is quite bad because the autosizing makes Dialogs "explode" on long select values. Is there a s...

How to make <option>s of <select> show or hide using javascript?

I want to make the options of < select > show or hide by program(JS),is it possible ? it just like the interesting tags in the front page of StackOver Flow,when you type in some words,the drop list will expand and give you suggestions. ps.I know StackOver didn't use select in this case,anyway,just take it as an example. ...

What's wrong with this T-SQL select statement?

Hi, I'm reading an article from this website, but when i run the code that article provided, i get the error: Msg 102, Level 15, State 1, Line 16 Incorrect syntax near '.'. I double checked the syntax and can't find the cause of this error. The code is as follows, formatted by SQL Prompt. Anybody can help me with it? Great thanks. ...

Why is there one of my select options that put nothing in the query string at form submission?

This is my html: <select name="results"> <option value="0">Vis alle</option> <option value="10">10 resultater per side</option> <option value="20">20 resultater per side</option> <option value="30">30 resultater per side</option> <option value="40">40 resultater per side</option> <option value="50">50 resul...

How can show one Row in rows in which each row contain column name and the other conatin the value ?

I have a table that contain about 60 columns and if i write a select query in query analyser to get a row it show it and i must scroll to show data .. How can i get one row in which it shows as 60 row, each row contain 2 columns one for column name and other for value For example Select * from table where id = 1 in default it shown as ...