Search DaniWeb - relations

Re: Laravel Ardent, relations not showing 10 Years Ago by klemme … protected 'original' => array (size=0) ... protected 'relations' => array (size=0) ... protected 'hidden' =>…original' => array (size=0) empty protected 'relations' => array (size=0) empty protected '… PhpMyAdmin relations view question 14 Years Ago by 54uydf … lines between them that mark the relations (like in sqlServer or Access) I defined the relations between the tables using the Relation… Laravel Ardent, relations not showing 10 Years Ago by klemme … I can query just fine - But when I define my relations, I get a white screen when I try to dump… the expected data. I have double checked and the data + relations are set up just as they should in the DB… Database Explorer / manage relations 16 Years Ago by Bill Purkins … in the database itself? I see no way to manage relations using database explorer. Thanks, Bill P. How do i use relations between tables in the db in my navigation? 14 Years Ago by klemme Looking for an answer about how I can use relations in my DB, when a link is clicked. I have … Table relations in MySQL 14 Years Ago by xero771 … told me to use php to fill everything because table relations are slow... I am really confused about MySQL i don… equivalence relations 13 Years Ago by rihanareeza … algorithm [ICODE] function equivalence(m,n) //n variables,m equivalence relations //bit is a boolean array //seq is an array of… Help with creating relations in diagram 12 Years Ago by bombay1982 ….com/photos/94148478@N06/8564131847/) Im having problem with creation relations. I know it should be one-to-many relation but… relations diagram 17 Years Ago by Janulka I use MS Sql Manager 2008. I need to extract some diagrams from my database. I tried to use reverse engineering in Visio but there is some problem with compatibility Visio drivers with my DB. Have any idea how to set up this and get the diagram(s)? Anyway I found an easy way how to design diagram in MS Sql Manager directly. But it offers the … Re: relations diagram 17 Years Ago by peter_budo Vector format, what you trying to do with them? Re: relations diagram 17 Years Ago by Janulka [QUOTE=peter_budo;617010]Vector format, what you trying to do with them?[/QUOTE] just put it into the .pdf file Re: relations diagram 17 Years Ago by peter_budo You can do that with bmp format no problem at all Re: relations diagram 17 Years Ago by peter_budo Few more things I just tried [LIST=1] [*]In Managment Studio open diagram, right click on diagram and select "Copy to Clipboard", fire up your favourite image editing tool and past it there. Save in any format you wish. [*]Use PrintScr on your keyboard to take screenshot of the diagram, open image editing software save in any format … relations between data structures and computational methods and statistics. 15 Years Ago by MyRedz i was wondering. of all the data structures like list linked list,stack,queues,graph of bfs and dfs. hashing,sorting,searching,arrays...heaps, can anyone of them be solved using computational methods and statistic like linear regression,quadratic regression,trapezoidal rule,simpson's rule..which is to improve accuracy of integral.. just … Re: relations between data structures and computational methods and statistics. 15 Years Ago by tetron Your question highlights some gaps in your understanding in the statistics area. As phrased at the moment the answer is no it is not possible but perhaps you could be clearer. The data structure just contain data and are mathematically approximately just vectors [QUOTE=MyRedz;1158268] i was wondering. of all the data structures like list … Re: PhpMyAdmin relations view question 14 Years Ago by 54uydf still haven't worked it out and need help with this ASAP! in case I wasn't clear before, I want to see something like this [url]http://tjetjeprb.files.wordpress.com/2009/02/phpmyadmin-designer.png?w=512&h=301[/url] what I see now is only the tables without the lines connecting them!! pls pls pls help! I need it!! Re: Laravel Ardent, relations not showing 10 Years Ago by diafol Haven't used Ardent - still blundering away with Eloquent. However, are the relationships right? In Eloquent the relationships are: hasOne/belongsTo or hasMany/belongsTo or belongsToMany/belongsToMany - there are other more complicated ones. I haven't seen hasOne/hasMany. Re: Laravel Ardent, relations not showing 10 Years Ago by klemme If I do this: var_dump( menu::find(1)->take(1)->toSql() ); The produced SQL is: string 'select * from `generator_menus` limit 1' (length=39) Shouldnt I get a where clause in this query too? ::find(1) Im using Eloquent outside Laravel, for info. Re: Laravel Ardent, relations not showing 10 Years Ago by diafol I tried your code on my models, but I didn't get the where clause either. The `toSql()` method isn't available on just the `model::find(x)` The records were found and limited though - so seem to work. Hmmm looks ok, can't see an issue - but "relationships" is one aspect of Eloquent that I hate. Not intuitive and it gives me a nosebleed.… Re: Laravel Ardent, relations not showing 10 Years Ago by klemme Hmm thanks for testing. Its a really simple relationship, and I cant see anything wrong with it either, nor the table structure. Any ideas on a tool/way to debug this? The nosebleed has arrived here too ;-) Re: Laravel Ardent, relations not showing 10 Years Ago by diafol Not that I know of. The laravel debug interface is a pig. At least native php tells you where in your own code you've gone wrong, but references to some core file at line 10000 is absolutely no help. I would imagine that to retrieve your data it would be like this... **CONTROLLER (e.g. MenuController)** public function someMethod($id) … Re: How do i use relations between tables in the db in my navigation? 14 Years Ago by madCoder [CODE=sql] SELECT * FROM pages WHERE subjectid = '{$sid}' AND showing='1' ORDER BY pos ASC [/CODE] That will let you filter for just pages keyed to a supplied subject where $sid is the subject id. Re: How do i use relations between tables in the db in my navigation? 14 Years Ago by klemme Thanks! Can you perhaps also see how I can change the code below so the page navigation doesnt dissapear after it is clicked. Having some massive problems figuering this out :-/ [CODE] if (isset($_GET['sid'])) { $subjectid = ($_GET['sid']); $pageid = NULL; $subjectid = preg_replace("[^0-9]", "", $_GET['sid']); // filter … Re: How do i use relations between tables in the db in my navigation? 14 Years Ago by madCoder [QUOTE]What happens now is that a page is only set, after a subject is set. So after i click a page, then the subject is unset, meaning the pages are gone..[/QUOTE] Umm, then don't do that. You can use the ternary operator when initializing the variables instead of setting them to null. You should also, of course always pass the settings needed … Re: Table relations in MySQL 14 Years Ago by smantscheff JOIN is a part of a clause for querying related tables, not for design. You are on the right track. Use foreign keys wherever possible to enhance database integrity. No, they don't harm the performance except with large insert or update operations. But unless you have millions of users you won't notice any difference. When learning mysql make use … Re: equivalence relations 13 Years Ago by Taywin It is your homework. Who would know better than you do about what you are talking about this somewhat pseudo code? Also, there are many unknown variables in the code... 1)Is "seq" a global variable? Because it just pops up in the function without declaration. 2)Where does "x" come from? All the sudden it is being used in … Re: Help with creating relations in diagram 12 Years Ago by pritaeas None of your images show a diagram, just a table layout. It's hard to guess how far you want to take this, but I'd suggest never to create columns named "artist1_ID, artist2_ID, artist3_ID, artist4_ID". This indicates that you need an intermediate table, because what do you do when you need more than four artists. I'd suggest you start … Re: Help with creating relations in diagram 12 Years Ago by bombay1982 Thanks a lot of the quick review. It will help me a lot. Re: Help with creating relations in diagram 12 Years Ago by bombay1982 Why did you use 2 foreign keys in movies_actors table ? Re: incompatible types 12 Years Ago by scudzilla `relations[]` is an array of double. `relations[i]` is just a double, not an array of double. It is, of course, not compatible to `double[8]` which is an array of double.