I wrote this code and it works: SELECT d1.*,d3.* FROM bdir_programmation.d_program AS d1 JOIN ( SELECT d_program.id,MAX(id_reg) AS maxv FROM bdir_programmation.d_program GROUP BY d_program.id) AS d2 ON d1.id=d2.id AND d1.id_reg=d2.maxv JOIN bdir_programmation.d_infra_progra d3 ON d1.id=d3.id; But when I want to…
I'm using React Native Expo, and I encountered an error when trying to set the size of my Viewer to fit the selection menu and number input. View Code: <View style={{ flex: 1, flexDirection: 'row', alignItems: 'center', backgroundColor: "black", width:…
I have two tables with a one-to-many relationship that looks something like this: CREATE TABLE products ( id UUID PRIMARY KEY, name TEXT ); CREATE TABLE product_variations ( id UUID PRIMARY KEY, product_id UUID REFERENCES products, attribute1 TEXT, attribute2 TEXT,…
My view displays collections from four different tables. $redtable is my longest collection. @for ($i = 0; $counter < $redtable->count(); $i++) <div> {{ $red->slice($i, 1)->first()?->content }} {{ $green->slice($i, 1)->first()?->content }} {{ $blue->slice($i, 1)->first()?->content }} {{ $gray->slice($i, 1)->first()?->content }} <div> @endfor…
return Scaffold( appBar: AppBar( // Here we take the value from the MyHomePage object that was created by // the App.build method, and use it to set our appbar title. title: Text("Se connecter"), backgroundColor: Colors.red, ), body: Center( // Center…
i saved a table in my SSMS database but its not showing even after i refresh it. any idea what should be done??
I need to find all view based on table my_table. I try query select * from information_schema.views where view_definition ilike '%my_table%' and get empty table. That means I have no view based on my_table. But after trying to delete my_table…
Alright, let me give you guys an example; We have the following url configuration in Django. Django will try to match the url with the rules down below. Once it finds a match, it will use the appropriate view and…
I'm doing my thing in my normal view blade file, but when i edit my code and save it, it doesn't update. I found out that the view cache stored in /storage/framework/views keeps interrupting. Whatever i change in my normal…
So I've been building an analytics tool in crypto that requires ingesting a few billion rows of data across a couple tables. Sales, Listings, NFTs, Metadata, Contract info, etc. I take that data and machine learn on it, outputting quite…