Search Results

Search found 18245 results on 730 pages for 'recursive query'.

Page 512/730 | < Previous Page | 508 509 510 511 512 513 514 515 516 517 518 519  | Next Page >

• Accessing Mysql with JQuery without using php

  - by user326175

  Hi, I'm very new to JQuery, but I was told the one of the cool things about it is you can query a mysql database right from an html page(or in my case a smarty template)with out needing php. I have not found any examples of this so I am asking if someone has one? Thanks

  Read the article

• Excel : sum of values depending of other values

  - by gregseth

  Hi, What would be the equivalent Excel formula of this SQL query SELECT SUM(a) FROM table WHERE b < 0; A B ---- ---- 1 0 2 -1 3 4 5 -3 >> 7

  Read the article

• Make qwidget in new window in PyQt4

  - by matt

  I'm trying to make a class that extends qwidget, that pops up a new window, I must be missing something fundamental, class NewQuery(QtGui.QWidget): def __init__(self, parent): QtGui.QMainWindow.__init__(self,parent) self.setWindowTitle('Add New Query') grid = QtGui.QGridLayout() label = QtGui.QLabel('blah') grid.addWidget(label,0,0) self.setLayout(grid) self.resize(300,200) when a new instance of this is made in main window's class, and show() called, the content is overlaid on the main window, how can I make it display in a new window?

  Read the article

• how to get an xml in a variable

  - by sam

  I have a stored procedure that will return xml. I have delared a variable of type xml and trying to execute the following code declare @v xml set @v = execute get_xml @id, 33 whereas id is returned by another query. now it keeps compalinng about the following error Incorrect syntax near the keyword 'execute'.

  Read the article

• retrieving same column twice from a table

  - by GJ

  hello all i hav a table named address which has id, title and parent_id fields. in title column the name of regions and districts are inserted. the regions have parent_id zero and parent_id of the districts are id of the regions. i want a query which display regions in one column and its respective districts in another column. hope u guys understand what i mean.. thank u all.

  Read the article

• C# Reading a file and writing out replacing string

  - by Mike

  What I have is a C# windows app that reads a bunch of SQL tables and creates a bunch of queries based on the results. What I'm having a small issue with is the final "," on my query This is what I have ColumnX, from I need to read the entire file, write out exactly what is in the file and just replace the last , before the from with nothing. I tried .replace(@",\n\nfrom),(@"\n\nfrom) but it's not finding it. Any help is appreciated. Example: ColumnX, from Result: ColumnX from

  Read the article

• Set given time to 00:00:00 in PHP/MySQL

  - by hypnocode

  Hi, I'm retrieving a date from a MySQL database that shows up like this: '2010-03-09 09:11:30' How can I change the date to '2010-03-09 00:00:00'? I'm using PHP to perform the query. Thanks!

  Read the article

• Selecting from a Large Table SQL 2005

  - by Eugene

  I have a SQL table it has more than 1000000 rows, and I need to select with the query as you can see below: SELECT DISTINCT TOP (200) COUNT(1) AS COUNT, KEYWORD FROM QUERIES WITH(NOLOCK) WHERE KEYWORD LIKE '%Something%' GROUP BY KEYWORD ORDER BY 'COUNT' DESC Could you please tell me how can I optimize it to speed up the execution process? Thank you for useful answers.

  Read the article

• Rails3 nomethod error #<ActiveRecord::Relation>

  - by Dodi

  Hi! I'm writing a static page controller. I get the menuname in the routes.rb and it's call the static controller show method. match '/:menuname' = 'static#show' And static_controller.rb: @static=Staticpage.where("menuname = ?", params[:menuname]) But if I want print @static.title in the view, I get this error: undefined method `title' for # Whats wrong? the SQL query looks good: SELECT staticpages.* FROM staticpages WHERE (menuname = 'asd')

  Read the article

• Looking for a Function that insert "Any" form values to mysql

  - by jasmine

  I am Looking for a Function that insert "Any" form values to mysql, update or delete. (not OOP) I have found a function here: http://tr.php.net/manual/en/function.mysql-query.php Thanks in advance

  Read the article

• i want to add a column in my table

  - by Abid

  there is already some columns added in my table starsin.. i want to add a column address in my table starsin by using a query..

  Read the article

• Sql server Identity issue

  - by pranay

  I have query like below declare @str_CustomerID int Insert into IMDECONP38.[Customer].dbo.CustomerMaster ( CustomerName , CustomerAddress , CustomerEmail , CustomerPhone ) values ( ‘werw12e’ , ‘jkj12kj’ , ‘3212423sdf’ , ‘1212121' ) select @str_CustomerID= scope_identity() after execution it returns null in my parameter i want to get value of identity how can i do that

  Read the article

• Custom QAction/QMenu for mouse button detection

  - by voodoogiant

  I'm trying to create a popup menu, where I can detect the mouse button that was pressed for a given item. I've created a custom QAction already to build my QMenu, but the triggered signal when the menu item is pressed doesn't provide a QMouseEvent for me to query the button pressed. Also, I'm setting the a status tip for each QAction, which appears in the status bar when I mouse over it, but it stays even after I close the QMenu. Is this normal behavior?

  Read the article

• From Now() to Current_timestamp in Postgresql

  - by xRobot

  In mysql I am able to do this: SELECT * FROM table WHERE auth_user.lastactivity > NOW() - 100 now in postgresql I am using this query: SELECT * FROM table WHERE auth_user.lastactivity > CURRENT_TIMESTAMP - 100 but I get this error: operator does not exist: timestamp with time zone - integer How can I resolve ?

  Read the article

• Adding A New Row Using SQL Server Management Studio

  - by Soo

  I'm learning how to use SQL Server Management Studio and can't figure out how to insert a new row into a table. Table Structure: ID, Field1, Field2 Query: INSERT INTO Table (Field1,Field2) VALUES(1,2) Error: Major Error 0x80040E14, Minor Error 25503 I'm probably missing something very noobie like. Any help would be appreciated.

  Read the article

• SQL Reporting Services: Finding the folder a report is in

  - by Bob

  Hi there, If I have the report name how can I programmatically get the name of the project/folder the report is in? So for example if I have a report like so http://server/Reports/Pages/Report.aspx?ItemPath=/ReportProject1/ReportName Given "ReportName" how can I figure out that the report is in the folder "ReportProject1"? So I guess is there a function where I can pass int he report name and get it's details or else query the report server for a list of its report folders and I can loop through these and check some how that the report is inside?

  Read the article

• Anything like GROUP BY that gives you the max value'd field instead of the min?

  - by William

  I'm trying to get the results from this question (SO 2429348 - Help with a SQL query) except I need it to return values 1 and 3.

  Read the article

• mysql: Can I use two "where"s? Like, "SELECT * FROM table WHERE something and something"?

  - by KeriLynn

  I have a table with my products and I'm trying to write a page that would pull bracelets with certain colors from the database. So here's what I have right now (in php): $query = "SELECT * FROM products WHERE (products.colors LIKE '%black%')"; But I only want to select rows where the value for the column "category" equals "bracelet". I've tried a few different things, but I keep getting warnings and errors. I appreciate any help you can give, thank you!

  Read the article

• What's the easiest way to create an extensible custom container in Flex?

  - by Chris R

  I want to create an MXML container component that has some of its own chrome -- a standard query display, et al -- and that supports the addition of child components to it. Something a lot like the existing mx:Panel class, which includes a title label, but acts like a plain mx:Box with regards to adding children. What's the easiest way to do this? Edit: To be clear, I want to be able to extend the container using MXML, so the "Multiple visual children" problem is relevant.

  Read the article

• [C#] RegEx search for two pattern strings and cut what's between

  - by gsharp

  I'm trying to write a little SQL Helper. I have a query like this stored in a string: DECLARE @V1 INT --ignore DECLARE @V11 INT DECLARE @V12 INT --endignore DECLARE @V2 INT --ignore SELECT * FROM SampleTable INNER JOIN AnotherSampleTable ...... --endignore SELECT * From Employee ORDER BY LastName My helper method should cut everything what's between --ignore and --endignore The result string should look like: DECLARE @V1 INT DECLARE @V2 INT SELECT * From Employee ORDER BY LastName How can achieve my result with RegEx?

  Read the article

• Get top rated item using AVG mysql

  - by user1876234

  I want to find top rated item using AVG function in mysql, right now my query looks like this: SELECT a.title, AVG(d.rating) as rating FROM in8ku_content a JOIN in8ku_content_ratings d ON a.id = d.article_id ORDER BY rating DESC Problem is that it takes AVG of all items and the result is not accurate, what should be changed here to get correct result ? Tables: in8ku_content [id, title] in8ku_content_ratings [id, article_id, rating]

  Read the article

• Finding Shared Columns in SQL Server

  - by smoore

  Is there a quick query I can run that returns all columns of the same name between two tables? I have many pairs of tables that I know are tied together, but I'm not sure which of the 50 or so columns they have in common.

  Read the article

• single page javascript send data AND pull data from mysql via php?

  - by David19801

  Hi, I am trying to make a dynamic form which retrives data. How can I use javascript to load a value from a mysql database? I understand that it must use php in some way, and I know how to query the database and assign the value to a php variable, but I have no idea what to do after that...any advice? the goal is to have someone enter their orderid say, then the datbase auto pulls down and enters their last invoice in the field below it after they click GO...

  Read the article

• Is it normal to get SQLITE_BUSY on a read only database?

  - by dicroce

  I have 2 processes: 1 is writing to a sqlite database, 1 is reading from the same database. Occasioally, I get SQLITE_BUSY on my selects. Is this normal? Is their some option or way I could open the database so that it blocks until it CAN complete the query? (I tried the FULLMUTEX option on the open call but it appeared to have no effect).

  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

< Previous Page | 508 509 510 511 512 513 514 515 516 517 518 519  | Next Page >