Search DaniWeb - db

Re: Question/Answering over SQL Data Using LangGraph Framework 3 Weeks Ago by Pelorus_1 Through its combination of natural language processing and structured query generation, LangGraph makes interfacing with databases and extracting insights over SQL data easier than ever. Re: SAP db - how to get the time update statistics was performed on a table? 2 Months Ago by peol To check when update statistics was last performed on an SAP table, use database-specific queries! For SAP HANA, check M_TABLES.LAST_COMPILED. In SQL Server, use STATS_DATE. For Oracle, check DBA_TAB_STATISTICS.LAST_ANALYZED. In DB2, use SYSCAT.TABLES.STATS_TIME. Stay optimized, stay ahead! Re: Multiple MySQL connections + transactions 1 Month Ago by Salem https://www.php.net/manual/en/mysqli.select-db.php I think the key word in all… you want, but you have to refer to each DB by it's own handle. Using `select_db` is fine…, if you only have one DB and you want to be lazy about referring to it…. So you make it the default DB. But as soon as you have more than one… Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim … you can't run a query on more than one db at a time. It seems to me that transactions are… Re: DB.php Problem 17 Years Ago by richie513 … the PHP directory:) You will have to download the DB package and install it manually as it is not reccommended… here [URL="http://pear.php.net/package/DB/download"]PEAR DB Package[/URL] You will need a program that…extracted these files, browse through them until you see the DB.php and three Other directorys. One of those Directorys … DB Design, trying to keep in sync without foreign-keys 17 Years Ago by cancausecancer …keys could help things and make updates/deletes/db consistency easier. Because innodb lacks fulltext search support…have to be dropped period because as the db grows it'll need to be to …I can get away with fkeys because the db is small but since I need to design …sure but watching for and trying to keep db consistency in the code is making me worry.… DB Schema Export/Import Help 19 Years Ago by extofer I've been working on a production DB on a POS and Inventory System for over a year. … and take the software from the main location with the DB changes and run that same software in the other locations…??? Is it possible to take just the scheme of the DB and import it to an existing… Re: db run 15 Years Ago by network18 … php in it) that is stored in the DB. and i would like to call it in a…doesnt work is the php being called from the DB. It seems like it just calls the php…something else by just uploading the code to the DB. Unless there is better way. thanks in advance[/…QUOTE] If the HTML is stored in DB, you don't have any other option except taking… DB-Authentication php/mysql on Mac OSX v3 20 Years Ago by jani … is up and running. I have created tables in my DB, established user privileges, etc through the 'terminal' app. I …files - simple scipts work. The problem is connecting to my DB and being able to execute a simple query on any… entries. Unfortunately I cannot even establish a connection to my DB, the $PHP_AUTH_USER AND _PW don't seem to do anything… Re: DB.php Problem 17 Years Ago by richie513 Is this your own DB.php file, or are you trying to use the DB PEAR extension? If it is the PEAR DB file, you need to install PEAR then download and install the DB package, but in saying that, the DB package for PEAR is now out dated and is reccommended to you use the MDB2 PEAR package. Just some available info for you:) DB design capturing mergers and acquisitions 15 Years Ago by NewJoizey … some feedback and some discussion from other DB pros about the viability of a DB design I came up with. The goal… is to create the DB back end to an application feature that keeps track of… db run 15 Years Ago by itisnot_me … template (with php in it) that is stored in the DB. and i would like to call it in a query… what doesnt work is the php being called from the DB. It seems like it just calls the php but it… to something else by just uploading the code to the DB. Unless there is better way. thanks in advance db modeling 14 Years Ago by sasha_3 … have made my ER diagram for my DB, but i want it optimized. The db should store date for something like in… of a product_id; maybe a can reduce this with some db structure concept, 'cause i could have same component in more… DB SQL creating da/ds 13 Years Ago by applebule5 …quot;) Try DataBaseCreator() Catch ex As Exception MessageBox.Show("DB Allrdy there") End Try MessageBox.Show("DONE"…;) 'Define student DA and fill the DS with DB info DA = New OleDbDataAdapter DS = New DataSet cmd = New… Re: db run 15 Years Ago by itisnot_me understand but what about running php from the DB. in my template i also have php to call the navigation and info from the DB on top of html. Re: db run 15 Years Ago by network18 [QUOTE=itisnot_me;1094884]understand but what about running php from the DB. in my template i also have php to call the navigation and info from the DB on top of html.[/QUOTE] you need to do the same for it DB issues when dropping DB and inserting test data 11 Years Ago by pezza Hi All, Having a few issues with some DB functions in my code at the moment. This code was … having previously, it seemed to introduce some issues on the DB side. As far as I can see (and my eyes… Re: DB issues when dropping DB and inserting test data 11 Years Ago by cgeier …) Dim sqlText As String = String.Empty 'switch to 'master' db and 'put db into single user mode to prevent connections, then drop… DB design for friends network 17 Years Ago by rwagner …. My problem is that I can't think of a db schema that will allow me to do this without being… decent programmer and a good UI designer, but a novice db designer at best. I could use some recommendations. Thanks. DB Design Issues 16 Years Ago by varun077 … FK constraints are not there. Should we enforce FKs on DB level? There are some concerns about adding FKs like - performance… referential integrity to not to have any orphan records in DB. One alternative is to write triggers which will enforce data… Db structure needed please 16 Years Ago by jamescumm … of a business/computing degree. If someone gave me the db structure for my final year project interim report to be… it is available. If someone could give me a rough db structure for this I would be very happy. p.s… Re: DB Connection IN c# 15 Years Ago by mahmoud_wow ….Open() [/CODE] and after you finish your work with the DB close the Connection [CODE]conn.Close()[/CODE] Or you Can… , choose Server Name, if the any userName or Password for DB set it , Choose DB Name , press Ok. Re: db run 15 Years Ago by itisnot_me ya i was thinking that is what i would have to do. even though it would be awesome if you can run some php from the DB but with some good security features Re: DB access error 14 Years Ago by boet … $_POST ['description'] . "'"; mysql_query ( $query ) or die ( "DB access error (" . mysql_error () . ")" ); header( "Location: index… $_POST ['id'] . "'"; mysql_query ( $query ) or die ( "DB access error (" . mysql_error () . ")" ); header( "Location: … DB Url databinding to Labels 14 Years Ago by wrathyimp I have a pages table with following columns: DB Table: sno name title url parentPage 1 Reports Reports [url]… define the sql command to get the url from the db table. these are my code: cs: [CODE] public String pid… DB backup and restore problems 14 Years Ago by 00100110 … started a new project wich function is restoring a corrupted DB. I started with making a backup of the original… db and then trying to restore it again. But when executing … DB design for learning english words 14 Years Ago by jayanandan I am designing my own site to learn English words. Attached is the image of my DB design. Can some one suggest/direct me to design the DB more perfectly? DB vs Code 12 Years Ago by DarkMonarch … in time) implementation. Now i've been reading alot on DB so i can implement the right database and the right…: Is it better to pre-organized the data in the DB engin (i'm using MySQL) with more complex queries or… Re: DB vs Code 12 Years Ago by DarkMonarch … can be parse in ethier the code engin or the db engin. So which one i pick for performance? i know… i don't how to put an order on a db query. i'll do a search on that. thx for… Re: DB issues when dropping DB and inserting test data 11 Years Ago by cgeier … Dim lConnectStr As String = connectStr 'attempting to connect to a db that doesn't exist, will 'throw an error. use master…