Login or Register :: Home :: Search :: Your Account :: Forums :: Waraxe Advisories :: Tools :: November 8, 2026 Menu Home Logout Discussions Forums Members List IRC chat Tools Base64 coder MD5 hash CRC32 checksum ROT13 coder SHA-1 hash URL-decoder Sql Char Encoder Affiliates y3dips ITsec Md5 Cracker User Manuals AlbumNow Content Content Sections FAQ Top Info Feedback Recommend Us Search Journal Your Account User Info Welcome, Anonymous Nickname Password (Register) Membership: Latest: MichaelSnaRe New Today: 0 New Yesterday: 0 Overall: 9144 People Online: Visitors: 114 Members: 0 Total: 114 Full disclosure SEC Consult SA-20261104-0 :: Improper device certificate validation enables AiTM attacks in Siemens SICAM Toolbox II device communication Apache Struts2 Tiles Plugin <=7.4.0 and >=6.3.0 Preparer Cache Vulnerabilities unixODBC <=2.3.14 Rude Truncation via Narrowing Conversion Causes Out-of-Bounds `memcpy` unixODBC <=2.3.14 Multiple Races unixODBC <=2.3.14 Multiple Heap Buffer Overflows, Underflows, and Over-Reads Apache Struts2 Core Arbitrary Code Execution via OGNL SandboxEscape Apache Struts2 Core TokenHelper Token Cryptographic Timing Side-Channel Apache Struts2 Spring Plugin Uses a Previously Closed Resource Apache Struts2 Core Integer Overflow Apache Struts2 Core Cross-Origin Protection Exemption Miskeyed to a Deployment-Wide Path Apache Struts2 REST Plugin Fails to Properly Parse ChunkedRequests Apache Struts2 REST Plugin Untrimmed `Accept` Header Tokens Break Content Negation Fallback Apache Struts2 JSON Plugin Insecure Deserialisation -- Object Deserialisation Element-Count Limit Bypass [0day-rubbish] NETGEAR RAX120 V1.2.5.18 authenticated SOAP InstallApp OS command injection to root-configured web-stack execution (6.8 Medium; conditionally 7.2 High with management exposure) [0day-rubbish] Raritan PX3 PDU G4 firmware 4.3.14 command injection in the ping and traceroute diagnostics through an inverted hostname-validation return check (8.8) IT Security and Insecurity Portal www.waraxe.us Forum Index -> MySql -> Search on several tables in SQL View previous topic :: View next topic Search on several tables in SQL Posted: Mon Sep 15, 2008 10:47 am str0xo Beginner Joined: Sep 15, 2008 Posts: 3 Good morning, I have a problem and I am currently blocked the above, I hope any help , my problem is as follows: I must write PL / SQL, requette SQL which makes a search (a search engine) on several tables (at least 8 => several joints) on fields that can be NULL, empty, full ... I do not recover as the list of id of the table (ROOT), this is how I have done, but it did not work Quote: SELECT tableRoot.Id FROM table_root tableRoot, table_fille1 fille1, table_fille2 fille2, table_fille3 fille3, table_fille4 fille4, ... WHERE tableRoot.champRoot1 LIKE '%i__var1%' AND tableRoot.champRoot2 = i__var2 AND tableRoot.champRoot3 = i__var3 AND fille1.champfille1_1 = i__var4 AND fille1.champfille1_2 = i__var5 AND fille2.champfille2 LIKE '%i__var6 %' AND fille3.champfille3 LIKE '%i__var7 %' AND fille4.champfille4_1 LIKE '%i__var8 %' AND fille4.champfille4_2 LIKE '%i__var9 %' AND ... -- Inner joins fille1.id = tableRoot.fk_id_1 AND fille2.id = tableRoot.fk_id_2 AND fille3.id = tableRoot.fk_id_3 AND fille4.id = tableRoot.fk_id_4 ...; thank's Posted: Mon Sep 15, 2008 10:56 am nuckel Active user Joined: Mar 25, 2008 Posts: 28 Good morning can you give a little more detail? what does not? a small example can be reduced to a child table to show us what you really want and what you problem? Thanks Posted: Mon Sep 15, 2008 11:02 am str0xo Beginner Joined: Sep 15, 2008 Posts: 3 hi Thank's for your response Already the first question that arises: Is what I'm on the right path, is this the way forward? y'aurais no problems fall performance, if information does not exist at a table which has been doing a join, it will not affect the requette short, you see problems in this method? Posted: Mon Sep 15, 2008 11:08 am nuckel Active user Joined: Mar 25, 2008 Posts: 28 hi, Already performance level will require that you use indexes According without more information, it is difficult to say any more worry. Posted: Mon Sep 15, 2008 11:16 am dzH Regular user Joined: Mar 15, 2008 Posts: 17 nuckel wrote: hi, Already performance level will require that you use indexes According without more information, it is difficult to say any more worry. Indexes with like '%...', no interest!!!! Posted: Fri Sep 19, 2008 12:34 pm 0xbadfaceX Regular user Joined: Aug 01, 2008 Posts: 12 Location: .bashrc$> str0xo wrote: hi Thank's for your response Already the first question that arises: Is what I'm on the right path, is this the way forward? y'aurais no problems fall performance, if information does not exist at a table which has been doing a join, it will not affect the requette short, you see problems in this method? look at : y'aurais . . . french??? if you want to send a translated text to someone or use it for your correspondence, explain that you always use a translator ... because there, you writing as the noobs i can not understand what you talked about because your language is very bad and i think that "str0xo", "Nuckel", "dzH" are the same person by different nickname, the IP used. . see u . . _________________ , Search on several tables in SQL www.waraxe.us Forum Index -> MySql You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum All times are GMT Page 1 of 1 All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First Select a forumSecurity Research by waraxe----------------General discussionHow to fixMetasploit relatedHash cracking requests----------------MD5 hashesAll other hashesHash related informationhttp://www.waraxe.us portal----------------SuggestionsCooperation proposalsSecurity bugs and issues in general----------------Newbies cornerSql injectionCross-site scripting aka XSSRemote file inclusionFull path disclosureShell commands injectionPhishing and Social EngineeringAll other security holesVarious software----------------PhpNukePostNukePhpBBXMB forumvBulletin BoardInvision Power Boarde107MamboJoomlaXOOPSM$ WindowsLinux worldAll other softwareCoppermine Photo GalleryProgramming languages----------------PhpMySqlPerlJavaJavascriptC and C++Visual BasicBorland Delphi and PascalPythonHTML and XMLAssemblerReverse engineering----------------Newbies cornerDisassemblingPHP script decode requestsMiscellaneous stuff----------------Future of the ITNanotechnologyFun cornerLinksTry2hack sitesProxy databaseDirect Downloads----------------ToolsTutorialsWordlistsRecycle Bin----------------Removed messagesOutdated posts Powered by phpBB © 2001-2008 phpBB Group

PCWizardHub - Helping you fix, build, and optimize your PC life
All logos and trademarks in this site are property of their respective owner. The comments and posts are property of their posters, all the rest (c) 2004-2024 Janek Vind "waraxe"
Page Generation: 0.038 Seconds