Hi, i m having a little syntax problem in my query (simplified) : select * from table1 t1 inner join table2 t2 using (pk1) inner join table3 t3 using (pk2) where not exists (select1 from table4 t4 where t4.pk1 = t1.pk1) By using the "using" keyword, oracle doesnt allow table identifier in front of the column name (eg : t1.pk1, only p...
What is the best way to check if an object exists in the database from a performance point of view? I'm using Entity Framework 1.0 (ASP.NET 3.5 SP1). ...
I have this simple query that works on all other database systems, but fails with MySQL: UPDATE points p SET p.userid = 5224 WHERE p.userid = 2532 AND NOT EXISTS ( SELECT 1 FROM points q WHERE q.userid = 5224 AND q.game = p.game ) I get the following error message: #1093 - You can't specify target table 'p' for up...
In Jet, I want to test if certain conditions return any results. I want a query which returns exactly one record: "true" if there are any results, "false" otherwise. This works in MS SQL: SELECT CASE WHEN EXISTS(SELECT * FROM foo WHERE <some condition>) THEN 1 ELSE 0 END; This is what I have tried in Jet: SELECT IIF...
I already know how to check elements that are there when the document is ready: jQuery.fn.exists = function () { return jQuery(this).length > 0; } But this method doesn’t know elements that are added with AJAX. Does anybody know how to do that? ...
I am having a table in SQL server which stores MINIMUM_AMOUNT,MAXIMUM_AMOUNT and CURRENCY_ID Now i want to frame an SQL query which will check the new values to be inserted are already existing in the table. Ex : My table is having 2 records as follows RANGE_ID MINIMUM_AMOUNT MAXIMUM_AMOUNT CURRENCY_ID -----------------------...
I currently do this to check if an elements exists: if ($(".element1").length > 0 || $(".element2").length > 0 { ...stuff... } Is there a better way to rewrite the same? I mean, ".length" the same as ".length > 0" ? Thanks ...
I've got a query joining several tables and returning quite a few columns. An indexed column of another table references the PK of one of these joined tables. Now I would like to add another column to the query that states if at least one row with that ID exists in the new table. So if I have one of the old tables ID 1 2 3 and th...
Database one is called widgets, it has "id" and "title". Database two is called widget-layouts and it has "module-id", "widget-id", "position", and "weight". What I am trying to do is check to see if widgets.id exists in widget-layout.widget-id and if it does, then does widget-layouts.position = 0. I also want to get the values of widge...
I need to check if a webpage exists if it does whether a certain string exists anywhere on the page. Preferably I'd like to do this without a webbrowser control, so that images don't have to be downloaded and it doesn't have to be rendered. So is there a way to do this? ...
Hey, How do I check whether an object already exists or not? thank you! ...
I need to determine if a Perl hash has a given key, but that key will be mapped to an undef value. Specifically, the motivation for this is seeing if boolean flags while using getopt() with a hash reference passed into it. I've already searched both this site and google, and exists() and defined() don't seem to be applicable for the si...
How to write if not exists statement in sql server 2005 for the following condition If @MeasurementId say values (1,2,3) those are the existing values the below statement work but when @MeasurementId=0 it doesn't seem to work... If not exists(select Mat_Id,MeasurementId from MaterialQuantity where Mat_Id=@Id and MeasurementId=@Measur...
Basically, I want to upload about 10,000 family photos that have been organized into folders according to names of the people involved. What I'm looking for is php driven software that allows me to put passwords on each of the folders initially and then allow the family members themselves to manage their folder by adding additional usern...
How do I check an external file for a class? I am trying to setup a install feature for my modules, so I am trying to get it to load a list of directories and then check if the module file has a method called install. So only the modules with this method will be shown in the list. Here is my code so far: $output .= '<div id="module-di...
I have a reference to a DOM element, and a jQuery object which is the result of a selector, and I want to check if that specific DOM element is in that jQuery object. Short of looping through the whole jQuery object and checking for equality, is there a straightforward way in jQuery to do this? I have tried .contains, :contains, .has an...
Hi, How do you check if an include / require_once exists before you call it, I tried putting it in an error block, but PHP didn't like that. I think file_exists() would work with some effort, however that would require the whole file path, and a relative include could not be passed into it easily. Are there any other ways? ...
I am looking for a fast sql sentence for determine when a field exist or not in a table . actually i am using this sentence Select 1 from dual where exists (select 1 from all_tab_columns where table_name = 'MYTABLE' and column_name = 'MYCOLUMN') I think there must be...
Hey all... When I run the code below, the if(property_exists(get_class($puzzleCharacters_encrypted), $solutionCharacter) keeps evaluating to false, but the echo statements preceding that are showing the correct information, so the properties are definitely there. Anything I might be missing? (PHP Version 5.2.11) $puzzle_solution = $curr...
Hi all, I'm really new to this whole web stuff, so please be nice if I missed something important to post. Short: Is there a possibility to change the name of a processed file (eXist-DB) after serialization? Here my case, the following request to my eXist-db: http://localhost:8080/exist/cocoon/db/caos/test.xml and I want after seria...