FreeTextTable is really great for searching, as it actually returns a relevancy score for each item it finds. The problem is, it doesn't support the logical operator AND, so if I have 10 items with the word 'ice' in it, but not 'cream', and vice versa, then 20 results will be returned, when in this scenario 0 should've been returned. A...
We have a huge Oracle database and I frequently fetch data using SQL Navigator (v5.5). From time to time, I need to stop code execution by clicking on the Stop button because I realize that there are missing parts in my code. The problem is, after clicking on the Stop button, it takes a very long time to complete the stopping process (so...
Hi All, i have one table my_table,which contains three columnn namely name,address1,address2. Now i want to search a data from these 3 column which contains single quote. Can anybody suggest. Thanks in advance. ...
Hello... Suppose we have a table with collumns (A,B,C) We want to search this table based on a criteria that is calculated from collumn C... and other parameters Because the calculation is complex and cant be represented in sql query... what should i do? Make the filtering at application level ? ...
Using postgreSQL 8.1.11, is there a way to select a set of columns that have name begining with same prefix. Suppose we have columns : PREFIX_col1, PREFIX_col2, ... Is it possible to do a request like : SELECT 'PREFIX_*' FROM mytable; Wich of course doesn't work. ...
hEY ALL i have a table that shows transactions and their status. How can i create a column that shows the total of transactions that are completed,rejected,declined and the grand total of all on a different column for example i am looking something like this Completed 100 Rejected 50 Declined 20 Total 170 In 3 different rows...
I have one select: select * from table1 where col1=10; and another select: select * from table1 where col1=11; Sql parser parses them as different sqls.. I want to make SQL PARSER parse the statement once and just change the parameter in the where clause..Can I do that? Do have any idea ? please share it with me.. thanks a lot. P....
Hey guys i am really messing up with this. I tried this but failed. I have following three tables with user polard searched 2 times at different days, with increased friends in second search in table b. I just need to build the query which will give me the two newly added friends (wont be present in end of list of second search). In tabl...
Is it possible for a SQL Stored Procedure to call a .NET object? In my situation, I need to take a string parameter and return a hashed result that can be consumed by my secure client. I can either have this SP called on a per result basis (once per row), or I can possibly return multiple rows. It all depends on what SQL will support ...
My SQL query is ALTER TABLE `USERS` MODIFY `UUID` SERIAL UNSIGNED NOT NULL AUTO_INCREMENT but I keep on getting #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNSIGNED NOT NULL AUTO_INCREMENT' at line 1 from MySQL (version 5.1). :-( An...
Hi all.. I am trying to insert multiple tables at a time.. If any one of the insert is failed that means 0 rows updated after that.. When i try to execute the command in .net using execute non query i got 0 as result .. Is there any alternative ways to fix this . I need to execute the query and return 1 as the result ie,. succe...
Hi, I am using Doctrine 1.2 and looking for the correct syntax for creating a 1:n relationship between two tables in my schema.yml Usual this is done by: BookChapter: columns: ... relations: Book: class: Book local: book_id foreign: id type: one onDelete: cascade However in my special case t...
I need to copy a database from a remote server to a local one. I tried to use SQL Server Management Studio but it only backup to a drive in the remote server. Some points: I do not have access to the remote server in a way that i could copy files; I do not have access to setup a UNC path to my server; Any ideas of how can I copy thi...
I'm desperately trying to make sense of Arel, mostly because I hate dealing with SQL; I was doing so well, but I've hit a wall. I've been working in Rails 3.0.0, and I'm trying to make a complex query with some math in it. The real case is rather more complex, but I've simplified a bit. In my example, I have a table with a particular ...
I have a varchar field with the following data: Interface Gig1/0/1 Gig1/0/3 Gig1/0/5 Gig1/0/10 Gig1/1/11 I am trying to do a search (BETWEEN). Select * from test1 where Interface Between "Gig1/0/1" and "Gig1/0/5" Returns all the records except for Gig1/1/11 ...
I must check approximately 1000 numbers against 1000 other numbers. I loaded both and compared them server-side: foreach( $numbers1 as $n1 ) { foreach( $numbers2 as $n2 ) { if( $n1 == $n2 ) { doBla(); } } } This took a long time, so I tried to do the same comparison client side using two hidden div elements. Then co...
Hi, Im currently making a very simple WebApp on a Website using ASP.NET Framework using C# in Visual Studio 2010. The website will connect to my SQL EXPRESS server running on my laptop (Its all locally based) I have a table defined as below CREATE TABLE Users( userName varchar(50), email varchar(50), firstName varchar(50), lastNa...
I have a method that loops through all the rows of a table where a certain condition is met, and then checks if one of the columns in the row appears in a text. The method is below: public function isRecipeType($ingredients, $type) { $rows = $this->fetchAll($this->select()->where("type = ?", $type)); foreach($rows as $row) ...
I'm in need of some help with getting my duplicates from showing more than once in my output. SELECT accountNumber AS 'Member Number', OD.orderdetails AS 'iNum', FirstName AS 'First Name', LastName AS 'Last Name', HGP.email AS 'Email', points AS 'Points -->', '$' + CONVERT(varchar(50),(CONVERT(int,Points) * .1)) AS...
Person Table ID FirstName LastName PersonalWealth 1 Hello Alest $10,000.00 2 Leeds United $20,000.00 3 Middle Brough $30,000.00 4 Arsenal Chelsey $40,000.00 5 Manchester United $50,000.00 6 Peter Mean $60,000.00 7 Hello Coward $60,000.00 Car Table ID CarRego Model Make Manufact...