Search Results

Search found 40287 results on 1612 pages for 'try statement'.

Page 31/1612 | < Previous Page | 27 28 29 30 31 32 33 34 35 36 37 38  | Next Page >

• "Parameter xxx has no default value" error when using Order by in SQL statement

  - by Tofig Hasanov

  I am trying to run the following SQL statement: "SELECT *, (IIF([Field]=TRUE,'StringValue1','StringValue2') AS [NewField] FROM [Table1] ORDER BY [NewField] ASC" But this gives me an error "Parameter NewField has no default value". How can I solve it? I am using Microsoft Access (MDB) database using Jet Engine from Delphi 7. Thank you!

  Read the article

• Python: for statement behavior

  - by BandGap

  Hi all. My question concerns the output of this statement: for x in range(4), y in range(4): print x print y Results in: [0, 1, 2, 3] 2 True 2 It seems there is a comparison involved, I just can't figure out why the output is structured like this.

  Read the article

• I want to do a sql update loop statement, by using the do--while in php

  - by Jean

  Hello, I want to loop the update statement, but it only loops once. Here is the code I am using: do { mysql_select_db($database_ll, $ll); $query_query= "update table set ex='$71[1]' where field='val'"; $query = mysql_query($query_query, $ll) or die(mysql_error()); $row_domain_all = mysql_fetch_assoc($query); } while ($row_query = mysql_fetch_assoc($query)); Thanks Jean

  Read the article

• Spring Security Taglibs control statement

  - by Blake

  Is there a way to implement control statement with Spring Security taglibs? Currently we can only check if a user has a role... <security:authorize access="hasRole('ROLE_ADMIN')"> // display something </security:authorize> How about else?

  Read the article

• continue statement in pl/SQl?

  - by i2ijeya

  I am Using Oracle 9i and I want to use continue statement or its equivalent in PL/SQL. So is there any keyword called "continue" in oracle 9i. If not, please let me know the solution for this.

  Read the article

• C# empty statement

  - by dotnetdev

  In C#, I can write something like: using (new MyDisposableClass().MethodA()); The semicolon causes a compiler warning to be shown which states possible mistaken empty statement. I haven't run the above code but won't the method still be called? What uses is there of this type of coding convention? I saw another thread on here about this but I ask in case there areny differences now/therefore different replies. Thanks

  Read the article

• have mysql select statement return fully qualified column names like table.field

  - by handsomeGun

  is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field? like so: SELECT * FROM table1 LEFT JOIN table2 on table1.f_ID = table2.ID and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...

  Read the article

• meaning of import statement in java file

  - by Rozer

  Can any one clear me exactly what happend when we do import statement in java files. does it inscrease the size of file if we add more and more java classes. why we dont use classloader for the same and what are the restrictin for importing.

  Read the article

• Multiple bindings expressions in one statement

  - by Abhijeet Patel

  Does WPF support multiple binding expressions in one statement? Something along the lines of the following: <TextBlock Text="{Binding Path=OrderID} shipped on {Binding Path=OrderDate}"/> I'm guessing that it does but I think I just don't have the correct syntax.

  Read the article

• what is the required code method of making a sticker app?

  - by zeropt7

  I am new to photo apps, recently I am interested in making a sticker app like those can be seen in the appstore, I know I would need to use uiimagepickercontroller, uiscrollview and uigesturerecognizer. However I wonder which code method should I use for the app to load multiple stickers? Should it be called programmatically? Is that I would need to use the if-statement, say if one sticker is loaded, the app will auto generate a new sticker on top of it?

  Read the article

• Python style: if statements vs. boolean evaluation

  - by mkscrg

  One of the ideas of Python's design philosophy is "There should be one ... obvious way to do it." (PEP 20), but that can't always be true. I'm specifically referring to (simple) if statements versus boolean evaluation. Consider the following: if words: self.words = words else: self.words = {} versus self.words = words or {} With such a simple situation, which is preferable, stylistically speaking? With more complicated situations one would choose the if statement for readability, right?

  Read the article

• Refactoring nested foreach statement

  - by dotnetdev

  Hi, I have a method with a nested foreach collection (iterate a set of objects and then look inside each object). I saw in a book a good pattern to make this much more elegant but cannot remember/find the code example. How else could I make this more tidy? The code is just a typical nested foreach statement so I have not provided a code sample. Thanks

  Read the article

• Return Statement in JS Constructors

  - by Tony

  What is the effect of a return statement in the body of JavaScript function when it's used as a constructor for a new object(with 'new' keyword)?

  Read the article

• yield returns within lock statement

  - by DayOne

  Hi eveybody, if i have a yield return in a lock statement does the lock get taken out on each yield (5 times in the example below) or only once for all the items in the list? Thanks private List<string> _data = new List<string>(){"1","2","3","4","5"}; private object _locker =new object(); public IEnumerable<string> GetData() { lock (_locker) { foreach (string s in _data) { yield return s; } } }

  Read the article

• Is this sql where statement correct?

  - by Priyaa Muthuraman

  I have 10 rows for today's date but my select statement based on date dosen't seem to work.... SELECT Id,WirelessId,RegNo,DriverName1,MobileNo1,DriverName2,MobileNo1 from DailySchedule where IsDeleted=0 and CreatedDate='2010-05-28' Any suggestion...

  Read the article

• SQL - Stored Procedure with Select Statement using IN (@Variable_CommaDelimitedListOfIDS)

  - by GigaPr

  Hi I am creating a stored procedure to which i want to pass as variable a comma delimited list of Ids I want to use the Ids into a select statement something like Create Procedure up_TEST @Ids VARCHAR(MAX) AS SELECT * FROM ATable a WHERE a.Id IN(@Ids) Obviously i get the error that @Ids is a varchar and not an INT but how can i convert the comma delimited list I am using SQL Server 2008 Thanks

  Read the article

• Translate LINQ to sql statement

  - by zielu1

  Hi, I want to translate LINQ expression tree to SQL statement and I don't want to write my own code for this. Example: var query = from c in Customers where c.Country == "UK" && c.City == "London" select c); To SELECT ... FROM Customers AS c WHERE c.Country = "UK" AND c.City = "London" I know DataContext.Log, but I want to use: query.ToSqlStatementString() Thanks

  Read the article

• How to skip a statement in Eclipse during debugging

  - by frankfwl

  Is it possible to skip a statement in Eclipse while debugging? Suppose the process stopped at breakpoint and I want to skip the breakpoint line ( or maybe a few lines below), can I do it? On the debug tab, it only has "Step into", "Step over" and "Step return" buttons. I did google around but couldn't find anything, hopefully I can find an answer here.

  Read the article

• What's the error in my MySQL statement?

  - by Jim

  The following SQL statement has a syntax error according to phpMyAdmin, but I can't spot what it is. Any ideas? CREATE TABLE allocations( `student_uid` INT unsigned NOT NULL DEFAULT 0, `active` INT unsigned NOT NULL DEFAULT 1, `name` VARCHAR( 255 ) NOT NULL DEFAULT '', `internal_id` VARCHAR( 255 ) DEFAULT '', `tutor_uid` INT NOT NULL DEFAULT 0, `allocater_uid` INT unsigned NOT NULL DEFAULT 0, `time_created` INT NOT NULL DEFAULT 0, `remote_time` FLOAT NOT NULL DEFAULT 0, `next_lesson` VARCHAR NOT NULL DEFAULT -1, PRIMARY KEY ( student_uid ) );

  Read the article

• Can IF be used to start a MySQL query?

  - by Littledot

  Hi there, I have a query that looks like this: mysql_query("IF EXISTS(SELECT * FROM predict WHERE uid=$i AND bid=$j) THEN UPDATE predict SET predict_tfidf=$predict_tfidf WHERE uid=$i AND bid=$j ELSE INSERT INTO predict (uid, bid, predict_tfidf) VALUES('$i','$j','$predict_tfidf') END IF")or die(mysql_error()); But it dies and mysql tells me to check the syntax near IF EXISTS(....) Can we not use an IF statement to start a mysql query? Thank you in advance.

  Read the article

• MySQL select/where statement

  - by expo101

  I have a webapplication linked to a mysql database with the following fields: field 1:trip_id field 2:trip_destination field 3:trip_description field 4:trip_duration In the webapplication I have a listbox based on the following: ListBox value =1: trip duration 1 - 5 days ListBox value =2: trip duration 6 - 10 days Listbox value =3: trip duration 11 -20 days ListBox value =4: trip duration over 20 days How do I put this in the sql select statement?

  Read the article

• Best way to use If() statement in My-Sql Query

  - by PHP-Prabhu

  Can any one please let me know the best way to use IF statement in mysql query to show if the "email" field is NULL then it should show as "no email"... Postcode Telephone Email ---------------------------------------------------------- BS20 0QN 1275373088 no email BS20 0QN 1275373088 no email PO9 4HG 023 92474208 [email protected] SO43 7DS 07801 715200 [email protected] ----------------------------------------------------------

  Read the article

• Detect months with 31 days

  - by daddycardona

  Is there an analogous form of the following code: if(month == 4,6,9,11) { do something; } Or must it be: if(month == 4 || month == 6 etc...) { do something; } I am trying to write an if statement that checks if this month has more than 31 days.

  Read the article

• syntax error in a mysql statement

  - by knowledge

  what is the error in the following mysql statement : mysql> SELECT columnName FROM tableName WHERE columnName LIKE '%' + @variableName + '%';

  Read the article

• Need help understanding several MATLAB statement

  - by user198729

  All are from this post. What does these statement mean: error(nargchk(5, 6, nargin)); plot(p(:,1), p(:,2), '.-'), axis equal And what's this kinda syntax which I haven't quite often seen: if nargin<6, steps = 36; end

  Read the article

< Previous Page | 27 28 29 30 31 32 33 34 35 36 37 38  | Next Page >