|
|
stackoverflow.com
- 2012-03-31 13:15:49
- Similar
- Report/Block
i want to use case in sql statement where clause bt i ve an Problem as i want to create an where clause condition on the basis of some value and i want to set an not in clause values on the basis of it here is the query where am facing an issue WHERE CODE = 'x' and ID not in ( case when 'app'='A' then '570','592' when 'Q' t...
|
|
|
stackoverflow.com
- 2012-02-22 21:05:33
- Similar
- Report/Block
The "a.form" condition in the WHERE clause is not being met in the following query. That's regardless of whatever form that is used, for example, even if form=1 all students of economics in form 4 are displayed as result of the query. SELECT a.Form, c.AcademicYear, b.SubjectName, b.UserID, b.Password, c.
|
|
|
stackoverflow.com
- 2013-03-06 11:26:44
- Similar
- Report/Block
Please see below query: Update Employee Set AccountManagerId = a.AM_ID FROM Employee e INNER JOIN AccountManager a on e.Id = a.Id WHERE **Struggling to construct below part (which needs to be added to the where clause)** If a.Department is not null then [FOLLOWING NEEDS TO BE ADDED TO WHERE CLAUSE] (e.Department = a.department) Struggling...
|
|
|
|
stackoverflow.com
- 2012-02-24 16:53:53
- Similar
- Report/Block
In Visual Studio 2010, I have a windows forms application frmMain.cs with a ComboBox. From the form itself I can access its value with cmbxYear.SelectedValue. I also have a DataSet.xsd file to bind to an rdlc report to a TableAdapter to present view data. The TableAdapter has a SelectCommand that takes SQL code. I need to get the value o...
|
|
|
stackoverflow.com
- 2012-04-10 16:57:55
- Similar
- Report/Block
Dumb question time. Oracle 10g. Is it possible for a where clause to affect a join? I've got a query in the form of: select * from (select product, product_name from products p join product_serial ps on product.id = ps.id join product_data pd on pd.product_value = to_number(p.product_value)) product_result where product_name like '%protot...
|
|
|
stackoverflow.com
- 2012-03-10 05:10:16
- Similar
- Report/Block
I am trying to use this query in Postgres 9.1.3: WITH stops AS ( SELECT citation_id, rank() OVER (ORDER BY offense_timestamp, defendant_dl, offense_street_number, offense_street_name) AS stop FROM consistent.master WHERE citing_jurisdiction=1 UPDATE c...
|
|
|
thestudentroom.co.uk
- 2013-04-11 18:58:02
- Similar
- Report/Block
I am preparing for a moot, and my point as the junior appellant is that; 'barclays bank did not exclude liability by way of the exemption clause' So i am appealing that it did apply the exemption clause is - "the trustee shall not be liable for any loss or damage whatsoever that may occur with respect to the portfolio investments hereby s...
|
|
|
|
stackoverflow.com
- 2012-04-25 08:34:36
- Similar
- Report/Block
I have a select query in which I have joined a couple of tables say and both the tables have a field named STATUS which I don't need to fetch. In the where clause I need to add WHERE STATUS=1 and some more conditions. But somehow I just can't add the table name or table alias to the field in the where clause i.e. I can't use where T2.ST...
|
|
|
stackoverflow.com
- 2012-04-04 04:44:29
- Similar
- Report/Block
This question builds on the following question (s) Indexing : How do I construct my RavenDb static indexes for this document, given these requirements? Simple Where clause with paging : How to construct a proper WHERE clause with RavenDb The jist of the question is how do I code up a controller method for instance, that can accept N numbe...
|
|
|
stackoverflow.com
- 2012-02-27 21:00:13
- Similar
- Report/Block
I have an 8-digit TEXT field (called Code) and want to do a select "where Code mod 3 is 0". How do I write this where clause in ms-sql, in particular? I believe the query should be the same in other versions of SQL. Thanks.
|
|
|
stackoverflow.com
- 2013-02-23 14:07:34
- Similar
- Report/Block
I am making a Windows Forms application. I have a form. I want to open a new form at run time from the original form on a button click. And then close this new form (after 2,3 sec) programatically but from a thread other than gui main thread. Can anybody guide me how to do it ? Will the new form affect or hinder the things going on in t...
|
|
|
stackoverflow.com
- 2012-04-05 12:49:57
- Similar
- Report/Block
How can i use WHERE Clause to filter in the OVER clause? from the following data LoanID | Principal | Tenor | AmortizingPrincipal ---------------------------------------- 1 20000 1 5000 1 20000 2 5000 1 20000 3 5000 1 20000 4 5000 I need a fourth virtual co...
|
|
|
|
helifreak.com
- 2013-05-05 16:06:46
- Similar
- Report/Block
I ve only used the pc software maybe 3-4 times & bought the programmer box after finding my pc(vista) will not open certain file types to do firmware upgrades. I havent had any flight problems so im not too worried about upgradeing the firmware & i cant remember if i have 3.02 or 3.5. I did notice while going through all my settings in th...
|
|
|
stackoverflow.com
- 2012-06-04 14:36:26
- Similar
- Report/Block
I am working for one mysql db query performance improvement task and i faced below one query where the "where clause is 1=1". my question is, what is different in term of performance for executing time of below two db query Select * from Table1 where 1=1 Select * from Table1 nos of records : 159954 for table1 for one client nos of records...
|
|
|
stackoverflow.com
- 2013-02-06 12:44:54
- Similar
- Report/Block
I have a query that after execution shows: Name – LasName—City John – Doe –London John –Doe—Berlin Martin—Smith—Paris Is there anything I can do in the WHERE clause section in order to get just one John Doe, no matter the city? The query is humongous that’s why I’m not posting it in here. If there’s anything you think I can do, please, po...
|
|
|
stackoverflow.com
- 2012-03-16 09:21:19
- Similar
- Report/Block
I have problem with this SQL query: (SELECT tb1.id,tb1.bdate,tb1.jumpCard,tb1.public Image,tb1.lastlogin FROM users AS tb1, online AS tb2 WHERE tb1.valid='1' AND tb1.sex='female' AND tb1.looking_for='male' AND tb1.id = tb2.member_id ORDER BY tb1.publicImage) ORDER BY tb1.id DESC for some reason I'm getting: Table 'tb1' from one of the SELE...
|
|
|
stackoverflow.com
- 2012-04-13 14:09:32
- Similar
- Report/Block
I've created a WinService, unfortunately Win7 (and Vista) does not support Screen Capture from a service. I'm going to rewrite a program into something different than WinService, something that has no forms.. what will you suggest? Console Application has a console - I don't need any. WinForms app has a form - I don't need any. Is it poss...
|
|
|
stackoverflow.com
- 2010-10-15 18:55:10
- Similar
- Report/Block
I have a .NET powered website, that has a sign-up box form already. I'm using the JQuery dialog to popup a window, on which I also have a form. That form will not submit using a standard submit button. Nothing happens. I use the following Javascript to allow my main page signup form to work properly: <input onclick="this.form.action='...
|
|
|
|
stackoverflow.com
- 2012-06-07 00:16:50
- Similar
- Report/Block
I know that in oracle/mysql/sqlserver select statement you are not able to reference a column alias in the where clause because it is executed before the select , yet it works in sqlite3: sqlite> create table t (c1 text, c2 text); sqlite> insert into t values ("a1", "a2"); sqlite> insert into t values ("b1", "b2"); sqlite> s...
|
|
|
stackoverflow.com
- 2012-05-10 06:11:04
- Similar
- Report/Block
In my admin interface I have a listing of subdomains, which follow following logic: node-k1 node-k2 node-k3 node-k4 node-k5 node-k6 node-k7 node-k8 node-k9 node-k10 node-k11 These are stored in mysql. I need to list them in numeric order, however since I lack leading 0s after node-k , it orders them like so: node-k1 node-k10 node-k11 node...
|
|
|
badmintoncentral.com
- 2013-05-06 06:21:48
- Similar
- Report/Block
All equipment is only up for sale. No trades are welcome. My contact details is 90284635 1. Yonex Nanospeed 9900, 3UG5, 10/10 condition, $190 negotiable 2. Kumpoo Power Shot 3700 Middle, Red, 3UG5, 10/10 condition, $170 negotiable 3. Kumpoo Power Shot 3700 Bottom, Blue, 3uG5, 10/10 condition, $170 negotiable 4. X3 Cobra 300, 10/10 conditi...
|
|
|
|
dealsucker.com
- 2013-04-17 08:07:28
- Similar
- Report/Block
Part : OPTI755UC2D2332R Warranty: 90 Days Condition: Refurbished Packaging: Plain Box Ship Weight: 15 lbs Manufacturer: Dell MFG Part : 755 Model : OptiPlex 755 USFF Supported By: Geeks Dell OptiPlex 755 Core 2 Duo E6550 2.33 GHz Ultra Small Form Factor General Features: Ultra small form factor system Black and Gray Ultra Small Form...
|
|
|
stackoverflow.com
- 2012-04-22 12:04:06
- Similar
- Report/Block
maybe this question don't be NEW! but unfortunately my problem wasn't solved. I want show special position on the form without using scrollbar. for more description: my form need to scrollbar , but I don't want use scrollbar. I want to know what is the equivalent code for scrollbar to move horizontal in the form without using scrollbar. I...
|
|
|
stackoverflow.com
- 2011-01-05 06:08:46
- Similar
- Report/Block
I am starting to learn visual basic. So far, it is quite simple and easy to use. I am liking it! Anyway, I want to make applications a little bit more complex. So far I have done very silly things. I would appreciate if you could help me with these: How do I open a new window (form)? Maybe I click a button on my main form and another form...
|
|
|
|
stackoverflow.com
- 2013-03-29 15:18:57
- Similar
- Report/Block
I'm experiencing a very confusing situation that makes me question all my understanding of joins in SQL Server. SELECT t1.f2 FROM t1 LEFT JOIN t2 ON t1.f1 = t2.f1 AND cond2 AND t2.f3 > something Does not give the same results as : SELECT t1.f2 FROM t1 LEFT JOIN t2 ON t1.f1 = t2.f1 AND cond2 WHERE t2.f3 > something Can please someone help...
|
|
|
stackoverflow.com
- 2012-03-29 22:15:07
- Similar
- Report/Block
I've got a while-loop, with a loop condition like so: while (i != repetitionString.Length || !repetitionString[i].Equals(')')) The first part of the condition checks to see that the end of the collection is not reached. Is it possible to not execute the part following after the left side's condition is not met? The reason behind this is...
|
|
|
stackoverflow.com
- 2013-04-26 07:55:31
- Similar
- Report/Block
we want a subdomain to the register form. The project is a Code Igniter website. Our idea is to use register.domain.com I'm trying to build a rewrite rules to make this. If the domain is register.domain.com/whatever go to register.domain.com/register/form if the domain is register.domain.com/register/form do nothing. Now I only get a i...
|
|
|
|
dealsucker.com
- 2013-05-15 09:02:12
- Similar
- Report/Block
Part : SX2110GUW318FBR Warranty: 90 Day Direct Condition: Refurbished Packaging: Factory Box Ship Weight: 14.5 lbs Manufacturer: Gateway MFG Part : DT.GDYAA.002 Model : SX2110GUW318 Supported By: www.gateway.com Gateway SX2110GUW318 Fusion E11200 1.4 GHz Small Form Factor PC General Features: Small Form Factor design Microsoft...
|
|
|
istorya.net
- 2013-05-01 04:50:13
- Similar
- Report/Block
Unit is w/ clean papers and very condition: - air-conditioned - hi and low HID - 12'' condition tires ASKING PRICE: 180,000 FOR INQUIRIES: 032-4060713 ,09333358572...
|
|
|
stackoverflow.com
- 2012-03-16 20:33:27
- Similar
- Report/Block
This one has me stumped, so I thought I'd see if anyone else has ran into this issue and/or knows of a workaround. I have the following SELECT statement: SELECT * FROM TPM_VIEWSEARCH_EXPORT VS WHERE (PROJECTTYPEID IN (1)) This works fine, though it's a pretty slow query that returns about 3,000 rows. However, I want to order the results...
|
|
|
|
stackoverflow.com
- 2012-07-22 06:06:48
- Similar
- Report/Block
I'm very new to iOS. I have a UITableview that fill from sqlite3 database. Now I want to make, when a cell click, other database data relevant to that should be displayed in another view. I don't know how to write multiple parameterized where clause for select query. This is the query that I want. Here nebNO ModelName values are come in...
|
|
|
stackoverflow.com
- 2013-03-26 15:56:26
- Similar
- Report/Block
Im working on an application that does the following: User creates a new form User adds form elements to the form Application stores the form and form elements in a database Application generates an HTML version of the dynamic form User can update the HTML to customize the form and page to there desired needs Im currently working on editt...
|
|
|
dealsucker.com
- 2012-09-29 13:34:29
- Similar
- Report/Block
Part : DC5800C2D30MARR Warranty: 90 Days Condition: Refurbished Packaging: Plain Box Ship Weight: 21 lbs Manufacturer: HP MFG Part : dc5800 Model : dc5800 Small Form Factor Supported By: Geeks HP Compaq dc5800 Core 2 Duo E8400 3.0 GHz Small Form Factor PC General Features: Small Form Factor Microsoft Windows 7 Home Premium preinstalled...
|
|
|
|
stackoverflow.com
- 2013-05-14 03:42:22
- Similar
- Report/Block
I have a form that takes about 15 seconds to process and would like to show a spinner gif once the form is submitted and remove it once the form is complete. Also the form redirects to a new page and was wondering what the best method is to accomplish this? Should I be submitting this form with Ajax? Thanks in advance for your advice!...
|
|
|
stackoverflow.com
- 2013-03-19 01:50:41
- Similar
- Report/Block
I have two forms on my site (one is woocommerce, the other is gravity forms). The first form contains a single drop down with two options. The 2nd form contains two drop down fields. Any time the first form changes I want the second form to reset. I know this sounds strange but its for a hack. So I need a change function and clear form fu...
|
|
|
stackoverflow.com
- 2012-05-06 12:39:40
- Similar
- Report/Block
I have been googling a lot but i am still without an answer so i decided to ask this question here: Is there a way in PHP how to check that the data i am receiving in some script are from the specific form on the page? I am asking because everyone can see the name of the script i am using for saving the data to my database, so if somebody...
|
|
|
|
stackoverflow.com
- 2012-05-25 19:35:43
- Similar
- Report/Block
Following is sample query. CREATE PROCEDURE GetModel @brandids varchar(100), -- brandid="1,2,3" @bodystyleid varchar(100) -- bodystyleid="1,2,3" select * from model where brandid in (@brandids) -- use a UDF to return table for comma delimited string and bodystyleid in (@bodystyleid) My requirement is that if @brandids @bodystyleid i...
|
|
|
stackoverflow.com
- 2013-03-01 12:42:08
- Similar
- Report/Block
I use standart django comments framework. template: Add comment {% get_comment_form for post as form %} {% csrf_token %} {{form.content_type}}{{form.object_pk}}{ {form.timestamp}}{{form.security_hash}} Comment: {{form.comment}} Post How can I change {{form.comment}} field size? I tried to wrap it in or but it didn't work. Thx!...
|
|
|
stackoverflow.com
- 2012-04-15 12:27:32
- Similar
- Report/Block
I have situation like this: form with textbox, two dropdowns and grid with selected values form with search textbox, which needs to know values selected in dropdowns in above form to do searching First form is for saving whole data to database. Second form is for searching in database, showing searched values and adding selected values to...
|
|
|
|
cyberforum.ru
- 2012-09-16 14:25:22
- Similar
- Report/Block
Код: <html> <head> <SCRIPT LANGUAGE="JavaScript"> <!-- Begin function addChar(input, character) { if(input.value == null || input.value == "0") input.value = character input.value += character function cos(form) { form.display.value = Math.cos(form.display.value);} function sin(form) { form.display...
|