Search Results

Search found 28469 results on 1139 pages for 'select statement'.

Page 466/1139 | < Previous Page | 462 463 464 465 466 467 468 469 470 471 472 473  | Next Page >

• Get a char from a CString

  - by Sunscreen

  I have created a function that has as input a char szMyChar; (using it in a switch statement). Now I have a CString havong just a char, lets say CString strString = "A"; An option to call the function could be: if (strString == "A") CallMyFunc('A'); though it is clumsy. I tried atoi (returns 0) and casting though neither works. Any ideas? Thanks, Sun

  Read the article

• SQL: HAVING clause

  - by Craig Johnston

  See the following SQL statement: SELECT datediff("d", MAX(invoice.date), Now) As Date_Diff, MAX(invoice.date) AS max_invoice_date, customer.number AS customer_number FROM invoice INNER JOIN customer ON invoice.customer_number = customer.number GROUP BY customer.number If the the following was added: HAVING datediff("d", MAX(invoice.date), Now) > 365 would this simply exclude rows with Date_Diff <= 365? What should be the effect of the HAVING clause here?

  Read the article

• Archive Parent / Child Table Hierarchy in MySQL

  - by Eric J.

  If I have a Parent and Child table in MySQL related by a foreign key, is it possible using a SQL statement to move certain rows from Parent and the related rows from Child into archive tables (e.g. Parent_Archive and Child_Archive) in an atomic manner?

  Read the article

• Eclipse Doesn't List Classes Within Java Packages

  - by Matt Robertson

  Usually when I'm typing a Java import statement in Eclipse or otherwise referencing a class via the packages that it is in, Eclipse shows a context menu with a list of all classes within that package. There have been several times, however, that it would only shows subpackages within a package and would not show classes within that package. Does anyone know why this is? It sounds like a setting/preference was changed, but I never knowingly changed anything related to this.

  Read the article

• ORDERING A MYSQL QUERY WITH JOINS AND GROUPS

  - by Oliver

  I have this mysql query: SELECT * FROM Customer c JOIN eHRDemographic ehD ON ehD.CxID = c.CustomerID JOIN CustPrimaryWeight cpW ON cpW.CxID = c.CustomerID WHERE c.CustomerID =22703 GROUP BY c.CustomerID ORDER BY cpW.CustPrimaryWeightID DESC This doesn't really work correctly as the CustPrimaryWeight table has multiple enteries and it's simply joining the first entry and not the more recent one as the ORDER statement doesn't seem to do anything. Any ideas?

  Read the article

• replace function in dml statements in oracle 8i

  - by maheshasoni

  Can we use Replace function in a update statement ? If yes then How? I have a column 'enrollno' having values like '800-00001' to '800-01800'. I want to replace inital '800-' to '800' in all 1800 records. (Output should be '8000001' to '80001800') Is it possible through replace function or any other option is there in ORACLE8i ? MaheshA...

  Read the article

• Parse error: expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in ..?

  - by myaccount

  I tried to put an if statement inside an echo but this parse error came up, is it not possible to do that? should I use heredoc instead? echo "<input name='main_branch' type='radio' value='1' <?php if($restaurant['main_branch'] == 1) { echo "checked"; } ?> />Yes <input name='main_branch' type='radio' value='0' <?php if($restaurant['main_branch'] == 0) { echo " checked"; } ?> />No";

  Read the article

• How can I closely achieve ?: from C++/C# in Python?

  - by j0rd4n

  In C# I could easily write the following: string stringValue = string.IsNullOrEmpty( otherString ) ? defaultString : otherString; Is there a quick way of doing the same thing in Python or am I stuck with an 'if' statement?

  Read the article

• How to build array of 'bad' values

  - by JM4

  I am processing a form and in turn, receiving a response code based on the information submitted. I have a list of approximately 40 response codes (and their meaning) in my hands and am trying to build an 'if' statement that checks against a predefined array and returns a specific value. Just not sure how to do this First pass conceptually: $bads = array (1,2,3,4,5,6) if ($output['responsecode'] == (any value in $bads) { echo "you suck"; }

  Read the article

• Need batch file code to replace filepath with cd-rom drive letter.

  - by user361726

  Here is the copy statement I have currently. I am looking to replace the F: with %cdrom% so that this script will work no matter what computer it is used on. XCOPY F:\*.* .\disk2\ /C /S /D /Y /I

  Read the article

• One-line expression to map dictionary to another

  - by No Such IP

  I have dictionary like d = {'user_id':1, 'user':'user1', 'group_id':3, 'group_name':'ordinary users'} and "mapping" dictionary like: m = {'user_id':'uid', 'group_id':'gid', 'group_name':'group'} All i want to "replace" keys in first dictionary with keys from second (e.g. replace 'user_id' with 'uid', etc.) I know that keys are immutable and i know how to do it with 'if/else' statement. But maybe there is way to do it in one line expression?

  Read the article

• hibernate restrictions.in with and, how to use?

  - by cometta

  I have table like below id, employee_no, survey_no, name 1 test 1 test_name 2 test2 1 test_name2 3 test3 1 test_name3 4 test4 2 test_name4 how to query with Restriction.in by combining below AND into one IN statement? IN[ (if(survey_no==1) && employee_no== 'test') , (if(survey_no==1) && employee_no== 'test2') , ... ]

  Read the article

• In Asp.net (c#) i'm not able to catch any exception properly????

  - by Anand

  In Asp.net (c#),i'm not able to catch exception(FileNotFoundException) properly... i don't know the reason..Actually File s not there..But catch statement fails to catch the exception.. here is the code.. try { System.Drawing.Image imgg1 = System.Drawing.Image.FromFile(Server.MapPath("").ToString() + "\\images\\img1.jpg"); } catch (FileNotFoundException) { Response.Write("<script>alert('Please Select and upload Student's Photo');</script>"); }

  Read the article

• How to find out if a Java ResultSet obtained is empty?

  - by Bruce

  Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:userdata.db"); Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("SELECT * from table WHERE is_query_processed = 0;"); How can I find out if rs is empty?

  Read the article

• Design pattern suggestion

  - by Avinash

  Following is the problem statement. There are n numbers of match strings, If event A occurs and then in certain period of time event B occurs then I do not raise alarm. but if B do not occurs then i have to raise alarm. There can be multiple chain of events which defines whether to raise alarm or not.

  Read the article

• Allow user to only input text?

  - by Michael Quiles

  how do I make a boolean statement to only allow text? I have this code for only allowing the user to input numbers but ca'nt figure out how to do text. bool Dest = double.TryParse(this.xTripDestinationTextBox.Text, out Miles); bool MilesGal = double.TryParse(this.xTripMpgTextBox.Text, out Mpg); bool PriceGal = double.TryParse(this.xTripPricepgTextBox.Text, out Price);

  Read the article

• Why is used umask ?

  - by fabrizioM

  I am reading some source code and I found at the very begin of the main routine this statement: umask(077); What could be the reason for that? The man page (man 2 umask) states: umask -- set file creation mode mask This clearing allows each user to restrict the default access to his files But is not clear to me why would do that? as a shortcut ?

  Read the article

• Switch case in where clause (sql server)

  - by user685565

  I want to use case in sql statement where clause but I have a problem as I want to create a where clause condition on the basis of some value and I want to set a 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' then ID 592,90 else 592,90 END but its not syntax

  Read the article

• Is the Sleep operation no longer used in VBscript?

  - by Cheesus Toast

  The "Sleep" command as stated in many places over the internet (including here on this forum) DOES NOT WORK. Is it now an obsolete command? I am writing the VBScript code like this: sub button1_onclick() Wscript.Sleep 1000 div1.innerHTML = textbox1.value end sub It should wait 1 second and then execute that simple command. This is an utterly simple statement but it does not work. Plain and simple. It comes up with an error every time saying: Object Required: 'Wscript'

  Read the article

• PHP Echo with single quote or double quotes?

  - by nepc

  The is a very simple echo statement but I can't solve it? echo '"What is your name?'";

  Read the article

• Handling of 'or' condidions in Ruby vs PHP

  - by Adam

  I'm not sure what to call this, so I'll give an example. In PHP 1==2 || 2 returns 1 or true In Ruby 1==2 || 2 returns 2 (The second statement if the first evaluates to false). Is there any short way to implement similar thing in PHP?

  Read the article

• C++: Short question regarding switch and break

  - by oh boy

  Example: switch( x ) { case y: if ( true ) { break; } cout << "Oops"; break; } If the switch statement selects y, will Oops be written to the standard output? - Is break in switch statements a dynamic keyword like continue which can be called under conditions or static like a closing bracket }?

  Read the article

• Codeigniter: URI segments

  - by Kevin Brown

  How do I create an if statement saying something like this? $segment = "segment 2 or 3"; if($segment == 1{ do stuff } I know this is pretty elementary, but I don't totally understand the URI class...

  Read the article

• mysql restore file.sql syntax error using command line

  - by Jason

  when I input mysql -u root -p XXXX dbname < c:/filename.sql alway get this error "error 1064 <42000:" you have an error in your SQL suntax; check the manual that corresponds to your MySql server version for the right syntax to use near ..... what is wrong with this statement?

  Read the article

• Will IE9 support conditional comments?

  - by greim

  I thought I remembered reading somewhere that IE9 would not be supporting them, but now after searching I can't find any indication that this is true. Is anyone aware of a definitive statement, either way, about whether Microsoft will be supporting conditional comments in IE9?

  Read the article

< Previous Page | 462 463 464 465 466 467 468 469 470 471 472 473  | Next Page >