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 + '%';
Search Results
Search found 23568 results on 943 pages for 'select'.
Page 542/943 | < Previous Page | 538 539 540 541 542 543 544 545 546 547 548 549 | Next Page >
-
-
display 25 randomnumbers from an array
- by qwerty
Hello, I have in C++ an array of 100 elements, so v[1], ... ,v[100] contains numbers. How can i display, 25 random numbers from this array? So i wanna select 25 random positions from this array and display the values.. How can i do this in C++? Thanks!Read the article
-
How to check the existence of a row in SQLite with Python?
- by fx
I have the cursor with the query statement as follows: cursor.execute("select rowid from components where name = ?", (name,)) I want to check for the existence of the components: name and return to a python variable. How do I do that?Read the article
-
Operations on Java Swing
- by gustavo
In my project,I will get the coordinates of some points from an XML file,and create some visual components using this information ? I am planning to give these components to a Java swing frame or panel. However,The users are supposed to click on the figure(which I will construct using Graphics 2d libraries) and select two points and give a label to the points between those two points ? How can i get the clicks clicked on JFrame or JPanel(i.e events for this kind of actions) ?Read the article
-
Check the value from DBand pass it to next page
- by user554176
I have a field ,if user enters data it should go and check db if it is present it should redirect to next page. But here i m not sure whether it is checking the db but mysql query is correct. $ThirdPartyCategoryName =$_POST['ThirdPartyCategoryName']; $activate = mysql_query("SELECT * FROM `thirdpartycategorymaster` WHERE `delete` = 'y' "); if($activate=='y') { header("location:catact.php"); } else { //$activate=='NULL'; header("location:tp_home.php"); }Read the article
-
Is it possible to get id of affected rows in MySQL?
- by user198729
I'm using pdo to do this : update tags set cnt=cnt-1 where name in ? delete from news_tag where news_id=? and tag_id in (select id from tags where name in ?) But if I can get affected rows' id,the subquery is not needed.Read the article
-
How to edit resharper's action list
- by Gerard
In Resharper I edited the inspection severity of the 'use var keyword when possible' to ''do not show'. But when I select a certain word in the code file, Resharper still shows a pencil with an Action list in the left border with the action 'use var'. Where can I edit the actions that should be shown? I cannot find this option.Read the article
-
How do I use ST_Contains in following case?
- by Z77
I have two tables. First with points, and second with polygons. I need to find out which points are in required polygon according to the attribute gid. Using query: SELECT table1.* FROM table1, table2 WHERE table2.gid=1 AND ST_Contains(table2.geom2, table1.geom1); What I get is empty table (only columns without data)... TnxRead the article
-
Getting dates based on week number
- by meep
Hello. I have some rows in my database that contains some dates. I need to select all dates based on a weeknumber, how is this possible?Read the article
-
validating check boxes in grid view
- by SmartDev
Hi, I have used check box in gridview . Now i want to validate those checkboxes as if no check box is selected a message shud pop up saying please select check box and thn press submit Thanks SmartdevRead the article
-
JQuery - Set all cookies ending with
- by Israfel
I'm wondering if it's possible to use a wildcard to select multiple cookies. I'm using jquery to save various scroll position and would like to clear them out in one go. At the moment I clear them out individually as below function clearScroll(elementID) { if ($.cookie) { $.cookie(elementID + '_scrollpos', 0); } } What I'd like is a clear all something like below. function clearAllScroll() { if ($.cookie) { $cookie([name$='_scrollpos'],0); } } Is this possible?Read the article
-
mySQL convert varchar to date
- by Jeff V
I need to convert a varchar value of 1/9/2011 to a date in mySQL and I want only the month and year. So that I can then use the PERIOD_DIFF function (so I would need the above to be converted to 201101). I've tried various ways using the STR_TO_DATE function: SELECT STR_TO_DATE(CYOApp_oilChangedDate, '%m/%Y') FROM CYO_AppInfo But I get weird results... (for example: 2009-01-00) What am I doing incorrectly?Read the article
-
changing the name of type="file" input tag?
- by Syom
i have an input tag... <input type="file" name="upload"> for browsing it makes the button vith value "browse"(in mozilla) the question is: how can i change the name of that button? i want it to have the name "select" instead of "browse". ThanksRead the article
-
Signs that a SQL statement is dangerous
- by Matt
Hi, I want to develop a function in PHP that checks how dangerous a SQL statement is. When i say dangerous i mean, certain symbols, characters or strings that are used to get data from a database that the user shouldnt see. For example: SELECT * FROM users WHERE userId = '1' can be injected in several ways. Although i clean the params, i also want to monitor how safe the query is to run. Thanks in advanceRead the article
-
Copy (or USE) data from two tables in different databases
- by Z77
I don-t know how to use one table from one database and second table from another databse at the same time or copy data from table in one database to table from another databse. I tried following query: select * into NewTable from existingdb.dbo.existingTable; But it doesnt't work.Read the article
-
Erro while join table in SQL
- by Color Shadow
I have two tables that have relationship with UserName field. Based on UserName column, I want to get ID from CarReserve table. Here is my SQL statement: SELECT CarReserve.ID FROM CarReserve INNER JOIN aspnet_Users ON CarReserve.UserName = aspnet_Users.UserName WHERE UserName = @UserName Unfortunately, I am getting this warning: Ambiguous column name "UserName" Can anyone here tell me what is wrong with my statement?Read the article
-
Rails find through association
- by yogi
class Customer < ActiveRecord::Base has_one :address, :foreign_key => "customerid" end class Address < ActiveRecord::Base belongs_to :customer, :foreign_key => "customerid" end How do I find records in customer that do not have customerid in address table? in SQL i'd do select * from customer a, address b where a.customerid <> b.customeridRead the article
-
troubles creating a List of doubles from a list of objects
- by Michel
Hi, i have a list with objects. The object has a property 'Sales' which is a string. Now i want to create a list of doubles with the values of all objects' 'Sales' properties. I tried this: var tmp = from n in e.Result select new{ Convert.ToDouble ( n.Sales) }; but this gives me this error: Error 106 Invalid anonymous type member declarator. Anonymous type members must be declared with a member assignment, simple name or member access.Read the article
-
Problem in LINQ query formation
- by Newbie
I have written List<int> Uids = new List<int>(); Uids = (from returnResultSet in ds.ToList() from portfolioReturn in returnResultSet.Portfolios from baseRecord in portfolioReturn.ChildData select new int { id = baseRecord.Id }).ToList<int>(); Getting error: 'int' does not contain a definition for 'id' what is the problem that i created? ThanksRead the article
-
How to check the existence of a row in SQLite?
- by fx
I have the cursor with the query statement as follows: cursor.execute("select rowid from components where name = ?", (name,)) I want to check for the existence of the components: name and return to a python variable. How do I do that?Read the article
-
Selecting two specific mysql table rows in a single query
- by Scotta
Lets say I have a table with 20 entries. They are sorted by date (date is a column name _) in descending order. How would I go about selecting ONLY the newest entry and the 15th oldest entry? I am getting all 15 results by doing the following query SELECT * FROM mytable m WHERE col1 = "zzz" ORDER BY date DESC LIMIT 15;Read the article
-
jQuery Selection Child of UL. Looking for a better method
- by john doe
I have a div element which contains UL and UL contains the LI items. One of the LI item has an ID of stocknumber. I need to select that li. Here is my code which works fine I am just looking for a better implementation. $(".block").children("ul").children("#stocknumber") // gets me the li and it works!!Read the article
-
Selecting count(*) while checking for a value in the results
- by Rob
SELECT COUNT(*) as Count, IF(sch.HomeTeamID = 34,true,false) AS Hawaii FROM schedule sch JOIN schools s ON s.ID = 83 WHERE (sch.HomeTeamID = 83 OR sch.AwayTeamID = 83) AND sch.SeasonID = 4 I'm trying to use count() to simplify my result but also include a field that represents wether any of the results' specific column contained a certain value. Is this possible? I'd basically like a row response with all the info I need.Read the article
-
Git: Add part of (changed) file to index *by line numbers*
- by RobM
Is there a git command to add differences within a range of line-numbers to the index? I want to be able to select lines in my editor and run a macro to add any changes in the selection to the index.Read the article
-
Using JQuery to Style form elements
- by John
Hi, I've seen jquery used to change a form select drop down box in to a 'pretty' drop down list widget. I can't remember where I saw this but does anyone have any links or example code which show examples of how to use jquery to style form elements? I'd prefer it if it was code rather than a built in plug in. ThanksRead the article
